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
48: Work Order Processing
1	920	F48710	WT	120	2	Work Order Mass Update Template Table	Files	48: Work Order Processing

Column	Field	Description	Data Type	Edit Type	Length	SQL Create Statement
1	WTUKID	Unique Key ID (Internal)	Numeric	Generic Edit	15	Allow NULL?
2	WTTMPNA	Template Name	String	Generic Edit	20	Allow NULL?
3	WTTMPDSC	Template Description	String	Generic Edit	60	Allow NULL?
4	WTHIDEPLN	Hide Planning Tab	Character	Generic Edit	1	Allow NULL?
5	WTHIDEORD	Hide Order Detail Tab	Character	Generic Edit	1	Allow NULL?
6	WTHIDECAT	Hide Category Codes Tab	Character	Generic Edit	1	Allow NULL?
7	WTHIDECLS	Hide Classification Tab	Character	Generic Edit	1	Allow NULL?
8	WTHIDEACC	Hide Accounting Tab	Character	Generic Edit	1	Allow NULL?
9	WTSRST	Status Code W.O.	String	UDC (00 SS)	2	Allow NULL?
10	WTDISST	Lock Status	Character	Generic Edit	1	Allow NULL?
11	WTSTCM	Status - Comment	String	Generic Edit	30	Allow NULL?
12	WTDISSTCOM	Lock Status Comment	Character	Generic Edit	1	Allow NULL?
13	WTPC	Percent Complete	Numeric	Generic Edit	5	Allow NULL?
14	WTDISPC	Lock Percent Complete	Character	Generic Edit	1	Allow NULL?
15	WTDPL	Date - W.O. Planned Completed	Date	Generic Edit	6
16	WTDISRFD	Lock Requested Finish Date	Character	Generic Edit	1	Allow NULL?
17	WTSTRT	Date - Start (Julian)	Date	Generic Edit	6
18	WTDISPSD	Lock Planned Start Date	Character	Generic Edit	1	Allow NULL?
19	WTDRQJ	Date - Requested	Date	Generic Edit	6
20	WTDISPFD	Lock Planned Finish Date	Character	Generic Edit	1	Allow NULL?
21	WTSTRX	Date - Completion (Julian)	Date	Generic Edit	6
22	WTDISAFD	Lock Actual Finish Date	Character	Generic Edit	1	Allow NULL?
23	WTANSA	Address Number - Manager	Numeric	Generic Edit	8	Allow NULL?
24	WTDISMGR	Lock Manager	Character	Generic Edit	1	Allow NULL?
25	WTMCULT	Lead Craft	String	Generic Edit	12	Allow NULL?
26	WTDISLC	Lock Lead Craft	Character	Generic Edit	1	Allow NULL?
27	WTANP	Address Number - Assigned To	Numeric	Generic Edit	8	Allow NULL?
28	WTDISATO	Lock Assigned To	Character	Generic Edit	1	Allow NULL?
29	WTANT	Address Number - Inspector	Numeric	Generic Edit	8	Allow NULL?
30	WTDISINS	Lock Inspector	Character	Generic Edit	1	Allow NULL?
31	WTANO	Address Number - Originator	Numeric	Generic Edit	8	Allow NULL?
32	WTDISORG	Lock Originator	Character	Generic Edit	1	Allow NULL?
33	WTANPA	Supervisor	Numeric	Generic Edit	8	Allow NULL?
34	WTDISSUP	Lock Supervisor	Character	Generic Edit	1	Allow NULL?
35	WTDCTO	Order Type	String	UDC (00 DT)	2	Allow NULL?
36	WTDISOTY	Lock Order Type	Character	Generic Edit	1	Allow NULL?
37	WTTYPS	Type - W.O.	Character	UDC (00 TY)	1	Allow NULL?
38	WTDISWOTY	Lock Work Order Type	Character	Generic Edit	1	Allow NULL?
39	WTAN8	Address Number	Numeric	Generic Edit	8	Allow NULL?
40	WTDISCUS	Lock Customer Number	Character	Generic Edit	1	Allow NULL?
41	WTSAID	Service Address Number	Numeric	Generic Edit	8	Allow NULL?
42	WTDISSNO	Lock Site Number	Character	Generic Edit	1	Allow NULL?
43	WTDL01	Description	String	Generic Edit	30	Allow NULL?
44	WTDISDL01	Lock WO Description	Character	Generic Edit	1	Allow NULL?
45	WTWR01	Categories - Work Order 01	String	UDC (00 W1)	4	Allow NULL?
46	WTDISCC1	Lock Category Code 1	Character	Generic Edit	1	Allow NULL?
47	WTWR02	Categories - Work Order 02	String	UDC (00 W2)	3	Allow NULL?
48	WTDISCC2	Lock Category Code 2	Character	Generic Edit	1	Allow NULL?
49	WTWR03	Categories - Work Order 03	String	UDC (00 W3)	3	Allow NULL?
50	WTDISCC3	Lock Category Code 3	Character	Generic Edit	1	Allow NULL?
51	WTWR04	Categories - Work Order 04	String	UDC (00 W4)	3	Allow NULL?
52	WTDISCC4	Lock Category Code 4	Character	Generic Edit	1	Allow NULL?
53	WTWR05	Categories - Work Order 05	String	UDC (00 W5)	3	Allow NULL?
54	WTDISCC5	Lock Category Code 5	Character	Generic Edit	1	Allow NULL?
55	WTWR06	EnterpriseOne Consulting - Status	String	UDC (00 W6)	3	Allow NULL?
56	WTDISCC6	Lock Category Code 6	Character	Generic Edit	1	Allow NULL?
57	WTWR07	EnterpriseOne Consulting - Service Type	String	UDC (00 W7)	3	Allow NULL?
58	WTDISCC7	Lock Category Code 7	Character	Generic Edit	1	Allow NULL?
59	WTWR08	EnterpriseOne Consulting - Skill Type	String	UDC (00 W8)	3	Allow NULL?
60	WTDISCC8	Lock Category Code 8	Character	Generic Edit	1	Allow NULL?
61	WTWR09	E1 Consulting - Experience Level	String	UDC (00 W9)	3	Allow NULL?
62	WTDISCC9	Lock Category Code 9	Character	Generic Edit	1	Allow NULL?
63	WTWR10	Categories - Work Order 10	String	UDC (00 W0)	3	Allow NULL?
64	WTDISCC10	Lock Category Code 10	Character	Generic Edit	1	Allow NULL?
65	WTWR11	Categories - Work Order 11	String	UDC (00 X1)	3	Allow NULL?
66	WTDISCC11	Lock Category Code 11	Character	Generic Edit	1	Allow NULL?
67	WTWR12	Categories - Work Order 12	String	UDC (00 X2)	3	Allow NULL?
68	WTDISCC12	Lock Category Code 12	Character	Generic Edit	1	Allow NULL?
69	WTWR13	Categories - Work Order 13	String	UDC (00 X3)	3	Allow NULL?
70	WTDISCC13	Lock Category Code 13	Character	Generic Edit	1	Allow NULL?
71	WTWR14	Categories - Work Order 14	String	UDC (00 X4)	3	Allow NULL?
72	WTDISCC14	Lock Category Code 14	Character	Generic Edit	1	Allow NULL?
73	WTWR15	Categories - Work Order 15	String	UDC (00 X5)	3	Allow NULL?
74	WTDISCC15	Lock Category Code 15	Character	Generic Edit	1	Allow NULL?
75	WTWR16	Categories - Work Order 16	String	UDC (00 X6)	3	Allow NULL?
76	WTDISCC16	Lock Category Code 16	Character	Generic Edit	1	Allow NULL?
77	WTWR17	Categories - Work Order 17	String	UDC (00 X7)	3	Allow NULL?
78	WTDISCC17	Lock Category Code 17	Character	Generic Edit	1	Allow NULL?
79	WTWR18	Categories - Work Order 18	String	UDC (00 X8)	3	Allow NULL?
80	WTDISCC18	Lock Category Code 18	Character	Generic Edit	1	Allow NULL?
81	WTWR19	Categories - Work Order 19	String	UDC (00 X9)	3	Allow NULL?
82	WTDISCC19	Lock Category Code 19	Character	Generic Edit	1	Allow NULL?
83	WTWR20	Categories - Work Order 20	String	UDC (00 X0)	3	Allow NULL?
84	WTDISCC20	Lock Category Code 20	Character	Generic Edit	1	Allow NULL?
85	WTPRTS	Priority - W.O.	Character	UDC (00 PR)	1	Allow NULL?
86	WTDISPRI	Lock Priority	Character	Generic Edit	1	Allow NULL?
87	WTREGION	Geographic Region Code	String	UDC (17 GR)	3	Allow NULL?
88	WTDISGR	Lock Geographic Region	Character	Generic Edit	1	Allow NULL?
89	WTSPRT	Work Order Flash Message	Character	UDC (00 WM)	1	Allow NULL?
90	WTDISWOMSG	Lock WO Flash Message	Character	Generic Edit	1	Allow NULL?
91	WTPARS	Number - Parent WO Number	String	Generic Edit	8	Allow NULL?
92	WTDISPARWO	Lock Parent WO	Character	Generic Edit	1	Allow NULL?
93	WTSHNO	Message Number	String	Generic Edit	10	Allow NULL?
94	WTDISSHNO	Lock Message No	Character	Generic Edit	1	Allow NULL?
95	WTVR01	Reference	String	Generic Edit	25	Allow NULL?
96	WTDISVR01	Lock Reference	Character	Generic Edit	1	Allow NULL?
97	WTTBM	Type Bill of Material	String	UDC (40 TB)	3	Allow NULL?
98	WTDISTBM	Lock Type Bill of Material	Character	Generic Edit	1	Allow NULL?
99	WTTRT	Type of Routing	String	UDC (40 TR)	3	Allow NULL?
100	WTDISTRT	Lock Type of Routing	Character	Generic Edit	1	Allow NULL?
101	WTUNCD	Work Order Freeze Code	Character	UDC (H00 UN)	1	Allow NULL?
102	WTDISUNCD	Lock Freeze Code	Character	Generic Edit	1	Allow NULL?
103	WTMCU	Business Unit	String	Generic Edit	12	Allow NULL?
104	WTDISBU	Lock Business Unit	Character	Generic Edit	1	Allow NULL?
105	WTSUB	Subsidiary	String	Generic Edit	8	Allow NULL?
106	WTDISSUB	Lock Subsidiary	Character	Generic Edit	1	Allow NULL?
107	WTSBLI	Subledger Inactive Code	Character	UDC (00 SI)	1	Allow NULL?
108	WTDISSIC	Lock Subledger Inactive Code	Character	Generic Edit	1	Allow NULL?
109	WTGLCCV	Category - G/L Covered	String	UDC (41 9)	4	Allow NULL?
110	WTDISGLC	Lock Covered G/L Category	Character	Generic Edit	1	Allow NULL?
111	WTGLCNC	Category - G/L Non-Covered	String	UDC (41 9)	4	Allow NULL?
112	WTDISNCGLC	Lock Non-Covered G/L Category	Character	Generic Edit	1	Allow NULL?
113	WTMMCU	Branch	String	Generic Edit	12	Allow NULL?
114	WTDISBRA	Lock Branch	Character	Generic Edit	1	Allow NULL?
115	WTHIDEPEP	Hide People Tab	Character	Generic Edit	1	Allow NULL?
116	WTPID	Program ID	String	Generic Edit	10	Allow NULL?
117	WTUSER	User ID	String	Generic Edit	10	Allow NULL?
118	WTMKEY	Machine Key	String	Generic Edit	15	Allow NULL?
119	WTUPMJ	Date - Updated	Date	Generic Edit	6
120	WTUPMT	Time - Last Updated	Numeric	Generic Edit	6	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

120 COLUMNS | 2 INDEXES | 920 | 48 | F48710 TABLE

TOP 920 | 48 | F48710 COLUMNS

TOP 920 | 48 | F48710 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

120 COLUMNS | 2 INDEXES | 920 | 48 | F48710 TABLE

TOP920 | 48 | F48710 COLUMNS

TOP920 | 48 | F48710 INDEXES

TOP 920 | 48 | F48710 COLUMNS

TOP 920 | 48 | F48710 INDEXES