| 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 | * | MANDT | Allow NULL? |
| 2 | GASSTMTH_NO | Header System Number | nvarchar | 20 | 0 | NUMC | (N'00000000000000000000') | No | | OIUVL_HEADER_SYS_NO | Allow NULL? |
| 3 | SALE_DT | Sales Date / Month | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | OIU_SALE_DT | Allow NULL? |
| 4 | ORIG_MP_NO | Original measurement point number | nvarchar | 20 | 0 | CHAR | (N' ') | No | * | OIU_ORIG_MP_NO | Allow NULL? |
| 5 | WI_OWN_NO | Working Interest Owner | nvarchar | 10 | 0 | CHAR | (N' ') | No | * | OIU_WI_OWN_NO | Allow NULL? |
| 6 | WI_INT_TYPE_CD | Participant Interest Type | nvarchar | 2 | 0 | CHAR | (N' ') | No | * | OIU_PART_INT_TYPE | Allow NULL? |
| 7 | WI_OWN_ISQ_NO | Owner Interest Sequence Number | nvarchar | 2 | 0 | CHAR | (N' ') | No | | OIU_OWN_ISQ_NO | Allow NULL? |
| 8 | MATNR | Material Number | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | * | MATNR | Allow NULL? |
| 9 | TRNSP_NO | Transporter number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | OIU_TRNSP_NO | Allow NULL? |
| 10 | TRNSP_REF_NO | Transporter Reference Number | nvarchar | 25 | 0 | CHAR | (N' ') | Yes | | OIU_TRNSP_REF_NO | Allow NULL? |
| 11 | VL_TYPE_CD | Volume type code | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | OIU_VT_CD | Allow NULL? |
| 12 | ACTL_ENERGY | Actual Energy | decimal | 13 | 3 | QUAN | ((0)) | Yes | | OIU_ACTL_ENERGY | |
| 13 | ENTL_ENERGY | Entitlement Energy | decimal | 13 | 3 | QUAN | ((0)) | Yes | | OIU_ENTL_ENERGY | |
| 14 | ENERGY_U | Measurement unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | * | OIU_MEAS_U | Allow NULL? |
| 15 | ACTL_GR_VL | Actual Gross Volume Amount | decimal | 13 | 3 | QUAN | ((0)) | Yes | | OIU_ACTL_GR_VL_AM | |
| 16 | ENTL_GR_VL | Entitled Gross Volume Amount | decimal | 13 | 3 | QUAN | ((0)) | Yes | | OIU_ENTL_GR_VL_AM | |
| 17 | TOT_GR_VL_U | Measurement unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | * | OIU_MEAS_U | Allow NULL? |
| 18 | ACTL_GR_VAL_AM | Actual Gross Value Amount | decimal | 13 | 2 | CURR | ((0)) | Yes | | OIU_ACTL_GR_VAL_AM | |
| 19 | ENTL_GR_VAL_AM | Entitled Gross Value Amount | decimal | 13 | 2 | CURR | ((0)) | Yes | | OIU_ENTL_GR_VAL_AM | |
| 20 | GR_VAL_CURR | Currency Key | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | WAERS | Allow NULL? |
| 21 | ACT_HEAT_VAL_FCT | Actual Heating Factor | decimal | 13 | 3 | QUAN | ((0)) | Yes | | OIU_ACT_HEAT_VAL_FCT | |
| 22 | HEAT_VALUE_FCT_U | Measurement unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | * | OIU_MEAS_U | Allow NULL? |
| 23 | PC_AMT | Transporter unit value | decimal | 15 | 2 | CURR | ((0)) | Yes | | OIUVL_PRICE_PER_UNIT | |
| 24 | PC_CURR | Currency Key | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | WAERS | Allow NULL? |
| 25 | PC_CT_NO | PC Contract Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | OIU_PC_CT_NO | Allow NULL? |
| 26 | PC_WL_NO | PC Well ID Number | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | * | OIU_PC_WL_NO | Allow NULL? |
| 27 | PC_WC_NO | PC Well Completion Number | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | * | OIU_PC_WC_NO | Allow NULL? |
| 28 | PC_MP_NO | PC Measurement point number | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | * | OIU_PC_MP_NO | Allow NULL? |
| 29 | PC_CONDITION | Condition type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | KSCHA | Allow NULL? |
| 30 | KALSM | Sales and Distribution: Pricing Procedure in Pricing | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | * | KALSMASD | Allow NULL? |
| 31 | RVRS_ONLY_FL | Reversal Only Flag | char | 1 | 0 | CHAR | (N' ') | Yes | | OIUVL_RVSL_ONLY_FL | Allow NULL? |
| 32 | OIU_CRUSER | Name of Person who Created the Object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | ERNAM | Allow NULL? |
| 33 | OIU_TIMESTAMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | DEC | ((0)) | Yes | | TZNTSTMPS | |