	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

43 COLUMNS | 6 INDEXES | 812 | 00 | F5301 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
00: Foundation Environment
1	812	F5301	DI	43	6	Change Request Master Table	Master Files	53: Change Management	AS400 Coexistence Tables

TOP 812 | 00 | F5301 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	SQL Create Statement
1	DICONO	Change Request Number	Numeric	Generic Edit	8	Allow NULL?
2	DIMCU	Business Unit	String	Generic Edit	12	Allow NULL?
3	DIDL01	Description	String	Generic Edit	30	Allow NULL?
4	DIRMK	Name - Remark	String	Generic Edit	30	Allow NULL?
5	DICREF	Change Request Reference Number 1	String	Generic Edit	25	Allow NULL?
6	DICRF2	Change Request Reference Number 2	String	Generic Edit	10	Allow NULL?
7	DICRF3	Change Request Reference Number 3	String	Generic Edit	12	Allow NULL?
8	DIAREQ	Address Number - Requested By	Numeric	Generic Edit	8	Allow NULL?
9	DIANO	Address Number - Originator	Numeric	Generic Edit	8	Allow NULL?
10	DIAPRV	Address Number - Approved by	Numeric	Generic Edit	8	Allow NULL?
11	DIAN8V	Address Number - Supplier	Numeric	Generic Edit	8	Allow NULL?
12	DIBSTC	Status Code	Character	UDC (53 ST)	1	Allow NULL?
13	DIPRTC	Priority Code	Character	UDC (53 PR)	1	Allow NULL?
14	DITYPB	Type Change Request	Character	UDC (53 TY)	1	Allow NULL?
15	DIREQB	Number - Requote	Numeric	Generic Edit	8	Allow NULL?
16	DIRQBD	Date - Requote (Julian)	Date	Generic Edit	6
17	DIOREQ	Owner Change Required	Character	UDC (53 OR)	1	Allow NULL?
18	DISUB	Subsidiary	String	Generic Edit	8	Allow NULL?
19	DIPONO	Parent Change Order Number	Numeric	Generic Edit	8	Allow NULL?
20	DIDRQJ	Date - Requested	Date	Generic Edit	6
21	DIAPRD	Date - Approved (Julian)	Date	Generic Edit	6
22	DIPNST	Date - Planned Start (Julian)	Date	Generic Edit	6
23	DIPNFN	Date - Planned Finish (Julian)	Date	Generic Edit	6
24	DIUDT1	Transport Reason Code	Date	Generic Edit	6
25	DIUDT2	Date - User Defined #2	Date	Generic Edit	6
26	DIUDT3	Date - User Defined #3	Date	Generic Edit	6
27	DIRB01	Initiated By	String	UDC (53 01)	3	Allow NULL?
28	DIRB02	Area	String	UDC (53 02)	3	Allow NULL?
29	DIRB03	Category Code - Change Orders 03	String	UDC (53 03)	3	Allow NULL?
30	DIRB04	Category Code - Change Orders 04	String	UDC (53 04)	3	Allow NULL?
31	DIRB05	Category Code - Change Orders 05	String	UDC (53 05)	3	Allow NULL?
32	DIRB06	Category Code - Change Orders 06	String	UDC (53 06)	3	Allow NULL?
33	DIRB07	Category Code - Change Orders 07	String	UDC (53 07)	3	Allow NULL?
34	DIRB08	Category Code - Change Orders 08	String	UDC (53 08)	3	Allow NULL?
35	DIRB09	Category Code - Change Orders 09	String	UDC (53 09)	3	Allow NULL?
36	DIRB10	Category Code - Change Orders 10	String	UDC (53 10)	3	Allow NULL?
37	DIUSER	User ID	String	Generic Edit	10	Allow NULL?
38	DIPID	Program ID	String	Generic Edit	10	Allow NULL?
39	DIUPMJ	Date - Updated	Date	Generic Edit	6
40	DIJOBN	Work Station ID	String	Generic Edit	10	Allow NULL?
41	DICRFC	Change Request Reference # - Compressed	String	Generic Edit	20	Allow NULL?
42	DIUPMT	Time - Last Updated	Numeric	Generic Edit	6	Allow NULL?
43	DISBLI	Subledger Inactive Code	Character	UDC (00 SI)	1	Allow NULL?

TOP 812 | 00 | F5301 INDEXES

Number

Description

Cost Center Change Request (Primary/Unique)

Element	Alias	Description	Sequence
1	MCU	Business Unit	Ascending
2	CONO	Change Request Number	Ascending

Business Unit Chg Request +

Element	Alias	Description	Sequence
1	MCU	Business Unit	Ascending
2	CONO	Change Request Number	Ascending
3	TYPB	Type Change Request	Ascending
4	PRTC	Priority Code	Ascending

Originator Chg Request +

Element	Alias	Description	Sequence
1	ANO	Address Number - Originator	Ascending
2	CONO	Change Request Number	Ascending
3	BSTC	Status Code	Ascending
4	PRTC	Priority Code	Ascending

Ref Num Compressed Chg Req +

Element	Alias	Description	Sequence
1	CRFC	Change Request Reference # - Compressed	Ascending
2	CONO	Change Request Number	Ascending
3	BSTC	Status Code	Ascending
4	PRTC	Priority Code	Ascending

Approved By Chg Request +

Element	Alias	Description	Sequence
1	APRV	Address Number - Approved by	Ascending
2	CONO	Change Request Number	Ascending
3	BSTC	Status Code	Ascending
4	PRTC	Priority Code	Ascending

Reference 3 Chg Request +

Element	Alias	Description	Sequence
1	CRF3	Change Request Reference Number 3	Ascending
2	CONO	Change Request Number	Ascending
3	BSTC	Status Code	Ascending
4	PRTC	Priority Code	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 | 6 INDEXES | 812 | 00 | F5301 TABLE

TOP 812 | 00 | F5301 COLUMNS

TOP 812 | 00 | F5301 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 | 6 INDEXES | 812 | 00 | F5301 TABLE

TOP812 | 00 | F5301 COLUMNS

TOP812 | 00 | F5301 INDEXES

TOP 812 | 00 | F5301 COLUMNS

TOP 812 | 00 | F5301 INDEXES