OIUX3_TX_TAXSTG

Tax Reporting - Texas Tax Transaction Staging | #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
TAX_TYPE FK Severance Tax Type
TIER_TAX_IND Tier Tax Show values
REV_BOOK_ADJ_IND Reversal/Booking/Adjustment Show values
Column Name Description
💲 Currency Key (T001.WAERS):
GROSS_VAL Gross Value
TAX_VAL Taxable Value
EXEMPT_VAL Exempt Value
MKT_COST Marketing Cost
MKT_COST_REIMB Marketing Cost Reimbursement
TAX_AMT Tax Amount
TAX_REIMB Tax Reimbursement
Column Name Description
Column Name Description
SALES_DT Sales Date / Month
Column Name Description
TIER_TAX_IND Tier Tax Show values
REV_BOOK_ADJ_IND Reversal/Booking/Adjustment Show values
PROD_PURC_IND Producer or Purchaser Show values
OFF_LEASE_CD Texas On-/Off-Lease Sale Code Show values
STATEWIDE TX Tax 2.0 - Statewide Lease Show values
MASTER_LEVEL Texas Master Data Level Show values
COMMODITY_TYPE Texas Commodity Type Show values
REJ_SUSP_IND Rejection-Suspension Status 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
LEASE_GROSS_VOL Lease Gross Volume OIUX3_SIGNED_DEC_11_2
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
TAX_RATE_VOL Volume tax rate OIUVL_PERCENT76
TAX_RATE_VAL Value tax rate OIUVL_PERCENT76
GRAVITY Gravity OIUH_DEC3_1
API_WELL_NUMBER API Well Number CHAR8
EOR_PROJECT Texas Tax - Project Number
OTHER_PARTY_NO Texas Taxpayer Number of Other Party TEXT11
OTHER_PARTY Master Record OIUCM_MASTER
EXEMPTION_TYPE Texas Exemption Type NUMC2
TAXPAYER_NUMBER Texas Taxpayer Number
TAXPAYER_NAME Taxpayer Name TEXT100
OPTION1 null
OPTION2 null
OPTION3 null
DOC_NO Val. document number OIU_MP_NO
DOC_YEAR Document year GJAHR
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
Texas Lease Number
  • Texas Lease Number
  • Texas County Identifier
Client OIUX3_TX_TAXSTG.MANDT == T000.MANDT
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) OIUX3_TX_TAXSTG.PDCD == OIUX3_PDCD.PDCD
Rejection Code
Tax Class
  • ?
  • ?
  • Client
  • Tax Class
Severance Tax Type
  • ?
  • Severance Tax Type
  • Client
  • ?
Joint venture
  • Joint venture
  • Company Code
Measurement unit
  • OIUX3_TX_TAXSTG.MANDT == T006.MANDT
  • OIUX3_TX_TAXSTG.UOM == T006.MSEHI
Volume type code OIUX3_TX_TAXSTG.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
Other Relations | to Master Data Relations ↑ Join Conditions
Texas County Identifier
  • ?
  • Texas County Identifier