SAP ABAP Table ROIUX5_MIG_OK_TAXHST_VER_ALV (Tax 2.0 - OK Migration Validation Report ALV Output Struct)

Hierarchy

☛ IS-OIL (Software Component) IS-OIL
   ⤷ IS-OIL-PRA-REP-TAX (Application Component) Tax Reporting
     ⤷ OIU_X5 (Package) Tax 2.0 - Oklahoma Tax

Basic Data

Table Category	INTTAB	Structure
Structure	ROIUX5_MIG_OK_TAXHST_VER_ALV	Table Relationship Diagram
Short Description	Tax 2.0 - OK Migration Validation Report ALV Output Struct

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	ERROR_NUMBER	☐	NUMC5	NUM5	NUMC	5	0	5 Character Numeric NUMC
2	NEW_OLD	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
3	.INCLUDE	☐				0	0	Tax 2.0 - Oklahoma Gross Prod Report Detail
4	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
5	.INCLUDE	☐				0	0	Tax 2.0 - Oklahoma Gross Prod Report Detail Key Fields
6	.INCLUDE	☐				0	0	Tax 2.0 - Oklahoma Gross Prod Report Summary Key Fields
7	RUN_ID	☐	OIUX3_RUN_ID	NUMC10	NUMC	10	0	Tax Reporting - Run ID
8	TAXPAYER_NUMBER	☐	OIUX5_OK_COMPANY_REPORTING_NO		NUMC	5	0	Tax 2.0 - Oklahoma Company Reporting Number
9	PRODUCTION_DATE	☐	OIUX5_OK_PRODUCTION_DATE		NUMC	4	0	Tax 2.0 - Oklahoma Production Date (YYMM)
10	OK_PRODUCT_CODE	☐	OIUX5_OK_PRODUCT_CODE	OIUX5_OK_PRODUCT_CODE	NUMC	1	0	Tax 2.0 - Oklahoma Product Code
11	COUNTY	☐	OIUX5_OK_COUNTY	OIU_SEC_GEO_LOC	CHAR	3	0	Tax 2.0 - Oklahoma County	*
12	PROD_PURC_IND	☐	OIUX3_PRODUCER_PURCHASER_IND	OIUX3_PRODUCER_PURCHASER_IND	CHAR	1	0	Tax Reporting - Producer/Purchaser Indicator
13	PUN	☐	OIUX5_OK_PRODUCTION_UNIT_NO		CHAR	11	0	Tax 2.0 - Oklahoma Production Unit Number
14	PROD_PURCH_NO	☐	OIUX5_OK_PROD_PURCH_NUMBER		NUMC	5	0	Tax 2.0 - Oklahoma Prod/Purch Number
15	GAS_CODE	☐	OIUX5_OK_GAS_CODE	OIUX5_OK_GAS_CODE	NUMC	1	0	Tax 2.0 - Oklahoma Gas Code
16	TIER_CATEGORY	☐	OIUX5_OK_TIER_CATEGORY	OIUX5_OK_TIER_CATEGORY	NUMC	1	0	Tax 2.0 - Oklahoma Tier Category
17	OIL_CLASS	☐	OIUX5_OK_OIL_CLASSIFICATION	OIUX5_OK_OIL_CLASSIFICATION	NUMC	1	0	Tax 2.0 - Oklahoma Oil Classification
18	NGPA_CD	☐	OIUX5_OK_NGPA_CD	OIUX5_OK_NGPA_CD	CHAR	3	0	Tax 2.0 OKGP - NGPA Code (Tax Incentive Rate Code)
19	REV_BOOK_ADJ_IND	☐	OIUX5_REV_BOOK_REVADJ_ADJ_IND	OIUX5_REV_BOOK_REVADJ_ADJ_IND	CHAR	1	0	Tax 2.0 - Reversal/Booking/Reversal Adjustment/Adjustment
20	.INCLUDE	☐				0	0	Tax 2.0 - Oklahoma Gross Prod Report Detail Non-Key Fields
21	GROSS_VOL	☐	OIUX3_GROSS_VOLUME	OIUX3_SIGNED_DEC_11_2	DEC	11	2	Gross Volume
22	GROSS_VAL	☐	OIUX3_GROSS_VALUE	OIUX3_SIGNED_CURR_11_2	CURR	11	2	Gross Value
23	BTU	☐	OIUX5_BTU	OIUH_DEC7_3	DEC	7	3	Tax 2.0 - BTU
24	GRAVITY	☐	OIUH_GRAVITY	OIUH_DEC3_1	DEC	3	1	Gravity
25	TAX_REIMB	☐	OIUX3_TAX_REIMBURSEMENT	OIUX3_SIGNED_CURR_11_2	CURR	11	2	Tax Reporting - Tax Reimbursement
26	EXEMPT_CODE_1	☐	OIUX5_OK_EXEMPT_CODE_1	OIUX5_OK_EXEMPT_CODE	NUMC	2	0	Tax 2.0 - Oklahoma Exempt Code 1
27	EXE_DEC_EQUIV_1	☐	OIUX5_OK_EXEMPT_DEC_EQUIV_1		DEC	9	8	Tax 2.0 - Oklahaoma Exempt Decimal Equivalent 1
28	EXE_ENTTYPE1_VOL	☐	OIUX5_EXEMPT_ENTITY_TYPE_1_VOL	OIUX3_SIGNED_DEC_11_2	DEC	11	2	Tax 2.0 - Exempt Entity Type 1 Volume
29	EXE_ENTTYPE1_VAL	☐	OIUX5_EXEMPT_ENTITY_TYPE_1_VAL	OIUX3_SIGNED_CURR_11_2	CURR	11	2	Tax 2.0 - Exempt Entity Type 1 Value
30	EXEMPT_CODE_2	☐	OIUX5_OK_EXEMPT_CODE_2	OIUX5_OK_EXEMPT_CODE	NUMC	2	0	Tax 2.0 - Oklahoma Exempt Code 2
31	EXE_DEC_EQUIV_2	☐	OIUX5_OK_EXEMPT_DEC_EQUIV_2		DEC	9	8	Tax 2.0 - Oklahaoma Exempt Decimal Equivalent 2
32	EXE_ENTTYPE2_VOL	☐	OIUX5_EXEMPT_ENTITY_TYPE_2_VOL	OIUX3_SIGNED_DEC_11_2	DEC	11	2	Tax 2.0 - Exempt Entity Type 2 Volume
33	EXE_ENTTYPE2_VAL	☐	OIUX5_EXEMPT_ENTITY_TYPE_2_VAL	OIUX3_SIGNED_CURR_11_2	CURR	11	2	Tax 2.0 - Exempt Entity Type 2 Value
34	EXEMPT_CODE_3	☐	OIUX5_OK_EXEMPT_CODE_3	OIUX5_OK_EXEMPT_CODE	NUMC	2	0	Tax 2.0 - Oklahoma Exempt Code 3
35	EXE_DEC_EQUIV_3	☐	OIUX5_OK_EXEMPT_DEC_EQUIV_3		DEC	9	8	Tax 2.0 - Oklahaoma Exempt Decimal Equivalent 3
36	EXE_ENTTYPE3_VOL	☐	OIUX5_EXEMPT_ENTITY_TYPE_3_VOL	OIUX3_SIGNED_DEC_11_2	DEC	11	2	Tax 2.0 - Exempt Entity Type 3 Volume
37	EXE_ENTTYPE3_VAL	☐	OIUX5_EXEMPT_ENTITY_TYPE_3_VAL	OIUX3_SIGNED_CURR_11_2	CURR	11	2	Tax 2.0 - Exempt Entity Type 3 Value
38	EXEMPT_CODE_4	☐	OIUX5_OK_EXEMPT_CODE_4	OIUX5_OK_EXEMPT_CODE	NUMC	2	0	Tax 2.0 - Oklahoma Exempt Code 4
39	EXE_DEC_EQUIV_4	☐	OIUX5_OK_EXEMPT_DEC_EQUIV_4		DEC	9	8	Tax 2.0 - Oklahaoma Exempt Decimal Equivalent 4
40	EXE_ENTTYPE4_VOL	☐	OIUX5_EXEMPT_ENTITY_TYPE_4_VOL	OIUX3_SIGNED_DEC_11_2	DEC	11	2	Tax 2.0 - Exempt Entity Type 4 Volume
41	EXE_ENTTYPE4_VAL	☐	OIUX5_EXEMPT_ENTITY_TYPE_4_VAL	OIUX3_SIGNED_CURR_11_2	CURR	11	2	Tax 2.0 - Exempt Entity Type 4 Value
42	EXEMPT_CODE_5	☐	OIUX5_OK_EXEMPT_CODE_5	OIUX5_OK_EXEMPT_CODE	NUMC	2	0	Tax 2.0 - Oklahoma Exempt Code 5
43	EXE_DEC_EQUIV_5	☐	OIUX5_OK_EXEMPT_DEC_EQUIV_5		DEC	9	8	Tax 2.0 - Oklahaoma Exempt Decimal Equivalent 5
44	EXE_ENTTYPE5_VOL	☐	OIUX5_EXEMPT_ENTITY_TYPE_5_VOL	OIUX3_SIGNED_DEC_11_2	DEC	11	2	Tax 2.0 - Exempt Entity Type 5 Volume
45	EXE_ENTTYPE5_VAL	☐	OIUX5_EXEMPT_ENTITY_TYPE_5_VAL	OIUX3_SIGNED_CURR_11_2	CURR	11	2	Tax 2.0 - Exempt Entity Type 5 Value
46	EXEMPT_09_VAL	☐	OIUX5_EXEMPT_TYPE_09_VAL	OIUX3_SIGNED_DEC_11_2	DEC	11	2	Tax 2.0 - Exempt Entity Type 09 Value
47	TAX_VOL	☐	OIUX3_TAXABLE_VOLUME	OIUX3_SIGNED_DEC_11_2	DEC	11	2	Taxable Volume
48	TAX_VAL	☐	OIUX3_TAXABLE_VALUE	OIUX3_SIGNED_CURR_11_2	CURR	11	2	Taxable Value
49	GP_TAX_AMT	☐	OIUX5_GROSS_PROD_TAX_AMOUNT	OIUX3_SIGNED_CURR_11_2	CURR	11	2	Tax 2.0 - Gross Production Tax Amount
50	PE_TAX_AMT	☐	OIUX5_PETRO_EXCISE_TAX_AMOUNT	OIUX3_SIGNED_CURR_11_2	CURR	11	2	Tax 2.0 - Petroleum Excise Tax Amount
51	SEC_GEO_DESC	☐	OIUX5_OK_COUNTY_NAME	CHAR30	CHAR	30	0	Tax 2.0 - Oklahoma County Name
52	TAXPAYER_NAME	☐	OIUX5_OKLAHOMA_COMPANY_NAME	TEXT30	CHAR	30	0	Tax 2.0 - Oklahoma Company Name
53	FEIN_SSN	☐	OIUX3_FEIN_SSN		NUMC	9	0	Tax 2.0 - FEIN/SSN
54	MULTI_COUNTIES	☐	OIUX5_MULTIPLE_COUNTIES	YESNO	CHAR	1	0	Tax 2.0 - Multiple Counties?
55	.INCLUDE	☐				0	0	Creator and date/time created
56	OIU_CRUSER	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
57	OIU_TIMESTAMP	☐	TZNTSTMPS	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ROIUX5_MIG_OK_TAXHST_VER_ALV	MANDT	T000	MANDT	KEY

History

Last changed by/on	SAP	20130529
SAP Release Created in	100