| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | PARTNER | Business Partner Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 3 | MUSTER_KUN | Reference for creating a standard customer for bus. partner | nvarchar | 10 | 0 | | | | Allow NULL? |
| 4 | WAKLASS | Employee classification | nvarchar | 4 | 0 | | | | Allow NULL? |
| 5 | FIRMART | Type of installation company | nvarchar | 2 | 0 | | | | Allow NULL? |
| 6 | ARBFELD | Company work field | nvarchar | 2 | 0 | | | | Allow NULL? |
| 7 | MITGLIED | Membership of installer | char | 1 | 0 | | | | Allow NULL? |
| 8 | SPZULASS | Division license of installer | nvarchar | 20 | 0 | | | | Allow NULL? |
| 9 | ARTZULASS | Installer license type | nvarchar | 2 | 0 | | | | Allow NULL? |
| 10 | AUSWANZ | Number of identifications | nvarchar | 2 | 0 | | | | Allow NULL? |
| 11 | PLOMBENZ | Sealing pliers number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 12 | FREMDEVU | Main utility company | nvarchar | 3 | 0 | | | | Allow NULL? |
| 13 | STATINS | Valid status of installer in supply area | nvarchar | 2 | 0 | | | | Allow NULL? |
| 14 | STATDATUM | Date on which status of installer comes into effect | nvarchar | 8 | 0 | | | | Allow NULL? |
| 15 | ERSTZUL | Date of initial license of installer | nvarchar | 8 | 0 | | | | Allow NULL? |
| 16 | WERKSTATT | Date of workshop inspection | nvarchar | 8 | 0 | | | | Allow NULL? |
| 17 | VERLZUL | Date of license renewal | nvarchar | 8 | 0 | | | | Allow NULL? |
| 18 | ENDEZUL | Date until which license is renewed | nvarchar | 8 | 0 | | | | Allow NULL? |
| 19 | ANZEVU | Number of utility companies | nvarchar | 2 | 0 | | | | Allow NULL? |
| 20 | ANZFIL | Number of branches supported by an installionr company | nvarchar | 2 | 0 | | | | Allow NULL? |
| 21 | AUSW_INST | Identification number for installer license | nvarchar | 10 | 0 | | | | Allow NULL? |
| 22 | DR_LICENSE_LAND1 | Country in which driver's license was acquired | nvarchar | 3 | 0 | | | | Allow NULL? |
| 23 | DR_LICENSE_REGIO | Region in which driver's license was acquired | nvarchar | 3 | 0 | | | | Allow NULL? |
| 24 | DR_LICENSE | Driver's license number | nvarchar | 20 | 0 | | | | Allow NULL? |
| 25 | SOC_SECURE | Social Insurance Number | nvarchar | 12 | 0 | | | | Allow NULL? |
| 26 | WELFARE | Welfare office | nvarchar | 9 | 0 | | | | Allow NULL? |
| 27 | PLACE_EMPL | Work center | nvarchar | 40 | 0 | | | | Allow NULL? |
| 28 | KTOKLASSE | Account class | nvarchar | 4 | 0 | | | | Allow NULL? |
| 29 | BUPINFOREL | Information release for business partner data | nvarchar | 2 | 0 | | | | Allow NULL? |
| 30 | CLERK_ID | Business partner-specific criteria for agent determination | nvarchar | 8 | 0 | | | | Allow NULL? |
| 31 | RECPTYPE | Category for Alternate Payee | char | 1 | 0 | | | | Allow NULL? |
| 32 | PYMET | Payment method for donations/fund payments | char | 1 | 0 | | | | Allow NULL? |
| 33 | EMBVT | Bank details ID for donations/fund payments | nvarchar | 4 | 0 | | | | Allow NULL? |
| 34 | HKONT | G/L accounts for donations/fund payments | nvarchar | 10 | 0 | | | | Allow NULL? |
| 35 | CLASSIFICATION | Classification of Business Partner | nvarchar | 4 | 0 | | | | Allow NULL? |
| 36 | VIP | Indicate Very Important Business Partner | char | 1 | 0 | | | | Allow NULL? |
| 37 | IDENT_INST | Identification Number for Installer License | nvarchar | 18 | 0 | | | | Allow NULL? |
