OIUX5_OK_PRDT

Tax 2.0 - Oklahoma PRA Detail Tax Transactions | #transactional | Component: Tax Reporting
Column Name Description
MANDT Client
RUN_ID Run ID of Tax Report
BUKRS FK Company Code
SALES_DT Sales Date / Month
PDCD FK Full three char. product code (Major and Detail Products)
WL_NO FK Well ID number
WC_NO FK Well Completion Number
MP_NO FK Measurement point number
VNAME FK Joint venture
DOI_NO FK Division of interest (DOI)
DN_NO FK Delivery network number
CT_NO FK Contract Number
VL_TYPE_CD FK Volume type code
TAX_CLS FK Tax Class
REV_BOOK_ADJ_IND Tax 2.0 - Reversal/Booking/Reversal Adjustment/Adjustment Show values
Column Name Description
💲 Currency Key (T001.WAERS):
GROSS_VAL Gross Value
TAX_VAL Taxable Value
EXE_ENTTYPE1_VAL Tax 2.0 - Exempt Entity Type 1 Value
EXE_ENTTYPE2_VAL Tax 2.0 - Exempt Entity Type 2 Value
EXE_ENTTYPE3_VAL Tax 2.0 - Exempt Entity Type 3 Value
EXE_ENTTYPE4_VAL Tax 2.0 - Exempt Entity Type 4 Value
EXE_ENTTYPE5_VAL Tax 2.0 - Exempt Entity Type 5 Value
EXE_ENTTYPE6_VAL Tax 2.0 - Exempt Entity Type 6 Value
MKT_COST Marketing Cost
MKT_COST_REIMB Marketing Cost Reimbursement
GP_TAX_AMT Tax 2.0 - Gross Production Tax Amount
PE_TAX_AMT Tax 2.0 - Petroleum Excise Tax Amount
RF_TAX_AMT Tax 2.0 - Revolving Fund Tax Amount
MP_TAX_AMT Tax 2.0 - Marginally Producing Tax Amount
KW_TAX_AMT Tax 2.0 - Kiowa Tax Amount
CA_TAX_AMT Tax 2.0 - Cheyenne/Arapaho Tax Amount
XX_TAX_AMT Tax 2.0 - XX Tax Amount
TAX_REIMB Tax Reimbursement
Column Name Description
Column Name Description
SALES_DT Sales Date / Month
Column Name Description
REV_BOOK_ADJ_IND Tax 2.0 - Reversal/Booking/Reversal Adjustment/Adjustment Show values
OUT_OF_STATUTE Out of Statute Show values
PROD_PURC_IND Producer or Purchaser Show values
EXEMPT_CODE_1 Tax 2.0 - Oklahoma Exempt Code 1 Show values
EXEMPT_CODE_2 Tax 2.0 - Oklahoma Exempt Code 2 Show values
EXEMPT_CODE_3 Tax 2.0 - Oklahoma Exempt Code 3 Show values
EXEMPT_CODE_4 Tax 2.0 - Oklahoma Exempt Code 4 Show values
EXEMPT_CODE_5 Tax 2.0 - Oklahoma Exempt Code 5 Show values
EXEMPT_CODE_6 Tax 2.0 - Oklahoma Exempt Code 6 Show values
GAS_CODE Tax 2.0 - Oklahoma Gas Code Show values
OIL_CLASS Tax 2.0 - Oklahoma Oil Classification Show values
MULTI_COUNTIES Tax 2.0 - Multiple Counties? Show values
NGPA_CD Tax 2.0 OKGP – NGPA Code (Tax Incentive Rate Code) Show values
MASTER_LEVEL Tax 2.0 - Master Level Show values
OK_PRODUCT_CODE Tax 2.0 - Oklahoma Product Code Show values
Column Name Description Domain name
PAY_FL Tax Severance Tax Calculation Payment Obligations Types OIU_SEVT_PAY_FL
RPT_FL State Severance Tax Reporting Indicators CHAR1
GROSS_VOL Gross Volume OIUX3_SIGNED_DEC_11_2
TAX_VOL Taxable Volume OIUX3_SIGNED_DEC_11_2
EXE_ENTTYPE1_VOL Tax 2.0 - Exempt Entity Type 1 Volume OIUX3_SIGNED_DEC_11_2
EXE_ENTTYPE2_VOL Tax 2.0 - Exempt Entity Type 2 Volume OIUX3_SIGNED_DEC_11_2
EXE_ENTTYPE3_VOL Tax 2.0 - Exempt Entity Type 3 Volume OIUX3_SIGNED_DEC_11_2
EXE_ENTTYPE4_VOL Tax 2.0 - Exempt Entity Type 4 Volume OIUX3_SIGNED_DEC_11_2
EXE_ENTTYPE5_VOL Tax 2.0 - Exempt Entity Type 5 Volume OIUX3_SIGNED_DEC_11_2
EXE_ENTTYPE6_VOL Tax 2.0 - Exempt Entity Type 6 Volume OIUX3_SIGNED_DEC_11_2
GRAVITY Gravity OIUH_DEC3_1
BTU Tax 2.0 - British Thermal Unit (BTU) OIUH_DEC7_3
PROD_PURCH_NO Tax 2.0 - Oklahoma Producer/Purchaser Number
OTHER_PARTY Master Record OIUCM_MASTER
TAXPAYER_NUMBER Tax 2.0 - Oklahoma Taxpayer Number
TAXPAYER_NAME Taxpayer Name TEXT100
FEIN_SSN Tax 2.0 - FEIN/SSN
DOC_NO Val. document number OIU_MP_NO
DOC_YEAR Document year GJAHR
OPTION1 null
OPTION2 null
OPTION3 null
OIU_CRUSER Name of Person Responsible for Creating the Object USNAM
OIU_TIMESTAMP UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
Master Data Relations Join Conditions
Company Code
Tax 2.0 - Oklahoma County
  • ?
  • Client
  • ?
  • Tax 2.0 - Oklahoma County
Delivery network number
Division of interest (DOI)
  • Joint venture
  • Division of interest (DOI)
  • Company Code
Measurement point number
Business Associate
  • Sequence Number
  • Client
  • Business Associate
Sequence Number
  • Sequence Number
  • Client
  • Business Associate
Full three char. product code (Major and Detail Products) OIUX5_OK_PRDT.PDCD == OIUX3_PDCD.PDCD
Tax Class
  • ?
  • ?
  • Client
  • Tax Class
Joint venture
  • Joint venture
  • Company Code
Measurement unit
  • OIUX5_OK_PRDT.MANDT == T006.MANDT
  • OIUX5_OK_PRDT.UOM == T006.MSEHI
Volume type code OIUX5_OK_PRDT.VL_TYPE_CD == OIU_PR_VLTYP.VL_TYPE_CD
Joint venture
  • Joint venture
  • Company Code
Well Completion Number
  • Well ID number
  • Well Completion Number
Well ID number