I_PRATaxRptgHistCOConsvn

PRA Tax Reporting Hist CO Conservation | view: IPVTXRPTGHCOC | TRAN | Extraction: Full only | 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
📏 Base Unit of Measure (BaseUnit):
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
OriginTransaction Source Transaction ID FQM_ORIGIN_TRANS_ID
Master Data Relations Join Conditions
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • I_PRATAXRPTGHISTCOCONSVN.MANDT == T006.MANDT
  • I_PRATAXRPTGHISTCOCONSVN.BASEUNIT == T006.MSEHI
Company Code
  • Client
  • Company Code
Currency Key
  • Client
  • Currency Key
  • I_PRATAXRPTGHISTCOCONSVN.MANDT == TCURC.MANDT
  • I_PRATAXRPTGHISTCOCONSVN.COMPANYCODECURRENCY == TCURC.WAERS
Delivery network number
  • Delivery network number
  • Client
  • I_PRATAXRPTGHISTCOCONSVN.DELIVERYNETWORK == OIU_PR_DN.DN_NO
  • I_PRATAXRPTGHISTCOCONSVN.MANDT == OIU_PR_DN.MANDT
Division of interest (DOI)
  • Client
  • Joint venture
  • Company Code
  • Division of interest (DOI)
  • I_PRATAXRPTGHISTCOCONSVN.MANDT == OIU_DO_DI.MANDT
  • I_PRATAXRPTGHISTCOCONSVN.JOINTVENTURE == OIU_DO_DI.VNAME
  • I_PRATAXRPTGHISTCOCONSVN.COMPANYCODE == OIU_DO_DI.BUKRS
  • I_PRATAXRPTGHISTCOCONSVN.DIVISIONOFINTEREST == OIU_DO_DI.DOI_NO
Joint venture
  • Client
  • Joint venture
  • Company Code
  • I_PRATAXRPTGHISTCOCONSVN.MANDT == OIU_DO_JV.MANDT
  • I_PRATAXRPTGHISTCOCONSVN.JOINTVENTURE == OIU_DO_JV.VNAME
  • I_PRATAXRPTGHISTCOCONSVN.COMPANYCODE == OIU_DO_JV.BUKRS
Measurement point number
  • Client
  • Measurement point number
  • I_PRATAXRPTGHISTCOCONSVN.MANDT == OIU_PR_MP.MANDT
  • I_PRATAXRPTGHISTCOCONSVN.MEASUREMENTPOINT == OIU_PR_MP.MP_NO
Contract Number
  • Client
  • Contract Number
Full three char. product code (Major and Detail Products) I_PRATAXRPTGHISTCOCONSVN.PRODUCT == OIUX3_PDCD.PDCD
Tax 2.0 CO - Reject Code
  • Client
  • Tax 2.0 CO - Reject Code
Tax Class
  • Tax Class
  • Client
  • ?
  • ?
  • I_PRATAXRPTGHISTCOCONSVN.TAXCLASSIFICATION == OIU_CM_TAXCLS.TAX_CLS
  • I_PRATAXRPTGHISTCOCONSVN.MANDT == OIU_CM_TAXCLS.MANDT
  • I_PRATAXRPTGHISTCOCONSVN.[column in domain "OIU_PRI_GEO_LOC"] == OIU_CM_TAXCLS.PRI_GEO_LOC
  • I_PRATAXRPTGHISTCOCONSVN.[column in domain "LAND1"] == OIU_CM_TAXCLS.COUNTRY
Unit Venture
  • Client
  • Company Code
  • Unit Venture
  • I_PRATAXRPTGHISTCOCONSVN.MANDT == OIU_DO_JV.MANDT
  • I_PRATAXRPTGHISTCOCONSVN.COMPANYCODE == OIU_DO_JV.BUKRS
  • I_PRATAXRPTGHISTCOCONSVN.UNITJOINTVENTURE == OIU_DO_JV.VNAME
Volume type code I_PRATAXRPTGHISTCOCONSVN.VOLUMETYPE == OIU_PR_VLTYP.VL_TYPE_CD
Well ID number
  • Client
  • Well ID number
Well Completion Number
  • Client
  • Well Completion Number
  • Well ID number
  • I_PRATAXRPTGHISTCOCONSVN.MANDT == OIU_PR_WC.MANDT
  • I_PRATAXRPTGHISTCOCONSVN.WELLCOMPLETION == OIU_PR_WC.WC_NO
  • I_PRATAXRPTGHISTCOCONSVN.WELL == OIU_PR_WC.WL_NO