| 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 | DOC_NO | Val. document number | nvarchar | 20 | 0 | CHAR | (N' ') | No | * | OIURV_DOCNR | Allow NULL? |
| 3 | DOC_YEAR | Document year | nvarchar | 4 | 0 | NUMC | (N'0000') | No | | OIU_DOC_YEAR | Allow NULL? |
| 4 | SEQ_NO | Document Line Number | nvarchar | 5 | 0 | NUMC | (N'00000') | No | | OIU_DOC_LINENR | Allow NULL? |
| 5 | LINE_NO | Document Line Number | nvarchar | 5 | 0 | NUMC | (N'00000') | No | | OIU_DOC_LINENR | Allow NULL? |
| 6 | DN_NO | Delivery network number | nvarchar | 20 | 0 | CHAR | (N' ') | No | OIU_PR_DN | OIU_DN_NO | Allow NULL? |
| 7 | SALE_DT | Sales Date / Month | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | OIU_SALE_DT | Allow NULL? |
| 8 | FREQ_CD | Frequency | char | 1 | 0 | CHAR | (N' ') | Yes | | OIU_FREQ_CD | Allow NULL? |
| 9 | WL_NO | Well ID number | nvarchar | 15 | 0 | CHAR | (N' ') | No | OIU_PR_WELL | OIU_WL_NO | Allow NULL? |
| 10 | WC_NO | Well Completion Number | nvarchar | 5 | 0 | CHAR | (N' ') | No | OIU_PR_WC | OIU_WC_NO | Allow NULL? |
| 11 | MP_NO | Measurement point number | nvarchar | 20 | 0 | CHAR | (N' ') | No | OIU_PR_MP | OIU_MP_NO | Allow NULL? |
| 12 | MATNR | Material Number | nvarchar | 18 | 0 | CHAR | (N' ') | No | OIU_CM_MAT_PRCD | MATNR | Allow NULL? |
| 13 | BUKRS | Company Code | nvarchar | 4 | 0 | CHAR | (N' ') | No | T001 | BUKRS | Allow NULL? |
| 14 | VNAME | Joint Venture | nvarchar | 6 | 0 | CHAR | (N' ') | No | OIU_DO_JV | JV_NAME | Allow NULL? |
| 15 | DOI_NO | Division of interest (DOI) | nvarchar | 5 | 0 | CHAR | (N' ') | No | OIU_DO_DI | OIU_DOI_NO | Allow NULL? |
| 16 | CT_NO | Contract Number | nvarchar | 10 | 0 | CHAR | (N' ') | No | OIU_RV_CT | OIU_CT_NO | Allow NULL? |
| 17 | CT_TYPE_CD | Contract Type | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | OIU_CT_TYPE_CD | Allow NULL? |
| 18 | UNIT_VNAME | Joint Venture | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | * | JV_NAME | Allow NULL? |
| 19 | MAJPD_CD | Major product code | char | 1 | 0 | CHAR | (N' ') | No | | OIU_MAJPD_CD | Allow NULL? |
| 20 | SCHOOL_DIST_CD | School district code | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | OIU_SCHOOL_DIST_CD | Allow NULL? |
| 21 | TAX_CLASS | Tax Class | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | OIU_TAX_CLS | Allow NULL? |
| 22 | VL_TYPE_CD | Volume type code | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | OIU_VT_CD | Allow NULL? |
| 23 | VL_CLS_CD | Volume class code | char | 1 | 0 | CHAR | (N' ') | Yes | | OIU_VC_CD | Allow NULL? |
| 24 | LVL_CD | Level Code | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | OIU_LVL_CD | Allow NULL? |
| 25 | WI_OWN_NO | Working Interest Owner | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | OIU_WI_OWN_NO | Allow NULL? |
| 26 | WI_INT_TYPE_CD | Participant Interest Type | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | OIU_PART_INT_TYPE | Allow NULL? |
| 27 | WI_OWN_ISQ_NO | Owner Interest Sequence Number | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | OIU_OWN_ISQ_NO | Allow NULL? |
| 28 | NI_OWN_NO | Net Interest Owner | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | OIU_NI_OWN_NO | Allow NULL? |
| 29 | NI_INT_TYPE_CD | Participant Interest Type | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | OIU_PART_INT_TYPE | Allow NULL? |
| 30 | NI_OWN_ISQ_NO | Owner Interest Sequence Number | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | OIU_OWN_ISQ_NO | Allow NULL? |
| 31 | ORIG_MP_NO | Original measurement point number | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | * | OIU_ORIG_MP_NO | Allow NULL? |
| 32 | MP_TYPE_CD | Measurement point type code | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | OIU_MP_TYPE_CD | Allow NULL? |
| 33 | FRML_NO | Formula number | nvarchar | 8 | 0 | CHAR | (N' ') | No | OIU_RV_FRML | OIU_FRML_NO | Allow NULL? |
| 34 | PPA_RSN_CD | Prior Period Adjustment Reason Code | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | OIU_CM_PPARSN | OIU_PPA_RSN_CD | Allow NULL? |
| 35 | REJ_RSN_CD | Rejection Reason Code | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | OIU_REJ_RSN_CD | Allow NULL? |
| 36 | REJ_ZV_CD | Valuation REJ ZV code | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | OIU_REJ_ZVCD | Allow NULL? |
| 37 | DOI_SUM_FL | Summarize RD to DOI Level Flag | char | 1 | 0 | CHAR | (N' ') | Yes | | OIU_DOI_SUM_FL | Allow NULL? |
| 38 | REJ_REPRCS_FL | Reject Reprocess Flag | char | 1 | 0 | CHAR | (N' ') | Yes | | OIU_REJ_REPRCS_FL | Allow NULL? |
| 39 | SYSTEM_SRCE_CD | Valuation Transaction Source Code | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | OIU_VL_SRCE_CD | Allow NULL? |
