	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

189 COLUMNS | 3 INDEXES | 920 | 54R | F54R199 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
54R: Rental Management
1	920	F54R199	DL	189	3	Rental Contract Detail Ledger	Files	54R: Rental 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 DLDOCO, DLDCTO, DLKCOO, DLLNID, DLUKID, DL54RLA, DLMCU, DLCO, DLNUMB, DLITM, DLLITM, DLDSC1, DLDSC2, DLQSLD, DLUOM, DLLOCN, DLLOTN, DLLNTY, DL54RIC, DL54RPM, DLCRMCU, DLEMCU, DLRLIT, DLKTLN, DLCPNT, DLRKIT, DLKTP, DLSRP1, DLSRP2, DLSRP3, DLSRP4, DLSRP5, DLPRP1, DLPRP2, DLPRP3, DLPRP4, DLPRP5, DLACL1, DLACL2, DLACL3, DLACL4, DLACL5, DLAN8, DLDVAN, DLPA8, DLPBAN, DLITAN, DLVR01, DLVR02, DLFTAN, DLSHAN, DL54RCLS, DLENTJ, DLTENT, DL54RCSD, DL54RCST, DL54RCDD, DL54RCDT, DL54RCDAD, DL54RCDAT, DL54RCID, DL54RCIT, DL54RCPED, DL54RCPET, DL54RCAED, DL54RCAET, DL54RCBSD, DL54RCBST, DL54RCBED, DL54RCBET, DLDLIJ, DL54RREF1, DL54RREF2, DL54RARSVD, DL54RCRD, DL54RCRT, DL54RCRCD, DL54RCRCT, DL54RMSTRC, DLPTC, DLRYIN, DLASN, DLPRGP, DLTRDC, DLTAX1, DLEXR1, DLTXCT, DLHOLD, DLNTR, DLCARS, DLMOT, DLCOT, DLROUT, DLSTOP, DLZON, DLCNID, DLFRTH, DLDEL1, DLDEL2, DLAFT, DLCACT, DLCEXP, DLUPRC, DLAPUM, DLPROV, DLERC, DLLPRC, DLUNCS, DLCSTO, DLATUM, DL54RRUNCS, DL54RBOD, DLBCRC, DLCRRM, DLCRCD, DLCRR, DLERDT, DL54RXRFV, DLBILLCRCD, DLFUP, DLFPRC, DLFUC, DL54RRUNCF, DL54RRTO, DL54RUSRD1, DL54RUSRD2, DL54RUSRD3, DL54RUSRT1, DL54RUSRT2, DL54RUSRT3, DL54RUSNB1, DL54RUSNB2, DL54RUSNB3, DLUSER, DLPID, DLUPMJ, DLUPMT, DLJOBN, DLMKEY, DLTORG, DLURCD, DLURDT, DLURAT, DLURAB, DLURRF, DL54RDBILL, DL54RTEMPL, DLTXA1, DL54RLEASE, DL54RLSTY, DLRP01, DLRP02, DLRP03, DLRP04, DLRP05, DLRP06, DLRP07, DLRP08, DLRP09, DLRP10, DLRP11, DLRP12, DLRP13, DLRP14, DLRP15, DLRP16, DLRP17, DLRP18, DLRP19, DLRP20, DL54RSALE1, DL54RSALE2, DL54RLNGP, DL54RAUTN, DL54RIBUM, DLTMCU, DL54RDEF01, DL54RDEF02, DL54RDEF03, DL54RUSRBM, DL54RUSRLT, DL54RTS, DL54RQTYC, DL54RQTYO, DL54RQTYS, DL54RQTYW, DL54RQTYJ, DL54RQTYR, DL54RBCRR FROM F54R199

TOP 920 | 54R | F54R199 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	DLDOCO	Document (Order No Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
2	DLDCTO	Order Type	String	UDC (00 DT)	2	0	Allow NULL?
3	DLKCOO	Order Company (Order Number)	String	Generic Edit	5	0	Allow NULL?
4	DLLNID	Line Number	Numeric	Generic Edit	6	3	Allow NULL?
5	DLUKID	Unique Key ID (Internal)	Numeric	Generic Edit	15	0	Allow NULL?
6	DL54RLA	Ledger Action	String	UDC (54R LA)	2	0	Allow NULL?
7	DLMCU	Business Unit	String	Generic Edit	12	0	Allow NULL?
8	DLCO	Company	String	Generic Edit	5	0	Allow NULL?
9	DLNUMB	Asset Item Number	Numeric	Generic Edit	8	0	Allow NULL?
10	DLITM	Item Number - Short	Numeric	Generic Edit	8	0	Allow NULL?
11	DLLITM	2nd Item Number	String	Generic Edit	25	0	Allow NULL?
12	DLDSC1	Description	String	Generic Edit	30	0	Allow NULL?
13	DLDSC2	Description - Line 2	String	Generic Edit	30	0	Allow NULL?
14	DLQSLD	Quantity Sold	Numeric	Generic Edit	15	0	Allow NULL?
15	DLUOM	Unit of Measure as Input	String	UDC (00 UM)	2	0	Allow NULL?
16	DLLOCN	Location	String	Generic Edit	20	0	Allow NULL?
17	DLLOTN	Lot/Serial Number	String	Generic Edit	30	0	Allow NULL?
18	DLLNTY	Line Type	String	Generic Edit	2	0	Allow NULL?
19	DL54RIC	Inventory Commitment	String	UDC (54R IC)	3	0	Allow NULL?
20	DL54RPM	Billing Method	Character	UDC (54R BM)	1	0	Allow NULL?
21	DLCRMCU	Return Branch	String	Generic Edit	12	0	Allow NULL?
22	DLEMCU	Business Unit - Header	String	Generic Edit	12	0	Allow NULL?
23	DLRLIT	Item Number - Related (Kit)	String	Generic Edit	8	0	Allow NULL?
24	DLKTLN	Kit Master Line Number	Numeric	Generic Edit	6	3	Allow NULL?
25	DLCPNT	Component Line Number	Numeric	Generic Edit	4	1	Allow NULL?
26	DLRKIT	Related Kit Component	Numeric	Generic Edit	8	0	Allow NULL?
27	DLKTP	Number of Component Per Parent	Numeric	Generic Edit	15	0	Allow NULL?
28	DLSRP1	Sales Catalog Section	String	UDC (41 S1)	3	0	Allow NULL?
29	DLSRP2	Sub Section	String	UDC (41 S2)	3	0	Allow NULL?
30	DLSRP3	Sales Category Code 3	String	UDC (41 S3)	3	0	Allow NULL?
31	DLSRP4	Sales Category Code 4	String	UDC (41 S4)	3	0	Allow NULL?
32	DLSRP5	Sales Category Code 5	String	UDC (41 S5)	3	0	Allow NULL?
33	DLPRP1	Commodity Class	String	UDC (41 P1)	3	0	Allow NULL?
34	DLPRP2	Commodity Sub Class	String	UDC (41 P2)	3	0	Allow NULL?
35	DLPRP3	Supplier Rebate Code	String	UDC (41 P3)	3	0	Allow NULL?
36	DLPRP4	Master Planning Family	String	UDC (41 P4)	3	0	Allow NULL?
37	DLPRP5	Purchasing Category Code 5	String	UDC (41 P5)	3	0	Allow NULL?
38	DLACL1	Major Accounting Class	String	UDC (12 C1)	3	0	Allow NULL?
39	DLACL2	Major Equipment Class	String	UDC (12 C2)	3	0	Allow NULL?
40	DLACL3	Manufacturer	String	UDC (12 C3)	3	0	Allow NULL?
41	DLACL4	Model Year	String	UDC (12 C4)	3	0	Allow NULL?
42	DLACL5	Usage Miles or Hours	String	UDC (12 C5)	3	0	Allow NULL?
43	DLAN8	Address Number	Numeric	Generic Edit	8	0	Allow NULL?
44	DLDVAN	Address Number - Deliver To	Numeric	Generic Edit	8	0	Allow NULL?
45	DLPA8	Address Number - Parent	Numeric	Generic Edit	8	0	Allow NULL?
46	DLPBAN	Address Number - Paid By	Numeric	Generic Edit	8	0	Allow NULL?
47	DLITAN	Address Number - Invoiced To	Numeric	Generic Edit	8	0	Allow NULL?
48	DLVR01	Reference	String	Generic Edit	25	0	Allow NULL?
49	DLVR02	Reference 2	String	Generic Edit	25	0	Allow NULL?
50	DLFTAN	Address Number - Forwarded To	Numeric	Generic Edit	8	0	Allow NULL?
51	DLSHAN	Address Number - Ship To	Numeric	Generic Edit	8	0	Allow NULL?
52	DL54RCLS	Contract Line Status	String	UDC (54R LS)	3	0	Allow NULL?
53	DLENTJ	Date - Entered	Date	Generic Edit	6	0
54	DLTENT	Time Entered	Numeric	Generic Edit	6	0	Allow NULL?
55	DL54RCSD	Date - Start	Date	Generic Edit	6	0
56	DL54RCST	Time - Start	Numeric	Generic Edit	6	0	Allow NULL?
57	DL54RCDD	Date - Delivery	Date	Generic Edit	6	0
58	DL54RCDT	Time - Delivery	Numeric	Generic Edit	6	0	Allow NULL?
59	DL54RCDAD	Date - Delivery Actual	Date	Generic Edit	6	0
60	DL54RCDAT	Time - Delivery Actual	Numeric	Generic Edit	6	0	Allow NULL?
61	DL54RCID	Date - Install	Date	Generic Edit	6	0
62	DL54RCIT	Time - Install	Numeric	Generic Edit	6	0	Allow NULL?
63	DL54RCPED	Date - Projected End	Date	Generic Edit	6	0
64	DL54RCPET	Time - Projected End	Numeric	Generic Edit	6	0	Allow NULL?
65	DL54RCAED	Date - Actual End	Date	Generic Edit	6	0
66	DL54RCAET	Time - Actual End	Numeric	Generic Edit	6	0	Allow NULL?
67	DL54RCBSD	Date - Billing Start	Date	Generic Edit	6	0
68	DL54RCBST	Time - Billing Start	Numeric	Generic Edit	6	0	Allow NULL?
69	DL54RCBED	Date - Billing End	Date	Generic Edit	6	0
70	DL54RCBET	Time - Billing End	Numeric	Generic Edit	6	0	Allow NULL?
71	DLDLIJ	Date - Last Invoice (Julian)	Date	Generic Edit	6	0
72	DL54RREF1	Reference 1	String	Generic Edit	50	0	Allow NULL?
73	DL54RREF2	Reference 2	String	Generic Edit	50	0	Allow NULL?
74	DL54RARSVD	Reservation Contract	Character	Generic Edit	1	0	Allow NULL?
75	DL54RCRD	Date - Reservation	Date	Generic Edit	6	0
76	DL54RCRT	Time - Reservation	Numeric	Generic Edit	6	0	Allow NULL?
77	DL54RCRCD	Date - Reservation Cancellation	Date	Generic Edit	6	0
78	DL54RCRCT	Time - Reservation Cancellation	Numeric	Generic Edit	6	0	Allow NULL?
79	DL54RMSTRC	Contract Message	String	UDC (40 PM)	10	0	Allow NULL?
80	DLPTC	Payment Terms Code	String	Generic Edit	3	0	Allow NULL?
81	DLRYIN	Payment Instrument	Character	UDC (00 PY)	1	0	Allow NULL?
82	DLASN	Price and Adjustment Schedule	String	UDC (40 AS)	8	0	Allow NULL?
83	DLPRGP	Pricing Group	String	UDC (40 PC)	8	0	Allow NULL?
84	DLTRDC	Discount - Trade	Numeric	Generic Edit	7	3	Allow NULL?
85	DLTAX1	Sales Taxable (Y/N)	Character	UDC (H00 TV)	1	0	Allow NULL?
86	DLEXR1	Tax Expl Code 1	String	UDC (00 EX)	2	0	Allow NULL?
87	DLTXCT	Certificate Tax Exemption	String	Generic Edit	20	0	Allow NULL?
88	DLHOLD	Hold Orders Code	String	UDC (42 HC)	2	0	Allow NULL?
89	DLNTR	Nature of Transaction	String	UDC (00 NT)	2	0	Allow NULL?
90	DLCARS	Carrier Number	Numeric	Generic Edit	8	0	Allow NULL?
91	DLMOT	Mode of Transport	String	UDC (00 TM)	3	0	Allow NULL?
92	DLCOT	Conditions of Transport	String	UDC (00 TC)	3	0	Allow NULL?
93	DLROUT	Route Code	String	UDC (42 RT)	3	0	Allow NULL?
94	DLSTOP	Stop Code	String	UDC (42 SP)	3	0	Allow NULL?
95	DLZON	Zone Number	String	UDC (40 ZN)	3	0	Allow NULL?
96	DLCNID	Container I.D.	String	Generic Edit	20	0	Allow NULL?
97	DLFRTH	Freight Handling Code	String	UDC (42 FR)	3	0	Allow NULL?
98	DLDEL1	Delivery Instructions Line 1	String	Generic Edit	30	0	Allow NULL?
99	DLDEL2	Delivery Instructions Line 2	String	Generic Edit	30	0	Allow NULL?
100	DLAFT	Apply Freight - Y/N	Character	Generic Edit	1	0	Allow NULL?
101	DLCACT	Account Number - Credit/Bank	String	Generic Edit	25	0	Allow NULL?
102	DLCEXP	Date - Expired (Julian)	Date	Generic Edit	6	0
103	DLUPRC	Amount - Price per Unit	Numeric	Generic Edit	15	4	Allow NULL?
104	DLAPUM	Unit of Measure - Entered for Unit Price	String	UDC (00 UM)	2	0	Allow NULL?
105	DLPROV	Price Override Code	Character	Generic Edit	1	0	Allow NULL?
106	DLERC	Equipment Rate Code	String	UDC (00 RC)	2	0	Allow NULL?
107	DLLPRC	Amount - List Price	Numeric	Generic Edit	15	4	Allow NULL?
108	DLUNCS	Amount - Unit Cost	Numeric	Generic Edit	15	4	Allow NULL?
109	DLCSTO	Cost Override Code	Character	Generic Edit	1	0	Allow NULL?
110	DLATUM	Unit of Measure - Entered for Unit Cost	String	Generic Edit	2	0	Allow NULL?
111	DL54RRUNCS	Amount - Rehire Unit Cost	Numeric	Generic Edit	15	2	Allow NULL?
112	DL54RBOD	Based On Date	Character	Generic Edit	1	0	Allow NULL?
113	DLBCRC	Currency Code - Base	String	Generic Edit	3	0	Allow NULL?
114	DLCRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC (H00 CY)	1	0	Allow NULL?
115	DLCRCD	Currency Code - From	String	Generic Edit	3	0	Allow NULL?
116	DLCRR	Currency Conversion Rate - Spot Rate	Numeric	Generic Edit	15	0	Allow NULL?
117	DLERDT	Date - Exchange Rate	Date	Generic Edit	6	0
118	DL54RXRFV	Exchange Rate - Fixed Or Variable	Character	Generic Edit	1	0	Allow NULL?
119	DLBILLCRCD	Billed Currency Code	String	Generic Edit	3	0	Allow NULL?
120	DLFUP	Amount - Foreign Price per Unit	Numeric	Generic Edit	15	4	Allow NULL?
121	DLFPRC	Amount - List Price per Unit	Numeric	Generic Edit	15	4	Allow NULL?
122	DLFUC	Amount - Foreign Unit Cost	Numeric	Generic Edit	15	4	Allow NULL?
123	DL54RRUNCF	Foreign Amount - Rehire Unit Cost	Numeric	Generic Edit	15	2	Allow NULL?
124	DL54RRTO	Rent To Own	Character	Generic Edit	1	0	Allow NULL?
125	DL54RUSRD1	Date - User Defined 1	Date	Generic Edit	6	0
126	DL54RUSRD2	Date - User Defined 2	Date	Generic Edit	6	0
127	DL54RUSRD3	Date - User Defined 3	Date	Generic Edit	6	0
128	DL54RUSRT1	Time - User Defined 1	Numeric	Generic Edit	6	0	Allow NULL?
129	DL54RUSRT2	Time - User Defined 2	Numeric	Generic Edit	6	0	Allow NULL?
130	DL54RUSRT3	Time - User Defined 3	Numeric	Generic Edit	6	0	Allow NULL?
131	DL54RUSNB1	Number - User Defined 1	Numeric	Generic Edit	8	0	Allow NULL?
132	DL54RUSNB2	Number - User Defined 2	Numeric	Generic Edit	8	0	Allow NULL?
133	DL54RUSNB3	Number - User Defined 3	Numeric	Generic Edit	8	0	Allow NULL?
134	DLUSER	User ID	String	Generic Edit	10	0	Allow NULL?
135	DLPID	Program ID	String	Generic Edit	10	0	Allow NULL?
136	DLUPMJ	Date - Updated	Date	Generic Edit	6	0
137	DLUPMT	Time - Last Updated	Numeric	Generic Edit	6	0	Allow NULL?
138	DLJOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
139	DLMKEY	Machine Key	String	Generic Edit	15	0	Allow NULL?
140	DLTORG	Transaction Originator	String	Generic Edit	10	0	Allow NULL?
141	DLURCD	User Reserved Code	String	Generic Edit	2	0	Allow NULL?
142	DLURDT	User Reserved Date	Date	Generic Edit	6	0
143	DLURAT	User Reserved Amount	Numeric	Generic Edit	15	2	Allow NULL?
144	DLURAB	User Reserved Number	Numeric	Generic Edit	8	0	Allow NULL?
145	DLURRF	User Reserved Reference	String	Generic Edit	15	0	Allow NULL?
146	DL54RDBILL	Detail Billing	Character	Generic Edit	1	0	Allow NULL?
147	DL54RTEMPL	Template Contract	Character	Generic Edit	1	0	Allow NULL?
148	DLTXA1	Tax Rate/Area	String	Generic Edit	10	0	Allow NULL?
149	DL54RLEASE	Lease Flag	Character	Generic Edit	1	0	Allow NULL?
150	DL54RLSTY	Lease Type	String	UDC (54R LT)	2	0	Allow NULL?
151	DLRP01	Division	String	UDC (00 01)	3	0	Allow NULL?
152	DLRP02	Region	String	UDC (00 02)	3	0	Allow NULL?
153	DLRP03	Group	String	UDC (00 03)	3	0	Allow NULL?
154	DLRP04	Branch Office	String	UDC (00 04)	3	0	Allow NULL?
155	DLRP05	Department Type	String	UDC (00 05)	3	0	Allow NULL?
156	DLRP06	Person Responsible	String	UDC (00 06)	3	0	Allow NULL?
157	DLRP07	Line of Business	String	UDC (00 07)	3	0	Allow NULL?
158	DLRP08	Category Code - Business Unit 08	String	UDC (00 08)	3	0	Allow NULL?
159	DLRP09	Category Code - Business Unit 09	String	UDC (00 09)	3	0	Allow NULL?
160	DLRP10	Category Code - Business Unit 10	String	UDC (00 10)	3	0	Allow NULL?
161	DLRP11	Category Code - Business Unit 11	String	UDC (00 11)	3	0	Allow NULL?
162	DLRP12	Category Code - Business Unit 12	String	UDC (00 12)	3	0	Allow NULL?
163	DLRP13	Category Code - Business Unit 13	String	UDC (00 13)	3	0	Allow NULL?
164	DLRP14	Category Code - Business Unit 14	String	UDC (00 14)	3	0	Allow NULL?
165	DLRP15	Category Code - Business Unit 15	String	UDC (00 15)	3	0	Allow NULL?
166	DLRP16	Category Code - Business Unit 16	String	UDC (00 16)	3	0	Allow NULL?
167	DLRP17	Category Code - Business Unit 17	String	UDC (00 17)	3	0	Allow NULL?
168	DLRP18	Category Code - Business Unit 18	String	UDC (00 18)	3	0	Allow NULL?
169	DLRP19	Category Code - Business Unit 19	String	UDC (00 19)	3	0	Allow NULL?
170	DLRP20	Category Code - Business Unit 20	String	UDC (00 20)	3	0	Allow NULL?
171	DL54RSALE1	Contract Salesman 1	Numeric	Generic Edit	8	0	Allow NULL?
172	DL54RSALE2	Contract Salesman 2	Numeric	Generic Edit	8	0	Allow NULL?
173	DL54RLNGP	Language	String	UDC (01 LP)	2	0	Allow NULL?
174	DL54RAUTN	Authorization Number	String	Generic Edit	10	0	Allow NULL?
175	DL54RIBUM	Rental Item Billing UOM	String	UDC (54R UM)	2	0	Allow NULL?
176	DLTMCU	Business Unit - Transfer	String	Generic Edit	12	0	Allow NULL?
177	DL54RDEF01	User Defined Carrier Number Flag	Character	Generic Edit	1	0	Allow NULL?
178	DL54RDEF02	User Defined Mode of Transportation Flag	Character	Generic Edit	1	0	Allow NULL?
179	DL54RDEF03	User Defined Freight Handling Code Flag	Character	Generic Edit	1	0	Allow NULL?
180	DL54RUSRBM	Overriden Billing Method	Character	Generic Edit	1	0	Allow NULL?
181	DL54RUSRLT	Overriden Line Type	Character	Generic Edit	1	0	Allow NULL?
182	DL54RTS	Transfer Status	String	UDC (54R TS)	2	0	Allow NULL?
183	DL54RQTYC	Quantity Scrapped	Numeric	Generic Edit	15	0	Allow NULL?
184	DL54RQTYO	Quantity Open	Numeric	Generic Edit	15	0	Allow NULL?
185	DL54RQTYS	Quantity Stocked	Numeric	Generic Edit	15	0	Allow NULL?
186	DL54RQTYW	Quantity Reworked	Numeric	Generic Edit	15	0	Allow NULL?
187	DL54RQTYJ	Quantity Rejected	Numeric	Generic Edit	15	0	Allow NULL?
188	DL54RQTYR	Quantity Received	Numeric	Generic Edit	15	0	Allow NULL?
189	DL54RBCRR	Billing Exchange Rate	Numeric	Generic Edit	15	0	Allow NULL?

TOP 920 | 54R | F54R199 INDEXES

Number

Description

Primary key (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	UKID	Unique Key ID (Internal)	Ascending

DOCO DCTO KCOO LNID

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

Key UKID Descending

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	UKID	Unique Key ID (Internal)	Descending

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 | 3 INDEXES | 920 | 54R | F54R199 TABLE

TOP 920 | 54R | F54R199 COLUMNS

TOP 920 | 54R | F54R199 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 | 3 INDEXES | 920 | 54R | F54R199 TABLE

TOP920 | 54R | F54R199 COLUMNS

TOP920 | 54R | F54R199 INDEXES

TOP 920 | 54R | F54R199 COLUMNS

TOP 920 | 54R | F54R199 INDEXES