| Table Name: | MPEKVertraegeBelegeILVKopf |
| View Name: | MARIPurchaseProcessDocumentISCHead |
| Group: | Group: MPEKVertraegeBelege |
| Description: | Purchase Process: Document Internal Service Change Head |
| Field | View(engl.field)/Type | Description | Related |
|---|---|---|---|
| ILVBelegID | ISCDocumentID INT Primary |
||
| MPBelID | MARIDocID INT Index |
MPEKVertraegeBelege.MPBelID | |
| ILVBelegTyp | ISCDocumentType INT Index |
Journal or Document | |
| Belegart | DocumentTypeText NVARCHAR (50) |
||
| Stapel | Batch INT |
||
| ERPStatus | ERPStatus INT |
||
| ERPDocType | ERPDocType INT |
||
| ERPDocNum | ERPDocNum INT |
||
| ERPDocSeries | ERPDocSeries INT |
||
| ERPDocEntry | ERPDocEntry INT |
||
| ERPDeferrTax | ERPDeferrTax SMALLINT (0=false,-1=true) |
||
| ERPVatFirst | ERPVatFirst SMALLINT (0=false,-1=true) |
||
| ERPPaymentRef | ERPPaymentRef NVARCHAR (27) |
||
| ERPUebergabedatum | ERPTransferDate Datetime |
||
| ERPUebergabeUser | ERPTransferUser NVARCHAR (4) |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) | |
| ERPTan | ERPTransactionID INT |
||
| ERPErrorCode | ERPErrorCode INT Index |
||
| ERPErrorText | ERPErrorText NTEXT |
||
| ERPBPLId | ERPBPLId INT |
OINF.BPLId | |
| PTICode | PTICode NVARCHAR (5) |
Localization Argentina | OPOR.PTICode |
| Letter | Letter NVARCHAR (1) |
Localization Argentina | OPOR.Letter |
| FolNumFrom | FolNumFrom INT |
Localization Argentina | OPOR.FolNumFrom |
| FolNumTo | FolNumTo INT |
Localization Argentina | OPOR.FolNumTo |
| FolSeries | FolSeries INT |
Localization Argentina | OPOR.FolSeries |
| Indicator | Indicator NVARCHAR (2) |
Localization Argentina SELECT * FROM OIDC | OPOR.Indicator |
| ImportEnt | ImportEnt INT |
Localization Argentina | OPOR.ImportEnt |
| FiscDocNum | FiscDocNum NVARCHAR (100) |
Localization Poland | OPOR.FiscDocNum |
| Geschaeftspartner | BusinessPartner NVARCHAR (20) |
OCRD.CardCode | |
| Mandant | Company SMALLINT Index |
MPSysConnections.CompanyID (WHERE ConnectionType=6) | |
| OPNr | OpenItemNumber NVARCHAR (20) |
||
| Belegdatum | DocDate Datetime |
||
| Faelligkeit | DueDate Datetime |
||
| Periode | Period INT |
MPPerioden.PeriodeJahr | |
| NettoSys | NetSysCur NUMERIC(19,6) |
||
| NettoMA | NetCompCur NUMERIC(19,6) |
||
| NettoFW | NetFC NUMERIC(19,6) |
||
| BruttoSys | GrossSysCur NUMERIC(19,6) |
||
| BruttoMA | GrossCompCur NUMERIC(19,6) |
||
| BruttoFW | GrossFC NUMERIC(19,6) |
||
| SteuerSys | TaxSysCur NUMERIC(19,6) |
||
| SteuerMA | TaxCompCur NUMERIC(19,6) |
||
| SteuerFW | TaxFC NUMERIC(19,6) |
||
| WKZSys | CurrencySys NVARCHAR (3) |
||
| WKZMa | CurrencyCompany NVARCHAR (3) |
||
| WKZBeleg | CurrencyForeign NVARCHAR (3) |
||
| WkzMaKurs | ExchangeRateCompany Float |
||
| WKzKursFw | ExchangeRateFC2Sys Float |
||
| A0AdressNr | A0AddressNr INT |
||
| A0Empfaenger | A0CardCode NVARCHAR (20) |
OCRD.CardCode | |
| A0Anrede | A0Salutation NVARCHAR (50) |
||
| A0Name1 | A0Name1 NVARCHAR (100) |
||
| A0Name2 | A0Name2 NVARCHAR (50) |
||
| A0Zusatz | A0Name3 NVARCHAR (50) |
||
| A0Einmalkunde | A0SingleCustomer SMALLINT |
||
| A0Matchcode | A0Matchcode NVARCHAR (100) |
||
| A0Strasse | A0Street NVARCHAR (100) |
||
| A0Hausnummer | A0StreetNumber NVARCHAR (100) |
||
| A0Land | A0Country NVARCHAR (3) |
||
| A0PLZ | A0ZIP NVARCHAR (20) |
||
| A0Ort | A0City NVARCHAR (100) |
||
| A0Bezirk | A0County NVARCHAR (100) |
||
| A0Bundesland | A0State NVARCHAR (3) |
||
| A0Gebaeude | A0Block NVARCHAR (100) |
||
| A0AnsprechpartnerID | A0ContactPerson INT |
OCPR.CntctCode | |
| A0AdressName | A0AddressName1 NVARCHAR (50) |
||
| A0AdressName2 | A0AddressName2 NVARCHAR (50) |
||
| A0AdressName3 | A0AddressName3 NVARCHAR (50) |
||
| A0GebaeudeStockwerk | A0Building NTEXT |
||
| A0AdressMemo | A0AddressMemo NTEXT |
||
| A0CardFName | A0CardFName NVARCHAR (100) |
||
| A0AddrType | A0AddrType NVARCHAR (100) |
||
| A0AdressLineNum | A0AddressLineNum INT |
||
| A0GlbLocNum | A0GlbLocNum NVARCHAR (50) |
||
| A0Longitude | A0Longitude Float |
||
| A0Latitude | A0Latitude Float |
||
| A1AdressNr | A1AddressNr INT |
||
| A1Empfaenger | A1CardCode NVARCHAR (20) |
OCRD.CardCode | |
| A1Anrede | A1Salutation NVARCHAR (50) |
||
| A1Name1 | A1Name1 NVARCHAR (100) |
||
| A1Name2 | A1Name2 NVARCHAR (50) |
||
| A1Zusatz | A1Name3 NVARCHAR (50) |
||
| A1Einmalkunde | A1SignleCustomer SMALLINT |
||
| A1Matchcode | A1Matchcode NVARCHAR (100) |
||
| A1Strasse | A1Street NVARCHAR (100) |
||
| A1Hausnummer | A1StreetNum NVARCHAR (100) |
||
| A1Land | A1Country NVARCHAR (3) |
||
| A1PLZ | A1ZIP NVARCHAR (20) |
||
| A1Ort | A1City NVARCHAR (100) |
||
| A1Bezirk | A1County NVARCHAR (100) |
||
| A1Bundesland | A1State NVARCHAR (3) |
||
| A1Gebaeude | A1Block NVARCHAR (100) |
||
| A1AnsprechpartnerID | A1ContactPerson INT |
OCPR.CntctCode | |
| A1AdressName | A1AddressName1 NVARCHAR (50) |
||
| A1AdressName2 | A1AddressName2 NVARCHAR (50) |
||
| A1AdressName3 | A1AddressName3 NVARCHAR (50) |
||
| A1GebaeudeStockwerk | A1Building NTEXT |
||
| A1AdressMemo | A1AddressMemo NTEXT |
||
| A1CardFName | A1CardFName NVARCHAR (100) |
||
| A1AddrType | A1AddrType NVARCHAR (100) |
||
| A1AdressLineNum | A1AddressLineNum INT |
||
| A1GlbLocNum | A1GlbLocNum NVARCHAR (50) |
||
| A1Longitude | A1Longitude Float |
||
| A1Latitude | A1Latitude Float |
||
| A0EMailAnsprechpartner | A0EMailContactPerson INT |
||
| A1EMailAnsprechpartner | A1EMailContactPerson INT |
||
| ILVBelegIDNachfolger | ISCDocumentIDFollowing INT |
||
| ILVBelegIDVorgaenger | ISCDocumentIDPrevious INT |
||
| LocationID | LocationID INT Index |
||
| CIG_Code | CIG_Code INT |
||
| CUP_Code | CUP_Code INT Index |
||
| Erstanlage | CreateDate Datetime |
||
| ErstanlageID | CreateUser NVARCHAR (4) |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) | |
| Aenderung | ChangeDate Datetime |
||
| AenderungID | ChangeUser NVARCHAR (4) |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) | |
| UpdateStamp | UpdateStamp INT |