920: Top 10 requests

	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

910: Top 10 requests

	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

812: Top 10 requests

	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

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
44H: Homebuilder Management
1	812	F44H501H	LS	184	1	Lot Sales History	Files	44H: Homebuilder Management

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	LSHBMCUS	Community	String	Generic Edit	12	0	Allow NULL?
2	LSHBLOT	Lot Number	String	Generic Edit	4	0	Allow NULL?
3	LSCSSEQ	Sequence - Current Sales	String	Generic Edit	3	0	Allow NULL?
4	LSSHSEQ	Sequence - Lot Sales History	String	Generic Edit	3	0	Allow NULL?
5	LSACTVSEQ	Active Sales Sequence	Character	Generic Edit	1	0	Allow NULL?
6	LSMCU	Business Unit	String	Generic Edit	12	0	Allow NULL?
7	LSHBAREA	HomeBuilder Area ID	String	UDC (00 05)	3	0	Allow NULL?
8	LSCPHASE	Phase	String	Generic Edit	3	0	Allow NULL?
9	LSBYR	Buyer Number	Numeric	Generic Edit	8	0	Allow NULL?
10	LSMLTBYR	Multiple Buyers	Character	Generic Edit	1	0	Allow NULL?
11	LSHBPLAN	Plan Number	String	Generic Edit	4	0	Allow NULL?
12	LSHBELEV	Elevation	String	Generic Edit	3	0	Allow NULL?
13	LSSWING	Swing	Character	UDC (44H2 SW)	1	0	Allow NULL?
14	LSSALLST	Sales Activity Code - Last	String	UDC (44H0 RL)	3	0	Allow NULL?
15	LSSALNXT	Sales Activity Code - Next	String	UDC (44H0 RL)	3	0	Allow NULL?
16	LSDCG	Date - Status Changed	Date	Generic Edit	6	0
17	LSCONACT	Sold at Construction Activity	String	UDC (44H0 RL)	3	0	Allow NULL?
18	LSHBSCS	Sales Contract Status	String	UDC (44H5 ST)	3	0	Allow NULL?
19	LSSDJ	Sales Date (Julian)	Date	Generic Edit	6	0
20	LSSRPDJ	Sale Reported Date (Julian)	Date	Generic Edit	6	0
21	LSSRDJ	Sale Ratified Date (Julian)	Date	Generic Edit	6	0
22	LSCAPRVL	Credit Approval Date (Julian)	Date	Generic Edit	6	0
23	LSECDJ	Projected Close Date (Julian)	Date	Generic Edit	6	0
24	LSCDJ	Close Date (Julian)	Date	Generic Edit	6	0
25	LSEDJ	Cancel Date (Julian)	Date	Generic Edit	6	0
26	LSCSRCD	Cancel Sale Reason Code	String	UDC (44H5 CS)	3	0	Allow NULL?
27	LSCSN1	Cancel Sale Note 1	String	Generic Edit	30	0	Allow NULL?
28	LSCSN2	Cancel Sale Note 2	String	Generic Edit	30	0	Allow NULL?
29	LSCSN3	Cancel Sale Note 3	String	Generic Edit	30	0	Allow NULL?
30	LSBHPRICE	Amount - Base House Sales Price	Numeric	Generic Edit	15	2	Allow NULL?
31	LSLOTPREM	Amount - Lot Premium	Numeric	Generic Edit	15	2	Allow NULL?
32	LSINCA1	Amount - Incentive 1	Numeric	Generic Edit	15	2	Allow NULL?
33	LSINCA2	Amount - Incentive 2	Numeric	Generic Edit	15	2	Allow NULL?
34	LSINCA3	Amount - Incentive 3	Numeric	Generic Edit	15	2	Allow NULL?
35	LSUPG	Amount - Upgrade	Numeric	Generic Edit	15	2	Allow NULL?
36	LSNETBP	Amount - Net Base Price	Numeric	Generic Edit	15	2	Allow NULL?
37	LSOPRV1	Amount - Option Revenue 1	Numeric	Generic Edit	15	2	Allow NULL?
38	LSOPRV2	Amount - Option Revenue 2	Numeric	Generic Edit	15	2	Allow NULL?
39	LSOPRV3	Amount - Option Revenue 3	Numeric	Generic Edit	15	2	Allow NULL?
40	LSOPRV4	Amount - Option Revenue 4	Numeric	Generic Edit	15	2	Allow NULL?
41	LSOPRV5	Amount - Option Revenue 5	Numeric	Generic Edit	15	2	Allow NULL?
42	LSOPRV6	Amount - Option Revenue 6	Numeric	Generic Edit	15	2	Allow NULL?
43	LSOPRV7	Amount - Option Revenue 7	Numeric	Generic Edit	15	2	Allow NULL?
44	LSOPRV8	Amount - Option Revenue 8	Numeric	Generic Edit	15	2	Allow NULL?
45	LSOPRV9	Amount - Option Revenue 9	Numeric	Generic Edit	15	2	Allow NULL?
46	LSOPINCA	Amount - Option Incentive	Numeric	Generic Edit	15	2	Allow NULL?
47	LSNETOPT	Amount - Net Option Price	Numeric	Generic Edit	15	2	Allow NULL?
48	LSTOTSAL	Amount - Total Sales Price	Numeric	Generic Edit	15	2	Allow NULL?
49	LSANSM01	Address Number - Sales Master 1	Numeric	Generic Edit	8	0	Allow NULL?
50	LSANSM02	Address Number - Sales Master 2	Numeric	Generic Edit	8	0	Allow NULL?
51	LSANSM03	Address Number - Sales Master 3	Numeric	Generic Edit	8	0	Allow NULL?
52	LSANSM04	Address Number - Sales Master 4	Numeric	Generic Edit	8	0	Allow NULL?
53	LSANSM05	Address Number - Sales Master 5	Numeric	Generic Edit	8	0	Allow NULL?
54	LSANSM06	Address Number - Sales Master 6	Numeric	Generic Edit	8	0	Allow NULL?
55	LSANSM07	Address Number - Sales Master 7	Numeric	Generic Edit	8	0	Allow NULL?
56	LSANSM08	Address Number - Sales Master 8	Numeric	Generic Edit	8	0	Allow NULL?
57	LSANSM09	Address Number - Sales Master 9	Numeric	Generic Edit	8	0	Allow NULL?
58	LSANSM10	Address Number - Sales Master 10	Numeric	Generic Edit	8	0	Allow NULL?
59	LSCMPCT1	Commission Percentage 1	Numeric	Generic Edit	5	3	Allow NULL?
60	LSCMPCT2	Commission Percentage 2	Numeric	Generic Edit	5	3	Allow NULL?
61	LSCMPCT3	Commission Percentage 3	Numeric	Generic Edit	5	3	Allow NULL?
62	LSCMPCT4	Commission Percentage 4	Numeric	Generic Edit	5	3	Allow NULL?
63	LSCMPCT5	Commission Percentage 5	Numeric	Generic Edit	5	3	Allow NULL?
64	LSCMPCT6	Commission Percentage 6	Numeric	Generic Edit	5	3	Allow NULL?
65	LSCMPCT7	Commission Percentage 7	Numeric	Generic Edit	5	3	Allow NULL?
66	LSCMPCT8	Commission Percentage 8	Numeric	Generic Edit	5	3	Allow NULL?
67	LSCMPCT9	Commission Percentage 9	Numeric	Generic Edit	5	3	Allow NULL?
68	LSCMPCT10	Commission Percentage 10	Numeric	Generic Edit	5	3	Allow NULL?
69	LSCM1	Amount - Commission 1	Numeric	Generic Edit	15	2	Allow NULL?
70	LSCM2	Amount - Commission 2	Numeric	Generic Edit	15	2	Allow NULL?
71	LSCM3	Amount - Commission 3	Numeric	Generic Edit	15	2	Allow NULL?
72	LSCM4	Amount - Commission 4	Numeric	Generic Edit	15	0	Allow NULL?
73	LSCM5	Amount - Commission 5	Numeric	Generic Edit	15	2	Allow NULL?
74	LSCM6	Amount - Commission 6	Numeric	Generic Edit	15	2	Allow NULL?
75	LSCM7	Amount - Commission 7	Numeric	Generic Edit	15	2	Allow NULL?
76	LSCM8	Amount - Commission 8	Numeric	Generic Edit	15	2	Allow NULL?
77	LSCM9	Amount - Commission 9	Numeric	Generic Edit	15	2	Allow NULL?
78	LSCM10	Amount - Commission 10	Numeric	Generic Edit	15	2	Allow NULL?
79	LSLDR	Lender Number	Numeric	Generic Edit	8	0	Allow NULL?
80	LSLOANNUM	Loan Number	String	Generic Edit	25	0	Allow NULL?
81	LSLOANTYP	Loan Type	String	UDC (44H5 LT)	10	0	Allow NULL?
82	LSMGA	Mortage_Amount	Numeric	Generic Edit	15	2	Allow NULL?
83	LSINRTE	Interest Rate	Numeric	Generic Edit	15	4	Allow NULL?
84	LSINRLCK	Interest Rate Lock Date	Date	Generic Edit	6	0
85	LSPXD	Points expiration date	Date	Generic Edit	6	0
86	LSDNPT	Down Payment	Numeric	Generic Edit	15	2	Allow NULL?
87	LSEMD	Earnest Money Deposit	Numeric	Generic Edit	15	2	Allow NULL?
88	LSDTKN	Amount - Deposit Taken	Numeric	Generic Edit	15	2	Allow NULL?
89	LSMAD	Mortgage Approval Date (julian)	Date	Generic Edit	6	0
90	LSTAD	Title Appt. Date	Date	Generic Edit	6	0
91	LSLADJ	Loan Application Date	Date	Generic Edit	6	0
92	LSCTG	Contingent Sale Flag	Character	Generic Edit	1	0	Allow NULL?
93	LSCTGS	Contingent Sale Type	String	Generic Edit	8	0	Allow NULL?
94	LSPTX	Property Text	String	Generic Edit	30	0	Allow NULL?
95	LSCTGJ	Contingency Effective Date	Date	Generic Edit	6	0
96	LSLRD	Listing Receipt Date	Date	Generic Edit	6	0
97	LSCCNVD	Contingency Converted Date	Date	Generic Edit	6	0
98	LSCLJ	Conversion Loss Date	Date	Generic Edit	6	0
99	LSCXD	Contingency Expiration Date	Date	Generic Edit	6	0
100	LSCRD	Contingency Release Date	Date	Generic Edit	6	0
101	LSCN1	Contingent Note 1	String	Generic Edit	30	0	Allow NULL?
102	LSCN2	Contingent Note 2	String	Generic Edit	30	0	Allow NULL?
103	LSLAG	Listing Agent	Numeric	Generic Edit	8	0	Allow NULL?
104	LSDCAPPT	Design Center Appointment	Date	Generic Edit	6	0
105	LSDCSTM	Design Center Appointment Time	String	Generic Edit	8	0	Allow NULL?
106	LSDCADT	Actual Design Center Appointment	Date	Generic Edit	6	0
107	LSCLT	Change Lot	String	Generic Edit	4	0	Allow NULL?
108	LSTEDJ	Transfer Buyer Date (Julian)	Date	Generic Edit	6	0
109	LSTIDJ	Transfer Buyer In Date (Julian)	Date	Generic Edit	6	0
110	LSTLN1	Transfer Lot Note 1	String	Generic Edit	30	0	Allow NULL?
111	LSTLN2	Transfer Lot Note 2	String	Generic Edit	30	0	Allow NULL?
112	LSTLN3	Transfer Lot Note 3	String	Generic Edit	30	0	Allow NULL?
113	LSBSWD	Buyer Scheduled Walkthru Date	Date	Generic Edit	6	0
114	LSBSWT	Buyer Scheduled Walkthru Time	String	Generic Edit	8	0	Allow NULL?
115	LSBAWD	Buyer Actual Walkthru Date	Date	Generic Edit	6	0
116	LSUSD1	User Date 1	Date	Generic Edit	6	0
117	LSUSD2	User Date 2	Date	Generic Edit	6	0
118	LSUSD3	User Date 3	Date	Generic Edit	6	0
119	LSUSD4	User Date 4	Date	Generic Edit	6	0
120	LSUSD5	User Date 5	Date	Generic Edit	6	0
121	LSUSD6	User Date 6	Date	Generic Edit	6	0
122	LSUSD7	User Date 7	Date	Generic Edit	6	0
123	LSUSD8	User Date 8	Date	Generic Edit	6	0
124	LSUSD9	User Date 9	Date	Generic Edit	6	0
125	LSUSD10	User Date 10	Date	Generic Edit	6	0
126	LSUSD11	User Date 11	Date	Generic Edit	6	0
127	LSUSD12	User Date 12	Date	Generic Edit	6	0
128	LSUSD13	User Date 13	Date	Generic Edit	6	0
129	LSUSD14	User Date 14	Date	Generic Edit	6	0
130	LSUSD15	User Date 15	Date	Generic Edit	6	0
131	LSUSD16	User Date 16	Date	Generic Edit	6	0
132	LSUSD17	User Date 17	Date	Generic Edit	6	0
133	LSUSD18	User Date 18	Date	Generic Edit	6	0
134	LSUSD19	User Date 19	Date	Generic Edit	6	0
135	LSUSD20	User Date 20	Date	Generic Edit	6	0
136	LSUAMT01	User Defined Amount 01	Numeric	Generic Edit	15	2	Allow NULL?
137	LSUAMT02	User Defined Amount 02	Numeric	Generic Edit	15	2	Allow NULL?
138	LSUAMT03	User Defined Amount 03	Numeric	Generic Edit	15	2	Allow NULL?
139	LSUAMT04	User Defined Amount 04	Numeric	Generic Edit	15	2	Allow NULL?
140	LSUAMT05	User Defined Amount 05	Numeric	Generic Edit	15	2	Allow NULL?
141	LSUAMT06	User Defined Amount 06	Numeric	Generic Edit	15	2	Allow NULL?
142	LSUAMT07	User Defined Amount 07	Numeric	Generic Edit	15	2	Allow NULL?
143	LSUAMT08	User Defined Amount 08	Numeric	Generic Edit	15	2	Allow NULL?
144	LSUAMT09	User Defined Amount 09	Numeric	Generic Edit	15	2	Allow NULL?
145	LSUAMT10	User Defined Amount 10	Numeric	Generic Edit	15	4	Allow NULL?
146	LSSMC01	Sales Category Code 1	String	UDC (44H5 01)	3	0	Allow NULL?
147	LSSMC02	Sales Category Code 2	String	UDC (44H5 02)	3	0	Allow NULL?
148	LSSMC03	Sales Category Code 3	String	UDC (44H5 03)	3	0	Allow NULL?
149	LSSMC04	Sales Category Code 4	String	UDC (44H5 04)	3	0	Allow NULL?
150	LSSMC05	Sales Category Code 5	String	UDC (44H5 05)	3	0	Allow NULL?
151	LSSMC06	Sales Category Code 6	String	UDC (44H5 06)	3	0	Allow NULL?
152	LSSMC07	Sales Category Code 7	String	UDC (44H5 07)	3	0	Allow NULL?
153	LSSMC08	Sales Category Code 8	String	UDC (44H5 08)	3	0	Allow NULL?
154	LSSMC09	Sales Category Code 9	String	UDC (44H5 09)	3	0	Allow NULL?
155	LSSMC10	Sales Category Code 10	String	UDC (44H5 10)	3	0	Allow NULL?
156	LSUSAN01	Address Number User Defined 01	Numeric	Generic Edit	8	0	Allow NULL?
157	LSUSAN02	Address Number User Defined 02	Numeric	Generic Edit	8	0	Allow NULL?
158	LSUSAN03	Address Number User Defined 03	Numeric	Generic Edit	8	0	Allow NULL?
159	LSUSAN04	Address Number User Defined 04	Numeric	Generic Edit	8	0	Allow NULL?
160	LSUSAN05	Address Number User Defined 05	Numeric	Generic Edit	8	0	Allow NULL?
161	LSHBST1	HomeBuilder Status Code 1	Character	Generic Edit	1	0	Allow NULL?
162	LSHBST2	HomeBuilder Status Code 2	Character	Generic Edit	1	0	Allow NULL?
163	LSHBST3	HomeBuilder Status Code 3	Character	Generic Edit	1	0	Allow NULL?
164	LSHBST4	HomeBuilder Status Code 4	Character	Generic Edit	1	0	Allow NULL?
165	LSHBST5	HomeBuilder Status Code 5	Character	Generic Edit	1	0	Allow NULL?
166	LSCONLST	Construction Status Code Last	String	UDC (44H0 RL)	3	0	Allow NULL?
167	LSCONNXT	Construction Status Code Next	String	UDC (44H0 RL)	3	0	Allow NULL?
168	LSLSTATHB	Lot Status Code - HomeBuilder	Character	UDC (44H2 LS)	1	0	Allow NULL?
169	LSCONSSEQ	Construction Sequence Number	String	Generic Edit	3	0	Allow NULL?
170	LSCTY1	City	String	Generic Edit	25	0	Allow NULL?
171	LSADDS	State	String	UDC (00 S)	3	0	Allow NULL?
172	LSADDZ	Postal Code	String	Generic Edit	12	0	Allow NULL?
173	LSLOTADD	Lot Address	String	Generic Edit	40	0	Allow NULL?
174	LSLPP	Amount - Lot Premium Previous	Numeric	Generic Edit	15	2	Allow NULL?
175	LSCRTU	Created by user	String	Generic Edit	10	0	Allow NULL?
176	LSCRTJ	Date - Created	Date	Generic Edit	6	0
177	LSCRTT	Time - Created	Numeric	Generic Edit	6	0	Allow NULL?
178	LSWRKSTNID	Original Work Station ID	String	Generic Edit	10	0	Allow NULL?
179	LSHBOPID	Original Program ID	String	Generic Edit	10	0	Allow NULL?
180	LSUPMB	Updated By - User	String	Generic Edit	10	0	Allow NULL?
181	LSUPMJ	Date - Updated	Date	Generic Edit	6	0
182	LSUPMT	Time - Last Updated	Numeric	Generic Edit	6	0	Allow NULL?
183	LSJOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
184	LSPID	Program ID	String	Generic Edit	10	0	Allow NULL?

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

184 COLUMNS | 1 INDEXES | 812 | 44H | F44H501H TABLE

TOP 812 | 44H | F44H501H COLUMNS

TOP 812 | 44H | F44H501H 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

184 COLUMNS | 1 INDEXES | 812 | 44H | F44H501H TABLE

TOP812 | 44H | F44H501H COLUMNS

TOP812 | 44H | F44H501H INDEXES

TOP 812 | 44H | F44H501H COLUMNS

TOP 812 | 44H | F44H501H INDEXES