OIUT5_PRDT - Tax 2.0 OK - PRA Detail Transaction

Tax 2.0 OK - PRA Detail Transaction information is stored in SAP table OIUT5_PRDT.
It is part of development package OIU_T5 in software component IS-OIL-PRA-REP-TAX. This development package consists of objects that can be grouped under "Oklahoma Tax Reporting SLA".

Fields for table OIUT5_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	ROIUX5_OK_TAXTXN_KEY	X		ROIUX5_OK_TAXTXN_KEY	0
.INCLUDE	ROIUX5_OK_REVTXN_KEY	X		ROIUX5_OK_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
REV_BOOK_ADJ_IND	Tax 2.0 - Reversal/Booking/Reversal Adjustment/Adjustment	X	OIUX5_REV_BOOK_REVADJ_ADJ_IND	CHAR	2
.INCLUDE	ROIUT5_TAXTXN_NONKEY			ROIUT5_TAXTXN_NONKEY	0
PROD_PURC_IND	Producer or Purchaser		OIUX3_PRODUCER_PURCHASER_IND	CHAR	2
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
VAL_TAX_RAT	Value tax rate		OIUVL_VAL_TAX_RAT	DEC	4
OTHER_PARTY	Master Record		OIUCM_MASTER	CHAR	20
DOC_NO	Val. document number		OIURV_DOCNR	CHAR	40	*
DOC_YEAR	Document year		OIU_DOC_YEAR	NUMC	8
OPTION1	Single-Character Flag		CHAR1	CHAR	2
OPTION2	Single-Character Flag		CHAR1	CHAR	2
OPTION3	Single-Character Flag		CHAR1	CHAR	2
INTERFACE_FL	Single-Character Flag		CHAR1	CHAR	2
OOS_FL	Out of Statute		OIUX3_OUT_OF_STATUTE	CHAR	2
.INCLUDE	ROIUT5_TAXTXN_NONKEY_NUMERIC			ROIUT5_TAXTXN_NONKEY_NUMERIC	0
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
EXE_ENTTYPE1_VOL	Tax 2.0 - Exempt Entity Type 1 Volume		OIUX5_EXEMPT_ENTITY_TYPE_1_VOL	DEC	6
EXE_ENTTYPE1_VAL	Tax 2.0 - Exempt Entity Type 1 Value		OIUX5_EXEMPT_ENTITY_TYPE_1_VAL	CURR	6
EXE_ENTTYPE2_VOL	Tax 2.0 - Exempt Entity Type 2 Volume		OIUX5_EXEMPT_ENTITY_TYPE_2_VOL	DEC	6
EXE_ENTTYPE2_VAL	Tax 2.0 - Exempt Entity Type 2 Value		OIUX5_EXEMPT_ENTITY_TYPE_2_VAL	CURR	6
EXE_ENTTYPE3_VOL	Tax 2.0 - Exempt Entity Type 3 Volume		OIUX5_EXEMPT_ENTITY_TYPE_3_VOL	DEC	6
EXE_ENTTYPE3_VAL	Tax 2.0 - Exempt Entity Type 3 Value		OIUX5_EXEMPT_ENTITY_TYPE_3_VAL	CURR	6
EXE_ENTTYPE4_VOL	Tax 2.0 - Exempt Entity Type 4 Volume		OIUX5_EXEMPT_ENTITY_TYPE_4_VOL	DEC	6
EXE_ENTTYPE4_VAL	Tax 2.0 - Exempt Entity Type 4 Value		OIUX5_EXEMPT_ENTITY_TYPE_4_VAL	CURR	6
EXE_ENTTYPE5_VOL	Tax 2.0 - Exempt Entity Type 5 Volume		OIUX5_EXEMPT_ENTITY_TYPE_5_VOL	DEC	6
EXE_ENTTYPE5_VAL	Tax 2.0 - Exempt Entity Type 5 Value		OIUX5_EXEMPT_ENTITY_TYPE_5_VAL	CURR	6
EOR_VOL	EOR Volume		OIU_EOR_VL	QUAN	7
EOR_VAL	EOR Value		OIU_EOR_VAL	CURR	8
MKT_COST	Marketing Cost		OIUX3_MARKETING_COST	CURR	6
MKT_COST_REIMB	Marketing Cost Reimbursement		OIUX3_MARKETING_COST_REIMB	CURR	6
GP_TAX_AMT	Tax 2.0 - Gross Production Tax Amount		OIUX5_GROSS_PROD_TAX_AMOUNT	CURR	6
PE_TAX_AMT	Tax 2.0 - Petroleum Excise Tax Amount		OIUX5_PETRO_EXCISE_TAX_AMOUNT	CURR	6
RF_TAX_AMT	Tax 2.0 - Revolving Fund Tax Amount		OIUX5_REVOLVE_FUND_TAX_AMOUNT	CURR	6
MP_TAX_AMT	Tax 2.0 - Marginally Producing Tax Amount		OIUX5_MARGINAL_PROD_TAX_AMOUNT	CURR	6
KW_TAX_AMT	Tax 2.0 - Kiowa Tax Amount		OIUX5_KIOWA_TAX_AMOUNT	CURR	6
CA_TAX_AMT	Tax 2.0 - Cheyenne/Arapaho Tax Amount		OIUX5_CHEYENNE_ARAPAHO_TAX_AMT	CURR	6
XX_TAX_AMT	Tax 2.0 - XX Tax Amount		OIUX5_XX_TAX_AMT	CURR	6
.INCLUDE	ROIUT5_TAXTXN_NONKEY_DERIVED			ROIUT5_TAXTXN_NONKEY_DERIVED	0
EXEMPT_CODE_1	Tax 2.0 OKGP - Entity Type 01 Exempt Code		OIUT5_EXEMPT_CODE_1	NUMC	4	OIUT5_EXCD
EXEMPT_CODE_2	Tax 2.0 OKGP - Entity Type 02 Exempt Code		OIUT5_EXEMPT_CODE_2	NUMC	4	OIUT5_EXCD
EXEMPT_CODE_3	Tax 2.0 OKGP - Entity Type 03 Exempt Code		OIUT5_EXEMPT_CODE_3	NUMC	4	OIUT5_EXCD
EXEMPT_CODE_4	Tax 2.0 OKGP - Entity Type 04 Exempt Code		OIUT5_EXEMPT_CODE_4	NUMC	4	OIUT5_EXCD
EXEMPT_CODE_5	Tax 2.0 OKGP - Entity Type 05 Exempt Code		OIUT5_EXEMPT_CODE_5	NUMC	4	OIUT5_EXCD
MASTER_LEVEL	Tax 2.0 - Master Level		OIUX5_MASTER_LEVEL	CHAR	2
PROD_PURCH_NO	Tax 2.0 - Oklahoma Producer/Purchaser Number		OIUX5_OK_PROD_PURCH_NUMBER	NUMC	10
OK_PRODUCT_CODE	Tax 2.0 - Oklahoma Product Code		OIUX5_OK_PRODUCT_CODE	NUMC	2
TAXPAYER_NUMBER	Tax 2.0 - Oklahoma Taxpayer Number		OIUX5_OK_TAXPAYER_NUMBER	NUMC	10
FEIN_SSN	Tax 2.0 - FEIN/SSN		OIUX3_FEIN_SSN	NUMC	18
REFERENCE_RUN_ID	Run ID of Tax Report		OIUX3_RUN_ID	NUMC	20
PRODUCTION_DATE	Tax 2.0 OK - Production Date (YYYYMM)		OIUT5_PRODUCTION_DATE	ACCP	12
.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