/PRA/ND_PRDT - Tax 2.0 - North Dakota PRA Detail Tax Transaction

Tax 2.0 - North Dakota PRA Detail Tax Transaction information is stored in SAP table /PRA/ND_PRDT.
It is part of development package /PRA/TAX_ND in software component IS-OIL-PRA. This development package consists of objects that can be grouped under "Tax Reporting - North Dakota".

Fields for table /PRA/ND_PRDT

Field Name
Description
Is Key
Data Element
Data Type
Length
Check Table
MANDTClientXMANDTCLNT6
RUN_IDRun ID of Tax ReportXOIUX3_RUN_IDNUMC20
.INCLUDE/PRA/S_ND_TAXTXN_KEYX/PRA/S_ND_TAXTXN_KEY0
.INCLUDE/PRA/S_ND_TAXREV_KEYX/PRA/S_ND_TAXREV_KEY0
BUKRSCompany CodeXBUKRSCHAR8OIU_CM_COMPC
SALES_DTSales Date / MonthXOIU_SALE_DTDATS16
PDCDFull three char. product code (Major and Detail Products)XOIU_FULL_PD_CDCHAR6OIUX3_PDCD
WL_NOWell ID numberXOIU_WL_NOCHAR30OIU_PR_WELL
WC_NOWell Completion NumberXOIU_WC_NOCHAR10OIU_PR_WC
MP_NOMeasurement point numberXOIU_MP_NOCHAR40OIU_PR_MP
VNAMEJoint ventureXJV_NAMECHAR12OIU_DO_JV
DOI_NODivision of interest (DOI)XOIU_DOI_NOCHAR10OIU_DO_DI
DN_NODelivery network numberXOIU_DN_NOCHAR40OIU_PR_DN
CT_NOContract NumberXOIU_CT_NOCHAR20OIU_RV_CT
VL_TYPE_CDVolume type codeXOIU_VT_CDCHAR4OIU_PR_VLTYP
TAX_CLSTax ClassXOIU_TAX_CLSCHAR8OIU_CM_TAXCLS
REV_BOOK_ADJ_INDReversal/Booking/AdjustmentX/PRA/ND_REV_BOOKING_ADJ_INDCHAR2
OUT_OF_STATUTEOut of StatuteOIUX3_OUT_OF_STATUTECHAR2
.INCLUDE/PRA/S_ND_TAXTXN_NONKEY/PRA/S_ND_TAXTXN_NONKEY0
PROD_PURC_INDProducer or PurchaserOIUX3_PRODUCER_PURCHASER_INDCHAR2
UNIT_VNAMEJoint ventureJV_NAMECHAR12OIU_DO_JV
PAY_FLTax Severance Tax Calculation Payment Obligations TypesOIU_SEVT_PAY_FLCHAR2
RPT_FLState Severance Tax Reporting IndicatorsOIU_SEVT_RPT_FLCHAR2
UOMMeasurement unitOIU_MEAS_UUNIT6T006
.INCLUDE/PRA/S_ND_PRDT_NUMFIELDS/PRA/S_ND_PRDT_NUMFIELDS0
BRL_OIL_PUR_SLDTax 2.0 - ND Barrels Of Oil Purchased or Sold/PRA/ND_BARREL_OIL_PUR_SOLDEC7
VAL_OIL_PUR_SLDTax 2.0 - ND Oil Value Purchased Or Sold/PRA/ND_OIL_VALUECURR7
EXEMPT_VALUETax 2.0 ND Ex Val Pur/Sold/PRA/ND_EXEMPT_VALUECURR7
TAX_VALUE_OILTax 2.0 - ND Oil Taxable Value/PRA/ND_TAX_VALUECURR7
PR_TAX_DUETax 2.0 - ND Production Tax Due/PRA/ND_PR_TAX_DUECURR7
PR_TAX_PREVTax 2.0 - ND Tax Previously Paid/PRA/ND_PR_TAX_PREVCURR7
PR_TAX_OTHERSTax 2.0 ND Production Tax Paid By Others/PRA/ND_PR_TAX_OTHERSCURR7
PR_TAX_PAIDTax 2.0 - ND Production Tax Paid By Report/PRA/ND_PR_TAX_REPORTCURR7
EX_TAX_DUETax 2.0 - ND Extraction Tax Due/PRA/ND_EX_TAX_DUECURR7
EX_TAX_PREVTax 2.0 - ND Extraction Tax Previously Paid/PRA/ND_EX_TAX_PREVCURR7
EX_TAX_OTHERSTax 2.0 - ND Extraction Tax Paid By Others/PRA/ND_EX_TAX_OTHERSCURR7
EX_TAX_PAIDTax 2.0 - ND Extraction Tax Paid By Report/PRA/ND_EX_TAX_REPORTCURR7
ADDITIONAL_VALTax 2.0 : ND Additional Value/PRA/ND_ADDITIONAL_VALCURR4
MKT_COST_01Marketing CostOIUX3_MARKETING_COSTCURR6
MKT_COST_02Marketing CostOIUX3_MARKETING_COSTCURR6
MKT_COST_03Marketing CostOIUX3_MARKETING_COSTCURR6
MKT_COST_04Marketing CostOIUX3_MARKETING_COSTCURR6
MKT_COST_05Marketing CostOIUX3_MARKETING_COSTCURR6
MKT_COST_06Marketing CostOIUX3_MARKETING_COSTCURR6
MKT_COST_07Marketing CostOIUX3_MARKETING_COSTCURR6
MKT_COST_08Marketing CostOIUX3_MARKETING_COSTCURR6
MKT_COST_09Marketing CostOIUX3_MARKETING_COSTCURR6
MKT_COST_10Marketing CostOIUX3_MARKETING_COSTCURR6
MKT_COST_REIMBMarketing Cost ReimbursementOIUX3_MARKETING_COST_REIMBCURR6
WELL_CODETax 2.0: ND Well Code/PRA/ND_WELL_CODECHAR4
POSTING_CODETax 2.0: ND Posting Code/PRA/ND_POSTING_CODECHAR8
API_NUMBERTax 2.0 ND API Number/PRA/ND_API_NUMBERCHAR16
API_NAMETax 2.0 North Dakota API Name/PRA/ND_API_NAMECHAR70
OIL_GRAVITYTax 2.0 : ND Oil Gravity/PRA/ND_OIL_GRAVITYDEC2
OTHER_NOCustomer / Vendor Number/PRA/CM_CUSTOMER_VENDOR_NUMBERCHAR20
OTH_FED_ID_NO_1Tax 2.0: Federal ID Number/PRA/ND_FEDERAL_ID_NONUMC18
TAXPAYER_NUMBERTax 2.0 ND Taxpayer Number/PRA/ND_TAX_PAYER_NOCHAR18
OPTION1CHAR2
OPTION2PPN FlagCHAR2
OPTION3CHAR2
DOC_NOVal. document numberOIURV_DOCNRCHAR40
DOC_YEARDocument yearOIU_DOC_YEARNUMC8
OIU_CRUSERName of Person Responsible for Creating the ObjectERNAMCHAR24
OIU_TIMESTAMPTax 2.0 Data Element for Timestamp/PRA/ND_TMPDEC8
Privacy Policy