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	F44H501	SM	174	1	Sales Master Table	Files	44H: Homebuilder Management

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	SMHBMCUS	Community	String	Generic Edit	12	0	Allow NULL?
2	SMHBLOT	Lot Number	String	Generic Edit	4	0	Allow NULL?
3	SMCSSEQ	Sequence - Current Sales	String	Generic Edit	3	0	Allow NULL?
4	SMACTVSEQ	Active Sales Sequence	Character	Generic Edit	1	0	Allow NULL?
5	SMMCU	Business Unit	String	Generic Edit	12	0	Allow NULL?
6	SMHBAREA	HomeBuilder Area ID	String	UDC (00 05)	3	0	Allow NULL?
7	SMCPHASE	Phase	String	Generic Edit	3	0	Allow NULL?
8	SMBYR	Buyer Number	Numeric	Generic Edit	8	0	Allow NULL?
9	SMMLTBYR	Multiple Buyers	Character	Generic Edit	1	0	Allow NULL?
10	SMHBPLAN	Plan Number	String	Generic Edit	4	0	Allow NULL?
11	SMHBELEV	Elevation	String	Generic Edit	3	0	Allow NULL?
12	SMSWING	Swing	Character	UDC (44H2 SW)	1	0	Allow NULL?
13	SMSALLST	Sales Activity Code - Last	String	UDC (44H0 RL)	3	0	Allow NULL?
14	SMSALNXT	Sales Activity Code - Next	String	UDC (44H0 RL)	3	0	Allow NULL?
15	SMDCG	Date - Status Changed	Date	Generic Edit	6	0
16	SMCONACT	Sold at Construction Activity	String	UDC (44H0 RL)	3	0	Allow NULL?
17	SMHBSCS	Sales Contract Status	String	UDC (44H5 ST)	3	0	Allow NULL?
18	SMSDJ	Sales Date (Julian)	Date	Generic Edit	6	0
19	SMSRPDJ	Sale Reported Date (Julian)	Date	Generic Edit	6	0
20	SMSRDJ	Sale Ratified Date (Julian)	Date	Generic Edit	6	0
21	SMCAPRVL	Credit Approval Date (Julian)	Date	Generic Edit	6	0
22	SMECDJ	Projected Close Date (Julian)	Date	Generic Edit	6	0
23	SMCDJ	Close Date (Julian)	Date	Generic Edit	6	0
24	SMEDJ	Cancel Date (Julian)	Date	Generic Edit	6	0
25	SMCSRCD	Cancel Sale Reason Code	String	UDC (44H5 CS)	3	0	Allow NULL?
26	SMCSN1	Cancel Sale Note 1	String	Generic Edit	30	0	Allow NULL?
27	SMCSN2	Cancel Sale Note 2	String	Generic Edit	30	0	Allow NULL?
28	SMCSN3	Cancel Sale Note 3	String	Generic Edit	30	0	Allow NULL?
29	SMBHPRICE	Amount - Base House Sales Price	Numeric	Generic Edit	15	2	Allow NULL?
30	SMLOTPREM	Amount - Lot Premium	Numeric	Generic Edit	15	2	Allow NULL?
31	SMINCA1	Amount - Incentive 1	Numeric	Generic Edit	15	2	Allow NULL?
32	SMINCA2	Amount - Incentive 2	Numeric	Generic Edit	15	2	Allow NULL?
33	SMINCA3	Amount - Incentive 3	Numeric	Generic Edit	15	2	Allow NULL?
34	SMUPG	Amount - Upgrade	Numeric	Generic Edit	15	2	Allow NULL?
35	SMNETBP	Amount - Net Base Price	Numeric	Generic Edit	15	2	Allow NULL?
36	SMOPRV1	Amount - Option Revenue 1	Numeric	Generic Edit	15	2	Allow NULL?
37	SMOPRV2	Amount - Option Revenue 2	Numeric	Generic Edit	15	2	Allow NULL?
38	SMOPRV3	Amount - Option Revenue 3	Numeric	Generic Edit	15	2	Allow NULL?
39	SMOPRV4	Amount - Option Revenue 4	Numeric	Generic Edit	15	2	Allow NULL?
40	SMOPRV5	Amount - Option Revenue 5	Numeric	Generic Edit	15	2	Allow NULL?
41	SMOPRV6	Amount - Option Revenue 6	Numeric	Generic Edit	15	2	Allow NULL?
42	SMOPRV7	Amount - Option Revenue 7	Numeric	Generic Edit	15	2	Allow NULL?
43	SMOPRV8	Amount - Option Revenue 8	Numeric	Generic Edit	15	2	Allow NULL?
44	SMOPRV9	Amount - Option Revenue 9	Numeric	Generic Edit	15	2	Allow NULL?
45	SMOPINCA	Amount - Option Incentive	Numeric	Generic Edit	15	2	Allow NULL?
46	SMNETOPT	Amount - Net Option Price	Numeric	Generic Edit	15	2	Allow NULL?
47	SMTOTSAL	Amount - Total Sales Price	Numeric	Generic Edit	15	2	Allow NULL?
48	SMANSM01	Address Number - Sales Master 1	Numeric	Generic Edit	8	0	Allow NULL?
49	SMANSM02	Address Number - Sales Master 2	Numeric	Generic Edit	8	0	Allow NULL?
50	SMANSM03	Address Number - Sales Master 3	Numeric	Generic Edit	8	0	Allow NULL?
51	SMANSM04	Address Number - Sales Master 4	Numeric	Generic Edit	8	0	Allow NULL?
52	SMANSM05	Address Number - Sales Master 5	Numeric	Generic Edit	8	0	Allow NULL?
53	SMANSM06	Address Number - Sales Master 6	Numeric	Generic Edit	8	0	Allow NULL?
54	SMANSM07	Address Number - Sales Master 7	Numeric	Generic Edit	8	0	Allow NULL?
55	SMANSM08	Address Number - Sales Master 8	Numeric	Generic Edit	8	0	Allow NULL?
56	SMANSM09	Address Number - Sales Master 9	Numeric	Generic Edit	8	0	Allow NULL?
57	SMANSM10	Address Number - Sales Master 10	Numeric	Generic Edit	8	0	Allow NULL?
58	SMCMPCT1	Commission Percentage 1	Numeric	Generic Edit	5	3	Allow NULL?
59	SMCMPCT2	Commission Percentage 2	Numeric	Generic Edit	5	3	Allow NULL?
60	SMCMPCT3	Commission Percentage 3	Numeric	Generic Edit	5	3	Allow NULL?
61	SMCMPCT4	Commission Percentage 4	Numeric	Generic Edit	5	3	Allow NULL?
62	SMCMPCT5	Commission Percentage 5	Numeric	Generic Edit	5	3	Allow NULL?
63	SMCMPCT6	Commission Percentage 6	Numeric	Generic Edit	5	3	Allow NULL?
64	SMCMPCT7	Commission Percentage 7	Numeric	Generic Edit	5	3	Allow NULL?
65	SMCMPCT8	Commission Percentage 8	Numeric	Generic Edit	5	3	Allow NULL?
66	SMCMPCT9	Commission Percentage 9	Numeric	Generic Edit	5	3	Allow NULL?
67	SMCMPCT10	Commission Percentage 10	Numeric	Generic Edit	5	3	Allow NULL?
68	SMCM1	Amount - Commission 1	Numeric	Generic Edit	15	2	Allow NULL?
69	SMCM2	Amount - Commission 2	Numeric	Generic Edit	15	2	Allow NULL?
70	SMCM3	Amount - Commission 3	Numeric	Generic Edit	15	2	Allow NULL?
71	SMCM4	Amount - Commission 4	Numeric	Generic Edit	15	0	Allow NULL?
72	SMCM5	Amount - Commission 5	Numeric	Generic Edit	15	2	Allow NULL?
73	SMCM6	Amount - Commission 6	Numeric	Generic Edit	15	2	Allow NULL?
74	SMCM7	Amount - Commission 7	Numeric	Generic Edit	15	2	Allow NULL?
75	SMCM8	Amount - Commission 8	Numeric	Generic Edit	15	2	Allow NULL?
76	SMCM9	Amount - Commission 9	Numeric	Generic Edit	15	2	Allow NULL?
77	SMCM10	Amount - Commission 10	Numeric	Generic Edit	15	2	Allow NULL?
78	SMLDR	Lender Number	Numeric	Generic Edit	8	0	Allow NULL?
79	SMLOANNUM	Loan Number	String	Generic Edit	25	0	Allow NULL?
80	SMLOANTYP	Loan Type	String	UDC (44H5 LT)	10	0	Allow NULL?
81	SMMGA	Mortage_Amount	Numeric	Generic Edit	15	2	Allow NULL?
82	SMINRTE	Interest Rate	Numeric	Generic Edit	15	4	Allow NULL?
83	SMINRLCK	Interest Rate Lock Date	Date	Generic Edit	6	0
84	SMPXD	Points expiration date	Date	Generic Edit	6	0
85	SMDNPT	Down Payment	Numeric	Generic Edit	15	2	Allow NULL?
86	SMEMD	Earnest Money Deposit	Numeric	Generic Edit	15	2	Allow NULL?
87	SMDTKN	Amount - Deposit Taken	Numeric	Generic Edit	15	2	Allow NULL?
88	SMMAD	Mortgage Approval Date (julian)	Date	Generic Edit	6	0
89	SMTAD	Title Appt. Date	Date	Generic Edit	6	0
90	SMLADJ	Loan Application Date	Date	Generic Edit	6	0
91	SMCTG	Contingent Sale Flag	Character	Generic Edit	1	0	Allow NULL?
92	SMCTGS	Contingent Sale Type	String	Generic Edit	8	0	Allow NULL?
93	SMPTX	Property Text	String	Generic Edit	30	0	Allow NULL?
94	SMCTGJ	Contingency Effective Date	Date	Generic Edit	6	0
95	SMLRD	Listing Receipt Date	Date	Generic Edit	6	0
96	SMCCNVD	Contingency Converted Date	Date	Generic Edit	6	0
97	SMCLJ	Conversion Loss Date	Date	Generic Edit	6	0
98	SMCXD	Contingency Expiration Date	Date	Generic Edit	6	0
99	SMCRD	Contingency Release Date	Date	Generic Edit	6	0
100	SMCN1	Contingent Note 1	String	Generic Edit	30	0	Allow NULL?
101	SMCN2	Contingent Note 2	String	Generic Edit	30	0	Allow NULL?
102	SMLAG	Listing Agent	Numeric	Generic Edit	8	0	Allow NULL?
103	SMDCAPPT	Design Center Appointment	Date	Generic Edit	6	0
104	SMDCSTM	Design Center Appointment Time	String	Generic Edit	8	0	Allow NULL?
105	SMDCADT	Actual Design Center Appointment	Date	Generic Edit	6	0
106	SMCLT	Change Lot	String	Generic Edit	4	0	Allow NULL?
107	SMTEDJ	Transfer Buyer Date (Julian)	Date	Generic Edit	6	0
108	SMTIDJ	Transfer Buyer In Date (Julian)	Date	Generic Edit	6	0
109	SMTLN1	Transfer Lot Note 1	String	Generic Edit	30	0	Allow NULL?
110	SMTLN2	Transfer Lot Note 2	String	Generic Edit	30	0	Allow NULL?
111	SMTLN3	Transfer Lot Note 3	String	Generic Edit	30	0	Allow NULL?
112	SMBSWD	Buyer Scheduled Walkthru Date	Date	Generic Edit	6	0
113	SMBSWT	Buyer Scheduled Walkthru Time	String	Generic Edit	8	0	Allow NULL?
114	SMBAWD	Buyer Actual Walkthru Date	Date	Generic Edit	6	0
115	SMUSD1	User Date 1	Date	Generic Edit	6	0
116	SMUSD2	User Date 2	Date	Generic Edit	6	0
117	SMUSD3	User Date 3	Date	Generic Edit	6	0
118	SMUSD4	User Date 4	Date	Generic Edit	6	0
119	SMUSD5	User Date 5	Date	Generic Edit	6	0
120	SMUSD6	User Date 6	Date	Generic Edit	6	0
121	SMUSD7	User Date 7	Date	Generic Edit	6	0
122	SMUSD8	User Date 8	Date	Generic Edit	6	0
123	SMUSD9	User Date 9	Date	Generic Edit	6	0
124	SMUSD10	User Date 10	Date	Generic Edit	6	0
125	SMUSD11	User Date 11	Date	Generic Edit	6	0
126	SMUSD12	User Date 12	Date	Generic Edit	6	0
127	SMUSD13	User Date 13	Date	Generic Edit	6	0
128	SMUSD14	User Date 14	Date	Generic Edit	6	0
129	SMUSD15	User Date 15	Date	Generic Edit	6	0
130	SMUSD16	User Date 16	Date	Generic Edit	6	0
131	SMUSD17	User Date 17	Date	Generic Edit	6	0
132	SMUSD18	User Date 18	Date	Generic Edit	6	0
133	SMUSD19	User Date 19	Date	Generic Edit	6	0
134	SMUSD20	User Date 20	Date	Generic Edit	6	0
135	SMUAMT01	User Defined Amount 01	Numeric	Generic Edit	15	2	Allow NULL?
136	SMUAMT02	User Defined Amount 02	Numeric	Generic Edit	15	2	Allow NULL?
137	SMUAMT03	User Defined Amount 03	Numeric	Generic Edit	15	2	Allow NULL?
138	SMUAMT04	User Defined Amount 04	Numeric	Generic Edit	15	2	Allow NULL?
139	SMUAMT05	User Defined Amount 05	Numeric	Generic Edit	15	2	Allow NULL?
140	SMUAMT06	User Defined Amount 06	Numeric	Generic Edit	15	2	Allow NULL?
141	SMUAMT07	User Defined Amount 07	Numeric	Generic Edit	15	2	Allow NULL?
142	SMUAMT08	User Defined Amount 08	Numeric	Generic Edit	15	2	Allow NULL?
143	SMUAMT09	User Defined Amount 09	Numeric	Generic Edit	15	2	Allow NULL?
144	SMUAMT10	User Defined Amount 10	Numeric	Generic Edit	15	4	Allow NULL?
145	SMSMC01	Sales Category Code 1	String	UDC (44H5 01)	3	0	Allow NULL?
146	SMSMC02	Sales Category Code 2	String	UDC (44H5 02)	3	0	Allow NULL?
147	SMSMC03	Sales Category Code 3	String	UDC (44H5 03)	3	0	Allow NULL?
148	SMSMC04	Sales Category Code 4	String	UDC (44H5 04)	3	0	Allow NULL?
149	SMSMC05	Sales Category Code 5	String	UDC (44H5 05)	3	0	Allow NULL?
150	SMSMC06	Sales Category Code 6	String	UDC (44H5 06)	3	0	Allow NULL?
151	SMSMC07	Sales Category Code 7	String	UDC (44H5 07)	3	0	Allow NULL?
152	SMSMC08	Sales Category Code 8	String	UDC (44H5 08)	3	0	Allow NULL?
153	SMSMC09	Sales Category Code 9	String	UDC (44H5 09)	3	0	Allow NULL?
154	SMSMC10	Sales Category Code 10	String	UDC (44H5 10)	3	0	Allow NULL?
155	SMUSAN01	Address Number User Defined 01	Numeric	Generic Edit	8	0	Allow NULL?
156	SMUSAN02	Address Number User Defined 02	Numeric	Generic Edit	8	0	Allow NULL?
157	SMUSAN03	Address Number User Defined 03	Numeric	Generic Edit	8	0	Allow NULL?
158	SMUSAN04	Address Number User Defined 04	Numeric	Generic Edit	8	0	Allow NULL?
159	SMUSAN05	Address Number User Defined 05	Numeric	Generic Edit	8	0	Allow NULL?
160	SMHBST1	HomeBuilder Status Code 1	Character	Generic Edit	1	0	Allow NULL?
161	SMHBST2	HomeBuilder Status Code 2	Character	Generic Edit	1	0	Allow NULL?
162	SMHBST3	HomeBuilder Status Code 3	Character	Generic Edit	1	0	Allow NULL?
163	SMHBST4	HomeBuilder Status Code 4	Character	Generic Edit	1	0	Allow NULL?
164	SMHBST5	HomeBuilder Status Code 5	Character	Generic Edit	1	0	Allow NULL?
165	SMCRTU	Created by user	String	Generic Edit	10	0	Allow NULL?
166	SMCRTJ	Date - Created	Date	Generic Edit	6	0
167	SMCRTT	Time - Created	Numeric	Generic Edit	6	0	Allow NULL?
168	SMWRKSTNID	Original Work Station ID	String	Generic Edit	10	0	Allow NULL?
169	SMHBOPID	Original Program ID	String	Generic Edit	10	0	Allow NULL?
170	SMUPMB	Updated By - User	String	Generic Edit	10	0	Allow NULL?
171	SMUPMJ	Date - Updated	Date	Generic Edit	6	0
172	SMUPMT	Time - Last Updated	Numeric	Generic Edit	6	0	Allow NULL?
173	SMJOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
174	SMPID	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

174 COLUMNS | 1 INDEXES | 812 | 44H | F44H501 TABLE

TOP 812 | 44H | F44H501 COLUMNS

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

174 COLUMNS | 1 INDEXES | 812 | 44H | F44H501 TABLE

TOP812 | 44H | F44H501 COLUMNS

TOP812 | 44H | F44H501 INDEXES

TOP 812 | 44H | F44H501 COLUMNS

TOP 812 | 44H | F44H501 INDEXES