	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

187 COLUMNS | 5 INDEXES | 920 | 54R | F54R11 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
54R: Rental Management
1	920	F54R11	CD	187	5	Rental Contract Detail	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 CDDOCO, CDDCTO, CDKCOO, CDLNID, CDMCU, CDCO, CDNUMB, CDITM, CDLITM, CDDSC1, CDDSC2, CDQSLD, CD54RQTYO, CD54RQTYS, CD54RQTYW, CD54RQTYJ, CD54RQTYC, CD54RQTYR, CDUOM, CDLOCN, CDLOTN, CDLNTY, CD54RIC, CD54RPM, CDCRMCU, CDEMCU, CDRLIT, CDKTLN, CDCPNT, CDRKIT, CDKTP, CDSRP1, CDSRP2, CDSRP3, CDSRP4, CDSRP5, CDPRP1, CDPRP2, CDPRP3, CDPRP4, CDPRP5, CDACL1, CDACL2, CDACL3, CDACL4, CDACL5, CDAN8, CDDVAN, CDPA8, CDPBAN, CDITAN, CDVR01, CDVR02, CDFTAN, CDSHAN, CD54RCLS, CDENTJ, CDTENT, CD54RCSD, CD54RCST, CD54RCDD, CD54RCDT, CD54RCDAD, CD54RCDAT, CD54RCID, CD54RCIT, CD54RCPED, CD54RCPET, CD54RCAED, CD54RCAET, CD54RCBSD, CD54RCBST, CD54RCBED, CD54RCBET, CDDLIJ, CD54RREF1, CD54RREF2, CD54RARSVD, CD54RCRD, CD54RCRT, CD54RCRCD, CD54RCRCT, CD54RMSTRC, CDPTC, CDRYIN, CDASN, CDPRGP, CDTRDC, CDTAX1, CDEXR1, CDTXCT, CDHOLD, CDNTR, CDCARS, CDMOT, CDCOT, CDROUT, CDSTOP, CDZON, CDCNID, CDFRTH, CDDEL1, CDDEL2, CDAFT, CDCACT, CDCEXP, CDUPRC, CDAPUM, CDPROV, CDERC, CDLPRC, CDUNCS, CDCSTO, CDATUM, CD54RRUNCS, CD54RBOD, CDBCRC, CDCRRM, CDCRCD, CDCRR, CDERDT, CD54RXRFV, CDBILLCRCD, CDFUP, CDFPRC, CDFUC, CD54RRUNCF, CD54RRTO, CD54RUSRD1, CD54RUSRD2, CD54RUSRD3, CD54RUSRT1, CD54RUSRT2, CD54RUSRT3, CD54RUSNB1, CD54RUSNB2, CD54RUSNB3, CDUSER, CDPID, CDUPMJ, CDUPMT, CDJOBN, CDMKEY, CDTORG, CDURCD, CDURDT, CDURAT, CDURAB, CDURRF, CD54RDBILL, CD54RTEMPL, CDTXA1, CD54RLEASE, CD54RLSTY, CDRP01, CDRP02, CDRP03, CDRP04, CDRP05, CDRP06, CDRP07, CDRP08, CDRP09, CDRP10, CDRP11, CDRP12, CDRP13, CDRP14, CDRP15, CDRP16, CDRP17, CDRP18, CDRP19, CDRP20, CD54RSALE1, CD54RSALE2, CD54RLNGP, CD54RAUTN, CD54RIBUM, CDTMCU, CD54RDEF01, CD54RDEF02, CD54RDEF03, CD54RUSRBM, CD54RUSRLT, CD54RTS, CD54RBCRR FROM F54R11

TOP 920 | 54R | F54R11 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	CDDOCO	Document (Order No Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
2	CDDCTO	Order Type	String	UDC (00 DT)	2	0	Allow NULL?
3	CDKCOO	Order Company (Order Number)	String	Generic Edit	5	0	Allow NULL?
4	CDLNID	Line Number	Numeric	Generic Edit	6	3	Allow NULL?
5	CDMCU	Business Unit	String	Generic Edit	12	0	Allow NULL?
6	CDCO	Company	String	Generic Edit	5	0	Allow NULL?
7	CDNUMB	Asset Item Number	Numeric	Generic Edit	8	0	Allow NULL?
8	CDITM	Item Number - Short	Numeric	Generic Edit	8	0	Allow NULL?
9	CDLITM	2nd Item Number	String	Generic Edit	25	0	Allow NULL?
10	CDDSC1	Description	String	Generic Edit	30	0	Allow NULL?
11	CDDSC2	Description - Line 2	String	Generic Edit	30	0	Allow NULL?
12	CDQSLD	Quantity Sold	Numeric	Generic Edit	15	0	Allow NULL?
13	CD54RQTYO	Quantity Open	Numeric	Generic Edit	15	0	Allow NULL?
14	CD54RQTYS	Quantity Stocked	Numeric	Generic Edit	15	0	Allow NULL?
15	CD54RQTYW	Quantity Reworked	Numeric	Generic Edit	15	0	Allow NULL?
16	CD54RQTYJ	Quantity Rejected	Numeric	Generic Edit	15	0	Allow NULL?
17	CD54RQTYC	Quantity Scrapped	Numeric	Generic Edit	15	0	Allow NULL?
18	CD54RQTYR	Quantity Received	Numeric	Generic Edit	15	0	Allow NULL?
19	CDUOM	Unit of Measure as Input	String	UDC (00 UM)	2	0	Allow NULL?
20	CDLOCN	Location	String	Generic Edit	20	0	Allow NULL?
21	CDLOTN	Lot/Serial Number	String	Generic Edit	30	0	Allow NULL?
22	CDLNTY	Line Type	String	Generic Edit	2	0	Allow NULL?
23	CD54RIC	Inventory Commitment	String	UDC (54R IC)	3	0	Allow NULL?
24	CD54RPM	Billing Method	Character	UDC (54R BM)	1	0	Allow NULL?
25	CDCRMCU	Return Branch	String	Generic Edit	12	0	Allow NULL?
26	CDEMCU	Business Unit - Header	String	Generic Edit	12	0	Allow NULL?
27	CDRLIT	Item Number - Related (Kit)	String	Generic Edit	8	0	Allow NULL?
28	CDKTLN	Kit Master Line Number	Numeric	Generic Edit	6	3	Allow NULL?
29	CDCPNT	Component Line Number	Numeric	Generic Edit	4	1	Allow NULL?
30	CDRKIT	Related Kit Component	Numeric	Generic Edit	8	0	Allow NULL?
31	CDKTP	Number of Component Per Parent	Numeric	Generic Edit	15	0	Allow NULL?
32	CDSRP1	Sales Catalog Section	String	UDC (41 S1)	3	0	Allow NULL?
33	CDSRP2	Sub Section	String	UDC (41 S2)	3	0	Allow NULL?
34	CDSRP3	Sales Category Code 3	String	UDC (41 S3)	3	0	Allow NULL?
35	CDSRP4	Sales Category Code 4	String	UDC (41 S4)	3	0	Allow NULL?
36	CDSRP5	Sales Category Code 5	String	UDC (41 S5)	3	0	Allow NULL?
37	CDPRP1	Commodity Class	String	UDC (41 P1)	3	0	Allow NULL?
38	CDPRP2	Commodity Sub Class	String	UDC (41 P2)	3	0	Allow NULL?
39	CDPRP3	Supplier Rebate Code	String	UDC (41 P3)	3	0	Allow NULL?
40	CDPRP4	Master Planning Family	String	UDC (41 P4)	3	0	Allow NULL?
41	CDPRP5	Purchasing Category Code 5	String	UDC (41 P5)	3	0	Allow NULL?
42	CDACL1	Major Accounting Class	String	UDC (12 C1)	3	0	Allow NULL?
43	CDACL2	Major Equipment Class	String	UDC (12 C2)	3	0	Allow NULL?
44	CDACL3	Manufacturer	String	UDC (12 C3)	3	0	Allow NULL?
45	CDACL4	Model Year	String	UDC (12 C4)	3	0	Allow NULL?
46	CDACL5	Usage Miles or Hours	String	UDC (12 C5)	3	0	Allow NULL?
47	CDAN8	Address Number	Numeric	Generic Edit	8	0	Allow NULL?
48	CDDVAN	Address Number - Deliver To	Numeric	Generic Edit	8	0	Allow NULL?
49	CDPA8	Address Number - Parent	Numeric	Generic Edit	8	0	Allow NULL?
50	CDPBAN	Address Number - Paid By	Numeric	Generic Edit	8	0	Allow NULL?
51	CDITAN	Address Number - Invoiced To	Numeric	Generic Edit	8	0	Allow NULL?
52	CDVR01	Reference	String	Generic Edit	25	0	Allow NULL?
53	CDVR02	Reference 2	String	Generic Edit	25	0	Allow NULL?
54	CDFTAN	Address Number - Forwarded To	Numeric	Generic Edit	8	0	Allow NULL?
55	CDSHAN	Address Number - Ship To	Numeric	Generic Edit	8	0	Allow NULL?
56	CD54RCLS	Contract Line Status	String	UDC (54R LS)	3	0	Allow NULL?
57	CDENTJ	Date - Entered	Date	Generic Edit	6	0
58	CDTENT	Time Entered	Numeric	Generic Edit	6	0	Allow NULL?
59	CD54RCSD	Date - Start	Date	Generic Edit	6	0
60	CD54RCST	Time - Start	Numeric	Generic Edit	6	0	Allow NULL?
61	CD54RCDD	Date - Delivery	Date	Generic Edit	6	0
62	CD54RCDT	Time - Delivery	Numeric	Generic Edit	6	0	Allow NULL?
63	CD54RCDAD	Date - Delivery Actual	Date	Generic Edit	6	0
64	CD54RCDAT	Time - Delivery Actual	Numeric	Generic Edit	6	0	Allow NULL?
65	CD54RCID	Date - Install	Date	Generic Edit	6	0
66	CD54RCIT	Time - Install	Numeric	Generic Edit	6	0	Allow NULL?
67	CD54RCPED	Date - Projected End	Date	Generic Edit	6	0
68	CD54RCPET	Time - Projected End	Numeric	Generic Edit	6	0	Allow NULL?
69	CD54RCAED	Date - Actual End	Date	Generic Edit	6	0
70	CD54RCAET	Time - Actual End	Numeric	Generic Edit	6	0	Allow NULL?
71	CD54RCBSD	Date - Billing Start	Date	Generic Edit	6	0
72	CD54RCBST	Time - Billing Start	Numeric	Generic Edit	6	0	Allow NULL?
73	CD54RCBED	Date - Billing End	Date	Generic Edit	6	0
74	CD54RCBET	Time - Billing End	Numeric	Generic Edit	6	0	Allow NULL?
75	CDDLIJ	Date - Last Invoice (Julian)	Date	Generic Edit	6	0
76	CD54RREF1	Reference 1	String	Generic Edit	50	0	Allow NULL?
77	CD54RREF2	Reference 2	String	Generic Edit	50	0	Allow NULL?
78	CD54RARSVD	Reservation Contract	Character	Generic Edit	1	0	Allow NULL?
79	CD54RCRD	Date - Reservation	Date	Generic Edit	6	0
80	CD54RCRT	Time - Reservation	Numeric	Generic Edit	6	0	Allow NULL?
81	CD54RCRCD	Date - Reservation Cancellation	Date	Generic Edit	6	0
82	CD54RCRCT	Time - Reservation Cancellation	Numeric	Generic Edit	6	0	Allow NULL?
83	CD54RMSTRC	Contract Message	String	UDC (40 PM)	10	0	Allow NULL?
84	CDPTC	Payment Terms Code	String	Generic Edit	3	0	Allow NULL?
85	CDRYIN	Payment Instrument	Character	UDC (00 PY)	1	0	Allow NULL?
86	CDASN	Price and Adjustment Schedule	String	UDC (40 AS)	8	0	Allow NULL?
87	CDPRGP	Pricing Group	String	UDC (40 PC)	8	0	Allow NULL?
88	CDTRDC	Discount - Trade	Numeric	Generic Edit	7	3	Allow NULL?
89	CDTAX1	Sales Taxable (Y/N)	Character	UDC (H00 TV)	1	0	Allow NULL?
90	CDEXR1	Tax Expl Code 1	String	UDC (00 EX)	2	0	Allow NULL?
91	CDTXCT	Certificate Tax Exemption	String	Generic Edit	20	0	Allow NULL?
92	CDHOLD	Hold Orders Code	String	UDC (42 HC)	2	0	Allow NULL?
93	CDNTR	Nature of Transaction	String	UDC (00 NT)	2	0	Allow NULL?
94	CDCARS	Carrier Number	Numeric	Generic Edit	8	0	Allow NULL?
95	CDMOT	Mode of Transport	String	UDC (00 TM)	3	0	Allow NULL?
96	CDCOT	Conditions of Transport	String	UDC (00 TC)	3	0	Allow NULL?
97	CDROUT	Route Code	String	UDC (42 RT)	3	0	Allow NULL?
98	CDSTOP	Stop Code	String	UDC (42 SP)	3	0	Allow NULL?
99	CDZON	Zone Number	String	UDC (40 ZN)	3	0	Allow NULL?
100	CDCNID	Container I.D.	String	Generic Edit	20	0	Allow NULL?
101	CDFRTH	Freight Handling Code	String	UDC (42 FR)	3	0	Allow NULL?
102	CDDEL1	Delivery Instructions Line 1	String	Generic Edit	30	0	Allow NULL?
103	CDDEL2	Delivery Instructions Line 2	String	Generic Edit	30	0	Allow NULL?
104	CDAFT	Apply Freight - Y/N	Character	Generic Edit	1	0	Allow NULL?
105	CDCACT	Account Number - Credit/Bank	String	Generic Edit	25	0	Allow NULL?
106	CDCEXP	Date - Expired (Julian)	Date	Generic Edit	6	0
107	CDUPRC	Amount - Price per Unit	Numeric	Generic Edit	15	4	Allow NULL?
108	CDAPUM	Unit of Measure - Entered for Unit Price	String	UDC (00 UM)	2	0	Allow NULL?
109	CDPROV	Price Override Code	Character	Generic Edit	1	0	Allow NULL?
110	CDERC	Equipment Rate Code	String	UDC (00 RC)	2	0	Allow NULL?
111	CDLPRC	Amount - List Price	Numeric	Generic Edit	15	4	Allow NULL?
112	CDUNCS	Amount - Unit Cost	Numeric	Generic Edit	15	4	Allow NULL?
113	CDCSTO	Cost Override Code	Character	Generic Edit	1	0	Allow NULL?
114	CDATUM	Unit of Measure - Entered for Unit Cost	String	Generic Edit	2	0	Allow NULL?
115	CD54RRUNCS	Amount - Rehire Unit Cost	Numeric	Generic Edit	15	2	Allow NULL?
116	CD54RBOD	Based On Date	Character	Generic Edit	1	0	Allow NULL?
117	CDBCRC	Currency Code - Base	String	Generic Edit	3	0	Allow NULL?
118	CDCRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC (H00 CY)	1	0	Allow NULL?
119	CDCRCD	Currency Code - From	String	Generic Edit	3	0	Allow NULL?
120	CDCRR	Currency Conversion Rate - Spot Rate	Numeric	Generic Edit	15	0	Allow NULL?
121	CDERDT	Date - Exchange Rate	Date	Generic Edit	6	0
122	CD54RXRFV	Exchange Rate - Fixed Or Variable	Character	Generic Edit	1	0	Allow NULL?
123	CDBILLCRCD	Billed Currency Code	String	Generic Edit	3	0	Allow NULL?
124	CDFUP	Amount - Foreign Price per Unit	Numeric	Generic Edit	15	4	Allow NULL?
125	CDFPRC	Amount - List Price per Unit	Numeric	Generic Edit	15	4	Allow NULL?
126	CDFUC	Amount - Foreign Unit Cost	Numeric	Generic Edit	15	4	Allow NULL?
127	CD54RRUNCF	Foreign Amount - Rehire Unit Cost	Numeric	Generic Edit	15	2	Allow NULL?
128	CD54RRTO	Rent To Own	Character	Generic Edit	1	0	Allow NULL?
129	CD54RUSRD1	Date - User Defined 1	Date	Generic Edit	6	0
130	CD54RUSRD2	Date - User Defined 2	Date	Generic Edit	6	0
131	CD54RUSRD3	Date - User Defined 3	Date	Generic Edit	6	0
132	CD54RUSRT1	Time - User Defined 1	Numeric	Generic Edit	6	0	Allow NULL?
133	CD54RUSRT2	Time - User Defined 2	Numeric	Generic Edit	6	0	Allow NULL?
134	CD54RUSRT3	Time - User Defined 3	Numeric	Generic Edit	6	0	Allow NULL?
135	CD54RUSNB1	Number - User Defined 1	Numeric	Generic Edit	8	0	Allow NULL?
136	CD54RUSNB2	Number - User Defined 2	Numeric	Generic Edit	8	0	Allow NULL?
137	CD54RUSNB3	Number - User Defined 3	Numeric	Generic Edit	8	0	Allow NULL?
138	CDUSER	User ID	String	Generic Edit	10	0	Allow NULL?
139	CDPID	Program ID	String	Generic Edit	10	0	Allow NULL?
140	CDUPMJ	Date - Updated	Date	Generic Edit	6	0
141	CDUPMT	Time - Last Updated	Numeric	Generic Edit	6	0	Allow NULL?
142	CDJOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
143	CDMKEY	Machine Key	String	Generic Edit	15	0	Allow NULL?
144	CDTORG	Transaction Originator	String	Generic Edit	10	0	Allow NULL?
145	CDURCD	User Reserved Code	String	Generic Edit	2	0	Allow NULL?
146	CDURDT	User Reserved Date	Date	Generic Edit	6	0
147	CDURAT	User Reserved Amount	Numeric	Generic Edit	15	2	Allow NULL?
148	CDURAB	User Reserved Number	Numeric	Generic Edit	8	0	Allow NULL?
149	CDURRF	User Reserved Reference	String	Generic Edit	15	0	Allow NULL?
150	CD54RDBILL	Detail Billing	Character	Generic Edit	1	0	Allow NULL?
151	CD54RTEMPL	Template Contract	Character	Generic Edit	1	0	Allow NULL?
152	CDTXA1	Tax Rate/Area	String	Generic Edit	10	0	Allow NULL?
153	CD54RLEASE	Lease Flag	Character	Generic Edit	1	0	Allow NULL?
154	CD54RLSTY	Lease Type	String	UDC (54R LT)	2	0	Allow NULL?
155	CDRP01	Division	String	UDC (00 01)	3	0	Allow NULL?
156	CDRP02	Region	String	UDC (00 02)	3	0	Allow NULL?
157	CDRP03	Group	String	UDC (00 03)	3	0	Allow NULL?
158	CDRP04	Branch Office	String	UDC (00 04)	3	0	Allow NULL?
159	CDRP05	Department Type	String	UDC (00 05)	3	0	Allow NULL?
160	CDRP06	Person Responsible	String	UDC (00 06)	3	0	Allow NULL?
161	CDRP07	Line of Business	String	UDC (00 07)	3	0	Allow NULL?
162	CDRP08	Category Code - Business Unit 08	String	UDC (00 08)	3	0	Allow NULL?
163	CDRP09	Category Code - Business Unit 09	String	UDC (00 09)	3	0	Allow NULL?
164	CDRP10	Category Code - Business Unit 10	String	UDC (00 10)	3	0	Allow NULL?
165	CDRP11	Category Code - Business Unit 11	String	UDC (00 11)	3	0	Allow NULL?
166	CDRP12	Category Code - Business Unit 12	String	UDC (00 12)	3	0	Allow NULL?
167	CDRP13	Category Code - Business Unit 13	String	UDC (00 13)	3	0	Allow NULL?
168	CDRP14	Category Code - Business Unit 14	String	UDC (00 14)	3	0	Allow NULL?
169	CDRP15	Category Code - Business Unit 15	String	UDC (00 15)	3	0	Allow NULL?
170	CDRP16	Category Code - Business Unit 16	String	UDC (00 16)	3	0	Allow NULL?
171	CDRP17	Category Code - Business Unit 17	String	UDC (00 17)	3	0	Allow NULL?
172	CDRP18	Category Code - Business Unit 18	String	UDC (00 18)	3	0	Allow NULL?
173	CDRP19	Category Code - Business Unit 19	String	UDC (00 19)	3	0	Allow NULL?
174	CDRP20	Category Code - Business Unit 20	String	UDC (00 20)	3	0	Allow NULL?
175	CD54RSALE1	Contract Salesman 1	Numeric	Generic Edit	8	0	Allow NULL?
176	CD54RSALE2	Contract Salesman 2	Numeric	Generic Edit	8	0	Allow NULL?
177	CD54RLNGP	Language	String	UDC (01 LP)	2	0	Allow NULL?
178	CD54RAUTN	Authorization Number	String	Generic Edit	10	0	Allow NULL?
179	CD54RIBUM	Rental Item Billing UOM	String	UDC (54R UM)	2	0	Allow NULL?
180	CDTMCU	Business Unit - Transfer	String	Generic Edit	12	0	Allow NULL?
181	CD54RDEF01	User Defined Carrier Number Flag	Character	Generic Edit	1	0	Allow NULL?
182	CD54RDEF02	User Defined Mode of Transportation Flag	Character	Generic Edit	1	0	Allow NULL?
183	CD54RDEF03	User Defined Freight Handling Code Flag	Character	Generic Edit	1	0	Allow NULL?
184	CD54RUSRBM	Overriden Billing Method	Character	Generic Edit	1	0	Allow NULL?
185	CD54RUSRLT	Overriden Line Type	Character	Generic Edit	1	0	Allow NULL?
186	CD54RTS	Transfer Status	String	UDC (54R TS)	2	0	Allow NULL?
187	CD54RBCRR	Billing Exchange Rate	Numeric	Generic Edit	15	0	Allow NULL?

TOP 920 | 54R | F54R11 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

DOCO DCTO KCOO

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

DOCO DCTO KCOO 54RIC

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	54RIC	Inventory Commitment	Ascending

DOCO DCTO KCOO 54RIC ++

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	54RIC	Inventory Commitment	Ascending
5	54RCLS	Contract Line Status	Ascending

DOCO DCTO KCOO 54RCLS

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	54RCLS	Contract Line Status	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

187 COLUMNS | 5 INDEXES | 920 | 54R | F54R11 TABLE

TOP 920 | 54R | F54R11 COLUMNS

TOP 920 | 54R | F54R11 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

187 COLUMNS | 5 INDEXES | 920 | 54R | F54R11 TABLE

TOP920 | 54R | F54R11 COLUMNS

TOP920 | 54R | F54R11 INDEXES

TOP 920 | 54R | F54R11 COLUMNS

TOP 920 | 54R | F54R11 INDEXES