| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | VERTRAG | Contract | nvarchar | 10 | 0 | | | | Allow NULL? |
| 3 | VKONT | Contract Account Number | nvarchar | 12 | 0 | | | | Allow NULL? |
| 4 | GPARTNER | Business Partner Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 5 | SPARTE | Division | nvarchar | 2 | 0 | | | | Allow NULL? |
| 6 | AB_H | From Date of Extrapolation Period | nvarchar | 8 | 0 | | | | Allow NULL? |
| 7 | BIS_H | To Date of Extrapolation | nvarchar | 8 | 0 | | | | Allow NULL? |
| 8 | ABRMENGE_H | Extrapolated Billing Quantity (Consumption) | decimal | 31 | 14 | | | | |
| 9 | MASSBILL_H | Unit of measurement for billing | nvarchar | 3 | 0 | | | | Allow NULL? |
| 10 | NETTOBTR_H | Extrapolated Net Amount (Turnover) | decimal | 13 | 2 | | | | |
| 11 | ADDIT_AMNT_H | Extrapolated Additional Net Amount (Turnover) | decimal | 13 | 2 | | | | |
| 12 | LABRMENGE_H | Extrapolated Amount for Demand | decimal | 31 | 14 | | | | |
| 13 | LMASSBILL_H | Unit of measurement for billing | nvarchar | 3 | 0 | | | | Allow NULL? |
| 14 | LNETTOBTR_H | Extrapolated Net Amount for Demand | decimal | 13 | 2 | | | | |
| 15 | TWAERS_H | Currency Key | nvarchar | 5 | 0 | | | | Allow NULL? |
| 16 | DATATYPE | Indicators | char | 1 | 0 | | | | Allow NULL? |
| 17 | ABRBELNR | Basis for Extrapolation: Document Number of Billing Document | nvarchar | 12 | 0 | | | | Allow NULL? |
| 18 | ENDABRPE | Basis for Extrapolation: End of Billing Period | nvarchar | 8 | 0 | | | | Allow NULL? |
| 19 | AB_A | Basis for Extrapolation: Start Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 20 | BIS_A | Basis for Extrapolation: End Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 21 | ABRMENGE_A | Basis for Extrapolation: Billing Quantity (Consumption) | decimal | 31 | 14 | | | | |
| 22 | MASSBILL_A | Unit of measurement for billing | nvarchar | 3 | 0 | | | | Allow NULL? |
| 23 | NETTOBTR_A | Basis for Extrapolation: Net Amount (Turnover) | decimal | 13 | 2 | | | | |
| 24 | ADDIT_AMNT_A | Basis for Extrapolation: Additional Net Amount (Turnover) | decimal | 13 | 2 | | | | |
| 25 | LABRMENGE_A | Basis for Extrapolation: Demand Amount | decimal | 31 | 14 | | | | |
| 26 | LMASSBILL_A | Unit of measurement for billing | nvarchar | 3 | 0 | | | | Allow NULL? |
| 27 | LNETTOBTR_A | Basis for Extrapolation: Net Amount of Demand | decimal | 13 | 2 | | | | |
| 28 | TWAERS_A | Currency Key | nvarchar | 5 | 0 | | | | Allow NULL? |
| 29 | ANLAGE | Installation | nvarchar | 10 | 0 | | | | Allow NULL? |
| 30 | EINZDAT | Move-In Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 31 | AUSZDAT | Move-Out Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 32 | CPUDT | Day On Which Accounting Document Was Entered | nvarchar | 8 | 0 | | | | Allow NULL? |
