/PRA/UTX_PRDTA

Roy 2.0 - TX UT - Royalty PRA Details (Allocated) | #transactional | Component: Royalty Reporting
Column Name Description
MANDT FK Client
RUN_ID Run ID of Tax Report
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
LEASE_IDENTIFIER Roy 2.0 – TX UT - State Lease
REV_BOOK_ADJ_IND Royalty 2.0 - TX - Reversal/Booking/Reversal Adjustment/Adjs Show values
Column Name Description
💲 Currency Key (T001.WAERS):
GR_AM Gross Value
TXN_VAL_AM Royalty 2.0 - TX GLO - Owner Gross Value
DED_RMB_AM Deduction/Reimbursement Amount
NET_TRANSP_AM Marketing Cost
NET_OTH_MK_AM Marketing Cost
TAX_RMB_AM Tax Reimbursement Amount
TAX_AM Tax amount
Column Name Description
Column Name Description
SALES_DT Sales Date / Month
Column Name Description
REV_BOOK_ADJ_IND Royalty 2.0 - TX - Reversal/Booking/Reversal Adjustment/Adjs Show values
OUT_OF_STATUTE Roy 2.0 - TX UT - Out of Statute Show values
IMMATERIAL Roy 2.0 - TX UT - Immaterial record Show values
AFFILIATED_SALE Roy 2.0 – TX UT - Affiliated indicator Show values
ORIGINAL_REBOOK Roy 2.0 - TX UT - Original / Rebook Show values
UNIT_VNAME_FLAG Roy 2.0 - Texas GLO/TAMU - Unit Venture Show values
OIL_TYPE Roy 2.0 - TX UT - Oil type flag Show values
RRC_TYPE Roy 2.0 – TX UT - RRC Type Show values
DRILL_PERMIT Texas Drill Permit Show values
INTERFACE_FL Royalty 2.0 - TX GLO - Interface Flag Show values
Column Name Description Domain name
ORIG_MP_NO Original measurement point number OIU_MP_NO
ACCT_NO Account ID CHAR10
CHV_RPT_CD Template Cost Center KOSTL
PS_BASE_QY Pressure Base Quantity OIUH_DEC6_3
GRV_QY Gravity OIUH_DEC3_1
PAY_CD Pay Code CHAR2
OWN_INT_DECM_QY Royalty 2.0 - TX GLO - Owner NRI OIU_PERCENT98
OWN_BAL_DECM_QY Owner Disbursement (Balance) Decimal OIUH_DEC9_8
PU_NO Purchaser Number KUNNR
GR_QY Gross Volume OIUX3_SIGNED_DEC_11_2
TRANS_AM JE Transaction Amount OIUX3_SIGNED_DEC_11_2
TRANS_QY JE Transaction Quantity OIUH_DEC11_2
MMBTU_OVL_AM Owner MMBTU OIUH_DEC11_2
PLT_VL_GRED_AM Gross Plant Volume Reduction amount OIUH_DEC11_2
PLT_VL_ORED_AM Owner Plant Volume Reduction amount OIUH_DEC11_2
BTU_QY BTU Quantity OIUH_DEC7_3
DISP_CODE Roy 2.0 - TX UT - Disposition Code
MASTER_LEVEL Royalty 2.0 - TX GLO - Master Level
RRC_LEVEL Royalty 2.0 - TX GLO - RRC Master Level
PURCHASER_ID Roy 2.0 - TX UT - Purchaser ID
ROYALTY_DECIMAL Royalty 2.0 - Texas GLO - Royalty Decimal OIU_PERCENT98
ALLOC_PERCENT Royalty 2.0 - TX GLO/TAMU - Allocation Percent OIU_PERCENT98
REPORT_FACTOR Roy 2.0 – TX UT - Reporting factor OIU_PERCENT98
RRC_DISTRICT_NO Roy 2.0 – TX UT - RRC District Number
RRC_NO Roy 2.0 – TX UT - RRC No / Drill Permit
DOC_NO Val. document number OIU_MP_NO
DOC_YEAR Document year GJAHR
OPTION1 null
OPTION2 null
OPTION3 null
REFERENCE_RUN_ID Run ID of Tax Report NUMC10
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/UTX_PRDTA.MANDT == T000.MANDT
Measurement point number
Full three char. product code (Major and Detail Products) /PRA/UTX_PRDTA.PDCD == OIUX3_PDCD.PDCD
Joint venture
  • Joint venture
  • Company Code
Measurement unit
  • /PRA/UTX_PRDTA.MANDT == T006.MANDT
  • /PRA/UTX_PRDTA.UOM == T006.MSEHI
Roy 2.0 – TX UT - State Lease
  • Roy 2.0 – TX UT - State Lease
  • Client
Roy 2.0 - TX UT - Tract Number
  • Roy 2.0 – TX UT - State Lease
  • Roy 2.0 - TX UT - Tract Number
  • ?
  • Roy 2.0 – TX UT - Unit Number
Roy 2.0 – TX UT - Unit Number
  • Roy 2.0 – TX UT - State Lease
  • Roy 2.0 - TX UT - Tract Number
  • ?
  • Roy 2.0 – TX UT - Unit Number
Volume type code /PRA/UTX_PRDTA.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