| Table Name: | MPEKFremdBelegErfassung |
| View Name: | MARIPurchaseImportDocument |
| Group: | |
| Description: | Purchase Order: Import external documents (Header) |
| Field | View(engl.field)/Type | Description | Related |
|---|---|---|---|
| FremdBelegID | ImportDocID INT Primary |
||
| FremdBelegTyp | ImportDocType INT |
||
| Lieferant | Supplier NVARCHAR (20) |
OCRD.CardCode | |
| Mandant | Company INT |
MPSysConnections.CompanyID (WHERE ConnectionType=6) | |
| Periode | Period INT |
MPPerioden.PeriodeJahr | |
| FremdBelegNummer | ExternalDocumentNumber NVARCHAR (50) Index |
||
| Belegdatum | DocDate Datetime |
||
| Faelligkeit | DueDate Datetime |
||
| Erfassungsdatum | EntryDate Datetime |
||
| Referenznummer | ReferenceNumber NVARCHAR (40) Index |
||
| Referenzzeichen | ReferenceSign NVARCHAR (20) Index |
||
| Beschreibung | Description NVARCHAR (255) |
||
| ERPBelegID | ERPDocID INT Index |
||
| BelegErstellungsDatum | DocumentCreationDate Datetime |
||
| ERPFiBuTAN | EPRJournalEntry INT |
||
| FiBuErstellungsDatum | ERPTransferDate Datetime |
||
| Erstanlage | CreateDate Datetime |
||
| Aenderung | ChangeDate Datetime |
||
| AenderungID | ChangeUser NVARCHAR (4) |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) | |
| Memo | Memo NTEXT |
||
| UpdateStamp | UpdateStamp INT |
| Table | Description |
|---|---|
| MPEKFremdBelegErfassungPos | Purchase Order: Import external documents (Line) |