| Table Name: | MPGebindeAdresse |
| View Name: | MARIContainerAddress |
| Group: | |
| Description: | Addtional information for trucks as container for shipping |
| Field | View(engl.field)/Type | Description | Related |
|---|---|---|---|
| GebindeAdresseID | ContainerAddressID INT Primary |
||
| GebindeID | ContainerID INT Index |
MPGebinde.GebindeID | |
| GebindeKategorie | ContainerCategory INT Index |
MPGebindeKategorie.GebindeKategorie | |
| AdressTyp | AddressType SMALLINT |
||
| QuellTyp | SourceType INT |
||
| QuellVerweis | SourceKey NVARCHAR (20) |
||
| A0AdressNr | A0AddressNr INT |
||
| A0Empfaenger | A0CardCode NVARCHAR (20) |
OCRD.CardCode | |
| A0Anrede | A0Salutation NVARCHAR (50) |
||
| A0Name1 | A0Name1 NVARCHAR (100) |
||
| A0Name2 | A0Name2 NVARCHAR (50) |
||
| A0Zusatz | A0Name3 NVARCHAR (50) |
||
| A0Einmalkunde | A0SingleCustomer SMALLINT |
||
| 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 |
||
| A0AdressMemo | A0AddressMemo NTEXT |
||
| A0CardFName | A0CardFName NVARCHAR (100) |
||
| A0AddrType | A0AddrType NVARCHAR (100) |
||
| A0AdressLineNum | A0AddressLineNum INT |
||
| A0GlbLocNum | A0GlbLocNum NVARCHAR (50) |
||
| A0Longitude | A0Longitude Float |
||
| A0Latitude | A0Latitude Float |