	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

138 COLUMNS | 4 INDEXES | 812 | 44H | F44H201Z TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
44H: Homebuilder Management
1	812	F44H201Z	SZ	138	4	HB Lot Master Unedited Transaction 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 SZEDUS, SZEDBT, SZEDTN, SZEDLN, SZEDCT, SZTYTN, SZEDFT, SZEDDT, SZDRIN, SZEDDL, SZEDSP, SZPNID, SZTNAC, SZHBMCUS, SZHBLOT, SZLOTADD, SZCTY1, SZADDS, SZADDZ, SZLOTCMT, SZCPHASE, SZMCU, SZCONSSEQ, SZHBAREA, SZHBPLAN, SZHBELEV, SZSWING, SZPSG, SZLSWVER, SZLSWPEND, SZLSTATHB, SZOSELCF, SZCONNXT, SZCONLST, SZSSACS, SZDCG, SZUSC, SZHBSCS, SZCSSEQ, SZBYR, SZMCUTJ, SZSCHTMPT, SZLGLLOT, SZHBBLOCK, SZHBTRACT, SZPARC, SZPARCT, SZBUILD, SZUNT3, SZSFTL, SZWLT, SZDPLT, SZACLT, SZMDLHF, SZSPECHF, SZBSP, SZLTP, SZLPP, SZBLDR, SZAN8CM01, SZPTDJ, SZPHD, SZCTYJ, SZPMN, SZPRD, SZCPJ, SZATFN, SZRLSDTE, SZCOMJ, SZLSRJ, SZLCSJ, SZLCCJ, SZUCSMSF, SZUSD1, SZUSD2, SZUSD3, SZUSD4, SZUSD5, SZUSD6, SZUSD7, SZUSD8, SZUSD9, SZUSD10, SZUAMT01, SZUAMT02, SZUAMT03, SZUAMT04, SZUAMT05, SZUAMT06, SZOA1, SZOA2, SZUC01, SZUC02, SZUC03, SZUC04, SZUC05, SZUC06, SZLCC01, SZLCC02, SZLCC03, SZLCC04, SZLCC05, SZLCC06, SZLCC07, SZLCC08, SZLCC09, SZLCC10, SZACCL, SZCLRH, SZROF, SZBDC, SZFSC, SZCLPK, SZDOC01, SZDOC02, SZDOC03, SZDCT01, SZDCT02, SZDCT03, SZCDJ, SZSUB, SZCO, SZRLSN, SZHBST1, SZHBST2, SZHBST3, SZHBST4, SZHBST5, SZCRTU, SZCRTJ, SZCRTT, SZWRKSTNID, SZHBOPID, SZUPMB, SZUPMJ, SZUPMT, SZJOBN, SZPID FROM F44H201Z

TOP 812 | 44H | F44H201Z COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	SZEDUS	EDI - User ID	String	Generic Edit	10	0	Allow NULL?
2	SZEDBT	EDI - Batch Number	String	Generic Edit	15	0	Allow NULL?
3	SZEDTN	EDI - Transaction Number	String	Generic Edit	22	0	Allow NULL?
4	SZEDLN	EDI - Line Number	Numeric	Generic Edit	7	3	Allow NULL?
5	SZEDCT	EDI - Document Type	String	Generic Edit	2	0	Allow NULL?
6	SZTYTN	Type - Transaction	String	UDC (00 TT)	8	0	Allow NULL?
7	SZEDFT	EDI - Translation Format	String	Generic Edit	10	0	Allow NULL?
8	SZEDDT	EDI - Transmission Date	Date	Generic Edit	6	0
9	SZDRIN	Direction Indicator	Character	UDC (00 DN)	1	0	Allow NULL?
10	SZEDDL	EDI - Detail Lines Processed	Numeric	Generic Edit	5	0	Allow NULL?
11	SZEDSP	EDI - Successfully Processed	Character	Generic Edit	1	0	Allow NULL?
12	SZPNID	Trading Partner ID	String	Generic Edit	15	0	Allow NULL?
13	SZTNAC	Transaction Action	String	UDC (00 TA)	2	0	Allow NULL?
14	SZHBMCUS	Community	String	Generic Edit	12	0	Allow NULL?
15	SZHBLOT	Lot Number	String	Generic Edit	4	0	Allow NULL?
16	SZLOTADD	Lot Address	String	Generic Edit	40	0	Allow NULL?
17	SZCTY1	City	String	Generic Edit	25	0	Allow NULL?
18	SZADDS	State	String	UDC (00 S)	3	0	Allow NULL?
19	SZADDZ	Postal Code	String	Generic Edit	12	0	Allow NULL?
20	SZLOTCMT	Lot Comment	String	Generic Edit	40	0	Allow NULL?
21	SZCPHASE	Phase	String	Generic Edit	3	0	Allow NULL?
22	SZMCU	Business Unit	String	Generic Edit	12	0	Allow NULL?
23	SZCONSSEQ	Construction Sequence Number	String	Generic Edit	3	0	Allow NULL?
24	SZHBAREA	HomeBuilder Area ID	String	UDC (00 05)	3	0	Allow NULL?
25	SZHBPLAN	Plan Number	String	Generic Edit	4	0	Allow NULL?
26	SZHBELEV	Elevation	String	Generic Edit	3	0	Allow NULL?
27	SZSWING	Swing	Character	UDC (44H2 SW)	1	0	Allow NULL?
28	SZPSG	Posting Stage	Numeric	Generic Edit	3	0	Allow NULL?
29	SZLSWVER	Lot Start Workfile Version	String	Generic Edit	10	0	Allow NULL?
30	SZLSWPEND	Lot Start Workfile Pending Records	Character	Generic Edit	1	0	Allow NULL?
31	SZLSTATHB	Lot Status Code - HomeBuilder	Character	UDC (44H2 LS)	1	0	Allow NULL?
32	SZOSELCF	Option Selection Changed Flag	Character	Generic Edit	1	0	Allow NULL?
33	SZCONNXT	Construction Status Code Next	String	UDC (44H0 RL)	3	0	Allow NULL?
34	SZCONLST	Construction Status Code Last	String	UDC (44H0 RL)	3	0	Allow NULL?
35	SZSSACS	Sales Status At Construction Start	String	Generic Edit	3	0	Allow NULL?
36	SZDCG	Date - Status Changed	Date	Generic Edit	6	0
37	SZUSC	User ID - Last Changed	String	Generic Edit	10	0	Allow NULL?
38	SZHBSCS	Sales Contract Status	String	UDC (44H5 ST)	3	0	Allow NULL?
39	SZCSSEQ	Sequence - Current Sales	String	Generic Edit	3	0	Allow NULL?
40	SZBYR	Buyer Number	Numeric	Generic Edit	8	0	Allow NULL?
41	SZMCUTJ	Cost Code Template	String	Generic Edit	12	0	Allow NULL?
42	SZSCHTMPT	Schedule Template	String	Generic Edit	12	0	Allow NULL?
43	SZLGLLOT	Legal Lot Number	String	Generic Edit	12	0	Allow NULL?
44	SZHBBLOCK	Homebuilder Block	String	Generic Edit	12	0	Allow NULL?
45	SZHBTRACT	Homebuilder Tract Number	String	Generic Edit	12	0	Allow NULL?
46	SZPARC	Parcel Number	String	Generic Edit	20	0	Allow NULL?
47	SZPARCT	Parcel Tax Number	String	Generic Edit	20	0	Allow NULL?
48	SZBUILD	Equipment Location Building	String	Generic Edit	25	0	Allow NULL?
49	SZUNT3	Unit	String	Generic Edit	8	0	Allow NULL?
50	SZSFTL	Lot Square Footage	Numeric	Generic Edit	8	0	Allow NULL?
51	SZWLT	Width - Lot	Numeric	Generic Edit	8	2	Allow NULL?
52	SZDPLT	Depth - Lot	Numeric	Generic Edit	8	2	Allow NULL?
53	SZACLT	Acres - Lot	Numeric	Generic Edit	8	2	Allow NULL?
54	SZMDLHF	Model Home Flag	Character	Generic Edit	1	0	Allow NULL?
55	SZSPECHF	Spec House Flag	Character	Generic Edit	1	0	Allow NULL?
56	SZBSP	Amount - Base Price	Numeric	Generic Edit	15	2	Allow NULL?
57	SZLTP	Amount - Lot Premium	Numeric	Generic Edit	15	2	Allow NULL?
58	SZLPP	Amount - Lot Premium Previous	Numeric	Generic Edit	15	2	Allow NULL?
59	SZBLDR	Builder Number	Numeric	Generic Edit	8	0	Allow NULL?
60	SZAN8CM01	Address Number - Community 01	Numeric	Generic Edit	8	0	Allow NULL?
61	SZPTDJ	Plot Approval Date	Date	Generic Edit	6	0
62	SZPHD	PQ Hold Date	Date	Generic Edit	6	0
63	SZCTYJ	Date at City	Date	Generic Edit	6	0
64	SZPMN	Permit Number	String	Generic Edit	12	0	Allow NULL?
65	SZPRD	Permit Received Date	Date	Generic Edit	6	0
66	SZCPJ	Compliance Date (Julian)	Date	Generic Edit	6	0
67	SZATFN	Date - Actual Finish (Julian)	Date	Generic Edit	6	0
68	SZRLSDTE	Released for Sale Date (Julian)	Date	Generic Edit	6	0
69	SZCOMJ	Date - Commitment Start	Date	Generic Edit	6	0
70	SZLSRJ	Date - Release Status	Date	Generic Edit	6	0
71	SZLCSJ	Date - Construction Start	Date	Generic Edit	6	0
72	SZLCCJ	Date - Construction Complete	Date	Generic Edit	6	0
73	SZUCSMSF	Update CSMS Flag	Character	Generic Edit	1	0	Allow NULL?
74	SZUSD1	User Date 1	Date	Generic Edit	6	0
75	SZUSD2	User Date 2	Date	Generic Edit	6	0
76	SZUSD3	User Date 3	Date	Generic Edit	6	0
77	SZUSD4	User Date 4	Date	Generic Edit	6	0
78	SZUSD5	User Date 5	Date	Generic Edit	6	0
79	SZUSD6	User Date 6	Date	Generic Edit	6	0
80	SZUSD7	User Date 7	Date	Generic Edit	6	0
81	SZUSD8	User Date 8	Date	Generic Edit	6	0
82	SZUSD9	User Date 9	Date	Generic Edit	6	0
83	SZUSD10	User Date 10	Date	Generic Edit	6	0
84	SZUAMT01	User Defined Amount 01	Numeric	Generic Edit	15	2	Allow NULL?
85	SZUAMT02	User Defined Amount 02	Numeric	Generic Edit	15	2	Allow NULL?
86	SZUAMT03	User Defined Amount 03	Numeric	Generic Edit	15	2	Allow NULL?
87	SZUAMT04	User Defined Amount 04	Numeric	Generic Edit	15	2	Allow NULL?
88	SZUAMT05	User Defined Amount 05	Numeric	Generic Edit	15	2	Allow NULL?
89	SZUAMT06	User Defined Amount 06	Numeric	Generic Edit	15	2	Allow NULL?
90	SZOA1	Other Amount 1	Numeric	Generic Edit	15	0	Allow NULL?
91	SZOA2	Other Amount 2	Numeric	Generic Edit	15	0	Allow NULL?
92	SZUC01	User Reason Code 01	Character	Generic Edit	1	0	Allow NULL?
93	SZUC02	User Reason Code 02	Character	Generic Edit	1	0	Allow NULL?
94	SZUC03	User Reason Code 03	Character	Generic Edit	1	0	Allow NULL?
95	SZUC04	User Reason Code 04	Character	Generic Edit	1	0	Allow NULL?
96	SZUC05	User Reason Code 05	Character	Generic Edit	1	0	Allow NULL?
97	SZUC06	User Reason Code 06	Character	Generic Edit	1	0	Allow NULL?
98	SZLCC01	Lot Category Code 01	String	UDC (44H2 01)	3	0	Allow NULL?
99	SZLCC02	Lot Category Code 02	String	UDC (44H2 02)	3	0	Allow NULL?
100	SZLCC03	Lot Category Code 03	String	UDC (44H2 03)	3	0	Allow NULL?
101	SZLCC04	Lot Category Code 04	String	UDC (44H2 04)	3	0	Allow NULL?
102	SZLCC05	Lot Category Code 05	String	UDC (44H2 05)	3	0	Allow NULL?
103	SZLCC06	Lot Category Code 06	String	UDC (44H2 06)	3	0	Allow NULL?
104	SZLCC07	Lot Category Code 07	String	UDC (44H2 07)	3	0	Allow NULL?
105	SZLCC08	Lot Category Code 08	String	UDC (44H2 08)	3	0	Allow NULL?
106	SZLCC09	Lot Category Code 09	String	UDC (44H2 09)	3	0	Allow NULL?
107	SZLCC10	Lot Category Code 10	String	UDC (44H2 10)	3	0	Allow NULL?
108	SZACCL	Accent Color	String	Generic Edit	15	0	Allow NULL?
109	SZCLRH	Color Hold	Character	Generic Edit	1	0	Allow NULL?
110	SZROF	Roof Tile	String	Generic Edit	15	0	Allow NULL?
111	SZBDC	Body Color	String	Generic Edit	15	0	Allow NULL?
112	SZFSC	Fascia Color	String	Generic Edit	15	0	Allow NULL?
113	SZCLPK	Color Package	String	Generic Edit	10	0	Allow NULL?
114	SZDOC01	Close Document (Order # Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
115	SZDOC02	Final Document (Order # Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
116	SZDOC03	Cost Document Number	Numeric	Generic Edit	8	0	Allow NULL?
117	SZDCT01	Close Document Type	String	UDC (00 DT)	2	0	Allow NULL?
118	SZDCT02	Final Document Type	String	UDC (00 DT)	2	0	Allow NULL?
119	SZDCT03	Cost Document Type	String	UDC (00 DT)	2	0	Allow NULL?
120	SZCDJ	Close Date (Julian)	Date	Generic Edit	6	0
121	SZSUB	Subsidiary	String	Generic Edit	8	0	Allow NULL?
122	SZCO	Company	String	Generic Edit	5	0	Allow NULL?
123	SZRLSN	Release	String	Generic Edit	3	0	Allow NULL?
124	SZHBST1	HomeBuilder Status Code 1	Character	Generic Edit	1	0	Allow NULL?
125	SZHBST2	HomeBuilder Status Code 2	Character	Generic Edit	1	0	Allow NULL?
126	SZHBST3	HomeBuilder Status Code 3	Character	Generic Edit	1	0	Allow NULL?
127	SZHBST4	HomeBuilder Status Code 4	Character	Generic Edit	1	0	Allow NULL?
128	SZHBST5	HomeBuilder Status Code 5	Character	Generic Edit	1	0	Allow NULL?
129	SZCRTU	Created by user	String	Generic Edit	10	0	Allow NULL?
130	SZCRTJ	Date - Created	Date	Generic Edit	6	0
131	SZCRTT	Time - Created	Numeric	Generic Edit	6	0	Allow NULL?
132	SZWRKSTNID	Original Work Station ID	String	Generic Edit	10	0	Allow NULL?
133	SZHBOPID	Original Program ID	String	Generic Edit	10	0	Allow NULL?
134	SZUPMB	Updated By - User	String	Generic Edit	10	0	Allow NULL?
135	SZUPMJ	Date - Updated	Date	Generic Edit	6	0
136	SZUPMT	Time - Last Updated	Numeric	Generic Edit	6	0	Allow NULL?
137	SZJOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
138	SZPID	Program ID	String	Generic Edit	10	0	Allow NULL?

TOP 812 | 44H | F44H201Z INDEXES

Number

Description

UserBatchTransNoLineNo (Primary/Unique)

Element	Alias	Description	Sequence
1	EDUS	EDI - User ID	Ascending
2	EDBT	EDI - Batch Number	Ascending
3	EDTN	EDI - Transaction Number	Ascending
4	EDLN	EDI - Line Number	Ascending

CommunityLot

Element	Alias	Description	Sequence
1	HBMCUS	Community	Ascending
2	HBLOT	Lot Number	Ascending

CommunityPlanElevation

Element	Alias	Description	Sequence
1	HBMCUS	Community	Ascending
2	HBPLAN	Plan Number	Ascending
3	HBELEV	Elevation	Ascending

CommunityLotSeqNo

Element	Alias	Description	Sequence
1	HBMCUS	Community	Ascending
2	HBLOT	Lot Number	Ascending
3	CSSEQ	Sequence - Current Sales	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

138 COLUMNS | 4 INDEXES | 812 | 44H | F44H201Z TABLE

TOP 812 | 44H | F44H201Z COLUMNS

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

138 COLUMNS | 4 INDEXES | 812 | 44H | F44H201Z TABLE

TOP812 | 44H | F44H201Z COLUMNS

TOP812 | 44H | F44H201Z INDEXES

TOP 812 | 44H | F44H201Z COLUMNS

TOP 812 | 44H | F44H201Z INDEXES