C_PRATaxRptgHistCOConsvnQry

PRA Tax Reporting History CO Conservation Query | view: CPVTAXRPTGHCOC | Extraction: Not supported | Component: Production and Revenue Accounting
Tables used: /PRA/TA_TAXHST, 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
TaxClassification FK Tax Class
TaxRptgRvslOrBkgOrAdjmt Reversal/Booking/Adjustment Show values
Column Name Description
💲 Currency Key (CompanyCodeCurrency):
GrossValInCoCodeCrcy Gross value
TaxExmptVal1InCoCdCrcy Charitable exempt value
TaxExmptVal2InCoCdCrcy Federal entity exempt value
TaxExmptVal3InCoCdCrcy US Indian exempt value
TaxExmptVal4InCoCdCrcy State entity exempt value
TaxExmptVal5InCoCdCrcy Other entity exempt value
MktgCostInCoCodeCrcy Marketing Cost
FixedMktgCostInCoCodeCrcy Fixed Marketing Cost
MktgReimbmtCostInCoCodeCrcy Marketing Cost Reimbursement
TaxableValInCoCodeCrcy Taxable Value
ConservationTaxAmtInCoCdCrcy Conservation Tax Amount
Column Name Description
GrossVolInBaseUnit Total Gross Volume
WetGasLessResidueGasVolInMCF Wet-less-residue volume
TaxExmptVolInBaseUnit Exempt Volume
TaxableVolInBaseUnit Taxable Volume
Column Name Description
SalesDate Sales Date / Month
Column Name Description
TaxRptgRvslOrBkgOrAdjmt Reversal/Booking/Adjustment Show values
ProducerOrPurchaserCode Producer or Purchaser Show values
RejectedOrSuspendedType Rejection-Suspension Status Show values
ProductCodeByAgency Product Cd Show values
Column Name Description Domain name
ProducerOrPurchaserNmbr Customer / Vendor Number OIUCM_MASTER
HasSeveranceTaxPaytOblgn Tax Severance Tax Calculation Payment Obligations Types OIU_SEVT_PAY_FL
SeveranceTaxRptgType State Severance Tax Reporting Indicators CHAR1
ValuationDocumentNumber Val. document number OIU_MP_NO
ValuationDocumentYear Document year GJAHR
TaxPayerIDByAgency OGCC Payor
TaxRate Levy Rate
LastChangedByUser Changed By XUBNAME
ChangedDateTime Changed On Timestamp TZNTSTMPS
Country Country/Region Key LAND1
PrimaryGeogrlLocation Primary geographical location (PRI geo. loc.) OIU_PRI_GEO_LOC
Master Data Relations Join Conditions
Company Code
  • Company Code
  • Client
Currency Key
  • Client
  • Currency Key
  • C_PRATAXRPTGHISTCOCONSVNQRY.MANDT == TCURC.MANDT
  • C_PRATAXRPTGHISTCOCONSVNQRY.COMPANYCODECURRENCY == TCURC.WAERS
Delivery network number
  • Client
  • Delivery network number
  • C_PRATAXRPTGHISTCOCONSVNQRY.MANDT == OIU_PR_DN.MANDT
  • C_PRATAXRPTGHISTCOCONSVNQRY.DELIVERYNETWORK == OIU_PR_DN.DN_NO
Division of interest (DOI)
  • Division of interest (DOI)
  • Company Code
  • Client
  • Joint venture
  • C_PRATAXRPTGHISTCOCONSVNQRY.DIVISIONOFINTEREST == OIU_DO_DI.DOI_NO
  • C_PRATAXRPTGHISTCOCONSVNQRY.COMPANYCODE == OIU_DO_DI.BUKRS
  • C_PRATAXRPTGHISTCOCONSVNQRY.MANDT == OIU_DO_DI.MANDT
  • C_PRATAXRPTGHISTCOCONSVNQRY.JOINTVENTURE == OIU_DO_DI.VNAME
Joint venture
  • Company Code
  • Client
  • Joint venture
  • C_PRATAXRPTGHISTCOCONSVNQRY.COMPANYCODE == OIU_DO_JV.BUKRS
  • C_PRATAXRPTGHISTCOCONSVNQRY.MANDT == OIU_DO_JV.MANDT
  • C_PRATAXRPTGHISTCOCONSVNQRY.JOINTVENTURE == OIU_DO_JV.VNAME
Measurement point number
  • Client
  • Measurement point number
  • C_PRATAXRPTGHISTCOCONSVNQRY.MANDT == OIU_PR_MP.MANDT
  • C_PRATAXRPTGHISTCOCONSVNQRY.MEASUREMENTPOINT == OIU_PR_MP.MP_NO
Contract Number
  • Contract Number
  • Client
Full three char. product code (Major and Detail Products) C_PRATAXRPTGHISTCOCONSVNQRY.PRODUCT == OIUX3_PDCD.PDCD
Tax 2.0 CO - Reject Code
  • Client
  • Tax 2.0 CO - Reject Code
Tax Class
  • ?
  • ?
  • Client
  • Tax Class
  • C_PRATAXRPTGHISTCOCONSVNQRY.[column in domain "OIU_PRI_GEO_LOC"] == OIU_CM_TAXCLS.PRI_GEO_LOC
  • C_PRATAXRPTGHISTCOCONSVNQRY.[column in domain "LAND1"] == OIU_CM_TAXCLS.COUNTRY
  • C_PRATAXRPTGHISTCOCONSVNQRY.MANDT == OIU_CM_TAXCLS.MANDT
  • C_PRATAXRPTGHISTCOCONSVNQRY.TAXCLASSIFICATION == OIU_CM_TAXCLS.TAX_CLS
Unit Venture
  • Company Code
  • Client
  • Unit Venture
  • C_PRATAXRPTGHISTCOCONSVNQRY.COMPANYCODE == OIU_DO_JV.BUKRS
  • C_PRATAXRPTGHISTCOCONSVNQRY.MANDT == OIU_DO_JV.MANDT
  • C_PRATAXRPTGHISTCOCONSVNQRY.UNITJOINTVENTURE == OIU_DO_JV.VNAME
Volume type code C_PRATAXRPTGHISTCOCONSVNQRY.VOLUMETYPE == OIU_PR_VLTYP.VL_TYPE_CD
Well ID number
  • Well ID number
  • Client
Well Completion Number
  • Well Completion Number
  • Well ID number
  • Client
  • C_PRATAXRPTGHISTCOCONSVNQRY.WELLCOMPLETION == OIU_PR_WC.WC_NO
  • C_PRATAXRPTGHISTCOCONSVNQRY.WELL == OIU_PR_WC.WL_NO
  • C_PRATAXRPTGHISTCOCONSVNQRY.MANDT == OIU_PR_WC.MANDT