I_PRATaxRptgHistoryTexas

PRA Tax Reporting History Texas | view: IPVTAXHISTTX | TRAN | Extraction: Full only | Component: Production and Revenue Accounting
Tables used: OIUX3_TX_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
SeveranceTaxType FK Severance Tax Type
TierTaxType Tier Tax Show values
TaxRptgRvslOrBkgOrAdjmt Reversal/Booking/Adjustment Show values
Column Name Description
💲 Currency Key (CompanyCodeCurrency):
GrossValInCoCodeCrcy Gross Value
TaxableValInCoCodeCrcy Taxable Value
TaxExmptValInCoCodeCrcy Exempt Value
MktgCostInCoCodeCrcy Marketing Cost
MktgReimbmtCostInCoCodeCrcy Marketing Cost Reimbursement
GrossTaxAmtInCoCodeCrcy Tax Amount
TaxReimbmtAmtInCoCodeCrcy Tax Reimbursement
Column Name Description
Column Name Description
SalesDate Sales Date / Month
Column Name Description
TierTaxType Tier Tax Show values
TaxRptgRvslOrBkgOrAdjmt Reversal/Booking/Adjustment Show values
ProducerOrPurchaserCode Producer or Purchaser Show values
OnOrOffLeaseSale Texas On-/Off-Lease Sale Code Show values
MasterDataRecordingLvl Texas Master Data Level Show values
CommodityType Texas Commodity Type 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
APIWellNumber API Well Number CHAR8
OtherPartyTaxPayerIDByAgency Texas Taxpayer Number of Other Party TEXT11
ProducerOrPurchaserNmbr Producer/Purchaser OIUCM_MASTER
TaxExmpType Texas Exemption Type NUMC2
TaxPayerIDByAgency Texas Taxpayer Number
TaxPayerName Taxpayer Name TEXT100
CreatedByUser Created By XUBNAME
CreationDateTime Created On Timestamp TZNTSTMPS
NumberOfItems Number of Items
Country Country/Region Key LAND1
PrimaryGeogrlLocation Primary geographical location (PRI geo. loc.) OIU_PRI_GEO_LOC
OriginTransaction Source Transaction ID FQM_ORIGIN_TRANS_ID
APIGravityRatio Gravity OIUH_DEC3_1
TransacVolInBaseUnit Lease Gross Volume OIUX3_SIGNED_DEC_11_2
GrossVolInBaseUnit Gross Volume OIUX3_SIGNED_DEC_11_2
TaxableVolInBaseUnit Taxable Volume OIUX3_SIGNED_DEC_11_2
TaxExmptVolInBaseUnit Exempt Volume OIUX3_SIGNED_DEC_11_2
Master Data Relations Join Conditions
Measurement unit
  • Measurement unit
  • Client
  • I_PRATAXRPTGHISTORYTEXAS.BASEUNIT == T006.MSEHI
  • I_PRATAXRPTGHISTORYTEXAS.MANDT == T006.MANDT
Company Code
  • Company Code
  • Client
Currency Key
  • Client
  • Currency Key
  • I_PRATAXRPTGHISTORYTEXAS.MANDT == TCURC.MANDT
  • I_PRATAXRPTGHISTORYTEXAS.COMPANYCODECURRENCY == TCURC.WAERS
Delivery network number
  • Client
  • Delivery network number
  • I_PRATAXRPTGHISTORYTEXAS.MANDT == OIU_PR_DN.MANDT
  • I_PRATAXRPTGHISTORYTEXAS.DELIVERYNETWORK == OIU_PR_DN.DN_NO
Division of interest (DOI)
  • Company Code
  • Joint venture
  • Client
  • Division of interest (DOI)
  • I_PRATAXRPTGHISTORYTEXAS.COMPANYCODE == OIU_DO_DI.BUKRS
  • I_PRATAXRPTGHISTORYTEXAS.JOINTVENTURE == OIU_DO_DI.VNAME
  • I_PRATAXRPTGHISTORYTEXAS.MANDT == OIU_DO_DI.MANDT
  • I_PRATAXRPTGHISTORYTEXAS.DIVISIONOFINTEREST == OIU_DO_DI.DOI_NO
Joint venture
  • Company Code
  • Joint venture
  • Client
  • I_PRATAXRPTGHISTORYTEXAS.COMPANYCODE == OIU_DO_JV.BUKRS
  • I_PRATAXRPTGHISTORYTEXAS.JOINTVENTURE == OIU_DO_JV.VNAME
  • I_PRATAXRPTGHISTORYTEXAS.MANDT == OIU_DO_JV.MANDT
Measurement point number
  • Measurement point number
  • Client
  • I_PRATAXRPTGHISTORYTEXAS.MEASUREMENTPOINT == OIU_PR_MP.MP_NO
  • I_PRATAXRPTGHISTORYTEXAS.MANDT == OIU_PR_MP.MANDT
Full three char. product code (Major and Detail Products) I_PRATAXRPTGHISTORYTEXAS.PRODUCT == OIUX3_PDCD.PDCD
Texas Lease Number
  • Texas County Identifier
  • Texas Lease Number
  • Client
Severance Tax Type
  • Severance Tax Type
  • ?
  • ?
  • Client
  • I_PRATAXRPTGHISTORYTEXAS.SEVERANCETAXTYPE == OIU_CM_SEVTTY.SEVT_TAX_TY
  • I_PRATAXRPTGHISTORYTEXAS.[column in domain "OIU_PRI_GEO_LOC"] == OIU_CM_SEVTTY.PRIM_GEO_LOC
  • I_PRATAXRPTGHISTORYTEXAS.[column in domain "LAND"] == OIU_CM_SEVTTY.COUNTRY
  • I_PRATAXRPTGHISTORYTEXAS.MANDT == OIU_CM_SEVTTY.MANDT
Tax Class
  • Tax Class
  • ?
  • ?
  • Client
  • I_PRATAXRPTGHISTORYTEXAS.TAXCLASSIFICATION == OIU_CM_TAXCLS.TAX_CLS
  • I_PRATAXRPTGHISTORYTEXAS.[column in domain "OIU_PRI_GEO_LOC"] == OIU_CM_TAXCLS.PRI_GEO_LOC
  • I_PRATAXRPTGHISTORYTEXAS.[column in domain "LAND1"] == OIU_CM_TAXCLS.COUNTRY
  • I_PRATAXRPTGHISTORYTEXAS.MANDT == OIU_CM_TAXCLS.MANDT
Unit Venture
  • Company Code
  • Unit Venture
  • Client
  • I_PRATAXRPTGHISTORYTEXAS.COMPANYCODE == OIU_DO_JV.BUKRS
  • I_PRATAXRPTGHISTORYTEXAS.UNITJOINTVENTURE == OIU_DO_JV.VNAME
  • I_PRATAXRPTGHISTORYTEXAS.MANDT == OIU_DO_JV.MANDT
Volume type code I_PRATAXRPTGHISTORYTEXAS.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_PRATAXRPTGHISTORYTEXAS.WELLCOMPLETION == OIU_PR_WC.WC_NO
  • I_PRATAXRPTGHISTORYTEXAS.WELL == OIU_PR_WC.WL_NO
  • I_PRATAXRPTGHISTORYTEXAS.MANDT == OIU_PR_WC.MANDT
Other Relations | to Master Data Relations ↑ Join Conditions
Texas County Identifier
  • Texas County Identifier
  • ?
  • I_PRATAXRPTGHISTORYTEXAS.TEXASCOUNTY == OIUX3_TX_CNTXRF.COUNTY
  • I_PRATAXRPTGHISTORYTEXAS.[column in domain "OIU_SEC_GEO_LOC"] == OIUX3_TX_CNTXRF.SEC_GEO_LOC