I_PRAPaymentDetail

PRA Payment Detail | view: IPVPAYMENTDTL | TRAN | Extraction: Full only | Component: Production and Revenue Accounting
Tables used: /PRA/PP_CHK_DTL, T001, TKA02
Column Name Description
ProcessRun FK Proc 2.0 - Run ID
PaymentReference Check Number
PRAOwner FK PRA owner
JointVenture FK Joint venture
DivisionOfInterest FK Division of interest (DOI)
Well FK Well ID number
WellCompletion FK Well Completion Number
OwnerInterestType Participant Interest Type
OwnerInterestSequence Owner Interest Sequence Number
SalesDate Sales Date / Month
Product FK Full three char. product code (Major and Detail Products)
DisbursementDecimalRatio Payment Processing - Disbursement decimal
GLAccount FK G/L Account Number
RecordType Payment Processing - Record Type Show values
Column Name Description
💲 Currency Key (CompanyCodeCurrency):
GrossAmount Gross value
OwnerGrossAmount Owner Gross Value
OwnerNetAmount Owner Net Value
GrossMarketingCost Gross marketing costs
GrossTaxAmount Gross Tax
TotalMarketingAmt Total owner marketing cost
OwnerTaxAmount Owner tax
TotalDeductionAmt Total Owner Other Deducts
GrossLessDeductionAmt Gross value less deductions
WeightedNetPrice Price
Column Name Description
📏 Heating Unit Of Measure (HeatingValUnit):
HeatingValue Heating value
📏 Volume Base Unit of Measure (VolumeUnit):
GrossVolInVolUnit Total Gross Volume
OwnerNetVolInVolUnit Owner Net Volume
📏 Energy Base Unit Of Measure (EnergyUnit):
GrossEnergyInEnergyUnit Gross Energy
OwnerEnergyInEnergyUnit Owner Energy
Column Name Description
SalesDate Sales Date / Month
PaymentDate Check Date
Column Name Description
RecordType Payment Processing - Record Type Show values
CalculationBasis Actual, Entitlement, Settlement Codes Show values
Column Name Description Domain name
FiscalPeriod Fiscal Period OIU_VDM_FIS_PERIOD
JntIntrstBilgVenture JIB Venture JV_NAME
JointVentureEquityType Equity type JV_ETYPE
JointVentureEquityGroup Equity group JV_EGROUP
OriginTransaction Source Transaction ID FQM_ORIGIN_TRANS_ID
CreatedByUser Created By XUBNAME
CreationDateTime Created On Timestamp TZNTSTMPS
NetRevenueInterestRatio Net Revenue Interest Percent OIU_PERCENT98
Master Data Relations Join Conditions
Company Code
  • Client
  • Company Code
Currency Key
  • Client
  • Currency Key
  • I_PRAPAYMENTDETAIL.MANDT == TCURC.MANDT
  • I_PRAPAYMENTDETAIL.COMPANYCODECURRENCY == TCURC.WAERS
Country/Region Key
  • Client
  • Country/Region Key
  • I_PRAPAYMENTDETAIL.MANDT == T005.MANDT
  • I_PRAPAYMENTDETAIL.COUNTRY == T005.LAND1
County Code
  • County Code
  • Client
  • Region (State, Province, County)
  • Country/Region Key
  • I_PRAPAYMENTDETAIL.COUNTY == T005E.COUNC
  • I_PRAPAYMENTDETAIL.MANDT == T005E.MANDT
  • I_PRAPAYMENTDETAIL.REGION == T005E.REGIO
  • I_PRAPAYMENTDETAIL.COUNTRY == T005E.LAND1
Delivery network number
  • Client
  • Delivery network number
  • I_PRAPAYMENTDETAIL.MANDT == OIU_PR_DN.MANDT
  • I_PRAPAYMENTDETAIL.DELIVERYNETWORK == OIU_PR_DN.DN_NO
Division of interest (DOI)
  • Client
  • Company Code
  • Division of interest (DOI)
  • Joint venture
  • I_PRAPAYMENTDETAIL.MANDT == OIU_DO_DI.MANDT
  • I_PRAPAYMENTDETAIL.COMPANYCODE == OIU_DO_DI.BUKRS
  • I_PRAPAYMENTDETAIL.DIVISIONOFINTEREST == OIU_DO_DI.DOI_NO
  • I_PRAPAYMENTDETAIL.JOINTVENTURE == OIU_DO_DI.VNAME
Energy Base Unit Of Measure
  • Client
  • Energy Base Unit Of Measure
  • I_PRAPAYMENTDETAIL.MANDT == T006.MANDT
  • I_PRAPAYMENTDETAIL.ENERGYUNIT == T006.MSEHI
G/L Account Number
  • Client
  • ?
  • G/L Account Number
  • I_PRAPAYMENTDETAIL.MANDT == SKA1.MANDT
  • I_PRAPAYMENTDETAIL.[column in domain "KTOPL"] == SKA1.KTOPL
  • I_PRAPAYMENTDETAIL.GLACCOUNT == SKA1.SAKNR
Heating Unit Of Measure
  • Client
  • Heating Unit Of Measure
  • I_PRAPAYMENTDETAIL.MANDT == T006.MANDT
  • I_PRAPAYMENTDETAIL.HEATINGVALUNIT == T006.MSEHI
Joint venture
  • Client
  • Company Code
  • Joint venture
  • I_PRAPAYMENTDETAIL.MANDT == T8JV.MANDT
  • I_PRAPAYMENTDETAIL.COMPANYCODE == T8JV.BUKRS
  • I_PRAPAYMENTDETAIL.JOINTVENTURE == T8JV.VNAME
Payment Processing - Detail Level Reject Code
  • Client
  • Payment Processing - Detail Level Reject Code
PRA owner
  • Client
  • PRA owner
  • I_PRAPAYMENTDETAIL.MANDT == LFA1.MANDT
  • I_PRAPAYMENTDETAIL.PRAOWNER == LFA1.LIFNR
Prior Period Adjustment Reason Code
  • Client
  • Prior Period Adjustment Reason Code
Full three char. product code (Major and Detail Products) I_PRAPAYMENTDETAIL.PRODUCT == OIUX3_PDCD.PDCD
Region (State, Province, County)
  • Client
  • Region (State, Province, County)
  • Country/Region Key
  • I_PRAPAYMENTDETAIL.MANDT == T005S.MANDT
  • I_PRAPAYMENTDETAIL.REGION == T005S.BLAND
  • I_PRAPAYMENTDETAIL.COUNTRY == T005S.LAND1
Suspense Reason Code
  • Client
  • Suspense Reason Code
Unit venture
  • Client
  • Company Code
  • Unit venture
  • I_PRAPAYMENTDETAIL.MANDT == OIU_DO_JV.MANDT
  • I_PRAPAYMENTDETAIL.COMPANYCODE == OIU_DO_JV.BUKRS
  • I_PRAPAYMENTDETAIL.UNITJOINTVENTURE == OIU_DO_JV.VNAME
Volume Base Unit of Measure
  • Client
  • Volume Base Unit of Measure
  • I_PRAPAYMENTDETAIL.MANDT == T006.MANDT
  • I_PRAPAYMENTDETAIL.VOLUMEUNIT == T006.MSEHI
Well ID number
  • Client
  • Well ID number
Well Completion Number
  • Client
  • Well ID number
  • Well Completion Number
  • I_PRAPAYMENTDETAIL.MANDT == OIU_PR_WC.MANDT
  • I_PRAPAYMENTDETAIL.WELL == OIU_PR_WC.WL_NO
  • I_PRAPAYMENTDETAIL.WELLCOMPLETION == OIU_PR_WC.WC_NO