| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | CLIENT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | PARTNER | Business Partner Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 3 | USABLE_FROM | Central Data of Business Partner Valid From | decimal | 15 | 0 | | | | |
| 4 | USABLE_TO | Central Data of Business Partner Valid To | decimal | 15 | 0 | | | | |
| 5 | ADDRNUMBER | Address number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 6 | ADDR_USABLE_FROM | Business Partner Address Valid From | decimal | 15 | 0 | | | | |
| 7 | ADDR_USABLE_TO | Business Partner Address Valid To (Inclusive) | decimal | 15 | 0 | | | | |
| 8 | BKVID | Bank details ID | nvarchar | 4 | 0 | | | | Allow NULL? |
| 9 | BK_USABLE_FROM | Bank Details of Business Partner Valid From | decimal | 15 | 0 | | | | |
| 10 | BK_USABLE_TO | Bank Details of Business Partner Valid To (Inclusive) | decimal | 15 | 0 | | | | |
| 11 | TYPE | Business partner category | char | 1 | 0 | | | | Allow NULL? |
| 12 | LANGU | Language Key | char | 1 | 0 | | | | Allow NULL? |
| 13 | COUNTRY | Country Key | nvarchar | 3 | 0 | | | | Allow NULL? |
| 14 | REGION | Region (State, Province, County) | nvarchar | 3 | 0 | | | | Allow NULL? |
| 15 | CITY1 | City | nvarchar | 40 | 0 | | | | Allow NULL? |
| 16 | CITY2 | District | nvarchar | 40 | 0 | | | | Allow NULL? |
| 17 | PO_BOX_LOC | PO Box city | nvarchar | 40 | 0 | | | | Allow NULL? |
| 18 | POST_CODE1 | City postal code | nvarchar | 10 | 0 | | | | Allow NULL? |
| 19 | POST_CODE2 | PO Box Postal Code | nvarchar | 10 | 0 | | | | Allow NULL? |
| 20 | POST_CODE3 | Company Postal Code (for Large Customers) | nvarchar | 10 | 0 | | | | Allow NULL? |
| 21 | PO_BOX | PO Box | nvarchar | 10 | 0 | | | | Allow NULL? |
| 22 | STREET | Street | nvarchar | 60 | 0 | | | | Allow NULL? |
| 23 | HOUSE_NUM1 | House Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 24 | HOUSE_NUM2 | House number supplement | nvarchar | 10 | 0 | | | | Allow NULL? |
| 25 | TEL_NUMBER | Telephone no.: dialling code+number | nvarchar | 30 | 0 | | | | Allow NULL? |
| 26 | TEL_EXTENS | Telephone no.: Extension | nvarchar | 10 | 0 | | | | Allow NULL? |
| 27 | FAX_NUMBER | Fax number: dialling code+number | nvarchar | 30 | 0 | | | | Allow NULL? |
| 28 | FAX_EXTENS | Fax no.: Extension | nvarchar | 10 | 0 | | | | Allow NULL? |
| 29 | BANKS | Bank country key | nvarchar | 3 | 0 | | | | Allow NULL? |
| 30 | BANKL | Bank Keys | nvarchar | 15 | 0 | | | | Allow NULL? |
| 31 | BANKN | Bank account number | nvarchar | 18 | 0 | | | | Allow NULL? |
| 32 | BKONT | Bank Control Key | nvarchar | 2 | 0 | | | | Allow NULL? |
| 33 | BKREF | Reference specifications for bank details | nvarchar | 20 | 0 | | | | Allow NULL? |
| 34 | KOINH | Account Holder Name | nvarchar | 60 | 0 | | | | Allow NULL? |
| 35 | NAME1 | Name field 1 (name1/last name) | nvarchar | 40 | 0 | | | | Allow NULL? |
| 36 | NAME2 | Name field 2 (name2/first name) | nvarchar | 40 | 0 | | | | Allow NULL? |
| 37 | CCARD_ID | Payment Card ID | nvarchar | 6 | 0 | | | | Allow NULL? |
| 38 | CCINS | Payment card type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 39 | CCNUM | Payment cards: Card number | nvarchar | 25 | 0 | | | | Allow NULL? |
| 40 | CITY_CODE | City code for city/street file | nvarchar | 12 | 0 | | | | Allow NULL? |
| 41 | CITYP_CODE | District code for City and Street file | nvarchar | 8 | 0 | | | | Allow NULL? |
| 42 | STREETCODE | Street Number for City/Street File | nvarchar | 12 | 0 | | | | Allow NULL? |
| 43 | INVALID | Shadow Table Entry Invalid | char | 1 | 0 | | | | Allow NULL? |
| 44 | IBAN | IBAN (International Bank Account Number) | nvarchar | 34 | 0 | | | | Allow NULL? |
| 45 | CARD_GUID | GUID of a Payment Card | varbinary | 16 | 0 | | | | |
| 46 | VERSION | Version of Shadow Table | nvarchar | 2 | 0 | | | | Allow NULL? |
| 47 | XPCPT | Business Purpose Completed Flag | char | 1 | 0 | | | | Allow NULL? |
