| 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 | SYS_NO | Severance tax number | nvarchar | 20 | 0 | NUMC | (N'00000000000000000000') | No | | OIUVL_SEV_NO | Allow NULL? |
| 3 | PRI_GEO_LOC | Primary geographical location (PRI geo. loc.) | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | OIU_PRI_GEO_LOC | Allow NULL? |
| 4 | WL_NO | Well ID number | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | * | OIU_WL_NO | Allow NULL? |
| 5 | WC_NO | Well Completion Number | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | * | OIU_WC_NO | Allow NULL? |
| 6 | MP_NO | Measurement point number | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | * | OIU_MP_NO | Allow NULL? |
| 7 | DN_NO | Delivery network number | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | * | OIU_DN_NO | Allow NULL? |
| 8 | MATNR | Material Number | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | * | MATNR | Allow NULL? |
| 9 | MAJPD_CD | Major product code | char | 1 | 0 | CHAR | (N' ') | Yes | | OIU_MAJPD_CD | Allow NULL? |
| 10 | BUKRS | Company Code | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | BUKRS | Allow NULL? |
| 11 | VNAME | Joint Venture | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | * | JV_NAME | Allow NULL? |
| 12 | DOI_NO | Division of interest (DOI) | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | * | OIU_DOI_NO | Allow NULL? |
| 13 | CT_NO | Contract Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | OIU_CT_NO | Allow NULL? |
| 14 | VL_TYPE_CD | Volume type code | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | OIU_VT_CD | Allow NULL? |
| 15 | PU_NO | Purchaser | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | OIU_PU_NO | Allow NULL? |
| 16 | SALE_DT | Sales Date / Month | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | OIU_SALE_DT | Allow NULL? |
| 17 | SEC_GEO_LOC | Secondary geographic location | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | OIU_SEC_GEO_LOC | Allow NULL? |
| 18 | SCHOOL_DIST_CD | School district code | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | OIU_SCHOOL_DIST_CD | Allow NULL? |
| 19 | TAX_CLS | Tax Class | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | OIU_TAX_CLS | Allow NULL? |
| 20 | PPA_RSN_CD | Prior Period Adjustment Reason Code | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | OIU_PPA_RSN_CD | Allow NULL? |
| 21 | RPT_FL | Report flag | char | 1 | 0 | CHAR | (N' ') | Yes | | OIUVL_RPT_FL | Allow NULL? |
| 22 | RVRS_FL | Reversal Flag | char | 1 | 0 | CHAR | (N' ') | Yes | | OIUVL_RVRS_FL | Allow NULL? |
| 23 | ACTL_GR_VL | Actual Gross Volume Amount | decimal | 13 | 3 | QUAN | ((0)) | Yes | | OIU_ACTL_GR_VL_AM | |
| 24 | ACTL_GR_VL_U | Measurement unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | * | OIU_MEAS_U | Allow NULL? |
| 25 | ACTL_ENERGY | Actual Energy | decimal | 13 | 3 | QUAN | ((0)) | Yes | | OIU_ACTL_ENERGY | |
| 26 | ACTL_ENERGY_U | Measurement unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | * | OIU_MEAS_U | Allow NULL? |
| 27 | BLPS_GR_VL | Before lease plant split gross volume | decimal | 13 | 3 | QUAN | ((0)) | Yes | | OIUVL_BLPS_GR_VL | |
| 28 | BLPS_GR_VAL | Before lease plant split gross value | decimal | 15 | 2 | CURR | ((0)) | Yes | | OIUVL_BLPS_GR_VAL | |
| 29 | ACTL_WLR_VL_AM | Act. Wet-less-Residue Vol. Amount | decimal | 13 | 3 | QUAN | ((0)) | Yes | | OIU_ACTL_WLR_VL_AM | |
| 30 | ACTL_GR_VAL_AM | Actual Gross Value Amount | decimal | 13 | 2 | CURR | ((0)) | Yes | | OIU_ACTL_GR_VAL_AM | |
| 31 | OWN_NO | PRA owner | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | OIU_OWN_NO | Allow NULL? |
| 32 | KO_ACTL_GRVL_AM | Actual Gross Volume Amount | decimal | 13 | 3 | QUAN | ((0)) | Yes | | OIU_ACTL_GR_VL_AM | |
| 33 | IKO_ACTL_WLR_AM | Actual Gross Volume Amount | decimal | 13 | 3 | QUAN | ((0)) | Yes | | OIU_ACTL_GR_VL_AM | |
| 34 | UOM | Base Unit of Measure | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | * | MEINS | Allow NULL? |
| 35 | OIU_CRUSER | Name of Person who Created the Object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | ERNAM | Allow NULL? |
| 36 | OIU_TIMESTAMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | DEC | ((0)) | Yes | | TZNTSTMPS | |
| 37 | ACCT_DT | Accounting date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | OIUVL_ACCT_DT | Allow NULL? |
