C_PRATaxRptgHistoryOKQRY

PRA Tax Reporting History Oklahoma Query | view: CPVTAXRPTGHISTOK | Extraction: Not supported | Component: Production and Revenue Accounting
Tables used: OIUT5_TAXHSTP, 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
ProductionUnitNumber Tax 2.0 - OKGP15 - Production Unit Number
TaxRptgRvslOrBkgOrAdjmt Tax 2.0 - Reversal/Booking/Reversal Adjustment/Adjustment Show values
Column Name Description
💲 Currency Key (CompanyCodeCurrency):
GrossValInCoCodeCrcy Gross Value
TaxableValInCoCodeCrcy Taxable Value
TaxExmptVal1InCoCdCrcy Tax 2.0 - Exempt Entity Type 1 Value
TaxExmptVal2InCoCdCrcy Tax 2.0 - Exempt Entity Type 2 Value
TaxExmptVal3InCoCdCrcy Tax 2.0 - Exempt Entity Type 3 Value
TaxExmptVal4InCoCdCrcy Tax 2.0 - Exempt Entity Type 4 Value
TaxExmptVal5InCoCdCrcy Tax 2.0 - Exempt Entity Type 5 Value
EnhncdOilRcvryValInCoCdCrcy EOR Value
MktgCostInCoCodeCrcy Marketing Cost
MktgReimbmtCostInCoCodeCrcy Marketing Cost Reimbursement
GrossProdnTaxAmtInCoCodeCrcy Tax 2.0 - Gross Production Tax Amount
PetroleumExcsTxAmtInCoCdCrcy Tax 2.0 - Petroleum Excise Tax Amount
RevolvingFundTxAmtInCoCdCrcy Tax 2.0 - Revolving Fund Tax Amount
MarginProdgTxAmtInCoCdCrcy Tax 2.0 - Marginally Producing Tax Amount
KoiwaTribeTaxAmtInCoCodeCrcy Tax 2.0 - Kiowa Tax Amount
ArapahoTribeTaxAmtInCoCdCrcy Shoshone Arapaho Tax
Column Name Description
EnhncdOilRcvryVolInBaseUnit EOR Volume
Column Name Description
SalesDate Sales Date / Month
Column Name Description
TaxRptgRvslOrBkgOrAdjmt Tax 2.0 - Reversal/Booking/Reversal Adjustment/Adjustment Show values
ProducerOrPurchaserCode Producer or Purchaser Show values
MasterDataRecordingLvl Tax 2.0 - Master Level Show values
ProductType Tax 2.0 - Oklahoma Product Code Show values
Column Name Description Domain name
AllocationRatio Tax 2.0 - Allocation Percentage
HasSeveranceTaxPaytOblgn Tax Severance Tax Calculation Payment Obligations Types OIU_SEVT_PAY_FL
SeveranceTaxRptgType State Severance Tax Reporting Indicators CHAR1
TaxRate Value tax rate
ProducerOrPurchaserNmbr Producer/Purchaser OIUCM_MASTER
ValuationDocumentNumber Val. document number OIU_MP_NO
ValuationDocumentYear Document year GJAHR
ExtProducerOrPurchaserNmbr Tax 2.0 - Oklahoma Producer/Purchaser Number
TaxPayerIDByAgency Tax 2.0 - Oklahoma Taxpayer Number
ReportingCompany Tax 2.0 - FEIN/SSN
ProductionDate Tax 2.0 OK - Production Date (YYYYMM)
CreatedByUser Created By XUBNAME
CreationDateTime Created On Timestamp TZNTSTMPS
GrossVolInBaseUnit Gross Volume OIUX3_SIGNED_DEC_11_2
TaxableVolInBaseUnit Taxable Volume OIUX3_SIGNED_DEC_11_2
TaxExmptVol1InBaseUnit Tax 2.0 - Exempt Entity Type 1 Volume OIUX3_SIGNED_DEC_11_2
TaxExmptVol2InBaseUnit Tax 2.0 - Exempt Entity Type 2 Volume OIUX3_SIGNED_DEC_11_2
TaxExmptVol3InBaseUnit Tax 2.0 - Exempt Entity Type 3 Volume OIUX3_SIGNED_DEC_11_2
TaxExmptVol4InBaseUnit Tax 2.0 - Exempt Entity Type 4 Volume OIUX3_SIGNED_DEC_11_2
TaxExmptVol5InBaseUnit Tax 2.0 - Exempt Entity Type 5 Volume OIUX3_SIGNED_DEC_11_2
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_PRATAXRPTGHISTORYOKQRY.MANDT == TCURC.MANDT
  • C_PRATAXRPTGHISTORYOKQRY.COMPANYCODECURRENCY == TCURC.WAERS
Delivery network number
  • Delivery network number
  • Client
  • C_PRATAXRPTGHISTORYOKQRY.DELIVERYNETWORK == OIU_PR_DN.DN_NO
  • C_PRATAXRPTGHISTORYOKQRY.MANDT == OIU_PR_DN.MANDT
Division of interest (DOI)
  • Division of interest (DOI)
  • Company Code
  • Client
  • Joint venture
  • C_PRATAXRPTGHISTORYOKQRY.DIVISIONOFINTEREST == OIU_DO_DI.DOI_NO
  • C_PRATAXRPTGHISTORYOKQRY.COMPANYCODE == OIU_DO_DI.BUKRS
  • C_PRATAXRPTGHISTORYOKQRY.MANDT == OIU_DO_DI.MANDT
  • C_PRATAXRPTGHISTORYOKQRY.JOINTVENTURE == OIU_DO_DI.VNAME
Joint venture
  • Company Code
  • Client
  • Joint venture
  • C_PRATAXRPTGHISTORYOKQRY.COMPANYCODE == OIU_DO_JV.BUKRS
  • C_PRATAXRPTGHISTORYOKQRY.MANDT == OIU_DO_JV.MANDT
  • C_PRATAXRPTGHISTORYOKQRY.JOINTVENTURE == OIU_DO_JV.VNAME
Measurement point number
  • Measurement point number
  • Client
  • C_PRATAXRPTGHISTORYOKQRY.MEASUREMENTPOINT == OIU_PR_MP.MP_NO
  • C_PRATAXRPTGHISTORYOKQRY.MANDT == OIU_PR_MP.MANDT
Full three char. product code (Major and Detail Products) C_PRATAXRPTGHISTORYOKQRY.PRODUCT == OIUX3_PDCD.PDCD
Tax Class
  • Tax Class
  • ?
  • ?
  • Client
  • C_PRATAXRPTGHISTORYOKQRY.TAXCLASSIFICATION == OIU_CM_TAXCLS.TAX_CLS
  • C_PRATAXRPTGHISTORYOKQRY.[column in domain "OIU_PRI_GEO_LOC"] == OIU_CM_TAXCLS.PRI_GEO_LOC
  • C_PRATAXRPTGHISTORYOKQRY.[column in domain "LAND1"] == OIU_CM_TAXCLS.COUNTRY
  • C_PRATAXRPTGHISTORYOKQRY.MANDT == OIU_CM_TAXCLS.MANDT
Tax 2.0 OKGP - Entity Type 01 Exempt Code
  • Tax 2.0 OKGP - Entity Type 01 Exempt Code
  • Client
  • C_PRATAXRPTGHISTORYOKQRY.TAXEXEMPTCODE1 == OIUT5_EXCD.EXEMPT_CODE
  • C_PRATAXRPTGHISTORYOKQRY.MANDT == OIUT5_EXCD.MANDT
Tax 2.0 OKGP - Entity Type 02 Exempt Code
  • Tax 2.0 OKGP - Entity Type 02 Exempt Code
  • Client
  • C_PRATAXRPTGHISTORYOKQRY.TAXEXEMPTCODE2 == OIUT5_EXCD.EXEMPT_CODE
  • C_PRATAXRPTGHISTORYOKQRY.MANDT == OIUT5_EXCD.MANDT
Tax 2.0 OKGP - Entity Type 03 Exempt Code
  • Tax 2.0 OKGP - Entity Type 03 Exempt Code
  • Client
  • C_PRATAXRPTGHISTORYOKQRY.TAXEXEMPTCODE3 == OIUT5_EXCD.EXEMPT_CODE
  • C_PRATAXRPTGHISTORYOKQRY.MANDT == OIUT5_EXCD.MANDT
Tax 2.0 OKGP - Entity Type 04 Exempt Code
  • Tax 2.0 OKGP - Entity Type 04 Exempt Code
  • Client
  • C_PRATAXRPTGHISTORYOKQRY.TAXEXEMPTCODE4 == OIUT5_EXCD.EXEMPT_CODE
  • C_PRATAXRPTGHISTORYOKQRY.MANDT == OIUT5_EXCD.MANDT
Tax 2.0 OKGP - Entity Type 05 Exempt Code
  • Client
  • Tax 2.0 OKGP - Entity Type 05 Exempt Code
  • C_PRATAXRPTGHISTORYOKQRY.MANDT == OIUT5_EXCD.MANDT
  • C_PRATAXRPTGHISTORYOKQRY.TAXEXEMPTCODE5 == OIUT5_EXCD.EXEMPT_CODE
Unit Venture
  • Company Code
  • Client
  • Unit Venture
  • C_PRATAXRPTGHISTORYOKQRY.COMPANYCODE == OIU_DO_JV.BUKRS
  • C_PRATAXRPTGHISTORYOKQRY.MANDT == OIU_DO_JV.MANDT
  • C_PRATAXRPTGHISTORYOKQRY.UNITJOINTVENTURE == OIU_DO_JV.VNAME
Volume type code C_PRATAXRPTGHISTORYOKQRY.VOLUMETYPE == OIU_PR_VLTYP.VL_TYPE_CD
Well ID number
  • Client
  • Well ID number
Well Completion Number
  • Client
  • Well ID number
  • Well Completion Number
  • C_PRATAXRPTGHISTORYOKQRY.MANDT == OIU_PR_WC.MANDT
  • C_PRATAXRPTGHISTORYOKQRY.WELL == OIU_PR_WC.WL_NO
  • C_PRATAXRPTGHISTORYOKQRY.WELLCOMPLETION == OIU_PR_WC.WC_NO