| View Name: | MARIJournalEntryExport |
| Based on table: | MPFiBuPositionen |
| Group: | Group: JournalEntryExport |
| Description: | Journal Entries Export (Travel Expenses, Internal Service Charges, Work in Progress) |
| ClassID: | 296. See Overview of ClassIDs by table. |
| Field | Table(Germ.field)/Type | Description | Related |
|---|---|---|---|
| TransID | TAN INT Primary |
||
| LineNumber | BuchungsNr SMALLINT Primary |
||
| LineType | Typ INT Primary |
||
| Company | Mandant SMALLINT Index |
MARISysConnections.Company (WHERE ConnectionType=6) | |
| Period | Periode INT Index |
MARIPeriods.Period | |
| Batch | Stapel INT |
MARIJournalEntryExportBatch.Batch | |
| EntryType | BuchungsTyp SMALLINT |
||
| SourceType | HerkunftsTyp INT |
||
| SourceTypeDetail | HerkunftsTypDetail INT |
||
| DistributionType | VerrechnungsTyp SMALLINT |
||
| DocumentType | ERPBelegtyp INT |
||
| ERPTransID | KHKTan INT |
Link to journal entry | OJDT.TransID |
| ERPSession | KHKSitzung INT |
Line of OJDT | |
| BookingAttributes | OLBuchungsAttribut INT |
Setting for Cost Accounting as flags | |
| PostingDate | Buchungsdatum Datetime |
||
| ValueDate | Valutadatum Datetime |
||
| DueDate | Faelligkeit Datetime |
||
| Account | Kto NVARCHAR (20) |
||
| AccountType | KtoTyp TINYINT |
MARISettingTypes.AccountType (WHERE TypTyp=188) | |
| ContraAccount | Gegenkto NVARCHAR (20) |
||
| ContraAccountType | GegenktoTyp TINYINT |
MARISettingTypes.ContraAccountType (WHERE TypTyp=188) | |
| DocDate | Belegdatum Datetime |
||
| DocumentNumber | Belegnummer NVARCHAR (100) Index |
||
| DocumentNumber2 | Belegnummer2 NVARCHAR (100) |
||
| DocumentNumber3 | Belegnummer3 NVARCHAR (100) |
||
| Currency | WKZ NVARCHAR (3) |
ISO Currency Code | |
| CurrencySys | WKZSys NVARCHAR (3) |
||
| CurrencyFC | WKZFW NVARCHAR (3) |
||
| TotalDebit | Sollumsatz NUMERIC(19,6) |
||
| TotalDebitSys | SollumsatzSys NUMERIC(19,6) |
||
| TotalDebitForeignCurr | SollumsatzFW NUMERIC(19,6) |
||
| TotalDebitNet | SollumsatzNetto NUMERIC(19,6) |
||
| TotalDebitNetSys | SollumsatzNettoSys NUMERIC(19,6) |
||
| TotalDebitNetForeignCurr | SollumsatzNettoFW NUMERIC(19,6) |
||
| TaxDebit | SollumsatzSteuer NUMERIC(19,6) |
||
| TaxDebitSys | SollumsatzSteuerSys NUMERIC(19,6) |
||
| TaxDebitForeignCurr | SollumsatzSteuerFW NUMERIC(19,6) |
||
| ExchangeRateFC2Sys | WKzKursFw Float |
||
| ExchangeRateSys | WkzKursSys Float |
||
| ProfitCenter | KstStelle NVARCHAR (20) |
OPRC.PrcCode (WHERE [DimCode]=1) | |
| OcrCode2 | OcrCode2 NVARCHAR (20) |
OOCR.OcrCode (WHERE [DimCode]=2) | |
| OcrCode3 | OcrCode3 NVARCHAR (20) |
OOCR.OcrCode (WHERE [DimCode]=3) | |
| OcrCode4 | OcrCode4 NVARCHAR (20) |
OOCR.OcrCode (WHERE [DimCode]=4) | |
| OcrCode5 | OcrCode5 NVARCHAR (20) |
OOCR.OcrCode (WHERE [DimCode]=5) | |
| ProjectCode | KstTraeger NVARCHAR (20) |
OPRJ.PrjCode | |
| BPLId | BPLId INT |
Branch ID | OINF.BPLId |
| JournalRemark | Buchungstext NVARCHAR (254) |
Journal Remark JDT1 | |
| JournalHeadText | BuchungsKopfText NVARCHAR (254) |
Journal Remark OJDT | OJDT.Memo |
| OINumber | OpNummer NVARCHAR (20) Index |
Open Item Number for BP Bookings | |
| TaxType | Steuerart NVARCHAR (2) |
Interal Code of the tax type | |
| TaxCode | Steuercode NVARCHAR (10) |
Tax code (MARI Mapping or OSTA Code) | |
| Quantity | Menge NUMERIC(19,6) |
||
| UnitPrice | Einzelwert NUMERIC(19,6) |
||
| UnitPriceFC | EinzelwertFW NUMERIC(19,6) |
||
| UoM | Einheit NVARCHAR (20) |
||
| GroupId | GruppenKennung NVARCHAR (50) |
||
| ISCDocumentMode | ILVBelegMode INT |
||
| ISCDocumentID | ILVBelegID INT |
MARIContractDocumentISCHead.ISCDocumentID | |
| ISCPositionID | ILVBelegPosID INT |
MARIContractDocumentISCPos.ISCPositionID | |
| CreateDate | Erstanlage Datetime |
||
| CreateUser | ErstanlageID NVARCHAR (4) |
MARIUser.CreateUser (WHERE BenutzerTyp=1) | |
| ChangeDate | Aenderung Datetime |
||
| ChangeUser | AenderungID NVARCHAR (4) |
MARIUser.ChangeUser (WHERE BenutzerTyp=1) | |
| UpdateStamp | UpdateStamp INT |
| Table | Description |
|---|---|
| MARIPurchaseProcessDocumentPositions | Purchase Process: Purchase Document (Positions) |
| MARIWorkInProgress | Work In Progress: Header (one line per project and month) |
| MARIProjectItemBooking | Time Keeping: ProjectTimeKeepingItems: For items used in a project each entry is stored in this table. This table is also linked to the header: MPProjectBuchungskopf |
| MARIProjectBookingErrors | Time Keeping: Error log in the time keeping |
| MARIProjectTimeKeepingLines | Time Keeping: ProjectTimeKeepingLines: One line per entry of an employee used for each project type |
| MARIContractDocumentPositions | Contract Management: Document Positions |
| MARICommissionAccrual | Commission: Stores the Accrual on Sales Invoicing Time (Project related) |
| MARICommissionAccrualSBO | Commission: Stores the Accrual on Sales Invoicing Time (None Project related) |
| MARICommissionDocuments | Commission: Sales Rep A/P Invoice Link |
| MARICommissionAccrualPeriods | Commission: Monthly values for employee commission |
| MARIProjectWorkPackageEntry | Work Packages progress reporting by day |