	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

93 COLUMNS | 3 INDEXES | 920 | 44H | F44H611W TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
44H: Homebuilder Management
1	920	F44H611W	BW	93	3	Bid Details Work File	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 BWJOBS, BWKCOO, BWDOCO, BWDCTO, BWSFXO, BWLNID, BWOKCO, BWODOC, BWOCTO, BWHBAREA, BWMCU, BWANI, BWAID, BWCPHASE, BWOBJ, BWSUB, BWOPTION, BWHBPLAN, BWHBELEV, BWR001, BWBIDTYPE, BWVNDAOVR, BWUNIDOC, BWBUDONLY, BWVNDTBD, BWAVEL, BWAN8, BWSHAN, BWDGL, BWBDEFDT, BWBDCLDT, BWPDDJ, BWOPDJ, BWTRDJ, BWPN, BWVR01, BWVR02, BWITM, BWLITM, BWDSC1, BWDSC2, BWLNTY, BWNXTR, BWLTTR, BWPDP1, BWPDP2, BWPDP3, BWPDP4, BWPDP5, BWUOM, BWPRRC, BWUORG, BWAEXP, BWPERFCTR, BWFTN1, BWPTC, BWTX, BWEXR1, BWTXA1, BWANBY, BWGLC, BWCTRY, BWFY, BWRCD, BWFUF1, BWFUF2, BWLT, BWPCRT, BWRTNR, BWPURG, BWCRRM, BWCRCD, BWCRR, BWFRRC, BWFEA, BWFUC, BWFEC, BWHBST1, BWHBST2, BWHBST3, BWHBST4, BWHBST5, BWURRF, BWCRTU, BWCRTJ, BWCRTT, BWWRKSTNID, BWHBOPID, BWUPMB, BWUPMJ, BWUPMT, BWJOBN, BWPID FROM F44H611W

TOP 920 | 44H | F44H611W COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	BWJOBS	Job Number	Numeric	Generic Edit	8	0	Allow NULL?
2	BWKCOO	Order Company (Order Number)	String	Generic Edit	5	0	Allow NULL?
3	BWDOCO	Document (Order No Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
4	BWDCTO	Order Type	String	UDC (00 DT)	2	0	Allow NULL?
5	BWSFXO	Order Suffix	String	Generic Edit	3	0	Allow NULL?
6	BWLNID	Line Number	Numeric	Generic Edit	6	3	Allow NULL?
7	BWOKCO	Document Company (Original Order)	String	Generic Edit	5	0	Allow NULL?
8	BWODOC	Document - Original	Numeric	Generic Edit	8	0	Allow NULL?
9	BWOCTO	Original Order Type	String	UDC (00 DT)	2	0	Allow NULL?
10	BWHBAREA	HomeBuilder Area ID	String	UDC (00 05)	3	0	Allow NULL?
11	BWMCU	Business Unit	String	Generic Edit	12	0	Allow NULL?
12	BWANI	Account Number - Input (Mode Unknown)	String	Generic Edit	29	0	Allow NULL?
13	BWAID	Account ID	String	Generic Edit	8	0	Allow NULL?
14	BWCPHASE	Phase	String	Generic Edit	3	0	Allow NULL?
15	BWOBJ	Object Account	String	Generic Edit	6	0	Allow NULL?
16	BWSUB	Subsidiary	String	Generic Edit	8	0	Allow NULL?
17	BWOPTION	Option Number	String	Generic Edit	8	0	Allow NULL?
18	BWHBPLAN	Plan Number	String	Generic Edit	4	0	Allow NULL?
19	BWHBELEV	Elevation	String	Generic Edit	3	0	Allow NULL?
20	BWR001	Category Code - G/L1	String	UDC (09 01)	3	0	Allow NULL?
21	BWBIDTYPE	Bid Type	String	UDC (44H6 BT)	2	0	Allow NULL?
22	BWVNDAOVR	Vendor Assignment Override	Character	Generic Edit	1	0	Allow NULL?
23	BWUNIDOC	Unique Document	Character	Generic Edit	1	0	Allow NULL?
24	BWBUDONLY	Budget Only	Character	Generic Edit	1	0	Allow NULL?
25	BWVNDTBD	Supplier TBD	Character	Generic Edit	1	0	Allow NULL?
26	BWAVEL	Autovoucher Eligible Flag	Character	Generic Edit	1	0	Allow NULL?
27	BWAN8	Address Number	Numeric	Generic Edit	8	0	Allow NULL?
28	BWSHAN	Address Number - Ship To	Numeric	Generic Edit	8	0	Allow NULL?
29	BWDGL	Date - For G/L (and Voucher)	Date	Generic Edit	6	0
30	BWBDEFDT	Bid Effective Date	Date	Generic Edit	6	0
31	BWBDCLDT	Bid Cancel Date	Date	Generic Edit	6	0
32	BWPDDJ	Date - Scheduled Pick	Date	Generic Edit	6	0
33	BWOPDJ	Date - Original Promised Delivery	Date	Generic Edit	6	0
34	BWTRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
35	BWPN	Period Number - General Ledger	Numeric	Generic Edit	2	0	Allow NULL?
36	BWVR01	Reference	String	Generic Edit	25	0	Allow NULL?
37	BWVR02	Reference 2	String	Generic Edit	25	0	Allow NULL?
38	BWITM	Item Number - Short	Numeric	Generic Edit	8	0	Allow NULL?
39	BWLITM	2nd Item Number	String	Generic Edit	25	0	Allow NULL?
40	BWDSC1	Description	String	Generic Edit	30	0	Allow NULL?
41	BWDSC2	Description - Line 2	String	Generic Edit	30	0	Allow NULL?
42	BWLNTY	Line Type	String	Generic Edit	2	0	Allow NULL?
43	BWNXTR	Status Code - Next	String	UDC (40 AT)	3	0	Allow NULL?
44	BWLTTR	Status Code - Last	String	UDC (40 AT)	3	0	Allow NULL?
45	BWPDP1	Reporting Code 1 - Purchasing	String	UDC (41 P1)	3	0	Allow NULL?
46	BWPDP2	Reporting Code 2 - Purchasing	String	UDC (41 P2)	3	0	Allow NULL?
47	BWPDP3	Reporting Code 3 - Purchasing	String	UDC (41 P3)	3	0	Allow NULL?
48	BWPDP4	Reporting Code 4 - Purchasing	String	UDC (41 P4)	3	0	Allow NULL?
49	BWPDP5	Reporting Code 5 - Purchasing	String	UDC (41 P5)	3	0	Allow NULL?
50	BWUOM	Unit of Measure as Input	String	UDC (00 UM)	2	0	Allow NULL?
51	BWPRRC	Amount - Unit Cost	Numeric	Generic Edit	15	4	Allow NULL?
52	BWUORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	0	Allow NULL?
53	BWAEXP	Amount - Extended Price	Numeric	Generic Edit	15	2	Allow NULL?
54	BWPERFCTR	Factor Percentage	Numeric	Generic Edit	15	6	Allow NULL?
55	BWFTN1	Amount - Tax Commitment	Numeric	Generic Edit	15	2	Allow NULL?
56	BWPTC	Payment Terms Code	String	Generic Edit	3	0	Allow NULL?
57	BWTX	Purchasing Taxable (Y/N)	Character	UDC (H00 TV)	1	0	Allow NULL?
58	BWEXR1	Tax Expl Code 1	String	UDC (00 EX)	2	0	Allow NULL?
59	BWTXA1	Tax Rate/Area	String	Generic Edit	10	0	Allow NULL?
60	BWANBY	Buyer Number	Numeric	Generic Edit	8	0	Allow NULL?
61	BWGLC	G/L Offset	String	Generic Edit	4	0	Allow NULL?
62	BWCTRY	Century	Numeric	Generic Edit	2	0	Allow NULL?
63	BWFY	Fiscal Year	Numeric	Generic Edit	2	0	Allow NULL?
64	BWRCD	Reason Code	String	UDC (42 RC)	3	0	Allow NULL?
65	BWFUF1	AIA Document Flag	Character	UDC (H40 FU)	1	0	Allow NULL?
66	BWFUF2	Post Quantities	Character	Generic Edit	1	0	Allow NULL?
67	BWLT	Ledger Types	String	UDC (09 LT)	2	0	Allow NULL?
68	BWPCRT	Percent - Retainage	Numeric	Generic Edit	7	3	Allow NULL?
69	BWRTNR	Retainage Rule	String	Generic Edit	3	0	Allow NULL?
70	BWPURG	Purge Code	Character	Generic Edit	1	0	Allow NULL?
71	BWCRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC (H00 CY)	1	0	Allow NULL?
72	BWCRCD	Currency Code - From	String	Generic Edit	3	0	Allow NULL?
73	BWCRR	Currency Conversion Rate - Spot Rate	Numeric	Generic Edit	15	0	Allow NULL?
74	BWFRRC	Amount - Foreign Unit Price	Numeric	Generic Edit	15	4	Allow NULL?
75	BWFEA	Amount - Foreign Extended Price	Numeric	Generic Edit	15	2	Allow NULL?
76	BWFUC	Amount - Foreign Unit Cost	Numeric	Generic Edit	15	4	Allow NULL?
77	BWFEC	Amount - Foreign Extended Cost	Numeric	Generic Edit	15	2	Allow NULL?
78	BWHBST1	HomeBuilder Status Code 1	Character	Generic Edit	1	0	Allow NULL?
79	BWHBST2	HomeBuilder Status Code 2	Character	Generic Edit	1	0	Allow NULL?
80	BWHBST3	HomeBuilder Status Code 3	Character	Generic Edit	1	0	Allow NULL?
81	BWHBST4	HomeBuilder Status Code 4	Character	Generic Edit	1	0	Allow NULL?
82	BWHBST5	HomeBuilder Status Code 5	Character	Generic Edit	1	0	Allow NULL?
83	BWURRF	User Reserved Reference	String	Generic Edit	15	0	Allow NULL?
84	BWCRTU	Created by user	String	Generic Edit	10	0	Allow NULL?
85	BWCRTJ	Date - Created	Date	Generic Edit	6	0
86	BWCRTT	Time - Created	Numeric	Generic Edit	6	0	Allow NULL?
87	BWWRKSTNID	Original Work Station ID	String	Generic Edit	10	0	Allow NULL?
88	BWHBOPID	Original Program ID	String	Generic Edit	10	0	Allow NULL?
89	BWUPMB	Updated By - User	String	Generic Edit	10	0	Allow NULL?
90	BWUPMJ	Date - Updated	Date	Generic Edit	6	0
91	BWUPMT	Time - Last Updated	Numeric	Generic Edit	6	0	Allow NULL?
92	BWJOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
93	BWPID	Program ID	String	Generic Edit	10	0	Allow NULL?

TOP 920 | 44H | F44H611W INDEXES

Number

Description

JOBS KCOO DOCO + (Primary/Unique)

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

JOBS DOCO DCTO +

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

JOBS OKCO ODOC +

Element	Alias	Description	Sequence
1	JOBS	Job Number	Ascending
2	OKCO	Document Company (Original Order)	Ascending
3	ODOC	Document - Original	Ascending
4	OCTO	Original Order Type	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

93 COLUMNS | 3 INDEXES | 920 | 44H | F44H611W TABLE

TOP 920 | 44H | F44H611W COLUMNS

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

93 COLUMNS | 3 INDEXES | 920 | 44H | F44H611W TABLE

TOP920 | 44H | F44H611W COLUMNS

TOP920 | 44H | F44H611W INDEXES

TOP 920 | 44H | F44H611W COLUMNS

TOP 920 | 44H | F44H611W INDEXES