	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

73 COLUMNS | 2 INDEXES | 920 | 41F | FCW50 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
41F: Apparel Management
1	920	FCW50	BX	73	2	Bill of Material Association Matrix	Files	41F: Apparel Management

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 BXKIT, BXMMCU, BXTBM, BXBQTY, BXITM, BXCPNT, BXSBNT, BXCOBY, BXC9LVC0, BXC9LVNO, BXC9LVCO1, BXC9LVCO2, BXC9LVCO3, BXC9LVCO4, BXC9LVCO5, BXC9LVCO6, BXC9LVCO7, BXC9LVCO8, BXC9LVCO9, BXC9LVCO10, BXC9LVCO11, BXC9LVCO12, BXC9LVCO13, BXC9LVCO14, BXC9LVCO15, BXC9LVCO16, BXC9LVCO17, BXC9LVCO18, BXC9LVCO19, BXC9LVCO20, BXC9LVCO21, BXC9LVCO22, BXC9LVCO23, BXC9LVCO24, BXC9LVCO25, BXC9LVCO26, BXC9LVCO27, BXC9LVCO28, BXC9LVCO29, BXC9LVCO30, BXC9STRC, BXC9GRCD, BXCPNB, BXCOQNTY1, BXCOQNTY2, BXCOQNTY3, BXCOQNTY4, BXCOQNTY5, BXCOQNTY6, BXCOQNTY7, BXCOQNTY8, BXCOQNTY9, BXCOQNTY10, BXCOQNTY11, BXCOQNTY12, BXCOQNTY13, BXCOQNTY14, BXCOQNTY15, BXCOQNTY16, BXCOQNTY18, BXCOQNTY17, BXCOQNTY19, BXCOQNTY20, BXCOQNTY21, BXCOQNTY22, BXCOQNTY23, BXCOQNTY24, BXCOQNTY25, BXCOQNTY26, BXCOQNTY27, BXCOQNTY28, BXCOQNTY29, BXCOQNTY30 FROM FCW50

TOP 920 | 41F | FCW50 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	BXKIT	Parent (short) Item Number	Numeric	Generic Edit	8	0	Allow NULL?
2	BXMMCU	Branch	String	Generic Edit	12	0	Allow NULL?
3	BXTBM	Type Bill of Material	String	UDC (40 TB)	3	0	Allow NULL?
4	BXBQTY	Units - Batch Quantity	Numeric	Generic Edit	15	0	Allow NULL?
5	BXITM	Item Number - Short	Numeric	Generic Edit	8	0	Allow NULL?
6	BXCPNT	Component Line Number	Numeric	Generic Edit	4	1	Allow NULL?
7	BXSBNT	Substitute Item Sequence Number	Numeric	Generic Edit	5	2	Allow NULL?
8	BXCOBY	Co-Products/By-Products/Intermediate	Character	UDC (H40 CO)	1	0	Allow NULL?
9	BXC9LVC0	Component Level 0	String	Generic Edit	25	0	Allow NULL?
10	BXC9LVNO	Level No	Numeric	Generic Edit	2	0	Allow NULL?
11	BXC9LVCO1	Level Code 1	String	Generic Edit	25	0	Allow NULL?
12	BXC9LVCO2	Level Code 2	String	Generic Edit	25	0	Allow NULL?
13	BXC9LVCO3	Level Code 3	String	Generic Edit	25	0	Allow NULL?
14	BXC9LVCO4	Level Code 4	String	Generic Edit	25	0	Allow NULL?
15	BXC9LVCO5	Level Code 5	String	Generic Edit	25	0	Allow NULL?
16	BXC9LVCO6	Level Code 6	String	Generic Edit	25	0	Allow NULL?
17	BXC9LVCO7	Level Code 7	String	Generic Edit	25	0	Allow NULL?
18	BXC9LVCO8	Level Code 8	String	Generic Edit	25	0	Allow NULL?
19	BXC9LVCO9	Level Code 9	String	Generic Edit	25	0	Allow NULL?
20	BXC9LVCO10	Level Code 10	String	Generic Edit	25	0	Allow NULL?
21	BXC9LVCO11	Level Code 11	String	Generic Edit	25	0	Allow NULL?
22	BXC9LVCO12	Level Code 12	String	Generic Edit	25	0	Allow NULL?
23	BXC9LVCO13	Level Code 13	String	Generic Edit	25	0	Allow NULL?
24	BXC9LVCO14	Level Code 14	String	Generic Edit	25	0	Allow NULL?
25	BXC9LVCO15	Level Code 15	String	Generic Edit	25	0	Allow NULL?
26	BXC9LVCO16	Level Code 16	String	Generic Edit	25	0	Allow NULL?
27	BXC9LVCO17	Level Code 17	String	Generic Edit	25	0	Allow NULL?
28	BXC9LVCO18	Level Code 18	String	Generic Edit	25	0	Allow NULL?
29	BXC9LVCO19	Level Code 19	String	Generic Edit	25	0	Allow NULL?
30	BXC9LVCO20	Level Code 20	String	Generic Edit	25	0	Allow NULL?
31	BXC9LVCO21	Level Code 21	String	Generic Edit	25	0	Allow NULL?
32	BXC9LVCO22	Level Code 22	String	Generic Edit	25	0	Allow NULL?
33	BXC9LVCO23	Level Code 23	String	Generic Edit	25	0	Allow NULL?
34	BXC9LVCO24	Level Code 24	String	Generic Edit	25	0	Allow NULL?
35	BXC9LVCO25	Level Code 25	String	Generic Edit	25	0	Allow NULL?
36	BXC9LVCO26	Level Code 26	String	Generic Edit	25	0	Allow NULL?
37	BXC9LVCO27	Level Code 27	String	Generic Edit	25	0	Allow NULL?
38	BXC9LVCO28	Level Code 28	String	Generic Edit	25	0	Allow NULL?
39	BXC9LVCO29	Level Code 29	String	Generic Edit	25	0	Allow NULL?
40	BXC9LVCO30	Level Code 30	String	Generic Edit	25	0	Allow NULL?
41	BXC9STRC	Structure	String	UDC (41F IS)	3	0	Allow NULL?
42	BXC9GRCD	Grid Code	String	UDC (41F GD)	3	0	Allow NULL?
43	BXCPNB	Component Line Number BOM	Numeric	Generic Edit	8	2	Allow NULL?
44	BXCOQNTY1	Quantity 1	Numeric	Generic Edit	15	6	Allow NULL?
45	BXCOQNTY2	Quantity 2	Numeric	Generic Edit	15	6	Allow NULL?
46	BXCOQNTY3	Quantity 3	Numeric	Generic Edit	15	6	Allow NULL?
47	BXCOQNTY4	Quantity 4	Numeric	Generic Edit	15	6	Allow NULL?
48	BXCOQNTY5	Quantity 5	Numeric	Generic Edit	15	6	Allow NULL?
49	BXCOQNTY6	Quantity 6	Numeric	Generic Edit	15	6	Allow NULL?
50	BXCOQNTY7	Quantity 7	Numeric	Generic Edit	15	6	Allow NULL?
51	BXCOQNTY8	Quantity 8	Numeric	Generic Edit	15	6	Allow NULL?
52	BXCOQNTY9	Quantity 9	Numeric	Generic Edit	15	6	Allow NULL?
53	BXCOQNTY10	Quantity 10	Numeric	Generic Edit	15	6	Allow NULL?
54	BXCOQNTY11	Quantity 11	Numeric	Generic Edit	15	6	Allow NULL?
55	BXCOQNTY12	Quantity 12	Numeric	Generic Edit	15	6	Allow NULL?
56	BXCOQNTY13	Quantity 13	Numeric	Generic Edit	15	6	Allow NULL?
57	BXCOQNTY14	Quantity 14	Numeric	Generic Edit	15	6	Allow NULL?
58	BXCOQNTY15	Quantity 15	Numeric	Generic Edit	15	6	Allow NULL?
59	BXCOQNTY16	Quantity 16	Numeric	Generic Edit	15	6	Allow NULL?
60	BXCOQNTY18	Quantity 18	Numeric	Generic Edit	15	6	Allow NULL?
61	BXCOQNTY17	Quantity 17	Numeric	Generic Edit	15	6	Allow NULL?
62	BXCOQNTY19	Quantity 19	Numeric	Generic Edit	15	6	Allow NULL?
63	BXCOQNTY20	Quantity 20	Numeric	Generic Edit	15	6	Allow NULL?
64	BXCOQNTY21	Quantity 21	Numeric	Generic Edit	15	6	Allow NULL?
65	BXCOQNTY22	Quantity 22	Numeric	Generic Edit	15	6	Allow NULL?
66	BXCOQNTY23	Quantity 23	Numeric	Generic Edit	15	6	Allow NULL?
67	BXCOQNTY24	Quantity 24	Numeric	Generic Edit	15	6	Allow NULL?
68	BXCOQNTY25	Quantity 25	Numeric	Generic Edit	15	6	Allow NULL?
69	BXCOQNTY26	Quantity 26	Numeric	Generic Edit	15	6	Allow NULL?
70	BXCOQNTY27	Quantity 27	Numeric	Generic Edit	15	6	Allow NULL?
71	BXCOQNTY28	Quantity 28	Numeric	Generic Edit	15	6	Allow NULL?
72	BXCOQNTY29	Quantity 29	Numeric	Generic Edit	15	6	Allow NULL?
73	BXCOQNTY30	Quantity 30	Numeric	Generic Edit	15	6	Allow NULL?

TOP 920 | 41F | FCW50 INDEXES

Number

Description

Primary (Primary/Unique)

Element	Alias	Description	Sequence
1	KIT	Parent (short) Item Number	Ascending
2	MMCU	Branch	Ascending
3	TBM	Type Bill of Material	Ascending
4	BQTY	Units - Batch Quantity	Ascending
5	ITM	Item Number - Short	Ascending
6	CPNB	Component Line Number BOM	Ascending
7	SBNT	Substitute Item Sequence Number	Ascending
8	COBY	Co-Products/By-Products/Intermediate	Ascending
9	C9LVC0	Component Level 0	Ascending

KIT to ITM

Element	Alias	Description	Sequence
1	KIT	Parent (short) Item Number	Ascending
2	MMCU	Branch	Ascending
3	TBM	Type Bill of Material	Ascending
4	BQTY	Units - Batch Quantity	Ascending
5	ITM	Item Number - Short	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

73 COLUMNS | 2 INDEXES | 920 | 41F | FCW50 TABLE

TOP 920 | 41F | FCW50 COLUMNS

TOP 920 | 41F | FCW50 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

73 COLUMNS | 2 INDEXES | 920 | 41F | FCW50 TABLE

TOP920 | 41F | FCW50 COLUMNS

TOP920 | 41F | FCW50 INDEXES

TOP 920 | 41F | FCW50 COLUMNS

TOP 920 | 41F | FCW50 INDEXES