	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

159 COLUMNS | 14 INDEXES | 812 | 46 | F4611 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
46: Warehouse Management
1	812	F4611	R2	159	14	Warehouse Suggestions	Transaction Files	46: Warehouse Management	AS400 Coexistence Tables

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 R2TYFL, R2OCDE, R2RQBT, R2RQSQ, R2SGBT, R2SGSQ, R2PWAV, R2PTSK, R2TRIP, R2MCU, R2KCOO, R2DOCO, R2DCTO, R2LNID, R2NLIN, R2SFXO, R2CLID, R2ITM, R2LITM, R2AITM, R2UML1, R2TQL1, R2EQL1, R2UML2, R2QPL2, R2TQL2, R2EQL2, R2UML3, R2QPL3, R2TQL3, R2EQL3, R2UML4, R2QPL4, R2TQL4, R2EQL4, R2CPNB, R2UML5, R2QPL5, R2TQL5, R2EQL5, R2UOM1, R2TQTY, R2CUBE, R2VUMD, R2WEIT, R2UWUM, R2LDFS, R2FLOC, R2FLOT, R2STNF, R2LDTS, R2TLOC, R2TLOT, R2STNT, R2LOTP, R2LOTG, R2MERG, R2EQTY, R2CRMT, R2BACK, R2APTS, R2COMM, R2ITCM, R2DSC1, R2DSC2, R2INMG, R2VR01, R2PALC, R2MORD, R2RLIT, R2KTLN, R2CPNT, R2RKIT, R2KTP, R2KTBL, R2PTPH, R2ZIP, R2SRP1, R2SRP2, R2SRP3, R2SRP4, R2SRP5, R2PRP6, R2PRP7, R2PRP8, R2PRP9, R2MPUT, R2PUTP, R2SEQ, R2RCDJ, R2TRDJ, R2DRQJ, R2PDDJ, R2PACK, R2RPCK, R2EKEY, R2CODR, R2PSTB, R2RESX, R2PZON, R2KZON, R2ZONR, R2AISL, R2BIN, R2LA03, R2LA04, R2LA05, R2LA06, R2LA07, R2LA08, R2LA09, R2LA10, R2WSQP, R2WSQQ, R2WSQR, R2MMTH, R2AN8, R2SHAN, R2LNTY, R2PRIO, R2CARS, R2ROUT, R2STOP, R2ZON, R2CTNF, R2VSUG, R2PHAS, R2RSBT, R2RSSQ, R2IUSE, R2TREX, R2DTCR, R2TMCR, R2DTPT, R2TMPT, R2TRPR, R2URCD, R2URDT, R2URAT, R2URAB, R2URRF, R2RCDS, R2USER, R2PID, R2JOBN, R2UPMJ, R2TDAY, R2UKID, R2CKID, R2VR03, R2SHPN, R2LDNM, R2VMCU, R2PLPNU, R2LPNUF, R2LPNUT, R2PSJOBNO, R2JOBSQ, R2DELBATCH FROM F4611

TOP 812 | 46 | F4611 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	R2TYFL	Code - Warehouse	Character	Generic Edit	1	0	Allow NULL?
2	R2OCDE	Code - Origin	String	Generic Edit	2	0	Allow NULL?
3	R2RQBT	Batch Number - Requests	Numeric	Generic Edit	8	0	Allow NULL?
4	R2RQSQ	Sequence Number - Request	Numeric	Generic Edit	7	3	Allow NULL?
5	R2SGBT	Batch Number - Suggestions	Numeric	Generic Edit	8	0	Allow NULL?
6	R2SGSQ	Sequence Number - Suggestion	Numeric	Generic Edit	7	3	Allow NULL?
7	R2PWAV	Number - Wave	Numeric	Generic Edit	8	0	Allow NULL?
8	R2PTSK	Number - Warehouse Task	Numeric	Generic Edit	8	0	Allow NULL?
9	R2TRIP	Number - Trip	Numeric	Generic Edit	7	3	Allow NULL?
10	R2MCU	Business Unit	String	Generic Edit	12	0	Allow NULL?
11	R2KCOO	Order Company (Order Number)	String	Generic Edit	5	0	Allow NULL?
12	R2DOCO	Document (Order No Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
13	R2DCTO	Order Type	String	UDC (00 DT)	2	0	Allow NULL?
14	R2LNID	Line Number	Numeric	Generic Edit	6	3	Allow NULL?
15	R2NLIN	Number of Lines	Numeric	Generic Edit	5	0	Allow NULL?
16	R2SFXO	Order Suffix	String	Generic Edit	3	0	Allow NULL?
17	R2CLID	Confirmed Line Number	Numeric	Generic Edit	6	3	Allow NULL?
18	R2ITM	Item Number - Short	Numeric	Generic Edit	8	0	Allow NULL?
19	R2LITM	2nd Item Number	String	Generic Edit	25	0	Allow NULL?
20	R2AITM	3rd Item Number	String	Generic Edit	25	0	Allow NULL?
21	R2UML1	Unit of Measure - Level 1	String	UDC (00 UM)	2	0	Allow NULL?
22	R2TQL1	Quantity - Total Level 1	Numeric	Generic Edit	15	2	Allow NULL?
23	R2EQL1	Container Code - Level 1	String	UDC (46 EQ)	5	0	Allow NULL?
24	R2UML2	Unit of Measure - Level 2	String	UDC (00 UM)	2	0	Allow NULL?
25	R2QPL2	Quantity per - Level 2	Numeric	Generic Edit	15	2	Allow NULL?
26	R2TQL2	Quantity - Total Level 2	Numeric	Generic Edit	15	2	Allow NULL?
27	R2EQL2	Container Code - Level 2	String	UDC (46 EQ)	5	0	Allow NULL?
28	R2UML3	Unit of Measure - Level 3	String	UDC (00 UM)	2	0	Allow NULL?
29	R2QPL3	Quantity per - Level 3	Numeric	Generic Edit	15	2	Allow NULL?
30	R2TQL3	Quantity - Total Level 3	Numeric	Generic Edit	15	2	Allow NULL?
31	R2EQL3	Container Code - Level 3	String	UDC (46 EQ)	5	0	Allow NULL?
32	R2UML4	Unit of Measure - Level 4	String	UDC (00 UM)	2	0	Allow NULL?
33	R2QPL4	Quantity per - Level 4	Numeric	Generic Edit	15	2	Allow NULL?
34	R2TQL4	Quantity - Total Level 4	Numeric	Generic Edit	15	2	Allow NULL?
35	R2EQL4	Container Code - Level 4	String	UDC (46 EQ)	5	0	Allow NULL?
36	R2CPNB	Component Line Number BOM	Numeric	Generic Edit	8	2	Allow NULL?
37	R2UML5	Unit of Measure - Level 5	String	UDC (00 UM)	2	0	Allow NULL?
38	R2QPL5	Quantity per - Level 5	Numeric	Generic Edit	15	2	Allow NULL?
39	R2TQL5	Quantity - Total Level 5	Numeric	Generic Edit	15	2	Allow NULL?
40	R2EQL5	Container Code - Level 5	String	UDC (46 EQ)	5	0	Allow NULL?
41	R2UOM1	Unit of Measure - Primary	String	UDC (00 UM)	2	0	Allow NULL?
42	R2TQTY	Quantity -Total	Numeric	Generic Edit	15	2	Allow NULL?
43	R2CUBE	Amount - Used Cubes	Numeric	Generic Edit	15	2	Allow NULL?
44	R2VUMD	Unit of Measure - Volume Display	String	UDC (00 UM)	2	0	Allow NULL?
45	R2WEIT	Amount - Used Weight	Numeric	Generic Edit	15	2	Allow NULL?
46	R2UWUM	Unit of Measure - Weight	String	UDC (00 UM)	2	0	Allow NULL?
47	R2LDFS	Sequence Number - Location Detail (From)	Numeric	Generic Edit	8	0	Allow NULL?
48	R2FLOC	Location - From	String	Generic Edit	20	0	Allow NULL?
49	R2FLOT	Lot - From	String	Generic Edit	30	0	Allow NULL?
50	R2STNF	Storage Unit Number - From	Numeric	Generic Edit	8	0	Allow NULL?
51	R2LDTS	Sequence Number - Location Detail (To)	Numeric	Generic Edit	8	0	Allow NULL?
52	R2TLOC	Location - To	String	Generic Edit	20	0	Allow NULL?
53	R2TLOT	Lot - To	String	Generic Edit	30	0	Allow NULL?
54	R2STNT	Storage Unit Number - To	Numeric	Generic Edit	8	0	Allow NULL?
55	R2LOTP	Lot Potency	Numeric	Generic Edit	15	3	Allow NULL?
56	R2LOTG	Lot Grade	String	UDC (40 LG)	3	0	Allow NULL?
57	R2MERG	Top Off (Y/N)	Character	Generic Edit	1	0	Allow NULL?
58	R2EQTY	Container Code	String	UDC (46 EQ)	5	0	Allow NULL?
59	R2CRMT	Carton Recommendation Method	Character	UDC (H46 CR)	1	0	Allow NULL?
60	R2BACK	Backorders Allowed (Y/N)	Character	Generic Edit	1	0	Allow NULL?
61	R2APTS	Partial Line Shipments Allowed (Y/N)	Character	Generic Edit	1	0	Allow NULL?
62	R2COMM	Committed (H/S)	Character	UDC (H42 CP)	1	0	Allow NULL?
63	R2ITCM	In Transit Committed (Y/N)	Character	Generic Edit	1	0	Allow NULL?
64	R2DSC1	Description	String	Generic Edit	30	0	Allow NULL?
65	R2DSC2	Description - Line 2	String	Generic Edit	30	0	Allow NULL?
66	R2INMG	Print Message	String	UDC (40 PM)	10	0	Allow NULL?
67	R2VR01	Reference	String	Generic Edit	25	0	Allow NULL?
68	R2PALC	Pallet Control	Character	Generic Edit	1	0	Allow NULL?
69	R2MORD	Merge Orders (Y/N)	Character	Generic Edit	1	0	Allow NULL?
70	R2RLIT	Item Number - Related (Kit)	String	Generic Edit	8	0	Allow NULL?
71	R2KTLN	Kit Master Line Number	Numeric	Generic Edit	6	3	Allow NULL?
72	R2CPNT	Component Line Number	Numeric	Generic Edit	4	1	Allow NULL?
73	R2RKIT	Related Kit Component	Numeric	Generic Edit	8	0	Allow NULL?
74	R2KTP	Number of Component Per Parent	Numeric	Generic Edit	15	2	Allow NULL?
75	R2KTBL	Kit Balanced (Y/N)	Character	Generic Edit	1	0	Allow NULL?
76	R2PTPH	1 or 2 Phase Putaway	Character	UDC (H46 PT)	1	0	Allow NULL?
77	R2ZIP	Zip Code - Sold to Postal Code	String	Generic Edit	12	0	Allow NULL?
78	R2SRP1	Sales Rpt 01 - Product Family	String	UDC (41 S1)	3	0	Allow NULL?
79	R2SRP2	Sales Rpt 02 - Family Section	String	UDC (41 S2)	3	0	Allow NULL?
80	R2SRP3	Sales Category Code 3	String	UDC (41 S3)	3	0	Allow NULL?
81	R2SRP4	Sales Category Code 4	String	UDC (41 S4)	3	0	Allow NULL?
82	R2SRP5	Sales Category Code 5	String	UDC (41 S5)	3	0	Allow NULL?
83	R2PRP6	Group - Item Dimension	String	UDC (41 01)	6	0	Allow NULL?
84	R2PRP7	Group - Warehouse Process 1	String	UDC (41 02)	6	0	Allow NULL?
85	R2PRP8	Group - Warehouse Process 2	String	UDC (41 02)	6	0	Allow NULL?
86	R2PRP9	Group - Warehouse Process 3	String	UDC (41 02)	6	0	Allow NULL?
87	R2MPUT	Table - Putaway Instructions	String	UDC (46 IT)	6	0	Allow NULL?
88	R2PUTP	Process Mode	Character	UDC (46 PC)	1	0	Allow NULL?
89	R2SEQ	Sequence Number	Numeric	Generic Edit	6	0	Allow NULL?
90	R2RCDJ	Date - Received	Date	Generic Edit	6	0
91	R2TRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
92	R2DRQJ	Date - Requested	Date	Generic Edit	6	0
93	R2PDDJ	Date - Scheduled Pick	Date	Generic Edit	6	0
94	R2PACK	Code - Packing	String	UDC (46 PK)	4	0	Allow NULL?
95	R2RPCK	Repack (Y/N)	Character	Generic Edit	1	0	Allow NULL?
96	R2EKEY	Error Message Key	String	Generic Edit	4	0	Allow NULL?
97	R2CODR	Reason Code	String	UDC (42 RC)	3	0	Allow NULL?
98	R2PSTB	Status - Task / Trip	String	UDC (46 PS)	3	0	Allow NULL?
99	R2RESX	Reservations Used	Character	Generic Edit	1	0	Allow NULL?
100	R2PZON	Zone - Putaway	String	UDC (46 ZN)	6	0	Allow NULL?
101	R2KZON	Zone - Picking	String	UDC (46 ZN)	6	0	Allow NULL?
102	R2ZONR	Zone - Replenishment	String	UDC (46 ZN)	6	0	Allow NULL?
103	R2AISL	Aisle	String	Generic Edit	8	0	Allow NULL?
104	R2BIN	Bin	String	Generic Edit	8	0	Allow NULL?
105	R2LA03	Category Code - Location 03	String	Generic Edit	4	0	Allow NULL?
106	R2LA04	Category Code - Location 04	String	Generic Edit	4	0	Allow NULL?
107	R2LA05	Category Code - Location 05	String	Generic Edit	4	0	Allow NULL?
108	R2LA06	Category Code - Location 06	String	Generic Edit	4	0	Allow NULL?
109	R2LA07	Category Code - Location 07	String	Generic Edit	4	0	Allow NULL?
110	R2LA08	Category Code - Location 08	String	Generic Edit	4	0	Allow NULL?
111	R2LA09	Category Code - Location 09	String	Generic Edit	4	0	Allow NULL?
112	R2LA10	Category Code - Location 10	String	Generic Edit	4	0	Allow NULL?
113	R2WSQP	Sequence Code - Putaway	Numeric	Generic Edit	5	0	Allow NULL?
114	R2WSQQ	Sequence Code - Picking	Numeric	Generic Edit	5	0	Allow NULL?
115	R2WSQR	Sequence Code - Replenishment	Numeric	Generic Edit	5	0	Allow NULL?
116	R2MMTH	Move Method Code	String	Generic Edit	4	0	Allow NULL?
117	R2AN8	Address Number	Numeric	UDC	8	0	Allow NULL?
118	R2SHAN	Address Number - Ship To	Numeric	Generic Edit	8	0	Allow NULL?
119	R2LNTY	Line Type	String	Generic Edit	2	0	Allow NULL?
120	R2PRIO	Priority - Processing	Character	UDC (H40 PR)	1	0	Allow NULL?
121	R2CARS	Carrier Number	Numeric	Generic Edit	8	0	Allow NULL?
122	R2ROUT	Route Code	String	UDC (42 RT)	3	0	Allow NULL?
123	R2STOP	Stop Code	String	UDC (42 SP)	3	0	Allow NULL?
124	R2ZON	Zone Number	String	UDC (40 ZN)	3	0	Allow NULL?
125	R2CTNF	Carton Recommendation (Y/N)	Character	Generic Edit	1	0	Allow NULL?
126	R2VSUG	Variance Suggestion (Y/N)	Character	Generic Edit	1	0	Allow NULL?
127	R2PHAS	Phase	Character	UDC (H46 PH)	1	0	Allow NULL?
128	R2RSBT	Batch Number - Related Suggestion	Numeric	Generic Edit	8	0	Allow NULL?
129	R2RSSQ	Batch Number - Related Suggestion	Numeric	Generic Edit	7	3	Allow NULL?
130	R2IUSE	Record in Use (Y/N)	Character	Generic Edit	1	0	Allow NULL?
131	R2TREX	Explanation - Transaction	String	Generic Edit	30	0	Allow NULL?
132	R2DTCR	Date - Created (Julian)	Date	Generic Edit	6	0
133	R2TMCR	Time - Created	Numeric	Generic Edit	6	0	Allow NULL?
134	R2DTPT	Date - Printed (Julian)	Date	Generic Edit	6	0
135	R2TMPT	Time - Printed	Numeric	Generic Edit	6	0	Allow NULL?
136	R2TRPR	Priority - Trip	Numeric	Generic Edit	5	0	Allow NULL?
137	R2URCD	User Reserved Code	String	Generic Edit	2	0	Allow NULL?
138	R2URDT	User Reserved Date	Date	Generic Edit	6	0
139	R2URAT	User Reserved Amount	Numeric	Generic Edit	15	2	Allow NULL?
140	R2URAB	User Reserved Number	Numeric	Generic Edit	8	0	Allow NULL?
141	R2URRF	User Reserved Reference	String	Generic Edit	15	0	Allow NULL?
142	R2RCDS	Status - Record	Character	Generic Edit	1	0	Allow NULL?
143	R2USER	User ID	String	Generic Edit	10	0	Allow NULL?
144	R2PID	Program ID	String	Generic Edit	10	0	Allow NULL?
145	R2JOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
146	R2UPMJ	Date - Updated	Date	Generic Edit	6	0
147	R2TDAY	Time of Day	Numeric	Generic Edit	6	0	Allow NULL?
148	R2UKID	Unique Key ID (Internal)	Numeric	Generic Edit	15	0	Allow NULL?
149	R2CKID	Confirmed Unique Key ID (Internal)	Numeric	Generic Edit	15	0	Allow NULL?
150	R2VR03	Reference	String	Generic Edit	25	0	Allow NULL?
151	R2SHPN	Shipment Number	Numeric	Generic Edit	8	0	Allow NULL?
152	R2LDNM	Load Number	Numeric	Generic Edit	8	0	Allow NULL?
153	R2VMCU	Depot - Trip	String	Generic Edit	12	0	Allow NULL?
154	R2PLPNU	Parent License Plate Number	String	Generic Edit	40	0	Allow NULL?
155	R2LPNUF	From License Plate Number	String	Generic Edit	40	0	Allow NULL?
156	R2LPNUT	ToLicense Plate Number	String	Generic Edit	40	0	Allow NULL?
157	R2PSJOBNO	Production Sequencing Job Number	String	Generic Edit	15	0	Allow NULL?
158	R2JOBSQ	Job Sequence Number	String	Generic Edit	15	0	Allow NULL?
159	R2DELBATCH	Delivery Batch Number	String	Generic Edit	6	0	Allow NULL?

TOP 812 | 46 | F4611 INDEXES

Number

Description

BatchNoSugg SeqNoSugg (Primary/Unique)

Element	Alias	Description	Sequence
1	SGBT	Batch Number - Suggestions	Ascending
2	SGSQ	Sequence Number - Suggestion	Ascending

Tyfl Ocde Mcu Itm Pstb

Element	Alias	Description	Sequence
1	TYFL	Code - Warehouse	Ascending
2	OCDE	Code - Origin	Ascending
3	MCU	Business Unit	Ascending
4	ITM	Item Number - Short	Ascending
5	PSTB	Status - Task / Trip	Ascending

Batch#_Request

Element	Alias	Description	Sequence
1	RQBT	Batch Number - Requests	Ascending
2	RQSQ	Sequence Number - Request	Ascending

Tyfl_Doco_Dcto_Kcoo_Clid

Element	Alias	Description	Sequence
1	TYFL	Code - Warehouse	Ascending
2	DOCO	Document (Order No Invoice etc.)	Ascending
3	DCTO	Order Type	Ascending
4	KCOO	Order Company (Order Number)	Ascending
5	CLID	Confirmed Line Number	Ascending

Tyfl_Doco_Dcto_Kcoo_Lnid

Element	Alias	Description	Sequence
1	TYFL	Code - Warehouse	Ascending
2	DOCO	Document (Order No Invoice etc.)	Ascending
3	DCTO	Order Type	Ascending
4	KCOO	Order Company (Order Number)	Ascending
5	LNID	Line Number	Ascending
6	NLIN	Number of Lines	Ascending
7	SFXO	Order Suffix	Ascending
8	PTSK	Number - Warehouse Task	Ascending
9	TRIP	Number - Trip	Ascending

Tyfl_Pstb_Ptsk_Trip

Element	Alias	Description	Sequence
1	TYFL	Code - Warehouse	Ascending
2	PSTB	Status - Task / Trip	Ascending
3	PTSK	Number - Warehouse Task	Ascending
4	TRIP	Number - Trip	Ascending

Tyfl Ocde Mcu Itm Floc Flot Ps

Element	Alias	Description	Sequence
1	TYFL	Code - Warehouse	Ascending
2	OCDE	Code - Origin	Ascending
3	MCU	Business Unit	Ascending
4	ITM	Item Number - Short	Ascending
5	FLOC	Location - From	Ascending
6	FLOT	Lot - From	Ascending
7	PSTB	Status - Task / Trip	Ascending

Ukid Flot Clid

Element	Alias	Description	Sequence
1	UKID	Unique Key ID (Internal)	Ascending
2	FLOT	Lot - From	Ascending
3	CKID	Confirmed Unique Key ID (Internal)	Ascending

Mcu_Itm_Floc_Flot

Element	Alias	Description	Sequence
1	MCU	Business Unit	Ascending
2	ITM	Item Number - Short	Ascending
3	FLOC	Location - From	Ascending
4	FLOT	Lot - From	Ascending

Mcu_Itm_Tloc_Tlot

Element	Alias	Description	Sequence
1	MCU	Business Unit	Ascending
2	ITM	Item Number - Short	Ascending
3	TLOC	Location - To	Ascending
4	TLOT	Lot - To	Ascending

Ptsk_Trip

Element	Alias	Description	Sequence
1	PTSK	Number - Warehouse Task	Ascending
2	TRIP	Number - Trip	Ascending

Sgbt_Ptsk_Trip

Element	Alias	Description	Sequence
1	SGBT	Batch Number - Suggestions	Ascending
2	PTSK	Number - Warehouse Task	Ascending
3	TRIP	Number - Trip	Ascending

Shpn_Tyfl

Element	Alias	Description	Sequence
1	SHPN	Shipment Number	Ascending
2	TYFL	Code - Warehouse	Ascending

Shpn_psjobno_jobsq

Element	Alias	Description	Sequence
1	SHPN	Shipment Number	Ascending
2	PSJOBNO	Production Sequencing Job Number	Ascending
3	JOBSQ	Job Sequence Number	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

159 COLUMNS | 14 INDEXES | 812 | 46 | F4611 TABLE

TOP 812 | 46 | F4611 COLUMNS

TOP 812 | 46 | F4611 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

159 COLUMNS | 14 INDEXES | 812 | 46 | F4611 TABLE

TOP812 | 46 | F4611 COLUMNS

TOP812 | 46 | F4611 INDEXES

TOP 812 | 46 | F4611 COLUMNS

TOP 812 | 46 | F4611 INDEXES