	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

155 COLUMNS | 11 INDEXES | 812 | 53 | F5311 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
53: Change Management
1	812	F5311	DK	155	11	Change Request Details Table	Master Files	53: Change Management	No

SQL: selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns. For Create statements, use Allow Null checkboxes and default values inputs to tailor query as required.

SELECT DKMCU, DKCONO, DKLNID, DKREQB, DKCO, DKRQBD, DKDL01, DKPROC, DKSCOS, DKLTC, DKCOAM, DKCQAM, DKCFAM, DKBCAM, DKPTYC, DKCURO, DKCURQ, DKFURC, DKBURC, DKUOCM, DKOQTC, DKQQTC, DKCQTF, DKCBTF, DKANIC, DKCAID, DKMCU5, DKOBJC, DKSUB7, DKDL05, DKSBLC, DKSBTC, DKCDTG, DKR01C, DKDTOC, DKDTQC, DKDTFC, DKCWFF, DKCFB0, DKCOFA, DKCQFA, DKCFFA, DKCBFA, DKSREV, DKLTO, DKTRMO, DKROAM, DKRQAM, DKFRAM, DKBRAM, DKPTYR, DKRURO, DKRURQ, DKFURR, DKFURB, DKUOMR, DKRQTO, DKRQTQ, DKRQTF, DKRQTB, DKMCU6, DKANIR, DKRAID, DKOBJ8, DKSUB8, DKDL06, DKSBLR, DKSBTR, DKDGCG, DKR01R, DKDTOR, DKDTQR, DKFRDT, DKRWFF, DKRFB0, DKROFA, DKRQFA, DKRFFA, DKRBFA, DKSSUB, DKLTS, DKTRM1, DKSOAM, DKSQAM, DKSFAM, DKBSAM, DKPTYS, DKSURO, DKSURQ, DKFURS, DKBURS, DKUOMS, DKSQTO, DKSQTQ, DKSQTF, DKSQTB, DKANIS, DKAIDS, DKMCU7, DKSOBJ, DKSUB9, DKDL07, DKSBL, DKSBTS, DKDCGS, DKR01S, DKFUF2, DKDTOS, DKDTQS, DKDTFS, DKSWFF, DKSFB0, DKSOFA, DKSQFA, DKSFFA, DKSBFA, DKEXTD, DKRQDD, DKQTDD, DKQTRD, DKDOCM, DKDCTM, DKSFXO, DKKCOO, DKLINN, DKAN8V, DKSMSF, DKDSBP, DKDOCO, DKDCTO, DKCOCH, DKLNCT, DKKCO, DKAN8O, DKOPIM, DKDL03, DKCBSF, DKDRVP, DKCRCL, DKCRRM, DKCRCD, DKCRR, DKCRCF, DKCRRD, DKRB01, DKRB02, DKRB03, DKF1A, DKF3T, DKCMDT, DKUSER, DKPID, DKJOBN, DKUPMJ, DKUPMT FROM F5311

TOP 812 | 53 | F5311 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	DKMCU	Business Unit	String	Generic Edit	12	0	Allow NULL?
2	DKCONO	Change Request Number	Numeric	Generic Edit	8	0	Allow NULL?
3	DKLNID	Line Number	Numeric	Generic Edit	6	3	Allow NULL?
4	DKREQB	Number - Requote	Numeric	Generic Edit	8	0	Allow NULL?
5	DKCO	Company	String	Generic Edit	5	0	Allow NULL?
6	DKRQBD	Date - Requote (Julian)	Date	Generic Edit	6	0
7	DKDL01	Description	String	Generic Edit	30	0	Allow NULL?
8	DKPROC	Notice to Proceed	Character	UDC (53 PS)	1	0	Allow NULL?
9	DKSCOS	Status Code Cost	String	Generic Edit	2	0	Allow NULL?
10	DKLTC	Cost Ledger Type	String	UDC (09 LT)	2	0	Allow NULL?
11	DKCOAM	Amount - Original for Cost	Numeric	Generic Edit	15	2	Allow NULL?
12	DKCQAM	Amount Quoted for Cost	Numeric	Generic Edit	15	2	Allow NULL?
13	DKCFAM	Amount Final for Cost	Numeric	Generic Edit	15	2	Allow NULL?
14	DKBCAM	Amount Best for Cost	Numeric	Generic Edit	15	2	Allow NULL?
15	DKPTYC	Pricing Type Cost	Character	Generic Edit	1	0	Allow NULL?
16	DKCURO	Unit Rate - Original Cost	Numeric	Generic Edit	15	4	Allow NULL?
17	DKCURQ	Unit Rate - Quoted Cost	Numeric	Generic Edit	15	4	Allow NULL?
18	DKFURC	Unit Rate - Final Cost	Numeric	Generic Edit	15	4	Allow NULL?
19	DKBURC	Unit Rate - Best Cost	Numeric	Generic Edit	15	4	Allow NULL?
20	DKUOCM	Unit of Measure - Cost	String	UDC (00 UM)	2	0	Allow NULL?
21	DKOQTC	Quantity - Original Cost	Numeric	Generic Edit	15	2	Allow NULL?
22	DKQQTC	Quantity - Quoted Cost	Numeric	Generic Edit	15	2	Allow NULL?
23	DKCQTF	Quantity - Final Cost	Numeric	Generic Edit	15	2	Allow NULL?
24	DKCBTF	Quantity - Best Cost	Numeric	Generic Edit	15	2	Allow NULL?
25	DKANIC	Account Number - Cost	String	Generic Edit	29	0	Allow NULL?
26	DKCAID	Account ID - Cost	String	Generic Edit	8	0	Allow NULL?
27	DKMCU5	Business Unit - Cost	String	Generic Edit	12	0	Allow NULL?
28	DKOBJC	Object Account - Cost	String	Generic Edit	6	0	Allow NULL?
29	DKSUB7	Subsidiary - Cost	String	Generic Edit	8	0	Allow NULL?
30	DKDL05	Description 05	String	Generic Edit	30	0	Allow NULL?
31	DKSBLC	Subledger - G/L Cost	String	Generic Edit	8	0	Allow NULL?
32	DKSBTC	Subledger Type - Cost	Character	UDC (00 ST)	1	0	Allow NULL?
33	DKCDTG	Date - Change	Date	Generic Edit	6	0
34	DKR01C	Category Code - G/L 001 Cost	String	UDC (09 01)	3	0	Allow NULL?
35	DKDTOC	Date - Original Cost	Date	Generic Edit	6	0
36	DKDTQC	Date - Quoted Cost	Date	Generic Edit	6	0
37	DKDTFC	Date - Final Cost	Date	Generic Edit	6	0
38	DKCWFF	WorkFlowCostFlag	Character	Generic Edit	1	0	Allow NULL?
39	DKCFB0	Force Best To Zero Cost	Character	Generic Edit	1	0	Allow NULL?
40	DKCOFA	ForeignAmount - Original for Cost	Numeric	Generic Edit	15	2	Allow NULL?
41	DKCQFA	ForeignAmount - Quoted for Cost	Numeric	Generic Edit	15	2	Allow NULL?
42	DKCFFA	ForeignAmount - Final for Cost	Numeric	Generic Edit	15	2	Allow NULL?
43	DKCBFA	ForeignAmount - Best for Cost	Numeric	Generic Edit	15	2	Allow NULL?
44	DKSREV	Status Code Revenue	String	Generic Edit	2	0	Allow NULL?
45	DKLTO	Revenue Ledger Type	String	UDC (09 LT)	2	0	Allow NULL?
46	DKTRMO	Terms Only	Character	UDC (H00 TR)	1	0	Allow NULL?
47	DKROAM	Amount - Original for Revenue	Numeric	Generic Edit	15	2	Allow NULL?
48	DKRQAM	Amount Quoted for Revenue	Numeric	Generic Edit	15	2	Allow NULL?
49	DKFRAM	Amount Final for Revenue	Numeric	Generic Edit	15	2	Allow NULL?
50	DKBRAM	Amount Best for Revenue	Numeric	Generic Edit	15	2	Allow NULL?
51	DKPTYR	Pricing Type Revenue	Character	Generic Edit	1	0	Allow NULL?
52	DKRURO	Unit Rate - Original Revenue	Numeric	Generic Edit	15	4	Allow NULL?
53	DKRURQ	Unit Rate - Quoted Revenue	Numeric	Generic Edit	15	4	Allow NULL?
54	DKFURR	Unit Rate - Final Revenue	Numeric	Generic Edit	15	4	Allow NULL?
55	DKFURB	Unit Rate - Best Revenue	Numeric	Generic Edit	15	4	Allow NULL?
56	DKUOMR	Unit of Measure - Revenue	String	UDC (00 UM)	2	0	Allow NULL?
57	DKRQTO	Quantity - Original Revenue	Numeric	Generic Edit	15	2	Allow NULL?
58	DKRQTQ	Quantity - Quoted Revenue	Numeric	Generic Edit	15	2	Allow NULL?
59	DKRQTF	Quantity - Final Revenue	Numeric	Generic Edit	15	2	Allow NULL?
60	DKRQTB	Quantity - Best Revenue	Numeric	Generic Edit	15	2	Allow NULL?
61	DKMCU6	Business Unit - Revenue	String	Generic Edit	12	0	Allow NULL?
62	DKANIR	Account Number - Revenue	String	Generic Edit	29	0	Allow NULL?
63	DKRAID	Account ID - Revenue	String	Generic Edit	8	0	Allow NULL?
64	DKOBJ8	Object Account - Revenue	String	Generic Edit	6	0	Allow NULL?
65	DKSUB8	Subsidiary - Revenue	String	Generic Edit	8	0	Allow NULL?
66	DKDL06	Description 06	String	Generic Edit	30	0	Allow NULL?
67	DKSBLR	Subledger - G/L Revenue	String	Generic Edit	8	0	Allow NULL?
68	DKSBTR	Subledger Type - Revenue	Character	UDC (00 ST)	1	0	Allow NULL?
69	DKDGCG	Date - Change	Date	Generic Edit	6	0
70	DKR01R	Category Code - G/L 001 Revenue	String	UDC (09 01)	3	0	Allow NULL?
71	DKDTOR	Date - Original Revenue	Date	Generic Edit	6	0
72	DKDTQR	Date - Quoted Revenue	Date	Generic Edit	6	0
73	DKFRDT	Date - Final Revenue	Date	Generic Edit	6	0
74	DKRWFF	WorkFlowRevenueFlag	Character	Generic Edit	1	0	Allow NULL?
75	DKRFB0	Force Best To Zero Revenue	Character	Generic Edit	1	0	Allow NULL?
76	DKROFA	ForeignAmount - Original for Revenue	Numeric	Generic Edit	15	2	Allow NULL?
77	DKRQFA	ForeignAmount - Quoted for Revenue	Numeric	Generic Edit	15	2	Allow NULL?
78	DKRFFA	ForeignAmount - Final for Revenue	Numeric	Generic Edit	15	2	Allow NULL?
79	DKRBFA	ForeignAmount - Best for Revenue	Numeric	Generic Edit	15	2	Allow NULL?
80	DKSSUB	Status Code Subcontract	String	Generic Edit	2	0	Allow NULL?
81	DKLTS	Subcontract Ledger Type	String	UDC (09 LT)	2	0	Allow NULL?
82	DKTRM1	Terms Only	Character	Generic Edit	1	0	Allow NULL?
83	DKSOAM	Amount - Original for Subcontract	Numeric	Generic Edit	15	2	Allow NULL?
84	DKSQAM	Amount Quoted for Subcontract	Numeric	Generic Edit	15	2	Allow NULL?
85	DKSFAM	Amount Final for Subcontract	Numeric	Generic Edit	15	2	Allow NULL?
86	DKBSAM	Amount Best for Subcontract	Numeric	Generic Edit	15	2	Allow NULL?
87	DKPTYS	Pricing Type Subcontract	Character	Generic Edit	1	0	Allow NULL?
88	DKSURO	Unit Rate - Original Subcontract	Numeric	Generic Edit	15	4	Allow NULL?
89	DKSURQ	Unit Rate - Quoted Subcontract	Numeric	Generic Edit	15	4	Allow NULL?
90	DKFURS	Unit Rate - Final Subcontract	Numeric	Generic Edit	15	4	Allow NULL?
91	DKBURS	Unit Rate - Best Subcontract	Numeric	Generic Edit	15	4	Allow NULL?
92	DKUOMS	Unit of Measure - Subcontract	String	UDC (00 UM)	2	0	Allow NULL?
93	DKSQTO	Quantity - Original Subcontract	Numeric	Generic Edit	15	2	Allow NULL?
94	DKSQTQ	Quantity - Quoted Subcontract	Numeric	Generic Edit	15	2	Allow NULL?
95	DKSQTF	Quantity - Final Subcontract	Numeric	Generic Edit	15	2	Allow NULL?
96	DKSQTB	Quantity - Best Subcontract	Numeric	Generic Edit	15	2	Allow NULL?
97	DKANIS	Account Number - Subcontract	String	Generic Edit	29	0	Allow NULL?
98	DKAIDS	Account ID - Subcontract	String	Generic Edit	8	0	Allow NULL?
99	DKMCU7	Business Unit - Subcontract	String	Generic Edit	12	0	Allow NULL?
100	DKSOBJ	Object Account - Subcontract	String	Generic Edit	6	0	Allow NULL?
101	DKSUB9	Subsidiary - Subcontract	String	Generic Edit	8	0	Allow NULL?
102	DKDL07	Description 07	String	Generic Edit	30	0	Allow NULL?
103	DKSBL	Subledger - G/L	String	Generic Edit	8	0	Allow NULL?
104	DKSBTS	Subledger Type - Subcontract	Character	UDC (00 ST)	1	0	Allow NULL?
105	DKDCGS	Date - Change Subcontract	Date	Generic Edit	6	0
106	DKR01S	Category Code - G/L 001 Subcontract	String	UDC (09 01)	3	0	Allow NULL?
107	DKFUF2	Post Quantities	Character	Generic Edit	1	0	Allow NULL?
108	DKDTOS	Date - Original Subcontract	Date	Generic Edit	6	0
109	DKDTQS	Date - Quoted Subcontract	Date	Generic Edit	6	0
110	DKDTFS	Date - Final Subcontract	Date	Generic Edit	6	0
111	DKSWFF	WorkFlowSubcontractFlag	Character	Generic Edit	1	0	Allow NULL?
112	DKSFB0	Force Best To Zero Subcontract	Character	Generic Edit	1	0	Allow NULL?
113	DKSOFA	ForeignAmount - Original for Subcontract	Numeric	Generic Edit	15	2	Allow NULL?
114	DKSQFA	ForeignAmount - Quoted for Subcontract	Numeric	Generic Edit	15	2	Allow NULL?
115	DKSFFA	ForeignAmount - Final for Subcontract	Numeric	Generic Edit	15	2	Allow NULL?
116	DKSBFA	ForeignAmount - Best for Subcontract	Numeric	Generic Edit	15	2	Allow NULL?
117	DKEXTD	Days - Extend	Numeric	Generic Edit	9	0	Allow NULL?
118	DKRQDD	Days - Required	Numeric	Generic Edit	9	0	Allow NULL?
119	DKQTDD	Date - Quote Due	Date	Generic Edit	6	0
120	DKQTRD	Date - Quote Received	Date	Generic Edit	6	0
121	DKDOCM	Document - Matching(Payment or Item)	Numeric	Generic Edit	8	0	Allow NULL?
122	DKDCTM	Document Type - Matching	String	UDC (00 DT)	2	0	Allow NULL?
123	DKSFXO	Order Suffix	String	Generic Edit	3	0	Allow NULL?
124	DKKCOO	Order Company (Order Number)	String	Generic Edit	5	0	Allow NULL?
125	DKLINN	Line Number	Numeric	Generic Edit	7	3	Allow NULL?
126	DKAN8V	Address Number - Supplier	Numeric	Generic Edit	8	0	Allow NULL?
127	DKSMSF	Subcontract Send Flag	Character	Generic Edit	1	0	Allow NULL?
128	DKDSBP	Date - Subcontract Pushed	Date	Generic Edit	6	0
129	DKDOCO	Document (Order No Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
130	DKDCTO	Order Type	String	UDC (00 DT)	2	0	Allow NULL?
131	DKCOCH	Contract Change Number	String	Generic Edit	3	0	Allow NULL?
132	DKLNCT	Line Number - Contract	Numeric	Generic Edit	7	3	Allow NULL?
133	DKKCO	Document Company	String	Generic Edit	5	0	Allow NULL?
134	DKAN8O	Address Number - Job A/R	Numeric	Generic Edit	8	0	Allow NULL?
135	DKOPIM	Owner Pay Item	String	Generic Edit	15	0	Allow NULL?
136	DKDL03	Description 03	String	Generic Edit	30	0	Allow NULL?
137	DKCBSF	Contract Billing Send Flag	Character	Generic Edit	1	0	Allow NULL?
138	DKDRVP	Date - Revenue Pushed	Date	Generic Edit	6	0
139	DKCRCL	Close Flag	Character	Generic Edit	1	0	Allow NULL?
140	DKCRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC (H00 CY)	1	0	Allow NULL?
141	DKCRCD	Currency Code - From	String	Generic Edit	3	0	Allow NULL?
142	DKCRR	Currency Conversion Rate - Spot Rate	Numeric	Generic Edit	15	0	Allow NULL?
143	DKCRCF	Currency Code - Origin	String	Generic Edit	3	0	Allow NULL?
144	DKCRRD	Currency Conversion Rate - Divisor	Numeric	Generic Edit	15	0	Allow NULL?
145	DKRB01	Initiated By	String	UDC (53 01)	3	0	Allow NULL?
146	DKRB02	Area	String	UDC (53 02)	3	0	Allow NULL?
147	DKRB03	Category Code - Change Orders 03	String	UDC (53 03)	3	0	Allow NULL?
148	DKF1A	Future 1 Amount	Numeric	Generic Edit	15	0	Allow NULL?
149	DKF3T	Future 3 Text	String	Generic Edit	30	0	Allow NULL?
150	DKCMDT	Future Use Date	Date	Generic Edit	6	0
151	DKUSER	User ID	String	Generic Edit	10	0	Allow NULL?
152	DKPID	Program ID	String	Generic Edit	10	0	Allow NULL?
153	DKJOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
154	DKUPMJ	Date - Updated	Date	Generic Edit	6	0
155	DKUPMT	Time - Last Updated	Numeric	Generic Edit	6	0	Allow NULL?

TOP 812 | 53 | F5311 INDEXES

Number

Description

Bus.Unit Chg.Order No. + (Primary/Unique)

Element	Alias	Description	Sequence
1	MCU	Business Unit	Ascending
2	CONO	Change Request Number	Ascending
3	LNID	Line Number	Ascending
4	REQB	Number - Requote	Ascending

Cost Status Code

Element	Alias	Description	Sequence
1	SCOS	Status Code Cost	Ascending

Revenue Status Code

Element	Alias	Description	Sequence
1	SREV	Status Code Revenue	Ascending

Subcontract Status Code

Element	Alias	Description	Sequence
1	SSUB	Status Code Subcontract	Ascending

Owner Addr. No. Chg. Order +

Element	Alias	Description	Sequence
1	AN8O	Address Number - Job A/R	Ascending
2	CONO	Change Request Number	Ascending
3	REQB	Number - Requote	Descending

Bus.Unit Chg. Order No. +

Element	Alias	Description	Sequence
1	MCU	Business Unit	Ascending
2	CONO	Change Request Number	Ascending
3	REQB	Number - Requote	Ascending
4	LNID	Line Number	Ascending

Owner Doc. Doc. Type +

Element	Alias	Description	Sequence
1	DOCO	Document (Order No Invoice etc.)	Ascending
2	DCTO	Order Type	Ascending
3	KCO	Document Company	Ascending
4	CONO	Change Request Number	Ascending
5	REQB	Number - Requote	Descending

Vendor Chg.Order No. +

Element	Alias	Description	Sequence
1	AN8V	Address Number - Supplier	Ascending
2	CONO	Change Request Number	Ascending
3	REQB	Number - Requote	Descending

Subcontract Doc. Doc. Type +

Element	Alias	Description	Sequence
1	DOCM	Document - Matching(Payment or Item)	Ascending
2	DCTM	Document Type - Matching	Ascending
3	KCOO	Order Company (Order Number)	Ascending
4	CONO	Change Request Number	Ascending
5	REQB	Number - Requote	Descending

Bus.Unit Chg.Ord Req# Lin# (D)

Element	Alias	Description	Sequence
1	MCU	Business Unit	Ascending
2	CONO	Change Request Number	Ascending
3	REQB	Number - Requote	Ascending
4	LNID	Line Number	Descending

Bus.Unit Chg.Order Req (D)

Element	Alias	Description	Sequence
1	MCU	Business Unit	Ascending
2	CONO	Change Request Number	Ascending
3	REQB	Number - Requote	Descending

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

155 COLUMNS | 11 INDEXES | 812 | 53 | F5311 TABLE

TOP 812 | 53 | F5311 COLUMNS

TOP 812 | 53 | F5311 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

155 COLUMNS | 11 INDEXES | 812 | 53 | F5311 TABLE

TOP812 | 53 | F5311 COLUMNS

TOP812 | 53 | F5311 INDEXES

TOP 812 | 53 | F5311 COLUMNS

TOP 812 | 53 | F5311 INDEXES