	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

	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

	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

90 COLUMNS | 17 INDEXES | 812 | 46 | F4602 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
46: Warehouse Management
1	812	F4602	IF	90	17	Location Detail Information	Balance Files	46: Warehouse 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 IFITM, IFMCU, IFLOCN, IFLOTN, IFLDSQ, IFSTUN, IFUML1, IFUGL1, IFEUL1, IFPPL1, IFTQL1, IFEQL1, IFHPL1, IFWPL1, IFDPL1, IFCPL1, IFEPL1, IFUML2, IFUGL2, IFEUL2, IFQPL2, IFPPL2, IFTQL2, IFEQL2, IFHPL2, IFWPL2, IFDPL2, IFCPL2, IFEPL2, IFUML3, IFUGL3, IFEUL3, IFQPL3, IFPPL3, IFTQL3, IFEQL3, IFHPL3, IFWPL3, IFDPL3, IFCPL3, IFEPL3, IFUML4, IFUGL4, IFEUL4, IFQPL4, IFPPL4, IFTQL4, IFEQL4, IFHPL4, IFWPL4, IFDPL4, IFCPL4, IFEPL4, IFUML5, IFUGL5, IFEUL5, IFQPL5, IFTQL5, IFEQL5, IFHPL5, IFWPL5, IFDPL5, IFCPL5, IFEPL5, IFUOM1, IFTQTY, IFHCOM, IFQTRI, IFQTRO, IFCUBE, IFRCUB, IFVUMD, IFWEIT, IFRWET, IFUWUM, IFRCDJ, IFMMEJ, IFDOCO, IFDCTO, IFKCOO, IFLNID, IFSFXO, IFNLIN, IFUSER, IFPID, IFJOBN, IFUPMJ, IFTDAY, IFUOM2, IFDQTY FROM F4602

TOP 812 | 46 | F4602 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	IFITM	Item Number - Short	Numeric	Generic Edit	8	0	Allow NULL?
2	IFMCU	Business Unit	String	Generic Edit	12	0	Allow NULL?
3	IFLOCN	Location	String	Generic Edit	20	0	Allow NULL?
4	IFLOTN	Lot/Serial Number	String	Generic Edit	30	0	Allow NULL?
5	IFLDSQ	Sequence Number - Location Detail	Numeric	Generic Edit	8	0	Allow NULL?
6	IFSTUN	Storage Unit Number	Numeric	Generic Edit	8	0	Allow NULL?
7	IFUML1	Unit of Measure - Level 1	String	UDC (00 UM)	2	0	Allow NULL?
8	IFUGL1	Group - Unit of Measure (Level 1)	String	Generic Edit	2	0	Allow NULL?
9	IFEUL1	U/M Usage - Level 1	Character	UDC (H46 EU)	1	0	Allow NULL?
10	IFPPL1	Quantity per - Level 1 (primary U/M)	Numeric	Generic Edit	15	2	Allow NULL?
11	IFTQL1	Quantity - Total Level 1	Numeric	Generic Edit	15	2	Allow NULL?
12	IFEQL1	Container Code - Level 1	String	UDC (46 EQ)	5	0	Allow NULL?
13	IFHPL1	Height per - Level 1	Numeric	Generic Edit	15	2	Allow NULL?
14	IFWPL1	Width per - Level 1	Numeric	Generic Edit	15	2	Allow NULL?
15	IFDPL1	Depth per - Level 1	Numeric	Generic Edit	15	2	Allow NULL?
16	IFCPL1	Cubic Dimensions per - Level 1	Numeric	Generic Edit	15	2	Allow NULL?
17	IFEPL1	Weight per - Level 1	Numeric	Generic Edit	15	2	Allow NULL?
18	IFUML2	Unit of Measure - Level 2	String	UDC (00 UM)	2	0	Allow NULL?
19	IFUGL2	Group - Unit of Measure (Level 2)	String	Generic Edit	2	0	Allow NULL?
20	IFEUL2	U/M Usage - Level 2	Character	UDC (H46 EU)	1	0	Allow NULL?
21	IFQPL2	Quantity per - Level 2	Numeric	Generic Edit	15	2	Allow NULL?
22	IFPPL2	Quantity per - Level 2 (primary U/M)	Numeric	Generic Edit	15	2	Allow NULL?
23	IFTQL2	Quantity - Total Level 2	Numeric	Generic Edit	15	2	Allow NULL?
24	IFEQL2	Container Code - Level 2	String	UDC (46 EQ)	5	0	Allow NULL?
25	IFHPL2	Height per - Level 2	Numeric	Generic Edit	15	2	Allow NULL?
26	IFWPL2	Width per - Level 2	Numeric	Generic Edit	15	2	Allow NULL?
27	IFDPL2	Depth per - Level 2	Numeric	Generic Edit	15	2	Allow NULL?
28	IFCPL2	Cubic Dimensions per - Level 2	Numeric	Generic Edit	15	2	Allow NULL?
29	IFEPL2	Weight per - Level 2	Numeric	Generic Edit	15	2	Allow NULL?
30	IFUML3	Unit of Measure - Level 3	String	UDC (00 UM)	2	0	Allow NULL?
31	IFUGL3	Group - Unit of Measure (Level 3)	String	Generic Edit	2	0	Allow NULL?
32	IFEUL3	U/M Usage - Level 3	Character	UDC (H46 EU)	1	0	Allow NULL?
33	IFQPL3	Quantity per - Level 3	Numeric	Generic Edit	15	2	Allow NULL?
34	IFPPL3	Quantity per - Level 3 (primary U/M)	Numeric	Generic Edit	15	2	Allow NULL?
35	IFTQL3	Quantity - Total Level 3	Numeric	Generic Edit	15	2	Allow NULL?
36	IFEQL3	Container Code - Level 3	String	UDC (46 EQ)	5	0	Allow NULL?
37	IFHPL3	Height per - Level 3	Numeric	Generic Edit	15	2	Allow NULL?
38	IFWPL3	Width per - Level 3	Numeric	Generic Edit	15	2	Allow NULL?
39	IFDPL3	Depth per - Level 3	Numeric	Generic Edit	15	2	Allow NULL?
40	IFCPL3	Cubic Dimensions per - Level 3	Numeric	Generic Edit	15	2	Allow NULL?
41	IFEPL3	Weight per - Level 3	Numeric	Generic Edit	15	2	Allow NULL?
42	IFUML4	Unit of Measure - Level 4	String	UDC (00 UM)	2	0	Allow NULL?
43	IFUGL4	Group - Unit of Measure (Level 4)	String	Generic Edit	2	0	Allow NULL?
44	IFEUL4	U/M Usage - Level 4	Character	UDC (H46 EU)	1	0	Allow NULL?
45	IFQPL4	Quantity per - Level 4	Numeric	Generic Edit	15	2	Allow NULL?
46	IFPPL4	Quantity per - Level 4 (primary U/M)	Numeric	Generic Edit	15	2	Allow NULL?
47	IFTQL4	Quantity - Total Level 4	Numeric	Generic Edit	15	2	Allow NULL?
48	IFEQL4	Container Code - Level 4	String	UDC (46 EQ)	5	0	Allow NULL?
49	IFHPL4	Height per - Level 4	Numeric	Generic Edit	15	2	Allow NULL?
50	IFWPL4	Width per - Level 4	Numeric	Generic Edit	15	2	Allow NULL?
51	IFDPL4	Depth per - Level 4	Numeric	Generic Edit	15	2	Allow NULL?
52	IFCPL4	Cubic Dimensions per - Level 4	Numeric	Generic Edit	15	2	Allow NULL?
53	IFEPL4	Weight per - Level 4	Numeric	Generic Edit	15	2	Allow NULL?
54	IFUML5	Unit of Measure - Level 5	String	UDC (00 UM)	2	0	Allow NULL?
55	IFUGL5	Group - Unit of Measure (Level 5)	String	Generic Edit	2	0	Allow NULL?
56	IFEUL5	U/M Usage - Level 5	Character	UDC (H46 EU)	1	0	Allow NULL?
57	IFQPL5	Quantity per - Level 5	Numeric	Generic Edit	15	2	Allow NULL?
58	IFTQL5	Quantity - Total Level 5	Numeric	Generic Edit	15	2	Allow NULL?
59	IFEQL5	Container Code - Level 5	String	UDC (46 EQ)	5	0	Allow NULL?
60	IFHPL5	Height per - Level 5	Numeric	Generic Edit	15	2	Allow NULL?
61	IFWPL5	Width per - Level 5	Numeric	Generic Edit	15	2	Allow NULL?
62	IFDPL5	Depth per - Level 5	Numeric	Generic Edit	15	2	Allow NULL?
63	IFCPL5	Cubic Dimensions per - Level 5	Numeric	Generic Edit	15	2	Allow NULL?
64	IFEPL5	Weight per - Level 5	Numeric	Generic Edit	15	2	Allow NULL?
65	IFUOM1	Unit of Measure - Primary	String	UDC (00 UM)	2	0	Allow NULL?
66	IFTQTY	Quantity -Total	Numeric	Generic Edit	15	2	Allow NULL?
67	IFHCOM	Quantity - Hard Committed	Numeric	Generic Edit	15	2	Allow NULL?
68	IFQTRI	Quantity Inbound - Warehouse	Numeric	Generic Edit	15	2	Allow NULL?
69	IFQTRO	Quantity Outbound - Warehouse	Numeric	Generic Edit	15	2	Allow NULL?
70	IFCUBE	Amount - Used Cubes	Numeric	Generic Edit	15	2	Allow NULL?
71	IFRCUB	Cubic Dimensions - Reserved	Numeric	Generic Edit	15	2	Allow NULL?
72	IFVUMD	Unit of Measure - Volume Display	String	UDC (00 UM)	2	0	Allow NULL?
73	IFWEIT	Amount - Used Weight	Numeric	Generic Edit	15	2	Allow NULL?
74	IFRWET	Amount - Reserved Weight	Numeric	Generic Edit	15	2	Allow NULL?
75	IFUWUM	Unit of Measure - Weight	String	UDC (00 UM)	2	0	Allow NULL?
76	IFRCDJ	Date - Received	Date	Generic Edit	6	0
77	IFMMEJ	Date - Lot Expiration	Date	Generic Edit	6	0
78	IFDOCO	Document (Order No Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
79	IFDCTO	Order Type	String	UDC (00 DT)	2	0	Allow NULL?
80	IFKCOO	Order Company (Order Number)	String	Generic Edit	5	0	Allow NULL?
81	IFLNID	Line Number	Numeric	Generic Edit	6	3	Allow NULL?
82	IFSFXO	Order Suffix	String	Generic Edit	3	0	Allow NULL?
83	IFNLIN	Number of Lines	Numeric	Generic Edit	5	0	Allow NULL?
84	IFUSER	User ID	String	Generic Edit	10	0	Allow NULL?
85	IFPID	Program ID	String	Generic Edit	10	0	Allow NULL?
86	IFJOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
87	IFUPMJ	Date - Updated	Date	Generic Edit	6	0
88	IFTDAY	Time of Day	Numeric	Generic Edit	6	0	Allow NULL?
89	IFUOM2	Unit of Measure - Secondary	String	UDC (00 UM)	2	0	Allow NULL?
90	IFDQTY	Dual Quantity	Numeric	Generic Edit	15	0	Allow NULL?

TOP 812 | 46 | F4602 INDEXES

Number

Description

Item Branch Locn Lot Seq (Primary/Unique)

Element	Alias	Description	Sequence
1	ITM	Item Number - Short	Ascending
2	MCU	Business Unit	Ascending
3	LOCN	Location	Ascending
4	LOTN	Lot/Serial Number	Ascending
5	LDSQ	Sequence Number - Location Detail	Ascending

Branch Item Locn Lot UML1

Element	Alias	Description	Sequence
1	MCU	Business Unit	Ascending
2	ITM	Item Number - Short	Ascending
3	LOCN	Location	Ascending
4	LOTN	Lot/Serial Number	Ascending
5	UML1	Unit of Measure - Level 1	Ascending

Branch Item Locn Lot UGL1

Element	Alias	Description	Sequence
1	MCU	Business Unit	Ascending
2	ITM	Item Number - Short	Ascending
3	LOCN	Location	Ascending
4	LOTN	Lot/Serial Number	Ascending
5	UGL1	Group - Unit of Measure (Level 1)	Ascending

Item Branch UML1 PPL1

Element	Alias	Description	Sequence
1	ITM	Item Number - Short	Ascending
2	MCU	Business Unit	Ascending
3	UML1	Unit of Measure - Level 1	Ascending
4	PPL1	Quantity per - Level 1 (primary U/M)	Ascending

Item Branch UML2 PPL2

Element	Alias	Description	Sequence
1	ITM	Item Number - Short	Ascending
2	MCU	Business Unit	Ascending
3	UML2	Unit of Measure - Level 2	Ascending
4	PPL2	Quantity per - Level 2 (primary U/M)	Ascending

Item Branch UML3 PPL3

Element	Alias	Description	Sequence
1	ITM	Item Number - Short	Ascending
2	MCU	Business Unit	Ascending
3	UML3	Unit of Measure - Level 3	Ascending
4	PPL3	Quantity per - Level 3 (primary U/M)	Ascending

Item Branch UML4 PPL4

Element	Alias	Description	Sequence
1	ITM	Item Number - Short	Ascending
2	MCU	Business Unit	Ascending
3	UML4	Unit of Measure - Level 4	Ascending
4	PPL4	Quantity per - Level 4 (primary U/M)	Ascending

Item Branch UML5

Element	Alias	Description	Sequence
1	ITM	Item Number - Short	Ascending
2	MCU	Business Unit	Ascending
3	UML5	Unit of Measure - Level 5	Ascending

Item Branch UGL1

Element	Alias	Description	Sequence
1	ITM	Item Number - Short	Ascending
2	MCU	Business Unit	Ascending
3	UGL1	Group - Unit of Measure (Level 1)	Ascending

Item Branch UGL2

Element	Alias	Description	Sequence
1	ITM	Item Number - Short	Ascending
2	MCU	Business Unit	Ascending
3	UGL2	Group - Unit of Measure (Level 2)	Ascending

Item Branch UGL3

Element	Alias	Description	Sequence
1	ITM	Item Number - Short	Ascending
2	MCU	Business Unit	Ascending
3	UGL3	Group - Unit of Measure (Level 3)	Ascending

Item Branch UGL4

Element	Alias	Description	Sequence
1	ITM	Item Number - Short	Ascending
2	MCU	Business Unit	Ascending
3	UGL4	Group - Unit of Measure (Level 4)	Ascending

Item Branch UGL5

Element	Alias	Description	Sequence
1	ITM	Item Number - Short	Ascending
2	MCU	Business Unit	Ascending
3	UGL5	Group - Unit of Measure (Level 5)	Ascending

License Plate

Element	Alias	Description	Sequence
1	STUN	Storage Unit Number	Ascending

Branch Locn Item UML1 EQL1

Element	Alias	Description	Sequence
1	MCU	Business Unit	Ascending
2	LOCN	Location	Ascending
3	ITM	Item Number - Short	Ascending
4	UML1	Unit of Measure - Level 1	Ascending
5	EQL1	Container Code - Level 1	Ascending

DOCO DCTO KCOO SFXO LNID NLIN

Element	Alias	Description	Sequence
1	DOCO	Document (Order No Invoice etc.)	Ascending
2	DCTO	Order Type	Ascending
3	KCOO	Order Company (Order Number)	Ascending
4	SFXO	Order Suffix	Ascending
5	LNID	Line Number	Ascending
6	NLIN	Number of Lines	Ascending

Branch Item STUN Locn Lot

Element	Alias	Description	Sequence
1	MCU	Business Unit	Ascending
2	ITM	Item Number - Short	Ascending
3	STUN	Storage Unit Number	Ascending
4	LOCN	Location	Ascending
5	LOTN	Lot/Serial Number	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

90 COLUMNS | 17 INDEXES | 812 | 46 | F4602 TABLE

TOP 812 | 46 | F4602 COLUMNS

TOP 812 | 46 | F4602 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

90 COLUMNS | 17 INDEXES | 812 | 46 | F4602 TABLE

TOP812 | 46 | F4602 COLUMNS

TOP812 | 46 | F4602 INDEXES

TOP 812 | 46 | F4602 COLUMNS

TOP 812 | 46 | F4602 INDEXES