I_PRATaxRptgHistWYConsvn

PRA Tax Reporting Hist WY Conservation | view: IPVTXRPTGHWYC | TRAN | Extraction: Full only | Component: Production and Revenue Accounting
Tables used: OIUX6_WY_CTAXHSTT001TKA02
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 Tax 2.0 - Reversal/Booking/Reversal Adjustment/Adjustment Show values
Column Name Description
💲 Currency Key (CompanyCodeCurrency):
TaxableValInCoCodeCrcy Taxable Value
GrossTaxAmtInCoCodeCrcy Tax Amount
TaxReimbmtAmtInCoCodeCrcy Tax Reimbursement
Column Name Description
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
EntityIsCompanyOperated Tax 2.0 - Operated Flag Show values
MasterDataRecordingLvl Texas Master Data Level Show values
ProductType Oil and Gas Indicator 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
GeologicFieldName Tax 2.0 - Wyoming Field Name
AgencyLeaseOrUnitName Tax 2.0 - Wyoming Lease Unit Name / API CHAR35
District Tax 2.0 - Wyoming Tax District NUMC4
PlantName Tax 2.0 - WY Gas Plant Name
OperatorIDByAgency Tax 2.0 - Wyoming Operator ID OIUX6_WY_OPERATOR_ID
OperatorName Tax 2.0 - Operator Name CHAR38
PurchaserName Tax 2.0 - Purchaser Name CHAR38
ValuationDocumentNumber Val. document number OIU_MP_NO
ValuationDocumentYear Document year GJAHR
Operator Master Record OIUCM_MASTER
Purchaser Master Record OIUCM_MASTER
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
OriginTransaction Source Transaction ID FQM_ORIGIN_TRANS_ID
GrossVolInBaseUnit Gross Volume OIUX3_SIGNED_DEC_11_2
TaxableVolInBaseUnit Taxable Volume OIUX3_SIGNED_DEC_11_2
TaxExmptVolInBaseUnit Exempt 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
PlantProcgVolInBaseUnit Tax 2.0 - Wyoming Plant Processing Volume OIUX3_SIGNED_DEC_11_2
Master Data Relations Join Conditions
Measurement unit
  • Client
  • Measurement unit
  • I_PRATAXRPTGHISTWYCONSVN.MANDT == T006.MANDT
  • I_PRATAXRPTGHISTWYCONSVN.BASEUNIT == T006.MSEHI
Company Code
  • Company Code
  • Client
Currency Key
  • Currency Key
  • Client
  • I_PRATAXRPTGHISTWYCONSVN.COMPANYCODECURRENCY == TCURC.WAERS
  • I_PRATAXRPTGHISTWYCONSVN.MANDT == TCURC.MANDT
Tax 2.0 - Wyoming County Identifier
  • ?
  • ?
  • Tax 2.0 - Wyoming County Identifier
  • Client
  • I_PRATAXRPTGHISTWYCONSVN.[column in domain "OIU_PRI_GEO_LOC"] == OIU_CM_LXSGL.PRI_GEO_LOC
  • I_PRATAXRPTGHISTWYCONSVN.[column in domain "LAND1"] == OIU_CM_LXSGL.LAND1
  • I_PRATAXRPTGHISTWYCONSVN.COUNTY == OIU_CM_LXSGL.SEC_GEO_LOC
  • I_PRATAXRPTGHISTWYCONSVN.MANDT == OIU_CM_LXSGL.MANDT
Delivery network number
  • Client
  • Delivery network number
  • I_PRATAXRPTGHISTWYCONSVN.MANDT == OIU_PR_DN.MANDT
  • I_PRATAXRPTGHISTWYCONSVN.DELIVERYNETWORK == OIU_PR_DN.DN_NO
Division of interest (DOI)
  • Division of interest (DOI)
  • Joint venture
  • Company Code
  • Client
  • I_PRATAXRPTGHISTWYCONSVN.DIVISIONOFINTEREST == OIU_DO_DI.DOI_NO
  • I_PRATAXRPTGHISTWYCONSVN.JOINTVENTURE == OIU_DO_DI.VNAME
  • I_PRATAXRPTGHISTWYCONSVN.COMPANYCODE == OIU_DO_DI.BUKRS
  • I_PRATAXRPTGHISTWYCONSVN.MANDT == OIU_DO_DI.MANDT
Joint venture
  • Joint venture
  • Company Code
  • Client
  • I_PRATAXRPTGHISTWYCONSVN.JOINTVENTURE == OIU_DO_JV.VNAME
  • I_PRATAXRPTGHISTWYCONSVN.COMPANYCODE == OIU_DO_JV.BUKRS
  • I_PRATAXRPTGHISTWYCONSVN.MANDT == OIU_DO_JV.MANDT
Measurement point number
  • Measurement point number
  • Client
  • I_PRATAXRPTGHISTWYCONSVN.MEASUREMENTPOINT == OIU_PR_MP.MP_NO
  • I_PRATAXRPTGHISTWYCONSVN.MANDT == OIU_PR_MP.MANDT
Full three char. product code (Major and Detail Products) I_PRATAXRPTGHISTWYCONSVN.PRODUCT == OIUX3_PDCD.PDCD
Tax Class
  • ?
  • ?
  • Client
  • Tax Class
  • I_PRATAXRPTGHISTWYCONSVN.[column in domain "OIU_PRI_GEO_LOC"] == OIU_CM_TAXCLS.PRI_GEO_LOC
  • I_PRATAXRPTGHISTWYCONSVN.[column in domain "LAND1"] == OIU_CM_TAXCLS.COUNTRY
  • I_PRATAXRPTGHISTWYCONSVN.MANDT == OIU_CM_TAXCLS.MANDT
  • I_PRATAXRPTGHISTWYCONSVN.TAXCLASSIFICATION == OIU_CM_TAXCLS.TAX_CLS
Joint venture
  • Company Code
  • Client
  • Joint venture
  • I_PRATAXRPTGHISTWYCONSVN.COMPANYCODE == OIU_DO_JV.BUKRS
  • I_PRATAXRPTGHISTWYCONSVN.MANDT == OIU_DO_JV.MANDT
  • I_PRATAXRPTGHISTWYCONSVN.UNITJOINTVENTURE == OIU_DO_JV.VNAME
Volume type code I_PRATAXRPTGHISTWYCONSVN.VOLUMETYPE == OIU_PR_VLTYP.VL_TYPE_CD
Well ID number
  • Well ID number
  • Client
Well Completion Number
  • Well Completion Number
  • Well ID number
  • Client
  • I_PRATAXRPTGHISTWYCONSVN.WELLCOMPLETION == OIU_PR_WC.WC_NO
  • I_PRATAXRPTGHISTWYCONSVN.WELL == OIU_PR_WC.WL_NO
  • I_PRATAXRPTGHISTWYCONSVN.MANDT == OIU_PR_WC.MANDT