I_ONRRRptgHistoryReportDetails

ONRR Reporting History Report Details | view: IONRRRHISREPDET | TRAN | Extraction: Full only | Component: Production and Revenue Accounting
Tables used: /PRA/FP_RPDT_HST
Column Name Description
ONRRPayerCode FK ONRR-2014 - Payor Code
ONRRLessorType ONRR-2014 - Lessor Code Show values
ONRRLease FK ONRR-2014 - Lease Number
APIWellNumber ONRR-2014 - API Well Number
ONRRAgreement FK ONRR-2014 - Agreement Number
ONRRReportedProduct ONRR-2014 - Product Code Show values
ONRRSalesType FK ONRR-2014 - Sales Type Code
SalesDate Sales Date / Month
ONRRReportedTransType ONRR-2014 - Transaction Code Show values
RoyaltyRate ONRR-2014 - Royalty Rate
ONRRPaymentMethod ONRR-2014 - Payment Method Code Show values
ONRRReportedRefTransType ONRR-2014 - Reference Transaction Code Show values
ONRRBusinessTransactionType ONRR-2014 - Line Type Show values
Column Name Description
💲 Currency Key (Currency):
ReportedSalesValue ONRR-2014 - Sales Value
GrossRoyaltyAmount ONRR-2014 - Royalty Value Prior To Allowance
TranspAllwncDeductAmt ONRR-2014 - Transportation Allowance Deduction
ProcgAllwncDeductAmt ONRR-2014 - Processing Allowance Deduction
NetRoyaltyAmount ONRR-2014 - Royalty Value Less Allowance
TranspAllwncDeductAdjmtAmt ONRR-2014 - Transportation Allowance Deduction Adjustment
ProcgAllwncDeductAdjmtAmt ONRR-2014 - Processing Allowance Deduction Adjustment
RoyaltyDueAdjustmentAmount ONRR-2014 - Royalty Due Adjustment
Column Name Description
📏 Volume Base Unit of Measure (VolumeUnit):
LeaseSalesVolumeInVolUnit ONRR-2014 - Sales Volume
📏 Energy Base Unit Of Measure (EnergyUnit):
LeaseGasEnergyInEnergyUnit ONRR-2014 - Gas Energy
📏 Heating Unit Of Measure (HeatingValUnit):
HeatingValue Heating value
Column Name Description
SalesDate Sales Date / Month
Column Name Description
ONRRLessorType ONRR-2014 - Lessor Code Show values
ONRRReportedProduct ONRR-2014 - Product Code Show values
ONRRReportedTransType ONRR-2014 - Transaction Code Show values
ONRRPaymentMethod ONRR-2014 - Payment Method Code Show values
ONRRReportedRefTransType ONRR-2014 - Reference Transaction Code Show values
ONRRBusinessTransactionType ONRR-2014 - Line Type Show values
ONRRAdjmtReason ONRR-2014 - Adjustment Code Show values
TribalOrAllotteeLeaseType ONRR-2014 - Tribal / Allottee Indicator Show values
AgencyReportType Proc 2.0 - Amended/Current Indicator Show values
ONRRReportStatus ONRR-2014 - Status Show values
AgencyReportIsManual ONRR-2014 - Manual 2014 Flag Show values
IsRejectOverridden ONRR-2014 - Override Reject Flag Show values
ONRROverrideAdjmtReason ONRR-2014 - Override Adjustment Code Show values
SalesFigureIsToBeRecalculated ONRR-2014: Recalculate Sales Vol/Val Show values
FutureRptHasRoyaltyDueAdjmt ONRR-2014: Persist Royalty Due Adjustment Show values
IsManualReversal ONRR-2014 - Manual Reversal Flag Show values
Column Name Description Domain name
ProcessRun Proc 2.0 - Run ID
PayerAssignedDocument ONRR-2014 - Payor Assigned Document Number
PayerAssignedDocumentItem ONRR-2014 - Line Number
SalesYearMonth Fiscal Period OIU_VDM_FIS_PERIOD
IndianIndexZone ONRR-2014 - Index Zone /PRA/FP_INDEX_ZONE
RefPayerAssignedDocument ONRR- Ref Payor Assigned Document Number
RefPayerAssignedDocumentItem ONRR-Ref Payor Assigned Document Line Number
ONRRLeaseName ONRR-2014 - Lease Name TEXT20
OverrideDocument ONRR-2014 - Override Payor Assigned Document Number
CreatedByUser Created By XUBNAME
CreationDateTime Created On Timestamp TZNTSTMPS
OriginTransaction Source Transaction ID FQM_ORIGIN_TRANS_ID
AgencyReportedPrice ONRR-2014 - Price /PRA/FP_PRICE
IndianIndexPrice ONRR-2014 - Index Price /PRA/FP_PRICE
Master Data Relations | to Other Relations ↓ Join Conditions
Company Code
  • Company Code
  • Client
  • I_ONRRRPTGHISTORYREPORTDETAILS.COMPANYCODE == OIU_CM_COMPC.BUKRS
  • I_ONRRRPTGHISTORYREPORTDETAILS.MANDT == OIU_CM_COMPC.MANDT
Currency Key
  • Client
  • Currency Key
  • I_ONRRRPTGHISTORYREPORTDETAILS.MANDT == TCURC.MANDT
  • I_ONRRRPTGHISTORYREPORTDETAILS.CURRENCY == TCURC.WAERS
Energy Base Unit Of Measure
  • Energy Base Unit Of Measure
  • Client
  • I_ONRRRPTGHISTORYREPORTDETAILS.ENERGYUNIT == T006.MSEHI
  • I_ONRRRPTGHISTORYREPORTDETAILS.MANDT == T006.MANDT
Heating Unit Of Measure
  • Client
  • Heating Unit Of Measure
  • I_ONRRRPTGHISTORYREPORTDETAILS.MANDT == T006.MANDT
  • I_ONRRRPTGHISTORYREPORTDETAILS.HEATINGVALUNIT == T006.MSEHI
ONRR-2014 - Agreement Number
  • Client
  • ONRR-2014 - Lease Number
  • I_ONRRRPTGHISTORYREPORTDETAILS.MANDT == /PRA/FP_AGREE.MANDT
  • I_ONRRRPTGHISTORYREPORTDETAILS.ONRRLEASE == /PRA/FP_AGREE.AGREEMENT_NO
ONRR-2014 - Lease Number
  • Client
  • ?
  • I_ONRRRPTGHISTORYREPORTDETAILS.MANDT == /PRA/FP_LEASE.MANDT
  • I_ONRRRPTGHISTORYREPORTDETAILS.[column in domain "/PRA/FP_LEASE_NO"] == /PRA/FP_LEASE.LEASE_NO
ONRR-2014 - Sales Type Code
  • Client
  • ONRR-2014 - Sales Type Code
Volume Base Unit of Measure
  • Volume Base Unit of Measure
  • Client
  • I_ONRRRPTGHISTORYREPORTDETAILS.VOLUMEUNIT == T006.MSEHI
  • I_ONRRRPTGHISTORYREPORTDETAILS.MANDT == T006.MANDT
Other Relations | to Master Data Relations ↑ Join Conditions
ONRR-2014 - Payor Code
  • Client
  • ONRR-2014 - Payor Code
ONRR-2014 - Distributee Code
  • ONRR-2014 - Distributee Code
  • Client