OIUREP_RTPEND - MMS-2014 - Royalty Transaction Pending
MMS-2014 - Royalty Transaction Pending information is stored in SAP table OIUREP_RTPEND.
It is part of development package OIU_REP in software component IS-OIL-PRA-REP-ROY. This development package consists of objects that can be grouped under "Production, Tax & Royalty Reporting".
It is part of development package OIU_REP in software component IS-OIL-PRA-REP-ROY. This development package consists of objects that can be grouped under "Production, Tax & Royalty Reporting".
Fields for table OIUREP_RTPEND
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| .INCLUDE | X | ROIUREP_MMS_2014_RT_KEY | 0 | |||
| MANDT | Client | X | MANDT | CLNT | 6 | T000 |
| BUKRS | Company Code | X | BUKRS | CHAR | 8 | T001 |
| SALES_YEAR | MMS-2014 - Year | X | OIUREP_MMS_2014_YEAR | NUMC | 8 | |
| SALES_MONTH | MMS-2014 - Month | X | OIUREP_MMS_2014_MONTH | NUMC | 4 | |
| RTP_LINE_NUM | MMS-2014 - Line Number | X | OIUREP_MMS_2014_LINE_NO | NUMC | 20 | |
| .INCLUDE | ROIUREP_MMS_2014_RT_NON | 0 | ||||
| PAYOR_NO | Production: MMS-2014 - Payor | OIUREP_MMS_2014_PAYOR | CHAR | 10 | ||
| FED_INDIAN_CD | Production: MMS-2014 - Federal or Indian Code | OIUREP_MMS_2014_FED_INDIAN_CD | CHAR | 2 | ||
| INDIAN_TRIBE_NO | Production: MMS-2014 - Indian Tribe Number | OIUREP_MMS_2014_INDN_TRIBE_NO | CHAR | 4 | OIUREP_INDIAN_TR | |
| API_WELL_NO | API well number | OIU_WLAPI | CHAR | 24 | ||
| API_WELL_CM_NO | API well completion number | OIU_API_WC_NO | CHAR | 6 | ||
| LEASE_NO | MMS-2014 - Lease Number | OIUREP_MMS_2014_LEASE_NO | CHAR | 22 | OIUREP_FEDINDIAN | |
| AGREEMENT_NO | Production: MMS-2014 - Agreement Number | OIUREP_MMS_2014_AGREEMENT_NO | CHAR | 22 | OIUREP_LEASE | |
| MMS_PROD_CD | Production: MMS Product Code | OIUREP_MMS_PRODUCT_CODE | CHAR | 4 | ||
| SALES_TYPE_CD | Production: MMS-2014 - Sales Type Code | OIUREP_MMS_2014_SALES_TYPE_CD | CHAR | 8 | OIUREP_SALESTY | |
| SALES_DATE | Sales Date / Month | OIU_SALE_DT | DATS | 16 | ||
| TRANS_CD | Production: MMS-2014 - Transaction Code | OIUREP_MMS_2014_TRANS_CD | CHAR | 4 | ||
| PAY_METHOD_CD | Production: MMS-2014 - Payment Method Code | OIUREP_MMS_2014_PAY_METHOD_CD | CHAR | 2 | ||
| WL_NO | Well ID number | OIU_WL_NO | CHAR | 30 | OIU_PR_WELL | |
| WC_NO | Well Completion Number | OIU_WC_NO | CHAR | 10 | OIU_PR_WC | |
| VNAME | MMS-2014 - Venture | OIUREP_MMS_2014_PROPERTY | CHAR | 12 | OIU_DO_JV | |
| DOI_NO | Division of interest (DOI) | OIU_DOI_NO | CHAR | 10 | OIU_DO_DI | |
| PU_NO | Purchaser | OIU_PU_NO | CHAR | 20 | * | |
| PU_SEQ_NO | Purchasing Representative Interest Sequence No | OIU_PU_REP_ISQ_NO | CHAR | 4 | ||
| PU_AFFIL_FL | Production: MMS-2014 - Purchaser Affiliation Flag | OIUREP_MMS_2014_PU_AFFIL_FL | CHAR | 2 | ||
| MATNR | Material Number | MATNR | CHAR | 80 | OIU_CM_MAT_PRCD | |
| OWN_NO | PRA owner | OIU_OWN_NO | CHAR | 20 | LFA1 | |
| OWN_ISQ_NO | Owner Interest Sequence Number | OIU_OWN_ISQ_NO | CHAR | 4 | ||
| CT_NO | Contract Number | OIU_CT_NO | CHAR | 20 | OIUCM_CONTRACT | |
| GL_ACCTID_NO | Account ID | OIUH_ACCTID | CHAR | 20 | ||
| NWK_NO | Network Number | OIUREP_MMS_2014_NWK_NO | CHAR | 8 | ||
| SUB_NWK_NO | Sub Network Number | OIUREP_MMS_2014_SUB_NWK_NO | CHAR | 8 | ||
| INT_TYPE_CD | Interest Type Code | OIUREP_MMS_2014_INT_TYPE_CD | CHAR | 4 | ||
| INT_SEQ_NO | Interest Sequence Number | OIUREP_MMS_2014_INT_SEQ_NO | CHAR | 4 | ||
| SALES_QY | Sales Quantity | OIUREP_MMS_2014_SALES_QY | QUAN | 7 | ||
| SALES_QY_U | Production: MMS-2014 - Sales Qty Unit | OIUREP_MMS_2014_SALES_QY_U | UNIT | 6 | T006 | |
| SALES_GV_QY | Production: MMS-2014 - Sales Gravity Qty | OIUREP_MMS_2014_SALES_GV_QY | QUAN | 3 | ||
| SALES_GV_QY_U | Production: MMS-2014 - Sales Gravity Qty Unit | OIUREP_MMS_2014_SALES_GV_QY_U | UNIT | 6 | T006 | |
| SALES_BTU_QY | Production: MMS-2014 - Sales BTU Quantity | OIUREP_MMS_2014_SALES_BTU_QY | QUAN | 7 | ||
| SALES_BTU_QY_U | Production: MMS-2014 - Sales BTU Qty Unit | OIUREP_MMS_2014_SALES_BTU_QY_U | UNIT | 6 | T006 | |
| SALES_PS_BASE_QY | Pressure Base | OIU_PS_BASE | QUAN | 7 | ||
| SALES_PS_BASE_U | Pressure Base Unit | OIU_PS_BASE_U | UNIT | 6 | T006 | |
| SALES_AMT | Production: MMS-2014 - Sales Amount | OIUREP_MMS_2014_SALES_AMT | CURR | 8 | ||
| SALES_CUR | Production: MMS-2014 - Sales Currency | OIUREP_MMS_2014_SALES_CUR | CUKY | 10 | TCURC | |
| ROY_PR_ALW_AMT | Production: MMS-2014 - Royalty Value Prior to Allows. Amt | OIUREP_MMS_2014_ROY_PR_ALW_AMT | CURR | 8 | ||
| ROY_PR_ALW_CUR | Production: MMS-2014 - Royalty Value Prior to Allows. Curr | OIUREP_MMS_2014_ROY_PR_ALW_CUR | CUKY | 10 | TCURC | |
| TRNSP_ALW_DE_AMT | Production: MMS-2014 - Transportation Allowance Amount | OIUREP_MMS_2014_TRNSP_ALLW_AMT | CURR | 8 | ||
| TRNSP_ALW_DE_CUR | MMS-2014 - Transportation Allowance Currency | OIUREP_MMS_2014_TRNSP_ALLW_CUR | CUKY | 10 | TCURC | |
| PROC_ALW_DE_AMT | Production: MMS-2014 - Manufacturing UOM Amount | OIUREP_MMS_2014_MFRING_UOM_AMT | CURR | 8 | ||
| PROC_ALW_DE_CUR | Production: MMS-2014 - Manufacturing UOM Currency | OIUREP_MMS_2014_MFRING_UOM_CUR | CUKY | 10 | TCURC | |
| ROY_LS_ALLOW_AMT | Production: MMS-2014 - Royalty Value Less Allows. Amt | OIUREP_MMS_2014_ROY_LS_ALW_AMT | CURR | 8 | ||
| ROY_LS_ALLOW_CUR | Production: MMS-2014 - Royalty Value Less Allows Curr | OIUREP_MMS_2014_ROY_LS_ALW_CUR | CUKY | 10 | TCURC | |
| ROY_QY | Production: MMS-2014 - Royalty Quantity | OIUREP_MMS_2014_ROY_QY | QUAN | 7 | ||
| ROY_QY_U | Production: MMS-2014 - Royalty Quantity Unit | OIUREP_MMS_2014_ROY_QY_U | UNIT | 6 | T006 | |
| DED_REMB_AMT | Production: MMS-2014 - Deduction Reimbursement Amount | OIUREP_MMS_2014_DED_REMB_AMT | CURR | 8 | ||
| DED_REMB_CUR | Production: MMS-2014 - Deduction Reimbursement Currency | OIUREP_MMS_2014_DED_REMB_CUR | CUKY | 10 | TCURC | |
| TAX_AMT | Production: MMS-2014 - Tax Amount | OIUREP_MMS_2014_TAX_AMT | CURR | 8 | ||
| TAX_CUR | Production: MMS-2014 - Tax Currency | OIUREP_MMS_2014_TAX_CUR | CUKY | 10 | TCURC | |
| TAX_REMB_AMT | Production: MMS-2014 - Tax Reimbursement Amount | OIUREP_MMS_2014_TAX_REMB_AMT | CURR | 8 | ||
| TAX_REMB_CUR | Production: MMS-2014 - Tax Reimbursement Currency | OIUREP_MMS_2014_TAX_REMB_CUR | CUKY | 10 | TCURC | |
| MMS_ROY_QY | Production: MMS-2014 - MMS Royalty Quantity | OIUREP_MMS_2014_MMS_ROY_QY | QUAN | 7 | ||
| MMS_ROY_QY_U | Production: MMS-2014 - MMS Royalty Quantity Unit | OIUREP_MMS_2014_MMS_ROY_QY_U | UNIT | 6 | T006 | |
| MMS_PS_BASE_QY | Pressure Base | OIU_PS_BASE | QUAN | 7 | ||
| MMS_PS_BASE_QY_U | Pressure Base Unit | OIU_PS_BASE_U | UNIT | 6 | T006 | |
| MMS_ROY_AMT | MMS-2014 - JE Offset Amount | OIUREP_MMS_2014_MMS_ROY_AMT | CURR | 8 | ||
| MMS_ROY_CUR | MMS-2014 - JE Offset Currency | OIUREP_MMS_2014_MMS_ROY_CUR | CUKY | 10 | TCURC | |
| MMS_SA_QY | Production: MMS-2014 - MMS Sales Quantity | OIUREP_MMS_2014_MMS_SA_QY | QUAN | 7 | ||
| MMS_SA_QY_U | Production: MMS-2014 - MMS Sales Quantity Unit | OIUREP_MMS_2014_MMS_SA_QY_U | UNIT | 6 | T006 | |
| MMS_SA_AMT | Production: MMS-2014 - MMS Sales Amount | OIUREP_MMS_2014_MMS_SA_AMT | CURR | 8 | ||
| MMS_SA_CUR | Production: MMS-2014 - MMS Sales Currency | OIUREP_MMS_2014_MMS_SA_CUR | CUKY | 10 | TCURC | |
| SUSPEND_RSN_CD | Suspense Reason Code | OIU_SUSP_CD | CHAR | 6 | OIU_CM_SUSP | |
| ADJ_CD | Production: MMS-2014 - Adjustment Reason Code | OIUREP_MMS_2014_ADJ_CD | NUMC | 4 | ||
| ADJ_SA_QY | Production: MMS-2014 - Adjusted Sales Quantity | OIUREP_MMS_2014_ADJ_SA_QY | QUAN | 7 | ||
| ADJ_SA_QY_U | Production: MMS-2014 - Adjusted Sales Quantity Unit | OIUREP_MMS_2014_ADJ_SA_QY_U | UNIT | 6 | T006 | |
| ADJ_ROY_QY | Production: MMS-2014 - Adjusted Royalty Quantity | OIUREP_MMS_2014_ADJ_ROY_QY | QUAN | 7 | ||
| ADJ_ROY_QY_U | Production: MMS-2014 - Adjusted Royalty Quantity Unit | OIUREP_MMS_2014_ADJ_ROY_QY_U | UNIT | 6 | T006 | |
| ADJ_BTU_QY | Production: MMS-2014 - Adjusted BTU Quantity | OIUREP_MMS_2014_ADJ_BTU_QY | QUAN | 7 | ||
| ADJ_BTU_QY_U | Production: MMS-2014 - Adjusted BTU Quantity Unit | OIUREP_MMS_2014_ADJ_BTU_QY_U | UNIT | 6 | T006 | |
| GAS_MMBTU_QY | Production: MMS-2014 - Gas MMBTU Qty | OIUREP_MMS_2014_GAS_MMBTU_QY | QUAN | 7 | ||
| GAS_MMBTU_QY_U | Production: MMS-2014 - Gas MMBTU Qty Unit | OIUREP_MMS_2014_GAS_MMBTU_QY_U | UNIT | 6 | T006 | |
| HISTORY_FL | Production: MMS-2014 - History Flag | OIUREP_MMS_2014_HISTORY_FL | CHAR | 2 | ||
| REPORT_PART_FAC | Production: MMS-2014 - Report Participation Factor | OIUREP_MMS_2014_RPT_PART_FAC | DEC | 5 | ||
| TRIBAL_ALLOT_CD | Production: MMS-2014 - Tribal/Allottee Code | OIUREP_MMS_2014_TRIB_ALLOT_CD | CHAR | 2 | ||
| COMP_ROY_FL | Production: MMS-2014 - Compensatory Royalty Flag | OIUREP_MMS_2014_COMP_ROY_FL | CHAR | 2 | ||
| ROY_IN_KIND_FL | Production: MMS-2014 - Royalty In Kind Flag | OIUREP_MMS_2014_ROY_IN_KIND_FL | CHAR | 2 | ||
| PAY_CD | Production: MMS-2014 - Payment Code | OIUREP_MMS_2014_PAY_CD | CHAR | 4 | ||
| EXTRACTED_FL | MMS-2014: Extracted | OIUREP_MMS_2014_EXTRACTED_FL | CHAR | 2 | ||
| EXTRACT_RUN_TYPE | Defines whether the run is direct pay or not | OIUREP_MMS_2014_RUN_TYPE | CHAR | 2 | ||
| MANUAL_CREATE_FL | Manually Created Entry Flag | CHAR | 2 | |||
| .INCLUDE | OIU_CREATION | 0 | ||||
| OIU_CRUSER | Name of Person Responsible for Creating the Object | ERNAM | CHAR | 24 | ||
| OIU_TIMESTAMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TZNTSTMPS | DEC | 8 | ||
| .INCLUDE | ROIUCM_CHANGE | 0 | ||||
| CHANGE_USER | Name of Person Who Changed Object | AENAM | CHAR | 24 | ||
| CHANGE_TIMESTAMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TZNTSTMPS | DEC | 8 | ||
| COST_CENTER | PRA Cost Center | OIUCM_KOSTL | CHAR | 20 | ||
| VL_TYPE_CD | Volume Type Code | OIU_VL_TYPE_CD | CHAR | 4 | ||
| ALT_CT_NO | ONRR MPP: Pricing Contract Number | OIU_PRIC_CT_NO | CHAR | 20 |