	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

140 COLUMNS | 3 INDEXES | 920 | 54R | F54R099 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
54R: Rental Management
1	920	F54R099	HL	140	3	Rental Contract Header 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 HLDOCO, HLDCTO, HLKCOO, HLUKID, HL54RLA, HLMCU, HLCO, HLRKCO, HLRORN, HLRCTO, HLAN8, HLSHAN, HLDVAN, HLPA8, HLPBAN, HLITAN, HLFTAN, HL54RREF1, HL54RREF2, HLBLFC, HL54RCNTST, HL54RCTJ, HL54RCTT, HL54RCSD, HL54RCST, HL54RCDD, HL54RCDT, HL54RCDAD, HL54RCDAT, HL54RCID, HL54RCIT, HL54RCPED, HL54RCPET, HL54RCAED, HL54RCAET, HL54RCBSD, HL54RCBST, HL54RCBED, HL54RCBET, HLDLIJ, HLVR01, HLVR02, HLVR03, HLDEL1, HLDEL2, HL54RARSVD, HL54RCRD, HL54RCRT, HL54RCRCD, HL54RCRCT, HL54RMSTRC, HLPTC, HLRYIN, HLASN, HLPRGP, HLTRDC, HLEXR1, HLTXA1, HLTXCT, HLHOLD, HLNTR, HLCARS, HLMOT, HLCOT, HLROUT, HLSTOP, HLZON, HLCNID, HLFRTH, HLAFT, HLCACT, HLCEXP, HLCRRM, HLCRCD, HLCRR, HLBCRC, HLERDT, HLBILLCRCD, HLORBY, HLTKBY, HLUPMJ, HLENTJ, HLUSER, HLPID, HLUPMT, HLJOBN, HLMKEY, HLTORG, HLURCD, HLURDT, HLURAT, HLURAB, HLURRF, HLTENT, HL54RIT, HL54RIP, HL54RXRFV, HL54RRTO, HL54RUSRD1, HL54RUSRD2, HL54RUSRD3, HL54RUSRT1, HL54RUSRT2, HL54RUSRT3, HL54RUSNB1, HL54RUSNB2, HL54RUSNB3, HL54RTEMPL, HL54RDBILL, HL54RLEASE, HL54RLSTY, HLRP01, HLRP02, HLRP03, HLRP04, HLRP05, HLRP06, HLRP07, HLRP08, HLRP09, HLRP10, HLRP11, HLRP12, HLRP13, HLRP14, HLRP15, HLRP16, HLRP17, HLRP18, HLRP19, HLRP20, HL54RSALE1, HL54RSALE2, HL54RAUTN, HL54RLNGP, HL54RRQSB, HL54RDEF01, HL54RDEF02, HL54RDEF03, HL54RBCRR FROM F54R099

TOP 920 | 54R | F54R099 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	HLDOCO	Document (Order No Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
2	HLDCTO	Order Type	String	UDC (00 DT)	2	0	Allow NULL?
3	HLKCOO	Order Company (Order Number)	String	Generic Edit	5	0	Allow NULL?
4	HLUKID	Unique Key ID (Internal)	Numeric	Generic Edit	15	0	Allow NULL?
5	HL54RLA	Ledger Action	String	UDC (54R LA)	2	0	Allow NULL?
6	HLMCU	Business Unit	String	Generic Edit	12	0	Allow NULL?
7	HLCO	Company	String	Generic Edit	5	0	Allow NULL?
8	HLRKCO	Company - Key (Related Order)	String	Generic Edit	5	0	Allow NULL?
9	HLRORN	Related PO/SO/WO Number	String	Generic Edit	8	0	Allow NULL?
10	HLRCTO	Related PO/SO/WO Order Type	String	UDC (00 DT)	2	0	Allow NULL?
11	HLAN8	Address Number	Numeric	Generic Edit	8	0	Allow NULL?
12	HLSHAN	Address Number - Ship To	Numeric	Generic Edit	8	0	Allow NULL?
13	HLDVAN	Address Number - Deliver To	Numeric	Generic Edit	8	0	Allow NULL?
14	HLPA8	Address Number - Parent	Numeric	Generic Edit	8	0	Allow NULL?
15	HLPBAN	Address Number - Paid By	Numeric	Generic Edit	8	0	Allow NULL?
16	HLITAN	Address Number - Invoiced To	Numeric	Generic Edit	8	0	Allow NULL?
17	HLFTAN	Address Number - Forwarded To	Numeric	Generic Edit	8	0	Allow NULL?
18	HL54RREF1	Reference 1	String	Generic Edit	50	0	Allow NULL?
19	HL54RREF2	Reference 2	String	Generic Edit	50	0	Allow NULL?
20	HLBLFC	Billing Frequency Code	Character	UDC	1	0	Allow NULL?
21	HL54RCNTST	Contract Status	String	UDC (54R CS)	3	0	Allow NULL?
22	HL54RCTJ	Date - Transaction	Date	Generic Edit	6	0
23	HL54RCTT	Time - Transaction	Numeric	Generic Edit	6	0	Allow NULL?
24	HL54RCSD	Date - Start	Date	Generic Edit	6	0
25	HL54RCST	Time - Start	Numeric	Generic Edit	6	0	Allow NULL?
26	HL54RCDD	Date - Delivery	Date	Generic Edit	6	0
27	HL54RCDT	Time - Delivery	Numeric	Generic Edit	6	0	Allow NULL?
28	HL54RCDAD	Date - Delivery Actual	Date	Generic Edit	6	0
29	HL54RCDAT	Time - Delivery Actual	Numeric	Generic Edit	6	0	Allow NULL?
30	HL54RCID	Date - Install	Date	Generic Edit	6	0
31	HL54RCIT	Time - Install	Numeric	Generic Edit	6	0	Allow NULL?
32	HL54RCPED	Date - Projected End	Date	Generic Edit	6	0
33	HL54RCPET	Time - Projected End	Numeric	Generic Edit	6	0	Allow NULL?
34	HL54RCAED	Date - Actual End	Date	Generic Edit	6	0
35	HL54RCAET	Time - Actual End	Numeric	Generic Edit	6	0	Allow NULL?
36	HL54RCBSD	Date - Billing Start	Date	Generic Edit	6	0
37	HL54RCBST	Time - Billing Start	Numeric	Generic Edit	6	0	Allow NULL?
38	HL54RCBED	Date - Billing End	Date	Generic Edit	6	0
39	HL54RCBET	Time - Billing End	Numeric	Generic Edit	6	0	Allow NULL?
40	HLDLIJ	Date - Last Invoice (Julian)	Date	Generic Edit	6	0
41	HLVR01	Reference	String	Generic Edit	25	0	Allow NULL?
42	HLVR02	Reference 2	String	Generic Edit	25	0	Allow NULL?
43	HLVR03	Reference	String	Generic Edit	25	0	Allow NULL?
44	HLDEL1	Delivery Instructions Line 1	String	Generic Edit	30	0	Allow NULL?
45	HLDEL2	Delivery Instructions Line 2	String	Generic Edit	30	0	Allow NULL?
46	HL54RARSVD	Reservation Contract	Character	Generic Edit	1	0	Allow NULL?
47	HL54RCRD	Date - Reservation	Date	Generic Edit	6	0
48	HL54RCRT	Time - Reservation	Numeric	Generic Edit	6	0	Allow NULL?
49	HL54RCRCD	Date - Reservation Cancellation	Date	Generic Edit	6	0
50	HL54RCRCT	Time - Reservation Cancellation	Numeric	Generic Edit	6	0	Allow NULL?
51	HL54RMSTRC	Contract Message	String	UDC (40 PM)	10	0	Allow NULL?
52	HLPTC	Payment Terms Code	String	Generic Edit	3	0	Allow NULL?
53	HLRYIN	Payment Instrument	Character	UDC (00 PY)	1	0	Allow NULL?
54	HLASN	Price and Adjustment Schedule	String	UDC (40 AS)	8	0	Allow NULL?
55	HLPRGP	Pricing Group	String	UDC (40 PC)	8	0	Allow NULL?
56	HLTRDC	Discount - Trade	Numeric	Generic Edit	7	3	Allow NULL?
57	HLEXR1	Tax Expl Code 1	String	UDC (00 EX)	2	0	Allow NULL?
58	HLTXA1	Tax Rate/Area	String	Generic Edit	10	0	Allow NULL?
59	HLTXCT	Certificate Tax Exemption	String	Generic Edit	20	0	Allow NULL?
60	HLHOLD	Hold Orders Code	String	UDC (42 HC)	2	0	Allow NULL?
61	HLNTR	Nature of Transaction	String	UDC (00 NT)	2	0	Allow NULL?
62	HLCARS	Carrier Number	Numeric	Generic Edit	8	0	Allow NULL?
63	HLMOT	Mode of Transport	String	UDC (00 TM)	3	0	Allow NULL?
64	HLCOT	Conditions of Transport	String	UDC (00 TC)	3	0	Allow NULL?
65	HLROUT	Route Code	String	UDC (42 RT)	3	0	Allow NULL?
66	HLSTOP	Stop Code	String	UDC (42 SP)	3	0	Allow NULL?
67	HLZON	Zone Number	String	UDC (40 ZN)	3	0	Allow NULL?
68	HLCNID	Container I.D.	String	Generic Edit	20	0	Allow NULL?
69	HLFRTH	Freight Handling Code	String	UDC (42 FR)	3	0	Allow NULL?
70	HLAFT	Apply Freight - Y/N	Character	Generic Edit	1	0	Allow NULL?
71	HLCACT	Account Number - Credit/Bank	String	Generic Edit	25	0	Allow NULL?
72	HLCEXP	Date - Expired (Julian)	Date	Generic Edit	6	0
73	HLCRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC (H00 CY)	1	0	Allow NULL?
74	HLCRCD	Currency Code - From	String	Generic Edit	3	0	Allow NULL?
75	HLCRR	Currency Conversion Rate - Spot Rate	Numeric	Generic Edit	15	0	Allow NULL?
76	HLBCRC	Currency Code - Base	String	Generic Edit	3	0	Allow NULL?
77	HLERDT	Date - Exchange Rate	Date	Generic Edit	6	0
78	HLBILLCRCD	Billed Currency Code	String	Generic Edit	3	0	Allow NULL?
79	HLORBY	Ordered By	String	Generic Edit	10	0	Allow NULL?
80	HLTKBY	Order Taken By	String	Generic Edit	10	0	Allow NULL?
81	HLUPMJ	Date - Updated	Date	Generic Edit	6	0
82	HLENTJ	Date - Entered	Date	Generic Edit	6	0
83	HLUSER	User ID	String	Generic Edit	10	0	Allow NULL?
84	HLPID	Program ID	String	Generic Edit	10	0	Allow NULL?
85	HLUPMT	Time - Last Updated	Numeric	Generic Edit	6	0	Allow NULL?
86	HLJOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
87	HLMKEY	Machine Key	String	Generic Edit	15	0	Allow NULL?
88	HLTORG	Transaction Originator	String	Generic Edit	10	0	Allow NULL?
89	HLURCD	User Reserved Code	String	Generic Edit	2	0	Allow NULL?
90	HLURDT	User Reserved Date	Date	Generic Edit	6	0
91	HLURAT	User Reserved Amount	Numeric	Generic Edit	15	2	Allow NULL?
92	HLURAB	User Reserved Number	Numeric	Generic Edit	8	0	Allow NULL?
93	HLURRF	User Reserved Reference	String	Generic Edit	15	0	Allow NULL?
94	HLTENT	Time Entered	Numeric	Generic Edit	6	0	Allow NULL?
95	HL54RIT	Insurance Type	String	UDC (54R IT)	2	0	Allow NULL?
96	HL54RIP	Insurance Policy	String	Generic Edit	30	0	Allow NULL?
97	HL54RXRFV	Exchange Rate - Fixed Or Variable	Character	Generic Edit	1	0	Allow NULL?
98	HL54RRTO	Rent To Own	Character	Generic Edit	1	0	Allow NULL?
99	HL54RUSRD1	Date - User Defined 1	Date	Generic Edit	6	0
100	HL54RUSRD2	Date - User Defined 2	Date	Generic Edit	6	0
101	HL54RUSRD3	Date - User Defined 3	Date	Generic Edit	6	0
102	HL54RUSRT1	Time - User Defined 1	Numeric	Generic Edit	6	0	Allow NULL?
103	HL54RUSRT2	Time - User Defined 2	Numeric	Generic Edit	6	0	Allow NULL?
104	HL54RUSRT3	Time - User Defined 3	Numeric	Generic Edit	6	0	Allow NULL?
105	HL54RUSNB1	Number - User Defined 1	Numeric	Generic Edit	8	0	Allow NULL?
106	HL54RUSNB2	Number - User Defined 2	Numeric	Generic Edit	8	0	Allow NULL?
107	HL54RUSNB3	Number - User Defined 3	Numeric	Generic Edit	8	0	Allow NULL?
108	HL54RTEMPL	Template Contract	Character	Generic Edit	1	0	Allow NULL?
109	HL54RDBILL	Detail Billing	Character	Generic Edit	1	0	Allow NULL?
110	HL54RLEASE	Lease Flag	Character	Generic Edit	1	0	Allow NULL?
111	HL54RLSTY	Lease Type	String	UDC (54R LT)	2	0	Allow NULL?
112	HLRP01	Division	String	UDC (00 01)	3	0	Allow NULL?
113	HLRP02	Region	String	UDC (00 02)	3	0	Allow NULL?
114	HLRP03	Group	String	UDC (00 03)	3	0	Allow NULL?
115	HLRP04	Branch Office	String	UDC (00 04)	3	0	Allow NULL?
116	HLRP05	Department Type	String	UDC (00 05)	3	0	Allow NULL?
117	HLRP06	Person Responsible	String	UDC (00 06)	3	0	Allow NULL?
118	HLRP07	Line of Business	String	UDC (00 07)	3	0	Allow NULL?
119	HLRP08	Category Code - Business Unit 08	String	UDC (00 08)	3	0	Allow NULL?
120	HLRP09	Category Code - Business Unit 09	String	UDC (00 09)	3	0	Allow NULL?
121	HLRP10	Category Code - Business Unit 10	String	UDC (00 10)	3	0	Allow NULL?
122	HLRP11	Category Code - Business Unit 11	String	UDC (00 11)	3	0	Allow NULL?
123	HLRP12	Category Code - Business Unit 12	String	UDC (00 12)	3	0	Allow NULL?
124	HLRP13	Category Code - Business Unit 13	String	UDC (00 13)	3	0	Allow NULL?
125	HLRP14	Category Code - Business Unit 14	String	UDC (00 14)	3	0	Allow NULL?
126	HLRP15	Category Code - Business Unit 15	String	UDC (00 15)	3	0	Allow NULL?
127	HLRP16	Category Code - Business Unit 16	String	UDC (00 16)	3	0	Allow NULL?
128	HLRP17	Category Code - Business Unit 17	String	UDC (00 17)	3	0	Allow NULL?
129	HLRP18	Category Code - Business Unit 18	String	UDC (00 18)	3	0	Allow NULL?
130	HLRP19	Category Code - Business Unit 19	String	UDC (00 19)	3	0	Allow NULL?
131	HLRP20	Category Code - Business Unit 20	String	UDC (00 20)	3	0	Allow NULL?
132	HL54RSALE1	Contract Salesman 1	Numeric	Generic Edit	8	0	Allow NULL?
133	HL54RSALE2	Contract Salesman 2	Numeric	Generic Edit	8	0	Allow NULL?
134	HL54RAUTN	Authorization Number	String	Generic Edit	10	0	Allow NULL?
135	HL54RLNGP	Language	String	UDC (01 LP)	2	0	Allow NULL?
136	HL54RRQSB	Requested Billing Day	Numeric	Generic Edit	2	0	Allow NULL?
137	HL54RDEF01	User Defined Carrier Number Flag	Character	Generic Edit	1	0	Allow NULL?
138	HL54RDEF02	User Defined Mode of Transportation Flag	Character	Generic Edit	1	0	Allow NULL?
139	HL54RDEF03	User Defined Freight Handling Code Flag	Character	Generic Edit	1	0	Allow NULL?
140	HL54RBCRR	Billing Exchange Rate	Numeric	Generic Edit	15	0	Allow NULL?

TOP 920 | 54R | F54R099 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	UKID	Unique Key ID (Internal)	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

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	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

140 COLUMNS | 3 INDEXES | 920 | 54R | F54R099 TABLE

TOP 920 | 54R | F54R099 COLUMNS

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

140 COLUMNS | 3 INDEXES | 920 | 54R | F54R099 TABLE

TOP920 | 54R | F54R099 COLUMNS

TOP920 | 54R | F54R099 INDEXES

TOP 920 | 54R | F54R099 COLUMNS

TOP 920 | 54R | F54R099 INDEXES