	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

46 COLUMNS | 3 INDEXES | 920 | 44H | F44H790 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
44H: Homebuilder Management
1	920	F44H790	HM	46	3	Construction Milestones	Files	44H: Homebuilder Management

TOP 920 | 44H | F44H790 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	SQL Create Statement
1	HMHBMCUS	Community	String	Generic Edit	12	Allow NULL?
2	HMHBLOT	Lot Number	String	Generic Edit	4	Allow NULL?
3	HMHBMSID	Milestone Id	String	Generic Edit	4	Allow NULL?
4	HMMSSEQ	Milestone Sequence	String	Generic Edit	4	Allow NULL?
5	HMDL01	Description	String	Generic Edit	30	Allow NULL?
6	HMPASQ	Precedent Activity Sequence	Numeric	Generic Edit	3	Allow NULL?
7	HMAN8V	Address Number - Supplier	Numeric	Generic Edit	8	Allow NULL?
8	HMHPF	Hold Payment Flag	Character	Generic Edit	1	Allow NULL?
9	HMMSC	Milestone Status Code	Character	UDC (44H7 MS)	1	Allow NULL?
10	HMNDAP	Days After Prior Milestone	Numeric	Generic Edit	4	Allow NULL?
11	HMPNST	Date - Planned Start (Julian)	Date	Generic Edit	6
12	HMOSF	Original Schedule Finish	Date	Generic Edit	6
13	HMODWD	Original Duration Work Days	Numeric	Generic Edit	9	Allow NULL?
14	HMODCD	Original Duration Calendar Days	Numeric	Generic Edit	9	Allow NULL?
15	HMCSHST	Revisded Start Date	Date	Generic Edit	6
16	HMCSHF	Current Schedule Finish	Date	Generic Edit	6
17	HMRDWD	Revised Duration Work Days	Numeric	Generic Edit	9	Allow NULL?
18	HMRDCD	Revised Duration Calendar Days	Numeric	Generic Edit	9	Allow NULL?
19	HMASJ	Actual Start Date	Date	Generic Edit	6
20	HMATFN	Date - Actual Finish (Julian)	Date	Generic Edit	6
21	HMADWD	Actual Duration Work Days	Numeric	Generic Edit	9	Allow NULL?
22	HMADCD	Actual Duration Calendar Days	Numeric	Generic Edit	9	Allow NULL?
23	HMDRC	Delay Reason Code	String	UDC (44H7 DR)	10	Allow NULL?
24	HMDDL01	Delay Reason Description	String	Generic Edit	30	Allow NULL?
25	HMMSNOTE	Milestone Note	String	Generic Edit	80	Allow NULL?
26	HMSCHTMPT	Schedule Template	String	Generic Edit	12	Allow NULL?
27	HMAPRV	Address Number - Approved by	Numeric	Generic Edit	8	Allow NULL?
28	HMHBST1	HomeBuilder Status Code 1	Character	Generic Edit	1	Allow NULL?
29	HMHBST2	HomeBuilder Status Code 2	Character	Generic Edit	1	Allow NULL?
30	HMHBST3	HomeBuilder Status Code 3	Character	Generic Edit	1	Allow NULL?
31	HMHBST4	HomeBuilder Status Code 4	Character	Generic Edit	1	Allow NULL?
32	HMHBST5	HomeBuilder Status Code 5	Character	Generic Edit	1	Allow NULL?
33	HMGS3A	Generic String x 30	String	Generic Edit	30	Allow NULL?
34	HMGS3B	Generic String x 30	String	Generic Edit	30	Allow NULL?
35	HMGS3C	Generic String x 30	String	Generic Edit	30	Allow NULL?
36	HMGS3D	Generic String x 30	String	Generic Edit	30	Allow NULL?
37	HMGS3E	Generic String x 30	String	Generic Edit	30	Allow NULL?
38	HMCRTU	Created by user	String	Generic Edit	10	Allow NULL?
39	HMCRTJ	Date - Created	Date	Generic Edit	6
40	HMWRKSTNID	Original Work Station ID	String	Generic Edit	10	Allow NULL?
41	HMHBOPID	Original Program ID	String	Generic Edit	10	Allow NULL?
42	HMUPMB	Updated By - User	String	Generic Edit	10	Allow NULL?
43	HMUPMJ	Date - Updated	Date	Generic Edit	6
44	HMUPMT	Time - Last Updated	Numeric	Generic Edit	6	Allow NULL?
45	HMJOBN	Work Station ID	String	Generic Edit	10	Allow NULL?
46	HMPID	Program ID	String	Generic Edit	10	Allow NULL?

TOP 920 | 44H | F44H790 INDEXES

Number

Description

CommunityLotMilestoneSequence (Primary/Unique)

Element	Alias	Description	Sequence
1	HBMCUS	Community	Ascending
2	HBLOT	Lot Number	Ascending
3	HBMSID	Milestone Id	Ascending

HBMCUS HBLOT MSSEQ HBMSID

Element	Alias	Description	Sequence
1	HBMCUS	Community	Ascending
2	HBLOT	Lot Number	Ascending
3	MSSEQ	Milestone Sequence	Ascending
4	HBMSID	Milestone Id	Ascending

HBMCUS HBLOT DL01 HBMSID

Element	Alias	Description	Sequence
1	HBMCUS	Community	Ascending
2	HBLOT	Lot Number	Ascending
3	DL01	Description	Ascending
4	HBMSID	Milestone Id	Ascending

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

46 COLUMNS | 3 INDEXES | 920 | 44H | F44H790 TABLE

TOP 920 | 44H | F44H790 COLUMNS

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

46 COLUMNS | 3 INDEXES | 920 | 44H | F44H790 TABLE

TOP920 | 44H | F44H790 COLUMNS

TOP920 | 44H | F44H790 INDEXES

TOP 920 | 44H | F44H790 COLUMNS

TOP 920 | 44H | F44H790 INDEXES