C_PRATaxRptgHistWYGrssProdQry

PRA Tax Reporting History WY Gross Product Query | view: CPVTAXRPTGHWYGP | Extraction: Not supported | Component: Production and Revenue Accounting
Tables used: OIUX7_WY_GTAXHST, T001, TKA02
Column Name Description
Column Name Description
💲 Currency Key (CompanyCodeCurrency):
GrossValInCoCodeCrcy Gross Value
TaxableValInCoCodeCrcy Taxable Value
TaxExmptVal1InCoCdCrcy Exempt Value
TaxExmptVal2InCoCdCrcy Exempt Value
TaxExmptVal3InCoCdCrcy Exempt Value
TaxExmptVal4InCoCdCrcy Exempt Value
TaxExmptVal5InCoCdCrcy Exempt 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
SeveranceTaxAmtInCoCodeCrcy Tax 2.0 - Severance Tax Amount
ArapahoTribeTaxAmtInCoCdCrcy Tax 2.0 - Wyoming Shoshone Arapaho Tax Amount
AdValoremTaxAmtInCoCodeCrcy Tax 2.0 - Wyoming Ad Valorem Tax Amount
TaxPrevPaidAmtInCoCodeCrcy Tax 2.0 - Previous Tax Paid
TaxReimbmtAmtInCoCodeCrcy Tax Reimbursement
GrossSalesValInCoCodeCrcy Tax 2.0 - Wyoming Before Lease Plant Split Gross Value
TaxProcgAllwncAmtInCoCdCrcy Tax 2.0 - Wyoming Plant Processing Allowance
Column Name Description
Column Name Description
SalesDate Sales Date / Month
Column Name Description
TaxTransacFormType Tax 2.0 - Original / Amended / Unknown Indicator Show values
EntityIsCompanyOperated Tax 2.0 - Operated Flag Show values
MasterDataRecordingLvl Texas Master Data Level Show values
TaxCode Tax 2.0 - Wyoming Rate Code Show values
ProductType Oil and Gas Indicator Show values
Plant Tax 2.0 - Wyoming Plant 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 Percent Returned to Lease OIU_PERCENT63
APIWellNumber Tax 2.0 - Wyoming API Well Number
WyomingTaxRptgSideTrackNmbr Tax 2.0 - Wyoming Side Track Number
Reservoir Tax 2.0 - Wyoming Reservoir
TaxRptgGroupNumber Tax 2.0 - Wyoming Report Group Number OIUX6_WY_REPORT_GROUP_NUMBER
GeologicField Tax 2.0 - Wyoming Field Name
AgencyLeaseOrUnitName Tax 2.0 - Wyoming Lease Unit Name / API CHAR35
District Tax 2.0 - Wyoming Tax District NUMC4
OperatorIDByAgency Tax 2.0 - Wyoming Operator ID OIUX6_WY_OPERATOR_ID
ValuationDocumentNumber Val. document number OIU_MP_NO
ValuationDocumentYear Document year GJAHR
CreatedByUser Created By XUBNAME
CreationDateTime Created On Timestamp TZNTSTMPS
GrossVolInBaseUnit Gross Volume OIUX3_SIGNED_DEC_11_2
WetGasLessResidueGasVolInMCF Tax 2.0 - Wet Less Residue Volume (MCF) OIUX3_SIGNED_DEC_11_2
GrossSalesVolInBaseUnit Tax 2.0 - Wyoming Before Lease Plant Split Gross 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
Measurement unit
  • Client
  • Measurement unit
  • C_PRATAXRPTGHISTWYGRSSPRODQRY.MANDT == T006.MANDT
  • C_PRATAXRPTGHISTWYGRSSPRODQRY.BASEUNIT == T006.MSEHI
Company Code
  • Company Code
  • Client
  • C_PRATAXRPTGHISTWYGRSSPRODQRY.COMPANYCODE == OIU_CM_COMPC.BUKRS
  • C_PRATAXRPTGHISTWYGRSSPRODQRY.MANDT == OIU_CM_COMPC.MANDT
Currency Key
  • Client
  • Currency Key
  • C_PRATAXRPTGHISTWYGRSSPRODQRY.MANDT == TCURC.MANDT
  • C_PRATAXRPTGHISTWYGRSSPRODQRY.COMPANYCODECURRENCY == TCURC.WAERS
Tax 2.0 - Wyoming County Identifier
  • Tax 2.0 - Wyoming County Identifier
  • Client
  • ?
  • ?
  • C_PRATAXRPTGHISTWYGRSSPRODQRY.COUNTY == OIU_CM_LXSGL.SEC_GEO_LOC
  • C_PRATAXRPTGHISTWYGRSSPRODQRY.MANDT == OIU_CM_LXSGL.MANDT
  • C_PRATAXRPTGHISTWYGRSSPRODQRY.[column in domain "OIU_PRI_GEO_LOC"] == OIU_CM_LXSGL.PRI_GEO_LOC
  • C_PRATAXRPTGHISTWYGRSSPRODQRY.[column in domain "LAND1"] == OIU_CM_LXSGL.LAND1
Delivery network number
  • Client
  • Delivery network number
  • C_PRATAXRPTGHISTWYGRSSPRODQRY.MANDT == OIU_PR_DN.MANDT
  • C_PRATAXRPTGHISTWYGRSSPRODQRY.DELIVERYNETWORK == OIU_PR_DN.DN_NO
Division of interest (DOI)
  • Division of interest (DOI)
  • Company Code
  • Client
  • Joint venture
  • C_PRATAXRPTGHISTWYGRSSPRODQRY.DIVISIONOFINTEREST == OIU_DO_DI.DOI_NO
  • C_PRATAXRPTGHISTWYGRSSPRODQRY.COMPANYCODE == OIU_DO_DI.BUKRS
  • C_PRATAXRPTGHISTWYGRSSPRODQRY.MANDT == OIU_DO_DI.MANDT
  • C_PRATAXRPTGHISTWYGRSSPRODQRY.JOINTVENTURE == OIU_DO_DI.VNAME
Joint venture
  • Company Code
  • Client
  • Joint venture
  • C_PRATAXRPTGHISTWYGRSSPRODQRY.COMPANYCODE == OIU_DO_JV.BUKRS
  • C_PRATAXRPTGHISTWYGRSSPRODQRY.MANDT == OIU_DO_JV.MANDT
  • C_PRATAXRPTGHISTWYGRSSPRODQRY.JOINTVENTURE == OIU_DO_JV.VNAME
Measurement point number
  • Measurement point number
  • Client
  • C_PRATAXRPTGHISTWYGRSSPRODQRY.MEASUREMENTPOINT == OIU_PR_MP.MP_NO
  • C_PRATAXRPTGHISTWYGRSSPRODQRY.MANDT == OIU_PR_MP.MANDT
Full three char. product code (Major and Detail Products) C_PRATAXRPTGHISTWYGRSSPRODQRY.PRODUCT == OIUX3_PDCD.PDCD
Tax Class
  • Client
  • ?
  • ?
  • Tax Class
  • C_PRATAXRPTGHISTWYGRSSPRODQRY.MANDT == OIU_CM_TAXCLS.MANDT
  • C_PRATAXRPTGHISTWYGRSSPRODQRY.[column in domain "OIU_PRI_GEO_LOC"] == OIU_CM_TAXCLS.PRI_GEO_LOC
  • C_PRATAXRPTGHISTWYGRSSPRODQRY.[column in domain "LAND1"] == OIU_CM_TAXCLS.COUNTRY
  • C_PRATAXRPTGHISTWYGRSSPRODQRY.TAXCLASSIFICATION == OIU_CM_TAXCLS.TAX_CLS
Joint venture
  • Joint venture
  • Company Code
  • Client
  • C_PRATAXRPTGHISTWYGRSSPRODQRY.UNITJOINTVENTURE == OIU_DO_JV.VNAME
  • C_PRATAXRPTGHISTWYGRSSPRODQRY.COMPANYCODE == OIU_DO_JV.BUKRS
  • C_PRATAXRPTGHISTWYGRSSPRODQRY.MANDT == OIU_DO_JV.MANDT
Volume type code C_PRATAXRPTGHISTWYGRSSPRODQRY.VOLUMETYPE == OIU_PR_VLTYP.VL_TYPE_CD
Well ID number
  • Well ID number
  • Client
  • C_PRATAXRPTGHISTWYGRSSPRODQRY.WELL == OIU_PR_WELL.WL_NO
  • C_PRATAXRPTGHISTWYGRSSPRODQRY.MANDT == OIU_PR_WELL.MANDT
Well Completion Number
  • Well ID number
  • Client
  • Well Completion Number
  • C_PRATAXRPTGHISTWYGRSSPRODQRY.WELL == OIU_PR_WC.WL_NO
  • C_PRATAXRPTGHISTWYGRSSPRODQRY.MANDT == OIU_PR_WC.MANDT
  • C_PRATAXRPTGHISTWYGRSSPRODQRY.WELLCOMPLETION == OIU_PR_WC.WC_NO