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

126 COLUMNS | 1 INDEXES | 920 | 44H | F44H201H TABLE

TOP 920 | 44H | F44H201H COLUMNS

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

126 COLUMNS | 1 INDEXES | 920 | 44H | F44H201H TABLE

TOP920 | 44H | F44H201H COLUMNS

TOP920 | 44H | F44H201H INDEXES

TOP 920 | 44H | F44H201H COLUMNS

TOP 920 | 44H | F44H201H INDEXES