	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

57 columns | 920 | BCI

	Table	Table Description	Column#	Prefix	Alias	Column Description	Data Type	Edit Type	Length	Decimals
TOP15: Real Estate Management
1	F15011	Billings Generation Control Master	2	NK	BCI	Billing Control ID	Numeric	Generic Edit	8	0
2	F15011B	BIllings Generation Control	2	NK	BCI	Billing Control ID	Numeric	Generic Edit	8	0
3	F15012	Tenant E.P. Class Master	49	NS	BCI	Billing Control ID	Numeric	Generic Edit	8	0
4	F15012B	Tenant E.P. Class Master	56	NS	BCI	Billing Control ID	Numeric	Generic Edit	8	0
5	F15013	Sales Overage Master	67	NO	BCI	Billing Control ID	Numeric	Generic Edit	8	0
6	F15013B	Sales Overage Master File	13	NO	BCI	Billing Control ID	Numeric	Generic Edit	8	0
7	F15014	Product Scales Master	25	NP	BCI	Billing Control ID	Numeric	Generic Edit	8	0
8	F15014B	Product Scales Master	10	NP	BCI	Billing Control ID	Numeric	Generic Edit	8	0
9	F15015	Minimum rent/recoveries Master	22	NQ	BCI	Billing Control ID	Numeric	Generic Edit	8	0
10	F15015B	Min/Max Rents And Recoveries Master	7	NQ	BCI	Billing Control ID	Numeric	Generic Edit	8	0
11	F15016	Tenant Escalation Master	47	NU	BCI	Billing Control ID	Numeric	Generic Edit	8	0
12	F15016B	Tenant Escalation Master	49	NU	BCI	Billing Control ID	Numeric	Generic Edit	8	0
13	F1502	Recurring Billings Master	42	NF	BCI	Billing Control ID	Numeric	Generic Edit	8	0
14	F15020	Extended Billings Master	2	NN	BCI	Billing Control ID	Numeric	Generic Edit	8	0
15	F1502B	Recurring Billings Master	42	NF	BCI	Billing Control ID	Numeric	Generic Edit	8	0
16	F1502WB	Estimated EP Recurring Billings	44	N4	BCI	Billing Control ID	Numeric	Generic Edit	8	0
17	F1505	Management Fee Master	3	ND	BCI	Billing Control ID	Numeric	Generic Edit	8	0
18	F1505B	Management Fee Master	4	ND	BCI	Billing Control ID	Numeric	Generic Edit	8	0
19	F1505H	Revenue Fee Generation History	2	OK	BCI	Billing Control ID	Numeric	Generic Edit	8	0
20	F1505HB	Revenue Fee Generation History	2	OK	BCI	Billing Control ID	Numeric	Generic Edit	8	0
21	F1511	Tenant/Lease Billings Detail	38	NJ	BCI	Billing Control ID	Numeric	Generic Edit	8	0
22	F1511B	Lease Billings Master	38	NJ	BCI	Billing Control ID	Numeric	Generic Edit	8	0
23	F1511H	Tenant/Lease Billings Detail History	38	N#	BCI	Billing Control ID	Numeric	Generic Edit	8	0
24	F1511HB	Lease Billings History	38	NC	BCI	Billing Control ID	Numeric	Generic Edit	8	0
25	F15152	Lease E.P. Caps	3	LC	BCI	Billing Control ID	Numeric	Generic Edit	8	0
26	F151521	Lease E.P. Accounts Not Subject to Cap	3	LO	BCI	Billing Control ID	Numeric	Generic Edit	8	0
27	F15153	Lease Cap History	4	LC	BCI	Billing Control ID	Numeric	Generic Edit	8	0
28	F1525	A/R Fee Interest	26	N0	BCI	Billing Control ID	Numeric	Generic Edit	8	0
29	F1525B	Fees and Interest	27	NM	BCI	Billing Control ID	Numeric	Generic Edit	8	0
30	F1532B	Expense Participation Audit File	34	NT	BCI	Billing Control ID	Numeric	Generic Edit	8	0
31	F1533B	Tenant Account Exclusions	52	NM	BCI	Billing Control ID	Numeric	Generic Edit	8	0
32	F1538	WF - Expence Participation Register	54	NZ	BCI	Billing Control ID	Numeric	Generic Edit	8	0
33	F1538B	EP Billing Register	55	NZ	BCI	Billing Control ID	Numeric	Generic Edit	8	0
34	F1538B1	Occupancy Gross Up Audit	5	GU	BCI	Billing Control ID	Numeric	Generic Edit	8	0
35	F1538B2	Exclusion/Redistribution	13	RD	BCI	Billing Control ID	Numeric	Generic Edit	8	0
36	F1539A	EP Billing Account Adjustments Audit	5	AU	BCI	Billing Control ID	Numeric	Generic Edit	8	0
37	F1539C	EP Billing Class Adjustments Audit File	5	AU	BCI	Billing Control ID	Numeric	Generic Edit	8	0
38	F1539E	EP Billing Account Exclusions Audit	5	AU	BCI	Billing Control ID	Numeric	Generic Edit	8	0
39	F1539FC	EP Billing Adj Factor EP Class Audit	5	AU	BCI	Billing Control ID	Numeric	Generic Edit	8	0
40	F1539FL	EP Billing Adj Factor Lease Audit	5	AU	BCI	Billing Control ID	Numeric	Generic Edit	8	0
41	F1548	Escalation Billing Register	49	N1	BCI	Billing Control ID	Numeric	Generic Edit	8	0
42	F1548B	Escalation Billing Register	50	N1	BCI	Billing Control ID	Numeric	Generic Edit	8	0
43	F1565	Security Deposit Master	18	JF	BCI	Billing Control ID	Numeric	Generic Edit	8	0
TOP15L: Adv Real Estate Forecasting
44	F15L302	AREF Prior Gross Billings	8	PG	BCI	Billing Control ID	Numeric	Generic Edit	8	0
45	F15L38	AREF EP Billing Register	7	NZ	BCI	Billing Control ID	Numeric	Generic Edit	8	0
46	F15L403	AREF Gross Up Processing Audit	4	SH	BCI	Billing Control ID	Numeric	Generic Edit	8	0
TOP48S: Service Billing
47	F4812	Billing Detail Workfile	70	WD	BCI	Billing Control ID	Numeric	Generic Edit	8	0
48	F4812H	Billing Workfile History	70	WD	BCI	Billing Control ID	Numeric	Generic Edit	8	0
49	F4812HS	Billing Workfile History Purged Save	70	WD	BCI	Billing Control ID	Numeric	Generic Edit	8	0
50	F48S411	CSB Pay When Paid Table	1	BZ	BCI	Billing Control ID	Numeric	Generic Edit	8	0
51	F48S910	Billing Detail Journal Workfile	68	W2	BCI	Billing Control ID	Numeric	Generic Edit	8	0
52	F48S912	G/L Link	12	W6	BCI	Billing Control ID	Numeric	Generic Edit	8	0
53	F48SUI01	Billing Detail Print Workfile	70	WD	BCI	Billing Control ID	Numeric	Generic Edit	8	0
TOP52: Contract Billing
54	F5280W	Contract Revenue Summary Work File	18	GY	BCI	Billing Control ID	Numeric	Generic Edit	8	0
TOP74U: United Kingdom Localizations
55	F74U012T	Tenant EP Class Tag - 15	3	PJ	BCI	Billing Control ID	Numeric	Generic Edit	8	0
56	F74U0205	Payment Profile - 15	25	P8	BCI	Billing Control ID	Numeric	Generic Edit	8	0
57	F74U02BT	Recurring Billing Tag - 15	8	P6	BCI	Billing Control ID	Numeric	Generic Edit	8	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

57 columns | 920 | BCI