| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | PRDOC | Parked Document Number | nvarchar | 12 | 0 | | | | Allow NULL? |
| 3 | PARTNER | Business Partner Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 4 | ADDRNUMBER | Address Number (Temporary or Permanent) | nvarchar | 10 | 0 | | | | Allow NULL? |
| 5 | STREETCODE | Street Number for City/Street File | nvarchar | 12 | 0 | | | | Allow NULL? |
| 6 | STREET | Street | nvarchar | 60 | 0 | | | | Allow NULL? |
| 7 | HOUSE_NUM1 | House Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 8 | HOUSE_NUM2 | House number supplement | nvarchar | 10 | 0 | | | | Allow NULL? |
| 9 | COUNTRY | Country Key | nvarchar | 3 | 0 | | | | Allow NULL? |
| 10 | LANGU | Language Key | char | 1 | 0 | | | | Allow NULL? |
| 11 | REGION | Region (State, Province, County) | nvarchar | 3 | 0 | | | | Allow NULL? |
| 12 | POST_CODE1 | City postal code | nvarchar | 10 | 0 | | | | Allow NULL? |
| 13 | CITY_CODE | City code for city/street file | nvarchar | 12 | 0 | | | | Allow NULL? |
| 14 | CITYP_CODE | District code for City and Street file | nvarchar | 8 | 0 | | | | Allow NULL? |
| 15 | HOME_CITY | City (different from postal city) | nvarchar | 40 | 0 | | | | Allow NULL? |
| 16 | CITY1 | City | nvarchar | 40 | 0 | | | | Allow NULL? |
| 17 | CITY2 | District | nvarchar | 40 | 0 | | | | Allow NULL? |
| 18 | CITYH_CODE | Different city for city/street file | nvarchar | 12 | 0 | | | | Allow NULL? |
| 19 | STR_SUPPL1 | Street 2 | nvarchar | 40 | 0 | | | | Allow NULL? |
| 20 | STR_SUPPL2 | Street 3 | nvarchar | 40 | 0 | | | | Allow NULL? |
| 21 | STR_SUPPL3 | Street 4 | nvarchar | 40 | 0 | | | | Allow NULL? |
| 22 | LOCATION | Street 5 | nvarchar | 40 | 0 | | | | Allow NULL? |
| 23 | BUILDING | Building (Number or Code) | nvarchar | 20 | 0 | | | | Allow NULL? |
| 24 | FLOOR | Floor in building | nvarchar | 10 | 0 | | | | Allow NULL? |
| 25 | ROOMNUMBER | Room or Appartment Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 26 | PO_BOX | PO Box | nvarchar | 10 | 0 | | | | Allow NULL? |
| 27 | PO_BOX_REG | Region for PO Box (Country, State, Province, ...) | nvarchar | 3 | 0 | | | | Allow NULL? |
| 28 | PO_BOX_CTY | PO box country | nvarchar | 3 | 0 | | | | Allow NULL? |
| 29 | POST_CODE2 | PO Box Postal Code | nvarchar | 10 | 0 | | | | Allow NULL? |
| 30 | PO_BOX_LOC | PO Box city | nvarchar | 40 | 0 | | | | Allow NULL? |
| 31 | POST_CODE3 | Company Postal Code (for Large Customers) | nvarchar | 10 | 0 | | | | Allow NULL? |
| 32 | PCODE2_EXT | (Not Supported) PO Box Postal Code Extension | nvarchar | 10 | 0 | | | | Allow NULL? |
| 33 | PCODE3_EXT | (Not Supported) Major Customer Postal Code Extension | nvarchar | 10 | 0 | | | | Allow NULL? |
| 34 | TAXJURCODE | Tax Jurisdiction | nvarchar | 15 | 0 | | | | Allow NULL? |
