I_PRATaxRptgHistoryKansas

PRA Tax Reporting History Kansas | view: IPVTAXRPTGHISTKS | TRAN | Extraction: Full only | Component: Production and Revenue Accounting
Tables used: /PRA/KS_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 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
TaxableValInCoCodeCrcy Taxable Value
TaxExmptValInCoCodeCrcy Exempt Value
TaxAssmtValInCoCodeCrcy KCC Assessment Value
SeveranceTaxAmtInCoCodeCrcy Taxable Liability
MktgCostInCoCodeCrcy Marketing Cost
MktgReimbmtCostInCoCodeCrcy Marketing Cost Reimbursement
TaxReimbmtAmtInCoCodeCrcy Tax Reimbursement
Column Name Description
Column Name Description
SalesDate Sales Date / Month
Column Name Description
TaxRptgRvslOrBkgOrAdjmt Reversal/Booking/Adjustment Show values
OperatorOrPurchaserCode Tax Reporting: Kansas Operator and Purchaser Indicators Show values
TaxExemptCode Tax Reporting - Kansas Exemption Show values
Column Name Description Domain name
TaxExmpCertNmbr Exemption Certificate Number CHAR3
ValuationDocumentNumber Val. document number OIU_MP_NO
ValuationDocumentYear Document year GJAHR
HasSeveranceTaxPaytOblgn Tax Severance Tax Calculation Payment Obligations Types OIU_SEVT_PAY_FL
SeveranceTaxRptgType State Severance Tax Reporting Indicators CHAR1
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 /PRA/SIGNED_DEC_13_3
TaxableVolInBaseUnit Taxable Volume /PRA/SIGNED_DEC_13_3
TaxExmptVolInBaseUnit Exempt Volume /PRA/SIGNED_DEC_13_3
WetGasLessResidueGasVolInMCF Tax 2.0 Kansas Wetgas Less Residue /PRA/SIGNED_DEC_13_3
Master Data Relations Join Conditions
Measurement unit
  • Client
  • Measurement unit
  • I_PRATAXRPTGHISTORYKANSAS.MANDT == T006.MANDT
  • I_PRATAXRPTGHISTORYKANSAS.BASEUNIT == T006.MSEHI
Company Code
  • Company Code
  • Client
Currency Key
  • Client
  • Currency Key
  • I_PRATAXRPTGHISTORYKANSAS.MANDT == TCURC.MANDT
  • I_PRATAXRPTGHISTORYKANSAS.COMPANYCODECURRENCY == TCURC.WAERS
Delivery network number
  • Delivery network number
  • Client
  • I_PRATAXRPTGHISTORYKANSAS.DELIVERYNETWORK == OIU_PR_DN.DN_NO
  • I_PRATAXRPTGHISTORYKANSAS.MANDT == OIU_PR_DN.MANDT
Division of interest (DOI)
  • Joint venture
  • Company Code
  • Division of interest (DOI)
  • Client
  • I_PRATAXRPTGHISTORYKANSAS.JOINTVENTURE == OIU_DO_DI.VNAME
  • I_PRATAXRPTGHISTORYKANSAS.COMPANYCODE == OIU_DO_DI.BUKRS
  • I_PRATAXRPTGHISTORYKANSAS.DIVISIONOFINTEREST == OIU_DO_DI.DOI_NO
  • I_PRATAXRPTGHISTORYKANSAS.MANDT == OIU_DO_DI.MANDT
Joint venture
  • Joint venture
  • Company Code
  • Client
  • I_PRATAXRPTGHISTORYKANSAS.JOINTVENTURE == OIU_DO_JV.VNAME
  • I_PRATAXRPTGHISTORYKANSAS.COMPANYCODE == OIU_DO_JV.BUKRS
  • I_PRATAXRPTGHISTORYKANSAS.MANDT == OIU_DO_JV.MANDT
Full three char. product code (Major and Detail Products) I_PRATAXRPTGHISTORYKANSAS.PRODUCT == OIUX3_PDCD.PDCD
Tax Class
  • Client
  • ?
  • ?
  • Tax Class
  • I_PRATAXRPTGHISTORYKANSAS.MANDT == OIU_CM_TAXCLS.MANDT
  • I_PRATAXRPTGHISTORYKANSAS.[column in domain "OIU_PRI_GEO_LOC"] == OIU_CM_TAXCLS.PRI_GEO_LOC
  • I_PRATAXRPTGHISTORYKANSAS.[column in domain "LAND1"] == OIU_CM_TAXCLS.COUNTRY
  • I_PRATAXRPTGHISTORYKANSAS.TAXCLASSIFICATION == OIU_CM_TAXCLS.TAX_CLS
Unit Venture
  • Company Code
  • Client
  • Unit Venture
  • I_PRATAXRPTGHISTORYKANSAS.COMPANYCODE == OIU_DO_JV.BUKRS
  • I_PRATAXRPTGHISTORYKANSAS.MANDT == OIU_DO_JV.MANDT
  • I_PRATAXRPTGHISTORYKANSAS.UNITJOINTVENTURE == OIU_DO_JV.VNAME
Volume type code I_PRATAXRPTGHISTORYKANSAS.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_PRATAXRPTGHISTORYKANSAS.MANDT == OIU_PR_WC.MANDT
  • I_PRATAXRPTGHISTORYKANSAS.WELLCOMPLETION == OIU_PR_WC.WC_NO
  • I_PRATAXRPTGHISTORYKANSAS.WELL == OIU_PR_WC.WL_NO