	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

175 COLUMNS | 3 INDEXES | 920 | 51X | F51X10 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
51X: In-Memory Project Management
1	920	F51X10	EX	175	3	Project Advisor Console Worktable	Work Files	51X: In-Memory Project 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 EXUSER, EXJOBS, EX51XRTY, EX51XTC, EX51XTCD, EXMCU, EX51XCT1, EX51XCT2, EX51XSEQ, EX51XSQT, EXCO, EXMCUS, EXDL01, EXAID, EXCRCD, EX51XZBA, EX51XHA, EX51XC01, EX51XC02, EX51XC03, EX51XC04, EX51XC05, EX51XC06, EX51XC07, EX51XC08, EX51XC09, EX51XC10, EX51XC11, EX51XC12, EX51XC13, EX51XC14, EX51XC15, EX51XC16, EX51XC17, EX51XC18, EX51XC19, EX51XC20, EX51XC21, EX51XC22, EX51XC23, EX51XC24, EX51XC25, EX51XC26, EX51XC27, EX51XC28, EX51XC29, EX51XC30, EX51XC31, EX51XC32, EX51XC33, EX51XC34, EX51XC35, EX51XC36, EX51XC37, EX51XC38, EX51XC39, EX51XC40, EXSTYL, EXPECC, EXDOCO, EXPCTN, EXCLNU, EXADDS, EXAN8O, EXAN8GCA1, EXAN8GCA2, EXAN8GCA3, EXAN8GCA4, EXAN8GCA5, EXANPA, EXCT, EXD1J, EXD2J, EXD3J, EXD4J, EXD5J, EXD6J, EXRP01, EXRP02, EXRP03, EXRP04, EXRP05, EXRP06, EXRP07, EXRP08, EXRP09, EXRP10, EXRP11, EXRP12, EXRP13, EXRP14, EXRP15, EXRP16, EXRP17, EXRP18, EXRP19, EXRP20, EXRP21, EXRP22, EXRP23, EXRP24, EXRP25, EXRP26, EXRP27, EXRP28, EXRP29, EXRP30, EXRP31, EXRP32, EXRP33, EXRP34, EXRP35, EXRP36, EXRP37, EXRP38, EXRP39, EXRP40, EXRP41, EXRP42, EXRP43, EXRP44, EXRP45, EXRP46, EXRP47, EXRP48, EXRP49, EXRP50, EX51XACD, EXLDA, EXPEC, EXUM, EXSUBA, EXR001, EXR002, EXR003, EXR004, EXR005, EXR006, EXR007, EXR008, EXR009, EXR010, EXR011, EXR012, EXR013, EXR014, EXR015, EXR016, EXR017, EXR018, EXR019, EXR020, EXR021, EXR022, EXR023, EXR024, EXR025, EXR026, EXR027, EXR028, EXR029, EXR030, EXR031, EXR032, EXR033, EXR034, EXR035, EXR036, EXR037, EXR038, EXR039, EXR040, EXR041, EXR042, EXR043 FROM F51X10

TOP 920 | 51X | F51X10 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	SQL Create Statement
1	EXUSER	User ID	String	Generic Edit	10	Allow NULL?
2	EXJOBS	Job Number	Numeric	Generic Edit	8	Allow NULL?
3	EX51XRTY	PAC Record Type	Character	Generic Edit	1	Allow NULL?
4	EX51XTC	PAC Total Code	String	Generic Edit	12	Allow NULL?
5	EX51XTCD	PAC Total Code Description	String	Generic Edit	30	Allow NULL?
6	EXMCU	Business Unit	String	Generic Edit	12	Allow NULL?
7	EX51XCT1	Cost Code OR Cost Type 1	String	Generic Edit	8	Allow NULL?
8	EX51XCT2	Cost Code OR Cost Type 2	String	Generic Edit	8	Allow NULL?
9	EX51XSEQ	PAC Sequence	Numeric	Generic Edit	15	Allow NULL?
10	EX51XSQT	PAC Sequence Type	Character	Generic Edit	1	Allow NULL?
11	EXCO	Company	String	Generic Edit	5	Allow NULL?
12	EXMCUS	Business Unit - Subsequent	String	Generic Edit	12	Allow NULL?
13	EXDL01	Description	String	Generic Edit	30	Allow NULL?
14	EXAID	Account ID	String	Generic Edit	8	Allow NULL?
15	EXCRCD	Currency Code - From	String	Generic Edit	3	Allow NULL?
16	EX51XZBA	Zero Balance Account Flag	Character	Generic Edit	1	Allow NULL?
17	EX51XHA	Header Account Flag	Character	Generic Edit	1	Allow NULL?
18	EX51XC01	PMC Amount Column 01	Numeric	Generic Edit	15	Allow NULL?
19	EX51XC02	PMC Amount Column 02	Numeric	Generic Edit	15	Allow NULL?
20	EX51XC03	PMC Amount Column 03	Numeric	Generic Edit	15	Allow NULL?
21	EX51XC04	PMC Amount Column 04	Numeric	Generic Edit	15	Allow NULL?
22	EX51XC05	PMC Amount Column 05	Numeric	Generic Edit	15	Allow NULL?
23	EX51XC06	PMC Amount Column 06	Numeric	Generic Edit	15	Allow NULL?
24	EX51XC07	PMC Amount Column 07	Numeric	Generic Edit	15	Allow NULL?
25	EX51XC08	PMC Amount Column 08	Numeric	Generic Edit	15	Allow NULL?
26	EX51XC09	PMC Amount Column 09	Numeric	Generic Edit	15	Allow NULL?
27	EX51XC10	PMC Amount Column 10	Numeric	Generic Edit	15	Allow NULL?
28	EX51XC11	PMC Amount Column 11	Numeric	Generic Edit	15	Allow NULL?
29	EX51XC12	PMC Amount Column 12	Numeric	Generic Edit	15	Allow NULL?
30	EX51XC13	PMC Amount Column 13	Numeric	Generic Edit	15	Allow NULL?
31	EX51XC14	PMC Amount Column 14	Numeric	Generic Edit	15	Allow NULL?
32	EX51XC15	PMC Amount Column 15	Numeric	Generic Edit	15	Allow NULL?
33	EX51XC16	PMC Amount Column 16	Numeric	Generic Edit	15	Allow NULL?
34	EX51XC17	PMC Amount Column 17	Numeric	Generic Edit	15	Allow NULL?
35	EX51XC18	PMC Amount Column 18	Numeric	Generic Edit	15	Allow NULL?
36	EX51XC19	PMC Amount Column 19	Numeric	Generic Edit	15	Allow NULL?
37	EX51XC20	PMC Amount Column 20	Numeric	Generic Edit	15	Allow NULL?
38	EX51XC21	PMC Amount Column 21	Numeric	Generic Edit	15	Allow NULL?
39	EX51XC22	PMC Amount Column 22	Numeric	Generic Edit	15	Allow NULL?
40	EX51XC23	PMC Amount Column 23	Numeric	Generic Edit	15	Allow NULL?
41	EX51XC24	PMC Amount Column 24	Numeric	Generic Edit	15	Allow NULL?
42	EX51XC25	PMC Amount Column 25	Numeric	Generic Edit	15	Allow NULL?
43	EX51XC26	PMC Amount Column 26	Numeric	Generic Edit	15	Allow NULL?
44	EX51XC27	PMC Amount Column 27	Numeric	Generic Edit	15	Allow NULL?
45	EX51XC28	PMC Amount Column 28	Numeric	Generic Edit	15	Allow NULL?
46	EX51XC29	PMC Amount Column 29	Numeric	Generic Edit	15	Allow NULL?
47	EX51XC30	PMC Amount Column 30	Numeric	Generic Edit	15	Allow NULL?
48	EX51XC31	PMC Amount Column 31	Numeric	Generic Edit	15	Allow NULL?
49	EX51XC32	PMC Amount Column 32	Numeric	Generic Edit	15	Allow NULL?
50	EX51XC33	PMC Amount Column 33	Numeric	Generic Edit	15	Allow NULL?
51	EX51XC34	PMC Amount Column 34	Numeric	Generic Edit	15	Allow NULL?
52	EX51XC35	PMC Amount Column 35	Numeric	Generic Edit	15	Allow NULL?
53	EX51XC36	PMC Amount Column 36	Numeric	Generic Edit	15	Allow NULL?
54	EX51XC37	PMC Amount Column 37	Numeric	Generic Edit	15	Allow NULL?
55	EX51XC38	PMC Amount Column 38	Numeric	Generic Edit	15	Allow NULL?
56	EX51XC39	PMC Amount Column 39	Numeric	Generic Edit	15	Allow NULL?
57	EX51XC40	PMC Amount Column 40	Numeric	Generic Edit	15	Allow NULL?
58	EXSTYL	Business Unit Type	String	UDC (00 MC)	2	Allow NULL?
59	EXPECC	Posting Edit - Business Unit	Character	UDC (00 PF)	1	Allow NULL?
60	EXDOCO	Document (Order No Invoice etc.)	Numeric	Generic Edit	8	Allow NULL?
61	EXPCTN	Parent Contract Number	Numeric	Generic Edit	8	Allow NULL?
62	EXCLNU	Contract Level Number	Numeric	Generic Edit	8	Allow NULL?
63	EXADDS	State	String	UDC (00 S)	3	Allow NULL?
64	EXAN8O	Address Number - Job A/R	Numeric	Generic Edit	8	Allow NULL?
65	EXAN8GCA1	Address Number1	Numeric	Generic Edit	8	Allow NULL?
66	EXAN8GCA2	Address Number2	Numeric	Generic Edit	8	Allow NULL?
67	EXAN8GCA3	Address Number3	Numeric	Generic Edit	8	Allow NULL?
68	EXAN8GCA4	Address Number4	Numeric	Generic Edit	8	Allow NULL?
69	EXAN8GCA5	Address Number5	Numeric	Generic Edit	8	Allow NULL?
70	EXANPA	Supervisor	Numeric	Generic Edit	8	Allow NULL?
71	EXCT	Contract Type	String	UDC (51 CT)	4	Allow NULL?
72	EXD1J	Date - Planned Start	Date	Generic Edit	6
73	EXD2J	Date - Actual Start	Date	Generic Edit	6
74	EXD3J	Date - Planned Complete	Date	Generic Edit	6
75	EXD4J	Date - Actual Complete	Date	Generic Edit	6
76	EXD5J	Date - Other 5	Date	Generic Edit	6
77	EXD6J	Date - Other 6	Date	Generic Edit	6
78	EXRP01	Division	String	UDC (00 01)	3	Allow NULL?
79	EXRP02	Region	String	UDC (00 02)	3	Allow NULL?
80	EXRP03	Group	String	UDC (00 03)	3	Allow NULL?
81	EXRP04	Branch Office	String	UDC (00 04)	3	Allow NULL?
82	EXRP05	Department Type	String	UDC (00 05)	3	Allow NULL?
83	EXRP06	Person Responsible	String	UDC (00 06)	3	Allow NULL?
84	EXRP07	Line of Business	String	UDC (00 07)	3	Allow NULL?
85	EXRP08	Category Code - Business Unit 08	String	UDC (00 08)	3	Allow NULL?
86	EXRP09	Category Code - Business Unit 09	String	UDC (00 09)	3	Allow NULL?
87	EXRP10	Category Code - Business Unit 10	String	UDC (00 10)	3	Allow NULL?
88	EXRP11	Category Code - Business Unit 11	String	UDC (00 11)	3	Allow NULL?
89	EXRP12	Category Code - Business Unit 12	String	UDC (00 12)	3	Allow NULL?
90	EXRP13	Category Code - Business Unit 13	String	UDC (00 13)	3	Allow NULL?
91	EXRP14	Category Code - Business Unit 14	String	UDC (00 14)	3	Allow NULL?
92	EXRP15	Category Code - Business Unit 15	String	UDC (00 15)	3	Allow NULL?
93	EXRP16	Category Code - Business Unit 16	String	UDC (00 16)	3	Allow NULL?
94	EXRP17	Category Code - Business Unit 17	String	UDC (00 17)	3	Allow NULL?
95	EXRP18	Category Code - Business Unit 18	String	UDC (00 18)	3	Allow NULL?
96	EXRP19	Category Code - Business Unit 19	String	UDC (00 19)	3	Allow NULL?
97	EXRP20	Category Code - Business Unit 20	String	UDC (00 20)	3	Allow NULL?
98	EXRP21	Category Code - Business Unit 21	String	UDC (00 21)	10	Allow NULL?
99	EXRP22	Category Code - Business Unit 22	String	UDC (00 22)	10	Allow NULL?
100	EXRP23	Category Code - Business Unit 23	String	UDC (00 23)	10	Allow NULL?
101	EXRP24	Category Code - Business Unit 24	String	UDC (00 24)	10	Allow NULL?
102	EXRP25	Category Code - Business Unit 25	String	UDC (00 25)	10	Allow NULL?
103	EXRP26	Category Code - Business Unit 26	String	UDC (00 26)	10	Allow NULL?
104	EXRP27	Category Code - Business Unit 27	String	UDC (00 27)	10	Allow NULL?
105	EXRP28	Category Code - Business Unit 28	String	UDC (00 28)	10	Allow NULL?
106	EXRP29	Category Code - Business Unit 29	String	UDC (00 29)	10	Allow NULL?
107	EXRP30	Category Code - Business Unit 30	String	UDC (00 30)	10	Allow NULL?
108	EXRP31	Category Code - Business Unit 31	String	UDC (00 31)	10	Allow NULL?
109	EXRP32	Category Code - Business Unit 32	String	UDC (00 32)	10	Allow NULL?
110	EXRP33	Category Code - Business Unit 33	String	UDC (00 33)	10	Allow NULL?
111	EXRP34	Category Code - Business Unit 34	String	UDC (00 34)	10	Allow NULL?
112	EXRP35	Category Code - Business Unit 35	String	UDC (00 35)	10	Allow NULL?
113	EXRP36	Category Code - Business Unit 36	String	UDC (00 36)	10	Allow NULL?
114	EXRP37	Category Code - Business Unit 37	String	UDC (00 37)	10	Allow NULL?
115	EXRP38	Category Code - Business Unit 38	String	UDC (00 38)	10	Allow NULL?
116	EXRP39	Category Code - Business Unit 39	String	UDC (00 39)	10	Allow NULL?
117	EXRP40	Category Code - Business Unit 40	String	UDC (00 40)	10	Allow NULL?
118	EXRP41	Category Code - Business Unit 41	String	UDC (00 41)	10	Allow NULL?
119	EXRP42	Category Code - Business Unit 42	String	UDC (00 42)	10	Allow NULL?
120	EXRP43	Category Code - Business Unit 43	String	UDC (00 43)	10	Allow NULL?
121	EXRP44	Category Code - Business Unit 44	String	UDC (00 44)	10	Allow NULL?
122	EXRP45	Category Code - Business Unit 45	String	UDC (00 45)	10	Allow NULL?
123	EXRP46	Category Code - Business Unit 46	String	UDC (00 46)	10	Allow NULL?
124	EXRP47	Category Code - Business Unit 47	String	UDC (00 47)	10	Allow NULL?
125	EXRP48	Category Code - Business Unit 48	String	UDC (00 48)	10	Allow NULL?
126	EXRP49	Category Code - Business Unit 49	String	UDC (00 49)	10	Allow NULL?
127	EXRP50	Category Code - Business Unit 50	String	UDC (00 50)	10	Allow NULL?
128	EX51XACD	PAC Account Description	String	Generic Edit	30	Allow NULL?
129	EXLDA	Account Level of Detail	Character	Generic Edit	1	Allow NULL?
130	EXPEC	Posting Edit	Character	UDC (H00 PE)	1	Allow NULL?
131	EXUM	Unit of Measure	String	UDC (00 UM)	2	Allow NULL?
132	EXSUBA	Subsidiary - Alternate	String	Generic Edit	8	Allow NULL?
133	EXR001	Category Code - G/L1	String	UDC (09 01)	3	Allow NULL?
134	EXR002	Category Code - G/L2	String	UDC (09 02)	3	Allow NULL?
135	EXR003	Category Code - G/L3	String	UDC (09 03)	3	Allow NULL?
136	EXR004	Category Code - G/L4	String	UDC (09 04)	3	Allow NULL?
137	EXR005	Category Code - G/L5	String	UDC (09 05)	3	Allow NULL?
138	EXR006	Category Code - G/L6	String	UDC (09 06)	3	Allow NULL?
139	EXR007	Category Code - G/L7	String	UDC (09 07)	3	Allow NULL?
140	EXR008	Category Code - G/L8	String	UDC (09 08)	3	Allow NULL?
141	EXR009	Category Code - G/L9	String	UDC (09 09)	3	Allow NULL?
142	EXR010	Category Code - G/L10	String	UDC (09 10)	3	Allow NULL?
143	EXR011	Category Code - G/L11	String	UDC (09 11)	3	Allow NULL?
144	EXR012	Category Code - G/L12	String	UDC (09 12)	3	Allow NULL?
145	EXR013	Category Code - G/L13	String	UDC (09 13)	3	Allow NULL?
146	EXR014	Category Code - G/L14	String	UDC (09 14)	3	Allow NULL?
147	EXR015	Category Code - G/L15	String	UDC (09 15)	3	Allow NULL?
148	EXR016	Category Code - G/L16	String	UDC (09 16)	3	Allow NULL?
149	EXR017	Category Code - G/L17	String	UDC (09 17)	3	Allow NULL?
150	EXR018	Category Code - G/L18	String	UDC (09 18)	3	Allow NULL?
151	EXR019	Category Code - G/L19	String	UDC (09 19)	3	Allow NULL?
152	EXR020	Category Code - G/L20	String	UDC (09 20)	3	Allow NULL?
153	EXR021	Category Code - G/L 021	String	UDC (09 21)	10	Allow NULL?
154	EXR022	Category Code - G/L 022	String	UDC (09 22)	10	Allow NULL?
155	EXR023	Category Code - G/L 023	String	UDC (09 23)	10	Allow NULL?
156	EXR024	Category Code - G/L 024	String	UDC (09 24)	10	Allow NULL?
157	EXR025	Category Code - G/L 025	String	UDC (09 25)	10	Allow NULL?
158	EXR026	Category Code - G/L 026	String	UDC (09 26)	10	Allow NULL?
159	EXR027	Category Code - G/L 027	String	UDC (09 27)	10	Allow NULL?
160	EXR028	Category Code - G/L 028	String	UDC (09 28)	10	Allow NULL?
161	EXR029	Category Code - G/L 029	String	UDC (09 29)	10	Allow NULL?
162	EXR030	Category Code - G/L 030	String	UDC (09 30)	10	Allow NULL?
163	EXR031	Category Code - G/L 031	String	UDC (09 31)	10	Allow NULL?
164	EXR032	Category Code - G/L 032	String	UDC (09 32)	10	Allow NULL?
165	EXR033	Category Code - G/L 033	String	UDC (09 33)	10	Allow NULL?
166	EXR034	Category Code - G/L 034	String	UDC (09 34)	10	Allow NULL?
167	EXR035	Category Code - G/L 035	String	UDC (09 35)	10	Allow NULL?
168	EXR036	Category Code - G/L 036	String	UDC (09 36)	10	Allow NULL?
169	EXR037	Category Code - G/L 037	String	UDC (09 37)	10	Allow NULL?
170	EXR038	Category Code - G/L 038	String	UDC (09 38)	10	Allow NULL?
171	EXR039	Category Code - G/L 039	String	UDC (09 39)	10	Allow NULL?
172	EXR040	Category Code - G/L 040	String	UDC (09 40)	10	Allow NULL?
173	EXR041	Category Code - G/L 041	String	UDC (09 41)	10	Allow NULL?
174	EXR042	Category Code - G/L 042	String	UDC (09 42)	10	Allow NULL?
175	EXR043	Category Code - G/L 043	String	UDC (09 43)	10	Allow NULL?

TOP 920 | 51X | F51X10 INDEXES

Number

Description

User Job + (Primary/Unique)

Element	Alias	Description	Sequence
1	USER	User ID	Ascending
2	JOBS	Job Number	Ascending
3	51XRTY	PAC Record Type	Ascending
4	51XTC	PAC Total Code	Ascending
5	MCU	Business Unit	Ascending
6	51XCT1	Cost Code OR Cost Type 1	Ascending
7	51XCT2	Cost Code OR Cost Type 2	Ascending

User Job Record Type +

Element	Alias	Description	Sequence
1	USER	User ID	Ascending
2	JOBS	Job Number	Ascending
3	51XRTY	PAC Record Type	Ascending
4	MCU	Business Unit	Ascending

User Job MCU

Element	Alias	Description	Sequence
1	USER	User ID	Ascending
2	JOBS	Job Number	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

175 COLUMNS | 3 INDEXES | 920 | 51X | F51X10 TABLE

TOP 920 | 51X | F51X10 COLUMNS

TOP 920 | 51X | F51X10 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

175 COLUMNS | 3 INDEXES | 920 | 51X | F51X10 TABLE

TOP920 | 51X | F51X10 COLUMNS

TOP920 | 51X | F51X10 INDEXES

TOP 920 | 51X | F51X10 COLUMNS

TOP 920 | 51X | F51X10 INDEXES