| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | DN_NO | Delivery network number | nvarchar | 20 | 0 | | | | Allow NULL? |
| 3 | SA_DT | Sales date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 4 | MP_NO | Measurement point number | nvarchar | 20 | 0 | | | | Allow NULL? |
| 5 | ORIG_MP_NO | Original measurement point number | nvarchar | 20 | 0 | | | | Allow NULL? |
| 6 | TRNSP_NO | Transporter number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 7 | MATNR | Material Number | nvarchar | 18 | 0 | | | | Allow NULL? |
| 8 | FREQ_CD | Frequency | char | 1 | 0 | | | | Allow NULL? |
| 9 | CT_NO | Contract Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 10 | VC_CD | Volume class code | char | 1 | 0 | | | | Allow NULL? |
| 11 | STD_VOL_U | Standard volume unit | nvarchar | 3 | 0 | | | | Allow NULL? |
| 12 | STD_VOL | Standard volume | decimal | 13 | 3 | | | | |
| 13 | STD_HEAT_VAL_U | Standardized Heating Value Unit | nvarchar | 3 | 0 | | | | Allow NULL? |
| 14 | STD_HEAT_VAL | Standardized Heating Value | decimal | 13 | 3 | | | | |
| 15 | STD_ENERGY_U | Standard Energy UoM | nvarchar | 3 | 0 | | | | Allow NULL? |
| 16 | STD_ENERGY | Standard Energy | decimal | 13 | 3 | | | | |
| 17 | QY_U | Quantity Unit | nvarchar | 3 | 0 | | | | Allow NULL? |
| 18 | ENTL_QY | Entitled Quantity | decimal | 13 | 3 | | | | |
| 19 | ADJ_ENTL_QY | Adjusted Entitlement (Volumetric or Energy) | decimal | 13 | 3 | | | | |
| 20 | PHASE_1_QY | Phase One Allocation Energy Quantity | decimal | 13 | 3 | | | | |
| 21 | PHASE_2_QY | Phase Two Allocation Energy Quantity | decimal | 13 | 3 | | | | |
| 22 | PHASE_3_QY | Phase Three Allocation Energy Quantity | decimal | 13 | 3 | | | | |
| 23 | PHASE_4_QY | Phase Four Allocation Energy Quantity | decimal | 13 | 3 | | | | |
| 24 | PHASE_5_QY | Phase Five Allocation Energy Quantity | decimal | 13 | 3 | | | | |
| 25 | ME_DOCNR | Meas. document number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 26 | ME_DOCYR | Meas. document year | nvarchar | 4 | 0 | | | | Allow NULL? |
| 27 | OIU_CRUSER | Name of Person who Created the Object | nvarchar | 12 | 0 | | | | Allow NULL? |
| 28 | OIU_TIMESTAMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | | | |
