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

	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

123 tables910 | 15

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
15: Property Management
1	910	F1501	NE	72	3	Tenant/Lease Master	Master Files	15: Property Management	Business Data
2	910	F15011	NK	23	1	Billings Generation Control Master	Balance Files	15: Property Management	Business Data
3	910	F15011B	NK	71	1	BIllings Generation Control	Balance Files	15: Property Management	Business Data
4	910	F15012	NS	69	1	Tenant E.P. Class Master	Secondary Master Files	15: Property Management	Business Data
5	910	F150120	NW	17	1	Tenant Exclusion Header	Files	15: Property Management	Business Data
6	910	F150120D	NW	10	1	Tenant Exclusion - Alternate Description	Extra Features Files	15: Property Management	Business Data
7	910	F150121	NX	25	1	Tenant Exclusion Detail	Files	15: Property Management	Business Data
8	910	F150122	NY	19	1	Share Factor Denominator Header	Files	15: Property Management	Business Data
9	910	F150122A	SA	24	1	Share Factor Denominator Audit	Files	15: Property Management	Business Data
10	910	F150122D	NY	10	1	Share Factor Denominator - Alternate Description	Extra Features Files	15: Property Management	Business Data
11	910	F150123	NZ	15	1	Share Factor Denominator Detail	Files	15: Property Management	Business Data
12	910	F15012B	NS	97	6	Tenant E.P. Class Master	Secondary Master Files	15: Property Management	Business Data
13	910	F15013	NO	68	1	Sales Overage Master	Secondary Master Files	15: Property Management	Business Data
14	910	F15013B	NO	89	6	Sales Overage Master File	Secondary Master Files	15: Property Management	Business Data
15	910	F15014	NP	36	1	Product Scales Master	Secondary Master Files	15: Property Management	Business Data
16	910	F15014B	NP	55	9	Product Scales Master	Secondary Master Files	15: Property Management	Business Data
17	910	F15015	NQ	40	1	Minimum rent/recoveries Master	Secondary Master Files	15: Property Management	Business Data
18	910	F15015B	NQ	54	5	Min/Max Rents And Recoveries Master	Secondary Master Files	15: Property Management	Business Data
19	910	F15016	NU	70	1	Tenant Escalation Master	Secondary Master Files	15: Property Management	Business Data
20	910	F15016B	NU	82	4	Tenant Escalation Master	Secondary Master Files	15: Property Management	Business Data
21	910	F15017	NW	57	6	Lease Master Detail	Balance Files	15: Property Management	Business Data
22	910	F15019D	NL	10	1	Billing Frequency - Alternate Description	Extra Features Files	15: Property Management	Business Data
23	910	F1501B	NE	61	8	Lease Master Header	Master Files	15: Property Management	Business Data
24	910	F1501BD	NE	11	1	Lease Master Header - Alternate Description	Extra Features Files	15: Property Management	Business Data
25	910	F1502	NF	71	1	Recurring Billings Master	Secondary Master Files	15: Property Management	Business Data
26	910	F15020	NN	62	4	Extended Billings Master	Master Files	15: Property Management	Business Data
27	910	F1502B	NF	82	12	Recurring Billings Master	Secondary Master Files	15: Property Management	Business Data
28	910	F1502BD	NF	11	1	Recurring Billings Master - Alternate Description	Extra Features Files	15: Property Management	Business Data
29	910	F1502WAB	NF	22	1	Rent Increase Amounts	Regular Work Files	15: Property Management	Business Data
30	910	F1502WB	N4	84	1	Estimated EP Recurring Billings	Regular Work Files	15: Property Management	Business Data
31	910	F1503	NB	34	1	Log Standards Master	Transaction Files	15: Property Management	Business Data
32	910	F1504	NC	14	1	Log Standards Text Master	Transaction Files	15: Property Management	Business Data
33	910	F1505	ND	49	1	Management Fee Master	Secondary Master Files	15: Property Management	Business Data
34	910	F1505B	ND	60	8	Management Fee Master	Secondary Master Files	15: Property Management	Business Data
35	910	F1505H	OK	12	1	Revenue Fee Generation History	History Files	15: Property Management	Business Data
36	910	F1505HB	OK	20	1	Revenue Fee Generation History	History Files	15: Property Management	Business Data
37	910	F1506	OP	18	1	Floor Master	Master Files	15: Property Management	Business Data
38	910	F1506D	OP	13	1	Floor Master - Alternate Description	Extra Features Files	15: Property Management	Business Data
39	910	F1507	NH	60	4	Unit Master	Master Files	15: Property Management	Business Data
40	910	F1507D	NH	15	1	Unit Master - Alternate Description	Extra Features Files	15: Property Management	Business Data
41	910	F1510	OE	36	1	Property Management Constants	Constants Files	15: Property Management	Business Data
42	910	F1510B	OE	43	1	Real Estate Management Constants	Constants Files	15: Property Management	Business Data
43	910	F1511	NJ	87	1	Tenant/Lease Billings Detail	Transaction Files	15: Property Management	Business Data
44	910	F15110B	OB	18	3	Expense Participation Class Account	Regular Work Files	15: Property Management	Business Data
45	910	F1511B	NJ	95	12	Lease Billings Master	Transaction Files	15: Property Management	Business Data
46	910	F1511B1	NW	15	1	Billing Batches Summary	Files	15: Property Management	Business Data
47	910	F1511H	N#	86	1	Tenant/Lease Billings Detail History	History Files	15: Property Management	Business Data
48	910	F1511HB	NC	93	6	Lease Billings History	History Files	15: Property Management	Business Data
49	910	F1512	NA	32	4	Billing Code Extension	Constants Files	15: Property Management	Business Data
50	910	F1512D	NA	11	1	Billing Code Extension - Alternate Description	Extra Features Files	15: Property Management	Business Data
51	910	F1513	O3	59	1	FASB 13 Lease Control File	Transaction Files	15: Property Management	Business Data
52	910	F1513B	O3	69	2	FASB 13 Lease Control	Transaction Files	15: Property Management	Business Data
53	910	F1514	NW	25	4	Area Master	Secondary Master Files	15: Property Management	Business Data
54	910	F15141	NC	29	3	Gross Lease Occupied Areas	Files	15: Property Management	Business Data
55	910	F15142	NV	25	1	Area Definitions	Master Files	15: Property Management	Business Data
56	910	F1514D	NW	16	1	Area Master - Alternate Description	Extra Features Files	15: Property Management	Business Data
57	910	F1514W	NW	8	1	Area Work File	Work Files	15: Property Management	Business Data
58	910	F1515	CH	23	1	E.P. Cap Rules	Files	15: Property Management	Business Data
59	910	F15151	CD	28	1	Building E.P. Caps	Files	15: Property Management	Business Data
60	910	F15152	LC	38	1	Lease E.P. Caps	Secondary Master Files	15: Property Management	Business Data
61	910	F151521	LO	24	1	Lease E.P. Accounts Not Subject to Cap	Files	15: Property Management	Business Data
62	910	F15153	LC	43	4	Lease Cap History	Files	15: Property Management	Business Data
63	910	F1516	NX	9	1	Extended Invoice Text	Files	15: Property Management	Business Data
64	910	F151991	NB	20	1	G/L Transaction A/R Application Work File	Work Files	15: Property Management	Business Data
65	910	F15199W	NB	13	3	G/L Transaction Summarization Work File	Work Files	15: Property Management	Business Data
66	910	F1521	NB	40	13	Log Detail Master	Secondary Master Files	15: Property Management	Business Data
67	910	F1521D	NB	11	1	Log Detail Master - Alternate Description	Extra Features Files	15: Property Management	Business Data
68	910	F1523	OG	28	2	Log Standard Master	Secondary Master Files	15: Property Management	Business Data
69	910	F1523D	OG	11	1	Log Standards Master - Alternate Description	Extra Features Files	15: Property Management	Business Data
70	910	F1525	N0	37	1	A/R Fee Interest	Secondary Master Files	15: Property Management	Business Data
71	910	F1525B	NM	45	3	Fees and Interest	Secondary Master Files	15: Property Management	Business Data
72	910	F1530	NG	34	2	Expense Participation Class Master	Secondary Master Files	15: Property Management	Business Data
73	910	F15301	AO	35	2	E.P. Class Account Overrides	Files	15: Property Management	Business Data
74	910	F15302	LT	16	1	Ledger Type Groups	Files	15: Property Management	Business Data
75	910	F15303	CH	31	2	E.P. Class Expenses History	History Files	15: Property Management	Business Data
76	910	F1530H	NG	20	1	Expense Participation Class Master Header	Master Files	15: Property Management	Business Data
77	910	F1530HD	HD	10	1	E.P. Class Master Alternate Description	Files	15: Property Management	Business Data
78	910	F1531	OM	28	3	Expense Participation Class Adjustment	Secondary Master Files	15: Property Management	Business Data
79	910	F1531D	OM	11	1	Expense Participation Class Adj. - Alternate Description	Files	15: Property Management	Business Data
80	910	F1532B	NT	34	5	Expense Participation Audit File	History Files	15: Property Management	Business Data
81	910	F1533	NM	12	1	Tenant Class Account Exclusions	Transaction Files	15: Property Management	Business Data
82	910	F1533B	NM	52	1	Tenant Account Exclusions	Master Files	15: Property Management	Business Data
83	910	F1538	NZ	85	1	WF - Expence Participation Register	Secondary Master Files	15: Property Management	Business Data
84	910	F1538B	NZ	152	3	EP Billing Register	Regular Work Files	15: Property Management	Business Data
85	910	F1538B1	GU	39	1	Occupancy Gross Up Audit	Transaction Files	15: Property Management	Business Data
86	910	F1538B2	RD	27	1	Exclusion/Redistribution	Files	15: Property Management	Business Data
87	910	F1539A	AU	33	1	EP Billing Account Adjustments Audit	Files	15: Property Management	Business Data
88	910	F1539C	AU	28	1	EP Billing Class Adjustments Audit File	Files	15: Property Management	Business Data
89	910	F1539E	AU	34	1	EP Billing Account Exclusions Audit	Files	15: Property Management	Business Data
90	910	F1539FC	AU	27	1	EP Billing Adj Factor EP Class Audit	Files	15: Property Management	Business Data
91	910	F1539FL	AU	33	1	EP Billing Adj Factor Lease Audit	Files	15: Property Management	Business Data
92	910	F1540	NR	41	1	Sales Report Control File	Transaction Files	15: Property Management	Business Data
93	910	F1540B	NR	67	7	Sales Report Control	Transaction Files	15: Property Management	Business Data
94	910	F1541	N8	34	1	Tenant Sales History	History Files	15: Property Management	Business Data
95	910	F15410	N9	40	1	Tenant Weekly Sales	History Files	15: Property Management	Business Data
96	910	F1541B	N8	50	4	Tenant Sales History	History Files	15: Property Management	Business Data
97	910	F1541BW	OW	62	1	Sales History Work File	Files	15: Property Management	Business Data
98	910	F1542	OJ	51	2	Projected Sales	Files	15: Property Management	Business Data
99	910	F1543B	OA	79	2	Tenant Sales Analysis Reporting File	Balance Files	15: Property Management	Business Data
100	910	F1544	OB	35	1	Sales Analysis Control File	Secondary Master Files	15: Property Management	Business Data
101	910	F1544B	OB	48	1	Sales Analysis Control	Secondary Master Files	15: Property Management	Business Data
102	910	F1544BD	OB	12	1	Sales Analysis Control - Alternate Description	Extra Features Files	15: Property Management	Business Data
103	910	F1547	OI	28	1	Sales Seasonality	Files	15: Property Management	Business Data
104	910	F1548	N1	61	1	Escalation Billing Register	Transaction Files	15: Property Management	Business Data
105	910	F1548B	N1	72	1	Escalation Billing Register	Transaction Files	15: Property Management	Business Data
106	910	F1549	OL	14	1	Seasonality Models	Files	15: Property Management	Business Data
107	910	F1550	NV	22	1	Escalation Index Master	Secondary Master Files	15: Property Management	Business Data
108	910	F15525W	RT	59	1	PM Statements Credit/Cash Build Workfile	Work Files	15: Property Management	Business Data
109	910	F1565	JF	40	5	Security Deposit Master	Secondary Master Files	15: Property Management	Business Data
110	910	F1570	ND	25	2	Legal Clauses	Master Files	15: Property Management	Business Data
111	910	F15701	NK	25	3	Legal Clause Options Audit	Secondary Master Files	15: Property Management	Business Data
112	910	F157011	NA	14	1	Lease Option Type Header	Master Files	15: Property Management	Business Data
113	910	F157011D	NA	10	1	Lease Option Type Header - Alternate Description	Extra Features Files	15: Property Management	Business Data
114	910	F157012	NC	20	1	Lease Option Type Detail	Master Files	15: Property Management	Business Data
115	910	F157012D	NC	11	1	Lease Option Type Detail - Alternate Description	Extra Features Files	15: Property Management	Business Data
116	910	F15702	NF	24	2	Legal Clause Space Detail	Secondary Master Files	15: Property Management	Business Data
117	910	F157021	NG	22	3	Legal Clause Space Detail Audit	Secondary Master Files	15: Property Management	Business Data
118	910	F15702D	NF	13	1	Legal Clause Space Detail - Alternate Description	Extra Features Files	15: Property Management	Business Data
119	910	F15703	NI	24	3	Legal Clause Amounts	Secondary Master Files	15: Property Management	Business Data
120	910	F159071	NY	24	2	Market/Potential/Renewal Rent Master	Secondary Master Files	15: Property Management	Business Data
121	910	F159071D	NY	13	1	Market/Potential/Renewal Rent Master - Alternate Description	Extra Features Files	15: Property Management	Business Data
122	910	F8915CV1	N7	16	1	Property Management Table Conversion Master Audit	Work Files	15: Property Management	Business Data
123	910	F8915CV2	N9	9	1	Property Management Table Conversion Detail Audit	Work Files	15: Property Management	Business Data

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

123 tables910 | 15