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
81A: DREAMWriter Conversion Tool
1	812	F81A14	M6	57	1	DreamWriter Selection Values Interim Table	Files	81A: DREAMWriter Conversion Tool

Column	Field	Description	Data Type	Edit Type	Length	SQL Create Statement
1	M6LDFR	Library Name - Data - From	String	Generic Edit	10	Allow NULL?
2	M6PID	Program ID	String	Generic Edit	10	Allow NULL?
3	M6VERS	Version History	String	Generic Edit	10	Allow NULL?
4	M6SQN	Option Prompt Line	Numeric	Generic Edit	3	Allow NULL?
5	M6FLDN	Data Field Name	String	Generic Edit	6	Allow NULL?
6	M6FPID	EnterpriseOne Program ID	String	Generic Edit	10	Allow NULL?
7	M6BVER	EnterpriseOne Version	String	Generic Edit	10	Allow NULL?
8	M6VL01	Selection Values 01	String	Generic Edit	25	Allow NULL?
9	M6VL02	Selection Values 02	String	Generic Edit	25	Allow NULL?
10	M6VL03	Selection Values 03	String	Generic Edit	25	Allow NULL?
11	M6VL04	Selection Values 04	String	Generic Edit	25	Allow NULL?
12	M6VL05	Selection Values 05	String	Generic Edit	25	Allow NULL?
13	M6VL06	Selection Values 06	String	Generic Edit	25	Allow NULL?
14	M6VL07	Selection Values 07	String	Generic Edit	25	Allow NULL?
15	M6VL08	Selection Values 08	String	Generic Edit	25	Allow NULL?
16	M6VL09	Selection Values 09	String	Generic Edit	25	Allow NULL?
17	M6VL10	Selection Values 10	String	Generic Edit	25	Allow NULL?
18	M6VL11	Selection Values 11	String	Generic Edit	25	Allow NULL?
19	M6VL12	Selection Values 12	String	Generic Edit	25	Allow NULL?
20	M6VL13	Selection Values 13	String	Generic Edit	25	Allow NULL?
21	M6VL14	Selection Values 14	String	Generic Edit	25	Allow NULL?
22	M6VL15	Selection Values 15	String	Generic Edit	25	Allow NULL?
23	M6VL16	Selection Values 16	String	Generic Edit	25	Allow NULL?
24	M6VL17	Selection Values 17	String	Generic Edit	25	Allow NULL?
25	M6VL18	Selection Values 18	String	Generic Edit	25	Allow NULL?
26	M6VL19	Selection Values 19	String	Generic Edit	25	Allow NULL?
27	M6VL20	Selection Values 20	String	Generic Edit	25	Allow NULL?
28	M6VL21	Selection Values 21	String	Generic Edit	25	Allow NULL?
29	M6VL22	Selection Values 22	String	Generic Edit	25	Allow NULL?
30	M6VL23	Selection Values 23	String	Generic Edit	25	Allow NULL?
31	M6VL24	Selection Values 24	String	Generic Edit	25	Allow NULL?
32	M6VL25	Selection Values 25	String	Generic Edit	25	Allow NULL?
33	M6VL26	Selection Values 26	String	Generic Edit	25	Allow NULL?
34	M6VL27	Selection Values 27	String	Generic Edit	25	Allow NULL?
35	M6VL28	Selection Values 28	String	Generic Edit	25	Allow NULL?
36	M6VL29	Selection Values 29	String	Generic Edit	25	Allow NULL?
37	M6VL30	Selection Values 30	String	Generic Edit	25	Allow NULL?
38	M6VL31	Selection Values 31	String	Generic Edit	25	Allow NULL?
39	M6VL32	Selection Values 32	String	Generic Edit	25	Allow NULL?
40	M6VL33	Selection Values 33	String	Generic Edit	25	Allow NULL?
41	M6VL34	Selection Values 34	String	Generic Edit	25	Allow NULL?
42	M6VL35	Selection Values 35	String	Generic Edit	25	Allow NULL?
43	M6VL36	Selection Values 36	String	Generic Edit	25	Allow NULL?
44	M6VL37	Selection Values 37	String	Generic Edit	25	Allow NULL?
45	M6VL38	Selection Values 38	String	Generic Edit	25	Allow NULL?
46	M6VL39	Selection Values 39	String	Generic Edit	25	Allow NULL?
47	M6VL40	Selection Values 40	String	Generic Edit	25	Allow NULL?
48	M6VL41	Selection Values 41	String	Generic Edit	25	Allow NULL?
49	M6VL42	Selection Values 42	String	Generic Edit	25	Allow NULL?
50	M6VL43	Selection Values 43	String	Generic Edit	25	Allow NULL?
51	M6VL44	Selection Values 44	String	Generic Edit	25	Allow NULL?
52	M6VL45	Selection Values 45	String	Generic Edit	25	Allow NULL?
53	M6LUS	User Migration	String	Generic Edit	10	Allow NULL?
54	M6FPD	Program ID - Migration Process	String	Generic Edit	10	Allow NULL?
55	M6UPMJ	Date - Updated	Date	Generic Edit	6
56	M6JOBN	Work Station ID	String	Generic Edit	10	Allow NULL?
57	M6UPMT	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

57 COLUMNS | 1 INDEXES | 812 | 81A | F81A14 TABLE

TOP 812 | 81A | F81A14 COLUMNS

TOP 812 | 81A | F81A14 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

57 COLUMNS | 1 INDEXES | 812 | 81A | F81A14 TABLE

TOP812 | 81A | F81A14 COLUMNS

TOP812 | 81A | F81A14 INDEXES

TOP 812 | 81A | F81A14 COLUMNS

TOP 812 | 81A | F81A14 INDEXES