FA10200 - Select Assets Master | Prospr - Dynamics GP Table Reference

FA10200 - Select Assets Master

Query Builder

Select * from FA10200

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
USERID	User ID	String	16	View
GROUPNAME	Group Name	String	16	View
ASSETINDEX	Asset Index	Long Integer	4	View
ASSETID	Asset ID	String	16	View
ASSETIDSUF	Asset ID Suffix	Integer	2	View
ASSETDESC	Asset Description	String	42	View
ASSETCLASSID	Asset Class ID	String	16	View
LOCATNID	Location ID	String	16	View
STRUCTUREID	Structure ID	String	32	View
ASSETSTATUS	Asset Status	Integer	2	View
Asset_Label	Asset Label	String	20	View
Physical_Location_ID	Physical Location ID	String	16	View