| View Name: | MARIPurchaseProcessDocumentISCHead |
| Based on table: | MPEKVertraegeBelegeILVKopf |
| Group: | Group: MPEKVertraegeBelege |
| Description: | Purchase Process: Document Internal Service Change Head |
| Field | Table(Germ.field)/Type | Description | Related |
|---|---|---|---|
| ISCDocumentID | ILVBelegID INT Primary |
||
| MARIDocID | MPBelID INT Index |
MARIPurchaseProcessDocument.MARIDocID | |
| ISCDocumentType | ILVBelegTyp INT Index |
Journal or Document | |
| DocumentTypeText | Belegart NVARCHAR (50) |
||
| Batch | Stapel 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) |
||
| ERPTransferDate | ERPUebergabedatum Datetime |
||
| ERPTransferUser | ERPUebergabeUser NVARCHAR (4) |
MARIUser.ERPTransferUser (WHERE BenutzerTyp=1) | |
| ERPTransactionID | ERPTan 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 |
| BusinessPartner | Geschaeftspartner NVARCHAR (20) |
OCRD.CardCode | |
| Company | Mandant SMALLINT Index |
MARISysConnections.Company (WHERE ConnectionType=6) | |
| OpenItemNumber | OPNr NVARCHAR (20) |
||
| DocDate | Belegdatum Datetime |
||
| DueDate | Faelligkeit Datetime |
||
| Period | Periode INT |
MARIPeriods.Period | |
| NetSysCur | NettoSys NUMERIC(19,6) |
||
| NetCompCur | NettoMA NUMERIC(19,6) |
||
| NetFC | NettoFW NUMERIC(19,6) |
||
| GrossSysCur | BruttoSys NUMERIC(19,6) |
||
| GrossCompCur | BruttoMA NUMERIC(19,6) |
||
| GrossFC | BruttoFW NUMERIC(19,6) |
||
| TaxSysCur | SteuerSys NUMERIC(19,6) |
||
| TaxCompCur | SteuerMA NUMERIC(19,6) |
||
| TaxFC | SteuerFW NUMERIC(19,6) |
||
| CurrencySys | WKZSys NVARCHAR (3) |
||
| CurrencyCompany | WKZMa NVARCHAR (3) |
||
| CurrencyForeign | WKZBeleg NVARCHAR (3) |
||
| ExchangeRateCompany | WkzMaKurs Float |
||
| ExchangeRateFC2Sys | WKzKursFw Float |
||
| A0AddressNr | A0AdressNr INT |
||
| A0CardCode | A0Empfaenger NVARCHAR (20) |
OCRD.CardCode | |
| A0Salutation | A0Anrede NVARCHAR (50) |
||
| A0Name1 | A0Name1 NVARCHAR (100) |
||
| A0Name2 | A0Name2 NVARCHAR (50) |
||
| A0Name3 | A0Zusatz NVARCHAR (50) |
||
| A0SingleCustomer | A0Einmalkunde SMALLINT |
||
| A0Matchcode | A0Matchcode NVARCHAR (100) |
||
| A0Street | A0Strasse NVARCHAR (100) |
||
| A0StreetNumber | A0Hausnummer NVARCHAR (100) |
||
| A0Country | A0Land NVARCHAR (3) |
||
| A0ZIP | A0PLZ NVARCHAR (20) |
||
| A0City | A0Ort NVARCHAR (100) |
||
| A0County | A0Bezirk NVARCHAR (100) |
||
| A0State | A0Bundesland NVARCHAR (3) |
||
| A0Block | A0Gebaeude NVARCHAR (100) |
||
| A0ContactPerson | A0AnsprechpartnerID INT |
OCPR.CntctCode | |
| A0AddressName1 | A0AdressName NVARCHAR (50) |
||
| A0AddressName2 | A0AdressName2 NVARCHAR (50) |
||
| A0AddressName3 | A0AdressName3 NVARCHAR (50) |
||
| A0Building | A0GebaeudeStockwerk NTEXT |
||
| A0AddressMemo | A0AdressMemo NTEXT |
||
| A0CardFName | A0CardFName NVARCHAR (100) |
||
| A0AddrType | A0AddrType NVARCHAR (100) |
||
| A0AddressLineNum | A0AdressLineNum INT |
||
| A0GlbLocNum | A0GlbLocNum NVARCHAR (50) |
||
| A0Longitude | A0Longitude Float |
||
| A0Latitude | A0Latitude Float |
||
| A1AddressNr | A1AdressNr INT |
||
| A1CardCode | A1Empfaenger NVARCHAR (20) |
OCRD.CardCode | |
| A1Salutation | A1Anrede NVARCHAR (50) |
||
| A1Name1 | A1Name1 NVARCHAR (100) |
||
| A1Name2 | A1Name2 NVARCHAR (50) |
||
| A1Name3 | A1Zusatz NVARCHAR (50) |
||
| A1SignleCustomer | A1Einmalkunde SMALLINT |
||
| A1Matchcode | A1Matchcode NVARCHAR (100) |
||
| A1Street | A1Strasse NVARCHAR (100) |
||
| A1StreetNum | A1Hausnummer NVARCHAR (100) |
||
| A1Country | A1Land NVARCHAR (3) |
||
| A1ZIP | A1PLZ NVARCHAR (20) |
||
| A1City | A1Ort NVARCHAR (100) |
||
| A1County | A1Bezirk NVARCHAR (100) |
||
| A1State | A1Bundesland NVARCHAR (3) |
||
| A1Block | A1Gebaeude NVARCHAR (100) |
||
| A1ContactPerson | A1AnsprechpartnerID INT |
OCPR.CntctCode | |
| A1AddressName1 | A1AdressName NVARCHAR (50) |
||
| A1AddressName2 | A1AdressName2 NVARCHAR (50) |
||
| A1AddressName3 | A1AdressName3 NVARCHAR (50) |
||
| A1Building | A1GebaeudeStockwerk NTEXT |
||
| A1AddressMemo | A1AdressMemo NTEXT |
||
| A1CardFName | A1CardFName NVARCHAR (100) |
||
| A1AddrType | A1AddrType NVARCHAR (100) |
||
| A1AddressLineNum | A1AdressLineNum INT |
||
| A1GlbLocNum | A1GlbLocNum NVARCHAR (50) |
||
| A1Longitude | A1Longitude Float |
||
| A1Latitude | A1Latitude Float |
||
| A0EMailContactPerson | A0EMailAnsprechpartner INT |
||
| A1EMailContactPerson | A1EMailAnsprechpartner INT |
||
| ISCDocumentIDFollowing | ILVBelegIDNachfolger INT |
||
| ISCDocumentIDPrevious | ILVBelegIDVorgaenger INT |
||
| LocationID | LocationID INT Index |
||
| CIG_Code | CIG_Code INT |
||
| CUP_Code | CUP_Code 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 |