I_PRATaxRptgHistLouisiana

PRA Tax Reporting History Louisiana | view: IPVTAXRPTGLA | TRAN | Extraction: Full only | Component: Production and Revenue Accounting
Tables used: /PRA/T9_TAXHSTT001TKA02
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 Reversal/Booking/Adjustment Show values
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
OriginTransaction Source Transaction ID FQM_ORIGIN_TRANS_ID
Master Data Relations | to Other Relations ↓ Join Conditions
Measurement unit
  • Measurement unit
  • Client
  • I_PRATAXRPTGHISTLOUISIANA.BASEUNIT == T006.MSEHI
  • I_PRATAXRPTGHISTLOUISIANA.MANDT == T006.MANDT
Company Code
  • Company Code
  • Client
Currency Key
  • Currency Key
  • Client
  • I_PRATAXRPTGHISTLOUISIANA.COMPANYCODECURRENCY == TCURC.WAERS
  • I_PRATAXRPTGHISTLOUISIANA.MANDT == TCURC.MANDT
Delivery network number
  • Client
  • Delivery network number
  • I_PRATAXRPTGHISTLOUISIANA.MANDT == OIU_PR_DN.MANDT
  • I_PRATAXRPTGHISTLOUISIANA.DELIVERYNETWORK == OIU_PR_DN.DN_NO
Division of interest (DOI)
  • Company Code
  • Client
  • Joint venture
  • Division of interest (DOI)
  • I_PRATAXRPTGHISTLOUISIANA.COMPANYCODE == OIU_DO_DI.BUKRS
  • I_PRATAXRPTGHISTLOUISIANA.MANDT == OIU_DO_DI.MANDT
  • I_PRATAXRPTGHISTLOUISIANA.JOINTVENTURE == OIU_DO_DI.VNAME
  • I_PRATAXRPTGHISTLOUISIANA.DIVISIONOFINTEREST == OIU_DO_DI.DOI_NO
Joint venture
  • Company Code
  • Client
  • Joint venture
  • I_PRATAXRPTGHISTLOUISIANA.COMPANYCODE == OIU_DO_JV.BUKRS
  • I_PRATAXRPTGHISTLOUISIANA.MANDT == OIU_DO_JV.MANDT
  • I_PRATAXRPTGHISTLOUISIANA.JOINTVENTURE == OIU_DO_JV.VNAME
Measurement point number
  • Client
  • Measurement point number
  • I_PRATAXRPTGHISTLOUISIANA.MANDT == OIU_PR_MP.MANDT
  • I_PRATAXRPTGHISTLOUISIANA.MEASUREMENTPOINT == OIU_PR_MP.MP_NO
Contract Number
  • Client
  • Contract Number
Full three char. product code (Major and Detail Products) I_PRATAXRPTGHISTLOUISIANA.PRODUCT == OIUX3_PDCD.PDCD
Tax 2.0 LA - Reject Code
  • Client
  • Tax 2.0 LA - Reject Code
Tax 2.0 LA - Lease Number
  • ?
  • Client
  • I_PRATAXRPTGHISTLOUISIANA.[column in domain "/PRA/T9_LEASE_NO"] == /PRA/T9_LEASE.LEASE_NO
  • I_PRATAXRPTGHISTLOUISIANA.MANDT == /PRA/T9_LEASE.MANDT
Tax Class
  • ?
  • ?
  • Client
  • Tax Class
  • I_PRATAXRPTGHISTLOUISIANA.[column in domain "OIU_PRI_GEO_LOC"] == OIU_CM_TAXCLS.PRI_GEO_LOC
  • I_PRATAXRPTGHISTLOUISIANA.[column in domain "LAND1"] == OIU_CM_TAXCLS.COUNTRY
  • I_PRATAXRPTGHISTLOUISIANA.MANDT == OIU_CM_TAXCLS.MANDT
  • I_PRATAXRPTGHISTLOUISIANA.TAXCLASSIFICATION == OIU_CM_TAXCLS.TAX_CLS
Tax 2.0 LA - Tax Rate Code
  • Tax 2.0 LA - Tax Rate Code
  • Client
  • ?
  • I_PRATAXRPTGHISTLOUISIANA.TAXRATE == /PRA/C_T9_TRC.TAX_RATE_CD
  • I_PRATAXRPTGHISTLOUISIANA.MANDT == /PRA/C_T9_TRC.MANDT
  • I_PRATAXRPTGHISTLOUISIANA.[column in domain "OIUE2_PROCESS_ID"] == /PRA/C_T9_TRC.PROC_ID
Unit venture
  • Company Code
  • Client
  • Unit venture
  • I_PRATAXRPTGHISTLOUISIANA.COMPANYCODE == OIU_DO_JV.BUKRS
  • I_PRATAXRPTGHISTLOUISIANA.MANDT == OIU_DO_JV.MANDT
  • I_PRATAXRPTGHISTLOUISIANA.UNITJOINTVENTURE == OIU_DO_JV.VNAME
Volume type code I_PRATAXRPTGHISTLOUISIANA.VOLUMETYPE == OIU_PR_VLTYP.VL_TYPE_CD
Well ID number
  • Client
  • Well ID number
Well Completion Number
  • Client
  • Well Completion Number
  • Well ID number
  • I_PRATAXRPTGHISTLOUISIANA.MANDT == OIU_PR_WC.MANDT
  • I_PRATAXRPTGHISTLOUISIANA.WELLCOMPLETION == OIU_PR_WC.WC_NO
  • I_PRATAXRPTGHISTLOUISIANA.WELL == OIU_PR_WC.WL_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