I_PRATaxRptgHistCOSvrnc

PRA Tax Reporting History CO Severance | view: IPVTXRPTGHCOS | TRAN | Extraction: Full only | Component: Production and Revenue Accounting
Tables used: /PRA/TA_ITAXHSTT001TKA02
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
PRAOwner Tax 2.0 CO - Owner Identifier
TaxRptgRvslOrBkgOrAdjmt Reversal/Booking/Adjustment Show values
Column Name Description
💲 Currency Key (CompanyCodeCurrency):
TransacAmtInCoCodeCrcy Tax 2.0 CO - Transaction Amount
MktgCost01InCoCodeCrcy Marketing Cost
MktgCost02InCoCodeCrcy Marketing Cost 2
MktgCost03InCoCodeCrcy Marketing Cost 3
MktgCost04InCoCodeCrcy Marketing Cost 4
MktgCost05InCoCodeCrcy Marketing Cost 5
MktgCost06InCoCodeCrcy Marketing Cost 6
MktgCost07InCoCodeCrcy Marketing Cost 7
MktgCost08InCoCodeCrcy Marketing Cost 8
MktgCost09InCoCodeCrcy Marketing Cost 9
MktgCost10InCoCodeCrcy Marketing Cost 10
AdValoremTaxAmtInCoCodeCrcy Tax 2.0 CO - Ad Valorem Tax amount
TranspCostInCoCodeCrcy Tax 2.0 CO - Transportation Cost
ProcgAndMfgCostInCoCodeCrcy Tax 2.0 CO - Ad Valorem Tax amount
Column Name Description
📏 Base Unit of Measure (BaseUnit):
OwnerVolReducnInMCF Tax 2.0 CO - PVR Amount
GrossVolInBaseUnit Total Gross Volume
Column Name Description
SalesDate Sales Date / Month
Column Name Description
TaxRptgRvslOrBkgOrAdjmt Reversal/Booking/Adjustment Show values
EntityIsTaxExempt Tax 2.0 CO - Exempt Flag Show values
RevenueProcessCode Revenue Process Code Show values
RejectedOrSuspendedType Rejection-Suspension Status Show values
ProductType Tax 2.0 CO - Oil/Gas Indicator Show values
OwnerInterestCategory Interest Category Show values
Column Name Description Domain name
FiscalPeriod Tax 2.0 CO - Accounting Period
UnitJointVenture Joint venture JV_NAME
ValuationDocumentNumber Val. document number OIU_MP_NO
ValuationDocumentYear Document year GJAHR
NetRevenueInterestRatio Tax 2.0 CO - Net Revenue Interest percent
ColoradoAccountNumber Tax 2.0 CO Sev - Colorado Account Number
SourceOfIncome Tax 2.0 CO - Source of Income /PRA/TA_SOURCE_OF_INCOME
APIWellNumber Tax 2.0 CO - API Number
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
TransacQtyInBaseUnit Tax 2.0 CO - Transaction Quantity OIUH_DEC13_2
Master Data Relations Join Conditions
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • I_PRATAXRPTGHISTCOSVRNC.MANDT == T006.MANDT
  • I_PRATAXRPTGHISTCOSVRNC.BASEUNIT == T006.MSEHI
Company Code
  • Company Code
  • Client
Currency Key
  • Currency Key
  • Client
  • I_PRATAXRPTGHISTCOSVRNC.COMPANYCODECURRENCY == TCURC.WAERS
  • I_PRATAXRPTGHISTCOSVRNC.MANDT == TCURC.MANDT
Cost Center
  • Client
  • ?
  • ?
  • Cost Center
  • I_PRATAXRPTGHISTCOSVRNC.MANDT == CSKS.MANDT
  • I_PRATAXRPTGHISTCOSVRNC.[column in domain "KOKRS"] == CSKS.KOKRS
  • I_PRATAXRPTGHISTCOSVRNC.[column in domain "DATBI"] == CSKS.DATBI
  • I_PRATAXRPTGHISTCOSVRNC.COSTCENTER == CSKS.KOSTL
Delivery network number
  • Delivery network number
  • Client
  • I_PRATAXRPTGHISTCOSVRNC.DELIVERYNETWORK == OIU_PR_DN.DN_NO
  • I_PRATAXRPTGHISTCOSVRNC.MANDT == OIU_PR_DN.MANDT
Division of interest (DOI)
  • Company Code
  • Division of interest (DOI)
  • Client
  • Joint venture
  • I_PRATAXRPTGHISTCOSVRNC.COMPANYCODE == OIU_DO_DI.BUKRS
  • I_PRATAXRPTGHISTCOSVRNC.DIVISIONOFINTEREST == OIU_DO_DI.DOI_NO
  • I_PRATAXRPTGHISTCOSVRNC.MANDT == OIU_DO_DI.MANDT
  • I_PRATAXRPTGHISTCOSVRNC.JOINTVENTURE == OIU_DO_DI.VNAME
G/L Account Number
  • Client
  • G/L Account Number
  • ?
  • I_PRATAXRPTGHISTCOSVRNC.MANDT == SKA1.MANDT
  • I_PRATAXRPTGHISTCOSVRNC.GLACCOUNT == SKA1.SAKNR
  • I_PRATAXRPTGHISTCOSVRNC.[column in domain "KTOPL"] == SKA1.KTOPL
Joint venture
  • Company Code
  • Client
  • Joint venture
  • I_PRATAXRPTGHISTCOSVRNC.COMPANYCODE == OIU_DO_JV.BUKRS
  • I_PRATAXRPTGHISTCOSVRNC.MANDT == OIU_DO_JV.MANDT
  • I_PRATAXRPTGHISTCOSVRNC.JOINTVENTURE == OIU_DO_JV.VNAME
Measurement point number
  • Measurement point number
  • Client
  • I_PRATAXRPTGHISTCOSVRNC.MEASUREMENTPOINT == OIU_PR_MP.MP_NO
  • I_PRATAXRPTGHISTCOSVRNC.MANDT == OIU_PR_MP.MANDT
Contract Number
  • Client
  • Contract Number
Full three char. product code (Major and Detail Products) I_PRATAXRPTGHISTCOSVRNC.PRODUCT == OIUX3_PDCD.PDCD
Tax 2.0 CO - Reject Code
  • Client
  • Tax 2.0 CO - Reject Code
Volume type code I_PRATAXRPTGHISTCOSVRNC.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_PRATAXRPTGHISTCOSVRNC.MANDT == OIU_PR_WC.MANDT
  • I_PRATAXRPTGHISTCOSVRNC.WELLCOMPLETION == OIU_PR_WC.WC_NO
  • I_PRATAXRPTGHISTCOSVRNC.WELL == OIU_PR_WC.WL_NO