/PRA/T9_TAXTXN

Tax 2.0 LA - Tax Transaction | #transactional | Component: Production and Revenue Accounting
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
REV_BOOK_ADJ_IND Reversal/Booking/Adjustment Show values
Column Name Description
💲 Currency Key (T001.WAERS):
GROSS_VAL Gross value
EXEMPT_VAL Exempt Value
MKT_COST Marketing Cost
FIXED_MKT_COST Tax 2.0 LA - Fixed Marketing Cost
MKT_COST_REIMB Marketing Cost Reimbursement
TAX_VAL Taxable Value
SV_TAX_AMT Tax 2.0 LA - Severance Tax amount
RF_TAX_AMT Tax 2.0 LA - Oil Field Restoration Fee
INTEREST Tax 2.0 LA - Interest
Column Name Description
📏 Base Unit of Measure (UOM):
GROSS_VOL Total Gross Volume
WET_LESS_RESIDUE Wet-less-residue volume
EXEMPT_VOL Exempt Volume
TAX_VOL Taxable Volume
Column Name Description
SALES_DT Sales Date / Month
Column Name Description
REV_BOOK_ADJ_IND Reversal/Booking/Adjustment Show values
PROD_PURC_IND Producer or Purchaser Show values
OOS_FL Out of Statute Show values
MASTER_LEVEL Texas Master Data Level Show values
PARISH Tax 2.0 LA - Parish Show values
MULTI_PARISH Tax 2.0 LA - Multiple Parish Show values
OPERATED_FL Operated flag Show values
KIND_CD Tax 2.0 LA - Kind Code Show values
DEEP_OR_HORIZ_WL Tax 2.0 LA - Deep or Horizontal Well Show values
REJ_SUSP_IND Rejection-Suspension Status Show values
Column Name Description Domain name
OTHER_NO Customer / Vendor Number OIUCM_MASTER
VL_TAX_RAT Volume tax rate OIUVL_PERCENT76
VAL_TAX_RAT Value tax rate OIUVL_PERCENT76
PAY_FL Tax Severance Tax Calculation Payment Obligations Types OIU_SEVT_PAY_FL
RPT_FL State Severance Tax Reporting Indicators CHAR1
DOC_NO Val. document number OIU_MP_NO
DOC_YEAR Document year GJAHR
OPTION1 Single-Character Flag CHAR1
OPTION2 Single-Character Flag CHAR1
OPTION3 Single-Character Flag CHAR1
INTERFACE_FL Single-Character Flag CHAR1
REVENUE_ACCT_NO Tax 2.0 LA - Tax ID
REPORTING_NAME Tax 2.0 LA - Reporting Name
REFERENCE_RUN_ID Proc 2.0 - Run ID
TAXPAYER_CD Tax 2.0 LA - Taxpayer Code /PRA/T9_PROD_TRANSP_CD
CHANGE_USER Last Changed By USNAM
CHANGE_TIMESTAMP Last Changed Timestamp /PRA/TZNTSTMPS
Master Data Relations | to Other Relations ↓ Join Conditions
Company Code
Contract Number
Delivery network number
Division of interest (DOI)
  • Joint venture
  • Division of interest (DOI)
  • Company Code
Tax 2.0 LA - Lease Number
Client /PRA/T9_TAXTXN.MANDT == T000.MANDT
Measurement point number
Full three char. product code (Major and Detail Products) /PRA/T9_TAXTXN.PDCD == OIUX3_PDCD.PDCD
Tax 2.0 LA - Reject Code
  • Tax 2.0 LA - Reject Code
  • Client
Tax Class
  • ?
  • ?
  • Client
  • Tax Class
Tax 2.0 LA - Tax Rate Code
  • ?
  • Tax 2.0 LA - Tax Rate Code
  • Client
Unit venture
  • Unit venture
  • Company Code
Base Unit of Measure
  • /PRA/T9_TAXTXN.MANDT == T006.MANDT
  • /PRA/T9_TAXTXN.UOM == T006.MSEHI
Volume type code /PRA/T9_TAXTXN.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
Tax 2.0 LA - Field ID
Tax 2.0 LA - Plant ID
  • Tax 2.0 LA - Plant ID
  • Client