	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

209 COLUMNS | 8 INDEXES | 920 | 41 | F4101 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
41: Inventory Management
1	920	F4101	IM	209	8	Item Master	Master Files	41: Inventory Management	Business Data

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 IMITM, IMLITM, IMAITM, IMDSC1, IMDSC2, IMSRTX, IMALN, IMSRP1, IMSRP2, IMSRP3, IMSRP4, IMSRP5, IMSRP6, IMSRP7, IMSRP8, IMSRP9, IMSRP0, IMPRP1, IMPRP2, IMPRP3, IMPRP4, IMPRP5, IMPRP6, IMPRP7, IMPRP8, IMPRP9, IMPRP0, IMCDCD, IMPDGR, IMDSGP, IMPRGR, IMRPRC, IMORPR, IMBUYR, IMDRAW, IMRVNO, IMDSZE, IMVCUD, IMCARS, IMCARP, IMSHCN, IMSHCM, IMUOM1, IMUOM2, IMUOM3, IMUOM4, IMUOM6, IMUOM8, IMUOM9, IMUWUM, IMUVM1, IMSUTM, IMUMVW, IMCYCL, IMGLPT, IMPLEV, IMPPLV, IMCLEV, IMPRPO, IMCKAV, IMBPFG, IMSRCE, IMOT1Y, IMOT2Y, IMSTDP, IMFRMP, IMTHRP, IMSTDG, IMFRGD, IMTHGD, IMCOTY, IMSTKT, IMLNTY, IMCONT, IMBACK, IMIFLA, IMTFLA, IMINMG, IMABCS, IMABCM, IMABCI, IMOVR, IMWARR, IMCMCG, IMSRNR, IMPMTH, IMFIFO, IMLOTS, IMSLD, IMANPL, IMMPST, IMPCTM, IMMMPC, IMPTSC, IMSNS, IMLTLV, IMLTMF, IMLTCM, IMOPC, IMOPV, IMACQ, IMMLQ, IMLTPU, IMMPSP, IMMRPP, IMITC, IMORDW, IMMTF1, IMMTF2, IMMTF3, IMMTF4, IMMTF5, IMEXPD, IMDEFD, IMSFLT, IMMAKE, IMCOBY, IMLLX, IMCMGL, IMCOMH, IMURCD, IMURDT, IMURAT, IMURAB, IMURRF, IMUSER, IMPID, IMJOBN, IMUPMJ, IMTDAY, IMUPCN, IMSCC0, IMUMUP, IMUMDF, IMUMS0, IMUMS1, IMUMS2, IMUMS3, IMUMS4, IMUMS5, IMUMS6, IMUMS7, IMUMS8, IMPOC, IMAVRT, IMEQTY, IMWTRQ, IMTMPL, IMSEG1, IMSEG2, IMSEG3, IMSEG4, IMSEG5, IMSEG6, IMSEG7, IMSEG8, IMSEG9, IMSEG0, IMMIC, IMAING, IMBBDD, IMCMDM, IMLECM, IMLEDD, IMPEFD, IMSBDD, IMU1DD, IMU2DD, IMU3DD, IMU4DD, IMU5DD, IMDLTL, IMDPPO, IMDUAL, IMXDCK, IMLAF, IMLTFM, IMRWLA, IMLNPA, IMLOTC, IMAPSC, IMAUOM, IMCONB, IMGCMP, IMPRI1, IMPRI2, IMASHL, IMVMINV, IMCMETH, IMEXPI, IMOPTH, IMCUTH, IMUMTH, IMLMFG, IMLINE, IMDFTPCT, IMKBIT, IMDFENDITM, IMKANEXLL, IMSCPSELL, IMMOPTH, IMMCUTH, IMCUMTH, IMATPRN, IMATPCA, IMATPAC, IMCOORE, IMVCPFC, IMPNYN FROM F4101

TOP 920 | 41 | F4101 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	IMITM	Item Number - Short	Numeric	Generic Edit	8	0	Allow NULL?
2	IMLITM	2nd Item Number	String	Generic Edit	25	0	Allow NULL?
3	IMAITM	3rd Item Number	String	Generic Edit	25	0	Allow NULL?
4	IMDSC1	Description	String	Generic Edit	30	0	Allow NULL?
5	IMDSC2	Description - Line 2	String	Generic Edit	30	0	Allow NULL?
6	IMSRTX	Search Text	String	Generic Edit	30	0	Allow NULL?
7	IMALN	Search Text - Compressed	String	Generic Edit	30	0	Allow NULL?
8	IMSRP1	Sales Catalog Section	String	UDC (41 S1)	3	0	Allow NULL?
9	IMSRP2	Sub Section	String	UDC (41 S2)	3	0	Allow NULL?
10	IMSRP3	Sales Category Code 3	String	UDC (41 S3)	3	0	Allow NULL?
11	IMSRP4	Sales Category Code 4	String	UDC (41 S4)	3	0	Allow NULL?
12	IMSRP5	Sales Category Code 5	String	UDC (41 S5)	3	0	Allow NULL?
13	IMSRP6	Category Code 6	String	UDC (41 06)	6	0	Allow NULL?
14	IMSRP7	Category Code 7	String	UDC (41 07)	6	0	Allow NULL?
15	IMSRP8	Category Code 8	String	UDC (41 08)	6	0	Allow NULL?
16	IMSRP9	Category Code 9	String	UDC (41 09)	6	0	Allow NULL?
17	IMSRP0	Category Code 10	String	UDC (41 10)	6	0	Allow NULL?
18	IMPRP1	Commodity Class	String	UDC (41 P1)	3	0	Allow NULL?
19	IMPRP2	Commodity Sub Class	String	UDC (41 P2)	3	0	Allow NULL?
20	IMPRP3	Supplier Rebate Code	String	UDC (41 P3)	3	0	Allow NULL?
21	IMPRP4	Master Planning Family	String	UDC (41 P4)	3	0	Allow NULL?
22	IMPRP5	Purchasing Category Code 5	String	UDC (41 P5)	3	0	Allow NULL?
23	IMPRP6	Group - Item Dimension	String	UDC (41 01)	6	0	Allow NULL?
24	IMPRP7	Group - Warehouse Process 1	String	UDC (41 02)	6	0	Allow NULL?
25	IMPRP8	Group - Warehouse Process 2	String	UDC (41 02)	6	0	Allow NULL?
26	IMPRP9	Group - Warehouse Process 3	String	UDC (41 02)	6	0	Allow NULL?
27	IMPRP0	Item Pool	String	UDC (41 05)	6	0	Allow NULL?
28	IMCDCD	Commodity Code	String	Generic Edit	15	0	Allow NULL?
29	IMPDGR	Product Group	String	UDC (41B PG)	3	0	Allow NULL?
30	IMDSGP	Dispatch Group	String	UDC (41B DG)	3	0	Allow NULL?
31	IMPRGR	Item Price Group	String	UDC (40 PI)	8	0	Allow NULL?
32	IMRPRC	Reprice (Basket Price) Category	String	UDC (40 PI)	8	0	Allow NULL?
33	IMORPR	Order Reprice Category	String	UDC (40 PI)	8	0	Allow NULL?
34	IMBUYR	Buyer Number	Numeric	Generic Edit	8	0	Allow NULL?
35	IMDRAW	Drawing Number	String	Generic Edit	20	0	Allow NULL?
36	IMRVNO	Last Revision No.	String	Generic Edit	2	0	Allow NULL?
37	IMDSZE	Drawing Size	Character	Generic Edit	1	0	Allow NULL?
38	IMVCUD	Cubic Dimensions - Volume	Numeric	Generic Edit	15	4	Allow NULL?
39	IMCARS	Carrier Number	Numeric	Generic Edit	8	0	Allow NULL?
40	IMCARP	Preferred Carrier - Purchasing	Numeric	Generic Edit	8	0	Allow NULL?
41	IMSHCN	Shipping Conditions Code	String	UDC (41 C)	3	0	Allow NULL?
42	IMSHCM	Shipping Commodity Class	String	UDC (41 E)	3	0	Allow NULL?
43	IMUOM1	Unit of Measure - Primary	String	UDC (00 UM)	2	0	Allow NULL?
44	IMUOM2	Unit of Measure - Secondary	String	UDC (00 UM)	2	0	Allow NULL?
45	IMUOM3	Unit of Measure - Purchasing	String	UDC (00 UM)	2	0	Allow NULL?
46	IMUOM4	Unit of Measure - Pricing	String	UDC (00 UM)	2	0	Allow NULL?
47	IMUOM6	Unit of Measure - Shipping	String	UDC (00 UM)	2	0	Allow NULL?
48	IMUOM8	Unit of Measure - Production	String	UDC (00 UM)	2	0	Allow NULL?
49	IMUOM9	Unit of Measure - Component	String	UDC (00 UM)	2	0	Allow NULL?
50	IMUWUM	Unit of Measure - Weight	String	UDC (00 UM)	2	0	Allow NULL?
51	IMUVM1	Unit of Measure - Volume	String	UDC (00 UM)	2	0	Allow NULL?
52	IMSUTM	Unit of Measure - Stocking	String	UDC (00 UM)	2	0	Allow NULL?
53	IMUMVW	Unit of Measure - Volume or Weight	Character	UDC (39 VW)	1	0	Allow NULL?
54	IMCYCL	Cycle Count Category	String	UDC (41 8)	3	0	Allow NULL?
55	IMGLPT	Category - G/L	String	UDC (41 9)	4	0	Allow NULL?
56	IMPLEV	Level - Sales Base Price	Character	UDC (H40 PL)	1	0	Allow NULL?
57	IMPPLV	Level - Purchase Price	Character	UDC (H40 PP)	1	0	Allow NULL?
58	IMCLEV	Level - Inventory Cost	Character	UDC (H40 CL)	1	0	Allow NULL?
59	IMPRPO	Grade/Potency Pricing	Character	UDC (40 LP)	1	0	Allow NULL?
60	IMCKAV	Check Availability Y/N	Character	Generic Edit	1	0	Allow NULL?
61	IMBPFG	Bulk/Packed Flag	Character	UDC (41B BF)	1	0	Allow NULL?
62	IMSRCE	Layer Code - Source	Character	UDC (H41 SR)	1	0	Allow NULL?
63	IMOT1Y	Potency Control	Character	Generic Edit	1	0	Allow NULL?
64	IMOT2Y	Grade Control	Character	Generic Edit	1	0	Allow NULL?
65	IMSTDP	Standard Potency	Numeric	Generic Edit	7	3	Allow NULL?
66	IMFRMP	From Potency	Numeric	Generic Edit	7	3	Allow NULL?
67	IMTHRP	Thru Potency	Numeric	Generic Edit	7	3	Allow NULL?
68	IMSTDG	Standard Grade	String	UDC (40 LG)	3	0	Allow NULL?
69	IMFRGD	From Grade	String	UDC (40 LG)	3	0	Allow NULL?
70	IMTHGD	Thru Grade	String	UDC (40 LG)	3	0	Allow NULL?
71	IMCOTY	Component Type	Character	UDC (H40 CP)	1	0	Allow NULL?
72	IMSTKT	Stocking Type	Character	UDC (41 I)	1	0	Allow NULL?
73	IMLNTY	Line Type	String	Generic Edit	2	0	Allow NULL?
74	IMCONT	Contract - Item	Character	Generic Edit	1	0	Allow NULL?
75	IMBACK	Backorders Allowed (Y/N)	Character	Generic Edit	1	0	Allow NULL?
76	IMIFLA	Item Flash Message	String	UDC (40 FL)	2	0	Allow NULL?
77	IMTFLA	Standard Unit of Measure Conversion	String	UDC (H40 ST)	2	0	Allow NULL?
78	IMINMG	Print Message	String	UDC (40 PM)	10	0	Allow NULL?
79	IMABCS	ABC Code 1 - Sales - Inventory	Character	UDC (H41 AB)	1	0	Allow NULL?
80	IMABCM	ABC Code 1 - Margin - Inventory	Character	UDC (H41 AB)	1	0	Allow NULL?
81	IMABCI	ABC Code 3 - Investment - Inventory	Character	UDC (H41 AB)	1	0	Allow NULL?
82	IMOVR	ABC Code Override Indicator	Character	Generic Edit	1	0	Allow NULL?
83	IMWARR	Type Warranty	String	Generic Edit	8	0	Allow NULL?
84	IMCMCG	Commission Category	String	Generic Edit	8	0	Allow NULL?
85	IMSRNR	Serial Number Required	Character	UDC (H41 NR)	1	0	Allow NULL?
86	IMPMTH	Method - Kit/Configurator Pricing	Character	UDC (H41 PM)	1	0	Allow NULL?
87	IMFIFO	FIFO Processing	Character	Generic Edit	1	0	Allow NULL?
88	IMLOTS	Lot Status Code	Character	UDC (41 L)	1	0	Allow NULL?
89	IMSLD	Days - Shelf Life Days	Numeric	Generic Edit	6	0	Allow NULL?
90	IMANPL	Planner Number	Numeric	Generic Edit	8	0	Allow NULL?
91	IMMPST	Planning Code	Character	UDC (H41 MP)	1	0	Allow NULL?
92	IMPCTM	Percent Margin	Numeric	Generic Edit	7	3	Allow NULL?
93	IMMMPC	Margin Maintenance (%)	Numeric	Generic Edit	7	3	Allow NULL?
94	IMPTSC	Material Status	String	UDC (40 PS)	2	0	Allow NULL?
95	IMSNS	Round to Whole Number	Character	UDC (H41 SN)	1	0	Allow NULL?
96	IMLTLV	Leadtime Level	Numeric	Generic Edit	5	0	Allow NULL?
97	IMLTMF	Leadtime MFG	Numeric	Generic Edit	5	0	Allow NULL?
98	IMLTCM	Leadtime Cumulative	Numeric	Generic Edit	5	0	Allow NULL?
99	IMOPC	Order Policy Code	Character	UDC (H41 OP)	1	0	Allow NULL?
100	IMOPV	Value - Order Policy	Numeric	Generic Edit	15	0	Allow NULL?
101	IMACQ	Quantity - Accounting Cost	Numeric	Generic Edit	15	0	Allow NULL?
102	IMMLQ	Quantity - MFG Leadtime	Numeric	Generic Edit	15	0	Allow NULL?
103	IMLTPU	Leadtime Per Unit	Numeric	Generic Edit	5	2	Allow NULL?
104	IMMPSP	Planning Time Fence Rule	Character	UDC (34 TF)	1	0	Allow NULL?
105	IMMRPP	Fixed or Variable Leadtime	Character	UDC (H41 MS)	1	0	Allow NULL?
106	IMITC	Issue Type Code	Character	UDC (41 IT)	1	0	Allow NULL?
107	IMORDW	Order With	Character	Generic Edit	1	0	Allow NULL?
108	IMMTF1	Planning Time Fence Days	Numeric	Generic Edit	5	0	Allow NULL?
109	IMMTF2	Freeze Time Fence Days	Numeric	Generic Edit	5	0	Allow NULL?
110	IMMTF3	Message Time Fence Days	Numeric	Generic Edit	5	0	Allow NULL?
111	IMMTF4	MPS/MRP Time Fence 4	Numeric	Generic Edit	5	0	Allow NULL?
112	IMMTF5	Shipment Leadtime Offset	Numeric	Generic Edit	5	0	Allow NULL?
113	IMEXPD	Expedite Damper Days	Numeric	Generic Edit	5	0	Allow NULL?
114	IMDEFD	Defer Damper Days	Numeric	Generic Edit	5	0	Allow NULL?
115	IMSFLT	Safety Leadtime	Numeric	Generic Edit	5	0	Allow NULL?
116	IMMAKE	Make/Buy Code	Character	UDC (H40 MA)	1	0	Allow NULL?
117	IMCOBY	Co-Products/By-Products/Intermediate	Character	UDC (H40 CO)	1	0	Allow NULL?
118	IMLLX	Low Level Code	Numeric	Generic Edit	3	0	Allow NULL?
119	IMCMGL	Commitment Method	Character	UDC (H40 CM)	1	0	Allow NULL?
120	IMCOMH	Commitment - Specific (Days)	Numeric	Generic Edit	3	0	Allow NULL?
121	IMURCD	User Reserved Code	String	Generic Edit	2	0	Allow NULL?
122	IMURDT	User Reserved Date	Date	Generic Edit	6	0
123	IMURAT	User Reserved Amount	Numeric	Generic Edit	15	2	Allow NULL?
124	IMURAB	User Reserved Number	Numeric	Generic Edit	8	0	Allow NULL?
125	IMURRF	User Reserved Reference	String	Generic Edit	15	0	Allow NULL?
126	IMUSER	User ID	String	Generic Edit	10	0	Allow NULL?
127	IMPID	Program ID	String	Generic Edit	10	0	Allow NULL?
128	IMJOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
129	IMUPMJ	Date - Updated	Date	Generic Edit	6	0
130	IMTDAY	Time of Day	Numeric	Generic Edit	6	0	Allow NULL?
131	IMUPCN	UPC Number	String	Generic Edit	13	0	Allow NULL?
132	IMSCC0	Aggregate SCC Code (PI=0)	String	Generic Edit	14	0	Allow NULL?
133	IMUMUP	Unit of Measure - UPC	String	UDC (00 UM)	2	0	Allow NULL?
134	IMUMDF	Unit of Measure - Aggregate UPC	String	UDC (00 UM)	2	0	Allow NULL?
135	IMUMS0	Unit of Measure - SCC(PI=0)	String	UDC (00 UM)	2	0	Allow NULL?
136	IMUMS1	Unit of Measure - SCC(PI=1)	String	UDC (00 UM)	2	0	Allow NULL?
137	IMUMS2	Unit of Measure - SCC(PI=2)	String	UDC (00 UM)	2	0	Allow NULL?
138	IMUMS3	Unit of Measure - SCC(PI=3)	String	UDC (00 UM)	2	0	Allow NULL?
139	IMUMS4	Unit of Measure - SCC(PI=4)	String	UDC (00 UM)	2	0	Allow NULL?
140	IMUMS5	Unit of Measure - SCC(PI=5)	String	UDC (00 UM)	2	0	Allow NULL?
141	IMUMS6	Unit of Measure - SCC(PI=6)	String	UDC (00 UM)	2	0	Allow NULL?
142	IMUMS7	Unit of Measure - SCC(PI=7)	String	UDC (00 UM)	2	0	Allow NULL?
143	IMUMS8	Unit of Measure - SCC(PI=8)	String	UDC (00 UM)	2	0	Allow NULL?
144	IMPOC	Issue and Receipt	Character	UDC (43 IR)	1	0	Allow NULL?
145	IMAVRT	Replenishment Hours - Standard	Numeric	Generic Edit	15	2	Allow NULL?
146	IMEQTY	Container Code	String	UDC (46 EQ)	5	0	Allow NULL?
147	IMWTRQ	Item Weight Required Y/N	Character	Generic Edit	1	0	Allow NULL?
148	IMTMPL	Template	String	Generic Edit	20	0	Allow NULL?
149	IMSEG1	Segment 1	String	Generic Edit	10	0	Allow NULL?
150	IMSEG2	Segment 2	String	Generic Edit	10	0	Allow NULL?
151	IMSEG3	Segment 3	String	Generic Edit	10	0	Allow NULL?
152	IMSEG4	Segment 4	String	Generic Edit	10	0	Allow NULL?
153	IMSEG5	Segment 5	String	Generic Edit	10	0	Allow NULL?
154	IMSEG6	Segment 6	String	Generic Edit	10	0	Allow NULL?
155	IMSEG7	Segment 7	String	Generic Edit	10	0	Allow NULL?
156	IMSEG8	Segment 8	String	Generic Edit	10	0	Allow NULL?
157	IMSEG9	Segment 9	String	Generic Edit	10	0	Allow NULL?
158	IMSEG0	Segment 10	String	Generic Edit	10	0	Allow NULL?
159	IMMIC	Matrix Controlled	Character	UDC (41 MA)	1	0	Allow NULL?
160	IMAING	Active Ingredient Flag	Character	Generic Edit	1	0	Allow NULL?
161	IMBBDD	Best Before Default Days	Numeric	Generic Edit	6	0	Allow NULL?
162	IMCMDM	Commitment Date Method	Character	UDC (H40 CD)	1	0	Allow NULL?
163	IMLECM	Lot Expiraton Date Calculation Method	Character	UDC (H41 EC)	1	0	Allow NULL?
164	IMLEDD	Lot Effective Default Days	Numeric	Generic Edit	6	0	Allow NULL?
165	IMPEFD	Purchasing Effective Days	Numeric	Generic Edit	6	0	Allow NULL?
166	IMSBDD	Sell By Default Days	Numeric	Generic Edit	6	0	Allow NULL?
167	IMU1DD	User Lot Date 1 Default Days	Numeric	Generic Edit	6	0	Allow NULL?
168	IMU2DD	User Lot Date 2 Default Days	Numeric	Generic Edit	6	0	Allow NULL?
169	IMU3DD	User Lot Date 3 Default Days	Numeric	Generic Edit	6	0	Allow NULL?
170	IMU4DD	User Lot Date 4 Default Days	Numeric	Generic Edit	6	0	Allow NULL?
171	IMU5DD	User Lot Date 5 Default Days	Numeric	Generic Edit	6	0	Allow NULL?
172	IMDLTL	Dual Tolerance	Numeric	Generic Edit	7	2	Allow NULL?
173	IMDPPO	Dual Picking Process Option	Character	Generic Edit	1	0	Allow NULL?
174	IMDUAL	Dual Unit Of Measure Item	Character	Generic Edit	1	0	Allow NULL?
175	IMXDCK	Cross-Docking Flag	Character	Generic Edit	1	0	Allow NULL?
176	IMLAF	Lot Audit Flag	Character	Generic Edit	1	0	Allow NULL?
177	IMLTFM	Special Lot Format	Character	Generic Edit	1	0	Allow NULL?
178	IMRWLA	Restrict Work Order Lot Assignment	Character	Generic Edit	1	0	Allow NULL?
179	IMLNPA	Lot Number Pre-Assignment	Character	Generic Edit	1	0	Allow NULL?
180	IMLOTC	Lot Status Code Expanded	String	Generic Edit	3	0	Allow NULL?
181	IMAPSC	Constraints Flag	Character	UDC (42 AC)	1	0	Allow NULL?
182	IMAUOM	APS Planning UOM	String	Generic Edit	9	0	Allow NULL?
183	IMCONB	Consumable	Character	Generic Edit	1	0	Allow NULL?
184	IMGCMP	Composition	Character	Generic Edit	1	0	Allow NULL?
185	IMPRI1	Priority One Alert Level	Numeric	Generic Edit	15	4	Allow NULL?
186	IMPRI2	Priority Two Alert Level	Numeric	Generic Edit	15	4	Allow NULL?
187	IMASHL	Allow Shipping of Held Lots	Character	Generic Edit	1	0	Allow NULL?
188	IMVMINV	Vendor Managed Inventory	Character	Generic Edit	1	0	Allow NULL?
189	IMCMETH	Method - Configurator Costing	Character	UDC (41 CM)	1	0	Allow NULL?
190	IMEXPI	Explode Item (1/0)	Character	Generic Edit	1	0	Allow NULL?
191	IMOPTH	Minimum Operational Threshold	Numeric	Generic Edit	15	4	Allow NULL?
192	IMCUTH	Minimum Cumulative Threshold	Numeric	Generic Edit	15	4	Allow NULL?
193	IMUMTH	Operational Threshold Unit of Measure	String	UDC (31B UM)	3	0	Allow NULL?
194	IMLMFG	Lean Manufacturing Flag	Character	Generic Edit	1	0	Allow NULL?
195	IMLINE	Line/Cell Identifier	String	Generic Edit	12	0	Allow NULL?
196	IMDFTPCT	Total Product Cycle Time	Numeric	Generic Edit	20	5	Allow NULL?
197	IMKBIT	Kanban Item	Character	Generic Edit	1	0	Allow NULL?
198	IMDFENDITM	Demand Flow End Item Flag	Character	Generic Edit	1	0	Allow NULL?
199	IMKANEXLL	Kanban Explode to Lower Level	Character	Generic Edit	1	0	Allow NULL?
200	IMSCPSELL	Sellable Item	Character	UDC (34A SA)	1	0	Allow NULL?
201	IMMOPTH	Maximum Operational Threshold	Numeric	Generic Edit	15	4	Allow NULL?
202	IMMCUTH	Maximum Cumulative Threshold	Numeric	Generic Edit	15	4	Allow NULL?
203	IMCUMTH	Cumulative Threshold Unit of Measure	String	UDC (31B UM)	3	0	Allow NULL?
204	IMATPRN	ATP Rule Name	String	Generic Edit	80	0	Allow NULL?
205	IMATPCA	Check ATP	Character	UDC (34A CA)	1	0	Allow NULL?
206	IMATPAC	ATP Components	String	UDC (34A AP)	5	0	Allow NULL?
207	IMCOORE	Country of Origin Required Flag	Character	Generic Edit	1	0	Allow NULL?
208	IMVCPFC	ATO Forecast Control	String	UDC (34A CF)	20	0	Allow NULL?
209	IMPNYN	Production Number Controlled	Character	Generic Edit	1	0	Allow NULL?

TOP 920 | 41 | F4101 INDEXES

Number

Description

Item Master (Primary/Unique)

Element	Alias	Description	Sequence
1	ITM	Item Number - Short	Ascending

2nd Item Number (Unique)

Element	Alias	Description	Sequence
1	LITM	2nd Item Number	Ascending

3rd Item Number (Unique)

Element	Alias	Description	Sequence
1	AITM	3rd Item Number	Ascending

Search Text Compressed

Element	Alias	Description	Sequence
1	ALN	Search Text - Compressed	Ascending

Low level Code

Element	Alias	Description	Sequence
1	LLX	Low Level Code	Descending

Segment1 Seg 2 +

Element	Alias	Description	Sequence
1	SEG1	Segment 1	Ascending
2	SEG2	Segment 2	Ascending
3	SEG3	Segment 3	Ascending
4	SEG4	Segment 4	Ascending
5	SEG5	Segment 5	Ascending
6	SEG6	Segment 6	Ascending
7	SEG7	Segment 7	Ascending
8	SEG8	Segment 8	Ascending
9	SEG9	Segment 9	Ascending
10	SEG0	Segment 10	Ascending

Template

Element	Alias	Description	Sequence
1	TMPL	Template	Ascending

Description Line1

Element	Alias	Description	Sequence
1	DSC1	Description	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

209 COLUMNS | 8 INDEXES | 920 | 41 | F4101 TABLE

TOP 920 | 41 | F4101 COLUMNS

TOP 920 | 41 | F4101 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

209 COLUMNS | 8 INDEXES | 920 | 41 | F4101 TABLE

TOP920 | 41 | F4101 COLUMNS

TOP920 | 41 | F4101 INDEXES

TOP 920 | 41 | F4101 COLUMNS

TOP 920 | 41 | F4101 INDEXES