OIUX8_NM_OOSTXN

Tax 2.0 - NM - Out-Of-Statute Transactions | #transactional | Component: Tax Reporting
Column Name Description
MANDT FK Client
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
SUFFIX Tax 2.0 - New Mexico Suffix for School Dist Code
REV_BOOK_ADJ_IND Tax 2.0 - NM Reversal/Booking/Reversal Adjustment/Adjustment Show values
Column Name Description
💲 Currency Key (T001.WAERS):
GROSS_VAL Gross Value
TAX_VAL Taxable Value
EXEMPT_VAL Exempt Value
MKT_COST_01 Marketing Cost
MKT_COST_02 Marketing Cost
MKT_COST_03 Marketing Cost
MKT_COST_04 Marketing Cost
MKT_COST_05 Marketing Cost
MKT_COST_06 Marketing Cost
MKT_COST_07 Marketing Cost
MKT_COST_08 Marketing Cost
MKT_COST_09 Marketing Cost
MKT_COST_10 Marketing Cost
MKT_COST_REIMB01 Marketing Cost Reimbursement
MKT_COST_REIMB02 Marketing Cost Reimbursement
MKT_COST_REIMB03 Marketing Cost Reimbursement
MKT_COST_REIMB04 Marketing Cost Reimbursement
MKT_COST_REIMB05 Marketing Cost Reimbursement
MKT_COST_REIMB06 Marketing Cost Reimbursement
MKT_COST_REIMB07 Marketing Cost Reimbursement
MKT_COST_REIMB08 Marketing Cost Reimbursement
MKT_COST_REIMB09 Marketing Cost Reimbursement
MKT_COST_REIMB10 Marketing Cost Reimbursement
SV_TAX_AMT Tax 2.0 - NM - Severance Tax Amount
CN_TAX_AMT Tax 2.0 - NM - Conservation Tax Amount
ES_TAX_AMT Tax 2.0 - NM - Emergency School Tax Amount
AV_TAX_AMT Tax 2.0 - NM - Ad Valorem Tax Amount
XX_TAX_AMT Tax 2.0 - NM - XX Tax Amount
TAX_REIMB Tax Reimbursement
BLPS_GROSS_VAL Tax 2.0 - NM Before Lease Plant Split Gross Value
PLANT_PROC_ALLOW Tax 2.0 - NM Plant Processing Allowance
Column Name Description
Column Name Description
SALES_DT Sales Date / Month
Column Name Description
REV_BOOK_ADJ_IND Tax 2.0 - NM Reversal/Booking/Reversal Adjustment/Adjustment Show values
AFF_BY_AUDIT Tax 2.0 - NM - Affected By Audit Flag (TC 55) Show values
MASTER_LEVEL Texas Master Data Level Show values
OPER_PURCH_IND Tax 2.0 - NM - Operator/Purchaser Indicator Show values
NM_PRODUCT_CODE Tax 2.0 - NM - Product Code Show values
AFFILIATION_CODE Tax 2.0 - NM - Affilication Code Show values
TRANSACTION_CODE Tax 2.0 - NM - Transaction Code Show values
INTERFACE_FL Tax 2.0 - NM - Interface Flag Show values
AUDIT_FL Tax 2.0 - New Mexico Audit Flag 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
EXEMPT_VOL Exempt Volume OIUX3_SIGNED_DEC_11_2
BLPS_GROSS_VOL Tax 2.0 - NM Before Lease Plant Split Gross Volume OIUX3_SIGNED_DEC_11_2
RET_LSE_PC Percent Returned to Lease OIU_PERCENT63
PUN Tax 2.0 - NM - PUN
PROP_ID Tax 2.0 - New Mexico Property ID
POOL_ID Tax 2.0 - New Mexico Pool ID
AGREEMENT_NO Tax 2.0 - New Mexico Agreement Number
SPEC_TAX_RATE_CD Tax 2.0 - NM - Special Tax Rate Code
OGRID Tax 2.0 - New Mexico Oil & Gas Reporting ID
DOC_NO Val. document number OIU_MP_NO
DOC_YEAR Document year GJAHR
OPTION1 null
OPTION2 null
OPTION3 null
IN_KIND Tax 2.0 - New Mexico Royalty-in-kind CHAR1
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
Delivery network number
Division of interest (DOI)
  • Joint venture
  • Division of interest (DOI)
  • Company Code
Client OIUX8_NM_OOSTXN.MANDT == T000.MANDT
Measurement point number
Full three char. product code (Major and Detail Products) OIUX8_NM_OOSTXN.PDCD == OIUX3_PDCD.PDCD
Tax Class
  • ?
  • ?
  • Client
  • Tax Class
Joint venture
  • Joint venture
  • Company Code
Measurement unit
  • OIUX8_NM_OOSTXN.MANDT == T006.MANDT
  • OIUX8_NM_OOSTXN.UOM == T006.MSEHI
Volume type code OIUX8_NM_OOSTXN.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