OIUREP_MRT_HIST - MMS-2014 MMS Royalty Transaction Processed History
MMS-2014 MMS Royalty Transaction Processed History information is stored in SAP table OIUREP_MRT_HIST.
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_MRT_HIST
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| .INCLUDE | X | ROIUREP_MMS_2014_REP_DTL_KEY | 0 | |||
| MANDT | Client | X | MANDT | CLNT | 6 | T000 |
| DOC_ID | Production: MMS-2104 - Document ID | X | OIUREP_MMS_2014_DOC_ID | CHAR | 16 | |
| DET_LINE_NO | Line Number | X | OIU_LIN_NO | NUMC | 10 | |
| .INCLUDE | ROIUREP_MMS_2014_REP_DTL_NON | 0 | ||||
| BUKRS | Company Code | BUKRS | CHAR | 8 | T001 | |
| PAYOR_NO | Production: MMS-2014 - Payor | OIUREP_MMS_2014_PAYOR | CHAR | 10 | ||
| SALES_YEAR | MMS-2014 - Year | OIUREP_MMS_2014_YEAR | NUMC | 8 | ||
| SALES_MONTH | MMS-2014 - Month | OIUREP_MMS_2014_MONTH | NUMC | 4 | ||
| FED_INDIAN_CD | Production: MMS-2014 - Federal or Indian Code | OIUREP_MMS_2014_FED_INDIAN_CD | CHAR | 2 | ||
| RESERV_SPACE | Production: MMS-2104 - Reserve Space | OIUREP_MMS_2014_RESERV_SPACE | CHAR | 40 | ||
| 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 | |
| API_WELL_NO | API well number | OIU_WLAPI | CHAR | 24 | ||
| API_WELL_CM_NO | API well completion number | OIU_API_WC_NO | CHAR | 6 | ||
| 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 | |
| TRANS_CD | Production: MMS-2014 - Transaction Code | OIUREP_MMS_2014_TRANS_CD | CHAR | 4 | ||
| ADJ_CD | Production: MMS-2014 - Adjustment Reason Code | OIUREP_MMS_2014_ADJ_CD | NUMC | 4 | ||
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| PAY_METHOD_CD | Production: MMS-2014 - Payment Method Code | OIUREP_MMS_2014_PAY_METHOD_CD | CHAR | 2 | ||
| INDIAN_TRIBE_NO | Production: MMS-2014 - Indian Tribe Number | OIUREP_MMS_2014_INDN_TRIBE_NO | CHAR | 4 | OIUREP_INDIAN_TR | |
| REVERSAL_FL | Production: MMS-2014 - Reversal History Flag | OIUREP_MMS_2014_REVERSAL_FL | CHAR | 2 | ||
| REVERSAL_YEAR | MMS-2014 - Year | OIUREP_MMS_2014_YEAR | NUMC | 8 | ||
| REVERSAL_MONTH | MMS-2014 - Month | OIUREP_MMS_2014_MONTH | NUMC | 4 | ||
| SALES_DATE | Sales Date / Month | OIU_SALE_DT | DATS | 16 | ||
| .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 |