	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

136 COLUMNS | 3 INDEXES | 812 | 42 | F42UI521 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
42: Sales Management
1	812	F42UI521	S9	136	3	Pick Slips Detail File	Work Files	42: Sales Management	No

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 S9SEQ, S9DOCO, S9KCOO, S9DCTO, S9LNID, S9MCU, S9CO, S9OKCO, S9OCTO, S9OORN, S9OGNO, S9RKCO, S9RORN, S9RCTO, S9RLLN, S9AN8, S9SHAN, S9PA8, S9DRQJ, S9TRDJ, S9PDDJ, S9OPDJ, S9ADDJ, S9RSDJ, S9PEFJ, S9PPDJ, S9VR01, S9ITM, S9LITM, S9AITM, S9LOCN, S9LOTN, S9FRGD, S9THGD, S9FRMP, S9THRP, S9EXDP, S9DSC1, S9DSC2, S9LNTY, S9IVI, S9NXTR, S9LTTR, S9EMCU, S9RLIT, S9KTLN, S9CPNT, S9RKIT, S9KTP, S9SRP1, S9SRP2, S9SRP3, S9SRP4, S9SRP5, S9PRP1, S9PRP2, S9PRP3, S9PRP4, S9PRP5, S9UOM, S9UORG, S9SOQS, S9SOBK, S9SOCN, S9SONE, S9UOPN, S9QTYT, S9COMM, S9OTQY, S9UPRC, S9AEXP, S9PROV, S9APUM, S9LPRC, S9UNCS, S9ECST, S9CSTO, S9TCST, S9INMG, S9PTC, S9RYIN, S9TRDC, S9ASN, S9PRGR, S9CLVL, S9PSN, S9TAX1, S9TXA1, S9EXR1, S9ATXT, S9PRIO, S9RESL, S9BACK, S9SBAL, S9APTS, S9CDCD, S9ROUT, S9STOP, S9UOM1, S9PQOR, S9UOM2, S9SQOR, S9UOM4, S9ITWT, S9WTUM, S9ITVL, S9VLUM, S9CMGL, S9STTS, S9SO01, S9SO02, S9RCD, S9GRWT, S9GWUM, S9SBL, S9SBLT, S9CRCD, S9CRR, S9FPRC, S9FUP, S9FEA, S9FUC, S9FEC, S9TXYN, S9URCD, S9URDT, S9URAT, S9URAB, S9URRF, S9USER, S9PID, S9JOBN, S9UPMJ, S9TDAY, S9CTID, S9JOBS FROM F42UI521

TOP 812 | 42 | F42UI521 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	S9SEQ	Sequence Number	Numeric	Generic Edit	6	0	Allow NULL?
2	S9DOCO	Document (Order No Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
3	S9KCOO	Order Company (Order Number)	String	Generic Edit	5	0	Allow NULL?
4	S9DCTO	Order Type	String	UDC (00 DT)	2	0	Allow NULL?
5	S9LNID	Line Number	Numeric	Generic Edit	6	3	Allow NULL?
6	S9MCU	Business Unit	String	Generic Edit	12	0	Allow NULL?
7	S9CO	Company	String	Generic Edit	5	0	Allow NULL?
8	S9OKCO	Document Company (Original Order)	String	Generic Edit	5	0	Allow NULL?
9	S9OCTO	Original Order Type	String	UDC (00 DT)	2	0	Allow NULL?
10	S9OORN	Original Order Number	String	Generic Edit	8	0	Allow NULL?
11	S9OGNO	Original Line Number	Numeric	Generic Edit	7	3	Allow NULL?
12	S9RKCO	Company - Key (Related Order)	String	Generic Edit	5	0	Allow NULL?
13	S9RORN	Related PO/SO/WO Number	String	Generic Edit	8	0	Allow NULL?
14	S9RCTO	Related PO/SO/WO Order Type	String	UDC (00 DT)	2	0	Allow NULL?
15	S9RLLN	Related PO/SO Line Number	Numeric	Generic Edit	7	3	Allow NULL?
16	S9AN8	Address Number	Numeric	UDC	8	0	Allow NULL?
17	S9SHAN	Address Number - Ship To	Numeric	Generic Edit	8	0	Allow NULL?
18	S9PA8	Address Number - Parent	Numeric	Generic Edit	8	0	Allow NULL?
19	S9DRQJ	Date - Requested	Date	Generic Edit	6	0
20	S9TRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
21	S9PDDJ	Date - Scheduled Pick	Date	Generic Edit	6	0
22	S9OPDJ	Date - Original Promised Delivery	Date	Generic Edit	6	0
23	S9ADDJ	Date - Actual Ship Date	Date	Generic Edit	6	0
24	S9RSDJ	Date - Promised Delivery	Date	Generic Edit	6	0
25	S9PEFJ	Date - Price Effective Date	Date	Generic Edit	6	0
26	S9PPDJ	Date - Promised Shipment	Date	Generic Edit	6	0
27	S9VR01	Reference	String	Generic Edit	25	0	Allow NULL?
28	S9ITM	Item Number - Short	Numeric	Generic Edit	8	0	Allow NULL?
29	S9LITM	2nd Item Number	String	Generic Edit	25	0	Allow NULL?
30	S9AITM	3rd Item Number	String	Generic Edit	25	0	Allow NULL?
31	S9LOCN	Location	String	Generic Edit	20	0	Allow NULL?
32	S9LOTN	Lot/Serial Number	String	Generic Edit	30	0	Allow NULL?
33	S9FRGD	From Grade	String	UDC (40 LG)	3	0	Allow NULL?
34	S9THGD	Thru Grade	String	UDC (40 LG)	3	0	Allow NULL?
35	S9FRMP	From Potency	Numeric	Generic Edit	7	3	Allow NULL?
36	S9THRP	Thru Potency	Numeric	Generic Edit	7	3	Allow NULL?
37	S9EXDP	Days Before Expiration	Numeric	Generic Edit	5	0	Allow NULL?
38	S9DSC1	Description	String	Generic Edit	30	0	Allow NULL?
39	S9DSC2	Description - Line 2	String	Generic Edit	30	0	Allow NULL?
40	S9LNTY	Line Type	String	Generic Edit	2	0	Allow NULL?
41	S9IVI	Inventory Interface Y/N - Distribution	Character	UDC (H40 IV)	1	0	Allow NULL?
42	S9NXTR	Status Code - Next	String	UDC (40 AT)	3	0	Allow NULL?
43	S9LTTR	Status Code - Last	String	UDC (40 AT)	3	0	Allow NULL?
44	S9EMCU	Business Unit - Header	String	Generic Edit	12	0	Allow NULL?
45	S9RLIT	Item Number - Related (Kit)	String	Generic Edit	8	0	Allow NULL?
46	S9KTLN	Kit Master Line Number	Numeric	Generic Edit	6	3	Allow NULL?
47	S9CPNT	Component Line Number	Numeric	Generic Edit	4	1	Allow NULL?
48	S9RKIT	Related Kit Component	Numeric	Generic Edit	8	0	Allow NULL?
49	S9KTP	Number of Component Per Parent	Numeric	Generic Edit	15	2	Allow NULL?
50	S9SRP1	Sales Rpt 01 - Product Family	String	UDC (41 S1)	3	0	Allow NULL?
51	S9SRP2	Sales Rpt 02 - Family Section	String	UDC (41 S2)	3	0	Allow NULL?
52	S9SRP3	Sales Category Code 3	String	UDC (41 S3)	3	0	Allow NULL?
53	S9SRP4	Sales Category Code 4	String	UDC (41 S4)	3	0	Allow NULL?
54	S9SRP5	Sales Category Code 5	String	UDC (41 S5)	3	0	Allow NULL?
55	S9PRP1	Commodity Class	String	UDC (41 P1)	3	0	Allow NULL?
56	S9PRP2	Commodity Sub Class	String	UDC (41 P2)	3	0	Allow NULL?
57	S9PRP3	Supplier Rebate Code	String	UDC (41 P3)	3	0	Allow NULL?
58	S9PRP4	Master Planning Family	String	UDC (41 P4)	3	0	Allow NULL?
59	S9PRP5	Purchasing Category Code 5	String	UDC (41 P5)	3	0	Allow NULL?
60	S9UOM	Unit of Measure as Input	String	UDC (00 UM)	2	0	Allow NULL?
61	S9UORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2	Allow NULL?
62	S9SOQS	Quantity Shipped	Numeric	Generic Edit	15	2	Allow NULL?
63	S9SOBK	Units - Qty Backordered/Held	Numeric	Generic Edit	15	2	Allow NULL?
64	S9SOCN	Units - Quantity Canceled/Scrapped	Numeric	Generic Edit	15	2	Allow NULL?
65	S9SONE	Units - Future Quantity Committed	Numeric	Generic Edit	15	2	Allow NULL?
66	S9UOPN	Units - Open	Numeric	Generic Edit	15	2	Allow NULL?
67	S9QTYT	Units - Shipped to Date	Numeric	Generic Edit	15	2	Allow NULL?
68	S9COMM	Committed (H/S)	Character	UDC (H42 CP)	1	0	Allow NULL?
69	S9OTQY	Other Quantity (1/2)	Character	UDC	1	0	Allow NULL?
70	S9UPRC	Amount - Price per Unit	Numeric	Generic Edit	15	4	Allow NULL?
71	S9AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2	Allow NULL?
72	S9PROV	Price Override Code	Character	Generic Edit	1	0	Allow NULL?
73	S9APUM	Unit of Measure - Entered for Unit Price	String	UDC (00 UM)	2	0	Allow NULL?
74	S9LPRC	Amount - List Price	Numeric	Generic Edit	15	4	Allow NULL?
75	S9UNCS	Amount - Unit Cost	Numeric	Generic Edit	15	4	Allow NULL?
76	S9ECST	Amount - Extended Cost	Numeric	Generic Edit	15	2	Allow NULL?
77	S9CSTO	Cost Override Code	Character	Generic Edit	1	0	Allow NULL?
78	S9TCST	Extended Cost - Transfer	Numeric	Generic Edit	15	4	Allow NULL?
79	S9INMG	Print Message	String	UDC (40 PM)	10	0	Allow NULL?
80	S9PTC	Payment Terms Code	String	Generic Edit	3	0	Allow NULL?
81	S9RYIN	Payment Instrument	Character	UDC (00 PY)	1	0	Allow NULL?
82	S9TRDC	Discount - Trade	Numeric	Generic Edit	7	3	Allow NULL?
83	S9ASN	Price and Adjustment Schedule	String	UDC (40 AS)	8	0	Allow NULL?
84	S9PRGR	Item Price Group	String	UDC (40 PI)	8	0	Allow NULL?
85	S9CLVL	Pricing Category Level	String	Generic Edit	3	0	Allow NULL?
86	S9PSN	Pick Slip Number	Numeric	Generic Edit	8	0	Allow NULL?
87	S9TAX1	Sales Taxable (Y/N)	Character	UDC (H00 TV)	1	0	Allow NULL?
88	S9TXA1	Tax Rate/Area	String	Generic Edit	10	0	Allow NULL?
89	S9EXR1	Tax Expl Code 1	String	UDC (00 EX)	2	0	Allow NULL?
90	S9ATXT	Associated Text	Character	Generic Edit	1	0	Allow NULL?
91	S9PRIO	Priority - Processing	Character	UDC (H40 PR)	1	0	Allow NULL?
92	S9RESL	Printed Code	Character	Generic Edit	1	0	Allow NULL?
93	S9BACK	Backorders Allowed (Y/N)	Character	Generic Edit	1	0	Allow NULL?
94	S9SBAL	Substitutes Allowed (Y/N)	Character	Generic Edit	1	0	Allow NULL?
95	S9APTS	Partial Line Shipments Allowed (Y/N)	Character	Generic Edit	1	0	Allow NULL?
96	S9CDCD	Commodity Code	String	Generic Edit	15	0	Allow NULL?
97	S9ROUT	Route Code	String	UDC (42 RT)	3	0	Allow NULL?
98	S9STOP	Stop Code	String	UDC (42 SP)	3	0	Allow NULL?
99	S9UOM1	Unit of Measure - Primary	String	UDC (00 UM)	2	0	Allow NULL?
100	S9PQOR	Units - Primary Quantity Ordered	Numeric	Generic Edit	15	2	Allow NULL?
101	S9UOM2	Unit of Measure - Secondary	String	UDC (00 UM)	2	0	Allow NULL?
102	S9SQOR	Units - Secondary Quantity Ordered	Numeric	Generic Edit	15	2	Allow NULL?
103	S9UOM4	Unit of Measure - Pricing	String	UDC (00 UM)	2	0	Allow NULL?
104	S9ITWT	Unit Weight	Numeric	Generic Edit	15	4	Allow NULL?
105	S9WTUM	Weight Unit of Measure	String	UDC (00 UM)	2	0	Allow NULL?
106	S9ITVL	Unit Volume	Numeric	Generic Edit	15	4	Allow NULL?
107	S9VLUM	Volume Unit of Measure	String	UDC (00 UM)	2	0	Allow NULL?
108	S9CMGL	Commitment Method	Character	UDC (H40 CM)	1	0	Allow NULL?
109	S9STTS	Line Status	String	Generic Edit	2	0	Allow NULL?
110	S9SO01	Inter Branch Sales	Character	Generic Edit	1	0	Allow NULL?
111	S9SO02	On Hand Updated	Character	Generic Edit	1	0	Allow NULL?
112	S9RCD	Reason Code	String	UDC (42 RC)	3	0	Allow NULL?
113	S9GRWT	Gross Weight	Numeric	Generic Edit	15	4	Allow NULL?
114	S9GWUM	Gross Weight Unit of Measure	String	UDC (00 UM)	2	0	Allow NULL?
115	S9SBL	Subledger - G/L	String	Generic Edit	8	0	Allow NULL?
116	S9SBLT	Subledger Type	Character	UDC (00 ST)	1	0	Allow NULL?
117	S9CRCD	Currency Code - From	String	Generic Edit	3	0	Allow NULL?
118	S9CRR	Currency Conversion Rate - Spot Rate	Numeric	Generic Edit	15	0	Allow NULL?
119	S9FPRC	Amount - List Price per Unit	Numeric	Generic Edit	15	4	Allow NULL?
120	S9FUP	Amount - Foreign Price per Unit	Numeric	Generic Edit	15	4	Allow NULL?
121	S9FEA	Amount - Foreign Extended Price	Numeric	Generic Edit	15	2	Allow NULL?
122	S9FUC	Amount - Foreign Unit Cost	Numeric	Generic Edit	15	4	Allow NULL?
123	S9FEC	Amount - Foreign Extended Cost	Numeric	Generic Edit	15	2	Allow NULL?
124	S9TXYN	Text (Y/N)	Character	Generic Edit	1	0	Allow NULL?
125	S9URCD	User Reserved Code	String	Generic Edit	2	0	Allow NULL?
126	S9URDT	User Reserved Date	Date	Generic Edit	6	0
127	S9URAT	User Reserved Amount	Numeric	Generic Edit	15	2	Allow NULL?
128	S9URAB	User Reserved Number	Numeric	Generic Edit	8	0	Allow NULL?
129	S9URRF	User Reserved Reference	String	Generic Edit	15	0	Allow NULL?
130	S9USER	User ID	String	Generic Edit	10	0	Allow NULL?
131	S9PID	Program ID	String	Generic Edit	10	0	Allow NULL?
132	S9JOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
133	S9UPMJ	Date - Updated	Date	Generic Edit	6	0
134	S9TDAY	Time of Day	Numeric	Generic Edit	6	0	Allow NULL?
135	S9CTID	Computer ID	String	Generic Edit	15	0	Allow NULL?
136	S9JOBS	Job Number	Numeric	Generic Edit	8	0	Allow NULL?

TOP 812 | 42 | F42UI521 INDEXES

Number

Description

SeqNum OrderNum OrderCo Typ

Element	Alias	Description	Sequence
1	SEQ	Sequence Number	Ascending
2	DOCO	Document (Order No Invoice etc.)	Ascending
3	KCOO	Order Company (Order Number)	Ascending
4	DCTO	Order Type	Ascending

OrderNum OrderCO Type

Element	Alias	Description	Sequence
1	DOCO	Document (Order No Invoice etc.)	Ascending
2	KCOO	Order Company (Order Number)	Ascending
3	DCTO	Order Type	Ascending

OrderNum Co Type LineNum (Primary/Unique)

Element	Alias	Description	Sequence
1	DOCO	Document (Order No Invoice etc.)	Ascending
2	KCOO	Order Company (Order Number)	Ascending
3	DCTO	Order Type	Ascending
4	LNID	Line 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

136 COLUMNS | 3 INDEXES | 812 | 42 | F42UI521 TABLE

TOP 812 | 42 | F42UI521 COLUMNS

TOP 812 | 42 | F42UI521 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

136 COLUMNS | 3 INDEXES | 812 | 42 | F42UI521 TABLE

TOP812 | 42 | F42UI521 COLUMNS

TOP812 | 42 | F42UI521 INDEXES

TOP 812 | 42 | F42UI521 COLUMNS

TOP 812 | 42 | F42UI521 INDEXES