| Table Name: | MPTmpRptPrintAdresse |
| View Name: | MARITempReportAddress |
| Group: | Group: TempReportDocumentHeader |
| Description: | Reportng: 1:n Addresses for ducments |
| Field | View(engl.field)/Type | Description | Related |
|---|---|---|---|
| ConnectionID | ConnectionID INT Primary |
||
| MPBelID | MARIDocID INT Primary |
||
| AdressLine | AddressLine INT Primary |
||
| AdressType | AddressType INT |
||
| Mandant | Company SMALLINT |
||
| A0Empfaenger | A0CardCode NVARCHAR (20) |
||
| Anschrift | Address NTEXT |
||
| A0Anrede | A0Salutation NVARCHAR (50) |
||
| A0Name1 | A0Name1 NVARCHAR (100) |
||
| A0Name2 | A0Name2 NVARCHAR (50) |
||
| A0Zusatz | A0Name3 NVARCHAR (50) |
||
| 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 |
||
| A0CardFName | A0CardFName NVARCHAR (100) |
||
| A0AddrType | A0AddrType NVARCHAR (100) |
||
| A0AdressLineNum | A0AddressLineNum INT |
||
| A0GlbLocNum | A0GlbLocNum NVARCHAR (50) |
||
| A0Longitude | A0Longitude Float |
||
| A0Latitude | A0Latitude Float |