/PRA/R6_OOSHST

Royalty 2.0 - WY - Out of Statute Royalty Transaction Hist | #transactional | Component: Production and Revenue Accounting
Column Name Description
MANDT FK Client
BUKRS FK Company Code
SALES_DT Sales Date / Month
PDCD FK Full three char. product code (Major and Detail Products)
WL_NO FK Well ID number
WC_NO FK Well Completion Number
MP_NO FK Measurement point number
VNAME FK Joint venture
DOI_NO FK Division of interest (DOI)
DN_NO FK Delivery network number
CT_NO FK Contract Number
VL_TYPE_CD FK Volume type code
OWNER_IDENTIFIER Royalty 2.0 - Owner Identifier
REV_BOOK_ADJ_IND Royalty 2.0 - WY - Reversal/Booking/Reversal Adjustment/Adjs Show values
Column Name Description
💲 Currency Key (T001.WAERS):
GR_AM Gross Value
DED_RMB_AM Deduction/Reimbursement Amount
TAX_RMB_AM Tax Reimbursement Amount
NET_TRANSP_AM Marketing Cost
NET_OTH_MK_AM Marketing Cost
MKT_COST_01 Marketing Cost
MKT_COST_02 Marketing Cost
MKT_COST_03 Marketing Cost
MKT_COST_04 Marketing Cost
MKT_COST_05 Marketing Cost
MKT_COST_06 Marketing Cost
MKT_COST_07 Marketing Cost
MKT_COST_08 Marketing Cost
MKT_COST_09 Marketing Cost
MKT_COST_10 Marketing Cost
TXN_VAL_AM Royalty 2.0 - WY - Owner Gross Value
Column Name Description
Column Name Description
SALES_DT Sales Date / Month
Column Name Description
REV_BOOK_ADJ_IND Royalty 2.0 - WY - Reversal/Booking/Reversal Adjustment/Adjs Show values
OPERATED_FL Royalty 2.0 - WY - Operated Flag Show values
REPORT_ONLY Royalty 2.0 - WY - Report Only Flag Show values
OVERRIDE_FL Royalty 2.0 - WY - Override Operated Flag Show values
WY_PDCD Royalty 2.0 - Wyoming - Product Code Show values
ORIGINAL_REPORT Royalty 2.0 - WY - Original Report Show values
INTERFACE_FL Royalty 2.0 - WY - Interface Flag Show values
Column Name Description Domain name
UNIT_VNAME Joint venture JV_NAME
ACCT_NO Account ID CHAR10
GR_QY Gross Volume OIUX3_SIGNED_DEC_11_2
OWN_INT_DECM_QY Royalty 2.0 - Wyoming - Owner NRI OIU_PERCENT98
TRANS_AM JE Transaction Amount OIUX3_SIGNED_DEC_11_2
TRANS_QY JE Transaction Quantity OIUH_DEC11_2
BTU_QY BTU Quantity OIUH_DEC7_3
PS_BASE_QY Pressure Base Quantity OIUH_DEC6_3
GRV_QY Gravity OIUH_DEC3_1
PAY_CD Pay Code CHAR2
OWN_BAL_DECM_QY Owner Disbursement (Balance) Decimal OIUH_DEC9_8
MMBTU_OVL_AM Owner MMBTU OIUH_DEC11_2
OPERATOR_NAME Royalty 2.0 - WY - Operator Name CHAR38
STATE_LEASE_NO Royalty 2.0 - Wyoming - State Lease Number
UNIQUE_ID Royalty 2.0 - Wyoming - PSA
TRACT_ALLOC_LSE Royalty 2.0 - Wyoming - Tract Allocation to Lease OIU_PERCENT98
ROYALTY_RATE Royalty 2.0 - Wyoming - Royalty Rate OIU_PERCENT98
ALLOC_PERCENT Royalty 2.0 - Wyoming - Allocation Percent OIU_PERCENT98
REFERENCE_FIELD Royalty 2.0 - WY - Reference Field
ALTERNATE_PSA Royalty 2.0 - Wyoming - Alternate PSA
CTRACT_ALLOC_LSE Royalty 2.0 - Wyoming - Calculated Tract Allocation to Lease OIU_PERCENT98
MASTER_LEVEL Royalty 2.0 - WY - Master Level
PAYER_CODE Royalty 2.0 - Wyoming - Payer Code OIUY6_WY_COMPANY_ID
DOC_NO Val. document number OIU_MP_NO
DOC_YEAR Document year GJAHR
OPTION1 null
OPTION2 null
OPTION3 null
OIU_CRUSER Name of Person Responsible for Creating the Object USNAM
OIU_TIMESTAMP UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
Master Data Relations Join Conditions
Company Code
Delivery network number
Division of interest (DOI)
  • Joint venture
  • Division of interest (DOI)
  • Company Code
Client /PRA/R6_OOSHST.MANDT == T000.MANDT
Measurement point number
Full three char. product code (Major and Detail Products) /PRA/R6_OOSHST.PDCD == OIUX3_PDCD.PDCD
Measurement unit
  • /PRA/R6_OOSHST.MANDT == T006.MANDT
  • /PRA/R6_OOSHST.UOM == T006.MSEHI
Volume type code /PRA/R6_OOSHST.VL_TYPE_CD == OIU_PR_VLTYP.VL_TYPE_CD
Joint venture
  • Joint venture
  • Company Code
Well Completion Number
  • Well ID number
  • Well Completion Number
Well ID number