| View Name: | MARIContainerAddress |
| Based on table: | MPGebindeAdresse |
| Group: | |
| Description: | Addtional information for trucks as container for shipping |
| Field | Table(Germ.field)/Type | Description | Related |
|---|---|---|---|
| ContainerAddressID | GebindeAdresseID INT Primary |
||
| ContainerID | GebindeID INT Index |
MARIContainer.ContainerID | |
| ContainerCategory | GebindeKategorie INT Index |
MARIContainerCategory.ContainerCategory | |
| AddressType | AdressTyp SMALLINT |
||
| SourceType | QuellTyp INT |
||
| SourceKey | QuellVerweis NVARCHAR (20) |
||
| 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 |