	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

58 COLUMNS | 2 INDEXES | 920 | 14 | F1404 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
14: Modeling - Planning & Budgeting
1	920	F1404	BY	58	2	Forecast Results - Header	Files	14: Modeling - Planning & Budgeting

TOP 920 | 14 | F1404 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	BYMCU	Business Unit	String	Generic Edit	12	0	Allow NULL?
2	BYAID	Account ID	String	Generic Edit	8	0	Allow NULL?
3	BYRVNUM	Revision Number	String	Generic Edit	10	0	Allow NULL?
4	BYDL01	Description	String	Generic Edit	30	0	Allow NULL?
5	BYOBJ	Object Account	String	Generic Edit	6	0	Allow NULL?
6	BYSUB	Subsidiary	String	Generic Edit	8	0	Allow NULL?
7	BYCO	Company	String	Generic Edit	5	0	Allow NULL?
8	BYFY01	Fiscal Year 01	Numeric	Generic Edit	2	0	Allow NULL?
9	BYCTRY01	Century 01	Numeric	Generic Edit	2	0	Allow NULL?
10	BYFA01	Forecast Amount 01	Numeric	Generic Edit	15	2	Allow NULL?
11	BYFY02	Fiscal Year 02	Numeric	Generic Edit	2	0	Allow NULL?
12	BYCTRY02	Century 02	Numeric	Generic Edit	2	0	Allow NULL?
13	BYFA02	Forecast Amount 02	Numeric	Generic Edit	15	2	Allow NULL?
14	BYFY03	Fiscal Year 03	Numeric	Generic Edit	2	0	Allow NULL?
15	BYCTRY03	Century 03	Numeric	Generic Edit	2	0	Allow NULL?
16	BYFA03	Forecast Amount 03	Numeric	Generic Edit	15	2	Allow NULL?
17	BYFY04	Fiscal Year 04	Numeric	Generic Edit	2	0	Allow NULL?
18	BYCTRY04	Century 04	Numeric	Generic Edit	2	0	Allow NULL?
19	BYFA04	Forecast Amount 04	Numeric	Generic Edit	15	2	Allow NULL?
20	BYFY05	Fiscal Year 05	Numeric	Generic Edit	2	0	Allow NULL?
21	BYCTRY05	Century 05	Numeric	Generic Edit	2	0	Allow NULL?
22	BYFA05	Forecast Amount 05	Numeric	Generic Edit	15	2	Allow NULL?
23	BYFY06	Fiscal Year 06	Numeric	Generic Edit	2	0	Allow NULL?
24	BYCTRY06	Century 06	Numeric	Generic Edit	2	0	Allow NULL?
25	BYFA06	Forecast Amount 06	Numeric	Generic Edit	15	2	Allow NULL?
26	BYFY07	Fiscal Year 07	Numeric	Generic Edit	2	0	Allow NULL?
27	BYCTRY07	Century 07	Numeric	Generic Edit	2	0	Allow NULL?
28	BYFA07	Forecast Amount 07	Numeric	Generic Edit	15	2	Allow NULL?
29	BYFY08	Fiscal Year 08	Numeric	Generic Edit	2	0	Allow NULL?
30	BYCTRY08	Century 08	Numeric	Generic Edit	2	0	Allow NULL?
31	BYFA08	Forecast Amount 08	Numeric	Generic Edit	15	2	Allow NULL?
32	BYFY09	Fiscal Year 09	Numeric	Generic Edit	2	0	Allow NULL?
33	BYCTRY09	Century 09	Numeric	Generic Edit	2	0	Allow NULL?
34	BYFA09	Forecast Amount 09	Numeric	Generic Edit	15	2	Allow NULL?
35	BYFY10	Fiscal Year 10	Numeric	Generic Edit	2	0	Allow NULL?
36	BYCTRY10	Century 10	Numeric	Generic Edit	2	0	Allow NULL?
37	BYFA10	Forecast Amount 10	Numeric	Generic Edit	15	2	Allow NULL?
38	BYFY11	Fiscal Year 11	Numeric	Generic Edit	2	0	Allow NULL?
39	BYCTRY11	Century 11	Numeric	Generic Edit	2	0	Allow NULL?
40	BYFA11	Forecast Amount 11	Numeric	Generic Edit	15	2	Allow NULL?
41	BYFY12	Fiscal Year 12	Numeric	Generic Edit	2	0	Allow NULL?
42	BYCTRY12	Century 12	Numeric	Generic Edit	2	0	Allow NULL?
43	BYFA12	Forecast Amount 12	Numeric	Generic Edit	15	2	Allow NULL?
44	BYFY13	Fiscal Year 13	Numeric	Generic Edit	2	0	Allow NULL?
45	BYCTRY13	Century 13	Numeric	Generic Edit	2	0	Allow NULL?
46	BYFA13	Forecast Amount 13	Numeric	Generic Edit	15	2	Allow NULL?
47	BYFY14	Fiscal Year 14	Numeric	Generic Edit	2	0	Allow NULL?
48	BYCTRY14	Century 14	Numeric	Generic Edit	2	0	Allow NULL?
49	BYFA14	Forecast Amount 14	Numeric	Generic Edit	15	2	Allow NULL?
50	BYFY15	Fiscal Year 15	Numeric	Generic Edit	2	0	Allow NULL?
51	BYCTRY15	Century 15	Numeric	Generic Edit	2	0	Allow NULL?
52	BYFA15	Forecast Amount 15	Numeric	Generic Edit	15	2	Allow NULL?
53	BYLOCKFLG	Lock Flag	Character	Generic Edit	1	0	Allow NULL?
54	BYUSER	User ID	String	Generic Edit	10	0	Allow NULL?
55	BYPID	Program ID	String	Generic Edit	10	0	Allow NULL?
56	BYJOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
57	BYUPMJ	Date - Updated	Date	Generic Edit	6	0
58	BYUPMT	Time - Last Updated	Numeric	Generic Edit	6	0	Allow NULL?

TOP 920 | 14 | F1404 INDEXES

Number

Description

MCU AID RVNUM (Primary/Unique)

Element	Alias	Description	Sequence
1	MCU	Business Unit	Ascending
2	AID	Account ID	Ascending
3	RVNUM	Revision Number	Ascending

CO MCU RVNUM

Element	Alias	Description	Sequence
1	CO	Company	Ascending
2	MCU	Business Unit	Ascending
3	RVNUM	Revision Number	Ascending
4	OBJ	Object Account	Ascending
5	SUB	Subsidiary	Ascending

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

58 COLUMNS | 2 INDEXES | 920 | 14 | F1404 TABLE

TOP 920 | 14 | F1404 COLUMNS

TOP 920 | 14 | F1404 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

58 COLUMNS | 2 INDEXES | 920 | 14 | F1404 TABLE

TOP920 | 14 | F1404 COLUMNS

TOP920 | 14 | F1404 INDEXES

TOP 920 | 14 | F1404 COLUMNS

TOP 920 | 14 | F1404 INDEXES