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	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

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	F4311	PD	Purchase Order Detail File
10	F4111	IL	Item Ledger 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	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

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
51X: In-Memory Project Management
1	920	F51X91	X2	87	1	Column Layout Table	Files	51X: In-Memory Project Management

Column	Field	Description	Data Type	Edit Type	Length	SQL Create Statement
1	X251XICL	Column Layout	String	Generic Edit	10	Allow NULL?
2	X2DL01	Description	String	Generic Edit	30	Allow NULL?
3	X251XCOL01	Column 01	String	Generic Edit	6	Allow NULL?
4	X251XCOL02	Column 02	String	Generic Edit	6	Allow NULL?
5	X251XCOL03	Column 03	String	Generic Edit	6	Allow NULL?
6	X251XCOL04	Column 04	String	Generic Edit	6	Allow NULL?
7	X251XCOL05	Column 05	String	Generic Edit	6	Allow NULL?
8	X251XCOL06	Column 06	String	Generic Edit	6	Allow NULL?
9	X251XCOL07	Column 07	String	Generic Edit	6	Allow NULL?
10	X251XCOL08	Column 08	String	Generic Edit	6	Allow NULL?
11	X251XCOL09	Column 09	String	Generic Edit	6	Allow NULL?
12	X251XCOL10	Column 10	String	Generic Edit	6	Allow NULL?
13	X251XCOL11	Column 11	String	Generic Edit	6	Allow NULL?
14	X251XCOL12	Column 12	String	Generic Edit	6	Allow NULL?
15	X251XCOL13	Column 13	String	Generic Edit	6	Allow NULL?
16	X251XCOL14	Column 14	String	Generic Edit	6	Allow NULL?
17	X251XCOL15	Column 15	String	Generic Edit	6	Allow NULL?
18	X251XCOL16	Column 16	String	Generic Edit	6	Allow NULL?
19	X251XCOL17	Column 17	String	Generic Edit	6	Allow NULL?
20	X251XCOL18	Column 18	String	Generic Edit	6	Allow NULL?
21	X251XCOL19	Column 19	String	Generic Edit	6	Allow NULL?
22	X251XCOL20	Column 20	String	Generic Edit	6	Allow NULL?
23	X251XCOL21	Column 21	String	Generic Edit	6	Allow NULL?
24	X251XCOL22	Column 22	String	Generic Edit	6	Allow NULL?
25	X251XCOL23	Column 23	String	Generic Edit	6	Allow NULL?
26	X251XCOL24	Column 24	String	Generic Edit	6	Allow NULL?
27	X251XCOL25	Column 25	String	Generic Edit	6	Allow NULL?
28	X251XCOL26	Column 26	String	Generic Edit	6	Allow NULL?
29	X251XCOL27	Column 27	String	Generic Edit	6	Allow NULL?
30	X251XCOL28	Column 28	String	Generic Edit	6	Allow NULL?
31	X251XCOL29	Column 29	String	Generic Edit	6	Allow NULL?
32	X251XCOL30	Column 30	String	Generic Edit	6	Allow NULL?
33	X251XCOL31	Column 31	String	Generic Edit	6	Allow NULL?
34	X251XCOL32	Column 32	String	Generic Edit	6	Allow NULL?
35	X251XCOL33	Column 33	String	Generic Edit	6	Allow NULL?
36	X251XCOL34	Column 34	String	Generic Edit	6	Allow NULL?
37	X251XCOL35	Column 35	String	Generic Edit	6	Allow NULL?
38	X251XCOL36	Column 36	String	Generic Edit	6	Allow NULL?
39	X251XCOL37	Column 37	String	Generic Edit	6	Allow NULL?
40	X251XCOL38	Column 38	String	Generic Edit	6	Allow NULL?
41	X251XCOL39	Column 39	String	Generic Edit	6	Allow NULL?
42	X251XCOL40	Column 40	String	Generic Edit	6	Allow NULL?
43	X251X01IC	Include Column 01 in Chart	Character	Check Box	1	Allow NULL?
44	X251X02IC	Include Column 02 in Chart	Character	Check Box	1	Allow NULL?
45	X251X03IC	Include Column 03 in Chart	Character	Check Box	1	Allow NULL?
46	X251X04IC	Include Column 04 in Chart	Character	Check Box	1	Allow NULL?
47	X251X05IC	Include Column 05 in Chart	Character	Check Box	1	Allow NULL?
48	X251X06IC	Include Column 06 in Chart	Character	Check Box	1	Allow NULL?
49	X251X07IC	Include Column 07 in Chart	Character	Check Box	1	Allow NULL?
50	X251X08IC	Include Column 08 in Chart	Character	Check Box	1	Allow NULL?
51	X251X09IC	Include Column 09 in Chart	Character	Check Box	1	Allow NULL?
52	X251X10IC	Include Column 10 in Chart	Character	Check Box	1	Allow NULL?
53	X251X11IC	Include Column 11 in Chart	Character	Check Box	1	Allow NULL?
54	X251X12IC	Include Column 12 in Chart	Character	Check Box	1	Allow NULL?
55	X251X13IC	Include Column 13 in Chart	Character	Check Box	1	Allow NULL?
56	X251X14IC	Include Column 14 in Chart	Character	Check Box	1	Allow NULL?
57	X251X15IC	Include Column 15 in Chart	Character	Check Box	1	Allow NULL?
58	X251X16IC	Include Column 16 in Chart	Character	Check Box	1	Allow NULL?
59	X251X17IC	Include Column 17 in Chart	Character	Check Box	1	Allow NULL?
60	X251X18IC	Include Column 18 in Chart	Character	Check Box	1	Allow NULL?
61	X251X19IC	Include Column 19 in Chart	Character	Check Box	1	Allow NULL?
62	X251X20IC	Include Column 20 in Chart	Character	Check Box	1	Allow NULL?
63	X251X21IC	Include Column 21 in Chart	Character	Check Box	1	Allow NULL?
64	X251X22IC	Include Column 22 in Chart	Character	Check Box	1	Allow NULL?
65	X251X23IC	Include Column 23 in Chart	Character	Check Box	1	Allow NULL?
66	X251X24IC	Include Column 24 in Chart	Character	Check Box	1	Allow NULL?
67	X251X25IC	Include Column 25 in Chart	Character	Check Box	1	Allow NULL?
68	X251X26IC	Include Column 26 in Chart	Character	Check Box	1	Allow NULL?
69	X251X27IC	Include Column 27 in Chart	Character	Check Box	1	Allow NULL?
70	X251X28IC	Include Column 28 in Chart	Character	Check Box	1	Allow NULL?
71	X251X29IC	Include Column 29 in Chart	Character	Check Box	1	Allow NULL?
72	X251X30IC	Include Column 30 in Chart	Character	Check Box	1	Allow NULL?
73	X251X31IC	Include Column 31 in Chart	Character	Check Box	1	Allow NULL?
74	X251X32IC	Include Column 32 in Chart	Character	Check Box	1	Allow NULL?
75	X251X33IC	Include Column 33 in Chart	Character	Check Box	1	Allow NULL?
76	X251X34IC	Include Column 34 in Chart	Character	Check Box	1	Allow NULL?
77	X251X35IC	Include Column 35 in Chart	Character	Check Box	1	Allow NULL?
78	X251X36IC	Include Column 36 in Chart	Character	Check Box	1	Allow NULL?
79	X251X37IC	Include Column 37 in Chart	Character	Check Box	1	Allow NULL?
80	X251X38IC	Include Column 38 in Chart	Character	Check Box	1	Allow NULL?
81	X251X39IC	Include Column 39 in Chart	Character	Check Box	1	Allow NULL?
82	X251X40IC	Include Column 40 in Chart	Character	Check Box	1	Allow NULL?
83	X2USER	User ID	String	Generic Edit	10	Allow NULL?
84	X2PID	Program ID	String	Generic Edit	10	Allow NULL?
85	X2JOB	Job Number	String	Generic Edit	8	Allow NULL?
86	X2UPMJ	Date - Updated	Date	Generic Edit	6
87	X2UPMT	Time - Last Updated	Numeric	Generic Edit	6	Allow NULL?

Su	Mo	Tu	We	Th	Fr	Sa
		1	2	3	4	5
6	7	8	9	10	11	12
13	14	15	16	17	18	19
20	21	22	23	24	25	26
27	28	29	30

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 | 920 | 51X | F51X91 TABLE

TOP 920 | 51X | F51X91 COLUMNS

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

TOP920 | 51X | F51X91 COLUMNS

TOP920 | 51X | F51X91 INDEXES

TOP 920 | 51X | F51X91 COLUMNS

TOP 920 | 51X | F51X91 INDEXES