	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

167 COLUMNS | 10 INDEXES | 812 | 41 | F4102 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
41: Inventory Management
1	812	F4102	IB	167	10	Item Branch File	Secondary Master 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 IBITM, IBLITM, IBAITM, IBMCU, IBSRP1, IBSRP2, IBSRP3, IBSRP4, IBSRP5, IBSRP6, IBSRP7, IBSRP8, IBSRP9, IBSRP0, IBPRP1, IBPRP2, IBPRP3, IBPRP4, IBPRP5, IBPRP6, IBPRP7, IBPRP8, IBPRP9, IBPRP0, IBCDCD, IBPDGR, IBDSGP, IBVEND, IBANPL, IBBUYR, IBGLPT, IBORIG, IBROPI, IBROQI, IBRQMX, IBRQMN, IBWOMO, IBSERV, IBSAFE, IBSLD, IBCKAV, IBSRCE, IBLOTS, IBOT1Y, IBOT2Y, IBSTDP, IBFRMP, IBTHRP, IBSTDG, IBFRGD, IBTHGD, IBCOTY, IBMMPC, IBPRGR, IBRPRC, IBORPR, IBBACK, IBIFLA, IBABCS, IBABCM, IBABCI, IBOVR, IBSHCM, IBCARS, IBCARP, IBSHCN, IBSTKT, IBLNTY, IBFIFO, IBCYCL, IBINMG, IBWARR, IBSRNR, IBPCTM, IBCMCG, IBFUF1, IBTX, IBTAX1, IBMPST, IBMRPD, IBMRPC, IBUPC, IBSNS, IBMERL, IBLTLV, IBLTMF, IBLTCM, IBOPC, IBOPV, IBACQ, IBMLQ, IBLTPU, IBMPSP, IBMRPP, IBITC, IBECO, IBECTY, IBECOD, IBMTF1, IBMTF2, IBMTF3, IBMTF4, IBMTF5, IBMOVD, IBQUED, IBSETL, IBSRNK, IBSRKF, IBTIMB, IBBQTY, IBORDW, IBEXPD, IBDEFD, IBMULT, IBSFLT, IBMAKE, IBLFDJ, IBLLX, IBCMGL, IBURCD, IBURDT, IBURAT, IBURAB, IBURRF, IBUSER, IBPID, IBJOBN, IBUPMJ, IBTDAY, IBTFLA, IBCOMH, IBAVRT, IBPOC, IBAING, IBBBDD, IBCMDM, IBLECM, IBLEDD, IBMLOT, IBPEFD, IBSBDD, IBU1DD, IBU2DD, IBU3DD, IBU4DD, IBU5DD, IBXDCK, IBLAF, IBLTFM, IBRWLA, IBLNPA, IBLOTC, IBAPSC, IBPRI1, IBPRI2, IBLTCV, IBASHL, IBOPTH, IBCUTH, IBUMTH, IBLMFG, IBLINE, IBDFTPCT, IBKBIT, IBDFENDITM, IBKANEXLL, IBSCPSELL FROM F4102

TOP 812 | 41 | F4102 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	IBITM	Item Number - Short	Numeric	Generic Edit	8	0	Allow NULL?
2	IBLITM	2nd Item Number	String	Generic Edit	25	0	Allow NULL?
3	IBAITM	3rd Item Number	String	Generic Edit	25	0	Allow NULL?
4	IBMCU	Business Unit	String	Generic Edit	12	0	Allow NULL?
5	IBSRP1	Sales Rpt 01 - Product Family	String	UDC (41 S1)	3	0	Allow NULL?
6	IBSRP2	Sales Rpt 02 - Family Section	String	UDC (41 S2)	3	0	Allow NULL?
7	IBSRP3	Sales Category Code 3	String	UDC (41 S3)	3	0	Allow NULL?
8	IBSRP4	Sales Category Code 4	String	UDC (41 S4)	3	0	Allow NULL?
9	IBSRP5	Sales Category Code 5	String	UDC (41 S5)	3	0	Allow NULL?
10	IBSRP6	Sales Rpt 06 - Product Line (Revenue)	String	UDC (41 06)	6	0	Allow NULL?
11	IBSRP7	Category Code 7	String	UDC (41 07)	6	0	Allow NULL?
12	IBSRP8	Sales Rpt 08 - Product Discount Group	String	UDC (41 08)	6	0	Allow NULL?
13	IBSRP9	Category Code 9	String	UDC (41 09)	6	0	Allow NULL?
14	IBSRP0	Category Code 10	String	UDC (41 10)	6	0	Allow NULL?
15	IBPRP1	Commodity Class	String	UDC (41 P1)	3	0	Allow NULL?
16	IBPRP2	Commodity Sub Class	String	UDC (41 P2)	3	0	Allow NULL?
17	IBPRP3	Supplier Rebate Code	String	UDC (41 P3)	3	0	Allow NULL?
18	IBPRP4	Master Planning Family	String	UDC (41 P4)	3	0	Allow NULL?
19	IBPRP5	Purchasing Category Code 5	String	UDC (41 P5)	3	0	Allow NULL?
20	IBPRP6	Group - Item Dimension	String	UDC (41 01)	6	0	Allow NULL?
21	IBPRP7	Group - Warehouse Process 1	String	UDC (41 02)	6	0	Allow NULL?
22	IBPRP8	Group - Warehouse Process 2	String	UDC (41 02)	6	0	Allow NULL?
23	IBPRP9	Group - Warehouse Process 3	String	UDC (41 02)	6	0	Allow NULL?
24	IBPRP0	Item Pool	String	UDC (41 05)	6	0	Allow NULL?
25	IBCDCD	Commodity Code	String	Generic Edit	15	0	Allow NULL?
26	IBPDGR	Product Group	String	UDC (41B PG)	3	0	Allow NULL?
27	IBDSGP	Dispatch Group	String	UDC (41B DG)	3	0	Allow NULL?
28	IBVEND	Primary / Last Supplier Number	Numeric	Generic Edit	8	0	Allow NULL?
29	IBANPL	Planner Number	Numeric	Generic Edit	8	0	Allow NULL?
30	IBBUYR	Buyer Number	Numeric	Generic Edit	8	0	Allow NULL?
31	IBGLPT	Category - G/L	String	UDC (41 9)	4	0	Allow NULL?
32	IBORIG	Country of Origin	String	UDC (00 CN)	3	0	Allow NULL?
33	IBROPI	Reorder Point - Input	Numeric	Generic Edit	15	2	Allow NULL?
34	IBROQI	Reorder Quantity - Input	Numeric	Generic Edit	15	2	Allow NULL?
35	IBRQMX	Reorder Quantity - Maximum	Numeric	Generic Edit	15	2	Allow NULL?
36	IBRQMN	Reorder Quantity - Minimum	Numeric	Generic Edit	15	2	Allow NULL?
37	IBWOMO	Quantity - Order Multiples (SO/PO)	Numeric	Generic Edit	7	0	Allow NULL?
38	IBSERV	Service Level	Numeric	Generic Edit	7	0	Allow NULL?
39	IBSAFE	Safety Stock	Numeric	Generic Edit	15	2	Allow NULL?
40	IBSLD	Days - Shelf Life Days	Numeric	Generic Edit	6	0	Allow NULL?
41	IBCKAV	Check Availability Y/N	Character	Generic Edit	1	0	Allow NULL?
42	IBSRCE	Layer Code - Source	Character	UDC (H41 SR)	1	0	Allow NULL?
43	IBLOTS	Lot Status Code	Character	UDC (41 L)	1	0	Allow NULL?
44	IBOT1Y	Potency Control	Character	Generic Edit	1	0	Allow NULL?
45	IBOT2Y	Grade Control	Character	Generic Edit	1	0	Allow NULL?
46	IBSTDP	Standard Potency	Numeric	Generic Edit	7	3	Allow NULL?
47	IBFRMP	From Potency	Numeric	Generic Edit	7	3	Allow NULL?
48	IBTHRP	Thru Potency	Numeric	Generic Edit	7	3	Allow NULL?
49	IBSTDG	Standard Grade	String	UDC (40 LG)	3	0	Allow NULL?
50	IBFRGD	From Grade	String	UDC (40 LG)	3	0	Allow NULL?
51	IBTHGD	Thru Grade	String	UDC (40 LG)	3	0	Allow NULL?
52	IBCOTY	Component Type	Character	UDC (H40 CP)	1	0	Allow NULL?
53	IBMMPC	Margin Maintenance (%)	Numeric	Generic Edit	7	3	Allow NULL?
54	IBPRGR	Item Price Group	String	UDC (40 PI)	8	0	Allow NULL?
55	IBRPRC	Reprice (Basket Price) Category	String	UDC (40 PI)	8	0	Allow NULL?
56	IBORPR	Order Reprice Category	String	UDC (40 PI)	8	0	Allow NULL?
57	IBBACK	Backorders Allowed (Y/N)	Character	Generic Edit	1	0	Allow NULL?
58	IBIFLA	Item Flash Message	String	UDC (40 FL)	2	0	Allow NULL?
59	IBABCS	ABC Code 1 - Sales - Inventory	Character	UDC (H41 AB)	1	0	Allow NULL?
60	IBABCM	ABC Code 1 - Margin - Inventory	Character	UDC (H41 AB)	1	0	Allow NULL?
61	IBABCI	ABC Code 3 - Investment - Inventory	Character	UDC (H41 AB)	1	0	Allow NULL?
62	IBOVR	ABC Code Override Indicator	Character	Generic Edit	1	0	Allow NULL?
63	IBSHCM	Shipping Commodity Class	String	UDC (41 E)	3	0	Allow NULL?
64	IBCARS	Carrier Number	Numeric	Generic Edit	8	0	Allow NULL?
65	IBCARP	Preferred Carrier - Purchasing	Numeric	Generic Edit	8	0	Allow NULL?
66	IBSHCN	Shipping Conditions Code	String	UDC (41 C)	3	0	Allow NULL?
67	IBSTKT	Stocking Type	Character	UDC (41 I)	1	0	Allow NULL?
68	IBLNTY	Line Type	String	Generic Edit	2	0	Allow NULL?
69	IBFIFO	FIFO Processing	Character	Generic Edit	1	0	Allow NULL?
70	IBCYCL	Cycle Count Category	String	UDC (41 8)	3	0	Allow NULL?
71	IBINMG	Print Message	String	UDC (40 PM)	10	0	Allow NULL?
72	IBWARR	Type Warranty	String	Generic Edit	8	0	Allow NULL?
73	IBSRNR	Serial Number Required	Character	UDC (H41 NR)	1	0	Allow NULL?
74	IBPCTM	Percent Margin	Numeric	Generic Edit	7	3	Allow NULL?
75	IBCMCG	Commission Category	String	Generic Edit	8	0	Allow NULL?
76	IBFUF1	AIA Document Flag	Character	UDC (H40 FU)	1	0	Allow NULL?
77	IBTX	Purchasing Taxable (Y/N)	Character	UDC (H00 TV)	1	0	Allow NULL?
78	IBTAX1	Sales Taxable (Y/N)	Character	UDC (H00 TV)	1	0	Allow NULL?
79	IBMPST	Planning Code	Character	UDC (H41 MP)	1	0	Allow NULL?
80	IBMRPD	Item Display Code	Character	UDC (H41 MR)	1	0	Allow NULL?
81	IBMRPC	Flag - Net Change	Character	UDC (H41 MQ)	1	0	Allow NULL?
82	IBUPC	Units - Per Container	Numeric	Generic Edit	15	0	Allow NULL?
83	IBSNS	Round to Whole Number	Character	UDC (H41 SN)	1	0	Allow NULL?
84	IBMERL	Item Revision Level	String	Generic Edit	3	0	Allow NULL?
85	IBLTLV	Leadtime Level	Numeric	Generic Edit	5	0	Allow NULL?
86	IBLTMF	Leadtime MFG	Numeric	Generic Edit	5	0	Allow NULL?
87	IBLTCM	Leadtime Cumulative	Numeric	Generic Edit	5	0	Allow NULL?
88	IBOPC	Order Policy Code	Character	UDC (H41 OP)	1	0	Allow NULL?
89	IBOPV	Value - Order Policy	Numeric	Generic Edit	15	0	Allow NULL?
90	IBACQ	Quantity - Accounting Cost	Numeric	Generic Edit	15	2	Allow NULL?
91	IBMLQ	Quantity - MFG Leadtime	Numeric	Generic Edit	15	2	Allow NULL?
92	IBLTPU	Leadtime Per Unit	Numeric	Generic Edit	5	2	Allow NULL?
93	IBMPSP	Planning Time Fence Rule	Character	UDC (34 TF)	1	0	Allow NULL?
94	IBMRPP	Fixed or Variable Leadtime	Character	UDC (H41 MS)	1	0	Allow NULL?
95	IBITC	Issue Type Code	Character	UDC (41 IT)	1	0	Allow NULL?
96	IBECO	ECO Number	String	Generic Edit	12	0	Allow NULL?
97	IBECTY	Engineering Change Reason	String	UDC (40 CR)	2	0	Allow NULL?
98	IBECOD	Date - Engineering Change Date	Date	Generic Edit	6	0
99	IBMTF1	Planning Time Fence Days	Numeric	Generic Edit	5	0	Allow NULL?
100	IBMTF2	Freeze Time Fence Days	Numeric	Generic Edit	5	0	Allow NULL?
101	IBMTF3	Message Time Fence Days	Numeric	Generic Edit	5	0	Allow NULL?
102	IBMTF4	MPS/MRP Time Fence 4	Numeric	Generic Edit	5	0	Allow NULL?
103	IBMTF5	Shipment Leadtime Offset	Numeric	Generic Edit	5	0	Allow NULL?
104	IBMOVD	Move Hours - Standard	Numeric	Generic Edit	5	2	Allow NULL?
105	IBQUED	Queue Hours - Standard	Numeric	Generic Edit	5	2	Allow NULL?
106	IBSETL	Setup Labor - Standard	Numeric	Generic Edit	15	2	Allow NULL?
107	IBSRNK	Shrink Factor	Numeric	Generic Edit	15	2	Allow NULL?
108	IBSRKF	Shrink Factor Method	Character	UDC (H40 SR)	1	0	Allow NULL?
109	IBTIMB	Time Basis Code	Character	UDC (30 TB)	1	0	Allow NULL?
110	IBBQTY	Units - Batch Quantity	Numeric	Generic Edit	15	2	Allow NULL?
111	IBORDW	Order With	Character	Generic Edit	1	0	Allow NULL?
112	IBEXPD	Expedite Damper Days	Numeric	Generic Edit	5	0	Allow NULL?
113	IBDEFD	Defer Damper Days	Numeric	Generic Edit	5	0	Allow NULL?
114	IBMULT	Quantity - Order Multiples (MRP)	Numeric	Generic Edit	15	2	Allow NULL?
115	IBSFLT	Safety Leadtime	Numeric	Generic Edit	5	0	Allow NULL?
116	IBMAKE	Make/Buy Code	Character	UDC (H40 MA)	1	0	Allow NULL?
117	IBLFDJ	Date - Future Use	Date	Generic Edit	6	0
118	IBLLX	Low Level Code	Numeric	Generic Edit	3	0	Allow NULL?
119	IBCMGL	Commitment Method	Character	UDC (H40 CM)	1	0	Allow NULL?
120	IBURCD	User Reserved Code	String	Generic Edit	2	0	Allow NULL?
121	IBURDT	User Reserved Date	Date	Generic Edit	6	0
122	IBURAT	User Reserved Amount	Numeric	Generic Edit	15	2	Allow NULL?
123	IBURAB	User Reserved Number	Numeric	Generic Edit	8	0	Allow NULL?
124	IBURRF	User Reserved Reference	String	Generic Edit	15	0	Allow NULL?
125	IBUSER	User ID	String	Generic Edit	10	0	Allow NULL?
126	IBPID	Program ID	String	Generic Edit	10	0	Allow NULL?
127	IBJOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
128	IBUPMJ	Date - Updated	Date	Generic Edit	6	0
129	IBTDAY	Time of Day	Numeric	Generic Edit	6	0	Allow NULL?
130	IBTFLA	Standard Unit of Measure Conversion	String	UDC (H40 ST)	2	0	Allow NULL?
131	IBCOMH	Commitment - Specific (Days)	Numeric	Generic Edit	3	0	Allow NULL?
132	IBAVRT	Replenishment Hours - Standard	Numeric	Generic Edit	15	2	Allow NULL?
133	IBPOC	Issue and Receipt	Character	UDC (43 IR)	1	0	Allow NULL?
134	IBAING	Active Ingredient Flag	Character	Generic Edit	1	0	Allow NULL?
135	IBBBDD	Best Before Default Days	Numeric	Generic Edit	6	0	Allow NULL?
136	IBCMDM	Commitment Date Method	Character	UDC (H40 CD)	1	0	Allow NULL?
137	IBLECM	Lot Expiraton Date Calculation Method	Character	UDC (H41 EC)	1	0	Allow NULL?
138	IBLEDD	Lot Effective Default Days	Numeric	Generic Edit	6	0	Allow NULL?
139	IBMLOT	Mix Dates / Lots (Y/N)	Character	Generic Edit	1	0	Allow NULL?
140	IBPEFD	Purchasing Effective Days	Numeric	Generic Edit	6	0	Allow NULL?
141	IBSBDD	Sell By Default Days	Numeric	Generic Edit	6	0	Allow NULL?
142	IBU1DD	User Lot Date 1 Default Days	Numeric	Generic Edit	6	0	Allow NULL?
143	IBU2DD	User Lot Date 2 Default Days	Numeric	Generic Edit	6	0	Allow NULL?
144	IBU3DD	User Lot Date 3 Default Days	Numeric	Generic Edit	6	0	Allow NULL?
145	IBU4DD	User Lot Date 4 Default Days	Numeric	Generic Edit	6	0	Allow NULL?
146	IBU5DD	User Lot Date 5 Default Days	Numeric	Generic Edit	6	0	Allow NULL?
147	IBXDCK	Cross-Docking Flag	Character	Generic Edit	1	0	Allow NULL?
148	IBLAF	Lot Audit Flag	Character	Generic Edit	1	0	Allow NULL?
149	IBLTFM	Special Lot Format	Character	Generic Edit	1	0	Allow NULL?
150	IBRWLA	Restrict Work Order Lot Assignment	Character	Generic Edit	1	0	Allow NULL?
151	IBLNPA	Lot Number Pre-Assignment	Character	Generic Edit	1	0	Allow NULL?
152	IBLOTC	Lot Status Code Expanded	String	Generic Edit	3	0	Allow NULL?
153	IBAPSC	Constraints Flag	Character	UDC (42 AC)	1	0	Allow NULL?
154	IBPRI1	Priority One Alert Level	Numeric	Generic Edit	15	4	Allow NULL?
155	IBPRI2	Priority Two Alert Level	Numeric	Generic Edit	15	4	Allow NULL?
156	IBLTCV	Leadtime Conversion Factor	Numeric	Generic Edit	15	7	Allow NULL?
157	IBASHL	Allow Shipping of Held Lots	Character	Generic Edit	1	0	Allow NULL?
158	IBOPTH	Operational Threshold	Numeric	Generic Edit	15	4	Allow NULL?
159	IBCUTH	Cumulative Threshold	Numeric	Generic Edit	15	4	Allow NULL?
160	IBUMTH	Threshold Unit of Measure	String	UDC (31B UM)	3	0	Allow NULL?
161	IBLMFG	Lean Manufacturing Flag	Character	Generic Edit	1	0	Allow NULL?
162	IBLINE	Line/Cell Identifier	String	Generic Edit	12	0	Allow NULL?
163	IBDFTPCT	Total Product Cycle Time	Numeric	Generic Edit	20	5	Allow NULL?
164	IBKBIT	Kanban Item	Character	Generic Edit	1	0	Allow NULL?
165	IBDFENDITM	Demand Flow End Item Flag	Character	Generic Edit	1	0	Allow NULL?
166	IBKANEXLL	Kanban Explode to Lower Level	Character	Generic Edit	1	0	Allow NULL?
167	IBSCPSELL	Sellable Item	Character	UDC (34A SA)	1	0	Allow NULL?

TOP 812 | 41 | F4102 INDEXES

Number

Description

Branch Item (Primary/Unique)

Element	Alias	Description	Sequence
1	MCU	Business Unit	Ascending
2	ITM	Item Number - Short	Ascending

Item Branch

Element	Alias	Description	Sequence
1	ITM	Item Number - Short	Ascending
2	MCU	Business Unit	Ascending

Vend Item

Element	Alias	Description	Sequence
1	VEND	Primary / Last Supplier Number	Ascending
2	ITM	Item Number - Short	Ascending

Purch Category Code 5 Item

Element	Alias	Description	Sequence
1	PRP5	Purchasing Category Code 5	Ascending
2	ITM	Item Number - Short	Ascending

Planning Family Branch +

Element	Alias	Description	Sequence
1	PRP4	Master Planning Family	Ascending
2	MCU	Business Unit	Ascending
3	MPST	Planning Code	Ascending

Planner Branch +

Element	Alias	Description	Sequence
1	ANPL	Planner Number	Ascending
2	MCU	Business Unit	Ascending
3	PRP4	Master Planning Family	Ascending
4	MPST	Planning Code	Ascending

Buyer Branch +

Element	Alias	Description	Sequence
1	BUYR	Buyer Number	Ascending
2	MCU	Business Unit	Ascending
3	PRP4	Master Planning Family	Ascending
4	MPST	Planning Code	Ascending

Pool Item +

Element	Alias	Description	Sequence
1	PRP0	Item Pool	Ascending
2	ITM	Item Number - Short	Ascending
3	MCU	Business Unit	Ascending

Branch Purch Cat Code 7 +

Element	Alias	Description	Sequence
1	MCU	Business Unit	Ascending
2	PRP7	Group - Warehouse Process 1	Ascending
3	PRP8	Group - Warehouse Process 2	Ascending
4	PRP9	Group - Warehouse Process 3	Ascending

Low Level Item +

Element	Alias	Description	Sequence
1	LLX	Low Level Code	Ascending
2	ITM	Item Number - Short	Ascending
3	MCU	Business Unit	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

167 COLUMNS | 10 INDEXES | 812 | 41 | F4102 TABLE

TOP 812 | 41 | F4102 COLUMNS

TOP 812 | 41 | F4102 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

167 COLUMNS | 10 INDEXES | 812 | 41 | F4102 TABLE

TOP812 | 41 | F4102 COLUMNS

TOP812 | 41 | F4102 INDEXES

TOP 812 | 41 | F4102 COLUMNS

TOP 812 | 41 | F4102 INDEXES