920: Top 10 requests

	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

F4211

Sales Order Detail File

Address Book Master

Item Master

Account Ledger

Purchase Order Detail File

F9671

Software Update Detail Table

F4102

Item Branch File

F0411

Accounts Payable Ledger

F0006

Business Unit Master

F41021

Item Location File

910: Top 10 requests

	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

F0011W

F0011W - WF - Batch To Detail

F76AUI46

CERG A/R -Work File - ARG - 03B - 76A

F4211

Sales Order Detail File

Item Master

Address Book Master

Account Ledger

Item Branch File

Customer Ledger

Item Ledger File

Purchase Order Detail File

812: Top 10 requests

	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

Table

Prefix

Description

F0911

Account Ledger

F4311

Purchase Order Detail File

F0101

Address Book Master

F0006

Business Unit Master

F0411

Accounts Payable Ledger

F4211

Sales Order Detail File

F42119

Sales Order History File

F03012

Customer Master by Line of Business

F0902

Account Balances

F4801

Work Order Master File

2 columns | 812 | CECM | STOCK UDC

	Table	Table Description	Column#	Prefix	Alias	Column Description	Data Type	Edit Type	Length	Decimals
TOP05A: OW HR & PR Foundation
1	F060117	Employee Master - International Data	15	YA	CECM	Census Metrop. Area - Can Emp Equity	String	UDC	2	0
TOP08C: OW HR Canadian
2	F08022	Canadian Employment Equity Workfile	9	YZ	CECM	Census Metrop. Area - Can Emp Equity	String	UDC	2	0

User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.

TOPUDC 05 / CM (Census Metropolitan Area) stock values

	Value	Description	Hard Coded
1		No CMA	N
2	50	St. John's, Newfoundland	N
3	51	Halifax, Nova Scotia	N
4	52	Saint John, New Brunswick	N
5	53	Chicoutimi-Jonquiere, Quebec	N
6	54	Quebec, Quebec	N
7	55	Sherbrooke, Quebec	N
8	56	Trois-Rivieres, Quebec	N
9	57	Montreal, Quebec	N
10	58	Ottawa/Hull, Ontario/Quebec	N
11	59	Oshawa, Ontario	N
12	60	Toronto, Ontario	N
13	61	Hamilton, Ontario	N
14	62	St.Catharines-Niagara, Ontario	N
15	63	Kitchener, Ontario	N
16	64	London, Ontario	N
17	65	Windsor, Ontario	N
18	66	Sudbury, Ontario	N
19	67	Thunder Bay, Ontario	N
20	68	Winnipeg, Manitoba	N
21	69	Regina, Saskatchewan	N
22	70	Saskatoon, Saskatchewan	N
23	71	Calgary, Alberta	N
24	72	Edmonton, Alberta	N
25	73	Vancouver, British Columbia	N
26	74	Victoria, British Columbia	N

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

2 columns | 812 | CECM | STOCK UDC

TOPUDC 05 / CM (Census Metropolitan Area) stock values