| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | GASSTMTH_NO | Header System Number | nvarchar | 20 | 0 | | | | Allow NULL? |
| 3 | SALE_DT | Sales Date / Month | nvarchar | 8 | 0 | | | | Allow NULL? |
| 4 | ORIG_MP_NO | Original measurement point number | nvarchar | 20 | 0 | | | | Allow NULL? |
| 5 | WI_OWN_NO | Working Interest Owner | nvarchar | 10 | 0 | | | | Allow NULL? |
| 6 | WI_INT_TYPE_CD | Participant Interest Type | nvarchar | 2 | 0 | | | | Allow NULL? |
| 7 | WI_OWN_ISQ_NO | Owner Interest Sequence Number | nvarchar | 2 | 0 | | | | Allow NULL? |
| 8 | MATNR | Material Number | nvarchar | 18 | 0 | | | | Allow NULL? |
| 9 | TRNSP_NO | Transporter number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 10 | TRNSP_REF_NO | Transporter Reference Number | nvarchar | 25 | 0 | | | | Allow NULL? |
| 11 | VL_TYPE_CD | Volume type code | nvarchar | 2 | 0 | | | | Allow NULL? |
| 12 | ACTL_ENERGY | Actual Energy | decimal | 13 | 3 | | | | |
| 13 | ENTL_ENERGY | Entitlement Energy | decimal | 13 | 3 | | | | |
| 14 | ENERGY_U | Measurement unit | nvarchar | 3 | 0 | | | | Allow NULL? |
| 15 | ACTL_GR_VL | Actual Gross Volume Amount | decimal | 13 | 3 | | | | |
| 16 | ENTL_GR_VL | Entitled Gross Volume Amount | decimal | 13 | 3 | | | | |
| 17 | TOT_GR_VL_U | Measurement unit | nvarchar | 3 | 0 | | | | Allow NULL? |
| 18 | ACTL_GR_VAL_AM | Actual Gross Value Amount | decimal | 13 | 2 | | | | |
| 19 | ENTL_GR_VAL_AM | Entitled Gross Value Amount | decimal | 13 | 2 | | | | |
| 20 | GR_VAL_CURR | Currency Key | nvarchar | 5 | 0 | | | | Allow NULL? |
| 21 | ACT_HEAT_VAL_FCT | Actual Heating Factor | decimal | 13 | 3 | | | | |
| 22 | HEAT_VALUE_FCT_U | Measurement unit | nvarchar | 3 | 0 | | | | Allow NULL? |
| 23 | PC_AMT | Transporter unit value | decimal | 15 | 2 | | | | |
| 24 | PC_CURR | Currency Key | nvarchar | 5 | 0 | | | | Allow NULL? |
| 25 | PC_CT_NO | PC Contract Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 26 | PC_WL_NO | PC Well ID Number | nvarchar | 15 | 0 | | | | Allow NULL? |
| 27 | PC_WC_NO | PC Well Completion Number | nvarchar | 5 | 0 | | | | Allow NULL? |
| 28 | PC_MP_NO | PC Measurement point number | nvarchar | 20 | 0 | | | | Allow NULL? |
| 29 | PC_CONDITION | Condition type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 30 | KALSM | Sales and Distribution: Pricing Procedure in Pricing | nvarchar | 6 | 0 | | | | Allow NULL? |
| 31 | RVRS_ONLY_FL | Reversal Only Flag | char | 1 | 0 | | | | Allow NULL? |
| 32 | OIU_CRUSER | Name of Person who Created the Object | nvarchar | 12 | 0 | | | | Allow NULL? |
| 33 | OIU_TIMESTAMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | | | |