ERPRef.com

106 COLUMNS | 13 INDICIES 920 | 12 | F1201 Asset Master File

Schema	Name	Prefix	Columns	Indicies	Description	Type	Report	Category
920	F1201	FA	106	13	Asset Master File	Master Files	12: Fixed Assets	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.

106 COLUMNS | TOP 920 | 12 | F1201 Asset Master File

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

13 INDICIES | TOP 920 | 12 | F1201 Asset Master File

1: Item Number (Primary/Unique)

Element	Alias	Description	Sequence
1	NUMB	Asset Item Number	Ascending

2: Unit Number

Element	Alias	Description	Sequence
1	APID	Unit or Tag Number	Ascending

3: Serial Number

Element	Alias	Description	Sequence
1	ASID	Serial Number	Ascending

4: MajorClass Subclass +A

Element	Alias	Description	Sequence
3	NUMB	Asset Item Number	Ascending
2	ACL2	Major Equipment Class	Ascending
1	ACL1	Major Accounting Class	Ascending

5: Parent No Sequence No +A

Element	Alias	Description	Sequence
3	NUMB	Asset Item Number	Ascending
2	SEQ	Sequence Number	Ascending
1	AAID	Parent Number	Ascending

6: Parent Number

Element	Alias	Description	Sequence
1	AAID	Parent Number	Ascending

7: compresseddescription +a

Element	Alias	Description	Sequence
2	NUMB	Asset Item Number	Ascending
1	DSCC	Description - Compressed	Ascending

8: business unit +a

Element	Alias	Description	Sequence
2	NUMB	Asset Item Number	Ascending
1	MCU	Business Unit	Ascending

9: location asset item number

Element	Alias	Description	Sequence
2	NUMB	Asset Item Number	Ascending
1	LOC	Business Unit - Location	Ascending

11: parent item number +a

Element	Alias	Description	Sequence
2	NUMB	Asset Item Number	Ascending
1	KIT	Parent (short) Item Number	Ascending

12: Parent Number Serial Number

Element	Alias	Description	Sequence
2	ASID	Serial Number	Ascending
1	AAID	Parent Number	Ascending

13: Majorclass Subclass +B

Element	Alias	Description	Sequence
10	ACL0	Category Code - F/A 10 (Rate Group)	Ascending
9	ACL9	Category Code - F/A 9	Ascending
8	ACL8	Category Code - F/A 8	Ascending
7	ACL7	Category Code - F/A 7	Ascending
6	ACL6	Category Code - F/A 6	Ascending
5	ACL5	Usage Miles or Hours	Ascending
4	ACL4	Model Year	Ascending
3	ACL3	Manufacturer	Ascending
2	ACL2	Major Equipment Class	Ascending
1	ACL1	Major Accounting Class	Ascending

14: Description

Element	Alias	Description	Sequence
1	DL01	Description	Ascending