	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

99 COLUMNS | 15 INDEXES | 812 | 46 | F4600 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
46: Warehouse Management
1	812	F4600	R1	99	15	Warehouse Requests	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 R1TYFL, R1OCDE, R1RQBT, R1RQSQ, R1KCOO, R1DOCO, R1DCTO, R1LNID, R1NLIN, R1SFXO, R1AN8, R1SHAN, R1MCU, R1ITM, R1LITM, R1AITM, R1OGRP, R1OVRQ, R1MERG, R1RLIT, R1KTLN, R1CPNT, R1RKIT, R1KTP, R1QTRQ, R1UOM, R1LDFS, R1FLOC, R1FLOT, R1STNF, R1LPNUF, R1LDTS, R1TLOC, R1TLOT, R1STNT, R1LPNUT, R1FRMP, R1THRP, R1FRGD, R1THGD, R1EXDP, R1LNTY, R1SRP1, R1SRP2, R1SRP3, R1SRP4, R1SRP5, R1PRIO, R1ROUT, R1STOP, R1ZON, R1CARS, R1BACK, R1APTS, R1COMM, R1DSC1, R1DSC2, R1INMG, R1VR01, R1PALC, R1MORD, R1LCOD, R1PACK, R1RPCK, R1PSTB, R1RCDJ, R1TRDJ, R1PDDJ, R1DRQJ, R1ZIP, R1CPNB, R1CNFR, R1RESX, R1PTYN, R1TREX, R1DTCR, R1TMCR, R1URCD, R1URDT, R1URAT, R1URAB, R1URRF, R1USER, R1PID, R1JOBN, R1UPMJ, R1TDAY, R1UKID, R1VR03, R1SHPN, R1LDNM, R1VMCU, R1SBCK, R1EDCK, R1CMDM, R1BBCK, R1PSJOBNO, R1JOBSQ, R1DELBATCH FROM F4600

TOP 812 | 46 | F4600 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	R1TYFL	Code - Warehouse	Character	Generic Edit	1	0	Allow NULL?
2	R1OCDE	Code - Origin	String	Generic Edit	2	0	Allow NULL?
3	R1RQBT	Batch Number - Requests	Numeric	Generic Edit	8	0	Allow NULL?
4	R1RQSQ	Sequence Number - Request	Numeric	Generic Edit	7	3	Allow NULL?
5	R1KCOO	Order Company (Order Number)	String	Generic Edit	5	0	Allow NULL?
6	R1DOCO	Document (Order No Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
7	R1DCTO	Order Type	String	UDC (00 DT)	2	0	Allow NULL?
8	R1LNID	Line Number	Numeric	Generic Edit	6	3	Allow NULL?
9	R1NLIN	Number of Lines	Numeric	Generic Edit	5	0	Allow NULL?
10	R1SFXO	Order Suffix	String	Generic Edit	3	0	Allow NULL?
11	R1AN8	Address Number	Numeric	UDC	8	0	Allow NULL?
12	R1SHAN	Address Number - Ship To	Numeric	Generic Edit	8	0	Allow NULL?
13	R1MCU	Business Unit	String	Generic Edit	12	0	Allow NULL?
14	R1ITM	Item Number - Short	Numeric	Generic Edit	8	0	Allow NULL?
15	R1LITM	2nd Item Number	String	Generic Edit	25	0	Allow NULL?
16	R1AITM	3rd Item Number	String	Generic Edit	25	0	Allow NULL?
17	R1OGRP	Order Group	String	UDC (46 DT)	4	0	Allow NULL?
18	R1OVRQ	Override Request (Y/N)	Character	Generic Edit	1	0	Allow NULL?
19	R1MERG	Top Off (Y/N)	Character	Generic Edit	1	0	Allow NULL?
20	R1RLIT	Item Number - Related (Kit)	String	Generic Edit	8	0	Allow NULL?
21	R1KTLN	Kit Master Line Number	Numeric	Generic Edit	6	3	Allow NULL?
22	R1CPNT	Component Line Number	Numeric	Generic Edit	4	1	Allow NULL?
23	R1RKIT	Related Kit Component	Numeric	Generic Edit	8	0	Allow NULL?
24	R1KTP	Number of Component Per Parent	Numeric	Generic Edit	15	2	Allow NULL?
25	R1QTRQ	Quantity - Requested in primary U/M	Numeric	Generic Edit	15	2	Allow NULL?
26	R1UOM	Unit of Measure as Input	String	UDC (00 UM)	2	0	Allow NULL?
27	R1LDFS	Sequence Number - Location Detail (From)	Numeric	Generic Edit	8	0	Allow NULL?
28	R1FLOC	Location - From	String	Generic Edit	20	0	Allow NULL?
29	R1FLOT	Lot - From	String	Generic Edit	30	0	Allow NULL?
30	R1STNF	Storage Unit Number - From	Numeric	Generic Edit	8	0	Allow NULL?
31	R1LPNUF	From License Plate Number	String	Generic Edit	40	0	Allow NULL?
32	R1LDTS	Sequence Number - Location Detail (To)	Numeric	Generic Edit	8	0	Allow NULL?
33	R1TLOC	Location - To	String	Generic Edit	20	0	Allow NULL?
34	R1TLOT	Lot - To	String	Generic Edit	30	0	Allow NULL?
35	R1STNT	Storage Unit Number - To	Numeric	Generic Edit	8	0	Allow NULL?
36	R1LPNUT	ToLicense Plate Number	String	Generic Edit	40	0	Allow NULL?
37	R1FRMP	From Potency	Numeric	Generic Edit	7	3	Allow NULL?
38	R1THRP	Thru Potency	Numeric	Generic Edit	7	3	Allow NULL?
39	R1FRGD	From Grade	String	UDC (40 LG)	3	0	Allow NULL?
40	R1THGD	Thru Grade	String	UDC (40 LG)	3	0	Allow NULL?
41	R1EXDP	Days Before Expiration	Numeric	Generic Edit	5	0	Allow NULL?
42	R1LNTY	Line Type	String	Generic Edit	2	0	Allow NULL?
43	R1SRP1	Sales Rpt 01 - Product Family	String	UDC (41 S1)	3	0	Allow NULL?
44	R1SRP2	Sales Rpt 02 - Family Section	String	UDC (41 S2)	3	0	Allow NULL?
45	R1SRP3	Sales Category Code 3	String	UDC (41 S3)	3	0	Allow NULL?
46	R1SRP4	Sales Category Code 4	String	UDC (41 S4)	3	0	Allow NULL?
47	R1SRP5	Sales Category Code 5	String	UDC (41 S5)	3	0	Allow NULL?
48	R1PRIO	Priority - Processing	Character	UDC (H40 PR)	1	0	Allow NULL?
49	R1ROUT	Route Code	String	UDC (42 RT)	3	0	Allow NULL?
50	R1STOP	Stop Code	String	UDC (42 SP)	3	0	Allow NULL?
51	R1ZON	Zone Number	String	UDC (40 ZN)	3	0	Allow NULL?
52	R1CARS	Carrier Number	Numeric	Generic Edit	8	0	Allow NULL?
53	R1BACK	Backorders Allowed (Y/N)	Character	Generic Edit	1	0	Allow NULL?
54	R1APTS	Partial Line Shipments Allowed (Y/N)	Character	Generic Edit	1	0	Allow NULL?
55	R1COMM	Committed (H/S)	Character	UDC (H42 CP)	1	0	Allow NULL?
56	R1DSC1	Description	String	Generic Edit	30	0	Allow NULL?
57	R1DSC2	Description - Line 2	String	Generic Edit	30	0	Allow NULL?
58	R1INMG	Print Message	String	UDC (40 PM)	10	0	Allow NULL?
59	R1VR01	Reference	String	Generic Edit	25	0	Allow NULL?
60	R1PALC	Pallet Control	Character	Generic Edit	1	0	Allow NULL?
61	R1MORD	Merge Orders (Y/N)	Character	Generic Edit	1	0	Allow NULL?
62	R1LCOD	Code - Location Tax Status	String	UDC (46 LT)	2	0	Allow NULL?
63	R1PACK	Code - Packing	String	UDC (46 PK)	4	0	Allow NULL?
64	R1RPCK	Repack (Y/N)	Character	Generic Edit	1	0	Allow NULL?
65	R1PSTB	Status - Task / Trip	String	UDC (46 PS)	3	0	Allow NULL?
66	R1RCDJ	Date - Received	Date	Generic Edit	6	0
67	R1TRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
68	R1PDDJ	Date - Scheduled Pick	Date	Generic Edit	6	0
69	R1DRQJ	Date - Requested	Date	Generic Edit	6	0
70	R1ZIP	Zip Code - Sold to Postal Code	String	Generic Edit	12	0	Allow NULL?
71	R1CPNB	Component Line Number BOM	Numeric	Generic Edit	8	2	Allow NULL?
72	R1CNFR	Automatically Confirm (Y/N)	Character	Generic Edit	1	0	Allow NULL?
73	R1RESX	Reservations Used	Character	Generic Edit	1	0	Allow NULL?
74	R1PTYN	Override Location (Y/N)	Character	Generic Edit	1	0	Allow NULL?
75	R1TREX	Explanation - Transaction	String	Generic Edit	30	0	Allow NULL?
76	R1DTCR	Date - Created (Julian)	Date	Generic Edit	6	0
77	R1TMCR	Time - Created	Numeric	Generic Edit	6	0	Allow NULL?
78	R1URCD	User Reserved Code	String	Generic Edit	2	0	Allow NULL?
79	R1URDT	User Reserved Date	Date	Generic Edit	6	0
80	R1URAT	User Reserved Amount	Numeric	Generic Edit	15	2	Allow NULL?
81	R1URAB	User Reserved Number	Numeric	Generic Edit	8	0	Allow NULL?
82	R1URRF	User Reserved Reference	String	Generic Edit	15	0	Allow NULL?
83	R1USER	User ID	String	Generic Edit	10	0	Allow NULL?
84	R1PID	Program ID	String	Generic Edit	10	0	Allow NULL?
85	R1JOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
86	R1UPMJ	Date - Updated	Date	Generic Edit	6	0
87	R1TDAY	Time of Day	Numeric	Generic Edit	6	0	Allow NULL?
88	R1UKID	Unique Key ID (Internal)	Numeric	Generic Edit	15	0	Allow NULL?
89	R1VR03	Reference	String	Generic Edit	25	0	Allow NULL?
90	R1SHPN	Shipment Number	Numeric	Generic Edit	8	0	Allow NULL?
91	R1LDNM	Load Number	Numeric	Generic Edit	8	0	Allow NULL?
92	R1VMCU	Depot - Trip	String	Generic Edit	12	0	Allow NULL?
93	R1SBCK	Check Sell By Date	Character	Generic Edit	1	0	Allow NULL?
94	R1EDCK	Check Expiration Date	Character	Generic Edit	1	0	Allow NULL?
95	R1CMDM	Commitment Date Method	Character	UDC (H40 CD)	1	0	Allow NULL?
96	R1BBCK	Check Best Before Date	Character	Generic Edit	1	0	Allow NULL?
97	R1PSJOBNO	Production Sequencing Job Number	String	Generic Edit	15	0	Allow NULL?
98	R1JOBSQ	Job Sequence Number	String	Generic Edit	15	0	Allow NULL?
99	R1DELBATCH	Delivery Batch Number	String	Generic Edit	6	0	Allow NULL?

TOP 812 | 46 | F4600 INDEXES

Number

Description

Batch#_Request (Primary/Unique)

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

Doc_DocType

Element	Alias	Description	Sequence
1	DOCO	Document (Order No Invoice etc.)	Ascending
2	DCTO	Order Type	Ascending
3	KCOO	Order Company (Order Number)	Ascending
4	LNID	Line Number	Ascending
5	NLIN	Number of Lines	Ascending

Doc#_DocType_Status

Element	Alias	Description	Sequence
1	DOCO	Document (Order No Invoice etc.)	Ascending
2	DCTO	Order Type	Ascending
3	KCOO	Order Company (Order Number)	Ascending
4	LNID	Line Number	Ascending
5	PSTB	Status - Task / Trip	Ascending

Wh_CC_Btch#_Seq

Element	Alias	Description	Sequence
1	TYFL	Code - Warehouse	Ascending
2	MCU	Business Unit	Ascending
3	RQBT	Batch Number - Requests	Ascending
4	RQSQ	Sequence Number - Request	Ascending

Wh_CC_Status_Btch#_Seq

Element	Alias	Description	Sequence
1	TYFL	Code - Warehouse	Ascending
2	MCU	Business Unit	Ascending
3	PSTB	Status - Task / Trip	Ascending
4	RQBT	Batch Number - Requests	Ascending
5	RQSQ	Sequence Number - Request	Ascending

Wh_Itm_Status_Btch#_Seq

Element	Alias	Description	Sequence
1	TYFL	Code - Warehouse	Ascending
2	ITM	Item Number - Short	Ascending
3	PSTB	Status - Task / Trip	Ascending
4	RQBT	Batch Number - Requests	Ascending
5	RQSQ	Sequence Number - Request	Ascending

Wh_Btch#_Seq

Element	Alias	Description	Sequence
1	TYFL	Code - Warehouse	Ascending
2	RQBT	Batch Number - Requests	Ascending
3	RQSQ	Sequence Number - Request	Ascending

Wh_Itm_Btch#_Seq

Element	Alias	Description	Sequence
1	RQSQ	Sequence Number - Request	Ascending
2	TYFL	Code - Warehouse	Ascending
3	ITM	Item Number - Short	Ascending
4	RQBT	Batch Number - Requests	Ascending

Wh_Status_Btch#_Seq

Element	Alias	Description	Sequence
1	TYFL	Code - Warehouse	Ascending
2	PSTB	Status - Task / Trip	Ascending
3	RQBT	Batch Number - Requests	Ascending
4	RQSQ	Sequence Number - Request	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
8	DOCO	Document (Order No Invoice etc.)	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

FromLicensePlate

Element	Alias	Description	Sequence
1	STNF	Storage Unit Number - From	Ascending

FromLP

Element	Alias	Description	Sequence
1	LPNUF	From License Plate Number	Ascending

Chk Existing LP Req

Element	Alias	Description	Sequence
1	LPNUF	From License Plate Number	Ascending
2	MCU	Business Unit	Ascending
3	PSTB	Status - Task / Trip	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

99 COLUMNS | 15 INDEXES | 812 | 46 | F4600 TABLE

TOP 812 | 46 | F4600 COLUMNS

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

99 COLUMNS | 15 INDEXES | 812 | 46 | F4600 TABLE

TOP812 | 46 | F4600 COLUMNS

TOP812 | 46 | F4600 INDEXES

TOP 812 | 46 | F4600 COLUMNS

TOP 812 | 46 | F4600 INDEXES