	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

104 COLUMNS | 2 INDEXES | 812 | 44H | F44H71W1 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
44H: Homebuilder Management
1	812	F44H71W1	GW	104	2	Lot Start Generation Workfile	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 GWGENJOB, GWMCU, GWOBJ, GWSUB, GWOPTION, GWAN8, GWITM, GWSEQ, GWLITM, GWAITM, GWMCUTJ, GWERRF, GWOPKID, GWAVEL, GWLSWVER, GWBUDONLY, GWLSWPOSTB, GWHBPFLG1, GWLSWPOSTC, GWOKCO, GWOORN, GWOCTO, GWOSFX, GWOGNO, GWKCOO, GWDOCO, GWDCTO, GWSFXO, GWLNID, GWHBMCUS, GWHBLOT, GWCPHASE, GWHBAREA, GWSHAN, GWDGL, GWOPDJ, GWTRDJ, GWPN, GWDESC, GWVR01, GWVR02, GWDSC1, GWDSC2, GWRMK, GWVNDTBD, GWLNTY, GWPDP1, GWPDP2, GWPDP3, GWPDP4, GWPDP5, GWOSCQTY, GWUOM, GWUORG, GWPRRC, GWAEXP, GWFTN1, GWLSWOGBA, GWPTC, GWTX, GWEXR1, GWTXA1, GWATXT, GWANBY, GWGLC, GWCTRY, GWFY, GWSTTS, GWRCD, GWFUF1, GWFUF2, GWANI, GWAID, GWLT, GWHBPLAN, GWHBELEV, GWR001, GWPCRT, GWRTNR, GWPURG, GWCRCD, GWCRCF, GWCRRM, GWCRR, GWFRRC, GWFEA, GWFUC, GWFEC, GWURRF, GWHBST1, GWHBST2, GWHBST3, GWHBST4, GWHBST5, GWCRTU, GWCRTJ, GWCRTT, GWWRKSTNID, GWHBOPID, GWUPMB, GWUPMJ, GWUPMT, GWJOBN, GWPID FROM F44H71W1

TOP 812 | 44H | F44H71W1 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	GWGENJOB	Generation Job Number	Numeric	Generic Edit	8	0	Allow NULL?
2	GWMCU	Business Unit	String	Generic Edit	12	0	Allow NULL?
3	GWOBJ	Object Account	String	Generic Edit	6	0	Allow NULL?
4	GWSUB	Subsidiary	String	Generic Edit	8	0	Allow NULL?
5	GWOPTION	Option Number	String	Generic Edit	8	0	Allow NULL?
6	GWAN8	Address Number	Numeric	UDC	8	0	Allow NULL?
7	GWITM	Item Number - Short	Numeric	Generic Edit	8	0	Allow NULL?
8	GWSEQ	Sequence Number	Numeric	Generic Edit	6	0	Allow NULL?
9	GWLITM	2nd Item Number	String	Generic Edit	25	0	Allow NULL?
10	GWAITM	3rd Item Number	String	Generic Edit	25	0	Allow NULL?
11	GWMCUTJ	Cost Code Template	String	Generic Edit	12	0	Allow NULL?
12	GWERRF	File in Error	String	Generic Edit	10	0	Allow NULL?
13	GWOPKID	Option Package Id	String	Generic Edit	8	0	Allow NULL?
14	GWAVEL	Autovoucher Eligible Flag	Character	Generic Edit	1	0	Allow NULL?
15	GWLSWVER	Lot Start Workfile Version	String	Generic Edit	10	0	Allow NULL?
16	GWBUDONLY	Budget Only	Character	Generic Edit	1	0	Allow NULL?
17	GWLSWPOSTB	Budget Posting Status	Character	UDC (44H7 BP)	1	0	Allow NULL?
18	GWHBPFLG1	Homebuilder - Lot Start Process Type	Character	UDC (44H7 LP)	1	0	Allow NULL?
19	GWLSWPOSTC	Commitment Posting Status	Character	UDC (44H7 PS)	1	0	Allow NULL?
20	GWOKCO	Document Company (Original Order)	String	Generic Edit	5	0	Allow NULL?
21	GWOORN	Original Order Number	String	Generic Edit	8	0	Allow NULL?
22	GWOCTO	Original Order Type	String	UDC (00 DT)	2	0	Allow NULL?
23	GWOSFX	Document Pay Item - Original	String	Generic Edit	3	0	Allow NULL?
24	GWOGNO	Original Line Number	Numeric	Generic Edit	7	3	Allow NULL?
25	GWKCOO	Order Company (Order Number)	String	Generic Edit	5	0	Allow NULL?
26	GWDOCO	Document (Order No Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
27	GWDCTO	Order Type	String	UDC (00 DT)	2	0	Allow NULL?
28	GWSFXO	Order Suffix	String	Generic Edit	3	0	Allow NULL?
29	GWLNID	Line Number	Numeric	Generic Edit	6	3	Allow NULL?
30	GWHBMCUS	Community	String	Generic Edit	12	0	Allow NULL?
31	GWHBLOT	Lot Number	String	Generic Edit	4	0	Allow NULL?
32	GWCPHASE	Phase	String	Generic Edit	3	0	Allow NULL?
33	GWHBAREA	HomeBuilder Area ID	String	UDC (00 05)	3	0	Allow NULL?
34	GWSHAN	Address Number - Ship To	Numeric	Generic Edit	8	0	Allow NULL?
35	GWDGL	Date - For G/L (and Voucher)	Date	Generic Edit	6	0
36	GWOPDJ	Date - Original Promised Delivery	Date	Generic Edit	6	0
37	GWTRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
38	GWPN	Period Number - General Ledger	Numeric	Generic Edit	2	0	Allow NULL?
39	GWDESC	Description	String	Generic Edit	30	0	Allow NULL?
40	GWVR01	Reference	String	Generic Edit	25	0	Allow NULL?
41	GWVR02	Reference 2	String	Generic Edit	25	0	Allow NULL?
42	GWDSC1	Description	String	Generic Edit	30	0	Allow NULL?
43	GWDSC2	Description - Line 2	String	Generic Edit	30	0	Allow NULL?
44	GWRMK	Name - Remark	String	Generic Edit	30	0	Allow NULL?
45	GWVNDTBD	Supplier TBD	Character	Generic Edit	1	0	Allow NULL?
46	GWLNTY	Line Type	String	Generic Edit	2	0	Allow NULL?
47	GWPDP1	Reporting Code 1 - Purchasing	String	UDC (41 P1)	3	0	Allow NULL?
48	GWPDP2	Reporting Code 2 - Purchasing	String	UDC (41 P2)	3	0	Allow NULL?
49	GWPDP3	Reporting Code 3 - Purchasing	String	UDC (41 P3)	3	0	Allow NULL?
50	GWPDP4	Reporting Code 4 - Purchasing	String	UDC (41 P4)	3	0	Allow NULL?
51	GWPDP5	Reporting Code 5 - Purchasing	String	UDC (41 P5)	3	0	Allow NULL?
52	GWOSCQTY	Cumulative Quantity Selected	Numeric	Generic Edit	15	0	Allow NULL?
53	GWUOM	Unit of Measure as Input	String	UDC (00 UM)	2	0	Allow NULL?
54	GWUORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2	Allow NULL?
55	GWPRRC	Amount - Unit Cost	Numeric	Generic Edit	15	4	Allow NULL?
56	GWAEXP	Amount - Extended Price	Numeric	Generic Edit	15	2	Allow NULL?
57	GWFTN1	Amount - Tax Commitment	Numeric	Generic Edit	15	2	Allow NULL?
58	GWLSWOGBA	Lot Start WF - Orig. Gen'd Budget Amt.	Numeric	Generic Edit	15	2	Allow NULL?
59	GWPTC	Payment Terms Code	String	Generic Edit	3	0	Allow NULL?
60	GWTX	Purchasing Taxable (Y/N)	Character	UDC (H00 TV)	1	0	Allow NULL?
61	GWEXR1	Tax Expl Code 1	String	UDC (00 EX)	2	0	Allow NULL?
62	GWTXA1	Tax Rate/Area	String	Generic Edit	10	0	Allow NULL?
63	GWATXT	Associated Text	Character	Generic Edit	1	0	Allow NULL?
64	GWANBY	Buyer Number	Numeric	Generic Edit	8	0	Allow NULL?
65	GWGLC	G/L Offset	String	Generic Edit	4	0	Allow NULL?
66	GWCTRY	Century	Numeric	Generic Edit	2	0	Allow NULL?
67	GWFY	Fiscal Year	Numeric	Generic Edit	2	0	Allow NULL?
68	GWSTTS	Line Status	String	Generic Edit	2	0	Allow NULL?
69	GWRCD	Reason Code	String	UDC (42 RC)	3	0	Allow NULL?
70	GWFUF1	AIA Document Flag	Character	UDC (H40 FU)	1	0	Allow NULL?
71	GWFUF2	Post Quantities	Character	Generic Edit	1	0	Allow NULL?
72	GWANI	Account Number - Input (Mode Unknown)	String	Generic Edit	29	0	Allow NULL?
73	GWAID	Account ID	String	Generic Edit	8	0	Allow NULL?
74	GWLT	Ledger Types	String	UDC (09 LT)	2	0	Allow NULL?
75	GWHBPLAN	Plan Number	String	Generic Edit	4	0	Allow NULL?
76	GWHBELEV	Elevation	String	Generic Edit	3	0	Allow NULL?
77	GWR001	Category Code - G/L1	String	UDC (09 01)	3	0	Allow NULL?
78	GWPCRT	Percent - Retainage	Numeric	Generic Edit	7	3	Allow NULL?
79	GWRTNR	Retainage Rule	String	Generic Edit	3	0	Allow NULL?
80	GWPURG	Purge Code	Character	Generic Edit	1	0	Allow NULL?
81	GWCRCD	Currency Code - From	String	Generic Edit	3	0	Allow NULL?
82	GWCRCF	Currency Code - Origin	String	Generic Edit	3	0	Allow NULL?
83	GWCRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC (H00 CY)	1	0	Allow NULL?
84	GWCRR	Currency Conversion Rate - Spot Rate	Numeric	Generic Edit	15	0	Allow NULL?
85	GWFRRC	Amount - Foreign Unit Price	Numeric	Generic Edit	15	4	Allow NULL?
86	GWFEA	Amount - Foreign Extended Price	Numeric	Generic Edit	15	2	Allow NULL?
87	GWFUC	Amount - Foreign Unit Cost	Numeric	Generic Edit	15	4	Allow NULL?
88	GWFEC	Amount - Foreign Extended Cost	Numeric	Generic Edit	15	2	Allow NULL?
89	GWURRF	User Reserved Reference	String	Generic Edit	15	0	Allow NULL?
90	GWHBST1	HomeBuilder Status Code 1	Character	Generic Edit	1	0	Allow NULL?
91	GWHBST2	HomeBuilder Status Code 2	Character	Generic Edit	1	0	Allow NULL?
92	GWHBST3	HomeBuilder Status Code 3	Character	Generic Edit	1	0	Allow NULL?
93	GWHBST4	HomeBuilder Status Code 4	Character	Generic Edit	1	0	Allow NULL?
94	GWHBST5	HomeBuilder Status Code 5	Character	Generic Edit	1	0	Allow NULL?
95	GWCRTU	Created by user	String	Generic Edit	10	0	Allow NULL?
96	GWCRTJ	Date - Created	Date	Generic Edit	6	0
97	GWCRTT	Time - Created	Numeric	Generic Edit	6	0	Allow NULL?
98	GWWRKSTNID	Original Work Station ID	String	Generic Edit	10	0	Allow NULL?
99	GWHBOPID	Original Program ID	String	Generic Edit	10	0	Allow NULL?
100	GWUPMB	Updated By - User	String	Generic Edit	10	0	Allow NULL?
101	GWUPMJ	Date - Updated	Date	Generic Edit	6	0
102	GWUPMT	Time - Last Updated	Numeric	Generic Edit	6	0	Allow NULL?
103	GWJOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
104	GWPID	Program ID	String	Generic Edit	10	0	Allow NULL?

TOP 812 | 44H | F44H71W1 INDEXES

Number

Description

MCU OBJ SUB OPTION AN8 ITM SEQ (Primary/Unique)

Element	Alias	Description	Sequence
1	GENJOB	Generation Job Number	Ascending
2	MCU	Business Unit	Ascending
3	OBJ	Object Account	Ascending
4	SUB	Subsidiary	Ascending
5	OPTION	Option Number	Ascending
6	AN8	Address Number	Ascending
7	ITM	Item Number - Short	Ascending
8	SEQ	Sequence Number	Ascending

GENJOB MCU OPT OBJ SUB..SEQ(d)

Element	Alias	Description	Sequence
1	GENJOB	Generation Job Number	Ascending
2	MCU	Business Unit	Ascending
3	OPTION	Option Number	Ascending
4	OBJ	Object Account	Ascending
5	SUB	Subsidiary	Ascending
6	AN8	Address Number	Ascending
7	ITM	Item Number - Short	Ascending
8	SEQ	Sequence Number	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

104 COLUMNS | 2 INDEXES | 812 | 44H | F44H71W1 TABLE

TOP 812 | 44H | F44H71W1 COLUMNS

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

104 COLUMNS | 2 INDEXES | 812 | 44H | F44H71W1 TABLE

TOP812 | 44H | F44H71W1 COLUMNS

TOP812 | 44H | F44H71W1 INDEXES

TOP 812 | 44H | F44H71W1 COLUMNS

TOP 812 | 44H | F44H71W1 INDEXES