	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

114 COLUMNS | 2 INDEXES | 812 | 40R | F47172 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
40R: Demand Scheduling
1	812	F47172	ED	114	2	EDI Demand Detail	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 EDEDTY, EDEDSQ, EDEKCO, EDEDOC, EDEDCT, EDEDLN, EDEDST, EDEDFT, EDEDDT, EDEDER, EDEDDL, EDEDSP, EDEDBT, EDITM, EDLITM, EDAITM, EDCITM, EDCSTPO, EDCSTPODJ, EDCSTPOTM, EDCSTPOLIN, EDDKID, EDDVAN, EDCIRV, EDYEAR1, EDPTRLSSTS, EDLCRCVDJ, EDLCRCVQTY, EDLCRCVTM, EDLCRCVUOM, EDLCSHPDJ, EDLCSHPQTY, EDLCSHPTM, EDLCSHPUOM, EDLASTSID, EDOPTCUMQY, EDCUMREFNO, EDCCUMRQY, EDCCUMRDJ, EDCCUMRTM, EDCRQQYFM, EDCRQQYPN, EDCRQQYPS, EDCRQSDJFM, EDCRQSTMFM, EDCRQEDJFM, EDCRQETMFM, EDCRQSDJPN, EDCRQSTMPN, EDCRQEDJPN, EDCRQETMPN, EDCRQSDJPS, EDCRQSTMPS, EDCRQEDJPS, EDCRQETMPS, EDCCUMSQY, EDCCUMSDJ, EDCCUMSTM, EDCCUMSUOM, EDFBCUMQY, EDFBCUMSDJ, EDFBCUMEDJ, EDMTCUMQY, EDMTCUMSDJ, EDMTCUMEDJ, EDVINNO, EDASBLNFD, EDASBLNLOC, EDASBNO, EDGCNT, EDCSTORDNO, EDHZCLSNO, EDKBSNO, EDKBENO, EDLABORHR, EDRSVLNFD, EDTRSRTE, EDTRSRTSFX, EDUCARTNO, EDCTLNUM, EDDMD01, EDDMD02, EDDMD03, EDDMD04, EDDMD05, EDDMDREF1, EDDMDREF2, EDURCD, EDURDT, EDURAT, EDURAB, EDURRF, EDUSER, EDPID, EDJOBN, EDUPMJ, EDTDAY, EDCARDNO, EDCIRVQ, EDPRODTYPE, EDRTORSQ, EDRTGDAT, EDRTGTIM, EDDMDREF3, EDDMDREF4, EDDMDREF5, EDDMDREF6, EDDMDREF7, EDDMDREF8, EDDMDREF9, EDDMDREF10, EDSCAC, EDATMCN, EDOFFLNDT FROM F47172

TOP 812 | 40R | F47172 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	EDEDTY	Type Record	Character	UDC (00 RD)	1	0	Allow NULL?
2	EDEDSQ	Record Sequence	Numeric	Generic Edit	2	0	Allow NULL?
3	EDEKCO	Company - Key (EDI - Document Key Co)	String	Generic Edit	5	0	Allow NULL?
4	EDEDOC	EDI - Document Number	Numeric	Generic Edit	9	0	Allow NULL?
5	EDEDCT	EDI - Document Type	String	Generic Edit	2	0	Allow NULL?
6	EDEDLN	EDI - Line Number	Numeric	Generic Edit	7	3	Allow NULL?
7	EDEDST	EDI - Transaction Set Number	String	UDC (40 ST)	6	0	Allow NULL?
8	EDEDFT	EDI - Translation Format	String	Generic Edit	10	0	Allow NULL?
9	EDEDDT	EDI - Transmission Date	Date	Generic Edit	6	0
10	EDEDER	EDI - Send/Receive Indicator	Character	UDC (H00 ED)	1	0	Allow NULL?
11	EDEDDL	EDI - Detail Lines Processed	Numeric	Generic Edit	5	0	Allow NULL?
12	EDEDSP	EDI - Successfully Processed	Character	Generic Edit	1	0	Allow NULL?
13	EDEDBT	EDI - Batch Number	String	Generic Edit	15	0	Allow NULL?
14	EDITM	Item Number - Short	Numeric	Generic Edit	8	0	Allow NULL?
15	EDLITM	2nd Item Number	String	Generic Edit	25	0	Allow NULL?
16	EDAITM	3rd Item Number	String	Generic Edit	25	0	Allow NULL?
17	EDCITM	Item Number - Customer/Supplier	String	Generic Edit	25	0	Allow NULL?
18	EDCSTPO	Customer PO	String	Generic Edit	30	0	Allow NULL?
19	EDCSTPODJ	Date - Customer PO	Date	Generic Edit	6	0
20	EDCSTPOTM	Customer PO Time	Numeric	Generic Edit	6	0	Allow NULL?
21	EDCSTPOLIN	Customer PO Line	String	Generic Edit	5	0	Allow NULL?
22	EDDKID	Dock ID	String	Generic Edit	20	0	Allow NULL?
23	EDDVAN	Address Number - Deliver To	Numeric	Generic Edit	8	0	Allow NULL?
24	EDCIRV	Item Revision Level - Customer/Supplier	String	Generic Edit	20	0	Allow NULL?
25	EDYEAR1	Model Year 1	Numeric	Generic Edit	4	0	Allow NULL?
26	EDPTRLSSTS	Code - Part Release Status	String	Generic Edit	2	0	Allow NULL?
27	EDLCRCVDJ	Date - Last Customer Received	Date	Generic Edit	6	0
28	EDLCRCVQTY	Last Customer Received Quantity	Numeric	Generic Edit	15	0	Allow NULL?
29	EDLCRCVTM	Last Customer Received Time	Numeric	Generic Edit	6	0	Allow NULL?
30	EDLCRCVUOM	Last Customer Received UOM	String	Generic Edit	2	0	Allow NULL?
31	EDLCSHPDJ	Date - Last Customer Shipped	Date	Generic Edit	6	0
32	EDLCSHPQTY	Last Customer Shipped Quantity	Numeric	Generic Edit	15	0	Allow NULL?
33	EDLCSHPTM	Last Customer Shipped Time	Numeric	Generic Edit	6	0	Allow NULL?
34	EDLCSHPUOM	Last Customer Shipped UOM	String	Generic Edit	2	0	Allow NULL?
35	EDLASTSID	Last Shipment Identification Number	String	Generic Edit	16	0	Allow NULL?
36	EDOPTCUMQY	Option - CUM Quantity	Character	Generic Edit	1	0	Allow NULL?
37	EDCUMREFNO	CUM Reference Number	String	Generic Edit	25	0	Allow NULL?
38	EDCCUMRQY	Customer CUM Received Quantity	Numeric	Generic Edit	15	0	Allow NULL?
39	EDCCUMRDJ	Date - Customer CUM Received	Date	Generic Edit	6	0
40	EDCCUMRTM	Customer CUM Received Time	Numeric	Generic Edit	6	0	Allow NULL?
41	EDCRQQYFM	CUM Required Quantity - Firm	Numeric	Generic Edit	15	0	Allow NULL?
42	EDCRQQYPN	CUM Required Quantity - Plan	Numeric	Generic Edit	15	0	Allow NULL?
43	EDCRQQYPS	CUM Required Quantity - Production Seq	Numeric	Generic Edit	15	0	Allow NULL?
44	EDCRQSDJFM	Date - Firm CUM Required Start	Date	Generic Edit	6	0
45	EDCRQSTMFM	CUM Required Start Time - Firm	Numeric	Generic Edit	6	0	Allow NULL?
46	EDCRQEDJFM	Date - Firm CUM Required End	Date	Generic Edit	6	0
47	EDCRQETMFM	CUM Required End Time - Firm	Numeric	Generic Edit	6	0	Allow NULL?
48	EDCRQSDJPN	Date - Plan CUM Required Start	Date	Generic Edit	6	0
49	EDCRQSTMPN	CUM Required Start Time - Plan	Numeric	Generic Edit	6	0	Allow NULL?
50	EDCRQEDJPN	Date - Plan CUM Required End	Date	Generic Edit	6	0
51	EDCRQETMPN	CUM Required End Time - Plan	Numeric	Generic Edit	6	0	Allow NULL?
52	EDCRQSDJPS	Date - Prod Seq CUM Required Start	Date	Generic Edit	6	0
53	EDCRQSTMPS	CUM Required Start Time - Prod Seq	Numeric	Generic Edit	6	0	Allow NULL?
54	EDCRQEDJPS	Date - Prod Seq CUM Required End	Date	Generic Edit	6	0
55	EDCRQETMPS	CUM Required End Time - Prod Seq	Numeric	Generic Edit	6	0	Allow NULL?
56	EDCCUMSQY	Customer CUM Shipped Quantity	Numeric	Generic Edit	15	0	Allow NULL?
57	EDCCUMSDJ	Date - Customer CUM Shipped	Date	Generic Edit	6	0
58	EDCCUMSTM	Customer CUM Shipped Time	Numeric	Generic Edit	6	0	Allow NULL?
59	EDCCUMSUOM	Customer CUM Shipped UOM	String	Generic Edit	2	0	Allow NULL?
60	EDFBCUMQY	Fabrication CUM Quantity	Numeric	Generic Edit	15	0	Allow NULL?
61	EDFBCUMSDJ	Date - Fabrication CUM Start	Date	Generic Edit	6	0
62	EDFBCUMEDJ	Date - Fabrication CUM End	Date	Generic Edit	6	0
63	EDMTCUMQY	Material CUM Quantity	Numeric	Generic Edit	15	0	Allow NULL?
64	EDMTCUMSDJ	Date - Material CUM Start	Date	Generic Edit	6	0
65	EDMTCUMEDJ	Date - Material CUM End	Date	Generic Edit	6	0
66	EDVINNO	Vehicle Identification Number	String	Generic Edit	20	0	Allow NULL?
67	EDASBLNFD	Assembly Line Feed	String	Generic Edit	10	0	Allow NULL?
68	EDASBLNLOC	Assembly Line Location	String	Generic Edit	6	0	Allow NULL?
69	EDASBNO	Assembly Number	String	Generic Edit	15	0	Allow NULL?
70	EDGCNT	Contract Number	String	Generic Edit	12	0	Allow NULL?
71	EDCSTORDNO	Customer Order Number	String	Generic Edit	15	0	Allow NULL?
72	EDHZCLSNO	Hazardous Goods Classification	String	Generic Edit	15	0	Allow NULL?
73	EDKBSNO	Kanban Start Number	String	Generic Edit	15	0	Allow NULL?
74	EDKBENO	Kanban End Number	String	Generic Edit	15	0	Allow NULL?
75	EDLABORHR	Labor Hours	Numeric	Generic Edit	15	0	Allow NULL?
76	EDRSVLNFD	Reserve Line Feed	String	Generic Edit	10	0	Allow NULL?
77	EDTRSRTE	Transportation Route	String	Generic Edit	15	0	Allow NULL?
78	EDTRSRTSFX	Transportation Route Suffix	String	Generic Edit	15	0	Allow NULL?
79	EDUCARTNO	Ultimate Customer's Article Number	String	Generic Edit	15	0	Allow NULL?
80	EDCTLNUM	Control Number	String	Generic Edit	35	0	Allow NULL?
81	EDDMD01	Category Code - Demand 01	String	UDC (40R 01)	3	0	Allow NULL?
82	EDDMD02	Category Code - Demand 02	String	UDC (40R 02)	3	0	Allow NULL?
83	EDDMD03	Category Code - Demand 03	String	UDC (40R 03)	3	0	Allow NULL?
84	EDDMD04	Category Code - Demand 04	String	UDC (40R 04)	3	0	Allow NULL?
85	EDDMD05	Category Code - Demand 05	String	UDC (40R 05)	3	0	Allow NULL?
86	EDDMDREF1	Demand Reference 1	String	Generic Edit	35	0	Allow NULL?
87	EDDMDREF2	Demand Reference 2	String	Generic Edit	35	0	Allow NULL?
88	EDURCD	User Reserved Code	String	Generic Edit	2	0	Allow NULL?
89	EDURDT	User Reserved Date	Date	Generic Edit	6	0
90	EDURAT	User Reserved Amount	Numeric	Generic Edit	15	2	Allow NULL?
91	EDURAB	User Reserved Number	Numeric	Generic Edit	8	0	Allow NULL?
92	EDURRF	User Reserved Reference	String	Generic Edit	15	0	Allow NULL?
93	EDUSER	User ID	String	Generic Edit	10	0	Allow NULL?
94	EDPID	Program ID	String	Generic Edit	10	0	Allow NULL?
95	EDJOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
96	EDUPMJ	Date - Updated	Date	Generic Edit	6	0
97	EDTDAY	Time of Day	Numeric	Generic Edit	6	0	Allow NULL?
98	EDCARDNO	Card Number	String	UDC (40R CD)	4	0	Allow NULL?
99	EDCIRVQ	Item Revision Level Qualifier	String	UDC (40R IQ)	2	0	Allow NULL?
100	EDPRODTYPE	Product Type	String	Generic Edit	30	0	Allow NULL?
101	EDRTORSQ	Routing Order Sequence Number	String	Generic Edit	30	0	Allow NULL?
102	EDRTGDAT	Routing Date	Date	Generic Edit	6	0
103	EDRTGTIM	Routing Time	Numeric	Generic Edit	6	0	Allow NULL?
104	EDDMDREF3	Demand Reference 3	String	Generic Edit	35	0	Allow NULL?
105	EDDMDREF4	Demand Reference 4	String	Generic Edit	35	0	Allow NULL?
106	EDDMDREF5	Demand Reference 5	String	Generic Edit	35	0	Allow NULL?
107	EDDMDREF6	Demand Reference 6	String	Generic Edit	35	0	Allow NULL?
108	EDDMDREF7	Demand Reference 7	String	Generic Edit	35	0	Allow NULL?
109	EDDMDREF8	Demand Reference 8	String	Generic Edit	35	0	Allow NULL?
110	EDDMDREF9	Demand Reference 9	String	Generic Edit	35	0	Allow NULL?
111	EDDMDREF10	Demand Reference 10	String	Generic Edit	35	0	Allow NULL?
112	EDSCAC	Standard Carrier Alpha Code	String	Generic Edit	4	0	Allow NULL?
113	EDATMCN	Authorization To Meet Competition Number	Numeric	Generic Edit	6	0	Allow NULL?
114	EDOFFLNDT	Off Line Date	Date	Generic Edit	6	0

TOP 812 | 40R | F47172 INDEXES

Number

Description

Document Number Doc Type + (Primary/Unique)

Element	Alias	Description	Sequence
1	EDOC	EDI - Document Number	Ascending
2	EDCT	EDI - Document Type	Ascending
3	EKCO	Company - Key (EDI - Document Key Co)	Ascending
4	EDLN	EDI - Line Number	Ascending

Success Proc Rec Seq +

Element	Alias	Description	Sequence
1	EDSP	EDI - Successfully Processed	Ascending
2	EDSQ	Record Sequence	Ascending
3	EKCO	Company - Key (EDI - Document Key Co)	Ascending
4	EDOC	EDI - Document Number	Ascending
5	EDCT	EDI - Document 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

114 COLUMNS | 2 INDEXES | 812 | 40R | F47172 TABLE

TOP 812 | 40R | F47172 COLUMNS

TOP 812 | 40R | F47172 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

114 COLUMNS | 2 INDEXES | 812 | 40R | F47172 TABLE

TOP812 | 40R | F47172 COLUMNS

TOP812 | 40R | F47172 INDEXES

TOP 812 | 40R | F47172 COLUMNS

TOP 812 | 40R | F47172 INDEXES