| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | YVWDNR | CHD Contract Number | nvarchar | 13 | 0 | | | | Allow NULL? |
| 3 | DATE_TO | Valid To Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 4 | DATE_FROM | Valid-From Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 5 | CTR_CURRENCY | CH: Contract Currency | nvarchar | 5 | 0 | | | | Allow NULL? |
| 6 | CTR_BUKRS | CH: Contract Company Code | nvarchar | 4 | 0 | | | | Allow NULL? |
| 7 | CTR_ACC_PARTY | Ch: Contract Partner (Contractee) | nvarchar | 10 | 0 | | | | Allow NULL? |
| 8 | VKORG_RG | Post Sales Organzation | nvarchar | 4 | 0 | | | | Allow NULL? |
| 9 | VTWEG_RG | Distribution Channel Post | nvarchar | 2 | 0 | | | | Allow NULL? |
| 10 | SPART_RG | Division Post | nvarchar | 2 | 0 | | | | Allow NULL? |
| 11 | CTR_OBJECT | CH: Object Number (Sales Outlet) | nvarchar | 10 | 0 | | | | Allow NULL? |
| 12 | VKORG_WE | Sales Organization Performance | nvarchar | 4 | 0 | | | | Allow NULL? |
| 13 | VTWEG_WE | Distribution Channel Performance | nvarchar | 2 | 0 | | | | Allow NULL? |
| 14 | SPART_WE | Division Performance | nvarchar | 2 | 0 | | | | Allow NULL? |
| 15 | KUNNR_AG | Customer Number of Sold-to Party | nvarchar | 10 | 0 | | | | Allow NULL? |
| 16 | DEBITOR | Customer | nvarchar | 10 | 0 | | | | Allow NULL? |
| 17 | BUKRS_DEBITOR | Company Code | nvarchar | 4 | 0 | | | | Allow NULL? |
| 18 | GEBIET | CH: Assignment of Territory | nvarchar | 10 | 0 | | | | Allow NULL? |
| 19 | GEBIET_NAME | CH: Territory Description | nvarchar | 20 | 0 | | | | Allow NULL? |
| 20 | PSTLZ | Postal Code | nvarchar | 10 | 0 | | | | Allow NULL? |
| 21 | REGIO | Region (State, Province, County) | nvarchar | 3 | 0 | | | | Allow NULL? |
| 22 | KUKLA | Customer classification | nvarchar | 2 | 0 | | | | Allow NULL? |
| 23 | BUSAB | Accounting clerk | nvarchar | 2 | 0 | | | | Allow NULL? |
| 24 | BUSAB_NAME | Name of Accounting Clerk | nvarchar | 30 | 0 | | | | Allow NULL? |
| 25 | ADM1 | CH: Field Sales Representative 1 | nvarchar | 10 | 0 | | | | Allow NULL? |
| 26 | ADM1_NAME | CH: Name of Field Sales Representative 1 | nvarchar | 30 | 0 | | | | Allow NULL? |
| 27 | ADM2 | CH: Field Sales Representative 2 | nvarchar | 10 | 0 | | | | Allow NULL? |
| 28 | ADM2_NAME | CH: Name of Field Sales Representative 2 | nvarchar | 30 | 0 | | | | Allow NULL? |
| 29 | ADM3 | CH: Field Sales Representative 3 | nvarchar | 10 | 0 | | | | Allow NULL? |
| 30 | ADM3_NAME | CH: Name of Field Sales Representative 3 | nvarchar | 30 | 0 | | | | Allow NULL? |
| 31 | ADM4 | CH: Field Sales Representative 4 | nvarchar | 10 | 0 | | | | Allow NULL? |
| 32 | ADM4_NAME | CH: Name of Field Sales Representative 4 | nvarchar | 30 | 0 | | | | Allow NULL? |
| 33 | ADM5 | CH: Field Sales Representative 5 | nvarchar | 10 | 0 | | | | Allow NULL? |
| 34 | ADM5_NAME | CH: Name of Field Sales Representative 5 | nvarchar | 30 | 0 | | | | Allow NULL? |
| 35 | HITYP | Customer hierarchy type | char | 1 | 0 | | | | Allow NULL? |
| 36 | AMOUNT_OP | CH: Amount of Open Item in Local Currency | decimal | 15 | 2 | | | | |
| 37 | SHKZG | Debit/Credit Indicator | char | 1 | 0 | | | | Allow NULL? |
| 38 | HS_CURRENCY | CH: Local Currency | nvarchar | 5 | 0 | | | | Allow NULL? |
| 39 | MAHNST_HIGH | CH: Highest Dunning Level | char | 1 | 0 | | | | Allow NULL? |
| 40 | REC_TIMESTAMP | CH: Time Stamp | nvarchar | 14 | 0 | | | | Allow NULL? |
