ERPRef.com

32 COLUMNS | 3 INDICIES 920 | 15L | F15L141 AREF Gross Lease Occupied Area

Schema	Name	Prefix	Columns	Indicies	Description	Type	Report	Category
920	F15L141	GL	32	3	AREF Gross Lease Occupied Area	Files	15L: Adv Real Estate Forecasting	Business Data

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.

32 COLUMNS | TOP 920 | 15L | F15L141 AREF Gross Lease Occupied Area

	Col#	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement

3 INDICIES | TOP 920 | 15L | F15L141 AREF Gross Lease Occupied Area

1: Property Building Rev Unit (Primary/Unique)

Element	Alias	Description	Sequence
8	ARDEFID	Area Definition ID	Ascending
7	GLMD	Area Calculation Method	Ascending
6	MT	Calendar Month	Ascending
5	CENTYR	Century/Year	Ascending
4	UNIT	Unit	Ascending
3	RVNB	Revision Number	Ascending
2	MCU	Business Unit	Ascending
1	MCUS	Business Unit - Subsequent	Ascending

2: Property Rev Unit

Element	Alias	Description	Sequence
7	ARDEFID	Area Definition ID	Ascending
6	GLMD	Area Calculation Method	Ascending
5	MT	Calendar Month	Ascending
4	CENTYR	Century/Year	Ascending
3	UNIT	Unit	Ascending
2	RVNB	Revision Number	Ascending
1	MCUS	Business Unit - Subsequent	Ascending

3: Building Rev Unit

Element	Alias	Description	Sequence
7	ARDEFID	Area Definition ID	Ascending
6	GLMD	Area Calculation Method	Ascending
5	MT	Calendar Month	Ascending
4	CENTYR	Century/Year	Ascending
3	UNIT	Unit	Ascending
2	RVNB	Revision Number	Ascending
1	MCU	Business Unit	Ascending