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
41F: Apparel Management
1	920	FCW10	WB	129	1	Item Branch Work File	Files	41F: Apparel Management

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	WBITM	Item Number - Short	Numeric	Generic Edit	8	0	Allow NULL?
2	WBMCU	Business Unit	String	Generic Edit	12	0	Allow NULL?
3	WBEV01	J.D. EnterpriseOne Event Point 01	Character	Generic Edit	1	0	Allow NULL?
4	WBSTKT	Stocking Type	Character	UDC (41 I)	1	0	Allow NULL?
5	WBGLPT	Category - G/L	String	UDC (41 9)	4	0	Allow NULL?
6	WBLNTY	Line Type	String	Generic Edit	2	0	Allow NULL?
7	WBANPL	Planner Number	Numeric	Generic Edit	8	0	Allow NULL?
8	WBBUYR	Buyer Number	Numeric	Generic Edit	8	0	Allow NULL?
9	WBVEND	Primary / Last Supplier Number	Numeric	Generic Edit	8	0	Allow NULL?
10	WBINMG	Print Message	String	UDC (40 PM)	10	0	Allow NULL?
11	WBCMGL	Commitment Method	Character	UDC (H40 CM)	1	0	Allow NULL?
12	WBORIG	Country of Origin	String	UDC (00 CN)	3	0	Allow NULL?
13	WBTAX1	Sales Taxable (Y/N)	Character	UDC (H00 TV)	1	0	Allow NULL?
14	WBTX	Purchasing Taxable (Y/N)	Character	UDC (H00 TV)	1	0	Allow NULL?
15	WBSRCE	Layer Code - Source	Character	UDC (H41 SR)	1	0	Allow NULL?
16	WBLOTS	Lot Status Code	Character	UDC (41 L)	1	0	Allow NULL?
17	WBSRNR	Serial Number Required	Character	UDC (H41 NR)	1	0	Allow NULL?
18	WBCKAV	Check Availability Y/N	Character	Generic Edit	1	0	Allow NULL?
19	WBBACK	Backorders Allowed (Y/N)	Character	Generic Edit	1	0	Allow NULL?
20	WBPRGR	Item Price Group	String	UDC (40 PI)	8	0	Allow NULL?
21	WBRPRC	Reprice (Basket Price) Category	String	UDC (40 PI)	8	0	Allow NULL?
22	WBORPR	Order Reprice Category	String	UDC (40 PI)	8	0	Allow NULL?
23	WBMMPC	Margin Maintenance (%)	Numeric	Generic Edit	7	3	Allow NULL?
24	WBSLD	Days - Shelf Life Days	Numeric	Generic Edit	6	0	Allow NULL?
25	WBABCS	ABC Code 1 - Sales - Inventory	Character	UDC (H41 AB)	1	0	Allow NULL?
26	WBABCM	ABC Code 1 - Margin - Inventory	Character	UDC (H41 AB)	1	0	Allow NULL?
27	WBABCI	ABC Code 3 - Investment - Inventory	Character	UDC (H41 AB)	1	0	Allow NULL?
28	WBSRP1	Sales Catalog Section	String	UDC (41 S1)	3	0	Allow NULL?
29	WBSRP2	Sub Section	String	UDC (41 S2)	3	0	Allow NULL?
30	WBSRP3	Sales Category Code 3	String	UDC (41 S3)	3	0	Allow NULL?
31	WBSRP4	Sales Category Code 4	String	UDC (41 S4)	3	0	Allow NULL?
32	WBSRP5	Sales Category Code 5	String	UDC (41 S5)	3	0	Allow NULL?
33	WBSRP6	Category Code 6	String	UDC (41 06)	6	0	Allow NULL?
34	WBSRP7	Category Code 7	String	UDC (41 07)	6	0	Allow NULL?
35	WBSRP8	Category Code 8	String	UDC (41 08)	6	0	Allow NULL?
36	WBSRP9	Category Code 9	String	UDC (41 09)	6	0	Allow NULL?
37	WBSRP0	Category Code 10	String	UDC (41 10)	6	0	Allow NULL?
38	WBCARS	Carrier Number	Numeric	Generic Edit	8	0	Allow NULL?
39	WBCARP	Preferred Carrier - Purchasing	Numeric	Generic Edit	8	0	Allow NULL?
40	WBSHCN	Shipping Conditions Code	String	UDC (41 C)	3	0	Allow NULL?
41	WBSHCM	Shipping Commodity Class	String	UDC (41 E)	3	0	Allow NULL?
42	WBCYCL	Cycle Count Category	String	UDC (41 8)	3	0	Allow NULL?
43	WBPRP1	Commodity Class	String	UDC (41 P1)	3	0	Allow NULL?
44	WBPRP2	Commodity Sub Class	String	UDC (41 P2)	3	0	Allow NULL?
45	WBPRP3	Supplier Rebate Code	String	UDC (41 P3)	3	0	Allow NULL?
46	WBPRP4	Master Planning Family	String	UDC (41 P4)	3	0	Allow NULL?
47	WBPRP5	Purchasing Category Code 5	String	UDC (41 P5)	3	0	Allow NULL?
48	WBPRP6	Group - Item Dimension	String	UDC (41 01)	6	0	Allow NULL?
49	WBPRP7	Group - Warehouse Process 1	String	UDC (41 02)	6	0	Allow NULL?
50	WBPRP8	Group - Warehouse Process 2	String	UDC (41 02)	6	0	Allow NULL?
51	WBPRP9	Group - Warehouse Process 3	String	UDC (41 02)	6	0	Allow NULL?
52	WBPRP0	Item Pool	String	UDC (41 05)	6	0	Allow NULL?
53	WBOPC	Order Policy Code	Character	UDC (H41 OP)	1	0	Allow NULL?
54	WBOPV	Value - Order Policy	Numeric	Generic Edit	15	0	Allow NULL?
55	WBMPST	Planning Code	Character	UDC (H41 MP)	1	0	Allow NULL?
56	WBMPSP	Planning Time Fence Rule	Character	UDC (34 TF)	1	0	Allow NULL?
57	WBMTF1	Planning Time Fence Days	Numeric	Generic Edit	5	0	Allow NULL?
58	WBMTF2	Freeze Time Fence Days	Numeric	Generic Edit	5	0	Allow NULL?
59	WBMTF3	Message Time Fence Days	Numeric	Generic Edit	5	0	Allow NULL?
60	WBSETL	Setup Labor - Standard	Numeric	Generic Edit	15	2	Allow NULL?
61	WBQUED	Queue Hours - Standard	Numeric	Generic Edit	5	2	Allow NULL?
62	WBECO	ECO Number	String	Generic Edit	12	0	Allow NULL?
63	WBECTY	Engineering Change Reason	String	UDC (40 CR)	2	0	Allow NULL?
64	WBECOD	Date - Engineering Change Date	Date	Generic Edit	6	0
65	WBPOC	Issue and Receipt	Character	UDC (43 IR)	1	0	Allow NULL?
66	WBAVRT	Replenishment Hours - Standard	Numeric	Generic Edit	15	2	Allow NULL?
67	WBACQ	Quantity - Accounting Cost	Numeric	Generic Edit	15	0	Allow NULL?
68	WBITC	Issue Type Code	Character	UDC (41 IT)	1	0	Allow NULL?
69	WBTIMB	Time Basis Code	Character	UDC (30 TB)	1	0	Allow NULL?
70	WBMERL	Item Revision Level	String	Generic Edit	3	0	Allow NULL?
71	WBSRNK	Shrink Factor	Numeric	Generic Edit	15	2	Allow NULL?
72	WBSRKF	Shrink Factor Method	Character	UDC (H40 SR)	1	0	Allow NULL?
73	WBLTLV	Leadtime Level	Numeric	Generic Edit	5	0	Allow NULL?
74	WBLTMF	Leadtime MFG	Numeric	Generic Edit	5	0	Allow NULL?
75	WBLTCM	Leadtime Cumulative	Numeric	Generic Edit	5	0	Allow NULL?
76	WBLTPU	Leadtime Per Unit	Numeric	Generic Edit	5	2	Allow NULL?
77	WBMRPP	Fixed or Variable Leadtime	Character	UDC (H41 MS)	1	0	Allow NULL?
78	WBFRMP	From Potency	Numeric	Generic Edit	7	3	Allow NULL?
79	WBMLQ	Quantity - MFG Leadtime	Numeric	Generic Edit	15	0	Allow NULL?
80	WBOT1Y	Potency Control	Character	Generic Edit	1	0	Allow NULL?
81	WBSTDP	Standard Potency	Numeric	Generic Edit	7	3	Allow NULL?
82	WBTHRP	Thru Potency	Numeric	Generic Edit	7	3	Allow NULL?
83	WBOT2Y	Grade Control	Character	Generic Edit	1	0	Allow NULL?
84	WBSTDG	Standard Grade	String	UDC (40 LG)	3	0	Allow NULL?
85	WBFRGD	From Grade	String	UDC (40 LG)	3	0	Allow NULL?
86	WBTHGD	Thru Grade	String	UDC (40 LG)	3	0	Allow NULL?
87	WBPRODM	Product Model	String	UDC (17 PM)	8	0	Allow NULL?
88	WBPRODF	Product Family	String	UDC (17 PA)	8	0	Allow NULL?
89	WBMCUZ	Business Unit - Alt	String	Generic Edit	12	0	Allow NULL?
90	WBCCOST	S/WM Cost Component	String	UDC (30 CA)	3	0	Allow NULL?
91	WBRTRND	Returnable Flag	Character	UDC (17 TF)	1	0	Allow NULL?
92	WBRPRBL	Repairable Flag	Character	UDC (17 TF)	1	0	Allow NULL?
93	WBDCD1	Disposition Code 1	String	UDC (17 P1)	3	0	Allow NULL?
94	WBDCD2	Disposition Code 2	String	UDC (17 P2)	3	0	Allow NULL?
95	WBDCD3	Disposition Code 3	String	UDC (17 P3)	3	0	Allow NULL?
96	WBDCD4	Disposition Code 4	String	UDC (17 P4)	3	0	Allow NULL?
97	WBDCD5	Disposition Code 5	String	UDC (17 P5)	3	0	Allow NULL?
98	WBROQI	Reorder Quantity - Input	Numeric	Generic Edit	15	0	Allow NULL?
99	WBRQMX	Reorder Quantity - Maximum	Numeric	Generic Edit	15	0	Allow NULL?
100	WBRQMN	Reorder Quantity - Minimum	Numeric	Generic Edit	15	0	Allow NULL?
101	WBROPI	Reorder Point - Input	Numeric	Generic Edit	15	0	Allow NULL?
102	WBMULT	Quantity - Order Multiples (MRP)	Numeric	Generic Edit	15	0	Allow NULL?
103	WBUPC	Units - Per Container	Numeric	Generic Edit	15	0	Allow NULL?
104	WBSAFE	Safety Stock	Numeric	Generic Edit	15	0	Allow NULL?
105	WBAING	Active Ingredient Flag	Character	Generic Edit	1	0	Allow NULL?
106	WBBBDD	Best Before Default Days	Numeric	Generic Edit	6	0	Allow NULL?
107	WBCMDM	Commitment Date Method	Character	UDC (H40 CD)	1	0	Allow NULL?
108	WBLECM	Lot Expiraton Date Calculation Method	Character	UDC (H41 EC)	1	0	Allow NULL?
109	WBLEDD	Lot Effective Default Days	Numeric	Generic Edit	6	0	Allow NULL?
110	WBMLOT	Mix Dates / Lots (Y/N)	Character	Generic Edit	1	0	Allow NULL?
111	WBPEFD	Purchasing Effective Days	Numeric	Generic Edit	6	0	Allow NULL?
112	WBSBDD	Sell By Default Days	Numeric	Generic Edit	6	0	Allow NULL?
113	WBU1DD	User Lot Date 1 Default Days	Numeric	Generic Edit	6	0	Allow NULL?
114	WBU2DD	User Lot Date 2 Default Days	Numeric	Generic Edit	6	0	Allow NULL?
115	WBU3DD	User Lot Date 3 Default Days	Numeric	Generic Edit	6	0	Allow NULL?
116	WBU4DD	User Lot Date 4 Default Days	Numeric	Generic Edit	6	0	Allow NULL?
117	WBU5DD	User Lot Date 5 Default Days	Numeric	Generic Edit	6	0	Allow NULL?
118	WBXDCK	Cross-Docking Flag	Character	Generic Edit	1	0	Allow NULL?
119	WBLAF	Lot Audit Flag	Character	Generic Edit	1	0	Allow NULL?
120	WBLTFM	Special Lot Format	Character	Generic Edit	1	0	Allow NULL?
121	WBRWLA	Restrict Work Order Lot Assignment	Character	Generic Edit	1	0	Allow NULL?
122	WBLNPA	Lot Number Pre-Assignment	Character	Generic Edit	1	0	Allow NULL?
123	WBLOTC	Lot Status Code Expanded	String	Generic Edit	3	0	Allow NULL?
124	WBAPSC	Constraints Flag	Character	UDC (42 AC)	1	0	Allow NULL?
125	WBPRI1	Priority One Alert Level	Numeric	Generic Edit	15	4	Allow NULL?
126	WBPRI2	Priority Two Alert Level	Numeric	Generic Edit	15	4	Allow NULL?
127	WBLTCV	Leadtime Conversion Factor	Numeric	Generic Edit	15	7	Allow NULL?
128	WBASHL	Allow Shipping of Held Lots	Character	Generic Edit	1	0	Allow NULL?
129	WBCOORE	Country of Origin Required Flag	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

129 COLUMNS | 1 INDEXES | 920 | 41F | FCW10 TABLE

TOP 920 | 41F | FCW10 COLUMNS

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

129 COLUMNS | 1 INDEXES | 920 | 41F | FCW10 TABLE

TOP920 | 41F | FCW10 COLUMNS

TOP920 | 41F | FCW10 INDEXES

TOP 920 | 41F | FCW10 COLUMNS

TOP 920 | 41F | FCW10 INDEXES