| View Name: | MARIJournalEntryExportCancel |
| Based on table: | MPFiBuPositionenStorno |
| Group: | Group: JournalEntryExport |
| Description: | Journal Entries Canceled Records (Travel Expenses, Internal Service Charges, Work in Progress) |
| 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 |
OJDT.TransID | |
| ERPSession | KHKSitzung INT |
||
| BookingAttributes | OLBuchungsAttribut INT |
||
| 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 |
OINF.BPLId | |
| JournalRemark | Buchungstext NVARCHAR (254) |
||
| JournalHeadText | BuchungsKopfText NVARCHAR (254) |
||
| OINumber | OpNummer NVARCHAR (20) Index |
||
| TaxType | Steuerart NVARCHAR (2) |
||
| TaxCode | Steuercode NVARCHAR (10) |
||
| 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 | |
| CancelBatch | StornoStapel INT |
||
| CancelERPTransID | StornoKHKTan INT |
||
| CancelERPSession | StornoKHKSitzung INT |
||
| CancelISCDocumentMode | StornoILVBelegMode INT |
||
| CancelISCDocumentID | StornoILVBelegID INT Index |
||
| CancelISCPositionID | StornoILVBelegPosID INT Index |
||
| 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 |