C_PRARoyaltyRptgHistWYQry

PRA Royalty Reporting History Wyoming Query | view: CPVROYRPTGHWY | Extraction: Not supported | Component: Production and Revenue Accounting
Tables used: /PRA/R6_ROYHST, T001, TKA02
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 - WY - Reversal/Booking/Reversal Adjustment/Adjs Show values
Column Name Description
💲 Currency Key (CompanyCodeCurrency):
GrossValInCoCodeCrcy Gross Value
DdctnOrReimbmtAmtInCoCdCrcy Deduction/Reimbursement Amount
TaxReimbmtAmtInCoCodeCrcy Tax Reimbursement Amount
TranspMktgCostInCoCodeCrcy Marketing Cost
OtherMktgCostInCoCodeCrcy Marketing Cost
MktgCost01InCoCodeCrcy Marketing Cost
MktgCost02InCoCodeCrcy Marketing Cost
MktgCost03InCoCodeCrcy Marketing Cost
MktgCost04InCoCodeCrcy Marketing Cost
MktgCost05InCoCodeCrcy Marketing Cost
MktgCost06InCoCodeCrcy Marketing Cost
MktgCost07InCoCodeCrcy Marketing Cost
MktgCost08InCoCodeCrcy Marketing Cost
MktgCost09InCoCodeCrcy Marketing Cost
MktgCost10InCoCodeCrcy Marketing Cost
OwnerGrossValInCoCodeCrcy Royalty 2.0 - WY - Owner Gross Value
Column Name Description
Column Name Description
SalesDate Sales Date / Month
Column Name Description
TaxRptgRvslOrBkgOrAdjmt Royalty 2.0 - WY - Reversal/Booking/Reversal Adjustment/Adjs Show values
EntityIsCompanyOperated Royalty 2.0 - WY - Operated Flag Show values
EntityIsOnlyReported Royalty 2.0 - WY - Report Only Flag Show values
OverrideOwnerOperatedType Royalty 2.0 - WY - Override Operated Flag Show values
AgencyProduct Royalty 2.0 - Wyoming - Product Code Show values
AgencyReportType Royalty 2.0 - WY - Original Report Show values
Column Name Description Domain name
UnitJointVenture Joint venture JV_NAME
GLAccount Account ID CHAR10
OwnerPaymentStatus Pay Code CHAR2
OperatorName Royalty 2.0 - WY - Operator Name CHAR38
ReportingAgencyLease Royalty 2.0 - Wyoming - State Lease Number
ProductionSharingAgreement Royalty 2.0 - Wyoming - PSA
ReferenceFieldText Royalty 2.0 - WY - Reference Field
AlternateProdnSharingAgrmt Royalty 2.0 - Wyoming - Alternate PSA
MasterDataRecordingLvl Royalty 2.0 - WY - Master Level
Company Royalty 2.0 - Wyoming - Payer Code OIUY6_WY_COMPANY_ID
ValuationDocumentNumber Val. document number OIU_MP_NO
ValuationDocumentYear Document year GJAHR
CreatedByUser Created By XUBNAME
CreationDateTime Created On Timestamp TZNTSTMPS
TractAllocToLeaseRatio Royalty 2.0 - Wyoming - Tract Allocation to Lease OIU_PERCENT98
RoyaltyRate Royalty 2.0 - Wyoming - Royalty Rate OIU_PERCENT98
AllocationPercent Royalty 2.0 - Wyoming - Allocation Percent OIU_PERCENT98
CalcTractAllocToLeaseRatio Royalty 2.0 - Wyoming - Calculated Tract Allocation to Lease OIU_PERCENT98
GrossVolInBaseUnit Gross Volume OIUX3_SIGNED_DEC_11_2
NetRevenueInterestRatio Royalty 2.0 - Wyoming - Owner NRI OIU_PERCENT98
JournalEntryTransacAmtVal JE Transaction Amount OIUX3_SIGNED_DEC_11_2
HeatingValue BTU Quantity OIUH_DEC7_3
PressureBaseQty Pressure Base Quantity OIUH_DEC6_3
APIGravityRatio Gravity OIUH_DEC3_1
DisbursementDecimalRatio Owner Disbursement (Balance) Decimal OIUH_DEC9_8
OwnerEnergyInMMBTU Owner MMBTU OIUH_DEC11_2
Master Data Relations Join Conditions
Company Code
  • Client
  • Company Code
Currency Key
  • Client
  • Currency Key
  • C_PRAROYALTYRPTGHISTWYQRY.MANDT == TCURC.MANDT
  • C_PRAROYALTYRPTGHISTWYQRY.COMPANYCODECURRENCY == TCURC.WAERS
Delivery network number
  • Delivery network number
  • Client
  • C_PRAROYALTYRPTGHISTWYQRY.DELIVERYNETWORK == OIU_PR_DN.DN_NO
  • C_PRAROYALTYRPTGHISTWYQRY.MANDT == OIU_PR_DN.MANDT
Division of interest (DOI)
  • Client
  • Joint venture
  • Company Code
  • Division of interest (DOI)
  • C_PRAROYALTYRPTGHISTWYQRY.MANDT == OIU_DO_DI.MANDT
  • C_PRAROYALTYRPTGHISTWYQRY.JOINTVENTURE == OIU_DO_DI.VNAME
  • C_PRAROYALTYRPTGHISTWYQRY.COMPANYCODE == OIU_DO_DI.BUKRS
  • C_PRAROYALTYRPTGHISTWYQRY.DIVISIONOFINTEREST == OIU_DO_DI.DOI_NO
Joint venture
  • Client
  • Joint venture
  • Company Code
  • C_PRAROYALTYRPTGHISTWYQRY.MANDT == OIU_DO_JV.MANDT
  • C_PRAROYALTYRPTGHISTWYQRY.JOINTVENTURE == OIU_DO_JV.VNAME
  • C_PRAROYALTYRPTGHISTWYQRY.COMPANYCODE == OIU_DO_JV.BUKRS
Measurement point number
  • Measurement point number
  • Client
  • C_PRAROYALTYRPTGHISTWYQRY.MEASUREMENTPOINT == OIU_PR_MP.MP_NO
  • C_PRAROYALTYRPTGHISTWYQRY.MANDT == OIU_PR_MP.MANDT
Full three char. product code (Major and Detail Products) C_PRAROYALTYRPTGHISTWYQRY.PRODUCT == OIUX3_PDCD.PDCD
Volume type code C_PRAROYALTYRPTGHISTWYQRY.VOLUMETYPE == OIU_PR_VLTYP.VL_TYPE_CD
Well ID number
  • Client
  • Well ID number
Well Completion Number
  • Well Completion Number
  • Client
  • Well ID number
  • C_PRAROYALTYRPTGHISTWYQRY.WELLCOMPLETION == OIU_PR_WC.WC_NO
  • C_PRAROYALTYRPTGHISTWYQRY.MANDT == OIU_PR_WC.MANDT
  • C_PRAROYALTYRPTGHISTWYQRY.WELL == OIU_PR_WC.WL_NO