	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

69 COLUMNS | 2 INDEXES | 920 | 40R | F40R12WF TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
40R: Demand Scheduling
1	920	F40R12WF	CQ	69	2	CUM Rollback Workfile	Files	40R: Demand Scheduling	Business Data

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 CQJOBS, CQCTID, CQMATH01, CQCUMID, CQMCU, CQCITM, CQAN8, CQSHAN, CQCSTPO, CQCUMUV1, CQCUMUV2, CQCUMUV3, CQCUMUT1, CQCUMUT2, CQCUMUT3, CQCUMTYPE, CQCUMADJ, CQSHPN, CQCUMREFNO, CQCUMS, CQCUMSADJ, CQADDJ, CQADTM, CQCCUMRQY, CQCCUMRDJ, CQCCUMRTM, CQCRQQYFM, CQCRQQYPN, CQCRQQYPS, CQCRQSDJFM, CQCRQSTMFM, CQCRQEDJFM, CQCRQETMFM, CQCRQSDJPN, CQCRQSTMPN, CQCRQEDJPN, CQCRQETMPN, CQCRQSDJPS, CQCRQSTMPS, CQCRQEDJPS, CQCRQETMPS, CQCCUMSQY, CQCCUMSDJ, CQCCUMSTM, CQCCUMSUOM, CQFBCUMQY, CQFBCUMSDJ, CQFBCUMEDJ, CQMTCUMQY, CQMTCUMSDJ, CQMTCUMEDJ, CQHFBCUMQY, CQHFBRLDJ, CQHFBRLNO, CQHMTCUMQY, CQHMTRLDJ, CQHMTRLNO, CQCUMRBDJ, CQCUMRBTM, CQURCD, CQURDT, CQURAT, CQURAB, CQURRF, CQUSER, CQPID, CQJOBN, CQUPMJ, CQTDAY FROM F40R12WF

TOP 920 | 40R | F40R12WF COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	CQJOBS	Job Number	Numeric	Generic Edit	8	0	Allow NULL?
2	CQCTID	Computer ID	String	Generic Edit	15	0	Allow NULL?
3	CQMATH01	Math Numeric 01	Numeric	Generic Edit	15	2	Allow NULL?
4	CQCUMID	CUM ID	Numeric	Generic Edit	15	0	Allow NULL?
5	CQMCU	Business Unit	String	Generic Edit	12	0	Allow NULL?
6	CQCITM	Item Number - Customer/Supplier	String	Generic Edit	25	0	Allow NULL?
7	CQAN8	Address Number	Numeric	Generic Edit	8	0	Allow NULL?
8	CQSHAN	Address Number - Ship To	Numeric	Generic Edit	8	0	Allow NULL?
9	CQCSTPO	Customer PO	String	Generic Edit	30	0	Allow NULL?
10	CQCUMUV1	CUM User Field Value 1	String	Generic Edit	30	0	Allow NULL?
11	CQCUMUV2	CUM User Field Value 2	String	Generic Edit	30	0	Allow NULL?
12	CQCUMUV3	CUM User Field Value 3	String	Generic Edit	30	0	Allow NULL?
13	CQCUMUT1	CUM User Field Type 1	String	UDC (40R UF)	3	0	Allow NULL?
14	CQCUMUT2	CUM User Field Type 2	String	UDC (40R UF)	3	0	Allow NULL?
15	CQCUMUT3	CUM User Field Type 3	String	UDC (40R UF)	3	0	Allow NULL?
16	CQCUMTYPE	CUM Type	Character	Generic Edit	1	0	Allow NULL?
17	CQCUMADJ	Code - CUM Adjustment	String	UDC (40R CA)	2	0	Allow NULL?
18	CQSHPN	Shipment Number	Numeric	Generic Edit	8	0	Allow NULL?
19	CQCUMREFNO	CUM Reference Number	String	Generic Edit	25	0	Allow NULL?
20	CQCUMS	CUM Quantity Shipped	Numeric	Generic Edit	15	0	Allow NULL?
21	CQCUMSADJ	CUM Shipped Adjustment	Numeric	Generic Edit	15	0	Allow NULL?
22	CQADDJ	Date - Actual Ship Date	Date	Generic Edit	6	0
23	CQADTM	Actual Shipment Time	Numeric	Generic Edit	6	0	Allow NULL?
24	CQCCUMRQY	Customer CUM Received Quantity	Numeric	Generic Edit	15	0	Allow NULL?
25	CQCCUMRDJ	Date - Customer CUM Received	Date	Generic Edit	6	0
26	CQCCUMRTM	Customer CUM Received Time	Numeric	Generic Edit	6	0	Allow NULL?
27	CQCRQQYFM	CUM Required Quantity - Firm	Numeric	Generic Edit	15	0	Allow NULL?
28	CQCRQQYPN	CUM Required Quantity - Plan	Numeric	Generic Edit	15	0	Allow NULL?
29	CQCRQQYPS	CUM Required Quantity - Production Seq	Numeric	Generic Edit	15	0	Allow NULL?
30	CQCRQSDJFM	Date - Firm CUM Required Start	Date	Generic Edit	6	0
31	CQCRQSTMFM	CUM Required Start Time - Firm	Numeric	Generic Edit	6	0	Allow NULL?
32	CQCRQEDJFM	Date - Firm CUM Required End	Date	Generic Edit	6	0
33	CQCRQETMFM	CUM Required End Time - Firm	Numeric	Generic Edit	6	0	Allow NULL?
34	CQCRQSDJPN	Date - Plan CUM Required Start	Date	Generic Edit	6	0
35	CQCRQSTMPN	CUM Required Start Time - Plan	Numeric	Generic Edit	6	0	Allow NULL?
36	CQCRQEDJPN	Date - Plan CUM Required End	Date	Generic Edit	6	0
37	CQCRQETMPN	CUM Required End Time - Plan	Numeric	Generic Edit	6	0	Allow NULL?
38	CQCRQSDJPS	Date - Prod Seq CUM Required Start	Date	Generic Edit	6	0
39	CQCRQSTMPS	CUM Required Start Time - Prod Seq	Numeric	Generic Edit	6	0	Allow NULL?
40	CQCRQEDJPS	Date - Prod Seq CUM Required End	Date	Generic Edit	6	0
41	CQCRQETMPS	CUM Required End Time - Prod Seq	Numeric	Generic Edit	6	0	Allow NULL?
42	CQCCUMSQY	Customer CUM Shipped Quantity	Numeric	Generic Edit	15	0	Allow NULL?
43	CQCCUMSDJ	Date - Customer CUM Shipped	Date	Generic Edit	6	0
44	CQCCUMSTM	Customer CUM Shipped Time	Numeric	Generic Edit	6	0	Allow NULL?
45	CQCCUMSUOM	Customer CUM Shipped UOM	String	Generic Edit	2	0	Allow NULL?
46	CQFBCUMQY	Fabrication CUM Quantity	Numeric	Generic Edit	15	0	Allow NULL?
47	CQFBCUMSDJ	Date - Fabrication CUM Start	Date	Generic Edit	6	0
48	CQFBCUMEDJ	Date - Fabrication CUM End	Date	Generic Edit	6	0
49	CQMTCUMQY	Material CUM Quantity	Numeric	Generic Edit	15	0	Allow NULL?
50	CQMTCUMSDJ	Date - Material CUM Start	Date	Generic Edit	6	0
51	CQMTCUMEDJ	Date - Material CUM End	Date	Generic Edit	6	0
52	CQHFBCUMQY	High Fabrication CUM Quantity	Numeric	Generic Edit	15	0	Allow NULL?
53	CQHFBRLDJ	Date - High Fabrication Release	Date	Generic Edit	6	0
54	CQHFBRLNO	High Fabrication Release Number	String	Generic Edit	10	0	Allow NULL?
55	CQHMTCUMQY	High Material CUM Quantity	Numeric	Generic Edit	15	0	Allow NULL?
56	CQHMTRLDJ	Date - High Material Release	Date	Generic Edit	6	0
57	CQHMTRLNO	High Material Release Number	String	Generic Edit	10	0	Allow NULL?
58	CQCUMRBDJ	Date - CUM Rollback	Date	Generic Edit	6	0
59	CQCUMRBTM	CUM Rollback Time	Numeric	Generic Edit	6	0	Allow NULL?
60	CQURCD	User Reserved Code	String	Generic Edit	2	0	Allow NULL?
61	CQURDT	User Reserved Date	Date	Generic Edit	6	0
62	CQURAT	User Reserved Amount	Numeric	Generic Edit	15	2	Allow NULL?
63	CQURAB	User Reserved Number	Numeric	Generic Edit	8	0	Allow NULL?
64	CQURRF	User Reserved Reference	String	Generic Edit	15	0	Allow NULL?
65	CQUSER	User ID	String	Generic Edit	10	0	Allow NULL?
66	CQPID	Program ID	String	Generic Edit	10	0	Allow NULL?
67	CQJOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
68	CQUPMJ	Date - Updated	Date	Generic Edit	6	0
69	CQTDAY	Time of Day	Numeric	Generic Edit	6	0	Allow NULL?

TOP 920 | 40R | F40R12WF INDEXES

Number

Description

Job Number Computer Id +A (Primary/Unique)

Element	Alias	Description	Sequence
1	JOBS	Job Number	Ascending
2	CTID	Computer ID	Ascending
3	MATH01	Math Numeric 01	Ascending
4	CUMID	CUM ID	Ascending

Alternate Key

Element	Alias	Description	Sequence
1	MCU	Business Unit	Ascending
2	CITM	Item Number - Customer/Supplier	Ascending
3	AN8	Address Number	Ascending
4	SHAN	Address Number - Ship To	Ascending
5	CSTPO	Customer PO	Ascending
6	CUMUV1	CUM User Field Value 1	Ascending
7	CUMUV2	CUM User Field Value 2	Ascending
8	CUMUV3	CUM User Field Value 3	Ascending
9	CUMUT1	CUM User Field Type 1	Ascending
10	CUMUT2	CUM User Field Type 2	Ascending
11	CUMUT3	CUM User Field Type 3	Ascending
12	CUMTYPE	CUM Type	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

69 COLUMNS | 2 INDEXES | 920 | 40R | F40R12WF TABLE

TOP 920 | 40R | F40R12WF COLUMNS

TOP 920 | 40R | F40R12WF 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

69 COLUMNS | 2 INDEXES | 920 | 40R | F40R12WF TABLE

TOP920 | 40R | F40R12WF COLUMNS

TOP920 | 40R | F40R12WF INDEXES

TOP 920 | 40R | F40R12WF COLUMNS

TOP 920 | 40R | F40R12WF INDEXES