| View Name: | MARIJournalEntryExportDocument |
| Based on table: | MPFibuPositionenBeleg |
| Group: | Group: JournalEntryExport |
| Description: | Journal Entries Export Document Head |
| Field | Table(Germ.field)/Type | Description | Related |
|---|---|---|---|
| ISCDocumentID | ILVBelegID INT Primary |
||
| ILVDocumentType | ILVBelegart SMALLINT |
||
| ILVDocumentNumber | ILVBelegnummer INT |
||
| SourceType | HerkunftsTyp INT |
||
| DocDate | Belegdatum Datetime |
||
| PostingDate | Buchungsdatum Datetime |
||
| Company1 | Mandant1 SMALLINT |
MARISysConnections.Company1 (WHERE ConnectionType=6) | |
| Company2 | Mandant2 SMALLINT |
MARISysConnections.Company2 (WHERE ConnectionType=6) | |
| BusinessUnit1 | Geschaeftsbereich1 INT |
MARIBusinessUnitMaster.BusinessUnit1 | |
| BusinessUnit2 | Geschaeftsbereich2 INT |
MARIBusinessUnitMaster.BusinessUnit2 | |
| Customer | Kunde NVARCHAR (20) |
OCRD.CardCode | |
| Supplier | Lieferant NVARCHAR (20) |
OCRD.CardCode | |
| Period | Periode INT |
MARIPeriods.Period | |
| Batch | Stapel INT |
MARIJournalEntryExportBatch.Batch | |
| Canceled | Storniert SMALLINT (0=false,-1=true) |
||
| 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 |