	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

189 COLUMNS | 4 INDEXES | 920 | 42 | F42UI11 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
42: Sales Management
1	920	F42UI11	ZD	189	4	SO Detail Cache File (MBF)	Regular Work Files	42B: Sales Order Entry

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 ZDCTID, ZDJOBS, ZDLNIX, ZDACTN, ZDKCOO, ZDDOCO, ZDDCTO, ZDLNID, ZDSFXO, ZDMCU, ZDCO, ZDOKCO, ZDOORN, ZDOCTO, ZDOGNO, ZDRKCO, ZDRORN, ZDRCTO, ZDRLLN, ZDDMCT, ZDDMCS, ZDAN8, ZDSHAN, ZDPA8, ZDDRQJ, ZDTRDJ, ZDPDDJ, ZDADDJ, ZDIVD, ZDCNDJ, ZDDGL, ZDRSDJ, ZDPEFJ, ZDVR01, ZDVR02, ZDITM, ZDLITM, ZDAITM, ZDLOCN, ZDLOTN, ZDEXDP, ZDDSC1, ZDDSC2, ZDLNTY, ZDNXTR, ZDLTTR, ZDRLIT, ZDKTLN, ZDCPNT, ZDRKIT, ZDKTP, ZDUOM, ZDUORG, ZDSOQS, ZDSOBK, ZDSOCN, ZDSONE, ZDUOPN, ZDQTYT, ZDQRLV, ZDCOMM, ZDOTQY, ZDUPRC, ZDAEXP, ZDAOPN, ZDPROV, ZDTPC, ZDAPUM, ZDLPRC, ZDUNCS, ZDECST, ZDCSTO, ZDTCST, ZDFUN2, ZDASN, ZDCLVL, ZDODOC, ZDODCT, ZDOKC, ZDPSN, ZDDELN, ZDTAX1, ZDATXT, ZDRESL, ZDAPTS, ZDVEND, ZDCNID, ZDUOM1, ZDPQOR, ZDUOM2, ZDSQOR, ZDUOM4, ZDITWT, ZDWTUM, ZDVLUM, ZDITVL, ZDRPRC, ZDORPR, ZDORP, ZDCMGP, ZDCTRY, ZDFY, ZDCMCG, ZDGRWT, ZDUPC1, ZDUPC2, ZDUPC3, ZDCRCD, ZDCRR, ZDFPRC, ZDFUP, ZDFEA, ZDFUC, ZDFEC, ZDTORG, ZDUSER, ZDPID, ZDJOBN, ZDUPMJ, ZDTDAY, ZDSTKT, ZDWRTH, ZDIVI, ZDCONV, ZDCNV3, ZDKTCM, ZDOT1Y, ZDSTDP, ZDCS07, ZDIT07, ZDTFLA, ZDEDLN, ZDRJOB, ZDDETD, ZDDETF, ZDSHPN, ZDLINN, ZDSLNE, ZDDSGP, ZDBPFG, ZDHCDS, ZDPSR, ZDPSRY, ZDSEQ, ZDRCUP, ZDCMTR, ZDALPH, ZDPMTH, ZDSO16, ZDSO17, ZDSO18, ZDSO19, ZDSO20, ZDIR01, ZDIR02, ZDIR03, ZDIR04, ZDIR05, ZDSOOR, ZDVR03, ZDBSC, ZDCBSC, ZDCORD, ZDDVAN, ZDPEND, ZDRFRV, ZDPRJM, ZDHOLD, ZDODLN, ZDRLNU, ZDDRQT, ZDMCLN, ZDPOE, ZDPMTO, ZDNUMB, ZDAAID, ZDSPATTN, ZDPRAN8, ZDPRCIDLN, ZDCCIDLN, ZDSHCCIDLN, ZDOPPID, ZDOSTP, ZDUKID, ZDCATNM, ZDOPFR, ZDOPERROR, ZDPMPN, ZDPNS FROM F42UI11

TOP 920 | 42 | F42UI11 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	ZDCTID	Computer ID	String	Generic Edit	15	0	Allow NULL?
2	ZDJOBS	Job Number	Numeric	Generic Edit	8	0	Allow NULL?
3	ZDLNIX	Line Number - X-REF	Numeric	Generic Edit	6	3	Allow NULL?
4	ZDACTN	Action Code	Character	Generic Edit	1	0	Allow NULL?
5	ZDKCOO	Order Company (Order Number)	String	Generic Edit	5	0	Allow NULL?
6	ZDDOCO	Document (Order No Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
7	ZDDCTO	Order Type	String	UDC (00 DT)	2	0	Allow NULL?
8	ZDLNID	Line Number	Numeric	Generic Edit	6	3	Allow NULL?
9	ZDSFXO	Order Suffix	String	Generic Edit	3	0	Allow NULL?
10	ZDMCU	Business Unit	String	Generic Edit	12	0	Allow NULL?
11	ZDCO	Company	String	Generic Edit	5	0	Allow NULL?
12	ZDOKCO	Document Company (Original Order)	String	Generic Edit	5	0	Allow NULL?
13	ZDOORN	Original Order Number	String	Generic Edit	8	0	Allow NULL?
14	ZDOCTO	Original Order Type	String	UDC (00 DT)	2	0	Allow NULL?
15	ZDOGNO	Original Line Number	Numeric	Generic Edit	7	3	Allow NULL?
16	ZDRKCO	Company - Key (Related Order)	String	Generic Edit	5	0	Allow NULL?
17	ZDRORN	Related PO/SO/WO Number	String	Generic Edit	8	0	Allow NULL?
18	ZDRCTO	Related PO/SO/WO Order Type	String	UDC (00 DT)	2	0	Allow NULL?
19	ZDRLLN	Related PO/SO Line Number	Numeric	Generic Edit	7	3	Allow NULL?
20	ZDDMCT	Agreement Number - Distribution	String	Generic Edit	12	0	Allow NULL?
21	ZDDMCS	Agreement Supplement - Distribution	Numeric	Generic Edit	3	0	Allow NULL?
22	ZDAN8	Address Number	Numeric	Generic Edit	8	0	Allow NULL?
23	ZDSHAN	Address Number - Ship To	Numeric	Generic Edit	8	0	Allow NULL?
24	ZDPA8	Address Number - Parent	Numeric	Generic Edit	8	0	Allow NULL?
25	ZDDRQJ	Date - Requested	Date	Generic Edit	6	0
26	ZDTRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
27	ZDPDDJ	Date - Scheduled Pick	Date	Generic Edit	6	0
28	ZDADDJ	Date - Actual Ship Date	Date	Generic Edit	6	0
29	ZDIVD	Date - Invoice	Date	Generic Edit	6	0
30	ZDCNDJ	Date - Cancel	Date	Generic Edit	6	0
31	ZDDGL	Date - For G/L (and Voucher)	Date	Generic Edit	6	0
32	ZDRSDJ	Date - Promised Delivery	Date	Generic Edit	6	0
33	ZDPEFJ	Date - Price Effective Date	Date	Generic Edit	6	0
34	ZDVR01	Reference	String	Generic Edit	25	0	Allow NULL?
35	ZDVR02	Reference 2	String	Generic Edit	25	0	Allow NULL?
36	ZDITM	Item Number - Short	Numeric	Generic Edit	8	0	Allow NULL?
37	ZDLITM	2nd Item Number	String	Generic Edit	25	0	Allow NULL?
38	ZDAITM	3rd Item Number	String	Generic Edit	25	0	Allow NULL?
39	ZDLOCN	Location	String	Generic Edit	20	0	Allow NULL?
40	ZDLOTN	Lot/Serial Number	String	Generic Edit	30	0	Allow NULL?
41	ZDEXDP	Days Before Expiration	Numeric	Generic Edit	5	0	Allow NULL?
42	ZDDSC1	Description	String	Generic Edit	30	0	Allow NULL?
43	ZDDSC2	Description - Line 2	String	Generic Edit	30	0	Allow NULL?
44	ZDLNTY	Line Type	String	Generic Edit	2	0	Allow NULL?
45	ZDNXTR	Status Code - Next	String	UDC (40 AT)	3	0	Allow NULL?
46	ZDLTTR	Status Code - Last	String	UDC (40 AT)	3	0	Allow NULL?
47	ZDRLIT	Item Number - Related (Kit)	String	Generic Edit	8	0	Allow NULL?
48	ZDKTLN	Kit Master Line Number	Numeric	Generic Edit	6	3	Allow NULL?
49	ZDCPNT	Component Line Number	Numeric	Generic Edit	4	1	Allow NULL?
50	ZDRKIT	Related Kit Component	Numeric	Generic Edit	8	0	Allow NULL?
51	ZDKTP	Number of Component Per Parent	Numeric	Generic Edit	15	0	Allow NULL?
52	ZDUOM	Unit of Measure as Input	String	UDC (00 UM)	2	0	Allow NULL?
53	ZDUORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	0	Allow NULL?
54	ZDSOQS	Quantity Shipped	Numeric	Generic Edit	15	0	Allow NULL?
55	ZDSOBK	Units - Qty Backordered/Held	Numeric	Generic Edit	15	0	Allow NULL?
56	ZDSOCN	Units - Quantity Canceled/Scrapped	Numeric	Generic Edit	15	0	Allow NULL?
57	ZDSONE	Units - Future Quantity Committed	Numeric	Generic Edit	15	0	Allow NULL?
58	ZDUOPN	Units - Open	Numeric	Generic Edit	15	0	Allow NULL?
59	ZDQTYT	Units - Shipped to Date	Numeric	Generic Edit	15	0	Allow NULL?
60	ZDQRLV	Units - Relieved	Numeric	Generic Edit	15	0	Allow NULL?
61	ZDCOMM	Committed (H/S)	Character	UDC (H42 CP)	1	0	Allow NULL?
62	ZDOTQY	Other Quantity (1/2)	Character	UDC	1	0	Allow NULL?
63	ZDUPRC	Amount - Price per Unit	Numeric	Generic Edit	15	4	Allow NULL?
64	ZDAEXP	Amount - Extended Price	Numeric	Generic Edit	15	2	Allow NULL?
65	ZDAOPN	Amount - Open	Numeric	Generic Edit	15	2	Allow NULL?
66	ZDPROV	Price Override Code	Character	Generic Edit	1	0	Allow NULL?
67	ZDTPC	Temporary Price (Y/N)	Character	Generic Edit	1	0	Allow NULL?
68	ZDAPUM	Unit of Measure - Entered for Unit Price	String	UDC (00 UM)	2	0	Allow NULL?
69	ZDLPRC	Amount - List Price	Numeric	Generic Edit	15	4	Allow NULL?
70	ZDUNCS	Amount - Unit Cost	Numeric	Generic Edit	15	4	Allow NULL?
71	ZDECST	Amount - Extended Cost	Numeric	Generic Edit	15	2	Allow NULL?
72	ZDCSTO	Cost Override Code	Character	Generic Edit	1	0	Allow NULL?
73	ZDTCST	Extended Cost - Transfer	Numeric	Generic Edit	15	4	Allow NULL?
74	ZDFUN2	Trade Discount (Old)	Numeric	Generic Edit	15	4	Allow NULL?
75	ZDASN	Price and Adjustment Schedule	String	UDC (40 AS)	8	0	Allow NULL?
76	ZDCLVL	Pricing Category Level	String	Generic Edit	3	0	Allow NULL?
77	ZDODOC	Document - Original	Numeric	Generic Edit	8	0	Allow NULL?
78	ZDODCT	Document Type - Original	String	UDC (00 DT)	2	0	Allow NULL?
79	ZDOKC	Document Company - Original	String	Generic Edit	5	0	Allow NULL?
80	ZDPSN	Pick Slip Number	Numeric	Generic Edit	8	0	Allow NULL?
81	ZDDELN	Delivery Number	Numeric	Generic Edit	8	0	Allow NULL?
82	ZDTAX1	Sales Taxable (Y/N)	Character	UDC (H00 TV)	1	0	Allow NULL?
83	ZDATXT	Associated Text	Character	Generic Edit	1	0	Allow NULL?
84	ZDRESL	Printed Code	Character	Generic Edit	1	0	Allow NULL?
85	ZDAPTS	Partial Line Shipments Allowed (Y/N)	Character	Generic Edit	1	0	Allow NULL?
86	ZDVEND	Primary / Last Supplier Number	Numeric	Generic Edit	8	0	Allow NULL?
87	ZDCNID	Container I.D.	String	Generic Edit	20	0	Allow NULL?
88	ZDUOM1	Unit of Measure - Primary	String	UDC (00 UM)	2	0	Allow NULL?
89	ZDPQOR	Units - Primary Quantity Ordered	Numeric	Generic Edit	15	0	Allow NULL?
90	ZDUOM2	Unit of Measure - Secondary	String	UDC (00 UM)	2	0	Allow NULL?
91	ZDSQOR	Units - Secondary Quantity Ordered	Numeric	Generic Edit	15	0	Allow NULL?
92	ZDUOM4	Unit of Measure - Pricing	String	UDC (00 UM)	2	0	Allow NULL?
93	ZDITWT	Unit Weight	Numeric	Generic Edit	15	4	Allow NULL?
94	ZDWTUM	Weight Unit of Measure	String	UDC (00 UM)	2	0	Allow NULL?
95	ZDVLUM	Volume Unit of Measure	String	UDC (00 UM)	2	0	Allow NULL?
96	ZDITVL	Unit Volume	Numeric	Generic Edit	15	4	Allow NULL?
97	ZDRPRC	Reprice (Basket Price) Category	String	UDC (40 PI)	8	0	Allow NULL?
98	ZDORPR	Order Reprice Category	String	UDC (40 PI)	8	0	Allow NULL?
99	ZDORP	Order Repriced Indicator	Character	Generic Edit	1	0	Allow NULL?
100	ZDCMGP	Costing Method - Inventory	String	Generic Edit	2	0	Allow NULL?
101	ZDCTRY	Century	Numeric	Generic Edit	2	0	Allow NULL?
102	ZDFY	Fiscal Year	Numeric	Generic Edit	2	0	Allow NULL?
103	ZDCMCG	Commission Category	String	Generic Edit	8	0	Allow NULL?
104	ZDGRWT	Gross Weight	Numeric	Generic Edit	15	4	Allow NULL?
105	ZDUPC1	Price Code 1	String	UDC (40 P1)	2	0	Allow NULL?
106	ZDUPC2	Price Code 2	String	UDC (40 P2)	2	0	Allow NULL?
107	ZDUPC3	Price Code 3	String	UDC (40 P3)	2	0	Allow NULL?
108	ZDCRCD	Currency Code - From	String	Generic Edit	3	0	Allow NULL?
109	ZDCRR	Currency Conversion Rate - Spot Rate	Numeric	Generic Edit	15	0	Allow NULL?
110	ZDFPRC	Amount - List Price per Unit	Numeric	Generic Edit	15	4	Allow NULL?
111	ZDFUP	Amount - Foreign Price per Unit	Numeric	Generic Edit	15	4	Allow NULL?
112	ZDFEA	Amount - Foreign Extended Price	Numeric	Generic Edit	15	2	Allow NULL?
113	ZDFUC	Amount - Foreign Unit Cost	Numeric	Generic Edit	15	4	Allow NULL?
114	ZDFEC	Amount - Foreign Extended Cost	Numeric	Generic Edit	15	2	Allow NULL?
115	ZDTORG	Transaction Originator	String	Generic Edit	10	0	Allow NULL?
116	ZDUSER	User ID	String	Generic Edit	10	0	Allow NULL?
117	ZDPID	Program ID	String	Generic Edit	10	0	Allow NULL?
118	ZDJOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
119	ZDUPMJ	Date - Updated	Date	Generic Edit	6	0
120	ZDTDAY	Time of Day	Numeric	Generic Edit	6	0	Allow NULL?
121	ZDSTKT	Stocking Type	Character	UDC (41 I)	1	0	Allow NULL?
122	ZDWRTH	Flag - Write Ledger Record (Y/N)	Character	Generic Edit	1	0	Allow NULL?
123	ZDIVI	Inventory Interface Y/N - Distribution	Character	UDC (H40 IV)	1	0	Allow NULL?
124	ZDCONV	Conversion Factor	Numeric	Generic Edit	15	7	Allow NULL?
125	ZDCNV3	Conversion Factor - Pricing to Primary	Numeric	Generic Edit	15	7	Allow NULL?
126	ZDKTCM	Kit is Complete (1/0)	Character	Generic Edit	1	0	Allow NULL?
127	ZDOT1Y	Potency Control	Character	Generic Edit	1	0	Allow NULL?
128	ZDSTDP	Standard Potency	Numeric	Generic Edit	7	3	Allow NULL?
129	ZDCS07	Customer Group - Product Allocations	String	UDC (40 07)	8	0	Allow NULL?
130	ZDIT07	Item Group - Product Allocations	String	UDC (40 57)	8	0	Allow NULL?
131	ZDTFLA	Standard Unit of Measure Conversion	String	UDC (H40 ST)	2	0	Allow NULL?
132	ZDEDLN	EDI - Line Number	Numeric	Generic Edit	7	3	Allow NULL?
133	ZDRJOB	Job Number	Numeric	Generic Edit	8	0	Allow NULL?
134	ZDDETD	Amount - Detached Adj. Domestic	Numeric	Generic Edit	15	4	Allow NULL?
135	ZDDETF	Amount - Detached Adj. Foreign	Numeric	Generic Edit	15	4	Allow NULL?
136	ZDSHPN	Shipment Number	Numeric	Generic Edit	8	0	Allow NULL?
137	ZDLINN	Line Number	Numeric	Generic Edit	7	3	Allow NULL?
138	ZDSLNE	Line Number	Numeric	Generic Edit	6	3	Allow NULL?
139	ZDDSGP	Dispatch Group	String	UDC (41B DG)	3	0	Allow NULL?
140	ZDBPFG	Bulk/Packed Flag	Character	UDC (41B BF)	1	0	Allow NULL?
141	ZDHCDS	Hold Codes String	String	Generic Edit	10	0	Allow NULL?
142	ZDPSR	Source	String	Generic Edit	12	0	Allow NULL?
143	ZDPSRY	Source Type	String	UDC (38 DY)	2	0	Allow NULL?
144	ZDSEQ	Sequence Number	Numeric	Generic Edit	6	0	Allow NULL?
145	ZDRCUP	Unedited record flag	Character	Generic Edit	1	0	Allow NULL?
146	ZDCMTR	Commitment Relief (Y/N)	Character	Generic Edit	1	0	Allow NULL?
147	ZDALPH	Name - Alpha	String	Generic Edit	40	0	Allow NULL?
148	ZDPMTH	Method - Kit/Configurator Pricing	Character	UDC (H41 PM)	1	0	Allow NULL?
149	ZDSO16	Manufacturing Variance Accounting Flag	Character	Generic Edit	1	0	Allow NULL?
150	ZDSO17	Sales Order Status 17	Character	Generic Edit	1	0	Allow NULL?
151	ZDSO18	Sales Order Status 18	Character	Generic Edit	1	0	Allow NULL?
152	ZDSO19	Sales Order Status 19	Character	Generic Edit	1	0	Allow NULL?
153	ZDSO20	Sales Order Status 20	Character	Generic Edit	1	0	Allow NULL?
154	ZDIR01	Integration Reference 01	String	Generic Edit	30	0	Allow NULL?
155	ZDIR02	Integration Reference 02	String	Generic Edit	30	0	Allow NULL?
156	ZDIR03	Integration Reference 03	String	Generic Edit	30	0	Allow NULL?
157	ZDIR04	Integration Reference 04	String	Generic Edit	30	0	Allow NULL?
158	ZDIR05	Integration Reference 05	String	Generic Edit	30	0	Allow NULL?
159	ZDSOOR	Source of Order	Integer	Generic Edit	11	0	Allow NULL?
160	ZDVR03	Reference	String	Generic Edit	25	0	Allow NULL?
161	ZDBSC	Buying Segment Code	String	UDC (42B BS)	10	0	Allow NULL?
162	ZDCBSC	Current Buying Segment Code	String	UDC (42B BS)	10	0	Allow NULL?
163	ZDCORD	Change Order Number	Numeric	Generic Edit	3	0	Allow NULL?
164	ZDDVAN	Address Number - Deliver To	Numeric	Generic Edit	8	0	Allow NULL?
165	ZDPEND	Pending Approval Flag	Character	Generic Edit	1	0	Allow NULL?
166	ZDRFRV	Revision Reason	String	UDC (42 RR)	3	0	Allow NULL?
167	ZDPRJM	Project Number	Numeric	Generic Edit	8	0	Allow NULL?
168	ZDHOLD	Hold Orders Code	String	UDC (42 HC)	2	0	Allow NULL?
169	ZDODLN	Document Line Number - Original	Numeric	Generic Edit	7	3	Allow NULL?
170	ZDRLNU	Release Number	String	Generic Edit	10	0	Allow NULL?
171	ZDDRQT	Requested Delivery Time	Numeric	Generic Edit	6	0	Allow NULL?
172	ZDMCLN	Matrix Control Line Number	Numeric	Generic Edit	6	3	Allow NULL?
173	ZDPOE	Port of Entry or Exit	String	UDC (40 PE)	6	0	Allow NULL?
174	ZDPMTO	Payment Terms Override Code	Character	Generic Edit	1	0	Allow NULL?
175	ZDNUMB	Asset Item Number	Numeric	Generic Edit	8	0	Allow NULL?
176	ZDAAID	Parent Number	Numeric	Generic Edit	8	0	Allow NULL?
177	ZDSPATTN	Ship To Attention	String	Generic Edit	50	0	Allow NULL?
178	ZDPRAN8	Partner Address Number	Numeric	Generic Edit	8	0	Allow NULL?
179	ZDPRCIDLN	Partner Contact Line Number ID	Numeric	Generic Edit	5	0	Allow NULL?
180	ZDCCIDLN	Customer Contact Line Number ID	Numeric	Generic Edit	5	0	Allow NULL?
181	ZDSHCCIDLN	Ship To Cust Contact Line Num ID	Numeric	Generic Edit	5	0	Allow NULL?
182	ZDOPPID	Opportunity Number	Numeric	Generic Edit	15	0	Allow NULL?
183	ZDOSTP	Organization Structure Type	String	UDC (01 TS)	3	0	Allow NULL?
184	ZDUKID	Unique Key ID (Internal)	Numeric	Generic Edit	15	0	Allow NULL?
185	ZDCATNM	Catalog Name	String	Generic Edit	30	0	Allow NULL?
186	ZDOPFR	OP Return Flag	Character	Generic Edit	1	0	Allow NULL?
187	ZDOPERROR	IntegrationError	String	Generic Edit	40	0	Allow NULL?
188	ZDPMPN	Production Number	String	Generic Edit	30	0	Allow NULL?
189	ZDPNS	Production Number Short	Numeric	Generic Edit	10	0	Allow NULL?

TOP 920 | 42 | F42UI11 INDEXES

Number

Description

Computer ID Job No (Primary/Unique)

Element	Alias	Description	Sequence
1	CTID	Computer ID	Ascending
2	JOBS	Job Number	Ascending
3	LNIX	Line Number - X-REF	Ascending
4	DOCO	Document (Order No Invoice etc.)	Ascending
5	DCTO	Order Type	Ascending
6	KCOO	Order Company (Order Number)	Ascending
7	LNID	Line Number	Ascending

Compuer ID Job No Item

Element	Alias	Description	Sequence
1	JOBS	Job Number	Ascending
2	CTID	Computer ID	Ascending
3	ITM	Item Number - Short	Ascending

Computer ID Job No SLineNo

Element	Alias	Description	Sequence
1	CTID	Computer ID	Ascending
2	JOBS	Job Number	Ascending
3	SLNE	Line Number	Ascending

Computer ID JobNo MatrixLineNo

Element	Alias	Description	Sequence
1	CTID	Computer ID	Ascending
2	JOBS	Job Number	Ascending
3	MCLN	Matrix Control Line Number	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

189 COLUMNS | 4 INDEXES | 920 | 42 | F42UI11 TABLE

TOP 920 | 42 | F42UI11 COLUMNS

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

189 COLUMNS | 4 INDEXES | 920 | 42 | F42UI11 TABLE

TOP920 | 42 | F42UI11 COLUMNS

TOP920 | 42 | F42UI11 INDEXES

TOP 920 | 42 | F42UI11 COLUMNS

TOP 920 | 42 | F42UI11 INDEXES