	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	F4102	IB	Item Branch File
7	F9671	SD	Software Update Detail Table
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	F4311	PD	Purchase Order Detail File
10	F4111	IL	Item Ledger File

	Table	Prefix	Description
1	F0911	GL	Account Ledger
2	F4311	PD	Purchase Order Detail File
3	F0101	AB	Address Book Master
4	F0411	RP	Accounts Payable Ledger
5	F0006	MC	Business Unit Master
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

268 COLUMNS | 2 INDEXES | 920 | 42 | F42199 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
42: Sales Management
1	920	F42199	SL	268	2	S.O. Detail Ledger File	History Files	42: Sales Management

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 SLKCOO, SLDOCO, SLDCTO, SLLNID, SLSFXO, SLMCU, SLCO, SLOKCO, SLOORN, SLOCTO, SLOGNO, SLRKCO, SLRORN, SLRCTO, SLRLLN, SLDMCT, SLDMCS, SLAN8, SLSHAN, SLPA8, SLDRQJ, SLTRDJ, SLPDDJ, SLADDJ, SLIVD, SLCNDJ, SLDGL, SLRSDJ, SLPEFJ, SLPPDJ, SLVR01, SLVR02, SLITM, SLLITM, SLAITM, SLLOCN, SLLOTN, SLFRGD, SLTHGD, SLFRMP, SLTHRP, SLEXDP, SLDSC1, SLDSC2, SLLNTY, SLNXTR, SLLTTR, SLEMCU, SLRLIT, SLKTLN, SLCPNT, SLRKIT, SLKTP, SLSRP1, SLSRP2, SLSRP3, SLSRP4, SLSRP5, SLPRP1, SLPRP2, SLPRP3, SLPRP4, SLPRP5, SLUOM, SLUORG, SLSOQS, SLSOBK, SLSOCN, SLSONE, SLUOPN, SLQTYT, SLQRLV, SLCOMM, SLOTQY, SLUPRC, SLAEXP, SLAOPN, SLPROV, SLTPC, SLAPUM, SLLPRC, SLUNCS, SLECST, SLCSTO, SLTCST, SLINMG, SLPTC, SLRYIN, SLDTBS, SLTRDC, SLFUN2, SLASN, SLPRGR, SLCLVL, SLCADC, SLKCO, SLDOC, SLDCT, SLODOC, SLODCT, SLOKC, SLPSN, SLDELN, SLTAX1, SLTXA1, SLEXR1, SLATXT, SLPRIO, SLRESL, SLBACK, SLSBAL, SLAPTS, SLLOB, SLEUSE, SLDTYS, SLNTR, SLVEND, SLCARS, SLMOT, SLROUT, SLSTOP, SLZON, SLCNID, SLFRTH, SLSHCM, SLSHCN, SLSERN, SLUOM1, SLPQOR, SLUOM2, SLSQOR, SLUOM4, SLITWT, SLWTUM, SLITVL, SLVLUM, SLRPRC, SLORPR, SLORP, SLCMGP, SLGLC, SLCTRY, SLFY, SLSO01, SLSO02, SLSO03, SLSO04, SLSO05, SLSO06, SLSO07, SLSO08, SLSO09, SLSO10, SLSO11, SLSO12, SLSO13, SLSO14, SLSO15, SLACOM, SLCMCG, SLRCD, SLGRWT, SLGWUM, SLSBL, SLSBLT, SLLCOD, SLUPC1, SLUPC2, SLUPC3, SLSWMS, SLUNCD, SLCRMD, SLCRCD, SLCRR, SLFPRC, SLFUP, SLFEA, SLFUC, SLFEC, SLURCD, SLURDT, SLURAT, SLURAB, SLURRF, SLTORG, SLUSER, SLPID, SLJOBN, SLUPMJ, SLTDAY, SLSO16, SLSO17, SLSO18, SLSO19, SLSO20, SLIR01, SLIR02, SLIR03, SLIR04, SLIR05, SLSOOR, SLVR03, SLDEID, SLPSIG, SLRLNU, SLPMDT, SLRLTM, SLRLDJ, SLDRQT, SLADTM, SLOPTT, SLPDTT, SLPSTM, SLXDCK, SLXPTY, SLDUAL, SLBSC, SLCBSC, SLCORD, SLDVAN, SLPEND, SLRFRV, SLMCLN, SLSHPN, SLRSDT, SLPRJM, SLOSEQ, SLMERL, SLHOLD, SLHDBU, SLDMBU, SLBCRC, SLODLN, SLOPDJ, SLXKCO, SLXORN, SLXCTO, SLXLLN, SLXSFX, SLPOE, SLPMTO, SLANBY, SLPMTN, SLNUMB, SLAAID, SLPRAN8, SLSPATTN, SLPRCIDLN, SLCCIDLN, SLSHCCIDLN, SLOPPID, SLOSTP, SLUKID, SLCATNM, SLALLOC, SLFULPID, SLALLSTS, SLOSCORE, SLOSCOREO, SLCMCO, SLKITID, SLKITAMTDOM, SLKITAMTFOR, SLKITDIRTY, SLOCITT, SLOCCARDNO, SLPMPN, SLPNS FROM F42199

TOP 920 | 42 | F42199 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	SLKCOO	Order Company (Order Number)	String	Generic Edit	5	0	Allow NULL?
2	SLDOCO	Document (Order No Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
3	SLDCTO	Order Type	String	UDC (00 DT)	2	0	Allow NULL?
4	SLLNID	Line Number	Numeric	Generic Edit	6	3	Allow NULL?
5	SLSFXO	Order Suffix	String	Generic Edit	3	0	Allow NULL?
6	SLMCU	Business Unit	String	Generic Edit	12	0	Allow NULL?
7	SLCO	Company	String	Generic Edit	5	0	Allow NULL?
8	SLOKCO	Document Company (Original Order)	String	Generic Edit	5	0	Allow NULL?
9	SLOORN	Original Order Number	String	Generic Edit	8	0	Allow NULL?
10	SLOCTO	Original Order Type	String	UDC (00 DT)	2	0	Allow NULL?
11	SLOGNO	Original Line Number	Numeric	Generic Edit	7	3	Allow NULL?
12	SLRKCO	Company - Key (Related Order)	String	Generic Edit	5	0	Allow NULL?
13	SLRORN	Related PO/SO/WO Number	String	Generic Edit	8	0	Allow NULL?
14	SLRCTO	Related PO/SO/WO Order Type	String	UDC (00 DT)	2	0	Allow NULL?
15	SLRLLN	Related PO/SO Line Number	Numeric	Generic Edit	7	3	Allow NULL?
16	SLDMCT	Agreement Number - Distribution	String	Generic Edit	12	0	Allow NULL?
17	SLDMCS	Agreement Supplement - Distribution	Numeric	Generic Edit	3	0	Allow NULL?
18	SLAN8	Address Number	Numeric	Generic Edit	8	0	Allow NULL?
19	SLSHAN	Address Number - Ship To	Numeric	Generic Edit	8	0	Allow NULL?
20	SLPA8	Address Number - Parent	Numeric	Generic Edit	8	0	Allow NULL?
21	SLDRQJ	Date - Requested	Date	Generic Edit	6	0
22	SLTRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
23	SLPDDJ	Date - Scheduled Pick	Date	Generic Edit	6	0
24	SLADDJ	Date - Actual Ship Date	Date	Generic Edit	6	0
25	SLIVD	Date - Invoice	Date	Generic Edit	6	0
26	SLCNDJ	Date - Cancel	Date	Generic Edit	6	0
27	SLDGL	Date - For G/L (and Voucher)	Date	Generic Edit	6	0
28	SLRSDJ	Date - Promised Delivery	Date	Generic Edit	6	0
29	SLPEFJ	Date - Price Effective Date	Date	Generic Edit	6	0
30	SLPPDJ	Date - Promised Shipment	Date	Generic Edit	6	0
31	SLVR01	Reference	String	Generic Edit	25	0	Allow NULL?
32	SLVR02	Reference 2	String	Generic Edit	25	0	Allow NULL?
33	SLITM	Item Number - Short	Numeric	Generic Edit	8	0	Allow NULL?
34	SLLITM	2nd Item Number	String	Generic Edit	25	0	Allow NULL?
35	SLAITM	3rd Item Number	String	Generic Edit	25	0	Allow NULL?
36	SLLOCN	Location	String	Generic Edit	20	0	Allow NULL?
37	SLLOTN	Lot/Serial Number	String	Generic Edit	30	0	Allow NULL?
38	SLFRGD	From Grade	String	UDC (40 LG)	3	0	Allow NULL?
39	SLTHGD	Thru Grade	String	UDC (40 LG)	3	0	Allow NULL?
40	SLFRMP	From Potency	Numeric	Generic Edit	7	3	Allow NULL?
41	SLTHRP	Thru Potency	Numeric	Generic Edit	7	3	Allow NULL?
42	SLEXDP	Days Before Expiration	Numeric	Generic Edit	5	0	Allow NULL?
43	SLDSC1	Description	String	Generic Edit	30	0	Allow NULL?
44	SLDSC2	Description - Line 2	String	Generic Edit	30	0	Allow NULL?
45	SLLNTY	Line Type	String	Generic Edit	2	0	Allow NULL?
46	SLNXTR	Status Code - Next	String	UDC (40 AT)	3	0	Allow NULL?
47	SLLTTR	Status Code - Last	String	UDC (40 AT)	3	0	Allow NULL?
48	SLEMCU	Business Unit - Header	String	Generic Edit	12	0	Allow NULL?
49	SLRLIT	Item Number - Related (Kit)	String	Generic Edit	8	0	Allow NULL?
50	SLKTLN	Kit Master Line Number	Numeric	Generic Edit	6	3	Allow NULL?
51	SLCPNT	Component Line Number	Numeric	Generic Edit	4	1	Allow NULL?
52	SLRKIT	Related Kit Component	Numeric	Generic Edit	8	0	Allow NULL?
53	SLKTP	Number of Component Per Parent	Numeric	Generic Edit	15	0	Allow NULL?
54	SLSRP1	Sales Catalog Section	String	UDC (41 S1)	3	0	Allow NULL?
55	SLSRP2	Sub Section	String	UDC (41 S2)	3	0	Allow NULL?
56	SLSRP3	Sales Category Code 3	String	UDC (41 S3)	3	0	Allow NULL?
57	SLSRP4	Sales Category Code 4	String	UDC (41 S4)	3	0	Allow NULL?
58	SLSRP5	Sales Category Code 5	String	UDC (41 S5)	3	0	Allow NULL?
59	SLPRP1	Commodity Class	String	UDC (41 P1)	3	0	Allow NULL?
60	SLPRP2	Commodity Sub Class	String	UDC (41 P2)	3	0	Allow NULL?
61	SLPRP3	Supplier Rebate Code	String	UDC (41 P3)	3	0	Allow NULL?
62	SLPRP4	Master Planning Family	String	UDC (41 P4)	3	0	Allow NULL?
63	SLPRP5	Purchasing Category Code 5	String	UDC (41 P5)	3	0	Allow NULL?
64	SLUOM	Unit of Measure as Input	String	UDC (00 UM)	2	0	Allow NULL?
65	SLUORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	0	Allow NULL?
66	SLSOQS	Quantity Shipped	Numeric	Generic Edit	15	0	Allow NULL?
67	SLSOBK	Units - Qty Backordered/Held	Numeric	Generic Edit	15	0	Allow NULL?
68	SLSOCN	Units - Quantity Canceled/Scrapped	Numeric	Generic Edit	15	0	Allow NULL?
69	SLSONE	Units - Future Quantity Committed	Numeric	Generic Edit	15	0	Allow NULL?
70	SLUOPN	Units - Open	Numeric	Generic Edit	15	0	Allow NULL?
71	SLQTYT	Units - Shipped to Date	Numeric	Generic Edit	15	0	Allow NULL?
72	SLQRLV	Units - Relieved	Numeric	Generic Edit	15	0	Allow NULL?
73	SLCOMM	Committed (H/S)	Character	UDC (H42 CP)	1	0	Allow NULL?
74	SLOTQY	Other Quantity (1/2)	Character	UDC	1	0	Allow NULL?
75	SLUPRC	Amount - Price per Unit	Numeric	Generic Edit	15	4	Allow NULL?
76	SLAEXP	Amount - Extended Price	Numeric	Generic Edit	15	2	Allow NULL?
77	SLAOPN	Amount - Open	Numeric	Generic Edit	15	2	Allow NULL?
78	SLPROV	Price Override Code	Character	Generic Edit	1	0	Allow NULL?
79	SLTPC	Temporary Price (Y/N)	Character	Generic Edit	1	0	Allow NULL?
80	SLAPUM	Unit of Measure - Entered for Unit Price	String	UDC (00 UM)	2	0	Allow NULL?
81	SLLPRC	Amount - List Price	Numeric	Generic Edit	15	4	Allow NULL?
82	SLUNCS	Amount - Unit Cost	Numeric	Generic Edit	15	4	Allow NULL?
83	SLECST	Amount - Extended Cost	Numeric	Generic Edit	15	2	Allow NULL?
84	SLCSTO	Cost Override Code	Character	Generic Edit	1	0	Allow NULL?
85	SLTCST	Extended Cost - Transfer	Numeric	Generic Edit	15	4	Allow NULL?
86	SLINMG	Print Message	String	UDC (40 PM)	10	0	Allow NULL?
87	SLPTC	Payment Terms Code	String	Generic Edit	3	0	Allow NULL?
88	SLRYIN	Payment Instrument	Character	UDC (00 PY)	1	0	Allow NULL?
89	SLDTBS	Based on Date	Character	UDC (42 BD)	1	0	Allow NULL?
90	SLTRDC	Discount - Trade	Numeric	Generic Edit	7	3	Allow NULL?
91	SLFUN2	Trade Discount (Old)	Numeric	Generic Edit	15	4	Allow NULL?
92	SLASN	Price and Adjustment Schedule	String	UDC (40 AS)	8	0	Allow NULL?
93	SLPRGR	Item Price Group	String	UDC (40 PI)	8	0	Allow NULL?
94	SLCLVL	Pricing Category Level	String	Generic Edit	3	0	Allow NULL?
95	SLCADC	Discount % - Cash	Numeric	Generic Edit	7	3	Allow NULL?
96	SLKCO	Document Company	String	Generic Edit	5	0	Allow NULL?
97	SLDOC	Document (Voucher Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
98	SLDCT	Document Type	String	UDC (00 DT)	2	0	Allow NULL?
99	SLODOC	Document - Original	Numeric	Generic Edit	8	0	Allow NULL?
100	SLODCT	Document Type - Original	String	UDC (00 DT)	2	0	Allow NULL?
101	SLOKC	Document Company - Original	String	Generic Edit	5	0	Allow NULL?
102	SLPSN	Pick Slip Number	Numeric	Generic Edit	8	0	Allow NULL?
103	SLDELN	Delivery Number	Numeric	Generic Edit	8	0	Allow NULL?
104	SLTAX1	Sales Taxable (Y/N)	Character	UDC (H00 TV)	1	0	Allow NULL?
105	SLTXA1	Tax Rate/Area	String	Generic Edit	10	0	Allow NULL?
106	SLEXR1	Tax Expl Code 1	String	UDC (00 EX)	2	0	Allow NULL?
107	SLATXT	Associated Text	Character	Generic Edit	1	0	Allow NULL?
108	SLPRIO	Priority - Processing	Character	UDC (H40 PR)	1	0	Allow NULL?
109	SLRESL	Printed Code	Character	Generic Edit	1	0	Allow NULL?
110	SLBACK	Backorders Allowed (Y/N)	Character	Generic Edit	1	0	Allow NULL?
111	SLSBAL	Substitutes Allowed (Y/N)	Character	Generic Edit	1	0	Allow NULL?
112	SLAPTS	Partial Line Shipments Allowed (Y/N)	Character	Generic Edit	1	0	Allow NULL?
113	SLLOB	Line of Business	String	UDC (40 LB)	3	0	Allow NULL?
114	SLEUSE	End Use	String	UDC (40 EU)	3	0	Allow NULL?
115	SLDTYS	Duty Status	String	UDC (40 DS)	2	0	Allow NULL?
116	SLNTR	Nature of Transaction	String	UDC (00 NT)	2	0	Allow NULL?
117	SLVEND	Primary / Last Supplier Number	Numeric	Generic Edit	8	0	Allow NULL?
118	SLCARS	Carrier Number	Numeric	Generic Edit	8	0	Allow NULL?
119	SLMOT	Mode of Transport	String	UDC (00 TM)	3	0	Allow NULL?
120	SLROUT	Route Code	String	UDC (42 RT)	3	0	Allow NULL?
121	SLSTOP	Stop Code	String	UDC (42 SP)	3	0	Allow NULL?
122	SLZON	Zone Number	String	UDC (40 ZN)	3	0	Allow NULL?
123	SLCNID	Container I.D.	String	Generic Edit	20	0	Allow NULL?
124	SLFRTH	Freight Handling Code	String	UDC (42 FR)	3	0	Allow NULL?
125	SLSHCM	Shipping Commodity Class	String	UDC (41 E)	3	0	Allow NULL?
126	SLSHCN	Shipping Conditions Code	String	UDC (41 C)	3	0	Allow NULL?
127	SLSERN	Serial Number - Lot	String	Generic Edit	30	0	Allow NULL?
128	SLUOM1	Unit of Measure - Primary	String	UDC (00 UM)	2	0	Allow NULL?
129	SLPQOR	Units - Primary Quantity Ordered	Numeric	Generic Edit	15	0	Allow NULL?
130	SLUOM2	Unit of Measure - Secondary	String	UDC (00 UM)	2	0	Allow NULL?
131	SLSQOR	Units - Secondary Quantity Ordered	Numeric	Generic Edit	15	0	Allow NULL?
132	SLUOM4	Unit of Measure - Pricing	String	UDC (00 UM)	2	0	Allow NULL?
133	SLITWT	Unit Weight	Numeric	Generic Edit	15	4	Allow NULL?
134	SLWTUM	Weight Unit of Measure	String	UDC (00 UM)	2	0	Allow NULL?
135	SLITVL	Unit Volume	Numeric	Generic Edit	15	4	Allow NULL?
136	SLVLUM	Volume Unit of Measure	String	UDC (00 UM)	2	0	Allow NULL?
137	SLRPRC	Reprice (Basket Price) Category	String	UDC (40 PI)	8	0	Allow NULL?
138	SLORPR	Order Reprice Category	String	UDC (40 PI)	8	0	Allow NULL?
139	SLORP	Order Repriced Indicator	Character	Generic Edit	1	0	Allow NULL?
140	SLCMGP	Costing Method - Inventory	String	Generic Edit	2	0	Allow NULL?
141	SLGLC	G/L Offset	String	Generic Edit	4	0	Allow NULL?
142	SLCTRY	Century	Numeric	Generic Edit	2	0	Allow NULL?
143	SLFY	Fiscal Year	Numeric	Generic Edit	2	0	Allow NULL?
144	SLSO01	Inter Branch Sales	Character	Generic Edit	1	0	Allow NULL?
145	SLSO02	On Hand Updated	Character	Generic Edit	1	0	Allow NULL?
146	SLSO03	Configurator Print Flag	Character	Generic Edit	1	0	Allow NULL?
147	SLSO04	Sales Order Status 04	Character	Generic Edit	1	0	Allow NULL?
148	SLSO05	Substitute Item Indicator	Character	Generic Edit	1	0	Allow NULL?
149	SLSO06	Preference Commitment Indicator	Character	Generic Edit	1	0	Allow NULL?
150	SLSO07	Ship date (PDDJ) overridden	Character	Generic Edit	1	0	Allow NULL?
151	SLSO08	Price Adjustment Line Indicator	Character	Generic Edit	1	0	Allow NULL?
152	SLSO09	Price Adj. History Indicator	Character	Generic Edit	1	0	Allow NULL?
153	SLSO10	Preference Production Allocation	Character	Generic Edit	1	0	Allow NULL?
154	SLSO11	Transfer/Direct Ship/Intercompany Flag	Character	Generic Edit	1	0	Allow NULL?
155	SLSO12	Deferred entries flag	Character	Generic Edit	1	0	Allow NULL?
156	SLSO13	Euro Conversion Status Flag	Character	Generic Edit	1	0	Allow NULL?
157	SLSO14	Sales Order Status 14	Character	Generic Edit	1	0	Allow NULL?
158	SLSO15	Sales Order Status 15	Character	Generic Edit	1	0	Allow NULL?
159	SLACOM	Apply Commission (Y/N)	Character	Generic Edit	1	0	Allow NULL?
160	SLCMCG	Commission Category	String	Generic Edit	8	0	Allow NULL?
161	SLRCD	Reason Code	String	UDC (42 RC)	3	0	Allow NULL?
162	SLGRWT	Gross Weight	Numeric	Generic Edit	15	4	Allow NULL?
163	SLGWUM	Gross Weight Unit of Measure	String	UDC (00 UM)	2	0	Allow NULL?
164	SLSBL	Subledger - G/L	String	Generic Edit	8	0	Allow NULL?
165	SLSBLT	Subledger Type	Character	UDC (00 ST)	1	0	Allow NULL?
166	SLLCOD	Code - Location Tax Status	String	UDC (46 LT)	2	0	Allow NULL?
167	SLUPC1	Price Code 1	String	UDC (40 P1)	2	0	Allow NULL?
168	SLUPC2	Price Code 2	String	UDC (40 P2)	2	0	Allow NULL?
169	SLUPC3	Price Code 3	String	UDC (40 P3)	2	0	Allow NULL?
170	SLSWMS	Status - In Warehouse	Character	Generic Edit	1	0	Allow NULL?
171	SLUNCD	Work Order Freeze Code	Character	UDC (H00 UN)	1	0	Allow NULL?
172	SLCRMD	Send Method	Character	UDC (00 SM)	1	0	Allow NULL?
173	SLCRCD	Currency Code - From	String	Generic Edit	3	0	Allow NULL?
174	SLCRR	Currency Conversion Rate - Spot Rate	Numeric	Generic Edit	15	0	Allow NULL?
175	SLFPRC	Amount - List Price per Unit	Numeric	Generic Edit	15	4	Allow NULL?
176	SLFUP	Amount - Foreign Price per Unit	Numeric	Generic Edit	15	4	Allow NULL?
177	SLFEA	Amount - Foreign Extended Price	Numeric	Generic Edit	15	2	Allow NULL?
178	SLFUC	Amount - Foreign Unit Cost	Numeric	Generic Edit	15	4	Allow NULL?
179	SLFEC	Amount - Foreign Extended Cost	Numeric	Generic Edit	15	2	Allow NULL?
180	SLURCD	User Reserved Code	String	Generic Edit	2	0	Allow NULL?
181	SLURDT	User Reserved Date	Date	Generic Edit	6	0
182	SLURAT	User Reserved Amount	Numeric	Generic Edit	15	2	Allow NULL?
183	SLURAB	User Reserved Number	Numeric	Generic Edit	8	0	Allow NULL?
184	SLURRF	User Reserved Reference	String	Generic Edit	15	0	Allow NULL?
185	SLTORG	Transaction Originator	String	Generic Edit	10	0	Allow NULL?
186	SLUSER	User ID	String	Generic Edit	10	0	Allow NULL?
187	SLPID	Program ID	String	Generic Edit	10	0	Allow NULL?
188	SLJOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
189	SLUPMJ	Date - Updated	Date	Generic Edit	6	0
190	SLTDAY	Time of Day	Numeric	Generic Edit	6	0	Allow NULL?
191	SLSO16	Manufacturing Variance Accounting Flag	Character	Generic Edit	1	0	Allow NULL?
192	SLSO17	Sales Order Status 17	Character	Generic Edit	1	0	Allow NULL?
193	SLSO18	Sales Order Status 18	Character	Generic Edit	1	0	Allow NULL?
194	SLSO19	Sales Order Status 19	Character	Generic Edit	1	0	Allow NULL?
195	SLSO20	Sales Order Status 20	Character	Generic Edit	1	0	Allow NULL?
196	SLIR01	Integration Reference 01	String	Generic Edit	30	0	Allow NULL?
197	SLIR02	Integration Reference 02	String	Generic Edit	30	0	Allow NULL?
198	SLIR03	Integration Reference 03	String	Generic Edit	30	0	Allow NULL?
199	SLIR04	Integration Reference 04	String	Generic Edit	30	0	Allow NULL?
200	SLIR05	Integration Reference 05	String	Generic Edit	30	0	Allow NULL?
201	SLSOOR	Source of Order	Integer	Generic Edit	11	0	Allow NULL?
202	SLVR03	Reference	String	Generic Edit	25	0	Allow NULL?
203	SLDEID	Demand Unique Key ID	Numeric	Generic Edit	15	0	Allow NULL?
204	SLPSIG	Pull Signal	String	Generic Edit	30	0	Allow NULL?
205	SLRLNU	Release Number	String	Generic Edit	10	0	Allow NULL?
206	SLPMDT	Scheduled Shipment Time	Numeric	Generic Edit	6	0	Allow NULL?
207	SLRLTM	Time - Release	Numeric	Generic Edit	6	0	Allow NULL?
208	SLRLDJ	Date - Release	Date	Generic Edit	6	0
209	SLDRQT	Requested Delivery Time	Numeric	Generic Edit	6	0	Allow NULL?
210	SLADTM	Actual Shipment Time	Numeric	Generic Edit	6	0	Allow NULL?
211	SLOPTT	Time - Original Promised Delivery	Numeric	Generic Edit	6	0	Allow NULL?
212	SLPDTT	Time - Scheduled Pick	Numeric	Generic Edit	6	0	Allow NULL?
213	SLPSTM	Time - Future Time 2	Numeric	Generic Edit	6	0	Allow NULL?
214	SLXDCK	Cross-Docking Flag	Character	Generic Edit	1	0	Allow NULL?
215	SLXPTY	Cross Docking Priority for Sales Orders	Numeric	Generic Edit	15	0	Allow NULL?
216	SLDUAL	Dual Unit Of Measure Item	Character	Generic Edit	1	0	Allow NULL?
217	SLBSC	Buying Segment Code	String	UDC (42B BS)	10	0	Allow NULL?
218	SLCBSC	Current Buying Segment Code	String	UDC (42B BS)	10	0	Allow NULL?
219	SLCORD	Change Order Number	Numeric	Generic Edit	3	0	Allow NULL?
220	SLDVAN	Address Number - Deliver To	Numeric	Generic Edit	8	0	Allow NULL?
221	SLPEND	Pending Approval Flag	Character	Generic Edit	1	0	Allow NULL?
222	SLRFRV	Revision Reason	String	UDC (42 RR)	3	0	Allow NULL?
223	SLMCLN	Matrix Control Line Number	Numeric	Generic Edit	6	3	Allow NULL?
224	SLSHPN	Shipment Number	Numeric	Generic Edit	8	0	Allow NULL?
225	SLRSDT	Promised Delivery Time	Numeric	Generic Edit	6	0	Allow NULL?
226	SLPRJM	Project Number	Numeric	Generic Edit	8	0	Allow NULL?
227	SLOSEQ	Sequence Number	Numeric	Generic Edit	4	0	Allow NULL?
228	SLMERL	Item Revision Level	String	Generic Edit	3	0	Allow NULL?
229	SLHOLD	Hold Orders Code	String	UDC (42 HC)	2	0	Allow NULL?
230	SLHDBU	Business Unit - Header	String	Generic Edit	12	0	Allow NULL?
231	SLDMBU	Business Unit - Demand	String	Generic Edit	12	0	Allow NULL?
232	SLBCRC	Currency Code - Base	String	Generic Edit	3	0	Allow NULL?
233	SLODLN	Document Line Number - Original	Numeric	Generic Edit	7	3	Allow NULL?
234	SLOPDJ	Date - Original Promised Delivery	Date	Generic Edit	6	0
235	SLXKCO	Cross Dock Order Company (Order Number)	String	Generic Edit	5	0	Allow NULL?
236	SLXORN	Cross Dock Order No	Numeric	Generic Edit	8	0	Allow NULL?
237	SLXCTO	Cross Dock Order Type	String	UDC (00 DT)	2	0	Allow NULL?
238	SLXLLN	Cross Dock Line Number	Numeric	Generic Edit	6	3	Allow NULL?
239	SLXSFX	Cross Dock Order Suffix	String	Generic Edit	3	0	Allow NULL?
240	SLPOE	Port of Entry or Exit	String	UDC (40 PE)	6	0	Allow NULL?
241	SLPMTO	Payment Terms Override Code	Character	Generic Edit	1	0	Allow NULL?
242	SLANBY	Buyer Number	Numeric	Generic Edit	8	0	Allow NULL?
243	SLPMTN	Promotion ID	String	Generic Edit	12	0	Allow NULL?
244	SLNUMB	Asset Item Number	Numeric	Generic Edit	8	0	Allow NULL?
245	SLAAID	Parent Number	Numeric	Generic Edit	8	0	Allow NULL?
246	SLPRAN8	Partner Address Number	Numeric	Generic Edit	8	0	Allow NULL?
247	SLSPATTN	Ship To Attention	String	Generic Edit	50	0	Allow NULL?
248	SLPRCIDLN	Partner Contact Line Number ID	Numeric	Generic Edit	5	0	Allow NULL?
249	SLCCIDLN	Customer Contact Line Number ID	Numeric	Generic Edit	5	0	Allow NULL?
250	SLSHCCIDLN	Ship To Cust Contact Line Num ID	Numeric	Generic Edit	5	0	Allow NULL?
251	SLOPPID	Opportunity Number	Numeric	Generic Edit	15	0	Allow NULL?
252	SLOSTP	Organization Structure Type	String	UDC (01 TS)	3	0	Allow NULL?
253	SLUKID	Unique Key ID (Internal)	Numeric	Generic Edit	15	0	Allow NULL?
254	SLCATNM	Catalog Name	String	Generic Edit	30	0	Allow NULL?
255	SLALLOC	Allocation Process Flag	Character	Generic Edit	1	0	Allow NULL?
256	SLFULPID	Fulfillment Plan ID	Integer	Generic Edit	11	0	Allow NULL?
257	SLALLSTS	Allocation Status Number	String	UDC (42 AS)	30	0	Allow NULL?
258	SLOSCORE	Sales Order Score	Numeric	Generic Edit	15	3	Allow NULL?
259	SLOSCOREO	Order Score Override	Character	Generic Edit	1	0	Allow NULL?
260	SLCMCO	Customer Master Company	String	Generic Edit	5	0	Allow NULL?
261	SLKITID	Kit Identifier	Numeric	Generic Edit	15	0	Allow NULL?
262	SLKITAMTDOM	Accumulated Amount Invoiced (Domestic)	Numeric	Generic Edit	15	2	Allow NULL?
263	SLKITAMTFOR	Accumulated Amount Invoiced (Foreign)	Numeric	Generic Edit	15	2	Allow NULL?
264	SLKITDIRTY	Kit Component Dirty Flag	Character	Generic Edit	1	0	Allow NULL?
265	SLOCITT	OC In-Transit Flag	Character	Generic Edit	1	0	Allow NULL?
266	SLOCCARDNO	OC Kanban Card No	Numeric	Generic Edit	8	0	Allow NULL?
267	SLPMPN	Production Number	String	Generic Edit	30	0	Allow NULL?
268	SLPNS	Production Number Short	Numeric	Generic Edit	10	0	Allow NULL?

TOP 920 | 42 | F42199 INDEXES

Number

Description

Order Num Order Type (Primary/Unique)

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	UPMJ	Date - Updated	Ascending
6	TDAY	Time of Day	Ascending

Order Num Order Type+

Element	Alias	Description	Sequence
1	KCOO	Order Company (Order Number)	Ascending
2	DOCO	Document (Order No Invoice etc.)	Ascending
3	DCTO	Order Type	Ascending
4	LNID	Line Number	Ascending
5	KCO	Document Company	Ascending
6	DOC	Document (Voucher Invoice etc.)	Ascending
7	DCT	Document Type	Ascending
8	UPMJ	Date - Updated	Ascending
9	TDAY	Time of Day	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

268 COLUMNS | 2 INDEXES | 920 | 42 | F42199 TABLE

TOP 920 | 42 | F42199 COLUMNS

TOP 920 | 42 | F42199 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

268 COLUMNS | 2 INDEXES | 920 | 42 | F42199 TABLE

TOP920 | 42 | F42199 COLUMNS

TOP920 | 42 | F42199 INDEXES

TOP 920 | 42 | F42199 COLUMNS

TOP 920 | 42 | F42199 INDEXES