Select Assets Master (FA10200)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/FA10200

Display Name: Select Assets Master
Physical Name: FA10200
Technical Name: FA_Select_Assets_MSTR

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	USERID	User ID	String	STR15_User_ID	15
	Key to the Users Master (SY01400). Click to show/hide SELECT ['Select Assets Master'].USERID AS 'Select Assets Master-User ID' ,['Users Master'].USERID AS 'Users Master-User ID' FROM FA10200 AS ['Select Assets Master'] INNER JOIN DYNAMICS..SY01400 AS ['Users Master'] ON ['Select Assets Master'].USERID = ['Users Master'].USERID
2	GROUPNAME	Group Name	String	STR15_Group_Name	15
3	ASSETINDEX	Asset Index	Long Integer	LI9_Asset_Index	9
	Key to the Asset General Information Master (FA00100). Click to show/hide SELECT ['Select Assets Master'].ASSETINDEX AS 'Select Assets Master-Asset Index' ,['Asset General Information Master'].ASSETINDEX AS 'Asset General Information Master-Asset Index' FROM FA10200 AS ['Select Assets Master'] INNER JOIN FA00100 AS ['Asset General Information Master'] ON ['Select Assets Master'].ASSETINDEX = ['Asset General Information Master'].ASSETINDEX
4	ASSETID	Asset ID	String	STR15_Asset_ID	15
5	ASSETIDSUF	Asset ID Suffix	Integer	INT3_U0	3
6	ASSETDESC	Asset Description	String	STR40_Asset_Description	40
7	ASSETCLASSID	Asset Class ID	String	STR15_Asset_Class_ID	15
8	LOCATNID	Location ID	String	STR15_Location_ID	15
9	STRUCTUREID	Structure ID	String	STR30_Structure_ID	30
10	ASSETSTATUS	Asset Status	Integer	VS_Asset_Status	0
11	Asset_Label	Asset Label	String	STR19_Asset_Label	19
12	Physical_Location_ID	Physical Location ID	String	STR15_Physical_Location_ID	15