	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

106 COLUMNS | 15 INDEXES | 920 | 44H | F44H711 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
44H: Homebuilder Management
1	920	F44H711	SW	106	15	Lot Start 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 SWMCU, SWOBJ, SWSUB, SWOPTION, SWAN8, SWITM, SWSEQ, SWLITM, SWAITM, SWMCUTJ, SWGENJOB, SWJOBS, SWAVEL, SWLSWVER, SWBUDONLY, SWLSWPOSTB, SWHBPFLG1, SWLSWPOSTC, SWOPKID, SWOKCO, SWOORN, SWOCTO, SWOSFX, SWOGNO, SWKCOO, SWDOCO, SWDCTO, SWSFXO, SWLNID, SWHBMCUS, SWHBLOT, SWCPHASE, SWHBAREA, SWSHAN, SWDGL, SWOPDJ, SWTRDJ, SWPN, SWDESC, SWVR01, SWVR02, SWDSC1, SWDSC2, SWRMK, SWVNDTBD, SWLNTY, SWPDP1, SWPDP2, SWPDP3, SWPDP4, SWPDP5, SWOSCQTY, SWUOM, SWUORG, SWPRRC, SWAEXP, SWFTN1, SWLSWOGBA, SWPTC, SWTX, SWEXR1, SWTXA1, SWATXT, SWANBY, SWGLC, SWCTRY, SWFY, SWSTTS, SWRCD, SWFUF1, SWFUF2, SWANI, SWAID, SWLT, SWHBPLAN, SWHBELEV, SWR001, SWPCRT, SWRTNR, SWPURG, SWCRCD, SWCRCF, SWCRRM, SWCRR, SWFRRC, SWFEA, SWFUC, SWFEC, SWURRF, SWHBST1, SWHBST2, SWHBST3, SWHBST4, SWHBST5, SWLSWLRK, SWCRTU, SWCRTJ, SWCRTT, SWWRKSTNID, SWHBOPID, SWUPMB, SWUPMJ, SWUPMT, SWJOBN, SWPID, SWNPF FROM F44H711

TOP 920 | 44H | F44H711 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	SWMCU	Business Unit	String	Generic Edit	12	0	Allow NULL?
2	SWOBJ	Object Account	String	Generic Edit	6	0	Allow NULL?
3	SWSUB	Subsidiary	String	Generic Edit	8	0	Allow NULL?
4	SWOPTION	Option Number	String	Generic Edit	8	0	Allow NULL?
5	SWAN8	Address Number	Numeric	Generic Edit	8	0	Allow NULL?
6	SWITM	Item Number - Short	Numeric	Generic Edit	8	0	Allow NULL?
7	SWSEQ	Sequence Number	Numeric	Generic Edit	6	0	Allow NULL?
8	SWLITM	2nd Item Number	String	Generic Edit	25	0	Allow NULL?
9	SWAITM	3rd Item Number	String	Generic Edit	25	0	Allow NULL?
10	SWMCUTJ	Cost Code Template	String	Generic Edit	12	0	Allow NULL?
11	SWGENJOB	Generation Job Number	Numeric	Generic Edit	8	0	Allow NULL?
12	SWJOBS	Job Number	Numeric	Generic Edit	8	0	Allow NULL?
13	SWAVEL	Autovoucher Eligible Flag	Character	Generic Edit	1	0	Allow NULL?
14	SWLSWVER	Lot Start Workfile Version	String	Generic Edit	10	0	Allow NULL?
15	SWBUDONLY	Budget Only	Character	Generic Edit	1	0	Allow NULL?
16	SWLSWPOSTB	Budget Posting Status	Character	UDC (44H7 BP)	1	0	Allow NULL?
17	SWHBPFLG1	Homebuilder - Lot Start Process Type	Character	UDC (44H7 LP)	1	0	Allow NULL?
18	SWLSWPOSTC	Commitment Posting Status	Character	UDC (44H7 PS)	1	0	Allow NULL?
19	SWOPKID	Option Package Id	String	Generic Edit	8	0	Allow NULL?
20	SWOKCO	Document Company (Original Order)	String	Generic Edit	5	0	Allow NULL?
21	SWOORN	Original Order Number	String	Generic Edit	8	0	Allow NULL?
22	SWOCTO	Original Order Type	String	UDC (00 DT)	2	0	Allow NULL?
23	SWOSFX	Document Pay Item - Original	String	Generic Edit	3	0	Allow NULL?
24	SWOGNO	Original Line Number	Numeric	Generic Edit	7	3	Allow NULL?
25	SWKCOO	Order Company (Order Number)	String	Generic Edit	5	0	Allow NULL?
26	SWDOCO	Document (Order No Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
27	SWDCTO	Order Type	String	UDC (00 DT)	2	0	Allow NULL?
28	SWSFXO	Order Suffix	String	Generic Edit	3	0	Allow NULL?
29	SWLNID	Line Number	Numeric	Generic Edit	6	3	Allow NULL?
30	SWHBMCUS	Community	String	Generic Edit	12	0	Allow NULL?
31	SWHBLOT	Lot Number	String	Generic Edit	4	0	Allow NULL?
32	SWCPHASE	Phase	String	Generic Edit	3	0	Allow NULL?
33	SWHBAREA	HomeBuilder Area ID	String	UDC (00 05)	3	0	Allow NULL?
34	SWSHAN	Address Number - Ship To	Numeric	Generic Edit	8	0	Allow NULL?
35	SWDGL	Date - For G/L (and Voucher)	Date	Generic Edit	6	0
36	SWOPDJ	Date - Original Promised Delivery	Date	Generic Edit	6	0
37	SWTRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
38	SWPN	Period Number - General Ledger	Numeric	Generic Edit	2	0	Allow NULL?
39	SWDESC	Description	String	Generic Edit	30	0	Allow NULL?
40	SWVR01	Reference	String	Generic Edit	25	0	Allow NULL?
41	SWVR02	Reference 2	String	Generic Edit	25	0	Allow NULL?
42	SWDSC1	Description	String	Generic Edit	30	0	Allow NULL?
43	SWDSC2	Description - Line 2	String	Generic Edit	30	0	Allow NULL?
44	SWRMK	Name - Remark	String	Generic Edit	30	0	Allow NULL?
45	SWVNDTBD	Supplier TBD	Character	Generic Edit	1	0	Allow NULL?
46	SWLNTY	Line Type	String	Generic Edit	2	0	Allow NULL?
47	SWPDP1	Reporting Code 1 - Purchasing	String	UDC (41 P1)	3	0	Allow NULL?
48	SWPDP2	Reporting Code 2 - Purchasing	String	UDC (41 P2)	3	0	Allow NULL?
49	SWPDP3	Reporting Code 3 - Purchasing	String	UDC (41 P3)	3	0	Allow NULL?
50	SWPDP4	Reporting Code 4 - Purchasing	String	UDC (41 P4)	3	0	Allow NULL?
51	SWPDP5	Reporting Code 5 - Purchasing	String	UDC (41 P5)	3	0	Allow NULL?
52	SWOSCQTY	Cumulative Quantity Selected	Numeric	Generic Edit	15	0	Allow NULL?
53	SWUOM	Unit of Measure as Input	String	UDC (00 UM)	2	0	Allow NULL?
54	SWUORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	0	Allow NULL?
55	SWPRRC	Amount - Unit Cost	Numeric	Generic Edit	15	4	Allow NULL?
56	SWAEXP	Amount - Extended Price	Numeric	Generic Edit	15	2	Allow NULL?
57	SWFTN1	Amount - Tax Commitment	Numeric	Generic Edit	15	2	Allow NULL?
58	SWLSWOGBA	Lot Start WF - Orig. Gen'd Budget Amt.	Numeric	Generic Edit	15	2	Allow NULL?
59	SWPTC	Payment Terms Code	String	Generic Edit	3	0	Allow NULL?
60	SWTX	Purchasing Taxable (Y/N)	Character	UDC (H00 TV)	1	0	Allow NULL?
61	SWEXR1	Tax Expl Code 1	String	UDC (00 EX)	2	0	Allow NULL?
62	SWTXA1	Tax Rate/Area	String	Generic Edit	10	0	Allow NULL?
63	SWATXT	Associated Text	Character	Generic Edit	1	0	Allow NULL?
64	SWANBY	Buyer Number	Numeric	Generic Edit	8	0	Allow NULL?
65	SWGLC	G/L Offset	String	Generic Edit	4	0	Allow NULL?
66	SWCTRY	Century	Numeric	Generic Edit	2	0	Allow NULL?
67	SWFY	Fiscal Year	Numeric	Generic Edit	2	0	Allow NULL?
68	SWSTTS	Line Status	String	Generic Edit	2	0	Allow NULL?
69	SWRCD	Reason Code	String	UDC (42 RC)	3	0	Allow NULL?
70	SWFUF1	AIA Document Flag	Character	UDC (H40 FU)	1	0	Allow NULL?
71	SWFUF2	Post Quantities	Character	Generic Edit	1	0	Allow NULL?
72	SWANI	Account Number - Input (Mode Unknown)	String	Generic Edit	29	0	Allow NULL?
73	SWAID	Account ID	String	Generic Edit	8	0	Allow NULL?
74	SWLT	Ledger Types	String	UDC (09 LT)	2	0	Allow NULL?
75	SWHBPLAN	Plan Number	String	Generic Edit	4	0	Allow NULL?
76	SWHBELEV	Elevation	String	Generic Edit	3	0	Allow NULL?
77	SWR001	Category Code - G/L1	String	UDC (09 01)	3	0	Allow NULL?
78	SWPCRT	Percent - Retainage	Numeric	Generic Edit	7	3	Allow NULL?
79	SWRTNR	Retainage Rule	String	Generic Edit	3	0	Allow NULL?
80	SWPURG	Purge Code	Character	Generic Edit	1	0	Allow NULL?
81	SWCRCD	Currency Code - From	String	Generic Edit	3	0	Allow NULL?
82	SWCRCF	Currency Code - Origin	String	Generic Edit	3	0	Allow NULL?
83	SWCRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC (H00 CY)	1	0	Allow NULL?
84	SWCRR	Currency Conversion Rate - Spot Rate	Numeric	Generic Edit	15	0	Allow NULL?
85	SWFRRC	Amount - Foreign Unit Price	Numeric	Generic Edit	15	4	Allow NULL?
86	SWFEA	Amount - Foreign Extended Price	Numeric	Generic Edit	15	2	Allow NULL?
87	SWFUC	Amount - Foreign Unit Cost	Numeric	Generic Edit	15	4	Allow NULL?
88	SWFEC	Amount - Foreign Extended Cost	Numeric	Generic Edit	15	2	Allow NULL?
89	SWURRF	User Reserved Reference	String	Generic Edit	15	0	Allow NULL?
90	SWHBST1	HomeBuilder Status Code 1	Character	Generic Edit	1	0	Allow NULL?
91	SWHBST2	HomeBuilder Status Code 2	Character	Generic Edit	1	0	Allow NULL?
92	SWHBST3	HomeBuilder Status Code 3	Character	Generic Edit	1	0	Allow NULL?
93	SWHBST4	HomeBuilder Status Code 4	Character	Generic Edit	1	0	Allow NULL?
94	SWHBST5	HomeBuilder Status Code 5	Character	Generic Edit	1	0	Allow NULL?
95	SWLSWLRK	Lot Start WF - Link Record Key ID	Numeric	Generic Edit	8	0	Allow NULL?
96	SWCRTU	Created by user	String	Generic Edit	10	0	Allow NULL?
97	SWCRTJ	Date - Created	Date	Generic Edit	6	0
98	SWCRTT	Time - Created	Numeric	Generic Edit	6	0	Allow NULL?
99	SWWRKSTNID	Original Work Station ID	String	Generic Edit	10	0	Allow NULL?
100	SWHBOPID	Original Program ID	String	Generic Edit	10	0	Allow NULL?
101	SWUPMB	Updated By - User	String	Generic Edit	10	0	Allow NULL?
102	SWUPMJ	Date - Updated	Date	Generic Edit	6	0
103	SWUPMT	Time - Last Updated	Numeric	Generic Edit	6	0	Allow NULL?
104	SWJOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
105	SWPID	Program ID	String	Generic Edit	10	0	Allow NULL?
106	SWNPF	Nationally Purchased Flag	Character	Generic Edit	1	0	Allow NULL?

TOP 920 | 44H | F44H711 INDEXES

Number

Description

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

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

GENJOB

Element	Alias	Description	Sequence
1	GENJOB	Generation Job Number	Ascending

JOBS

Element	Alias	Description	Sequence
1	JOBS	Job Number	Ascending

MCU HBPFLG1 OKCO OCTO OORN +

Element	Alias	Description	Sequence
1	MCU	Business Unit	Ascending
2	HBPFLG1	Homebuilder - Lot Start Process Type	Ascending
3	OKCO	Document Company (Original Order)	Ascending
4	OCTO	Original Order Type	Ascending
5	OORN	Original Order Number	Ascending
6	OGNO	Original Line Number	Ascending

MCU HBPFLG1 AN8 SUB OBJ +

Element	Alias	Description	Sequence
1	MCU	Business Unit	Ascending
2	HBPFLG1	Homebuilder - Lot Start Process Type	Ascending
3	AN8	Address Number	Ascending
4	SUB	Subsidiary	Ascending
5	OBJ	Object Account	Ascending

JOBS MCU OBJ SUB OPTION

Element	Alias	Description	Sequence
1	JOBS	Job Number	Ascending
2	MCU	Business Unit	Ascending
3	OBJ	Object Account	Ascending
4	SUB	Subsidiary	Ascending
5	OPTION	Option Number	Ascending

LSWVER MCU OBJ SUB OPTION +

Element	Alias	Description	Sequence
1	LSWVER	Lot Start Workfile Version	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

LSWLRK MCU SUB OPTION AN8 +

Element	Alias	Description	Sequence
1	LSWLRK	Lot Start WF - Link Record Key ID	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

MCU OBJ SUB OPTION KCOO DOCO +

Element	Alias	Description	Sequence
1	MCU	Business Unit	Ascending
2	OBJ	Object Account	Ascending
3	SUB	Subsidiary	Ascending
4	OPTION	Option Number	Ascending
5	KCOO	Order Company (Order Number)	Ascending
6	DOCO	Document (Order No Invoice etc.)	Ascending
7	DCTO	Order Type	Ascending

MCU OBJ SUB OPTION AN8 ITM +

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

OPTION OPKID MCU OBJ SUB AN8 +

Element	Alias	Description	Sequence
1	OPTION	Option Number	Ascending
2	OPKID	Option Package Id	Ascending
3	MCU	Business Unit	Ascending
4	OBJ	Object Account	Ascending
5	SUB	Subsidiary	Ascending
6	AN8	Address Number	Ascending
7	ITM	Item Number - Short	Ascending

MCU OPTION SEQ(REV) LSWLRK

Element	Alias	Description	Sequence
1	MCU	Business Unit	Ascending
2	OPTION	Option Number	Ascending
3	SEQ	Sequence Number	Descending
4	LSWLRK	Lot Start WF - Link Record Key ID	Ascending

OKCO OORN OCTO OSFX HBMCUS +

Element	Alias	Description	Sequence
1	OKCO	Document Company (Original Order)	Ascending
2	OORN	Original Order Number	Ascending
3	OCTO	Original Order Type	Ascending
4	OSFX	Document Pay Item - Original	Ascending
5	HBMCUS	Community	Ascending
6	HBLOT	Lot Number	Ascending
7	GENJOB	Generation Job Number	Ascending

MCU OBJ SUB OPT AN8 HBPFLG1 +

Element	Alias	Description	Sequence
1	MCU	Business Unit	Ascending
2	OBJ	Object Account	Ascending
3	SUB	Subsidiary	Ascending
4	OPTION	Option Number	Ascending
5	AN8	Address Number	Ascending
6	HBPFLG1	Homebuilder - Lot Start Process Type	Ascending
7	OPKID	Option Package Id	Ascending
8	ITM	Item Number - Short	Ascending

HBAREA HBMCUS CPHASE MCU +

Element	Alias	Description	Sequence
1	HBAREA	HomeBuilder Area ID	Ascending
2	HBMCUS	Community	Ascending
3	CPHASE	Phase	Ascending
4	MCU	Business Unit	Ascending
5	OBJ	Object Account	Ascending
6	SUB	Subsidiary	Ascending
7	OPTION	Option Number	Ascending
8	AN8	Address Number	Ascending
9	ITM	Item Number - Short	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

106 COLUMNS | 15 INDEXES | 920 | 44H | F44H711 TABLE

TOP 920 | 44H | F44H711 COLUMNS

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

106 COLUMNS | 15 INDEXES | 920 | 44H | F44H711 TABLE

TOP920 | 44H | F44H711 COLUMNS

TOP920 | 44H | F44H711 INDEXES

TOP 920 | 44H | F44H711 COLUMNS

TOP 920 | 44H | F44H711 INDEXES