C_PRATaxRptgHistLAQry

Louisiana Tax Reporting History Query | view: CPVTAXRPTGHISTLA | Extraction: Not supported | Component: Production and Revenue Accounting
Tables used: /PRA/T9_TAXHST, T001, TKA02
Column Name Description
Column Name Description
💲 Currency Key (CompanyCodeCurrency):
GrossValInCoCodeCrcy Gross value
TaxExmpValInCoCodeCrcy Exempt Value
MktgCostInCoCodeCrcy Marketing Cost
FixedMktgCostInCoCodeCrcy Tax 2.0 LA - Fixed Marketing Cost
MktgReimbmtCostInCoCodeCrcy Marketing Cost Reimbursement
TaxableValInCoCodeCrcy Taxable Value
SeveranceTaxAmtInCoCodeCrcy Tax 2.0 LA - Severance Tax amount
OilFldRestoreTxAmtInCoCdCrcy Tax 2.0 LA - Oil Field Restoration Fee
DelinquentTxAmtDueInCoCdCrcy Tax 2.0 LA - Interest
Column Name Description
📏 Measurement unit (BaseUnit):
GrossVolInBaseUnit Total Gross Volume
WetGasLessResidueGasVolInMCF Wet-less-residue volume
TaxExmptVolInBaseUnit Exempt Volume
TaxableVolInBaseUnit Taxable Volume
Column Name Description
SalesDate Sales Date / Month
Column Name Description
TaxRptgRvslOrBkgOrAdjmt Reversal/Booking/Adjustment Show values
ProducerOrPurchaserCode Producer or Purchaser Show values
MasterDataRecordingLvl Texas Master Data Level Show values
LouisianaCounty Tax 2.0 LA - Parish Show values
EntityIsCompanyOperated Operated flag Show values
LouisianaTaxRptgKind Tax 2.0 LA - Kind Code Show values
IsWellDeepOrHorizontal Tax 2.0 LA - Deep or Horizontal Well Show values
RejectedOrSuspendedType Rejection-Suspension Status Show values
Column Name Description Domain name
ProducerOrPurchaserNmbr Producer/Purchaser Number OIUCM_MASTER
HasSeveranceTaxPaytOblgn Tax Severance Tax Calculation Payment Obligations Types OIU_SEVT_PAY_FL
SeveranceTaxRptgType State Severance Tax Reporting Indicators CHAR1
ValuationDocumentNumber Val. document number OIU_MP_NO
ValuationDocumentYear Document year GJAHR
TaxPayerIDByAgency Tax 2.0 LA - Tax ID
ReportingName Tax 2.0 LA - Reporting Name
PayerCodeByAgency Tax 2.0 LA - Taxpayer Code /PRA/T9_PROD_TRANSP_CD
LastChangedByUser Changed By XUBNAME
ChangedDateTime Changed On Timestamp TZNTSTMPS
Country Country/Region Key LAND1
PrimaryGeogrlLocation Primary geographical location (PRI geo. loc.) OIU_PRI_GEO_LOC
Master Data Relations | to Other Relations ↓ Join Conditions
Measurement unit
  • Client
  • Measurement unit
  • C_PRATAXRPTGHISTLAQRY.MANDT == T006.MANDT
  • C_PRATAXRPTGHISTLAQRY.BASEUNIT == T006.MSEHI
Company Code
  • Client
  • Company Code
Currency Key
  • Client
  • Currency Key
  • C_PRATAXRPTGHISTLAQRY.MANDT == TCURC.MANDT
  • C_PRATAXRPTGHISTLAQRY.COMPANYCODECURRENCY == TCURC.WAERS
Delivery network number
  • Client
  • Delivery network number
  • C_PRATAXRPTGHISTLAQRY.MANDT == OIU_PR_DN.MANDT
  • C_PRATAXRPTGHISTLAQRY.DELIVERYNETWORK == OIU_PR_DN.DN_NO
Division of interest (DOI)
  • Division of interest (DOI)
  • Client
  • Joint venture
  • Company Code
  • C_PRATAXRPTGHISTLAQRY.DIVISIONOFINTEREST == OIU_DO_DI.DOI_NO
  • C_PRATAXRPTGHISTLAQRY.MANDT == OIU_DO_DI.MANDT
  • C_PRATAXRPTGHISTLAQRY.JOINTVENTURE == OIU_DO_DI.VNAME
  • C_PRATAXRPTGHISTLAQRY.COMPANYCODE == OIU_DO_DI.BUKRS
Joint venture
  • Client
  • Joint venture
  • Company Code
  • C_PRATAXRPTGHISTLAQRY.MANDT == OIU_DO_JV.MANDT
  • C_PRATAXRPTGHISTLAQRY.JOINTVENTURE == OIU_DO_JV.VNAME
  • C_PRATAXRPTGHISTLAQRY.COMPANYCODE == OIU_DO_JV.BUKRS
Measurement point number
  • Client
  • Measurement point number
  • C_PRATAXRPTGHISTLAQRY.MANDT == OIU_PR_MP.MANDT
  • C_PRATAXRPTGHISTLAQRY.MEASUREMENTPOINT == OIU_PR_MP.MP_NO
Contract Number
  • Client
  • Contract Number
Full three char. product code (Major and Detail Products) C_PRATAXRPTGHISTLAQRY.PRODUCT == OIUX3_PDCD.PDCD
Tax 2.0 LA - Reject Code
  • Client
  • Tax 2.0 LA - Reject Code
Tax 2.0 LA - Lease Number
  • Client
  • ?
  • C_PRATAXRPTGHISTLAQRY.MANDT == /PRA/T9_LEASE.MANDT
  • C_PRATAXRPTGHISTLAQRY.[column in domain "/PRA/T9_LEASE_NO"] == /PRA/T9_LEASE.LEASE_NO
Tax Class
  • Tax Class
  • Client
  • ?
  • ?
  • C_PRATAXRPTGHISTLAQRY.TAXCLASSIFICATION == OIU_CM_TAXCLS.TAX_CLS
  • C_PRATAXRPTGHISTLAQRY.MANDT == OIU_CM_TAXCLS.MANDT
  • C_PRATAXRPTGHISTLAQRY.[column in domain "OIU_PRI_GEO_LOC"] == OIU_CM_TAXCLS.PRI_GEO_LOC
  • C_PRATAXRPTGHISTLAQRY.[column in domain "LAND1"] == OIU_CM_TAXCLS.COUNTRY
Tax 2.0 LA - Tax Rate Code
  • Client
  • ?
  • Tax 2.0 LA - Tax Rate Code
  • C_PRATAXRPTGHISTLAQRY.MANDT == /PRA/C_T9_TRC.MANDT
  • C_PRATAXRPTGHISTLAQRY.[column in domain "OIUE2_PROCESS_ID"] == /PRA/C_T9_TRC.PROC_ID
  • C_PRATAXRPTGHISTLAQRY.TAXRATE == /PRA/C_T9_TRC.TAX_RATE_CD
Unit venture
  • Client
  • Unit venture
  • Company Code
  • C_PRATAXRPTGHISTLAQRY.MANDT == OIU_DO_JV.MANDT
  • C_PRATAXRPTGHISTLAQRY.UNITJOINTVENTURE == OIU_DO_JV.VNAME
  • C_PRATAXRPTGHISTLAQRY.COMPANYCODE == OIU_DO_JV.BUKRS
Volume type code C_PRATAXRPTGHISTLAQRY.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_PRATAXRPTGHISTLAQRY.MANDT == OIU_PR_WC.MANDT
  • C_PRATAXRPTGHISTLAQRY.WELL == OIU_PR_WC.WL_NO
  • C_PRATAXRPTGHISTLAQRY.WELLCOMPLETION == OIU_PR_WC.WC_NO
Other Relations | to Master Data Relations ↑ Join Conditions
Tax 2.0 LA - Field ID
  • Client
  • Tax 2.0 LA - Field ID
Tax 2.0 LA - Plant ID
  • Tax 2.0 LA - Plant ID
  • Client