| Table Name: | MPTmpRptPrintBelegKopf |
| View Name: | MARITempReportDocumentHeader |
| Group: | Group: TempReportDocumentHeader |
| Description: | Reporting: Temporary Table: Document Header |
| ClassID: | 278. See Overview of ClassIDs by table. |
| Field | View(engl.field)/Type | Description | Related |
|---|---|---|---|
| ConnectionID | ConnectionID INT Primary |
Unique ID per user session | |
| MPBelID | MARIDocID INT Primary |
MPVKVertraegeBelege.MPBelID | |
| BelID | DocEntry INT |
||
| Mandant | Company SMALLINT |
MPSysConnections.CompanyID (WHERE ConnectionType=6) | |
| A0Empfaenger | A0CardCode NVARCHAR (20) |
OCRD.CardCode | |
| MPBelegTyp | MARIDocType INT |
PM document type | |
| ERPBelegTyp | SBODocType INT |
ERP document type | |
| Belegart | DocumentTypeText NVARCHAR (50) |
Document name in user language | |
| Belegnummer | DocumentNumber NVARCHAR (20) |
Formatted DocNum (2011-12) | |
| Belegjahr | DocYear INT |
Only year of DocumentNumber | |
| DocNum | DocNum INT |
Only visibel number of DocumentNumber | |
| DocSeries | DocSeries INT |
Field for Brazil | |
| DocSeriesString | DocSeriesString NVARCHAR (3) |
Field for Brazil | |
| DocSeriesSubString | DocSeriesSubString NVARCHAR (3) |
Field for Brazil | |
| SequenceCode | SequenceCode INT |
Field for Brazil | |
| SequenceSerial | SequenceSerial INT |
Field for Brazil | |
| SequenceModel | SequenceModel NVARCHAR (10) |
Field for Brazil | OINV.Model |
| BPLId | BPLId INT |
OINF.BPLId | |
| BPLName | BPLName NVARCHAR (100) |
||
| 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 |
| Belegdatum | DocDate Datetime |
Document Date | |
| Steuerdatum | TaxDate Datetime |
VatDate (Only Poland) | |
| Faelligkeitsdatum | DueDate Datetime |
Sales Quotation: Valid until | Sales Order, Delivery, Purchase Order: Delivery Date | Other Documents: Due Date | |
| MietStartDatum | RentalStartDate Datetime |
||
| MietEndDatum | RentalEndDate Datetime |
||
| Buchungstext | JournalRemark NVARCHAR (254) |
Entry text | |
| Anschrift | Address NTEXT |
Delivery the delivery adress, invoices the payment address | |
| Anschrift2 | Address2 NTEXT |
Delivery the payment adress, invoices the delivery address | |
| A0Anrede | A0Salutation NVARCHAR (50) |
||
| A0Name1 | A0Name1 NVARCHAR (100) |
||
| A0Name2 | A0Name2 NVARCHAR (50) |
U_MARINam2 | |
| A0Zusatz | A0Name3 NVARCHAR (50) |
U_MARINam3 | |
| 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 |
id from Contact Person | OCPR.CntctCode |
| A0AdressName | A0AddressName1 NVARCHAR (50) |
||
| A0AdressName2 | A0AddressName2 NVARCHAR (50) |
||
| A0AdressName3 | A0AddressName3 NVARCHAR (50) |
||
| A0GebaeudeStockwerk | A0Building NTEXT |
||
| A0CardFName | A0CardFName NVARCHAR (100) |
foreign business partner name | |
| A0AddrType | A0AddrType NVARCHAR (100) |
||
| A0AdressLineNum | A0AddressLineNum INT |
||
| A0GlbLocNum | A0GlbLocNum NVARCHAR (50) |
||
| A0Longitude | A0Longitude Float |
||
| A0Latitude | A0Latitude Float |
||
| A1BusinessPartner | A1BusinessPartner NVARCHAR (20) |
cardcode of business partner | |
| A1Anrede | A1Salutation NVARCHAR (50) |
||
| A1Name1 | A1Name1 NVARCHAR (100) |
||
| A1Name2 | A1Name2 NVARCHAR (50) |
U_MARINam2 | |
| A1Zusatz | A1Name3 NVARCHAR (50) |
U_MARINam3 | |
| 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 |
id from Contact Person | OCPR.CntctCode |
| A1AdressName | A1AddressName1 NVARCHAR (50) |
||
| A1AdressName2 | A1AddressName2 NVARCHAR (50) |
||
| A1AdressName3 | A1AddressName3 NVARCHAR (50) |
||
| A1GebaeudeStockwerk | A1Building NTEXT |
||
| A1CardFName | A1CardFName NVARCHAR (100) |
foreign business partner name | |
| A1AddrType | A1AddrType NVARCHAR (100) |
||
| A1AdressLineNum | A1AddressLineNum INT |
||
| A1GlbLocNum | A1GlbLocNum NVARCHAR (50) |
||
| A1Longitude | A1Longitude Float |
||
| A1Latitude | A1Latitude Float |
||
| Anschrift2Text | Address2Text NVARCHAR (50) |
must empty for old user reports | |
| Lieferanschrift | DeliveryAddress NTEXT |
complete formatted delivery address | |
| Zwischensumme | SubtotalFc NUMERIC(19,6) |
Subtotal (before Discount and Down Payment, after Freight) | |
| Rabatt1 | DiscountPercent NUMERIC(19,6) |
DownPayment documents: down payment percent | Other documents: Discount | |
| Rabatt2 | DiscountPercent2 NUMERIC(19,6) |
must 0 for old user reports | |
| Rabatt3 | DiscountPercent3 NUMERIC(19,6) |
must 0 for old user reports | |
| Rabattbetrag1 | DiscountValueFC NUMERIC(19,6) |
DownPayment documents: down payment amount | Other documents: Discount Amount | |
| Rabattbetrag2 | Discount2ValueFc NUMERIC(19,6) |
DownPayment Subtraction | |
| Rabattbetrag3 | Discount3ValueFc NUMERIC(19,6) |
must 0 for old user reports | |
| Rabattbasis1 | DiscountBaseFC NUMERIC(19,6) |
Basic Value of Discount | |
| Rabattbasis2 | Discount2BaseFc NUMERIC(19,6) |
must 0 for old user reports | |
| Rabattbasis3 | Discount3BaseFc NUMERIC(19,6) |
must 0 for old user reports | |
| Bruttobetrag | TotalValueFc NUMERIC(19,6) |
Total Amount | |
| Fusstext | Footer NTEXT |
text in Footer | |
| IGSteuerfreitext | EUTaxInternalText NTEXT |
not in use | |
| Kopftext | Header NTEXT |
text in Header | |
| Comments | Comments NVARCHAR (254) |
Memo field in SBO document | |
| Adresskopf | AddressHead NVARCHAR (100) |
Sender Address of company setting PrintHeader | |
| Gueltigkeitsdauer | PostingDate Datetime |
Tax Date | |
| Versandart | ShippingType NVARCHAR (50) |
not in use | |
| Lieferbedingung | DeliveryTerms NVARCHAR (50) |
not in use | |
| QuellLager | SourceWarehouse NVARCHAR (110) |
Warehouse Code | OWHS.WhsCode |
| Bezug | Reference NVARCHAR (50) |
not in use | |
| Referenzzeichen | ReferenceSign NVARCHAR (255) |
REF. | |
| Referenznummer | ReferenceNumber NVARCHAR (255) |
REF. No. | |
| UStID | VATID NVARCHAR (32) |
EU Tax Number of company | |
| UStIDNRKunde | VATIDCustomer NVARCHAR (32) |
EU Tax ID Customer | |
| Bearbeiter | HandledBy NVARCHAR (128) |
Name from SBO User | OUSR.USER_Code |
| Vertriebsmitarbeiter | SalesEmployee NVARCHAR (128) |
Sales Employee Name | OSLP.SlpCode |
| VertriebsmitarbeiterCode | SalesEmployeeCode SMALLINT |
Sales Employee Code | |
| EUUStID | EUVATID NVARCHAR (32) |
not in use | |
| Infodruck | InfoPrintTypeText NVARCHAR (20) |
Print Preview or Historieninstanz # or Document Draft | |
| FolioPref | FolioPref NVARCHAR (4) |
||
| FolioNum | FolioNum INT |
||
| RabattText1 | DiscountText1 NVARCHAR (30) |
EU Tax ID Customer | |
| RabattText2 | DiscountText2 NVARCHAR (30) |
Telephone Extension from SBO User | |
| RabattText3 | DiscountText3 NVARCHAR (30) |
Payment Condition Code | |
| ProzentVon | PercentBasedOn NVARCHAR (10) |
not in use | |
| Nettosumme | NetAmountFc NUMERIC(19,6) |
Net Amount | |
| Wkz | Currency NVARCHAR (5) |
Document ISO Currency Code | |
| Lieferschein | DeliveryNote NVARCHAR (20) |
empty | |
| WkzEuro | CurrencyEUR NVARCHAR (5) |
ProjectManagement System Currency | |
| BruttobetragEuro | TotalValueEUR NUMERIC(19,6) |
Total Amount, same of field "Bruttobetrag" | |
| EntsprichtText | EqualsToText NVARCHAR (20) |
not in use | |
| Vorgangsnummer | ProcessNumber INT |
not in use | |
| Telefon | Phone NVARCHAR (20) |
Telephone Number from Business Partner | |
| Telefax | Fax NVARCHAR (20) |
Fax Number from Business Partner | |
| Rechnungsempfaenger | InvoiceCustomerCode NVARCHAR (20) |
CardCode Business Partner from payment adress | |
| Rechnungsadresse | InvoiceAddressCode INT |
not in use | |
| Archivtext | ArchiveText NVARCHAR (50) |
not in use | |
| VertragsID | ContractID INT |
Unique Contract ID | MPVKVertraege.VertragsID |
| Vertragsnummer | ContractNumber NVARCHAR (20) |
Contract number | |
| Vertragsbezeichnung | ContractName NVARCHAR (100) |
Contract Name | |
| Projektnummer | ProjectNumber NVARCHAR (20) |
Project Number | MPProjektstamm.Projektnummer |
| Projektbezeichnung | ProjectName NVARCHAR (100) |
Project Name | |
| ProjektMatchcode | ProjectMatchcode NVARCHAR (100) |
Project Matchcode | |
| ZahlungskonditonBezeichnung | PaymentConditionText NVARCHAR (50) |
Payment Condition Text | |
| ZahlungskonditionReferenz | PaymentConditionReference INT |
Payment Condition Code | |
| Sprache | LanguageKey NVARCHAR (10) |
ISO language code | |
| SprachID | LanguageID INT |
Customer language ID | |
| Incoterm | Incoterm NVARCHAR (4) |
International Commercial | |
| Revision | Revision NVARCHAR (20) |
Revision of document | |
| Personalnummer | EmployeeNumber NVARCHAR (20) |
PM Employee Number | MPPersonenstamm.Personalnummer |
| PersonenName | EmployeeName NVARCHAR (50) |
PM Employee Name | |
| PersonTelefon | EmployeePhone NVARCHAR (50) |
PM Employee Telephone | |
| PersonFax | EmployeeFax NVARCHAR (50) |
PM Employee Fax | |
| PersonEMail | EmployeeEMail NVARCHAR (50) |
PM Employee Email | |
| ShipmentTypeID | ShipmentTypeID INT |
Shipment Code | |
| ShipmentTypeText | ShipmentTypeText NVARCHAR (40) |
Shipment Text | |
| LocInstanc | LocInstanc INT |
Version from Document | |
| InfoDruckTyp | InfoPrintType INT |
Print Type of Document | |
| ProfitCenter | ProfitCenter NVARCHAR (20) |
Profit Center Code | OOCR.OcrCode (WHERE [DimCode]=1) |
| ProfitCenterName | ProfitCenterName NVARCHAR (50) |
Profit Center Name | |
| OcrCode2 | OcrCode2 NVARCHAR (20) |
OOCR.OcrCode (WHERE [DimCode]=2) | |
| OcrCode2Name | OcrCode2Name NVARCHAR (50) |
||
| OcrCode3 | OcrCode3 NVARCHAR (20) |
OOCR.OcrCode (WHERE [DimCode]=3) | |
| OcrCode3Name | OcrCode3Name NVARCHAR (50) |
||
| OcrCode4 | OcrCode4 NVARCHAR (20) |
OOCR.OcrCode (WHERE [DimCode]=4) | |
| OcrCode4Name | OcrCode4Name NVARCHAR (50) |
||
| OcrCode5 | OcrCode5 NVARCHAR (20) |
OOCR.OcrCode (WHERE [DimCode]=5) | |
| OcrCode5Name | OcrCode5Name NVARCHAR (50) |
||
| ProjectCode | ProjectCode NVARCHAR (20) |
Project Code-Code | |
| ProjectCodeName | ProjectCodeName NVARCHAR (50) |
Project Code Name | |
| CountDownPayment | CountDownPayment INT |
Num of Down Payment lines | |
| CountZKD | CountZKD INT |
Num of Payment Terms/Installments lines | |
| RoundDif | RoundDif NUMERIC(19,6) |
||
| DMS_LicenceKey | DMS_LicenceKey NVARCHAR (255) |
||
| DMS_ArchiveName | DMS_ArchiveName NVARCHAR (255) |
||
| DMS_ArchiveProfile | DMS_ArchiveProfile NVARCHAR (255) |
||
| PictureImage | PictureImage Image |