C_PRATaxRptgHistoryNDQry

PRA Tax Reporting History ND Query | view: CPVTAXRPTGHND | Extraction: Not supported | Component: Production and Revenue Accounting
Tables used: /PRA/ND_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):
OilValueInCoCodeCrcy Tax 2.0 - ND Oil Value Purchased Or Sold
TaxExmpValInCoCodeCrcy Tax 2.0 ND Ex Val Pur/Sold
TaxableOilValInCoCodeCrcy Tax 2.0 - ND Oil Taxable Value
ProdnTaxDueAmtInCoCodeCrcy Tax 2.0 - ND Production Tax Due
ProdnTxPrevPaidAmtInCoCdCrcy Tax 2.0 - ND Tax Previously Paid
ProdnTaxOthPaidAmtInCoCdCrcy Tax 2.0 ND Production Tax Paid By Others
ProdnTaxPaidAmtInCoCodeCrcy Tax 2.0 - ND Production Tax Paid By Report
ExtractnTxDueAmtInCoCodeCrcy Tax 2.0 - ND Extraction Tax Due
ExtractnTxPrevAmtInCoCdCrcy Tax 2.0 - ND Extraction Tax Previously Paid
ExtractnTaxOthAmtInCoCdCrcy Tax 2.0 - ND Extraction Tax Paid By Others
ExtractnTaxPaidAmtInCoCdCrcy Tax 2.0 - ND Extraction Tax Paid By Report
AddlValInCoCodeCrcy Tax 2.0 : ND Additional Value
MktgCost01InCoCodeCrcy Marketing Cost
MktgCost02InCoCodeCrcy Marketing Cost
MktgCost03InCoCodeCrcy Marketing Cost
MktgCost04InCoCodeCrcy Marketing Cost
MktgCost05InCoCodeCrcy Marketing Cost
MktgCost06InCoCodeCrcy Marketing Cost
MktgCost07InCoCodeCrcy Marketing Cost
MktgCost08InCoCodeCrcy Marketing Cost
MktgCost09InCoCodeCrcy Marketing Cost
MktgCost10InCoCodeCrcy Marketing Cost
MktgReimbmtCostInCoCodeCrcy Marketing Cost Reimbursement
Column Name Description
Column Name Description
SalesDate Sales Date / Month
Column Name Description
TaxRptgRvslOrBkgOrAdjmt Reversal/Booking/Adjustment Show values
ProducerOrPurchaserCode Producer or Purchaser Show values
Column Name Description Domain name
HasSeveranceTaxPaytOblgn Tax Severance Tax Calculation Payment Obligations Types OIU_SEVT_PAY_FL
SeveranceTaxRptgType State Severance Tax Reporting Indicators CHAR1
NorthDakotaTaxExmpWellType Tax 2.0: ND Well Code /PRA/ND_WELL_CODE
NorthDakotaPostalAreaCode Tax 2.0: ND Posting Code /PRA/ND_POSTING_CODE
APIWellNumber Tax 2.0 ND API Number CHAR8
APIWellName Tax 2.0 North Dakota API Name
APIGravityRatio Tax 2.0 : ND Oil Gravity /PRA/SIGNED_DEC_3_1
ProducerOrPurchaserNmbr Customer / Vendor Number OIUCM_MASTER
FederalIDByAgency Tax 2.0: Federal ID Number
TaxPayerIDByAgency Tax 2.0 ND Taxpayer Number
Reservoir Tax 2.0: ND Pool Code /PRA/ND_POOL_CODE
ValuationDocumentNumber Val. document number OIU_MP_NO
ValuationDocumentYear Document year GJAHR
CreatedByUser Created By XUBNAME
CreationDateTime Created On Timestamp TZNTSTMPS
Country Country/Region Key LAND1
PrimaryGeogrlLocation Primary geographical location (PRI geo. loc.) OIU_PRI_GEO_LOC
OilVolumeInBarrels Tax 2.0 - ND Barrels Of Oil Purchased or Sold /PRA/SIGNED_DEC_13_3
Master Data Relations Join Conditions
Measurement unit
  • Client
  • Measurement unit
  • C_PRATAXRPTGHISTORYNDQRY.MANDT == T006.MANDT
  • C_PRATAXRPTGHISTORYNDQRY.BASEUNIT == T006.MSEHI
Company Code
  • Client
  • Company Code
Currency Key
  • Client
  • Currency Key
  • C_PRATAXRPTGHISTORYNDQRY.MANDT == TCURC.MANDT
  • C_PRATAXRPTGHISTORYNDQRY.COMPANYCODECURRENCY == TCURC.WAERS
Delivery network number
  • Client
  • Delivery network number
  • C_PRATAXRPTGHISTORYNDQRY.MANDT == OIU_PR_DN.MANDT
  • C_PRATAXRPTGHISTORYNDQRY.DELIVERYNETWORK == OIU_PR_DN.DN_NO
Division of interest (DOI)
  • Client
  • Joint venture
  • Division of interest (DOI)
  • Company Code
  • C_PRATAXRPTGHISTORYNDQRY.MANDT == OIU_DO_DI.MANDT
  • C_PRATAXRPTGHISTORYNDQRY.JOINTVENTURE == OIU_DO_DI.VNAME
  • C_PRATAXRPTGHISTORYNDQRY.DIVISIONOFINTEREST == OIU_DO_DI.DOI_NO
  • C_PRATAXRPTGHISTORYNDQRY.COMPANYCODE == OIU_DO_DI.BUKRS
Joint venture
  • Client
  • Joint venture
  • Company Code
  • C_PRATAXRPTGHISTORYNDQRY.MANDT == OIU_DO_JV.MANDT
  • C_PRATAXRPTGHISTORYNDQRY.JOINTVENTURE == OIU_DO_JV.VNAME
  • C_PRATAXRPTGHISTORYNDQRY.COMPANYCODE == OIU_DO_JV.BUKRS
Measurement point number
  • Client
  • Measurement point number
  • C_PRATAXRPTGHISTORYNDQRY.MANDT == OIU_PR_MP.MANDT
  • C_PRATAXRPTGHISTORYNDQRY.MEASUREMENTPOINT == OIU_PR_MP.MP_NO
Full three char. product code (Major and Detail Products) C_PRATAXRPTGHISTORYNDQRY.PRODUCT == OIUX3_PDCD.PDCD
Tax Class
  • Client
  • ?
  • ?
  • Tax Class
  • C_PRATAXRPTGHISTORYNDQRY.MANDT == OIU_CM_TAXCLS.MANDT
  • C_PRATAXRPTGHISTORYNDQRY.[column in domain "OIU_PRI_GEO_LOC"] == OIU_CM_TAXCLS.PRI_GEO_LOC
  • C_PRATAXRPTGHISTORYNDQRY.[column in domain "LAND1"] == OIU_CM_TAXCLS.COUNTRY
  • C_PRATAXRPTGHISTORYNDQRY.TAXCLASSIFICATION == OIU_CM_TAXCLS.TAX_CLS
Joint venture
  • Client
  • Joint venture
  • Company Code
  • C_PRATAXRPTGHISTORYNDQRY.MANDT == OIU_DO_JV.MANDT
  • C_PRATAXRPTGHISTORYNDQRY.UNITJOINTVENTURE == OIU_DO_JV.VNAME
  • C_PRATAXRPTGHISTORYNDQRY.COMPANYCODE == OIU_DO_JV.BUKRS
Volume type code C_PRATAXRPTGHISTORYNDQRY.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_PRATAXRPTGHISTORYNDQRY.MANDT == OIU_PR_WC.MANDT
  • C_PRATAXRPTGHISTORYNDQRY.WELL == OIU_PR_WC.WL_NO
  • C_PRATAXRPTGHISTORYNDQRY.WELLCOMPLETION == OIU_PR_WC.WC_NO