/PRA/ND_PRDTA

Tax 2.0 - North Dakota PRA Detail Tax Transaction Allocated | #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
POOL_CODE Tax 2.0: ND Pool Code
REV_BOOK_ADJ_IND Reversal/Booking/Adjustment Show values
Column Name Description
💲 Currency Key (T001.WAERS):
VAL_OIL_PUR_SLD Tax 2.0 - ND Oil Value Purchased Or Sold
EXEMPT_VALUE Tax 2.0 ND Ex Val Pur/Sold
TAX_VALUE_OIL Tax 2.0 - ND Oil Taxable Value
PR_TAX_DUE Tax 2.0 - ND Production Tax Due
PR_TAX_PREV Tax 2.0 - ND Tax Previously Paid
PR_TAX_OTHERS Tax 2.0 ND Production Tax Paid By Others
PR_TAX_PAID Tax 2.0 - ND Production Tax Paid By Report
EX_TAX_DUE Tax 2.0 - ND Extraction Tax Due
EX_TAX_PREV Tax 2.0 - ND Extraction Tax Previously Paid
EX_TAX_OTHERS Tax 2.0 - ND Extraction Tax Paid By Others
EX_TAX_PAID Tax 2.0 - ND Extraction Tax Paid By Report
ADDITIONAL_VAL Tax 2.0 : ND Additional 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_REIMB Marketing Cost Reimbursement
Column Name Description
Column Name Description
SALES_DT Sales Date / Month
Column Name Description
REV_BOOK_ADJ_IND Reversal/Booking/Adjustment Show values
OUT_OF_STATUTE Out of Statute Show values
PROD_PURC_IND Producer or Purchaser Show values
Column Name Description Domain name
ALLOC_PERCENT Tax 2.0 - ND Allocation Percent OIU_PERCENT98
PAY_FL Tax Severance Tax Calculation Payment Obligations Types OIU_SEVT_PAY_FL
RPT_FL State Severance Tax Reporting Indicators CHAR1
BRL_OIL_PUR_SLD Tax 2.0 - ND Barrels Of Oil Purchased or Sold /PRA/SIGNED_DEC_13_3
WELL_CODE Tax 2.0: ND Well Code /PRA/ND_WELL_CODE
POSTING_CODE Tax 2.0: ND Posting Code /PRA/ND_POSTING_CODE
API_NUMBER Tax 2.0 ND API Number CHAR8
API_NAME Tax 2.0 North Dakota API Name
OIL_GRAVITY Tax 2.0 : ND Oil Gravity /PRA/SIGNED_DEC_3_1
OTHER_NO Customer / Vendor Number OIUCM_MASTER
OTH_FED_ID_NO_1 Tax 2.0: Federal ID Number
TAXPAYER_NUMBER Tax 2.0 ND Taxpayer Number
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 Tax 2.0 Data Element for Timestamp /PRA/ND_TMP
Master Data Relations Join Conditions
Company Code
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/ND_PRDTA.PDCD == OIUX3_PDCD.PDCD
Tax Class
  • ?
  • ?
  • Client
  • Tax Class
Joint venture
  • Joint venture
  • Company Code
Measurement unit
  • /PRA/ND_PRDTA.MANDT == T006.MANDT
  • /PRA/ND_PRDTA.UOM == T006.MSEHI
Volume type code /PRA/ND_PRDTA.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