	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

43 COLUMNS | 2 INDEXES | 920 | 44H | F44H0929 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
44H: Homebuilder Management
1	920	F44H0929	ED	43	2	Extended Homebuilder Data	Files	44H: Homebuilder Management

TOP 920 | 44H | F44H0929 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	EDHBAREA	HomeBuilder Area ID	String	UDC (00 05)	3	0	Allow NULL?
2	EDHBMCUS	Community	String	Generic Edit	12	0	Allow NULL?
3	EDCPHASE	Phase	String	Generic Edit	3	0	Allow NULL?
4	EDHBLOT	Lot Number	String	Generic Edit	4	0	Allow NULL?
5	EDCSSEQ	Sequence - Current Sales	String	Generic Edit	3	0	Allow NULL?
6	EDHBPLAN	Plan Number	String	Generic Edit	4	0	Allow NULL?
7	EDHBELEV	Elevation	String	Generic Edit	3	0	Allow NULL?
8	EDOPTION	Option Number	String	Generic Edit	8	0	Allow NULL?
9	EDSDTYP	Extended Data Type	String	Generic Edit	3	0	Allow NULL?
10	EDSDKY	Extended Data Type Key	String	Generic Edit	10	0	Allow NULL?
11	EDSDLIN	Extended Data Line Number	Numeric	Generic Edit	5	0	Allow NULL?
12	EDSDDSC	Extended Data Description	String	Generic Edit	50	0	Allow NULL?
13	EDSDDT1	Extended Data Date 1	Date	Generic Edit	6	0
14	EDSDDT2	Extended Data Date 2	Date	Generic Edit	6	0
15	EDSDDT3	Extended Data Date 3	Date	Generic Edit	6	0
16	EDSDAMT1	Extended Data Amount 1	Numeric	Generic Edit	15	2	Allow NULL?
17	EDSDAMT2	Extended Data Amount 2	Numeric	Generic Edit	15	2	Allow NULL?
18	EDSDAMT3	Extended Data Amount 3	Numeric	Generic Edit	15	2	Allow NULL?
19	EDSDNM1	Extended Data Number 1	Numeric	Generic Edit	9	0	Allow NULL?
20	EDSDNM2	Extended Data Number 2	Numeric	Generic Edit	9	0	Allow NULL?
21	EDSDNM3	Extended Data Number 3	Numeric	Generic Edit	9	0	Allow NULL?
22	EDSDMO1	Extended Data Memo 1	String	Generic Edit	20	0	Allow NULL?
23	EDSDMO2	Extended Data Memo 2	String	Generic Edit	20	0	Allow NULL?
24	EDSDMO3	Extended Data Memo 3	String	Generic Edit	20	0	Allow NULL?
25	EDSDAB1	Extended Data Address Book 1	Numeric	Generic Edit	8	0	Allow NULL?
26	EDSDAB2	Extended Data Address Book 2	Numeric	Generic Edit	8	0	Allow NULL?
27	EDSDAB3	Extended Data Address Book 3	Numeric	Generic Edit	8	0	Allow NULL?
28	EDSDTXT	Extended Data Text	String	Generic Edit	80	0	Allow NULL?
29	EDPRODM	Product Model	String	UDC (17 PM)	8	0	Allow NULL?
30	EDPRODF	Product Family	String	UDC (17 PA)	8	0	Allow NULL?
31	EDEDTLVL	Template Level - Extended Data	Character	Generic Edit	1	0	Allow NULL?
32	EDEDUPDF	Update Flag - Extended Data	Character	Generic Edit	1	0	Allow NULL?
33	EDEDSELFLG	Extended Data Selection Flag	Character	Generic Edit	1	0	Allow NULL?
34	EDCRTU	Created by user	String	Generic Edit	10	0	Allow NULL?
35	EDCRTJ	Date - Created	Date	Generic Edit	6	0
36	EDCRTT	Time - Created	Numeric	Generic Edit	6	0	Allow NULL?
37	EDWRKSTNID	Original Work Station ID	String	Generic Edit	10	0	Allow NULL?
38	EDHBOPID	Original Program ID	String	Generic Edit	10	0	Allow NULL?
39	EDUPMB	Updated By - User	String	Generic Edit	10	0	Allow NULL?
40	EDUPMJ	Date - Updated	Date	Generic Edit	6	0
41	EDUPMT	Time - Last Updated	Numeric	Generic Edit	6	0	Allow NULL?
42	EDJOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
43	EDPID	Program ID	String	Generic Edit	10	0	Allow NULL?

TOP 920 | 44H | F44H0929 INDEXES

Number

Description

HBAREA HBMCUS CPHASE HBLOT + (Primary/Unique)

Element	Alias	Description	Sequence
1	HBAREA	HomeBuilder Area ID	Ascending
2	HBMCUS	Community	Ascending
3	CPHASE	Phase	Ascending
4	HBLOT	Lot Number	Ascending
5	CSSEQ	Sequence - Current Sales	Ascending
6	HBPLAN	Plan Number	Ascending
7	HBELEV	Elevation	Ascending
8	OPTION	Option Number	Ascending
9	SDTYP	Extended Data Type	Ascending
10	SDKY	Extended Data Type Key	Ascending
11	SDLIN	Extended Data Line Number	Ascending

HBAREA HBMCUS SDTYP SDKY +

Element	Alias	Description	Sequence
1	HBAREA	HomeBuilder Area ID	Ascending
2	HBMCUS	Community	Ascending
3	SDTYP	Extended Data Type	Ascending
4	SDKY	Extended Data Type Key	Ascending
5	SDLIN	Extended Data Line Number	Ascending
6	EDUPDF	Update Flag - Extended Data	Descending

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

43 COLUMNS | 2 INDEXES | 920 | 44H | F44H0929 TABLE

TOP 920 | 44H | F44H0929 COLUMNS

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

43 COLUMNS | 2 INDEXES | 920 | 44H | F44H0929 TABLE

TOP920 | 44H | F44H0929 COLUMNS

TOP920 | 44H | F44H0929 INDEXES

TOP 920 | 44H | F44H0929 COLUMNS

TOP 920 | 44H | F44H0929 INDEXES