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

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

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

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
53: Change Management
1	920	F5311Z1	DK	160	2	Change Request Details Table Workfile	Master Files	53: Change Management

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

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

160 COLUMNS | 2 INDEXES | 920 | 53 | F5311Z1 TABLE

TOP 920 | 53 | F5311Z1 COLUMNS

TOP 920 | 53 | F5311Z1 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

160 COLUMNS | 2 INDEXES | 920 | 53 | F5311Z1 TABLE

TOP920 | 53 | F5311Z1 COLUMNS

TOP920 | 53 | F5311Z1 INDEXES

TOP 920 | 53 | F5311Z1 COLUMNS

TOP 920 | 53 | F5311Z1 INDEXES