	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

30 COLUMNS | 3 INDEXES | 812 | 44H | F44H604 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
44H: Homebuilder Management
1	812	F44H604	VA	30	3	Vendor Assignment	Files	44H: Homebuilder Management

TOP 812 | 44H | F44H604 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	SQL Create Statement
1	VAHBAREA	HomeBuilder Area ID	String	UDC (00 05)	3	Allow NULL?
2	VAR001	Category Code - G/L1	String	UDC (09 01)	3	Allow NULL?
3	VAHBMCUS	Community	String	Generic Edit	12	Allow NULL?
4	VACPHASE	Phase	String	Generic Edit	3	Allow NULL?
5	VAHBLOT	Lot Number	String	Generic Edit	4	Allow NULL?
6	VAOPTION	Option Number	String	Generic Edit	8	Allow NULL?
7	VAEFFF	Effective - From Date	Date	Generic Edit	6
8	VAAN8	Address Number	Numeric	UDC	8	Allow NULL?
9	VAASNSTS	Assignment Status	Character	Generic Edit	1	Allow NULL?
10	VAEXPR	Date - Expired	Date	Generic Edit	6
11	VADOCO	Document (Order No Invoice etc.)	Numeric	Generic Edit	8	Allow NULL?
12	VADCTO	Order Type	String	UDC (00 DT)	2	Allow NULL?
13	VATRDJ	Date - Order/Transaction	Date	Generic Edit	6
14	VAAVEL	Autovoucher Eligible Flag	Character	Generic Edit	1	Allow NULL?
15	VAHBST1	HomeBuilder Status Code 1	Character	Generic Edit	1	Allow NULL?
16	VAHBST2	HomeBuilder Status Code 2	Character	Generic Edit	1	Allow NULL?
17	VAHBST3	HomeBuilder Status Code 3	Character	Generic Edit	1	Allow NULL?
18	VAHBST4	HomeBuilder Status Code 4	Character	Generic Edit	1	Allow NULL?
19	VAHBST5	HomeBuilder Status Code 5	Character	Generic Edit	1	Allow NULL?
20	VACRTU	Created by user	String	Generic Edit	10	Allow NULL?
21	VACRTJ	Date - Created	Date	Generic Edit	6
22	VACRTT	Time - Created	Numeric	Generic Edit	6	Allow NULL?
23	VAWRKSTNID	Original Work Station ID	String	Generic Edit	10	Allow NULL?
24	VAHBOPID	Original Program ID	String	Generic Edit	10	Allow NULL?
25	VAUPMB	Updated By - User	String	Generic Edit	10	Allow NULL?
26	VAUPMJ	Date - Updated	Date	Generic Edit	6
27	VAUPMT	Time - Last Updated	Numeric	Generic Edit	6	Allow NULL?
28	VAJOBN	Work Station ID	String	Generic Edit	10	Allow NULL?
29	VAPID	Program ID	String	Generic Edit	10	Allow NULL?
30	VAASNRPR	Assignment Status Recalculate Price	Character	Generic Edit	1	Allow NULL?

TOP 812 | 44H | F44H604 INDEXES

Number

Description

HBAREA R001 CPHASE HBMCUS + (Primary/Unique)

Element	Alias	Description	Sequence
1	HBAREA	HomeBuilder Area ID	Ascending
2	R001	Category Code - G/L1	Ascending
3	CPHASE	Phase	Ascending
4	HBMCUS	Community	Ascending
5	HBLOT	Lot Number	Ascending
6	OPTION	Option Number	Ascending
7	EFFF	Effective - From Date	Ascending
8	AN8	Address Number	Ascending

HBAREA R001 OPTION HBMCUS(d) +

Element	Alias	Description	Sequence
1	HBAREA	HomeBuilder Area ID	Ascending
2	R001	Category Code - G/L1	Ascending
3	HBMCUS	Community	Descending
4	CPHASE	Phase	Descending
5	HBLOT	Lot Number	Descending
6	OPTION	Option Number	Descending

HBAREA R001 CPHASE +(dates)

Element	Alias	Description	Sequence
1	HBAREA	HomeBuilder Area ID	Ascending
2	R001	Category Code - G/L1	Ascending
3	HBMCUS	Community	Ascending
4	CPHASE	Phase	Ascending
5	HBLOT	Lot Number	Ascending
6	OPTION	Option Number	Ascending
7	EFFF	Effective - From Date	Ascending
8	EXPR	Date - Expired	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

30 COLUMNS | 3 INDEXES | 812 | 44H | F44H604 TABLE

TOP 812 | 44H | F44H604 COLUMNS

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

30 COLUMNS | 3 INDEXES | 812 | 44H | F44H604 TABLE

TOP812 | 44H | F44H604 COLUMNS

TOP812 | 44H | F44H604 INDEXES

TOP 812 | 44H | F44H604 COLUMNS

TOP 812 | 44H | F44H604 INDEXES