OIUX8_NM_PRDT - Tax 2.0 - NM - PRA Detail Transactions

Tax 2.0 - NM - PRA Detail Transactions information is stored in SAP table OIUX8_NM_PRDT.
It is part of development package OIU_X8 in software component IS-OIL-PRA-REP-TAX. This development package consists of objects that can be grouped under "Tax 2.0 - New Mexico".

Fields for table OIUX8_NM_PRDT

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
MANDT	Client	X	MANDT	CLNT	6	T000
RUN_ID	Run ID of Tax Report	X	OIUX3_RUN_ID	NUMC	20
.INCLUDE	ROIUX8_NM_TAXTXN_KEY	X		ROIUX8_NM_TAXTXN_KEY	0
.INCLUDE	ROIUX8_NM_REVTXN_KEY	X		ROIUX8_NM_REVTXN_KEY	0
BUKRS	Company Code	X	BUKRS	CHAR	8	OIU_CM_COMPC
SALES_DT	Sales Date / Month	X	OIU_SALE_DT	DATS	16
PDCD	Full three char. product code (Major and Detail Products)	X	OIU_FULL_PD_CD	CHAR	6	OIUX3_PDCD
WL_NO	Well ID number	X	OIU_WL_NO	CHAR	30	OIU_PR_WELL
WC_NO	Well Completion Number	X	OIU_WC_NO	CHAR	10	OIU_PR_WC
MP_NO	Measurement point number	X	OIU_MP_NO	CHAR	40	OIU_PR_MP
VNAME	Joint venture	X	JV_NAME	CHAR	12	OIU_DO_JV
DOI_NO	Division of interest (DOI)	X	OIU_DOI_NO	CHAR	10	OIU_DO_DI
DN_NO	Delivery network number	X	OIU_DN_NO	CHAR	40	OIU_PR_DN
CT_NO	Contract Number	X	OIU_CT_NO	CHAR	20	OIU_RV_CT
VL_TYPE_CD	Volume type code	X	OIU_VT_CD	CHAR	4	OIU_PR_VLTYP
TAX_CLS	Tax Class	X	OIU_TAX_CLS	CHAR	8	OIU_CM_TAXCLS
SUFFIX	Tax 2.0 - New Mexico Suffix for School Dist Code	X	OIUX8_NM_SUFFIX	CHAR	10
REV_BOOK_ADJ_IND	Tax 2.0 - NM Reversal/Booking/Reversal Adjustment/Adjustment	X	OIUX8_REV_BOOK_REVADJ_ADJ_IND	CHAR	2
OUT_OF_STATUTE	Out of Statute		OIUX3_OUT_OF_STATUTE	CHAR	2
.INCLUDE	ROIUX8_NM_TAXTXN_NONKEY			ROIUX8_NM_TAXTXN_NONKEY	0
UNIT_VNAME	Joint venture		JV_NAME	CHAR	12	OIU_DO_JV
PAY_FL	Tax Severance Tax Calculation Payment Obligations Types		OIU_SEVT_PAY_FL	CHAR	2
RPT_FL	State Severance Tax Reporting Indicators		OIU_SEVT_RPT_FL	CHAR	2
UOM	Measurement unit		OIU_MEAS_U	UNIT	6	T006
GROSS_VOL	Gross Volume		OIUX3_GROSS_VOLUME	DEC	6
GROSS_VAL	Gross Value		OIUX3_GROSS_VALUE	CURR	6
TAX_VOL	Taxable Volume		OIUX3_TAXABLE_VOLUME	DEC	6
TAX_VAL	Taxable Value		OIUX3_TAXABLE_VALUE	CURR	6
EXEMPT_VOL	Exempt Volume		OIUX3_EXEMPT_VOLUME	DEC	6
EXEMPT_VAL	Exempt Value		OIUX3_EXEMPT_VALUE	CURR	6
MKT_COST_01	Marketing Cost		OIUX3_MARKETING_COST	CURR	6
MKT_COST_02	Marketing Cost		OIUX3_MARKETING_COST	CURR	6
MKT_COST_03	Marketing Cost		OIUX3_MARKETING_COST	CURR	6
MKT_COST_04	Marketing Cost		OIUX3_MARKETING_COST	CURR	6
MKT_COST_05	Marketing Cost		OIUX3_MARKETING_COST	CURR	6
MKT_COST_06	Marketing Cost		OIUX3_MARKETING_COST	CURR	6
MKT_COST_07	Marketing Cost		OIUX3_MARKETING_COST	CURR	6
MKT_COST_08	Marketing Cost		OIUX3_MARKETING_COST	CURR	6
MKT_COST_09	Marketing Cost		OIUX3_MARKETING_COST	CURR	6
MKT_COST_10	Marketing Cost		OIUX3_MARKETING_COST	CURR	6
MKT_COST_REIMB01	Marketing Cost Reimbursement		OIUX3_MARKETING_COST_REIMB	CURR	6
MKT_COST_REIMB02	Marketing Cost Reimbursement		OIUX3_MARKETING_COST_REIMB	CURR	6
MKT_COST_REIMB03	Marketing Cost Reimbursement		OIUX3_MARKETING_COST_REIMB	CURR	6
MKT_COST_REIMB04	Marketing Cost Reimbursement		OIUX3_MARKETING_COST_REIMB	CURR	6
MKT_COST_REIMB05	Marketing Cost Reimbursement		OIUX3_MARKETING_COST_REIMB	CURR	6
MKT_COST_REIMB06	Marketing Cost Reimbursement		OIUX3_MARKETING_COST_REIMB	CURR	6
MKT_COST_REIMB07	Marketing Cost Reimbursement		OIUX3_MARKETING_COST_REIMB	CURR	6
MKT_COST_REIMB08	Marketing Cost Reimbursement		OIUX3_MARKETING_COST_REIMB	CURR	6
MKT_COST_REIMB09	Marketing Cost Reimbursement		OIUX3_MARKETING_COST_REIMB	CURR	6
MKT_COST_REIMB10	Marketing Cost Reimbursement		OIUX3_MARKETING_COST_REIMB	CURR	6
SV_TAX_AMT	Tax 2.0 - NM - Severance Tax Amount		OIUX8_NM_SEVERANCE_TAX_AMOUNT	CURR	6
CN_TAX_AMT	Tax 2.0 - NM - Conservation Tax Amount		OIUX8_NM_CONSERVATION_TAX_AMT	CURR	6
ES_TAX_AMT	Tax 2.0 - NM - Emergency School Tax Amount		OIUX8_NM_EMERGENCY_TAX_AMOUNT	CURR	6
AV_TAX_AMT	Tax 2.0 - NM - Ad Valorem Tax Amount		OIUX8_NM_AD_VALOREM_TAX_AMT	CURR	6
XX_TAX_AMT	Tax 2.0 - NM - XX Tax Amount		OIUX8_NM_XX_TAX_AMOUNT	CURR	6
TAX_REIMB	Tax Reimbursement		OIUX3_TAX_REIMBURSEMENT	CURR	6
BLPS_GROSS_VOL	Tax 2.0 - NM Before Lease Plant Split Gross Volume		OIUX8_NM_BLPS_GROSS_VOLUME	DEC	6
BLPS_GROSS_VAL	Tax 2.0 - NM Before Lease Plant Split Gross Value		OIUX8_NM_BLPS_GROSS_VALUE	CURR	6
RET_LSE_PC	Percent Returned to Lease		OIUCA_RET_LSE_PC	DEC	4
PLANT_PROC_ALLOW	Tax 2.0 - NM Plant Processing Allowance		OIUX8_NM_PLANT_PROC_ALLOWANCE	CURR	6
.INCLUDE	ROIUX8_NM_MASTER_NONKEY			ROIUX8_NM_MASTER_NONKEY	0
PUN	Tax 2.0 - NM - PUN		OIUX8_NM_PUN	NUMC	14
AFF_BY_AUDIT	Tax 2.0 - NM - Affected By Audit Flag (TC 55)		OIUX8_NM_AFFECTED_BY_AUDIT_FL	CHAR	2
.INCLUDE	NEW_PUN			ROIUX8_NM_NEW_PUN	0
PROP_ID	Tax 2.0 - New Mexico Property ID		OIUX8_NM_PROP_ID	CHAR	12
POOL_ID	Tax 2.0 - New Mexico Pool ID		OIUX8_NM_POOL_ID	CHAR	12
AGREEMENT_NO	Tax 2.0 - New Mexico Agreement Number		OIUX8_NM_AGRMNT_NUM	CHAR	22
MASTER_LEVEL	Texas Master Data Level		OIUX3_TX_MASTER_LEVEL	CHAR	2
OPER_PURCH_IND	Tax 2.0 - NM - Operator/Purchaser Indicator		OIUX8_OPERATOR_PURCHASER_IND	CHAR	2
SPEC_TAX_RATE_CD	Tax 2.0 - NM - Special Tax Rate Code		OIUX8_NM_SPECIAL_TAX_RATE_CODE	CHAR	6
NM_PRODUCT_CODE	Tax 2.0 - NM - Product Code		OIUX8_NM_PRODUCT_CODE	CHAR	4
AFFILIATION_CODE	Tax 2.0 - NM - Affilication Code		OIUX8_NM_AFFILIATION_CODE	CHAR	4
TRANSACTION_CODE	Tax 2.0 - NM - Transaction Code		OIUX8_NM_TRANSACTION_CODE	CHAR	4
OGRID	Tax 2.0 - New Mexico Oil & Gas Reporting ID		OIUX8_NM_OGR_OGT_ID	CHAR	22
DOC_NO	Val. document number		OIURV_DOCNR	CHAR	40	*
DOC_YEAR	Document year		OIU_DOC_YEAR	NUMC	8
INTERFACE_FL	Tax 2.0 - NM - Interface Flag		OIUX8_NM_INTERFACE_FL	CHAR	2
OPTION1				CHAR	2
OPTION2	PPN Flag			CHAR	2
OPTION3				CHAR	2
IN_KIND	Tax 2.0 - New Mexico Royalty-in-kind		OIUX8_NM_ROY_IN_KIND	CHAR	2
AUDIT_FL	Tax 2.0 - New Mexico Audit Flag		OIUX8_NM_AUDIT_FL	CHAR	2
.INCLUDE	OIU_CREATION			OIU_CREATION	0
OIU_CRUSER	Name of Person Responsible for Creating the Object		ERNAM	CHAR	24
OIU_TIMESTAMP	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)		TZNTSTMPS	DEC	8