	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

43 COLUMNS | 3 INDEXES | 920 | 00 | F0007 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
00: Foundation Environment
1	920	F0007	CZ	43	3	Workday Calendar	Extra Features Files	30: Product Data Management	Business Data

TOP 920 | 00 | F0007 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	SQL Create Statement
1	CZCTRY	Century	Numeric	Generic Edit	2	Allow NULL?
2	CZMMCU	Branch	String	Generic Edit	12	Allow NULL?
3	CZYR	Year - Calendar Year	Numeric	Generic Edit	2	Allow NULL?
4	CZMT	Calendar Month	Numeric	Generic Edit	2	Allow NULL?
5	CZSHFT	Shift Code	Character	UDC (06 SH)	1	Allow NULL?
6	CZTD01	Day - Type 01	Character	Generic Edit	1	Allow NULL?
7	CZTD02	Day - Type 02	Character	Generic Edit	1	Allow NULL?
8	CZTD03	Day - Type 03	Character	Generic Edit	1	Allow NULL?
9	CZTD04	Day - Type 04	Character	Generic Edit	1	Allow NULL?
10	CZTD05	Day - Type 05	Character	Generic Edit	1	Allow NULL?
11	CZTD06	Day - Type 06	Character	Generic Edit	1	Allow NULL?
12	CZTD07	Day - Type 07	Character	Generic Edit	1	Allow NULL?
13	CZTD08	Day - Type 08	Character	Generic Edit	1	Allow NULL?
14	CZTD09	Day - Type 09	Character	Generic Edit	1	Allow NULL?
15	CZTD10	Day - Type 10	Character	Generic Edit	1	Allow NULL?
16	CZTD11	Day - Type 11	Character	Generic Edit	1	Allow NULL?
17	CZTD12	Day - Type 12	Character	Generic Edit	1	Allow NULL?
18	CZTD13	Day - Type 13	Character	Generic Edit	1	Allow NULL?
19	CZTD14	Day - Type 14	Character	Generic Edit	1	Allow NULL?
20	CZTD15	Day - Type 15	Character	Generic Edit	1	Allow NULL?
21	CZTD16	Day - Type 16	Character	Generic Edit	1	Allow NULL?
22	CZTD17	Day - Type 17	Character	Generic Edit	1	Allow NULL?
23	CZTD18	Day - Type 18	Character	Generic Edit	1	Allow NULL?
24	CZTD19	Day - Type 19	Character	Generic Edit	1	Allow NULL?
25	CZTD20	Day - Type 20	Character	Generic Edit	1	Allow NULL?
26	CZTD21	Day - Type 21	Character	Generic Edit	1	Allow NULL?
27	CZTD22	Day - Type 22	Character	Generic Edit	1	Allow NULL?
28	CZTD23	Day - Type 23	Character	Generic Edit	1	Allow NULL?
29	CZTD24	Day - Type 24	Character	Generic Edit	1	Allow NULL?
30	CZTD25	Day - Type 25	Character	Generic Edit	1	Allow NULL?
31	CZTD26	Day - Type 26	Character	Generic Edit	1	Allow NULL?
32	CZTD27	Day - Type 27	Character	Generic Edit	1	Allow NULL?
33	CZTD28	Day - Type 28	Character	Generic Edit	1	Allow NULL?
34	CZTD29	Day - Type 29	Character	Generic Edit	1	Allow NULL?
35	CZTD30	Day - Type 30	Character	Generic Edit	1	Allow NULL?
36	CZTD31	Day - Type 31	Character	Generic Edit	1	Allow NULL?
37	CZJOBN	Work Station ID	String	Generic Edit	10	Allow NULL?
38	CZPID	Program ID	String	Generic Edit	10	Allow NULL?
39	CZUSER	User ID	String	Generic Edit	10	Allow NULL?
40	CZUPMJ	Date - Updated	Date	Generic Edit	6
41	CZTDAY	Time of Day	Numeric	Generic Edit	6	Allow NULL?
42	CZWDCT	Work Day Calendar Type	String	UDC (42 WD)	10	Allow NULL?
43	CZWDCK	Work Day Calendar Key	String	Generic Edit	10	Allow NULL?

TOP 920 | 00 | F0007 INDEXES

Number

Description

Branch Calendar Type +B (Unique)

Element	Alias	Description	Sequence
1	MMCU	Branch	Ascending
2	WDCT	Work Day Calendar Type	Ascending
3	WDCK	Work Day Calendar Key	Ascending
4	YR	Year - Calendar Year	Ascending
5	MT	Calendar Month	Ascending
6	SHFT	Shift Code	Ascending

Branch Calendar Type +A (Primary/Unique)

Element	Alias	Description	Sequence
1	MMCU	Branch	Ascending
2	WDCT	Work Day Calendar Type	Ascending
3	WDCK	Work Day Calendar Key	Ascending
4	CTRY	Century	Ascending
5	YR	Year - Calendar Year	Ascending
6	MT	Calendar Month	Ascending
7	SHFT	Shift Code	Ascending

Branch Calendar Name

Element	Alias	Description	Sequence
1	MMCU	Branch	Ascending
2	WDCK	Work Day Calendar Key	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

43 COLUMNS | 3 INDEXES | 920 | 00 | F0007 TABLE

TOP 920 | 00 | F0007 COLUMNS

TOP 920 | 00 | F0007 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

43 COLUMNS | 3 INDEXES | 920 | 00 | F0007 TABLE

TOP920 | 00 | F0007 COLUMNS

TOP920 | 00 | F0007 INDEXES

TOP 920 | 00 | F0007 COLUMNS

TOP 920 | 00 | F0007 INDEXES