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	F4101S	IM	31	1	Item Master Shipping Data	Secondary Master Files	41: Inventory Management	Business Data

Column	Field	Description	Data Type	Edit Type	Length	SQL Create Statement
1	IMMCU	Business Unit	String	Generic Edit	12	Allow NULL?
2	IMITM	Item Number - Short	Numeric	Generic Edit	8	Allow NULL?
3	IMSTAW	Status	Character	UDC (00 WS)	1	Allow NULL?
4	IMEFFT	Effective - Thru Date	Date	Generic Edit	6
5	IMDOC	Document (Voucher Invoice etc.)	Numeric	Generic Edit	8	Allow NULL?
6	IMDCT	Document Type	String	UDC (00 DT)	2	Allow NULL?
7	IMEFFF	Effective - From Date	Date	Generic Edit	6
8	IMSERK	Key Value Serial Number	Numeric	Generic Edit	15	Allow NULL?
9	IMNMFC	Freight Classification (NMFC)	String	UDC (49 BE)	4	Allow NULL?
10	IMNMFI	NMFC Item Number	String	Generic Edit	6	Allow NULL?
11	IMSTCC	Standard Transportation Commodity Code	String	Generic Edit	10	Allow NULL?
12	IMFRT1	Freight Category Code 1	String	UDC (49 CJ)	6	Allow NULL?
13	IMFRT2	Freight Category Code 2	String	UDC (49 CK)	6	Allow NULL?
14	IMHSCD	Harmonized Shipping Code	String	Generic Edit	12	Allow NULL?
15	IMPDCG	Producer of Goods	String	UDC (49 BV)	4	Allow NULL?
16	IMPFCT	Preference Criteria	Character	UDC (49 BU)	1	Allow NULL?
17	IMECCN	Export Control Commodity Number	String	Generic Edit	10	Allow NULL?
18	IMDMFR	Domestic/Foreign Commodity	Character	UDC (49 BW)	1	Allow NULL?
19	IMUNNA	UN or NA Number	String	Generic Edit	6	Allow NULL?
20	IMHZDC	Hazard Class or Division	String	UDC (49 BX)	3	Allow NULL?
21	IMHZDL	Hazard Label	String	UDC (49 CC)	3	Allow NULL?
22	IMFPNT	Flash Point Temperature	Numeric	Generic Edit	4	Allow NULL?
23	IMSTPU	Temperature Type	Character	UDC (41B TP)	1	Allow NULL?
24	IMPKGP	Packaging Group	String	UDC (49 BY)	3	Allow NULL?
25	IMPKIN	Packaging Instructions	String	UDC (49 CB)	4	Allow NULL?
26	IMSRSK	Subsidiary Risk	String	UDC (49 BZ)	3	Allow NULL?
27	IMUSER	User ID	String	Generic Edit	10	Allow NULL?
28	IMPID	Program ID	String	Generic Edit	10	Allow NULL?
29	IMJOBN	Work Station ID	String	Generic Edit	10	Allow NULL?
30	IMUPMJ	Date - Updated	Date	Generic Edit	6
31	IMTDAY	Time of Day	Numeric	Generic Edit	6	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

31 COLUMNS | 1 INDEXES | 910 | 41 | F4101S TABLE

TOP 910 | 41 | F4101S COLUMNS

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

31 COLUMNS | 1 INDEXES | 910 | 41 | F4101S TABLE

TOP910 | 41 | F4101S COLUMNS

TOP910 | 41 | F4101S INDEXES

TOP 910 | 41 | F4101S COLUMNS

TOP 910 | 41 | F4101S INDEXES