920: Top 10 requests

	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	F9671	SD	Software Update Detail Table
7	F4102	IB	Item Branch File
8	F0411	RP	Accounts Payable Ledger
9	F0006	MC	Business Unit Master
10	F41021	LI	Item Location File

910: Top 10 requests

	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	F4111	IL	Item Ledger File
10	F4311	PD	Purchase Order Detail File

812: Top 10 requests

	Table	Prefix	Description
1	F0911	GL	Account Ledger
2	F4311	PD	Purchase Order Detail File
3	F0101	AB	Address Book Master
4	F0006	MC	Business Unit Master
5	F0411	RP	Accounts Payable Ledger
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

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
41: Inventory Management
1	910	F4101A	IM	136	1	Item File	Secondary Master Files	41: Inventory Management	Business Data

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	IMMCU	Business Unit	String	Generic Edit	12	0	Allow NULL?
2	IMITM	Item Number - Short	Numeric	Generic Edit	8	0	Allow NULL?
3	IMSTAW	Status	Character	UDC (00 WS)	1	0	Allow NULL?
4	IMEFFT	Effective - Thru Date	Date	Generic Edit	6	0
5	IMDOC	Document (Voucher Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
6	IMDCT	Document Type	String	UDC (00 DT)	2	0	Allow NULL?
7	IMEFFF	Effective - From Date	Date	Generic Edit	6	0
8	IMSERK	Key Value Serial Number	Numeric	Generic Edit	15	0	Allow NULL?
9	IMITBR	Update Item Branch	Character	Generic Edit	1	0	Allow NULL?
10	IMLITM	2nd Item Number	String	Generic Edit	25	0	Allow NULL?
11	IMAITM	3rd Item Number	String	Generic Edit	25	0	Allow NULL?
12	IMDSC1	Description	String	Generic Edit	30	0	Allow NULL?
13	IMDSC2	Description - Line 2	String	Generic Edit	30	0	Allow NULL?
14	IMSRTX	Search Text	String	Generic Edit	30	0	Allow NULL?
15	IMALN	Search Text - Compressed	String	Generic Edit	30	0	Allow NULL?
16	IMCDCD	Commodity Code	String	Generic Edit	15	0	Allow NULL?
17	IMPDGR	Product Group	String	UDC (41B PG)	3	0	Allow NULL?
18	IMDSGP	Dispatch Group	String	UDC (41B DG)	3	0	Allow NULL?
19	IMPRGR	Item Price Group	String	UDC (40 PI)	8	0	Allow NULL?
20	IMRPRC	Reprice (Basket Price) Category	String	UDC (40 PI)	8	0	Allow NULL?
21	IMORPR	Order Reprice Category	String	UDC (40 PI)	8	0	Allow NULL?
22	IMBUYR	Buyer Number	Numeric	Generic Edit	8	0	Allow NULL?
23	IMVCUD	Cubic Dimensions - Volume	Numeric	Generic Edit	15	4	Allow NULL?
24	IMUOM1	Unit of Measure - Primary	String	UDC (00 UM)	2	0	Allow NULL?
25	IMUOM2	Unit of Measure - Secondary	String	UDC (00 UM)	2	0	Allow NULL?
26	IMUOM3	Unit of Measure - Purchasing	String	UDC (00 UM)	2	0	Allow NULL?
27	IMUOM4	Unit of Measure - Pricing	String	UDC (00 UM)	2	0	Allow NULL?
28	IMUOM6	Unit of Measure - Shipping	String	UDC (00 UM)	2	0	Allow NULL?
29	IMUOM8	Unit of Measure - Production	String	UDC (00 UM)	2	0	Allow NULL?
30	IMUOM9	Unit of Measure - Component	String	UDC (00 UM)	2	0	Allow NULL?
31	IMUWUM	Unit of Measure - Weight	String	UDC (00 UM)	2	0	Allow NULL?
32	IMUVM1	Unit of Measure - Volume	String	UDC (00 UM)	2	0	Allow NULL?
33	IMSUTM	Unit of Measure - Stocking	String	UDC (00 UM)	2	0	Allow NULL?
34	IMUMVW	Unit of Measure - Volume or Weight	Character	UDC (39 VW)	1	0	Allow NULL?
35	IMGLPT	Category - G/L	String	UDC (41 9)	4	0	Allow NULL?
36	IMPLEV	Level - Sales Base Price	Character	UDC (H40 PL)	1	0	Allow NULL?
37	IMPPLV	Level - Purchase Price	Character	UDC (H40 PP)	1	0	Allow NULL?
38	IMCLEV	Level - Inventory Cost	Character	UDC (H40 CL)	1	0	Allow NULL?
39	IMCKAV	Check Availability Y/N	Character	Generic Edit	1	0	Allow NULL?
40	IMBPFG	Bulk/Packed Flag	Character	UDC (41B BF)	1	0	Allow NULL?
41	IMSRCE	Layer Code - Source	Character	UDC (H41 SR)	1	0	Allow NULL?
42	IMCOTY	Component Type	Character	UDC (H40 CP)	1	0	Allow NULL?
43	IMSTKT	Stocking Type	Character	UDC (41 I)	1	0	Allow NULL?
44	IMLNTY	Line Type	String	Generic Edit	2	0	Allow NULL?
45	IMCONT	Contract - Item	Character	Generic Edit	1	0	Allow NULL?
46	IMBACK	Backorders Allowed (Y/N)	Character	Generic Edit	1	0	Allow NULL?
47	IMIFLA	Item Flash Message	String	UDC (40 FL)	2	0	Allow NULL?
48	IMTFLA	Standard Unit of Measure Conversion	String	UDC (H40 ST)	2	0	Allow NULL?
49	IMINMG	Print Message	String	UDC (40 PM)	10	0	Allow NULL?
50	IMABCS	ABC Code 1 - Sales - Inventory	Character	UDC (H41 AB)	1	0	Allow NULL?
51	IMABCM	ABC Code 1 - Margin - Inventory	Character	UDC (H41 AB)	1	0	Allow NULL?
52	IMABCI	ABC Code 3 - Investment - Inventory	Character	UDC (H41 AB)	1	0	Allow NULL?
53	IMOVR	ABC Code Override Indicator	Character	Generic Edit	1	0	Allow NULL?
54	IMWARR	Type Warranty	String	Generic Edit	8	0	Allow NULL?
55	IMCMCG	Commission Category	String	Generic Edit	8	0	Allow NULL?
56	IMSRNR	Serial Number Required	Character	UDC (H41 NR)	1	0	Allow NULL?
57	IMPMTH	Method - Kit/Configurator Pricing	Character	UDC (H41 PM)	1	0	Allow NULL?
58	IMFIFO	FIFO Processing	Character	Generic Edit	1	0	Allow NULL?
59	IMLOTS	Lot Status Code	Character	UDC (41 L)	1	0	Allow NULL?
60	IMSLD	Days - Shelf Life Days	Numeric	Generic Edit	6	0	Allow NULL?
61	IMANPL	Planner Number	Numeric	Generic Edit	8	0	Allow NULL?
62	IMPCTM	Percent Margin	Numeric	Generic Edit	7	3	Allow NULL?
63	IMMMPC	Margin Maintenance (%)	Numeric	Generic Edit	7	3	Allow NULL?
64	IMORDW	Order With	Character	Generic Edit	1	0	Allow NULL?
65	IMEXPD	Expedite Damper Days	Numeric	Generic Edit	5	0	Allow NULL?
66	IMDEFD	Defer Damper Days	Numeric	Generic Edit	5	0	Allow NULL?
67	IMSFLT	Safety Leadtime	Numeric	Generic Edit	5	0	Allow NULL?
68	IMMAKE	Make/Buy Code	Character	UDC (H40 MA)	1	0	Allow NULL?
69	IMCOBY	Co-Products/By-Products/Intermediate	Character	UDC (H40 CO)	1	0	Allow NULL?
70	IMLLX	Low Level Code	Numeric	Generic Edit	3	0	Allow NULL?
71	IMCMGL	Commitment Method	Character	UDC (H40 CM)	1	0	Allow NULL?
72	IMCOMH	Commitment - Specific (Days)	Numeric	Generic Edit	3	0	Allow NULL?
73	IMVEND	Primary / Last Supplier Number	Numeric	Generic Edit	8	0	Allow NULL?
74	IMORIG	Country of Origin	String	UDC (00 CN)	3	0	Allow NULL?
75	IMWOMO	Quantity - Order Multiples (SO/PO)	Numeric	Generic Edit	7	0	Allow NULL?
76	IMSERV	Service Level	Numeric	Generic Edit	7	0	Allow NULL?
77	IMFUF1	AIA Document Flag	Character	UDC (H40 FU)	1	0	Allow NULL?
78	IMTX	Purchasing Taxable (Y/N)	Character	UDC (H00 TV)	1	0	Allow NULL?
79	IMTAX1	Sales Taxable (Y/N)	Character	UDC (H00 TV)	1	0	Allow NULL?
80	IMMRPD	Item Display Code	Character	UDC (H41 MR)	1	0	Allow NULL?
81	IMMRPC	Flag - Net Change	Character	UDC (H41 MQ)	1	0	Allow NULL?
82	IMMOVD	Move Hours - Standard	Numeric	Generic Edit	5	2	Allow NULL?
83	IMBQTY	Units - Batch Quantity	Numeric	Generic Edit	15	2	Allow NULL?
84	IMLFDJ	Date - Future Use	Date	Generic Edit	6	0
85	IMMLOT	Mix Dates / Lots (Y/N)	Character	Generic Edit	1	0	Allow NULL?
86	IMLOCN	Location	String	Generic Edit	20	0	Allow NULL?
87	IMLOTN	Lot/Serial Number	String	Generic Edit	30	0	Allow NULL?
88	IMURCD	User Reserved Code	String	Generic Edit	2	0	Allow NULL?
89	IMURDT	User Reserved Date	Date	Generic Edit	6	0
90	IMURAT	User Reserved Amount	Numeric	Generic Edit	15	2	Allow NULL?
91	IMURAB	User Reserved Number	Numeric	Generic Edit	8	0	Allow NULL?
92	IMURRF	User Reserved Reference	String	Generic Edit	15	0	Allow NULL?
93	IMUSER	User ID	String	Generic Edit	10	0	Allow NULL?
94	IMPID	Program ID	String	Generic Edit	10	0	Allow NULL?
95	IMJOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
96	IMUPMJ	Date - Updated	Date	Generic Edit	6	0
97	IMTDAY	Time of Day	Numeric	Generic Edit	6	0	Allow NULL?
98	IMTMPL	Template	String	Generic Edit	20	0	Allow NULL?
99	IMSEG1	Segment 1	String	Generic Edit	10	0	Allow NULL?
100	IMSEG2	Segment 2	String	Generic Edit	10	0	Allow NULL?
101	IMSEG3	Segment 3	String	Generic Edit	10	0	Allow NULL?
102	IMSEG4	Segment 4	String	Generic Edit	10	0	Allow NULL?
103	IMSEG5	Segment 5	String	Generic Edit	10	0	Allow NULL?
104	IMSEG6	Segment 6	String	Generic Edit	10	0	Allow NULL?
105	IMSEG7	Segment 7	String	Generic Edit	10	0	Allow NULL?
106	IMSEG8	Segment 8	String	Generic Edit	10	0	Allow NULL?
107	IMSEG9	Segment 9	String	Generic Edit	10	0	Allow NULL?
108	IMSEG0	Segment 10	String	Generic Edit	10	0	Allow NULL?
109	IMCMDM	Commitment Date Method	Character	UDC (H40 CD)	1	0	Allow NULL?
110	IMDPPO	Dual Picking Process Option	Character	Generic Edit	1	0	Allow NULL?
111	IMDUAL	Dual Unit Of Measure Item	Character	Generic Edit	1	0	Allow NULL?
112	IMLECM	Lot Expiraton Date Calculation Method	Character	UDC (H41 EC)	1	0	Allow NULL?
113	IMMIC	Matrix Controlled	Character	UDC (41 MA)	1	0	Allow NULL?
114	IMXDCK	Cross-Docking Flag	Character	Generic Edit	1	0	Allow NULL?
115	IMBBDD	Best Before Default Days	Numeric	Generic Edit	6	0	Allow NULL?
116	IMAING	Active Ingredient Flag	Character	Generic Edit	1	0	Allow NULL?
117	IMLEDD	Lot Effective Default Days	Numeric	Generic Edit	6	0	Allow NULL?
118	IMPEFD	Purchasing Effective Days	Numeric	Generic Edit	6	0	Allow NULL?
119	IMSBDD	Sell By Default Days	Numeric	Generic Edit	6	0	Allow NULL?
120	IMU1DD	User Lot Date 1 Default Days	Numeric	Generic Edit	6	0	Allow NULL?
121	IMU2DD	User Lot Date 2 Default Days	Numeric	Generic Edit	6	0	Allow NULL?
122	IMU3DD	User Lot Date 3 Default Days	Numeric	Generic Edit	6	0	Allow NULL?
123	IMU4DD	User Lot Date 4 Default Days	Numeric	Generic Edit	6	0	Allow NULL?
124	IMU5DD	User Lot Date 5 Default Days	Numeric	Generic Edit	6	0	Allow NULL?
125	IMDLTL	Dual Tolerance	Numeric	Generic Edit	7	2	Allow NULL?
126	IMLOTC	Lot Status Code Expanded	String	Generic Edit	3	0	Allow NULL?
127	IMCMETH	Method - Configurator Costing	Character	UDC (41 CM)	1	0	Allow NULL?
128	IMLAF	Lot Audit Flag	Character	Generic Edit	1	0	Allow NULL?
129	IMLTFM	Special Lot Format	Character	Generic Edit	1	0	Allow NULL?
130	IMRWLA	Restrict Work Order Lot Assignment	Character	Generic Edit	1	0	Allow NULL?
131	IMLNPA	Lot Number Pre-Assignment	Character	Generic Edit	1	0	Allow NULL?
132	IMASHL	Allow Shipping of Held Lots	Character	Generic Edit	1	0	Allow NULL?
133	IMVMINV	Vendor Managed Inventory	Character	Generic Edit	1	0	Allow NULL?
134	IMTNAC	Transaction Action	String	UDC (00 TA)	2	0	Allow NULL?
135	IMCOORE	Country of Origin Required Flag	Character	Generic Edit	1	0	Allow NULL?
136	IMPNYN	Production Number Controlled	Character	Generic Edit	1	0	Allow NULL?

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

136 COLUMNS | 1 INDEXES | 910 | 41 | F4101A TABLE

TOP 910 | 41 | F4101A COLUMNS

TOP 910 | 41 | F4101A 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

136 COLUMNS | 1 INDEXES | 910 | 41 | F4101A TABLE

TOP910 | 41 | F4101A COLUMNS

TOP910 | 41 | F4101A INDEXES

TOP 910 | 41 | F4101A COLUMNS

TOP 910 | 41 | F4101A INDEXES