ERPRef.com

66 COLUMNS | 6 INDICIES 920 | 13 | F1207 Maintenance Schedule File

Schema	Name	Prefix	Columns	Indicies	Description	Type	Report	Category
920	F1207	FW	66	6	Maintenance Schedule File	Master Files	13: Plant/Equipment Management	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.

66 COLUMNS | TOP 920 | 13 | F1207 Maintenance Schedule File

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

6 INDICIES | TOP 920 | 13 | F1207 Maintenance Schedule File

1: UniqueKeyID (Primary/Unique)

Element	Alias	Description	Sequence
1	UKID	Unique Key ID (Internal)	Ascending

3: Unit No Maint Stat +A

Element	Alias	Description	Sequence
4	CPLD	Date - Completed Date	Descending
3	SRVT	Service Type	Ascending
2	MSTS	Maintenance Status	Ascending
1	APID	Unit or Tag Number	Ascending

4: Asset Item Main Stat +A

Element	Alias	Description	Sequence
4	CPLD	Date - Completed Date	Descending
3	SRVT	Service Type	Ascending
2	MSTS	Maintenance Status	Ascending
1	NUMB	Asset Item Number	Ascending

5: AssetNumber Sevice Type

Element	Alias	Description	Sequence
2	SRVT	Service Type	Ascending
1	NUMB	Asset Item Number	Ascending

6: AssetItem Service Type +Date

Element	Alias	Description	Sequence
3	CPLD	Date - Completed Date	Descending
2	SRVT	Service Type	Ascending
1	NUMB	Asset Item Number	Ascending

7: AssignedWO AssetNumber

Element	Alias	Description	Sequence
2	NUMB	Asset Item Number	Ascending
1	WONA	Work Order Number Assigned	Ascending