| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | T000 | MANDT | Allow NULL? |
| 2 | ANLAGE | Installation | nvarchar | 10 | 0 | CHAR | (N' ') | No | EANL | ANLAGE | Allow NULL? |
| 3 | BIS | Date at Which a Time Slice Expires | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | BISZEITSCH | Allow NULL? |
| 4 | AB | Date from which time slice is valid | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ABZEITSCH | Allow NULL? |
| 5 | TARIFTYP | Rate category | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | ETTA | TARIFTYP_ANL | Allow NULL? |
| 6 | ANLSTAT | Installation Status | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | ANLSTAT | Allow NULL? |
| 7 | KONZBEFR | Exempt from franchise fee | char | 1 | 0 | CHAR | (N' ') | Yes | | KONZBEFR | Allow NULL? |
| 8 | PAUSCHAL | Device allocation is not possible | char | 1 | 0 | CHAR | (N' ') | Yes | | E_PAUSCHAL | Allow NULL? |
| 9 | BRANCHE | Industry | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TB038A | BU_IND_SECTOR | Allow NULL? |
| 10 | AKLASSE | Billing class | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | EAKLASSE | AKLASSE | Allow NULL? |
| 11 | ABLEINH | Meter Reading Unit | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | TE422 | ABLEINHEIT | Allow NULL? |
| 12 | TEMP_AREA | Temperature area | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | TE307 | TEMP_AREA | Allow NULL? |
| 13 | KONZVER | Franchise contract | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | KONZVER | Allow NULL? |
| 14 | BILLING_PARTY | Service Provider that Bills the Installation | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | BILLING_PARTY | Allow NULL? |
| 15 | INVOICING_PARTY | Service Provider That Invoices the Contract | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | INVOICING_PARTY | Allow NULL? |
| 16 | PROV_LAST_RES | Obligation to Supply | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | PROV_LAST_RESSORT | Allow NULL? |
| 17 | MAININST | Key of Primary Installation | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | EANL | MAININST | Allow NULL? |
| 18 | INSTROLE | Role of an Installation Within the Installation Group | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TE673 | INSTROLE | Allow NULL? |
| 19 | INSTGRTYPE | Grouping Type for Installation Group | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TE672 | INSTGRTYPE | Allow NULL? |
| 20 | ISTYPE | Industry System | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TB038 | BU_ISTYPE | Allow NULL? |
| 21 | HIGHLEVINST | Higher-Level Installation | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | EANL | HIGHLEVINST | Allow NULL? |
| 22 | SCHEMANR | Number of the billing schema | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | ESCH | SCHEMANR | Allow NULL? |
| 23 | HOCHART | Type of extrapolation in unbilled revenue reporting | char | 1 | 0 | CHAR | (N' ') | Yes | | HOCHART | Allow NULL? |
| 24 | VPERGRUP | Previous period control group | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | VPERGRUP | Allow NULL? |
| 25 | PRUEFGR | Validation group for dependent validations | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TE413 | PRUEFGR | Allow NULL? |
| 26 | ABSSTEU | Budget billing control | char | 1 | 0 | CHAR | (N' ') | Yes | | ABSSTEU | Allow NULL? |
