	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

	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

112 columns | 920 | ENTJ

	Table	Table Description	Column#	Prefix	Alias	Column Description	Data Type	Edit Type	Length	Decimals
TOP15: Real Estate Management
1	F150120	Tenant Exclusion Header	13	NW	ENTJ	Date - Entered	Date	Generic Edit	6	0
2	F150120D	Tenant Exclusion - Alternate Description	10	NW	ENTJ	Date - Entered	Date	Generic Edit	6	0
3	F150121	Tenant Exclusion Detail	13	NX	ENTJ	Date - Entered	Date	Generic Edit	6	0
4	F150122	Share Factor Denominator Header	15	NY	ENTJ	Date - Entered	Date	Generic Edit	6	0
5	F150122A	Share Factor Denominator Audit	23	SA	ENTJ	Date - Entered	Date	Generic Edit	6	0
6	F150122D	Share Factor Denominator - Alternate Description	10	NY	ENTJ	Date - Entered	Date	Generic Edit	6	0
7	F150123	Share Factor Denominator Detail	13	NZ	ENTJ	Date - Entered	Date	Generic Edit	6	0
8	F15012B	Tenant E.P. Class Master	84	NS	ENTJ	Date - Entered	Date	Generic Edit	6	0
9	F15013B	Sales Overage Master File	85	NO	ENTJ	Date - Entered	Date	Generic Edit	6	0
10	F15014B	Product Scales Master	49	NP	ENTJ	Date - Entered	Date	Generic Edit	6	0
11	F15015B	Min/Max Rents And Recoveries Master	50	NQ	ENTJ	Date - Entered	Date	Generic Edit	6	0
12	F15016B	Tenant Escalation Master	80	NU	ENTJ	Date - Entered	Date	Generic Edit	6	0
13	F15017	Lease Master Detail	53	NW	ENTJ	Date - Entered	Date	Generic Edit	6	0
14	F15019D	Billing Frequency - Alternate Description	10	NL	ENTJ	Date - Entered	Date	Generic Edit	6	0
15	F1501B	Lease Master Header	56	NE	ENTJ	Date - Entered	Date	Generic Edit	6	0
16	F1501BD	Lease Master Header - Alternate Description	11	NE	ENTJ	Date - Entered	Date	Generic Edit	6	0
17	F15020	Extended Billings Master	61	NN	ENTJ	Date - Entered	Date	Generic Edit	6	0
18	F1502B	Recurring Billings Master	80	NF	ENTJ	Date - Entered	Date	Generic Edit	6	0
19	F1502BD	Recurring Billings Master - Alternate Description	11	NF	ENTJ	Date - Entered	Date	Generic Edit	6	0
20	F1506D	Floor Master - Alternate Description	13	OP	ENTJ	Date - Entered	Date	Generic Edit	6	0
21	F1507D	Unit Master - Alternate Description	15	NH	ENTJ	Date - Entered	Date	Generic Edit	6	0
22	F1510B	Real Estate Management Constants	42	OE	ENTJ	Date - Entered	Date	Generic Edit	6	0
23	F1512D	Billing Code Extension - Alternate Description	11	NA	ENTJ	Date - Entered	Date	Generic Edit	6	0
24	F1513B	FASB 13 Lease Control	65	O3	ENTJ	Date - Entered	Date	Generic Edit	6	0
25	F1514	Area Master	24	NW	ENTJ	Date - Entered	Date	Generic Edit	6	0
26	F15142	Area Definitions	25	NV	ENTJ	Date - Entered	Date	Generic Edit	6	0
27	F1514D	Area Master - Alternate Description	16	NW	ENTJ	Date - Entered	Date	Generic Edit	6	0
28	F1515	E.P. Cap Rules	23	CH	ENTJ	Date - Entered	Date	Generic Edit	6	0
29	F15151	Building E.P. Caps	25	CD	ENTJ	Date - Entered	Date	Generic Edit	6	0
30	F15152	Lease E.P. Caps	38	LC	ENTJ	Date - Entered	Date	Generic Edit	6	0
31	F151521	Lease E.P. Accounts Not Subject to Cap	24	LO	ENTJ	Date - Entered	Date	Generic Edit	6	0
32	F15153	Lease Cap History	43	LC	ENTJ	Date - Entered	Date	Generic Edit	6	0
33	F1521	Log Detail Master	39	NB	ENTJ	Date - Entered	Date	Generic Edit	6	0
34	F1521D	Log Detail Master - Alternate Description	11	NB	ENTJ	Date - Entered	Date	Generic Edit	6	0
35	F1523	Log Standard Master	28	OG	ENTJ	Date - Entered	Date	Generic Edit	6	0
36	F1523D	Log Standards Master - Alternate Description	11	OG	ENTJ	Date - Entered	Date	Generic Edit	6	0
37	F15302	Ledger Type Groups	16	LT	ENTJ	Date - Entered	Date	Generic Edit	6	0
38	F15303	E.P. Class Expenses History	25	CH	ENTJ	Date - Entered	Date	Generic Edit	6	0
39	F1530H	Expense Participation Class Master Header	20	NG	ENTJ	Date - Entered	Date	Generic Edit	6	0
40	F1530HD	E.P. Class Master Alternate Description	10	HD	ENTJ	Date - Entered	Date	Generic Edit	6	0
41	F1531	Expense Participation Class Adjustment	22	OM	ENTJ	Date - Entered	Date	Generic Edit	6	0
42	F1531D	Expense Participation Class Adj. - Alternate Description	11	OM	ENTJ	Date - Entered	Date	Generic Edit	6	0
43	F1533B	Tenant Account Exclusions	18	NM	ENTJ	Date - Entered	Date	Generic Edit	6	0
44	F1538B1	Occupancy Gross Up Audit	36	GU	ENTJ	Date - Entered	Date	Generic Edit	6	0
45	F1538B2	Exclusion/Redistribution	23	RD	ENTJ	Date - Entered	Date	Generic Edit	6	0
46	F1540B	Sales Report Control	66	NR	ENTJ	Date - Entered	Date	Generic Edit	6	0
47	F15410	Tenant Weekly Sales	37	N9	ENTJ	Date - Entered	Date	Generic Edit	6	0
48	F1541B	Tenant Sales History	47	N8	ENTJ	Date - Entered	Date	Generic Edit	6	0
49	F1541BW	Sales History Work File	59	OW	ENTJ	Date - Entered	Date	Generic Edit	6	0
50	F1542	Projected Sales	51	OJ	ENTJ	Date - Entered	Date	Generic Edit	6	0
51	F1544BD	Sales Analysis Control - Alternate Description	12	OB	ENTJ	Date - Entered	Date	Generic Edit	6	0
52	F1547	Sales Seasonality	28	OI	ENTJ	Date - Entered	Date	Generic Edit	6	0
53	F1549	Seasonality Models	14	OL	ENTJ	Date - Entered	Date	Generic Edit	6	0
54	F1570	Legal Clauses	24	ND	ENTJ	Date - Entered	Date	Generic Edit	6	0
55	F15701	Legal Clause Options Audit	23	NK	ENTJ	Date - Entered	Date	Generic Edit	6	0
56	F157011	Lease Option Type Header	13	NA	ENTJ	Date - Entered	Date	Generic Edit	6	0
57	F157011D	Lease Option Type Header - Alternate Description	10	NA	ENTJ	Date - Entered	Date	Generic Edit	6	0
58	F157012	Lease Option Type Detail	19	NC	ENTJ	Date - Entered	Date	Generic Edit	6	0
59	F157012D	Lease Option Type Detail - Alternate Description	11	NC	ENTJ	Date - Entered	Date	Generic Edit	6	0
60	F15702	Legal Clause Space Detail	23	NF	ENTJ	Date - Entered	Date	Generic Edit	6	0
61	F157021	Legal Clause Space Detail Audit	21	NG	ENTJ	Date - Entered	Date	Generic Edit	6	0
62	F15702D	Legal Clause Space Detail - Alternate Description	13	NF	ENTJ	Date - Entered	Date	Generic Edit	6	0
63	F15703	Legal Clause Amounts	21	NI	ENTJ	Date - Entered	Date	Generic Edit	6	0
64	F159071	Market/Potential/Renewal Rent Master	21	NY	ENTJ	Date - Entered	Date	Generic Edit	6	0
65	F159071D	Market/Potential/Renewal Rent Master - Alternate Description	13	NY	ENTJ	Date - Entered	Date	Generic Edit	6	0
TOP15L: Adv Real Estate Forecasting
66	F15L100	AREF Building Constants	36	BC	ENTJ	Date - Entered	Date	Generic Edit	6	0
67	F15L1001	AREF Building Constants Models	36	BM	ENTJ	Date - Entered	Date	Generic Edit	6	0
68	F15L101	AREF Unit Master	90	UM	ENTJ	Date - Entered	Date	Generic Edit	6	0
69	F15L102	AREF Unit Assumptions Master Header	35	AH	ENTJ	Date - Entered	Date	Generic Edit	6	0
70	F15L103	AREF Sales Overage Rule Header	27	SH	ENTJ	Date - Entered	Date	Generic Edit	6	0
71	F15L104	AREF E.P. Rules Header	18	EH	ENTJ	Date - Entered	Date	Generic Edit	6	0
72	F15L105	AREF Growth Pattern File	37	GP	ENTJ	Date - Entered	Date	Generic Edit	6	0
73	F15L106	AREF Recurring Bill Code Rules Header	16	RB	ENTJ	Date - Entered	Date	Generic Edit	6	0
74	F15L107	AREF Recycle Assumption Rules	22	EF	ENTJ	Date - Entered	Date	Generic Edit	6	0
75	F15L108	AREF Base Account Definition	39	AD	ENTJ	Date - Entered	Date	Generic Edit	6	0
76	F15L109	AREF Budget Results	33	BR	ENTJ	Date - Entered	Date	Generic Edit	6	0
77	F15L109W	AREF Grown Amounts Work File	26	GA	ENTJ	Date - Entered	Date	Generic Edit	6	0
78	F15L110	AREF Account Status	53	AS	ENTJ	Date - Entered	Date	Generic Edit	6	0
79	F15L111	AREF Account Status Detail	35	AD	ENTJ	Date - Entered	Date	Generic Edit	6	0
80	F15L112	AREF Unit Assumptions Master Detail	28	AD	ENTJ	Date - Entered	Date	Generic Edit	6	0
81	F15L113	AREF Sales Overage Detail	19	SD	ENTJ	Date - Entered	Date	Generic Edit	6	0
82	F15L114	AREF E.P. Rules Detail	20	ED	ENTJ	Date - Entered	Date	Generic Edit	6	0
83	F15L116	AREF Recurring Bill Code Rules Detail	18	RD	ENTJ	Date - Entered	Date	Generic Edit	6	0
84	F15L118	AREF Base Account Definition Detail	33	DD	ENTJ	Date - Entered	Date	Generic Edit	6	0
85	F15L141	AREF Gross Lease Occupied Area	29	GL	ENTJ	Date - Entered	Date	Generic Edit	6	0
86	F15L301	AREF Projected Sales	48	PS	ENTJ	Date - Entered	Date	Generic Edit	6	0
87	F15L401	AREF Share Factor Denominator Audit	42	SF	ENTJ	Date - Entered	Date	Generic Edit	6	0
88	F15L402	AREF Tenant Exclusion Rule Audit	24	SG	ENTJ	Date - Entered	Date	Generic Edit	6	0
89	F15L403	AREF Gross Up Processing Audit	35	SH	ENTJ	Date - Entered	Date	Generic Edit	6	0
TOP42: Sales Management
90	F42004	Commission Constants File	14	CM	ENTJ	Date - Entered	Date	Generic Edit	6	0
TOP44H: Homebuilder Management
91	F4457	Takeoff File (World)	14	JJ	ENTJ	Date - Entered	Date	Generic Edit	6	0
92	F4458	Takeoff (World)	14	JK	ENTJ	Date - Entered	Date	Generic Edit	6	0
TOP51F: Advanced Job Forecasting
93	F51F100	Job Forecast Header	10	QF	ENTJ	Date - Entered	Date	Generic Edit	6	0
94	F51F110	Job Forecast Details	30	QG	ENTJ	Date - Entered	Date	Generic Edit	6	0
95	F51F115	Remaining Work Detail	11	QJ	ENTJ	Date - Entered	Date	Generic Edit	6	0
96	F51F120	Job Forecast Header History	11	QK	ENTJ	Date - Entered	Date	Generic Edit	6	0
97	F51F125	Job Forecast Detail History	31	QI	ENTJ	Date - Entered	Date	Generic Edit	6	0
98	F51F90	Formula Definition	75	QN	ENTJ	Date - Entered	Date	Generic Edit	6	0
99	F51F94	User Defined MOC Definition	4	QU	ENTJ	Date - Entered	Date	Generic Edit	6	0
100	F51F95	User Defined MOC Rules	9	QT	ENTJ	Date - Entered	Date	Generic Edit	6	0
TOP54R: Rental Management
101	F54R01	Rental Constants	32	RC	ENTJ	Date - Entered	Date	Generic Edit	6	0
102	F54R02	Action Definition	16	AD	ENTJ	Date - Entered	Date	Generic Edit	6	0
103	F54R021	Action Details	16	AA	ENTJ	Date - Entered	Date	Generic Edit	6	0
104	F54R03	Line Type and Action Association Header	17	LH	ENTJ	Date - Entered	Date	Generic Edit	6	0
105	F54R031	Line Type and Action Association Detail	17	LD	ENTJ	Date - Entered	Date	Generic Edit	6	0
106	F54R099	Rental Contract Header Ledger	82	HL	ENTJ	Date - Entered	Date	Generic Edit	6	0
107	F54R10	Rental Contract Header	80	CH	ENTJ	Date - Entered	Date	Generic Edit	6	0
108	F54R11	Rental Contract Detail	57	CD	ENTJ	Date - Entered	Date	Generic Edit	6	0
109	F54R12	Purchase Order Receiver Rentals File	36	RR	ENTJ	Date - Entered	Date	Generic Edit	6	0
110	F54R199	Rental Contract Detail Ledger	53	DL	ENTJ	Date - Entered	Date	Generic Edit	6	0
111	F54R20	Rental Contract Related Orders	20	RO	ENTJ	Date - Entered	Date	Generic Edit	6	0
112	F54R41T	Rental Item Details Table	43	RI	ENTJ	Date - Entered	Date	Generic Edit	6	0

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

112 columns | 920 | ENTJ