	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	F4102	IB	Item Branch File
7	F9671	SD	Software Update Detail Table
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	F4311	PD	Purchase Order Detail File
10	F4111	IL	Item Ledger File

	Table	Prefix	Description
1	F0911	GL	Account Ledger
2	F4311	PD	Purchase Order Detail File
3	F0101	AB	Address Book Master
4	F0411	RP	Accounts Payable Ledger
5	F0006	MC	Business Unit Master
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

89 COLUMNS | 7 INDEXES | 920 | 44H | F44H611 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
44H: Homebuilder Management
1	920	F44H611	BD	89	7	Bid Details	Files	44H: Homebuilder Management

SQL: selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns. For Create statements, use Allow Null checkboxes and default values inputs to tailor query as required.

SELECT BDKCOO, BDDOCO, BDDCTO, BDSFXO, BDLNID, BDHBAREA, BDMCU, BDANI, BDAID, BDCPHASE, BDOBJ, BDSUB, BDOPTION, BDHBPLAN, BDHBELEV, BDR001, BDBIDTYPE, BDVNDAOVR, BDUNIDOC, BDBUDONLY, BDVNDTBD, BDAVEL, BDAN8, BDSHAN, BDDGL, BDBDEFDT, BDBDCLDT, BDPDDJ, BDOPDJ, BDTRDJ, BDPN, BDVR01, BDVR02, BDITM, BDLITM, BDDSC1, BDDSC2, BDLNTY, BDNXTR, BDLTTR, BDPDP1, BDPDP2, BDPDP3, BDPDP4, BDPDP5, BDUOM, BDPRRC, BDUORG, BDAEXP, BDPERFCTR, BDFTN1, BDPTC, BDTX, BDEXR1, BDTXA1, BDANBY, BDGLC, BDCTRY, BDFY, BDRCD, BDFUF1, BDFUF2, BDLT, BDPCRT, BDRTNR, BDPURG, BDCRRM, BDCRCD, BDCRR, BDFRRC, BDFEA, BDFUC, BDFEC, BDHBST1, BDHBST2, BDHBST3, BDHBST4, BDHBST5, BDURRF, BDCRTU, BDCRTJ, BDCRTT, BDWRKSTNID, BDHBOPID, BDUPMB, BDUPMJ, BDUPMT, BDJOBN, BDPID FROM F44H611

TOP 920 | 44H | F44H611 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	BDKCOO	Order Company (Order Number)	String	Generic Edit	5	0	Allow NULL?
2	BDDOCO	Document (Order No Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
3	BDDCTO	Order Type	String	UDC (00 DT)	2	0	Allow NULL?
4	BDSFXO	Order Suffix	String	Generic Edit	3	0	Allow NULL?
5	BDLNID	Line Number	Numeric	Generic Edit	6	3	Allow NULL?
6	BDHBAREA	HomeBuilder Area ID	String	UDC (00 05)	3	0	Allow NULL?
7	BDMCU	Business Unit	String	Generic Edit	12	0	Allow NULL?
8	BDANI	Account Number - Input (Mode Unknown)	String	Generic Edit	29	0	Allow NULL?
9	BDAID	Account ID	String	Generic Edit	8	0	Allow NULL?
10	BDCPHASE	Phase	String	Generic Edit	3	0	Allow NULL?
11	BDOBJ	Object Account	String	Generic Edit	6	0	Allow NULL?
12	BDSUB	Subsidiary	String	Generic Edit	8	0	Allow NULL?
13	BDOPTION	Option Number	String	Generic Edit	8	0	Allow NULL?
14	BDHBPLAN	Plan Number	String	Generic Edit	4	0	Allow NULL?
15	BDHBELEV	Elevation	String	Generic Edit	3	0	Allow NULL?
16	BDR001	Category Code - G/L1	String	UDC (09 01)	3	0	Allow NULL?
17	BDBIDTYPE	Bid Type	String	UDC (44H6 BT)	2	0	Allow NULL?
18	BDVNDAOVR	Vendor Assignment Override	Character	Generic Edit	1	0	Allow NULL?
19	BDUNIDOC	Unique Document	Character	Generic Edit	1	0	Allow NULL?
20	BDBUDONLY	Budget Only	Character	Generic Edit	1	0	Allow NULL?
21	BDVNDTBD	Supplier TBD	Character	Generic Edit	1	0	Allow NULL?
22	BDAVEL	Autovoucher Eligible Flag	Character	Generic Edit	1	0	Allow NULL?
23	BDAN8	Address Number	Numeric	Generic Edit	8	0	Allow NULL?
24	BDSHAN	Address Number - Ship To	Numeric	Generic Edit	8	0	Allow NULL?
25	BDDGL	Date - For G/L (and Voucher)	Date	Generic Edit	6	0
26	BDBDEFDT	Bid Effective Date	Date	Generic Edit	6	0
27	BDBDCLDT	Bid Cancel Date	Date	Generic Edit	6	0
28	BDPDDJ	Date - Scheduled Pick	Date	Generic Edit	6	0
29	BDOPDJ	Date - Original Promised Delivery	Date	Generic Edit	6	0
30	BDTRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
31	BDPN	Period Number - General Ledger	Numeric	Generic Edit	2	0	Allow NULL?
32	BDVR01	Reference	String	Generic Edit	25	0	Allow NULL?
33	BDVR02	Reference 2	String	Generic Edit	25	0	Allow NULL?
34	BDITM	Item Number - Short	Numeric	Generic Edit	8	0	Allow NULL?
35	BDLITM	2nd Item Number	String	Generic Edit	25	0	Allow NULL?
36	BDDSC1	Description	String	Generic Edit	30	0	Allow NULL?
37	BDDSC2	Description - Line 2	String	Generic Edit	30	0	Allow NULL?
38	BDLNTY	Line Type	String	Generic Edit	2	0	Allow NULL?
39	BDNXTR	Status Code - Next	String	UDC (40 AT)	3	0	Allow NULL?
40	BDLTTR	Status Code - Last	String	UDC (40 AT)	3	0	Allow NULL?
41	BDPDP1	Reporting Code 1 - Purchasing	String	UDC (41 P1)	3	0	Allow NULL?
42	BDPDP2	Reporting Code 2 - Purchasing	String	UDC (41 P2)	3	0	Allow NULL?
43	BDPDP3	Reporting Code 3 - Purchasing	String	UDC (41 P3)	3	0	Allow NULL?
44	BDPDP4	Reporting Code 4 - Purchasing	String	UDC (41 P4)	3	0	Allow NULL?
45	BDPDP5	Reporting Code 5 - Purchasing	String	UDC (41 P5)	3	0	Allow NULL?
46	BDUOM	Unit of Measure as Input	String	UDC (00 UM)	2	0	Allow NULL?
47	BDPRRC	Amount - Unit Cost	Numeric	Generic Edit	15	4	Allow NULL?
48	BDUORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	0	Allow NULL?
49	BDAEXP	Amount - Extended Price	Numeric	Generic Edit	15	2	Allow NULL?
50	BDPERFCTR	Factor Percentage	Numeric	Generic Edit	15	6	Allow NULL?
51	BDFTN1	Amount - Tax Commitment	Numeric	Generic Edit	15	2	Allow NULL?
52	BDPTC	Payment Terms Code	String	Generic Edit	3	0	Allow NULL?
53	BDTX	Purchasing Taxable (Y/N)	Character	UDC (H00 TV)	1	0	Allow NULL?
54	BDEXR1	Tax Expl Code 1	String	UDC (00 EX)	2	0	Allow NULL?
55	BDTXA1	Tax Rate/Area	String	Generic Edit	10	0	Allow NULL?
56	BDANBY	Buyer Number	Numeric	Generic Edit	8	0	Allow NULL?
57	BDGLC	G/L Offset	String	Generic Edit	4	0	Allow NULL?
58	BDCTRY	Century	Numeric	Generic Edit	2	0	Allow NULL?
59	BDFY	Fiscal Year	Numeric	Generic Edit	2	0	Allow NULL?
60	BDRCD	Reason Code	String	UDC (42 RC)	3	0	Allow NULL?
61	BDFUF1	AIA Document Flag	Character	UDC (H40 FU)	1	0	Allow NULL?
62	BDFUF2	Post Quantities	Character	Generic Edit	1	0	Allow NULL?
63	BDLT	Ledger Types	String	UDC (09 LT)	2	0	Allow NULL?
64	BDPCRT	Percent - Retainage	Numeric	Generic Edit	7	3	Allow NULL?
65	BDRTNR	Retainage Rule	String	Generic Edit	3	0	Allow NULL?
66	BDPURG	Purge Code	Character	Generic Edit	1	0	Allow NULL?
67	BDCRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC (H00 CY)	1	0	Allow NULL?
68	BDCRCD	Currency Code - From	String	Generic Edit	3	0	Allow NULL?
69	BDCRR	Currency Conversion Rate - Spot Rate	Numeric	Generic Edit	15	0	Allow NULL?
70	BDFRRC	Amount - Foreign Unit Price	Numeric	Generic Edit	15	4	Allow NULL?
71	BDFEA	Amount - Foreign Extended Price	Numeric	Generic Edit	15	2	Allow NULL?
72	BDFUC	Amount - Foreign Unit Cost	Numeric	Generic Edit	15	4	Allow NULL?
73	BDFEC	Amount - Foreign Extended Cost	Numeric	Generic Edit	15	2	Allow NULL?
74	BDHBST1	HomeBuilder Status Code 1	Character	Generic Edit	1	0	Allow NULL?
75	BDHBST2	HomeBuilder Status Code 2	Character	Generic Edit	1	0	Allow NULL?
76	BDHBST3	HomeBuilder Status Code 3	Character	Generic Edit	1	0	Allow NULL?
77	BDHBST4	HomeBuilder Status Code 4	Character	Generic Edit	1	0	Allow NULL?
78	BDHBST5	HomeBuilder Status Code 5	Character	Generic Edit	1	0	Allow NULL?
79	BDURRF	User Reserved Reference	String	Generic Edit	15	0	Allow NULL?
80	BDCRTU	Created by user	String	Generic Edit	10	0	Allow NULL?
81	BDCRTJ	Date - Created	Date	Generic Edit	6	0
82	BDCRTT	Time - Created	Numeric	Generic Edit	6	0	Allow NULL?
83	BDWRKSTNID	Original Work Station ID	String	Generic Edit	10	0	Allow NULL?
84	BDHBOPID	Original Program ID	String	Generic Edit	10	0	Allow NULL?
85	BDUPMB	Updated By - User	String	Generic Edit	10	0	Allow NULL?
86	BDUPMJ	Date - Updated	Date	Generic Edit	6	0
87	BDUPMT	Time - Last Updated	Numeric	Generic Edit	6	0	Allow NULL?
88	BDJOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
89	BDPID	Program ID	String	Generic Edit	10	0	Allow NULL?

TOP 920 | 44H | F44H611 INDEXES

Number

Description

DOCO DCTO KCOO SFXO LNID (Primary/Unique)

Element	Alias	Description	Sequence
1	DOCO	Document (Order No Invoice etc.)	Ascending
2	DCTO	Order Type	Ascending
3	KCOO	Order Company (Order Number)	Ascending
4	SFXO	Order Suffix	Ascending
5	LNID	Line Number	Ascending

DOCO DCTO KCOO SFXO(d) LNID(d)

Element	Alias	Description	Sequence
1	DOCO	Document (Order No Invoice etc.)	Ascending
2	DCTO	Order Type	Ascending
3	KCOO	Order Company (Order Number)	Ascending
4	SFXO	Order Suffix	Descending
5	LNID	Line Number	Descending

HBAREA VNDAOVR OPTION SUB OBJ+

Element	Alias	Description	Sequence
1	HBAREA	HomeBuilder Area ID	Ascending
2	VNDAOVR	Vendor Assignment Override	Ascending
3	OPTION	Option Number	Ascending
4	SUB	Subsidiary	Ascending
5	OBJ	Object Account	Ascending
6	MCU	Business Unit	Descending
7	CPHASE	Phase	Descending
8	HBPLAN	Plan Number	Descending
9	HBELEV	Elevation	Descending

SUB OBJ OPTION CPHASE HBPLAN+

Element	Alias	Description	Sequence
1	SUB	Subsidiary	Ascending
2	OBJ	Object Account	Ascending
3	OPTION	Option Number	Ascending
4	CPHASE	Phase	Ascending
5	HBPLAN	Plan Number	Ascending
6	HBELEV	Elevation	Ascending
7	AN8	Address Number	Ascending
8	MCU	Business Unit	Ascending
9	BDEFDT	Bid Effective Date	Ascending
10	BDCLDT	Bid Cancel Date	Ascending

HBAREA SUB OBJ OPTION

Element	Alias	Description	Sequence
1	HBAREA	HomeBuilder Area ID	Ascending
2	SUB	Subsidiary	Ascending
3	OBJ	Object Account	Ascending
4	OPTION	Option Number	Ascending

DOCO DCTO KCOO LNID(d)

Element	Alias	Description	Sequence
1	DOCO	Document (Order No Invoice etc.)	Ascending
2	DCTO	Order Type	Ascending
3	KCOO	Order Company (Order Number)	Ascending
4	LNID	Line Number	Descending

HBAREA MCU CPHASE OBJ SUB OPT+

Element	Alias	Description	Sequence
1	HBAREA	HomeBuilder Area ID	Ascending
2	MCU	Business Unit	Ascending
3	CPHASE	Phase	Ascending
4	OBJ	Object Account	Ascending
5	SUB	Subsidiary	Ascending
6	OPTION	Option Number	Ascending
7	HBPLAN	Plan Number	Ascending
8	HBELEV	Elevation	Ascending
9	VNDAOVR	Vendor Assignment Override	Ascending
10	BUDONLY	Budget Only	Ascending
11	AN8	Address Number	Ascending
12	BDEFDT	Bid Effective Date	Ascending
13	BDCLDT	Bid Cancel Date	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

89 COLUMNS | 7 INDEXES | 920 | 44H | F44H611 TABLE

TOP 920 | 44H | F44H611 COLUMNS

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

89 COLUMNS | 7 INDEXES | 920 | 44H | F44H611 TABLE

TOP920 | 44H | F44H611 COLUMNS

TOP920 | 44H | F44H611 INDEXES

TOP 920 | 44H | F44H611 COLUMNS

TOP 920 | 44H | F44H611 INDEXES