/PRA/TA_PRDT

Tax 2.0 CO - Conservation report PRA Detail Transaction | #transactional | Component: Production and Revenue Accounting
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 Reversal/Booking/Adjustment Show values
Column Name Description
💲 Currency Key (T001.WAERS):
GROSS_VAL Gross value
EXEMPT_VAL_1 Charitable exempt value
EXEMPT_VAL_2 Federal entity exempt value
EXEMPT_VAL_3 US Indian exempt value
EXEMPT_VAL_4 State entity exempt value
EXEMPT_VAL_5 Other entity exempt value
MKT_COST Marketing Cost
FIXED_MKT_COST Fixed Marketing Cost
MKT_COST_REIMB Marketing Cost Reimbursement
TAX_VAL Taxable Value
CN_TAX_AMT Conservation Tax Amount
Column Name Description
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
REJ_SUSP_IND Rejection-Suspension Status Show values
PRODUCT_CD Product Cd 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
OPERATOR_NO OGCC Payor
LEVY_RATE Levy Rate
CHANGE_USER Last Changed By USNAM
CHANGE_TIMESTAMP Last Changed Timestamp /PRA/TZNTSTMPS
Master Data Relations Join Conditions
Company Code
Contract Number
Delivery network number
Division of interest (DOI)
  • Joint venture
  • Division of interest (DOI)
  • Company Code
Measurement point number
Full three char. product code (Major and Detail Products) /PRA/TA_PRDT.PDCD == OIUX3_PDCD.PDCD
Tax 2.0 CO - Reject Code
  • Tax 2.0 CO - Reject Code
  • Client
Tax Class
  • ?
  • ?
  • Client
  • Tax Class
Unit Venture
  • Unit Venture
  • Company Code
Base Unit of Measure
  • /PRA/TA_PRDT.MANDT == T006.MANDT
  • /PRA/TA_PRDT.UOM == T006.MSEHI
Volume type code /PRA/TA_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