| 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 | RPT_YYYYMM | Reporting Year and Month | nvarchar | 6 | 0 | NUMC | (N'000000') | No | | OIUREP_RPT_YYYYMM | Allow NULL? |
| 3 | RSG | Report Submission Group | nvarchar | 4 | 0 | CHAR | (N' ') | No | | OIUX1_RSG | Allow NULL? |
| 4 | AGENCY | Agency for Reporting | nvarchar | 3 | 0 | CHAR | (N' ') | No | | OIUX1_TAX_AGENCY | Allow NULL? |
| 5 | OGIND | Oil and Gas Indicator | char | 1 | 0 | CHAR | (N' ') | No | | OIUREP_OIL_GAS_IND | Allow NULL? |
| 6 | SALES_YYYYMM | Sales YYYYMM | nvarchar | 6 | 0 | NUMC | (N'000000') | No | | OIUREP_SALES_YYYYMM | Allow NULL? |
| 7 | BUKRS | Company Code | nvarchar | 4 | 0 | CHAR | (N' ') | No | * | BUKRS | Allow NULL? |
| 8 | VNAME | Joint Venture | nvarchar | 6 | 0 | CHAR | (N' ') | No | * | JV_NAME | Allow NULL? |
| 9 | DOI_NO | Division of interest (DOI) | nvarchar | 5 | 0 | CHAR | (N' ') | No | * | OIU_DOI_NO | Allow NULL? |
| 10 | WL_NO | Well ID number | nvarchar | 15 | 0 | CHAR | (N' ') | No | * | OIU_WL_NO | Allow NULL? |
| 11 | WC_NO | Well Completion Number | nvarchar | 5 | 0 | CHAR | (N' ') | No | * | OIU_WC_NO | Allow NULL? |
| 12 | MP_NO | Measurement point number | nvarchar | 20 | 0 | CHAR | (N' ') | No | * | OIU_MP_NO | Allow NULL? |
| 13 | AGENCY_VOL_TYPE | Agency defined Volume type | nvarchar | 2 | 0 | CHAR | (N' ') | No | | OIUREP_AGENCY_VOL_TYPE | Allow NULL? |
| 14 | AGENCY_TAX_CODE | Agency defined Tax Code for Reporting | nvarchar | 4 | 0 | CHAR | (N' ') | No | | OIUX1_AGENCY_TAX_CODE | Allow NULL? |
| 15 | PDIND | Purchaser/Producer Indicator | char | 1 | 0 | CHAR | (N' ') | No | | OIUX1_PDIND | Allow NULL? |
| 16 | AFFL_COMP | Company Code | nvarchar | 4 | 0 | CHAR | (N' ') | No | * | BUKRS | Allow NULL? |
| 17 | TAXH_SYSNO | Tax Reporting History Sysno | nvarchar | 20 | 0 | NUMC | (N'00000000000000000000') | Yes | | OIUX1_TAXH_SYSNO | Allow NULL? |
| 18 | DOC_YEAR | Document year | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | OIU_DOC_YEAR | Allow NULL? |
| 19 | DOC_NO | Val. document number | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | * | OIURV_DOCNR | Allow NULL? |
| 20 | SEV_TAX_PAY_FL | Tax Severance Tax Calculation Payment Obligations Types | char | 1 | 0 | CHAR | (N' ') | Yes | | OIU_SEVT_PAY_FL | Allow NULL? |
| 21 | SEV_TAX_RPT_FL | State Severance Tax Reporting Indicators | char | 1 | 0 | CHAR | (N' ') | Yes | | OIU_SEVT_RPT_FL | Allow NULL? |
| 22 | UNIT_VNAME | Joint Venture | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | * | JV_NAME | Allow NULL? |
| 23 | SEC_GEO_LOC | Secondary geographic location | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | OIU_SEC_GEO_LOC | Allow NULL? |
| 24 | GRV_AM | Oil/gas density at standard/base conditions | float | 15 | 16 | FLTP | ((0)) | Yes | | OIB_BDICH | |
| 25 | ACTL_TXVL | Actual taxable volume | decimal | 13 | 3 | QUAN | ((0)) | Yes | | OIUVL_ACTL_TXVL | |
| 26 | ACTL_OVRD_TAXVL | Actual override taxable volume | decimal | 13 | 3 | QUAN | ((0)) | Yes | | OIUVL_ACTL_OVRD_TAX_VL | |
| 27 | ACTL_GR_VL | Actual Gross Volume Amount | decimal | 13 | 3 | QUAN | ((0)) | Yes | | OIU_ACTL_GR_VL_AM | |
| 28 | TAX_FREE_05_VL | Tax free 05 volume | decimal | 13 | 3 | QUAN | ((0)) | Yes | | OIUVL_TAX_FREE_VL | |
| 29 | BLPS_GR_VL | Before lease plant split gross volume | decimal | 13 | 3 | QUAN | ((0)) | Yes | | OIUVL_BLPS_GR_VL | |
| 30 | ACTL_GR_VL_U | Measurement unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | * | OIU_MEAS_U | Allow NULL? |
| 31 | ACTL_WLR_VL_AM | Act. Wet-less-Residue Vol. Amount | decimal | 13 | 3 | QUAN | ((0)) | Yes | | OIU_ACTL_WLR_VL_AM | |
| 32 | TAX_FREE_05_WLR | Tax free 05 wet-less-residue | decimal | 13 | 3 | QUAN | ((0)) | Yes | | OIUVL_TAX_FREE_WLR | |
| 33 | ACTL_WLR_VL_AM_U | Measurement unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | * | OIU_MEAS_U | Allow NULL? |
| 34 | ACTL_ENERGY | Actual Energy | decimal | 13 | 3 | QUAN | ((0)) | Yes | | OIU_ACTL_ENERGY | |
| 35 | ACTL_ENERGY_U | Actual Energy Unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | * | OIU_ACTL_ENERGY_U | Allow NULL? |
| 36 | FX_MCD | Fixed marketing cost deduction | decimal | 15 | 2 | CURR | ((0)) | Yes | | OIUVL_FX_MCD | |
| 37 | ACTL_GR_VAL_AM | Actual Gross Value Amount | decimal | 13 | 2 | CURR | ((0)) | Yes | | OIU_ACTL_GR_VAL_AM | |
| 38 | TAX_FREE_05_VAL | Tax free 05 value | decimal | 15 | 2 | CURR | ((0)) | Yes | | OIUVL_TAX_FREE_VAL | |
| 39 | BLPS_GR_VAL | Before lease plant split gross value | decimal | 15 | 2 | CURR | ((0)) | Yes | | OIUVL_BLPS_GR_VAL | |
| 40 | ST_TAX_PROC_ALLW | State tax processing allowance | decimal | 15 | 2 | CURR | ((0)) | Yes | | OIUVL_ST_TAX_PROC_ALLOW | |
| 41 | ACTL_TXVAL | Actual taxable value | decimal | 15 | 2 | CURR | ((0)) | Yes | | OIUVL_ACTL_TXVAL | |
| 42 | ACTL_OVRD_TAXVAL | Actual override taxable value | decimal | 15 | 2 | CURR | ((0)) | Yes | | OIUVL_ACTL_OVRD_TAX_VAL | |
| 43 | ACTL_ST_TAX_AM | Actual state tax amount | decimal | 15 | 2 | CURR | ((0)) | Yes | | OIUVL_ACTL_ST_TAX_AM | |
| 44 | ACTL_ST_TAX_RMB | Actual state tax reimbursement | decimal | 15 | 2 | CURR | ((0)) | Yes | | OIUVL_ACTL_ST_TAX_REIMB | |
| 45 | GR_VAL_CURR | Currency Key | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | WAERS | Allow NULL? |
| 46 | USERNAME | Name of Person who Created the Object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | ERNAM | Allow NULL? |
| 47 | TIMESTAMP | Time stamp in Numeric Character | nvarchar | 14 | 0 | NUMC | (N'00000000000000') | Yes | | OIUX1_TIMESTAMP | Allow NULL? |
| 48 | PU_NO | Purchaser | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | OIU_PU_NO | Allow NULL? |
