	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

24 COLUMNS | 1 INDEXES | 920 | 44H | F44H712 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
44H: Homebuilder Management
1	920	F44H712	ST	24	1	Lot Start Workfile Takeoff Detail	Files	44H: Homebuilder Management

TOP 920 | 44H | F44H712 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	SQL Create Statement
1	STMCU	Business Unit	String	Generic Edit	12	Allow NULL?
2	STOBJ	Object Account	String	Generic Edit	6	Allow NULL?
3	STSUB	Subsidiary	String	Generic Edit	8	Allow NULL?
4	STOPTN	Option Number	String	Generic Edit	8	Allow NULL?
5	STAN8	Address Number	Numeric	Generic Edit	8	Allow NULL?
6	STLITM	2nd Item Number	String	Generic Edit	25	Allow NULL?
7	STSEQ	Sequence Number	Numeric	Generic Edit	6	Allow NULL?
8	STMCUS	Business Unit - Subsequent	String	Generic Edit	12	Allow NULL?
9	STCPHASE	Phase	String	Generic Edit	3	Allow NULL?
10	STPL	Plan Number	String	Generic Edit	4	Allow NULL?
11	STELEV	Elevation	String	Generic Edit	3	Allow NULL?
12	STSWG	Swing	Character	Generic Edit	1	Allow NULL?
13	STUORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	Allow NULL?
14	STMCUTJ	Cost Code Template	String	Generic Edit	12	Allow NULL?
15	STCRTU	Created by user	String	Generic Edit	10	Allow NULL?
16	STCRTJ	Date - Created	Date	Generic Edit	6
17	STCRTT	Time - Created	Numeric	Generic Edit	6	Allow NULL?
18	STWRKSTNID	Original Work Station ID	String	Generic Edit	10	Allow NULL?
19	STJPID	Program ID	String	Generic Edit	10	Allow NULL?
20	STUPMB	Updated By - User	String	Generic Edit	10	Allow NULL?
21	STUPMJ	Date - Updated	Date	Generic Edit	6
22	STUPMT	Time - Last Updated	Numeric	Generic Edit	6	Allow NULL?
23	STJOBN	Work Station ID	String	Generic Edit	10	Allow NULL?
24	STPID	Program ID	String	Generic Edit	10	Allow NULL?

Number

Description

MCU OBJ SUB OPTN AN8 LITM etc. (Primary/Unique)

Element	Alias	Description	Sequence
1	MCU	Business Unit	Ascending
2	OBJ	Object Account	Ascending
3	SUB	Subsidiary	Ascending
4	OPTN	Option Number	Ascending
5	AN8	Address Number	Ascending
6	LITM	2nd Item Number	Ascending
7	SEQ	Sequence Number	Ascending
8	MCUS	Business Unit - Subsequent	Ascending
9	CPHASE	Phase	Ascending
10	PL	Plan Number	Ascending
11	ELEV	Elevation	Ascending