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