/PRA/FP_HST_CMP2

ONRR-2014 - History Compare Table (Indian) | #transactional | Component: Production and Revenue Accounting
Column Name Description
MANDT FK Client
PAYOR_CD FK ONRR-2014 - Payor Code
LEASE_NO FK ONRR-2014 - Lease Number
API_WELL_NO ONRR-2014 - API Well Number
AGREEMENT_NO FK ONRR-2014 - Agreement Number
PRODUCT_CD ONRR-2014 - Product Code Show values
SALES_TYPE_CD ONRR-2014 - Sales Type Code
SALE_DT Sales Date / Month
TRANSACTION_CD ONRR-2014 - Transaction Code Show values
ROY_RATE ONRR-2014 - Royalty Rate
PAY_METHOD_CD ONRR-2014 - Payment Method Code Show values
HISTORY_SOURCE ONRR-2014 - History Source Show values
HISTORY_RPT_DT ONRR-2014 - History Report Date
RUN_ID ONRR-2014 - History Doc Number
LINE_TYPE ONRR-2014 - Line Type Show values
Column Name Description
💲 Currency Key (WAERS):
SALES_VAL ONRR-2014 - Sales Value
ROY_PRIOR_ALLOW ONRR-2014 - Royalty Value Prior To Allowance
TRANSPORTATION ONRR-2014 - Transportation Allowance Deduction
PROCESSING ONRR-2014 - Processing Allowance Deduction
ROY_LESS_ALLOW ONRR-2014 - Royalty Value Less Allowance
TRANS_DEDUCT_ADJ ONRR-2014 - Transportation Allowance Deduction Adjustment
PROC_DEDUCT_ADJ ONRR-2014 - Processing Allowance Deduction Adjustment
ROYALTY_DUE_ADJ ONRR-2014 - Royalty Due Adjustment
Column Name Description
📏 Base Unit of Measure (VOL_UOM):
SALES_VOL ONRR-2014 - Sales Volume
📏 Base Unit of Measure (ENERGY_UOM):
GAS_ENERGY ONRR-2014 - Gas Energy
📏 Base Unit of Measure (HEAT_VAL_UOM):
HEAT_VAL Heating value
ORG_HEAT_VAL Heating value
Column Name Description
SALE_DT Sales Date / Month
HISTORY_RPT_DT ONRR-2014 - History Report Date
Column Name Description
PRODUCT_CD ONRR-2014 - Product Code Show values
TRANSACTION_CD ONRR-2014 - Transaction Code Show values
PAY_METHOD_CD ONRR-2014 - Payment Method Code Show values
HISTORY_SOURCE ONRR-2014 - History Source Show values
LINE_TYPE ONRR-2014 - Line Type Show values
LESSOR_CD ONRR-2014 - Lessor Code Show values
REVERSAL_SOURCE ONRR-2014 - Reversal Source Show values
APPROVED_FL Approved Flag Show values
LOCKED_FL ONRR-2014 - History Reconciliation Locked Flag Show values
ADJUSTMENT_CD ONRR-2014 - Adjustment Code Show values
TRIBAL_ALLOTTEE ONRR-2014 - Tribal / Allottee Indicator Show values
RPDT_AC_IND Proc 2.0 - Amended/Current Indicator Show values
STATUS ONRR-2014 - Status Show values
MANUAL_2014_FL ONRR-2014 - Manual 2014 Flag Show values
OVR_REJECT_FL ONRR-2014 - Override Reject Flag Show values
OVR_ADJ_CD ONRR-2014 - Override Adjustment Code Show values
RECALCULATE_FL ONRR-2014: Recalculate Sales Vol/Val Show values
RY_DUE_ADJ_PS_FL ONRR-2014: Persist Royalty Due Adjustment Show values
ORG_TRANS_CD ONRR-2014 - Transaction Code Show values
ORG_ADJ_CD ONRR-2014 - Adjustment Code Show values
EXCLUDE_FRM_FILE ONRR-2014 - Exclude From ASCII File Show values
MANUAL_REV_FL ONRR-2014 - Manual Reversal Flag Show values
Column Name Description Domain name
ONRR_2014_RUN_ID Proc 2.0 - Run ID
BRIO_REC_COUNT null
PAD_NO ONRR-2014 - Payor Assigned Document Number
LINE_NO ONRR-2014 - Line Number
SALES_MONTH ONRR-2014 - Sales Month /PRA/FP_SALES_MONTH
INDEX_ZONE ONRR-2014 - Index Zone /PRA/FP_INDEX_ZONE
REF_PAD_NO ONRR-2014 - Payor Assigned Document Number
REF_LINE_NO ONRR-2014 - Line Number
LEASE_NAME ONRR-2014 - Lease Name TEXT20
PRICE ONRR-2014 - Price /PRA/FP_PRICE
INDEX_PRICE ONRR-2014 - Index Price /PRA/FP_PRICE
OVR_PAD_NO ONRR-2014 - Override Payor Assigned Document Number
ORG_PRICE ONRR-2014 - Price /PRA/FP_PRICE
RPDT_GUID 16-byte UID in 32 chars (hexadecimal) SYSUUID_C32
ALT_GROUP_KEY ONRR-2014: Alternate Reporting Line Grouping Key NUMC10
BRIO_DOC_NO ONRR-2014 - History Doc Number
Master Data Relations | to Other Relations ↓ Join Conditions
ONRR-2014 - Agreement Number
  • ONRR-2014 - Lease Number
  • Client
Company Code
Base Unit of Measure
  • /PRA/FP_HST_CMP2.MANDT == T006.MANDT
  • /PRA/FP_HST_CMP2.ENERGY_UOM == T006.MSEHI
Base Unit of Measure
  • /PRA/FP_HST_CMP2.MANDT == T006.MANDT
  • /PRA/FP_HST_CMP2.HEAT_VAL_UOM == T006.MSEHI
ONRR-2014 - Lease Number
  • ?
  • Client
Client /PRA/FP_HST_CMP2.MANDT == T000.MANDT
Base Unit of Measure
  • /PRA/FP_HST_CMP2.MANDT == T006.MANDT
  • /PRA/FP_HST_CMP2.VOL_UOM == T006.MSEHI
Currency Key
  • /PRA/FP_HST_CMP2.MANDT == TCURC.MANDT
  • /PRA/FP_HST_CMP2.WAERS == TCURC.WAERS
Other Relations | to Master Data Relations ↑ Join Conditions
ONRR-2014 - Distributee Code
ONRR-2014 - Payor Code
  • ONRR-2014 - Payor Code
  • Client