OIUY3_TX_ROYSTG - Royalty 2.0 - TX GLO - Royalty Transactions (Staging)
Royalty 2.0 - TX GLO - Royalty Transactions (Staging) information is stored in SAP table OIUY3_TX_ROYSTG.
It is part of development package OIU_Y3 in software component IS-OIL-PRA-REP-ROY. This development package consists of objects that can be grouped under "Royalty 2.0 - Texas GLO/TAMU".
It is part of development package OIU_Y3 in software component IS-OIL-PRA-REP-ROY. This development package consists of objects that can be grouped under "Royalty 2.0 - Texas GLO/TAMU".
Fields for table OIUY3_TX_ROYSTG
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | Client | X | MANDT | CLNT | 6 | T000 |
| .INCLUDE | ROIUY3_TX_ROYTXN_KEY | X | ROIUY3_TX_ROYTXN_KEY | 0 | ||
| .INCLUDE | ROIUY3_TX_REVTXN_KEY | X | ROIUY3_TX_REVTXN_KEY | 0 | ||
| BUKRS | Company Code | X | BUKRS | CHAR | 8 | OIU_CM_COMPC |
| SALES_DT | Sales Date / Month | X | OIU_SALE_DT | DATS | 16 | |
| PDCD | Full three char. product code (Major and Detail Products) | X | OIU_FULL_PD_CD | CHAR | 6 | OIUX3_PDCD |
| WL_NO | Well ID number | X | OIU_WL_NO | CHAR | 30 | OIU_PR_WELL |
| WC_NO | Well Completion Number | X | OIU_WC_NO | CHAR | 10 | OIU_PR_WC |
| MP_NO | Measurement point number | X | OIU_MP_NO | CHAR | 40 | OIU_PR_MP |
| VNAME | Joint venture | X | JV_NAME | CHAR | 12 | OIU_DO_JV |
| DOI_NO | Division of interest (DOI) | X | OIU_DOI_NO | CHAR | 10 | OIU_DO_DI |
| DN_NO | Delivery network number | X | OIU_DN_NO | CHAR | 40 | OIU_PR_DN |
| CT_NO | Contract Number | X | OIU_CT_NO | CHAR | 20 | OIU_RV_CT |
| VL_TYPE_CD | Volume type code | X | OIU_VT_CD | CHAR | 4 | OIU_PR_VLTYP |
| OWNER_IDENTIFIER | Royalty 2.0 - Owner Identifier | X | OIUYC_OWNER_IDENTIFIER | CHAR | 44 | |
| REV_BOOK_ADJ_IND | Royalty 2.0 - TX - Reversal/Booking/Reversal Adjustment/Adjs | X | OIUY3_REV_BOOK_REVADJ_ADJ_IND | CHAR | 2 | |
| .INCLUDE | ROIUY3_TX_ROYTXN_NONKEY | ROIUY3_TX_ROYTXN_NONKEY | 0 | |||
| UNIT_VNAME | Joint venture | JV_NAME | CHAR | 12 | * | |
| ACCT_NO | Account ID | OIUH_ACCTID | CHAR | 20 | ||
| CHV_RPT_CD | Template Cost Center | RKOSTL | CHAR | 20 | * | |
| UOM | Measurement unit | OIU_MEAS_U | UNIT | 6 | T006 | |
| PS_BASE_QY | Pressure Base Quantity | OIUH_PRESSURE_BASE | DEC | 4 | ||
| GRV_QY | Gravity | OIUH_GRAVITY | DEC | 2 | ||
| PAY_CD | Pay Code | OIUH_PAY_CODE | CHAR | 4 | ||
| OWN_INT_DECM_QY | Royalty 2.0 - TX GLO - Owner NRI | OIUY3_TX_OWNER_NRI | DEC | 5 | ||
| OWN_BAL_DECM_QY | Owner Disbursement (Balance) Decimal | OIUH_OWNER_DISBUR_DECIMAL | DEC | 5 | ||
| PU_NO | Purchaser ID | OIUH_PURCHASER | CHAR | 12 | ||
| PU_SEQ_NO | Purchaser Sequence Number | OIUH_PURCHASER_SEQUENCE_NUMBER | CHAR | 4 | ||
| AFFILIATED_SALE | Royalty 2.0 - TX GLO - Affiliated Sale Indicator | OIUY3_TX_AFFILIATED_SALE_IND | CHAR | 2 | ||
| .INCLUDE | ROIUY3_TX_ROYTXN_NONKEY_NUM | ROIUY3_TX_ROYTXN_NONKEY_NUM | 0 | |||
| GR_QY | Gross Volume | OIUX3_GROSS_VOLUME | DEC | 6 | ||
| GR_AM | Gross Value | OIUX3_GROSS_VALUE | CURR | 6 | ||
| TXN_VAL_AM | Royalty 2.0 - TX GLO - Owner Gross Value | OIUY3_TX_OWNER_GROSS_VALUE | CURR | 6 | ||
| TRANS_AM | JE Transaction Amount | OIUX3_TRANS_AMT | DEC | 6 | ||
| TRANS_QY | JE Transaction Quantity | OIUH_TRANS_QUANTITY | DEC | 6 | ||
| MMBTU_OVL_AM | Owner MMBTU | OIUH_OWNER_MMBTU | DEC | 6 | ||
| PLT_VL_GRED_AM | Gross Plant Volume Reduction amount | OIUH_GROSS_PLANT_VOLUME_RED_AM | DEC | 6 | ||
| PLT_VL_ORED_AM | Owner Plant Volume Reduction amount | OIUH_OWNER_PLANT_VOLUME_RED_AM | DEC | 6 | ||
| DED_RMB_AM | Deduction/Reimbursement Amount | OIUH_DED_REIMB_AMOUNT | CURR | 6 | ||
| NET_TRANSP_AM | Marketing Cost | OIUX3_MARKETING_COST | CURR | 6 | ||
| NET_OTH_MK_AM | Marketing Cost | OIUX3_MARKETING_COST | CURR | 6 | ||
| TAX_RMB_AM | Tax Reimbursement Amount | OIUH_TAX_REIMBURSEMENT_AMT | CURR | 6 | ||
| TAX_AM | Tax amount | OIUH_TAX_AMOUNT | CURR | 6 | ||
| BTU_QY | BTU Quantity | OIUH_BTU_QUANTITY | DEC | 4 | ||
| .INCLUDE | ROIUY3_TX_ROYTXN_NONKEY_VAL | ROIUY3_TX_ROYTXN_NONKEY_VAL | 0 | |||
| ORIGINAL_REPORT | Royalty 2.0 - TX GLOTAMU - Original Report | OIUY3_TX_ORIGINAL_REPORT | CHAR | 2 | ||
| GAS_DISP_CODE | Royalty 2.0 - TX GLO/TAMU - Royalty Gas Disposition Code | OIUY3_TX_GLO_ROY_GAS_DISP_CODE | NUMC | 4 | ||
| MASTER_LEVEL | Royalty 2.0 - TX GLO - Master Level | OIUY3_TX_MASTER_LEVEL | CHAR | 2 | ||
| RRC_LEVEL | Royalty 2.0 - TX GLO - RRC Master Level | OIUY3_TX_RRC_LEVEL | CHAR | 2 | ||
| PURCHASER_ID | Royalty 2.0 - Texas GLO/TAMU - Purchaser ID | OIUY3_TX_PURCHASER_ID | NUMC | 22 | ||
| OPERATOR_ID | Royalty 2.0 - TX GLO - Operator ID | OIUY3_TX_OPERATOR_ID | CHAR | 20 | ||
| .INCLUDE | ROIUY3_TX_MASTER_SUBKEY | ROIUY3_TX_MASTER_SUBKEY | 0 | |||
| GLO_LEASE | Royalty 2.0 - TX GLO/TAMU Lease | OIUY3_TX_GLO_LEASE | NUMC | 12 | OIUY3_TX_LEASE | |
| GLO_UNIT_NO | Royalty 2.0 - Texas GLO/TAMU - Unit Number | OIUY3_TX_GLO_UNIT_NO | CHAR | 10 | OIUY3_TX_UNIT | |
| ROYALTY_DECIMAL | Royalty 2.0 - Texas GLO - Royalty Decimal | OIUY3_TX_ROYALTY_DECIMAL | DEC | 5 | ||
| UNIT_VNAME_FLAG | Roy 2.0 - Texas GLO/TAMU - Unit Venture | OIUY3_TX_UNIT_VNAME | CHAR | 2 | ||
| .INCLUDE | ROIUY3_TX_MASTER_NONKEY | ROIUY3_TX_MASTER_NONKEY | 0 | |||
| ALLOC_PERCENT | Royalty 2.0 - TX GLO/TAMU - Allocation Percent | OIUY3_TX_ALLOCATION_PERCENT | DEC | 5 | ||
| TRACT_PART_FACT | Royalty 2.0 - Texas GLO - Tract Participation Factor | OIUY3_TX_TRACT_PART_FACTOR | DEC | 5 | ||
| .INCLUDE | ROIUY3_TX_RRC_NONKEY | ROIUY3_TX_RRC_NONKEY | 0 | |||
| RRC_DISTRICT_NO | Royalty 2.0 - TX GLO/TAMU - District Number | OIUY3_TX_GLO_DISTRICT_NO | CHAR | 4 | ||
| RRC_OIL_LEASE_NO | Royalty 2.0 - TX GLO/TAMU - RRC Oil Lease Number | OIUY3_TX_GLO_RRC_OIL_LEASE_NO | CHAR | 10 | ||
| RRC_GAS_WELL_ID | Royalty 2.0 - TX GLO/TAMU - RRC Gas Well ID | OIUY3_TX_GLO_RRC_GAS_WELL_ID | CHAR | 12 | ||
| RRC_DRILL_PERMIT | Royalty 2.0 - TX GLO/TAMU - RRC Drilling Permit | OIUY3_TX_GLO_RRC_DRILLING_PERM | CHAR | 12 | ||
| RRC_FIELD_NAME | Royalty 2.0 - TX GLO/TAMU - RRC Field Name | OIUY3_TX_GLO_RRC_FIELD_NAME | CHAR | 64 | ||
| RRC_LEASE_NAME | Royalty 2.0 - TX GLO/TAMU - RRC Lease Name | OIUY3_TX_GLO_RRC_LEASE_NAME | CHAR | 64 | ||
| PROP_ALIAS_NAME | Royalty 2.0 - TX GLO/TAMU - Property Alias Name | OIUY3_TX_GLO_PROP_ALIAS_NAME | CHAR | 64 | ||
| OPERATOR_NO | Royalty 2.0 - TX GLO/TAMU - Operator Number | OIUY3_OPERATOR_NUMBER | CHAR | 12 | OIUH_CM_BA | |
| OPERATOR_SEQ_NO | Royalty 2.0 - TX GLO - Operator Sequence Number | OIUY3_OPERATOR_SEQUENCE_NUMBER | CHAR | 4 | ||
| PAY_REPORT_FLAG | Royalty 2.0 - TX GLO/TAMU - Pay/Report Flag | OIUY3_TX_PAY_REPORT_FLAG | CHAR | 2 | ||
| DOC_NO | Val. document number | OIURV_DOCNR | CHAR | 40 | * | |
| DOC_YEAR | Document year | OIU_DOC_YEAR | NUMC | 8 | ||
| INTERFACE_FL | Royalty 2.0 - TX GLO - Interface Flag | OIUY3_TX_INTERFACE_FL | CHAR | 2 | ||
| OPTION1 | CHAR | 2 | ||||
| OPTION2 | PPN Flag | CHAR | 2 | |||
| OPTION3 | CHAR | 2 | ||||
| REFERENCE_RUN_ID | Run ID of Tax Report | OIUX3_RUN_ID | NUMC | 20 | ||
| REJ_SUSP_IND | Rejection-Suspension Status | OIUX3_REJECT_SUSPEND_IND | CHAR | 2 | ||
| REJ_CD | Royalty 2.0 - Texas GLO - Reject Code | OIUY3_TX_REJECT_CODE | CHAR | 4 | OIUY3_TX_REJ | |
| .INCLUDE | OIU_CREATION | 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 |