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
31: Shop Floor Control
1	812	F3111S	WM	87	1	Purge - Shop Floor Parts List	Purge Files	31: Shop Floor Control	AS400 Coexistence Tables

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	WMDOCO	Document (Order No Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
2	WMDCTO	Order Type	String	UDC (00 DT)	2	0	Allow NULL?
3	WMSFXO	Order Suffix	String	Generic Edit	3	0	Allow NULL?
4	WMTBM	Type Bill of Material	String	UDC (40 TB)	3	0	Allow NULL?
5	WMFORQ	Fixed or Variable Quantity	Character	UDC (H40 FO)	1	0	Allow NULL?
6	WMITC	Issue Type Code	Character	UDC (41 IT)	1	0	Allow NULL?
7	WMCOBY	Co-Products/By-Products/Intermediate	Character	UDC (H40 CO)	1	0	Allow NULL?
8	WMCOTY	Component Type	Character	UDC (H40 CP)	1	0	Allow NULL?
9	WMCPNT	Component Line Number	Numeric	Generic Edit	4	1	Allow NULL?
10	WMFRMP	From Potency	Numeric	Generic Edit	7	3	Allow NULL?
11	WMTHRP	Thru Potency	Numeric	Generic Edit	7	3	Allow NULL?
12	WMFRGD	From Grade	String	UDC (40 LG)	3	0	Allow NULL?
13	WMTHGD	Thru Grade	String	UDC (40 LG)	3	0	Allow NULL?
14	WMRKCO	Company - Key (Related Order)	String	Generic Edit	5	0	Allow NULL?
15	WMRORN	Related PO/SO/WO Number	String	Generic Edit	8	0	Allow NULL?
16	WMRCTO	Related PO/SO/WO Order Type	String	UDC (00 DT)	2	0	Allow NULL?
17	WMRLLN	Related PO/SO Line Number	Numeric	Generic Edit	7	3	Allow NULL?
18	WMOPSQ	Sequence Number - Operations	Numeric	Generic Edit	5	2	Allow NULL?
19	WMBSEQ	Sorszám - Buborék sorszám	Numeric	Generic Edit	5	0	Allow NULL?
20	WMRSCP	Resource Percent	Numeric	Generic Edit	5	2	Allow NULL?
21	WMSCRP	Percent - Percent of Scrap	Numeric	Generic Edit	5	2	Allow NULL?
22	WMREWP	Percent - Rework	Numeric	Generic Edit	5	2	Allow NULL?
23	WMASIP	Percent - As is	Numeric	Generic Edit	5	2	Allow NULL?
24	WMCPYP	Percent - Cumulative Planned Yield	Numeric	Generic Edit	5	2	Allow NULL?
25	WMSTPP	Operation Scrap Percent	Numeric	Generic Edit	5	2	Allow NULL?
26	WMLOVD	Leadtime Offset Days	Numeric	Generic Edit	6	0	Allow NULL?
27	WMCPIT	Component Item Number - Short	Numeric	Generic Edit	8	0	Allow NULL?
28	WMCPIL	Component 2nd Item Number	String	Generic Edit	25	0	Allow NULL?
29	WMCPIA	Component 3rd Item Number	String	Generic Edit	25	0	Allow NULL?
30	WMCMCU	Component Branch	String	Generic Edit	12	0	Allow NULL?
31	WMDSC1	Description	String	Generic Edit	30	0	Allow NULL?
32	WMDSC2	Description - Line 2	String	Generic Edit	30	0	Allow NULL?
33	WMLOCN	Location	String	Generic Edit	20	0	Allow NULL?
34	WMLOTN	Lot/Serial Number	String	Generic Edit	30	0	Allow NULL?
35	WMAN8	Address Number	Numeric	UDC	8	0	Allow NULL?
36	WMLNTY	Line Type	String	Generic Edit	2	0	Allow NULL?
37	WMSERN	Serial Number - Lot	String	Generic Edit	30	0	Allow NULL?
38	WMTRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
39	WMDRQJ	Date - Requested	Date	Generic Edit	6	0
40	WMUORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2	Allow NULL?
41	WMTRQT	Quantity Available	Numeric	Generic Edit	15	2	Allow NULL?
42	WMSOCN	Units - Quantity Canceled/Scrapped	Numeric	Generic Edit	15	2	Allow NULL?
43	WMSOBK	Units - Qty Backordered/Held	Numeric	Generic Edit	15	2	Allow NULL?
44	WMCTS1	Hours - Unaccounted Direct Labor	Numeric	Generic Edit	15	2	Allow NULL?
45	WMQNTA	Units - Quantity Commited	Numeric	Generic Edit	15	2	Allow NULL?
46	WMUM	Unit of Measure	String	UDC (00 UM)	2	0	Allow NULL?
47	WMEA	Amount - Estimated Cost	Numeric	Generic Edit	15	2	Allow NULL?
48	WMRTG	Route Sheet (N)	Character	Generic Edit	1	0	Allow NULL?
49	WMMTST	Material Status Code W.O.	String	UDC (31 MS)	2	0	Allow NULL?
50	WMDCT	Document Type	String	UDC (00 DT)	2	0	Allow NULL?
51	WMSHNO	Message Number	String	Generic Edit	10	0	Allow NULL?
52	WMMCU	Business Unit	String	Generic Edit	12	0	Allow NULL?
53	WMOMCU	Project Business Unit	String	Generic Edit	12	0	Allow NULL?
54	WMOBJ	Object Account	String	Generic Edit	6	0	Allow NULL?
55	WMSUB	Subsidiary	String	Generic Edit	8	0	Allow NULL?
56	WMCMRV	Component Revision Level	String	Generic Edit	3	0	Allow NULL?
57	WMSTRX	Date - Completion (Julian)	Date	Generic Edit	6	0
58	WMPARS	Number - Parent WO Number	String	Generic Edit	8	0	Allow NULL?
59	WMCOMM	Committed (H/S)	Character	UDC (H42 CP)	1	0	Allow NULL?
60	WMURCD	User Reserved Code	String	Generic Edit	2	0	Allow NULL?
61	WMURDT	User Reserved Date	Date	Generic Edit	6	0
62	WMURAT	User Reserved Amount	Numeric	Generic Edit	15	2	Allow NULL?
63	WMURRF	User Reserved Reference	String	Generic Edit	15	0	Allow NULL?
64	WMURAB	User Reserved Number	Numeric	Generic Edit	8	0	Allow NULL?
65	WMUSER	User ID	String	Generic Edit	10	0	Allow NULL?
66	WMPID	Program ID	String	Generic Edit	10	0	Allow NULL?
67	WMJOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
68	WMUPMJ	Date - Updated	Date	Generic Edit	6	0
69	WMTDAY	Time of Day	Numeric	Generic Edit	6	0	Allow NULL?
70	WMUKID	Unique Key ID (Internal)	Numeric	Generic Edit	15	0	Allow NULL?
71	WMVEND	Primary / Last Supplier Number	Numeric	Generic Edit	8	0	Allow NULL?
72	WMPOC	Issue and Receipt	Character	UDC (43 IR)	1	0	Allow NULL?
73	WMCTS4	Amount - Unaccounted Direct Labor	Numeric	Generic Edit	15	2	Allow NULL?
74	WMCTS7	Amount - Unaccounted Scrap	Numeric	Generic Edit	15	2	Allow NULL?
75	WMCTS8	Units - Unaccounted Scrap	Numeric	Generic Edit	15	2	Allow NULL?
76	WMGLD	G/L Date	Date	Generic Edit	6	0
77	WMSBFL	Parts List Substitute Flag	Character	Generic Edit	1	0	Allow NULL?
78	WMAING	Active Ingredient Flag	Character	Generic Edit	1	0	Allow NULL?
79	WMSSTQ	Secondary Quantity Issued/Completed	Numeric	Generic Edit	15	0	Allow NULL?
80	WMUOM2	Unit of Measure - Secondary	String	UDC (00 UM)	2	0	Allow NULL?
81	WMAPSC	Constraints Flag	Character	UDC (42 AC)	1	0	Allow NULL?
82	WMPSN	Pick Slip Number	Numeric	Generic Edit	8	0	Allow NULL?
83	WMDLEJ	Lot Effectivity Date	Date	Generic Edit	6	0
84	WMCOST	Cost Component	String	UDC (30 CA)	3	0	Allow NULL?
85	WMCHPP	Critical Hold Propagation	Character	Generic Edit	1	0	Allow NULL?
86	WMCPNB	Component Line Number BOM	Numeric	Generic Edit	8	2	Allow NULL?
87	WMBSEQAN	Bubble Sequence Alpha Numeric	String	Generic Edit	5	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

87 COLUMNS | 1 INDEXES | 812 | 31 | F3111S TABLE

TOP 812 | 31 | F3111S COLUMNS

TOP 812 | 31 | F3111S 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

87 COLUMNS | 1 INDEXES | 812 | 31 | F3111S TABLE

TOP812 | 31 | F3111S COLUMNS

TOP812 | 31 | F3111S INDEXES

TOP 812 | 31 | F3111S COLUMNS

TOP 812 | 31 | F3111S INDEXES