	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	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

25 COLUMNS | 2 INDEXES | 920 | 44H | F44H602W TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
44H: Homebuilder Management
1	920	F44H602W	TS	25	2	Take Off Summary Workfile	Work Files	44H: Homebuilder Management

TOP 920 | 44H | F44H602W COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	SQL Create Statement
1	TSJOBS	Job Number	Numeric	Generic Edit	8	Allow NULL?
2	TSHBAREA	HomeBuilder Area ID	String	UDC (00 05)	3	Allow NULL?
3	TSHBPLAN	Plan Number	String	Generic Edit	4	Allow NULL?
4	TSHBMCUS	Community	String	Generic Edit	12	Allow NULL?
5	TSCPHASE	Phase	String	Generic Edit	3	Allow NULL?
6	TSHBELEV	Elevation	String	Generic Edit	3	Allow NULL?
7	TSSWING	Swing	Character	UDC (44H2 SW)	1	Allow NULL?
8	TSSUB	Subsidiary	String	Generic Edit	8	Allow NULL?
9	TSOBJ	Object Account	String	Generic Edit	6	Allow NULL?
10	TSOPTION	Option Number	String	Generic Edit	8	Allow NULL?
11	TSITM	Item Number - Short	Numeric	Generic Edit	8	Allow NULL?
12	TSETF	Estimated Takeoff Flag	Character	Generic Edit	1	Allow NULL?
13	TSSUBITEM	Substitute Item Number	String	Generic Edit	25	Allow NULL?
14	TSLITM	2nd Item Number	String	Generic Edit	25	Allow NULL?
15	TSAITM	3rd Item Number	String	Generic Edit	25	Allow NULL?
16	TSUORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	Allow NULL?
17	TSUOM	Unit of Measure as Input	String	UDC (00 UM)	2	Allow NULL?
18	TSUSER	User ID	String	Generic Edit	10	Allow NULL?
19	TSUPMJ	Date - Updated	Date	Generic Edit	6
20	TSUPMT	Time - Last Updated	Numeric	Generic Edit	6	Allow NULL?
21	TSHBST1	HomeBuilder Status Code 1	Character	Generic Edit	1	Allow NULL?
22	TSHBST2	HomeBuilder Status Code 2	Character	Generic Edit	1	Allow NULL?
23	TSHBST3	HomeBuilder Status Code 3	Character	Generic Edit	1	Allow NULL?
24	TSHBST4	HomeBuilder Status Code 4	Character	Generic Edit	1	Allow NULL?
25	TSHBST5	HomeBuilder Status Code 5	Character	Generic Edit	1	Allow NULL?

Number

Description

JOBS HBAREA HBPLAN HBMCUS + (Primary/Unique)

Element	Alias	Description	Sequence
1	JOBS	Job Number	Ascending
2	HBAREA	HomeBuilder Area ID	Ascending
3	HBPLAN	Plan Number	Ascending
4	HBMCUS	Community	Ascending
5	CPHASE	Phase	Ascending
6	HBELEV	Elevation	Ascending
7	SWING	Swing	Ascending
8	OPTION	Option Number	Ascending
9	SUB	Subsidiary	Ascending
10	OBJ	Object Account	Ascending
11	ITM	Item Number - Short	Ascending
12	ETF	Estimated Takeoff Flag	Ascending
13	SUBITEM	Substitute Item Number	Ascending

LITM JOBS HBAREA HBMCUS +

Element	Alias	Description	Sequence
1	LITM	2nd Item Number	Ascending
2	JOBS	Job Number	Ascending
3	HBAREA	HomeBuilder Area ID	Ascending
4	HBMCUS	Community	Ascending
5	CPHASE	Phase	Ascending
6	HBPLAN	Plan Number	Ascending
7	HBELEV	Elevation	Ascending
8	SWING	Swing	Ascending
9	SUB	Subsidiary	Ascending
10	OBJ	Object Account	Ascending
11	OPTION	Option Number	Ascending