	Table	Prefix	Description
1	F4211	SD	Sales Order Detail File
2	F0101	AB	Address Book Master
3	F4101	IM	Item Master
4	F0911	GL	Account Ledger
5	F4311	PD	Purchase Order Detail File
6	F4102	IB	Item Branch File
7	F9671	SD	Software Update Detail Table
8	F0411	RP	Accounts Payable Ledger
9	F0006	MC	Business Unit Master
10	F41021	LI	Item Location File

	Table	Prefix	Description
1	F0011W	IC	F0011W - WF - Batch To Detail
2	F76AUI46	WF	CERG A/R -Work File - ARG - 03B - 76A
3	F4211	SD	Sales Order Detail File
4	F4101	IM	Item Master
5	F0101	AB	Address Book Master
6	F0911	GL	Account Ledger
7	F4102	IB	Item Branch File
8	F03B11	RP	Customer Ledger
9	F4311	PD	Purchase Order Detail File
10	F4111	IL	Item Ledger File

	Table	Prefix	Description
1	F0911	GL	Account Ledger
2	F4311	PD	Purchase Order Detail File
3	F0101	AB	Address Book Master
4	F0411	RP	Accounts Payable Ledger
5	F0006	MC	Business Unit Master
6	F4211	SD	Sales Order Detail File
7	F42119	SD	Sales Order History File
8	F03012	AI	Customer Master by Line of Business
9	F0902	GB	Account Balances
10	F4801	WA	Work Order Master File

185 COLUMNS | 1 INDEXES | 812 | 41 | F4115 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
41: Inventory Management
1	812	F4115	IH	185	1	Item History	History Files	41: Inventory Management	AS400 Coexistence Tables

SQL: selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns. For Create statements, use Allow Null checkboxes and default values inputs to tailor query as required.

SELECT IHITM, IHMCU, IHCTRY, IHFY, IHFQ, IHLT, IHCMS, IHCMC, IHCYS, IHCYC, IHPYES, IHPYEC, IHSQ01, IHSQ02, IHSQ03, IHSQ04, IHSQ05, IHSQ06, IHSQ07, IHSQ08, IHSQ09, IHSQ10, IHSQ11, IHSQ12, IHSQ13, IHSQ14, IHDLIJ, IHLRCJ, IHLDAY, IHAS01, IHAS02, IHAS03, IHAS04, IHAS05, IHAS06, IHAS07, IHAS08, IHAS09, IHAS10, IHAS11, IHAS12, IHAS13, IHAS14, IHCI01, IHCI02, IHCI03, IHCI04, IHCI05, IHCI06, IHCI07, IHCI08, IHCI09, IHCI10, IHCI11, IHCI12, IHCI13, IHCI14, IHMA01, IHMA02, IHMA03, IHMA04, IHMA05, IHMA06, IHMA07, IHMA08, IHMA09, IHMA10, IHMA11, IHMA12, IHMA13, IHMA14, IHAV01, IHAV02, IHAV03, IHAV04, IHAV05, IHAV06, IHAV07, IHAV08, IHAV09, IHAV10, IHAV11, IHAV12, IHAV13, IHAV14, IHPQ01, IHPQ02, IHPQ03, IHPQ04, IHPQ05, IHPQ06, IHPQ07, IHPQ08, IHPQ09, IHPQ10, IHPQ11, IHPQ12, IHPQ13, IHPQ14, IHAE01, IHAE02, IHAE03, IHAE04, IHAE05, IHAE06, IHAE07, IHAE08, IHAE09, IHAE10, IHAE11, IHAE12, IHAE13, IHAE14, IHCW01, IHCW02, IHCW03, IHCW04, IHCW05, IHCW06, IHCW07, IHCW08, IHCW09, IHCW10, IHCW11, IHCW12, IHCW13, IHCW14, IHSM01, IHSM02, IHSM03, IHSM04, IHSM05, IHSM06, IHSM07, IHSM08, IHSM09, IHSM10, IHSM11, IHSM12, IHSM13, IHSM14, IHC101, IHC102, IHC103, IHC104, IHC105, IHC106, IHC107, IHC108, IHC109, IHC110, IHC111, IHC112, IHC113, IHC114, IHC201, IHC202, IHC203, IHC204, IHC205, IHC206, IHC207, IHC208, IHC209, IHC210, IHC211, IHC212, IHC213, IHC214, IHC301, IHC302, IHC303, IHC304, IHC305, IHC306, IHC307, IHC308, IHC309, IHC310, IHC311, IHC312, IHC313, IHC314, IHGMTD, IHINVV FROM F4115

TOP 812 | 41 | F4115 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	IHITM	Item Number - Short	Numeric	Generic Edit	8	0	Allow NULL?
2	IHMCU	Business Unit	String	Generic Edit	12	0	Allow NULL?
3	IHCTRY	Century	Numeric	Generic Edit	2	0	Allow NULL?
4	IHFY	Fiscal Year	Numeric	Generic Edit	2	0	Allow NULL?
5	IHFQ	Fiscal Quarter (Obsolete)	String	UDC (H09 FQ)	4	0	Allow NULL?
6	IHLT	Ledger Types	String	UDC (09 LT)	2	0	Allow NULL?
7	IHCMS	Amount - Sales Dollars YTD	Numeric	Generic Edit	15	2	Allow NULL?
8	IHCMC	Amount - Cost of Goods Sold YTD	Numeric	Generic Edit	15	2	Allow NULL?
9	IHCYS	Amount - Sales YTD	Numeric	Generic Edit	15	2	Allow NULL?
10	IHCYC	Amount - Cost of Sales - Year to Date	Numeric	Generic Edit	15	2	Allow NULL?
11	IHPYES	Amount - Invoiced Prior Year	Numeric	Generic Edit	15	2	Allow NULL?
12	IHPYEC	Amount - Cost of Goods Sold PYE	Numeric	Generic Edit	15	2	Allow NULL?
13	IHSQ01	Amount - Sales Quantity Prior Month 01	Numeric	Generic Edit	15	2	Allow NULL?
14	IHSQ02	Amount - Sales Quantity Prior Month 02	Numeric	Generic Edit	15	2	Allow NULL?
15	IHSQ03	Amount - Sales Quantity Prior Month 03	Numeric	Generic Edit	15	2	Allow NULL?
16	IHSQ04	Amount - Sales Quantity Prior Month 04	Numeric	Generic Edit	15	2	Allow NULL?
17	IHSQ05	Amount - Sales Quantity Prior Month 05	Numeric	Generic Edit	15	2	Allow NULL?
18	IHSQ06	Amount - Sales Quantity Prior Month 06	Numeric	Generic Edit	15	2	Allow NULL?
19	IHSQ07	Amount - Sales Quantity Prior Month 07	Numeric	Generic Edit	15	2	Allow NULL?
20	IHSQ08	Amount - Sales Quantity Prior Month 08	Numeric	Generic Edit	15	2	Allow NULL?
21	IHSQ09	Amount - Sales Quantity Prior Month 09	Numeric	Generic Edit	15	2	Allow NULL?
22	IHSQ10	Amount - Sales Quantity Prior Month 10	Numeric	Generic Edit	15	2	Allow NULL?
23	IHSQ11	Amount - Sales Quantity Prior Month 11	Numeric	Generic Edit	15	2	Allow NULL?
24	IHSQ12	Amount - Sales Quantity Prior Month 12	Numeric	Generic Edit	15	2	Allow NULL?
25	IHSQ13	Amount - Sales Quantity Prior Month 13	Numeric	Generic Edit	15	2	Allow NULL?
26	IHSQ14	Amount - Sales Quantity Prior Month 14	Numeric	Generic Edit	15	2	Allow NULL?
27	IHDLIJ	Date - Last Invoice (Julian)	Date	Generic Edit	6	0
28	IHLRCJ	Date - Last Receipt (Julian)	Date	Generic Edit	6	0
29	IHLDAY	Leadtime (Days)	Numeric	Generic Edit	3	0	Allow NULL?
30	IHAS01	Amount - Sales Amount Prior Month 01	Numeric	Generic Edit	15	2	Allow NULL?
31	IHAS02	Amount - Sales Amount Prior Month 02	Numeric	Generic Edit	15	2	Allow NULL?
32	IHAS03	Amount - Sales Amount Prior Month 03	Numeric	Generic Edit	15	2	Allow NULL?
33	IHAS04	Amount - Sales Amount Prior Month 04	Numeric	Generic Edit	15	2	Allow NULL?
34	IHAS05	Amount - Sales Amount Prior Month 05	Numeric	Generic Edit	15	2	Allow NULL?
35	IHAS06	Amount - Sales Amount Prior Month 06	Numeric	Generic Edit	15	2	Allow NULL?
36	IHAS07	Amount - Sales Amount Prior Month 07	Numeric	Generic Edit	15	2	Allow NULL?
37	IHAS08	Amount - Sales Amount Prior Month 08	Numeric	Generic Edit	15	2	Allow NULL?
38	IHAS09	Amount - Sales Amount Prior Month 09	Numeric	Generic Edit	15	2	Allow NULL?
39	IHAS10	Amount - Sales Amount Prior Month 10	Numeric	Generic Edit	15	2	Allow NULL?
40	IHAS11	Amount - Sales Amount Prior Month 11	Numeric	Generic Edit	15	2	Allow NULL?
41	IHAS12	Amount - Sales Amount Prior Month 12	Numeric	Generic Edit	15	2	Allow NULL?
42	IHAS13	Amount - Sales Amount Prior Month 13	Numeric	Generic Edit	15	2	Allow NULL?
43	IHAS14	Amount - Sales Amount Prior Month 14	Numeric	Generic Edit	15	2	Allow NULL?
44	IHCI01	Amount - Cost Amount Prior Month 01	Numeric	Generic Edit	15	2	Allow NULL?
45	IHCI02	Amount - Cost Amount Prior Month 02	Numeric	Generic Edit	15	2	Allow NULL?
46	IHCI03	Amount - Cost Amount Prior Month 03	Numeric	Generic Edit	15	2	Allow NULL?
47	IHCI04	Amount - Cost Amount Prior Month 04	Numeric	Generic Edit	15	2	Allow NULL?
48	IHCI05	Amount - Cost Amount Prior Month 05	Numeric	Generic Edit	15	2	Allow NULL?
49	IHCI06	Amount - Cost Amount Prior Month 06	Numeric	Generic Edit	15	2	Allow NULL?
50	IHCI07	Amount - Cost Amount Prior Month 07	Numeric	Generic Edit	15	2	Allow NULL?
51	IHCI08	Amount - Cost Amount Prior Month 08	Numeric	Generic Edit	15	2	Allow NULL?
52	IHCI09	Amount - Cost Amount Prior Month 09	Numeric	Generic Edit	15	2	Allow NULL?
53	IHCI10	Amount - Cost Amount Prior Month 10	Numeric	Generic Edit	15	2	Allow NULL?
54	IHCI11	Amount - Cost Amount Prior Month 11	Numeric	Generic Edit	15	2	Allow NULL?
55	IHCI12	Amount - Cost Amount Prior Month 12	Numeric	Generic Edit	15	2	Allow NULL?
56	IHCI13	Amount - Cost Amount Prior Month 13	Numeric	Generic Edit	15	2	Allow NULL?
57	IHCI14	Amount - Cost Amount Prior Month 14	Numeric	Generic Edit	15	2	Allow NULL?
58	IHMA01	Amount - Margin Amount Prior Month 01	Numeric	Generic Edit	15	2	Allow NULL?
59	IHMA02	Amount - Margin Amount Prior Month 02	Numeric	Generic Edit	15	2	Allow NULL?
60	IHMA03	Amount - Margin Amount Prior Month 03	Numeric	Generic Edit	15	2	Allow NULL?
61	IHMA04	Amount - Margin Amount Prior Month 04	Numeric	Generic Edit	15	2	Allow NULL?
62	IHMA05	Amount - Margin Amount Prior Month 05	Numeric	Generic Edit	15	2	Allow NULL?
63	IHMA06	Amount - Margin Amount Prior Month 06	Numeric	Generic Edit	15	2	Allow NULL?
64	IHMA07	Amount - Margin Amount Prior Month 07	Numeric	Generic Edit	15	2	Allow NULL?
65	IHMA08	Amount - Margin Amount Prior Month 08	Numeric	Generic Edit	15	2	Allow NULL?
66	IHMA09	Amount - Margin Amount Prior Month 09	Numeric	Generic Edit	15	2	Allow NULL?
67	IHMA10	Amount - Margin Amount Prior Month 10	Numeric	Generic Edit	15	2	Allow NULL?
68	IHMA11	Amount - Margin Amount Prior Month 11	Numeric	Generic Edit	15	2	Allow NULL?
69	IHMA12	Amount - Margin Amount Prior Month 12	Numeric	Generic Edit	15	2	Allow NULL?
70	IHMA13	Amount - Margin Amount Prior Month 13	Numeric	Generic Edit	15	2	Allow NULL?
71	IHMA14	Amount - Margin Amount Prior Month 14	Numeric	Generic Edit	15	2	Allow NULL?
72	IHAV01	Amount - Avg Inventory Value Prior Mo 01	Numeric	Generic Edit	15	2	Allow NULL?
73	IHAV02	Amount - Avg Inventory Value Prior Mo 02	Numeric	Generic Edit	15	2	Allow NULL?
74	IHAV03	Amount - Avg Inventory Value Prior Mo 03	Numeric	Generic Edit	15	2	Allow NULL?
75	IHAV04	Amount - Avg Inventory Value Prior Mo 04	Numeric	Generic Edit	15	2	Allow NULL?
76	IHAV05	Amount - Avg Inventory Value Prior Mo 05	Numeric	Generic Edit	15	2	Allow NULL?
77	IHAV06	Amount - Avg Inventory Value Prior Mo 06	Numeric	Generic Edit	15	2	Allow NULL?
78	IHAV07	Amount - Avg Inventory Value Prior Mo 07	Numeric	Generic Edit	15	2	Allow NULL?
79	IHAV08	Amount - Avg Inventory Value Prior Mo 08	Numeric	Generic Edit	15	2	Allow NULL?
80	IHAV09	Amount - Avg Inventory Value Prior Mo 09	Numeric	Generic Edit	15	2	Allow NULL?
81	IHAV10	Amount - Avg Inventory Value Prior Mo 10	Numeric	Generic Edit	15	2	Allow NULL?
82	IHAV11	Amount - Avg Inventory Value Prior Mo 11	Numeric	Generic Edit	15	2	Allow NULL?
83	IHAV12	Amount - Avg Inventory Value Prior Mo 12	Numeric	Generic Edit	15	2	Allow NULL?
84	IHAV13	Amount - Avg Inventory Value Prior Mo 13	Numeric	Generic Edit	15	2	Allow NULL?
85	IHAV14	Amount - Avg Inventory Value Prior Mo 14	Numeric	Generic Edit	15	2	Allow NULL?
86	IHPQ01	Qty on Hand-Primary units Prior Month 01	Numeric	Generic Edit	15	2	Allow NULL?
87	IHPQ02	Qty on Hand-Primary units Prior Month 02	Numeric	Generic Edit	15	2	Allow NULL?
88	IHPQ03	Qty on Hand-Primary units Prior Month 03	Numeric	Generic Edit	15	2	Allow NULL?
89	IHPQ04	Qty on Hand-Primary units Prior Month 04	Numeric	Generic Edit	15	2	Allow NULL?
90	IHPQ05	Qty on Hand-Primary units Prior Month 05	Numeric	Generic Edit	15	2	Allow NULL?
91	IHPQ06	Qty on Hand-Primary units Prior Month 06	Numeric	Generic Edit	15	2	Allow NULL?
92	IHPQ07	Qty on Hand-Primary units Prior Month 07	Numeric	Generic Edit	15	2	Allow NULL?
93	IHPQ08	Qty on Hand-Primary units Prior Month 08	Numeric	Generic Edit	15	2	Allow NULL?
94	IHPQ09	Qty on Hand-Primary units Prior Month 09	Numeric	Generic Edit	15	2	Allow NULL?
95	IHPQ10	Qty on Hand-Primary units Prior Month 10	Numeric	Generic Edit	15	2	Allow NULL?
96	IHPQ11	Qty on Hand-Primary units Prior Month 11	Numeric	Generic Edit	15	2	Allow NULL?
97	IHPQ12	Qty on Hand-Primary units Prior Month 12	Numeric	Generic Edit	15	2	Allow NULL?
98	IHPQ13	Qty on Hand-Primary units Prior Month 13	Numeric	Generic Edit	15	2	Allow NULL?
99	IHPQ14	Qty on Hand-Primary units Prior Month 14	Numeric	Generic Edit	15	2	Allow NULL?
100	IHAE01	Amount - Extended Price Prior Month 01	Numeric	Generic Edit	15	2	Allow NULL?
101	IHAE02	Amount - Extended Price Prior Month 02	Numeric	Generic Edit	15	2	Allow NULL?
102	IHAE03	Amount - Extended Price Prior Month 03	Numeric	Generic Edit	15	2	Allow NULL?
103	IHAE04	Amount - Extended Price Prior Month 04	Numeric	Generic Edit	15	2	Allow NULL?
104	IHAE05	Amount - Extended Price Prior Month 05	Numeric	Generic Edit	15	2	Allow NULL?
105	IHAE06	Amount - Extended Price Prior Month 06	Numeric	Generic Edit	15	2	Allow NULL?
106	IHAE07	Amount - Extended Price Prior Month 07	Numeric	Generic Edit	15	2	Allow NULL?
107	IHAE08	Amount - Extended Price Prior Month 08	Numeric	Generic Edit	15	2	Allow NULL?
108	IHAE09	Amount - Extended Price Prior Month 09	Numeric	Generic Edit	15	2	Allow NULL?
109	IHAE10	Amount - Extended Price Prior Month 10	Numeric	Generic Edit	15	2	Allow NULL?
110	IHAE11	Amount - Extended Price Prior Month 11	Numeric	Generic Edit	15	2	Allow NULL?
111	IHAE12	Amount - Extended Price Prior Month 12	Numeric	Generic Edit	15	2	Allow NULL?
112	IHAE13	Amount - Extended Price Prior Month 13	Numeric	Generic Edit	15	2	Allow NULL?
113	IHAE14	Amount - Extended Price Prior Month 14	Numeric	Generic Edit	15	2	Allow NULL?
114	IHCW01	Amount - Unit Cost - Wtd Avg Prior 01	Numeric	Generic Edit	15	4	Allow NULL?
115	IHCW02	Amount - Unit Cost - Wtd Avg Prior 02	Numeric	Generic Edit	15	4	Allow NULL?
116	IHCW03	Amount - Unit Cost - Wtd Avg Prior 03	Numeric	Generic Edit	15	4	Allow NULL?
117	IHCW04	Amount - Unit Cost - Wtd Avg Prior 04	Numeric	Generic Edit	15	4	Allow NULL?
118	IHCW05	Amount - Unit Cost - Wtd Avg Prior 05	Numeric	Generic Edit	15	4	Allow NULL?
119	IHCW06	Amount - Unit Cost - Wtd Avg Prior 06	Numeric	Generic Edit	15	4	Allow NULL?
120	IHCW07	Amount - Unit Cost - Wtd Avg Prior 07	Numeric	Generic Edit	15	4	Allow NULL?
121	IHCW08	Amount - Unit Cost - Wtd Avg Prior 08	Numeric	Generic Edit	15	4	Allow NULL?
122	IHCW09	Amount - Unit Cost - Wtd Avg Prior 09	Numeric	Generic Edit	15	4	Allow NULL?
123	IHCW10	Amount - Unit Cost - Wtd Avg Prior 10	Numeric	Generic Edit	15	4	Allow NULL?
124	IHCW11	Amount - Unit Cost - Wtd Avg Prior 11	Numeric	Generic Edit	15	4	Allow NULL?
125	IHCW12	Amount - Unit Cost - Wtd Avg Prior 12	Numeric	Generic Edit	15	4	Allow NULL?
126	IHCW13	Amount - Unit Cost - Wtd Avg Prior 13	Numeric	Generic Edit	15	4	Allow NULL?
127	IHCW14	Amount - Unit Cost - Wtd Avg Prior 14	Numeric	Generic Edit	15	4	Allow NULL?
128	IHSM01	Costing Method - Sales Prior Month 01	Character	Generic Edit	1	0	Allow NULL?
129	IHSM02	Costing Method - Sales Prior Month 02	Character	Generic Edit	1	0	Allow NULL?
130	IHSM03	Costing Method - Sales Prior Month 03	Character	Generic Edit	1	0	Allow NULL?
131	IHSM04	Costing Method - Sales Prior Month 04	Character	Generic Edit	1	0	Allow NULL?
132	IHSM05	Costing Method - Sales Prior Month 05	Character	Generic Edit	1	0	Allow NULL?
133	IHSM06	Costing Method - Sales Prior Month 06	Character	Generic Edit	1	0	Allow NULL?
134	IHSM07	Costing Method - Sales Prior Month 07	Character	Generic Edit	1	0	Allow NULL?
135	IHSM08	Costing Method - Sales Prior Month 08	Character	Generic Edit	1	0	Allow NULL?
136	IHSM09	Costing Method - Sales Prior Month 09	Character	Generic Edit	1	0	Allow NULL?
137	IHSM10	Costing Method - Sales Prior Month 10	Character	Generic Edit	1	0	Allow NULL?
138	IHSM11	Costing Method - Sales Prior Month 11	Character	Generic Edit	1	0	Allow NULL?
139	IHSM12	Costing Method - Sales Prior Month 12	Character	Generic Edit	1	0	Allow NULL?
140	IHSM13	Costing Method - Sales Prior Month 13	Character	Generic Edit	1	0	Allow NULL?
141	IHSM14	Costing Method - Sales Prior Month 14	Character	Generic Edit	1	0	Allow NULL?
142	IHC101	ABC Code 1 - Sales - Inventory Prior 01	Character	Generic Edit	1	0	Allow NULL?
143	IHC102	ABC Code 1 - Sales - Inventory Prior 02	Character	Generic Edit	1	0	Allow NULL?
144	IHC103	ABC Code 1 - Sales - Inventory Prior 03	Character	Generic Edit	1	0	Allow NULL?
145	IHC104	ABC Code 1 - Sales - Inventory Prior 04	Character	Generic Edit	1	0	Allow NULL?
146	IHC105	ABC Code 1 - Sales - Inventory Prior 05	Character	Generic Edit	1	0	Allow NULL?
147	IHC106	ABC Code 1 - Sales - Inventory Prior 06	Character	Generic Edit	1	0	Allow NULL?
148	IHC107	ABC Code 1 - Sales - Inventory Prior 07	Character	Generic Edit	1	0	Allow NULL?
149	IHC108	ABC Code 1 - Sales - Inventory Prior 08	Character	Generic Edit	1	0	Allow NULL?
150	IHC109	ABC Code 1 - Sales - Inventory Prior 09	Character	Generic Edit	1	0	Allow NULL?
151	IHC110	ABC Code 1 - Sales - Inventory Prior 10	Character	Generic Edit	1	0	Allow NULL?
152	IHC111	ABC Code 1 - Sales - Inventory Prior 11	Character	Generic Edit	1	0	Allow NULL?
153	IHC112	ABC Code 1 - Sales - Inventory Prior 12	Character	Generic Edit	1	0	Allow NULL?
154	IHC113	ABC Code 1 - Sales - Inventory Prior 13	Character	Generic Edit	1	0	Allow NULL?
155	IHC114	ABC Code 1 - Sales - Inventory Prior 14	Character	Generic Edit	1	0	Allow NULL?
156	IHC201	ABC Code 2 - Margin - Inventory Prior 01	Character	Generic Edit	1	0	Allow NULL?
157	IHC202	ABC Code 2 - Margin - Inventory Prior 02	Character	Generic Edit	1	0	Allow NULL?
158	IHC203	ABC Code 2 - Margin - Inventory Prior 03	Character	Generic Edit	1	0	Allow NULL?
159	IHC204	ABC Code 2 - Margin - Inventory Prior 04	Character	Generic Edit	1	0	Allow NULL?
160	IHC205	ABC Code 2 - Margin - Inventory Prior 05	Character	Generic Edit	1	0	Allow NULL?
161	IHC206	ABC Code 2 - Margin - Inventory Prior 06	Character	Generic Edit	1	0	Allow NULL?
162	IHC207	ABC Code 2 - Margin - Inventory Prior 07	Character	Generic Edit	1	0	Allow NULL?
163	IHC208	ABC Code 2 - Margin - Inventory Prior 08	Character	Generic Edit	1	0	Allow NULL?
164	IHC209	ABC Code 2 - Margin - Inventory Prior 09	Character	Generic Edit	1	0	Allow NULL?
165	IHC210	ABC Code 2 - Margin - Inventory Prior 10	Character	Generic Edit	1	0	Allow NULL?
166	IHC211	ABC Code 2 - Margin - Inventory Prior 11	Character	Generic Edit	1	0	Allow NULL?
167	IHC212	ABC Code 2 - Margin - Inventory Prior 12	Character	Generic Edit	1	0	Allow NULL?
168	IHC213	ABC Code 2 - Margin - Inventory Prior 13	Character	Generic Edit	1	0	Allow NULL?
169	IHC214	ABC Code 2 - Margin - Inventory Prior 14	Character	Generic Edit	1	0	Allow NULL?
170	IHC301	ABC Code 3 - Investment - Inv Prior 01	Character	Generic Edit	1	0	Allow NULL?
171	IHC302	ABC Code 3 - Investment - Inv Prior 02	Character	Generic Edit	1	0	Allow NULL?
172	IHC303	ABC Code 3 - Investment - Inv Prior 03	Character	Generic Edit	1	0	Allow NULL?
173	IHC304	ABC Code 3 - Investment - Inv Prior 04	Character	Generic Edit	1	0	Allow NULL?
174	IHC305	ABC Code 3 - Investment - Inv Prior 05	Character	Generic Edit	1	0	Allow NULL?
175	IHC306	ABC Code 3 - Investment - Inv Prior 06	Character	Generic Edit	1	0	Allow NULL?
176	IHC307	ABC Code 3 - Investment - Inv Prior 07	Character	Generic Edit	1	0	Allow NULL?
177	IHC308	ABC Code 3 - Investment - Inv Prior 08	Character	Generic Edit	1	0	Allow NULL?
178	IHC309	ABC Code 3 - Investment - Inv Prior 09	Character	Generic Edit	1	0	Allow NULL?
179	IHC310	ABC Code 3 - Investment - Inv Prior 10	Character	Generic Edit	1	0	Allow NULL?
180	IHC311	ABC Code 3 - Investment - Inv Prior 11	Character	Generic Edit	1	0	Allow NULL?
181	IHC312	ABC Code 3 - Investment - Inv Prior 12	Character	Generic Edit	1	0	Allow NULL?
182	IHC313	ABC Code 3 - Investment - Inv Prior 13	Character	Generic Edit	1	0	Allow NULL?
183	IHC314	ABC Code 3 - Investment - Inv Prior 14	Character	Generic Edit	1	0	Allow NULL?
184	IHGMTD	Amount - Gross Margin YTD	Numeric	Generic Edit	15	2	Allow NULL?
185	IHINVV	Amount - Average Inventory Value YTD	Numeric	Generic Edit	15	2	Allow NULL?

TOP 812 | 41 | F4115 INDEXES

Number

Description

Item Branch Fiscal Year (Primary/Unique)

Element	Alias	Description	Sequence
1	ITM	Item Number - Short	Ascending
2	MCU	Business Unit	Ascending
3	FY	Fiscal Year	Ascending

JDE TABLES

JD Edwards Enterprise One table definition reference

jde.erpref.com

JDE TABLESv3

920: Top 10 requests

910: Top 10 requests

812: Top 10 requests

185 COLUMNS | 1 INDEXES | 812 | 41 | F4115 TABLE

TOP 812 | 41 | F4115 COLUMNS

TOP 812 | 41 | F4115 INDEXES

JDE TABLES

JD Edwards Enterprise One table definition reference

jde.erpref.com

JDE TABLESv3

920: Top 10 requests

910: Top 10 requests

812: Top 10 requests

185 COLUMNS | 1 INDEXES | 812 | 41 | F4115 TABLE

TOP812 | 41 | F4115 COLUMNS

TOP812 | 41 | F4115 INDEXES

TOP 812 | 41 | F4115 COLUMNS

TOP 812 | 41 | F4115 INDEXES