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	920	F44H201	LM	125	2	Lot Master	Files	44H: Homebuilder Management

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	LMHBMCUS	Community	String	Generic Edit	12	0	Allow NULL?
2	LMHBLOT	Lot Number	String	Generic Edit	4	0	Allow NULL?
3	LMLOTADD	Lot Address	String	Generic Edit	40	0	Allow NULL?
4	LMCTY1	City	String	Generic Edit	25	0	Allow NULL?
5	LMADDS	State	String	UDC (00 S)	3	0	Allow NULL?
6	LMADDZ	Postal Code	String	Generic Edit	12	0	Allow NULL?
7	LMLOTCMT	Lot Comment	String	Generic Edit	40	0	Allow NULL?
8	LMCPHASE	Phase	String	Generic Edit	3	0	Allow NULL?
9	LMMCU	Business Unit	String	Generic Edit	12	0	Allow NULL?
10	LMCONSSEQ	Construction Sequence Number	String	Generic Edit	3	0	Allow NULL?
11	LMHBAREA	HomeBuilder Area ID	String	UDC (00 05)	3	0	Allow NULL?
12	LMHBPLAN	Plan Number	String	Generic Edit	4	0	Allow NULL?
13	LMHBELEV	Elevation	String	Generic Edit	3	0	Allow NULL?
14	LMSWING	Swing	Character	UDC (44H2 SW)	1	0	Allow NULL?
15	LMPSG	Posting Stage	Numeric	Generic Edit	3	0	Allow NULL?
16	LMLSWVER	Lot Start Workfile Version	String	Generic Edit	10	0	Allow NULL?
17	LMLSWPEND	Lot Start Workfile Pending Records	Character	Generic Edit	1	0	Allow NULL?
18	LMLSTATHB	Lot Status Code - HomeBuilder	Character	UDC (44H2 LS)	1	0	Allow NULL?
19	LMOSELCF	Option Selection Changed Flag	Character	Generic Edit	1	0	Allow NULL?
20	LMCONNXT	Construction Status Code Next	String	UDC (44H0 RL)	3	0	Allow NULL?
21	LMCONLST	Construction Status Code Last	String	UDC (44H0 RL)	3	0	Allow NULL?
22	LMSSACS	Sales Status At Construction Start	String	Generic Edit	3	0	Allow NULL?
23	LMDCG	Date - Status Changed	Date	Generic Edit	6	0
24	LMUSC	User ID - Last Changed	String	Generic Edit	10	0	Allow NULL?
25	LMHBSCS	Sales Contract Status	String	UDC (44H5 ST)	3	0	Allow NULL?
26	LMCSSEQ	Sequence - Current Sales	String	Generic Edit	3	0	Allow NULL?
27	LMBYR	Buyer Number	Numeric	Generic Edit	8	0	Allow NULL?
28	LMMCUTJ	Cost Code Template	String	Generic Edit	12	0	Allow NULL?
29	LMSCHTMPT	Schedule Template	String	Generic Edit	12	0	Allow NULL?
30	LMLGLLOT	Legal Lot Number	String	Generic Edit	12	0	Allow NULL?
31	LMHBBLOCK	Homebuilder Block	String	Generic Edit	12	0	Allow NULL?
32	LMHBTRACT	Homebuilder Tract Number	String	Generic Edit	12	0	Allow NULL?
33	LMPARC	Parcel Number	String	Generic Edit	20	0	Allow NULL?
34	LMPARCT	Parcel Tax Number	String	Generic Edit	20	0	Allow NULL?
35	LMBUILD	Equipment Location Building	String	Generic Edit	25	0	Allow NULL?
36	LMUNT3	Unit	String	Generic Edit	8	0	Allow NULL?
37	LMSFTL	Lot Square Footage	Numeric	Generic Edit	8	0	Allow NULL?
38	LMWLT	Width - Lot	Numeric	Generic Edit	8	2	Allow NULL?
39	LMDPLT	Depth - Lot	Numeric	Generic Edit	8	2	Allow NULL?
40	LMACLT	Acres - Lot	Numeric	Generic Edit	8	2	Allow NULL?
41	LMMDLHF	Model Home Flag	Character	Generic Edit	1	0	Allow NULL?
42	LMSPECHF	Spec House Flag	Character	Generic Edit	1	0	Allow NULL?
43	LMBSP	Amount - Base Price	Numeric	Generic Edit	15	2	Allow NULL?
44	LMLTP	Amount - Lot Premium	Numeric	Generic Edit	15	2	Allow NULL?
45	LMLPP	Amount - Lot Premium Previous	Numeric	Generic Edit	15	2	Allow NULL?
46	LMBLDR	Builder Number	Numeric	Generic Edit	8	0	Allow NULL?
47	LMAN8CM01	Address Number - Community 01	Numeric	Generic Edit	8	0	Allow NULL?
48	LMPTDJ	Plot Approval Date	Date	Generic Edit	6	0
49	LMPHD	PQ Hold Date	Date	Generic Edit	6	0
50	LMCTYJ	Date at City	Date	Generic Edit	6	0
51	LMPMN	Permit Number	String	Generic Edit	12	0	Allow NULL?
52	LMPRD	Permit Received Date	Date	Generic Edit	6	0
53	LMCPJ	Compliance Date (Julian)	Date	Generic Edit	6	0
54	LMATFN	Date - Actual Finish (Julian)	Date	Generic Edit	6	0
55	LMRLSDTE	Released for Sale Date (Julian)	Date	Generic Edit	6	0
56	LMCOMJ	Date - Commitment Start	Date	Generic Edit	6	0
57	LMLSRJ	Date - Release Status	Date	Generic Edit	6	0
58	LMLCSJ	Date - Construction Start	Date	Generic Edit	6	0
59	LMLCCJ	Date - Construction Complete	Date	Generic Edit	6	0
60	LMUCSMSF	Update CSMS Flag	Character	Generic Edit	1	0	Allow NULL?
61	LMUSD1	User Date 1	Date	Generic Edit	6	0
62	LMUSD2	User Date 2	Date	Generic Edit	6	0
63	LMUSD3	User Date 3	Date	Generic Edit	6	0
64	LMUSD4	User Date 4	Date	Generic Edit	6	0
65	LMUSD5	User Date 5	Date	Generic Edit	6	0
66	LMUSD6	User Date 6	Date	Generic Edit	6	0
67	LMUSD7	User Date 7	Date	Generic Edit	6	0
68	LMUSD8	User Date 8	Date	Generic Edit	6	0
69	LMUSD9	User Date 9	Date	Generic Edit	6	0
70	LMUSD10	User Date 10	Date	Generic Edit	6	0
71	LMUAMT01	User Defined Amount 01	Numeric	Generic Edit	15	2	Allow NULL?
72	LMUAMT02	User Defined Amount 02	Numeric	Generic Edit	15	2	Allow NULL?
73	LMUAMT03	User Defined Amount 03	Numeric	Generic Edit	15	2	Allow NULL?
74	LMUAMT04	User Defined Amount 04	Numeric	Generic Edit	15	2	Allow NULL?
75	LMUAMT05	User Defined Amount 05	Numeric	Generic Edit	15	2	Allow NULL?
76	LMUAMT06	User Defined Amount 06	Numeric	Generic Edit	15	2	Allow NULL?
77	LMOA1	Other Amount 1	Numeric	Generic Edit	15	0	Allow NULL?
78	LMOA2	Other Amount 2	Numeric	Generic Edit	15	0	Allow NULL?
79	LMUC01	User Reason Code 01	Character	Generic Edit	1	0	Allow NULL?
80	LMUC02	User Reason Code 02	Character	Generic Edit	1	0	Allow NULL?
81	LMUC03	User Reason Code 03	Character	Generic Edit	1	0	Allow NULL?
82	LMUC04	User Reason Code 04	Character	Generic Edit	1	0	Allow NULL?
83	LMUC05	User Reason Code 05	Character	Generic Edit	1	0	Allow NULL?
84	LMUC06	User Reason Code 06	Character	Generic Edit	1	0	Allow NULL?
85	LMLCC01	Lot Category Code 01	String	UDC (44H2 01)	3	0	Allow NULL?
86	LMLCC02	Lot Category Code 02	String	UDC (44H2 02)	3	0	Allow NULL?
87	LMLCC03	Lot Category Code 03	String	UDC (44H2 03)	3	0	Allow NULL?
88	LMLCC04	Lot Category Code 04	String	UDC (44H2 04)	3	0	Allow NULL?
89	LMLCC05	Lot Category Code 05	String	UDC (44H2 05)	3	0	Allow NULL?
90	LMLCC06	Lot Category Code 06	String	UDC (44H2 06)	3	0	Allow NULL?
91	LMLCC07	Lot Category Code 07	String	UDC (44H2 07)	3	0	Allow NULL?
92	LMLCC08	Lot Category Code 08	String	UDC (44H2 08)	3	0	Allow NULL?
93	LMLCC09	Lot Category Code 09	String	UDC (44H2 09)	3	0	Allow NULL?
94	LMLCC10	Lot Category Code 10	String	UDC (44H2 10)	3	0	Allow NULL?
95	LMACCL	Accent Color	String	Generic Edit	15	0	Allow NULL?
96	LMCLRH	Color Hold	Character	Generic Edit	1	0	Allow NULL?
97	LMROF	Roof Tile	String	Generic Edit	15	0	Allow NULL?
98	LMBDC	Body Color	String	Generic Edit	15	0	Allow NULL?
99	LMFSC	Fascia Color	String	Generic Edit	15	0	Allow NULL?
100	LMCLPK	Color Package	String	Generic Edit	10	0	Allow NULL?
101	LMDOC01	Close Document (Order # Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
102	LMDOC02	Final Document (Order # Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
103	LMDOC03	Cost Document Number	Numeric	Generic Edit	8	0	Allow NULL?
104	LMDCT01	Close Document Type	String	UDC (00 DT)	2	0	Allow NULL?
105	LMDCT02	Final Document Type	String	UDC (00 DT)	2	0	Allow NULL?
106	LMDCT03	Cost Document Type	String	UDC (00 DT)	2	0	Allow NULL?
107	LMCDJ	Close Date (Julian)	Date	Generic Edit	6	0
108	LMSUB	Subsidiary	String	Generic Edit	8	0	Allow NULL?
109	LMCO	Company	String	Generic Edit	5	0	Allow NULL?
110	LMRLSN	Release	String	Generic Edit	3	0	Allow NULL?
111	LMHBST1	HomeBuilder Status Code 1	Character	Generic Edit	1	0	Allow NULL?
112	LMHBST2	HomeBuilder Status Code 2	Character	Generic Edit	1	0	Allow NULL?
113	LMHBST3	HomeBuilder Status Code 3	Character	Generic Edit	1	0	Allow NULL?
114	LMHBST4	HomeBuilder Status Code 4	Character	Generic Edit	1	0	Allow NULL?
115	LMHBST5	HomeBuilder Status Code 5	Character	Generic Edit	1	0	Allow NULL?
116	LMCRTU	Created by user	String	Generic Edit	10	0	Allow NULL?
117	LMCRTJ	Date - Created	Date	Generic Edit	6	0
118	LMCRTT	Time - Created	Numeric	Generic Edit	6	0	Allow NULL?
119	LMWRKSTNID	Original Work Station ID	String	Generic Edit	10	0	Allow NULL?
120	LMHBOPID	Original Program ID	String	Generic Edit	10	0	Allow NULL?
121	LMUPMB	Updated By - User	String	Generic Edit	10	0	Allow NULL?
122	LMUPMJ	Date - Updated	Date	Generic Edit	6	0
123	LMUPMT	Time - Last Updated	Numeric	Generic Edit	6	0	Allow NULL?
124	LMJOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
125	LMPID	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

125 COLUMNS | 2 INDEXES | 920 | 44H | F44H201 TABLE

TOP 920 | 44H | F44H201 COLUMNS

TOP 920 | 44H | F44H201 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

125 COLUMNS | 2 INDEXES | 920 | 44H | F44H201 TABLE

TOP920 | 44H | F44H201 COLUMNS

TOP920 | 44H | F44H201 INDEXES

TOP 920 | 44H | F44H201 COLUMNS

TOP 920 | 44H | F44H201 INDEXES