C_PRATaxRptgHistCOSvrncQry

PRA Tax Rptg Hist Colorado Severance Qry | view: CPVTAXRPTGHCOS | Extraction: Not supported | Component: Production and Revenue Accounting
Tables used: /PRA/TA_ITAXHST, 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
PRAOwner Tax 2.0 CO - Owner Identifier
TaxRptgRvslOrBkgOrAdjmt Reversal/Booking/Adjustment Show values
Column Name Description
💲 Currency Key (CompanyCodeCurrency):
TransacAmtInCoCodeCrcy Tax 2.0 CO - Transaction Amount
MktgCost01InCoCodeCrcy Marketing Cost
MktgCost02InCoCodeCrcy Marketing Cost 2
MktgCost03InCoCodeCrcy Marketing Cost 3
MktgCost04InCoCodeCrcy Marketing Cost 4
MktgCost05InCoCodeCrcy Marketing Cost 5
MktgCost06InCoCodeCrcy Marketing Cost 6
MktgCost07InCoCodeCrcy Marketing Cost 7
MktgCost08InCoCodeCrcy Marketing Cost 8
MktgCost09InCoCodeCrcy Marketing Cost 9
MktgCost10InCoCodeCrcy Marketing Cost 10
AdValoremTaxAmtInCoCodeCrcy Tax 2.0 CO - Ad Valorem Tax amount
TranspCostInCoCodeCrcy Tax 2.0 CO - Transportation Cost
ProcgAndMfgCostInCoCodeCrcy Tax 2.0 CO - Ad Valorem Tax amount
Column Name Description
OwnerVolReducnInMCF Tax 2.0 CO - PVR Amount
GrossVolInBaseUnit Total Gross Volume
Column Name Description
SalesDate Sales Date / Month
Column Name Description
TaxRptgRvslOrBkgOrAdjmt Reversal/Booking/Adjustment Show values
EntityIsTaxExempt Tax 2.0 CO - Exempt Flag Show values
RevenueProcessCode Revenue Process Code Show values
RejectedOrSuspendedType Rejection-Suspension Status Show values
ProductType Tax 2.0 CO - Oil/Gas Indicator Show values
OwnerInterestCategory Interest Category Show values
Column Name Description Domain name
FiscalPeriod Tax 2.0 CO - Accounting Period
UnitJointVenture Joint venture JV_NAME
ValuationDocumentNumber Val. document number OIU_MP_NO
ValuationDocumentYear Document year GJAHR
NetRevenueInterestRatio Tax 2.0 CO - Net Revenue Interest percent
ColoradoAccountNumber Tax 2.0 CO Sev - Colorado Account Number
SourceOfIncome Tax 2.0 CO - Source of Income /PRA/TA_SOURCE_OF_INCOME
APIWellNumber Tax 2.0 CO - API Number
LastChangedByUser Changed By XUBNAME
ChangedDateTime Changed On Timestamp TZNTSTMPS
TransacQtyInBaseUnit Tax 2.0 CO - Transaction Quantity OIUH_DEC13_2
Master Data Relations Join Conditions
Company Code
  • Client
  • Company Code
Currency Key
  • Client
  • Currency Key
  • C_PRATAXRPTGHISTCOSVRNCQRY.MANDT == TCURC.MANDT
  • C_PRATAXRPTGHISTCOSVRNCQRY.COMPANYCODECURRENCY == TCURC.WAERS
Cost Center
  • Cost Center
  • Client
  • ?
  • ?
  • C_PRATAXRPTGHISTCOSVRNCQRY.COSTCENTER == CSKS.KOSTL
  • C_PRATAXRPTGHISTCOSVRNCQRY.MANDT == CSKS.MANDT
  • C_PRATAXRPTGHISTCOSVRNCQRY.[column in domain "KOKRS"] == CSKS.KOKRS
  • C_PRATAXRPTGHISTCOSVRNCQRY.[column in domain "DATBI"] == CSKS.DATBI
Delivery network number
  • Delivery network number
  • Client
  • C_PRATAXRPTGHISTCOSVRNCQRY.DELIVERYNETWORK == OIU_PR_DN.DN_NO
  • C_PRATAXRPTGHISTCOSVRNCQRY.MANDT == OIU_PR_DN.MANDT
Division of interest (DOI)
  • Division of interest (DOI)
  • Client
  • Joint venture
  • Company Code
  • C_PRATAXRPTGHISTCOSVRNCQRY.DIVISIONOFINTEREST == OIU_DO_DI.DOI_NO
  • C_PRATAXRPTGHISTCOSVRNCQRY.MANDT == OIU_DO_DI.MANDT
  • C_PRATAXRPTGHISTCOSVRNCQRY.JOINTVENTURE == OIU_DO_DI.VNAME
  • C_PRATAXRPTGHISTCOSVRNCQRY.COMPANYCODE == OIU_DO_DI.BUKRS
G/L Account Number
  • G/L Account Number
  • Client
  • ?
  • C_PRATAXRPTGHISTCOSVRNCQRY.GLACCOUNT == SKA1.SAKNR
  • C_PRATAXRPTGHISTCOSVRNCQRY.MANDT == SKA1.MANDT
  • C_PRATAXRPTGHISTCOSVRNCQRY.[column in domain "KTOPL"] == SKA1.KTOPL
Joint venture
  • Client
  • Joint venture
  • Company Code
  • C_PRATAXRPTGHISTCOSVRNCQRY.MANDT == OIU_DO_JV.MANDT
  • C_PRATAXRPTGHISTCOSVRNCQRY.JOINTVENTURE == OIU_DO_JV.VNAME
  • C_PRATAXRPTGHISTCOSVRNCQRY.COMPANYCODE == OIU_DO_JV.BUKRS
Measurement point number
  • Client
  • Measurement point number
  • C_PRATAXRPTGHISTCOSVRNCQRY.MANDT == OIU_PR_MP.MANDT
  • C_PRATAXRPTGHISTCOSVRNCQRY.MEASUREMENTPOINT == OIU_PR_MP.MP_NO
Contract Number
  • Contract Number
  • Client
Full three char. product code (Major and Detail Products) C_PRATAXRPTGHISTCOSVRNCQRY.PRODUCT == OIUX3_PDCD.PDCD
Tax 2.0 CO - Reject Code
  • Client
  • Tax 2.0 CO - Reject Code
Volume type code C_PRATAXRPTGHISTCOSVRNCQRY.VOLUMETYPE == OIU_PR_VLTYP.VL_TYPE_CD
Well ID number
  • Client
  • Well ID number
Well Completion Number
  • Client
  • Well Completion Number
  • Well ID number
  • C_PRATAXRPTGHISTCOSVRNCQRY.MANDT == OIU_PR_WC.MANDT
  • C_PRATAXRPTGHISTCOSVRNCQRY.WELLCOMPLETION == OIU_PR_WC.WC_NO
  • C_PRATAXRPTGHISTCOSVRNCQRY.WELL == OIU_PR_WC.WL_NO