/PRA/UTX_ROYSTG - Roy 2.0 - TX UT - Royalty Transactions (Staging)
Roy 2.0 - TX UT - Royalty Transactions (Staging) information is stored in SAP table /PRA/UTX_ROYSTG.
It is part of development package /PRA/UTX in software component IS-OIL-PRA-REP-ROY. This development package consists of objects that can be grouped under "Roy 2.0 Texas UT".
It is part of development package /PRA/UTX in software component IS-OIL-PRA-REP-ROY. This development package consists of objects that can be grouped under "Roy 2.0 Texas UT".
Fields for table /PRA/UTX_ROYSTG
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | Client | X | MANDT | CLNT | 6 | T000 |
| .INCLUDE | /PRA/UTX_S_ROYTXN_KEY | X | /PRA/UTX_S_ROYTXN_KEY | 0 | ||
| .INCLUDE | /PRA/UTX_S_REVTXN_KEY | X | /PRA/UTX_S_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 | /PRA/CM_OWNER_IDENTIFIER | CHAR | 48 | |
| REV_BOOK_ADJ_IND | Royalty 2.0 - TX - Reversal/Booking/Reversal Adjustment/Adjs | X | OIUY3_REV_BOOK_REVADJ_ADJ_IND | CHAR | 2 | |
| .INCLUDE | /PRA/UTX_S_ROYTXN_NONKEY | /PRA/UTX_S_ROYTXN_NONKEY | 0 | |||
| UNIT_VNAME | Joint venture | JV_NAME | CHAR | 12 | OIU_DO_JV | |
| ORIG_MP_NO | Original measurement point number | OIU_ORIG_MP_NO | CHAR | 40 | * | |
| 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 Number | /PRA/PURCHASER | CHAR | 20 | * | |
| AFFILIATED_SALE | Roy 2.0 � TX UT - Affiliated indicator | /PRA/UTX_AFFILIATED | CHAR | 2 | ||
| .INCLUDE | /PRA/UTX_S_ROYTXN_NONKEY_NUM | /PRA/UTX_S_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 | /PRA/UTX_S_ROYTXN_NONKEY_VAL | /PRA/UTX_S_ROYTXN_NONKEY_VAL | 0 | |||
| ORIGINAL_REBOOK | Roy 2.0 - TX UT - Original / Rebook | /PRA/UTX_ORIGINAL_REBOOK | CHAR | 2 | ||
| DISP_CODE | Roy 2.0 - TX UT - Disposition Code | /PRA/UTX_DISP_CODE | CHAR | 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 | Roy 2.0 - TX UT - Purchaser ID | /PRA/UTX_PURCHASER_ID | CHAR | 22 | ||
| .INCLUDE | /PRA/UTX_S_MASTER_SUBKEY | /PRA/UTX_S_MASTER_SUBKEY | 0 | |||
| UT_LEASE | Roy 2.0 � TX UT - State Lease | /PRA/UTX_UT_LEASE | CHAR | 40 | /PRA/UTX_LEASE | |
| UT_UNIT_NO | Roy 2.0 � TX UT - Unit Number | /PRA/UTX_UNIT_NO | CHAR | 20 | /PRA/UTX_UNIT | |
| UT_TRACT_NO | Roy 2.0 - TX UT - Tract Number | /PRA/UTX_TRACT_NUMBER | CHAR | 20 | /PRA/UTX_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 | ||
| OIL_TYPE | Roy 2.0 - TX UT - Oil type flag | /PRA/UTX_OIL_TYPE | CHAR | 2 | ||
| .INCLUDE | /PRA/UTX_S_MASTER_NONKEY | /PRA/UTX_S_MASTER_NONKEY | 0 | |||
| ALLOC_PERCENT | Royalty 2.0 - TX GLO/TAMU - Allocation Percent | OIUY3_TX_ALLOCATION_PERCENT | DEC | 5 | ||
| REPORT_FACTOR | Roy 2.0 � TX UT - Reporting factor | /PRA/UTX_REPORT_FACTOR | DEC | 5 | ||
| .INCLUDE | /PRA/UTX_S_RRC_NONKEY | /PRA/UTX_S_RRC_NONKEY | 0 | |||
| RRC_TYPE | Roy 2.0 � TX UT - RRC Type | /PRA/UTX_RRC_TYPE | CHAR | 2 | ||
| RRC_DISTRICT_NO | Roy 2.0 � TX UT - RRC District Number | /PRA/UTX_RRC_DISTRICT_NO | CHAR | 6 | ||
| RRC_NO | Roy 2.0 � TX UT - RRC No / Drill Permit | /PRA/UTX_RRC_NO | CHAR | 40 | ||
| DRILL_PERMIT | Texas Drill Permit | OIUX3_TX_DRILL_PERMIT | 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 | ||
| .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 |