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