I_PRATaxRptgHistoryNewMexico

PRA Tax Reporting History New Mexico | view: IPVTAXRPTGHISTNM | TRAN | Extraction: Full only | Component: Production and Revenue Accounting
Tables used: OIUX8_NM_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
NewMexicoTaxRptgSuffix Tax 2.0 - New Mexico Suffix for School Dist Code
TaxRptgRvslOrBkgOrAdjmt Tax 2.0 - NM Reversal/Booking/Reversal Adjustment/Adjustment Show values
Column Name Description
💲 Currency Key (CompanyCodeCurrency):
GrossValInCoCodeCrcy Gross Value
TaxableValInCoCodeCrcy Taxable Value
TaxExmptValInCoCodeCrcy Exempt Value
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
MktgReimbmtCost1InCoCdCrcy Marketing Reimbmt Cost 1
MktgReimbmtCost2InCoCdCrcy Marketing Reimbmt Cost 2
MktgReimbmtCost3InCoCdCrcy Marketing Reimbmt Cost 3
MktgReimbmtCost4InCoCdCrcy Marketing Reimbmt Cost 4
MktgReimbmtCost5InCoCdCrcy Marketing Reimbmt Cost 5
MktgReimbmtCost6InCoCdCrcy Marketing Reimbmt Cost 6
MktgReimbmtCost7InCoCdCrcy Marketing Reimbmt Cost 7
MktgReimbmtCost8InCoCdCrcy Marketing Reimbmt Cost 8
MktgReimbmtCost9InCoCdCrcy Marketing Reimbmt Cost 9
MktgReimbmtCost10InCoCdCrcy Marketing Reimbmt Cost 10
SeveranceTaxAmtInCoCodeCrcy Tax 2.0 - NM - Severance Tax Amount
ConservationTaxAmtInCoCdCrcy Tax 2.0 - NM - Conservation Tax Amount
EmergcySchoolTxAmtInCoCdCrcy Tax 2.0 - NM - Emergency School Tax Amount
AdValoremTaxAmtInCoCodeCrcy Tax 2.0 - NM - Ad Valorem Tax Amount
TaxReimbmtAmtInCoCodeCrcy Tax Reimbursement
GrossSalesValInCoCodeCrcy Tax 2.0 - NM Before Lease Plant Split Gross Value
TaxProcgAllwncAmtInCoCdCrcy Tax 2.0 - NM Plant Processing Allowance
Column Name Description
Column Name Description
SalesDate Sales Date / Month
Column Name Description
TaxRptgRvslOrBkgOrAdjmt Tax 2.0 - NM Reversal/Booking/Reversal Adjustment/Adjustment Show values
EntityIsAffectedByAudit Tax 2.0 - NM - Affected By Audit Flag (TC 55) Show values
MasterDataRecordingLvl Texas Master Data Level Show values
OperatorOrPurchaserCode Tax 2.0 - NM - Operator/Purchaser Indicator Show values
ProductType Tax 2.0 - NM - Product Code Show values
EntityAffiliationCode Tax 2.0 - NM - Affilication Code Show values
TransactionCode Tax 2.0 - NM - Transaction Code 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
ReturnedProductRatio Returned Product Ratio
ProductionUnitNumber Tax 2.0 - NM - PUN
TaxRate Tax 2.0 - NM - Special Tax Rate Code
ReportingIDByAgency Tax 2.0 - New Mexico Oil & Gas Reporting ID
ValuationDocumentNumber Val. document number OIU_MP_NO
ValuationDocumentYear Document year GJAHR
Country Country/Region Key LAND1
PrimaryGeogrlLocation Primary geographical location (PRI geo. loc.) OIU_PRI_GEO_LOC
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
TaxExmptVolInBaseUnit Exempt Volume OIUX3_SIGNED_DEC_11_2
GrossSalesVolInBaseUnit Tax 2.0 - NM Before Lease Plant Split Gross Volume OIUX3_SIGNED_DEC_11_2
OriginTransaction Source Transaction ID FQM_ORIGIN_TRANS_ID
Master Data Relations Join Conditions
Measurement unit
  • Client
  • Measurement unit
  • I_PRATAXRPTGHISTORYNEWMEXICO.MANDT == T006.MANDT
  • I_PRATAXRPTGHISTORYNEWMEXICO.BASEUNIT == T006.MSEHI
Company Code
  • Client
  • Company Code
  • I_PRATAXRPTGHISTORYNEWMEXICO.MANDT == OIU_CM_COMPC.MANDT
  • I_PRATAXRPTGHISTORYNEWMEXICO.COMPANYCODE == OIU_CM_COMPC.BUKRS
Currency Key
  • Client
  • Currency Key
  • I_PRATAXRPTGHISTORYNEWMEXICO.MANDT == TCURC.MANDT
  • I_PRATAXRPTGHISTORYNEWMEXICO.COMPANYCODECURRENCY == TCURC.WAERS
Delivery network number
  • Client
  • Delivery network number
  • I_PRATAXRPTGHISTORYNEWMEXICO.MANDT == OIU_PR_DN.MANDT
  • I_PRATAXRPTGHISTORYNEWMEXICO.DELIVERYNETWORK == OIU_PR_DN.DN_NO
Division of interest (DOI)
  • Division of interest (DOI)
  • Client
  • Company Code
  • Joint venture
  • I_PRATAXRPTGHISTORYNEWMEXICO.DIVISIONOFINTEREST == OIU_DO_DI.DOI_NO
  • I_PRATAXRPTGHISTORYNEWMEXICO.MANDT == OIU_DO_DI.MANDT
  • I_PRATAXRPTGHISTORYNEWMEXICO.COMPANYCODE == OIU_DO_DI.BUKRS
  • I_PRATAXRPTGHISTORYNEWMEXICO.JOINTVENTURE == OIU_DO_DI.VNAME
Joint venture
  • Client
  • Company Code
  • Joint venture
  • I_PRATAXRPTGHISTORYNEWMEXICO.MANDT == OIU_DO_JV.MANDT
  • I_PRATAXRPTGHISTORYNEWMEXICO.COMPANYCODE == OIU_DO_JV.BUKRS
  • I_PRATAXRPTGHISTORYNEWMEXICO.JOINTVENTURE == OIU_DO_JV.VNAME
Measurement point number
  • Client
  • Measurement point number
  • I_PRATAXRPTGHISTORYNEWMEXICO.MANDT == OIU_PR_MP.MANDT
  • I_PRATAXRPTGHISTORYNEWMEXICO.MEASUREMENTPOINT == OIU_PR_MP.MP_NO
Full three char. product code (Major and Detail Products) I_PRATAXRPTGHISTORYNEWMEXICO.PRODUCT == OIUX3_PDCD.PDCD
Tax Class
  • Client
  • Tax Class
  • ?
  • ?
  • I_PRATAXRPTGHISTORYNEWMEXICO.MANDT == OIU_CM_TAXCLS.MANDT
  • I_PRATAXRPTGHISTORYNEWMEXICO.TAXCLASSIFICATION == OIU_CM_TAXCLS.TAX_CLS
  • I_PRATAXRPTGHISTORYNEWMEXICO.[column in domain "OIU_PRI_GEO_LOC"] == OIU_CM_TAXCLS.PRI_GEO_LOC
  • I_PRATAXRPTGHISTORYNEWMEXICO.[column in domain "LAND1"] == OIU_CM_TAXCLS.COUNTRY
Unit Venture
  • Client
  • Unit Venture
  • Company Code
  • I_PRATAXRPTGHISTORYNEWMEXICO.MANDT == OIU_DO_JV.MANDT
  • I_PRATAXRPTGHISTORYNEWMEXICO.UNITJOINTVENTURE == OIU_DO_JV.VNAME
  • I_PRATAXRPTGHISTORYNEWMEXICO.COMPANYCODE == OIU_DO_JV.BUKRS
Volume type code I_PRATAXRPTGHISTORYNEWMEXICO.VOLUMETYPE == OIU_PR_VLTYP.VL_TYPE_CD
Well ID number
  • Client
  • Well ID number
  • I_PRATAXRPTGHISTORYNEWMEXICO.MANDT == OIU_PR_WELL.MANDT
  • I_PRATAXRPTGHISTORYNEWMEXICO.WELL == OIU_PR_WELL.WL_NO
Well Completion Number
  • Client
  • Well Completion Number
  • Well ID number
  • I_PRATAXRPTGHISTORYNEWMEXICO.MANDT == OIU_PR_WC.MANDT
  • I_PRATAXRPTGHISTORYNEWMEXICO.WELLCOMPLETION == OIU_PR_WC.WC_NO
  • I_PRATAXRPTGHISTORYNEWMEXICO.WELL == OIU_PR_WC.WL_NO