C_PRARoyaltyRptgHistTXGLOQry

PRA Royalty Reporting History Texas GLO Query | view: CPVROYRPTGHTXG | Extraction: Not supported | Component: Production and Revenue Accounting
Tables used: /PRA/R3_ROYHSTT001TKA02
Column Name Description
CompanyCode FK Company Code
SalesDate Sales Date / Month
Product FK Full three char. product code (Major and Detail Products)
Well FK Well ID number
WellCompletion FK Well Completion Number
MeasurementPoint FK Measurement point number
JointVenture FK Joint venture
DivisionOfInterest FK Division of interest (DOI)
DeliveryNetwork FK Delivery network number
PRAContract FK Contract Number
VolumeType FK Volume type code
UniqueOwnerReference Royalty 2.0 - Owner Identifier
TaxRptgRvslOrBkgOrAdjmt Royalty 2.0 - TX - Reversal/Booking/Reversal Adjustment/Adjs Show values
Column Name Description
💲 Currency Key (CompanyCodeCurrency):
GrossValInCoCodeCrcy Gross Value
OwnerGrossValInCoCodeCrcy Royalty 2.0 - TX GLO - Owner Gross Value
DdctnOrReimbmtAmtInCoCdCrcy Deduction/Reimbursement Amount
TranspMktgCostInCoCodeCrcy Marketing Cost
OtherMktgCostInCoCodeCrcy Marketing Cost
TaxReimbmtAmtInCoCodeCrcy Tax Reimbursement Amount
Column Name Description
Column Name Description
SalesDate Sales Date / Month
Column Name Description
TaxRptgRvslOrBkgOrAdjmt Royalty 2.0 - TX - Reversal/Booking/Reversal Adjustment/Adjs Show values
IsAffiliatedSale Royalty 2.0 - TX GLO - Affiliated Sale Indicator Show values
AgencyReportType Royalty 2.0 - TX GLOTAMU - Original Report Show values
AgencyGasDispositionType Royalty 2.0 - TX GLO/TAMU - Royalty Gas Disposition Code Show values
JointVentureIsUnit Roy 2.0 - Texas GLO/TAMU - Unit Venture Show values
AgencyPayOrReportType Royalty 2.0 - TX GLO/TAMU - Pay/Report Flag Show values
Column Name Description Domain name
GLAccount Account ID CHAR10
CostCenter Template Cost Center KOSTL
OwnerPaymentStatus Pay Code CHAR2
Purchaser Purchaser Number KUNNR
MasterDataRecordingLvl Royalty 2.0 - TX GLO - Master Level
RailRoadCommsnMstrDataRecgLvl Royalty 2.0 - TX GLO - RRC Master Level
PurchaserIDByAgency Royalty 2.0 - Texas GLO/TAMU - Purchaser ID
OperatorIDByAgency Royalty 2.0 - TX GLO - Operator ID OIUY3_TX_ID
TexasRailRoadCommsnDistrict Royalty 2.0 - TX GLO/TAMU - District Number
TexasRailRoadCommsnOilLease Royalty 2.0 - TX GLO/TAMU - RRC Oil Lease Number
TexasRailRoadCommsnGasWell Royalty 2.0 - TX GLO/TAMU - RRC Gas Well ID
TexasRailRoadCommsnDrillPermit Royalty 2.0 - TX GLO/TAMU - RRC Drilling Permit
TexasRailRoadCommsnFieldName Royalty 2.0 - TX GLO/TAMU - RRC Field Name
TexasRailRoadCommsnLeaseName Royalty 2.0 - TX GLO/TAMU - RRC Lease Name
PropertyAliasName Royalty 2.0 - TX GLO/TAMU - Property Alias Name
ValuationDocumentNumber Val. document number OIU_MP_NO
ValuationDocumentYear Document year GJAHR
CreatedByUser Created By XUBNAME
CreationDateTime Created On Timestamp TZNTSTMPS
AgencyNetRevenueInterestRatio Royalty 2.0 - Texas GLO - Royalty Decimal OIU_PERCENT98
AllocationPercent Royalty 2.0 - TX GLO/TAMU - Allocation Percent OIU_PERCENT98
TractParticipationFactor Royalty 2.0 - Texas GLO - Tract Participation Factor OIU_PERCENT98
PressureBaseQty Pressure Base Quantity OIUH_DEC6_3
APIGravityRatio Gravity OIUH_DEC3_1
NetRevenueInterestRatio Royalty 2.0 - TX GLO - Owner NRI OIU_PERCENT98
DisbursementDecimalRatio Owner Disbursement (Balance) Decimal OIUH_DEC9_8
GrossVolInBaseUnit Gross Volume OIUX3_SIGNED_DEC_11_2
JournalEntryTransacAmtVal JE Transaction Amount OIUX3_SIGNED_DEC_11_2
JournalEntryTransacQtyVal JE Transaction Quantity OIUH_DEC11_2
OwnerEnergyInMMBTU Owner MMBTU OIUH_DEC11_2
GrossVolReducnInMCF Gross Plant Volume Reduction amount OIUH_DEC11_2
OwnerVolReducnInMCF Owner Plant Volume Reduction amount OIUH_DEC11_2
HeatingValue BTU Quantity OIUH_DEC7_3
Master Data Relations Join Conditions
Company Code
  • Company Code
  • Client
  • C_PRAROYALTYRPTGHISTTXGLOQRY.COMPANYCODE == OIU_CM_COMPC.BUKRS
  • C_PRAROYALTYRPTGHISTTXGLOQRY.MANDT == OIU_CM_COMPC.MANDT
Currency Key
  • Client
  • Currency Key
  • C_PRAROYALTYRPTGHISTTXGLOQRY.MANDT == TCURC.MANDT
  • C_PRAROYALTYRPTGHISTTXGLOQRY.COMPANYCODECURRENCY == TCURC.WAERS
Delivery network number
  • Delivery network number
  • Client
  • C_PRAROYALTYRPTGHISTTXGLOQRY.DELIVERYNETWORK == OIU_PR_DN.DN_NO
  • C_PRAROYALTYRPTGHISTTXGLOQRY.MANDT == OIU_PR_DN.MANDT
Division of interest (DOI)
  • Division of interest (DOI)
  • Company Code
  • Client
  • Joint venture
  • C_PRAROYALTYRPTGHISTTXGLOQRY.DIVISIONOFINTEREST == OIU_DO_DI.DOI_NO
  • C_PRAROYALTYRPTGHISTTXGLOQRY.COMPANYCODE == OIU_DO_DI.BUKRS
  • C_PRAROYALTYRPTGHISTTXGLOQRY.MANDT == OIU_DO_DI.MANDT
  • C_PRAROYALTYRPTGHISTTXGLOQRY.JOINTVENTURE == OIU_DO_DI.VNAME
Joint venture
  • Company Code
  • Client
  • Joint venture
  • C_PRAROYALTYRPTGHISTTXGLOQRY.COMPANYCODE == OIU_DO_JV.BUKRS
  • C_PRAROYALTYRPTGHISTTXGLOQRY.MANDT == OIU_DO_JV.MANDT
  • C_PRAROYALTYRPTGHISTTXGLOQRY.JOINTVENTURE == OIU_DO_JV.VNAME
Measurement point number
  • Client
  • Measurement point number
  • C_PRAROYALTYRPTGHISTTXGLOQRY.MANDT == OIU_PR_MP.MANDT
  • C_PRAROYALTYRPTGHISTTXGLOQRY.MEASUREMENTPOINT == OIU_PR_MP.MP_NO
Full three char. product code (Major and Detail Products) C_PRAROYALTYRPTGHISTTXGLOQRY.PRODUCT == OIUX3_PDCD.PDCD
Royalty 2.0 - TX GLO/TAMU Lease
  • Royalty 2.0 - TX GLO/TAMU Lease
  • Client
Joint venture
  • Company Code
  • Joint venture
  • Client
  • C_PRAROYALTYRPTGHISTTXGLOQRY.COMPANYCODE == OIU_DO_JV.BUKRS
  • C_PRAROYALTYRPTGHISTTXGLOQRY.UNITJOINTVENTURE == OIU_DO_JV.VNAME
  • C_PRAROYALTYRPTGHISTTXGLOQRY.MANDT == OIU_DO_JV.MANDT
Royalty 2.0 - Texas GLO/TAMU - Unit Number
  • Royalty 2.0 - Texas GLO/TAMU - Unit Number
  • ?
  • Royalty 2.0 - TX GLO/TAMU Lease
  • Client
  • C_PRAROYALTYRPTGHISTTXGLOQRY.UNITNUMBERBYAGENCY == OIUY3_TX_UNIT.GLO_UNIT_NO
  • C_PRAROYALTYRPTGHISTTXGLOQRY.[column in domain "OIU_EFF_FROM_DT"] == OIUY3_TX_UNIT.EFF_FROM_DT
  • C_PRAROYALTYRPTGHISTTXGLOQRY.REPORTINGAGENCYLEASE == OIUY3_TX_UNIT.GLO_LEASE
  • C_PRAROYALTYRPTGHISTTXGLOQRY.MANDT == OIUY3_TX_UNIT.MANDT
Volume type code C_PRAROYALTYRPTGHISTTXGLOQRY.VOLUMETYPE == OIU_PR_VLTYP.VL_TYPE_CD
Well ID number
  • Well ID number
  • Client
  • C_PRAROYALTYRPTGHISTTXGLOQRY.WELL == OIU_PR_WELL.WL_NO
  • C_PRAROYALTYRPTGHISTTXGLOQRY.MANDT == OIU_PR_WELL.MANDT
Well Completion Number
  • Well ID number
  • Client
  • Well Completion Number
  • C_PRAROYALTYRPTGHISTTXGLOQRY.WELL == OIU_PR_WC.WL_NO
  • C_PRAROYALTYRPTGHISTTXGLOQRY.MANDT == OIU_PR_WC.MANDT
  • C_PRAROYALTYRPTGHISTTXGLOQRY.WELLCOMPLETION == OIU_PR_WC.WC_NO