FA00100 - Asset General Information Master | Prospr

FA00100 - Asset General Information Master

Query Builder

Select * from FA00100

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
ASSETINDEX	Asset Index	Long Integer	4	View
ASSETID	Asset ID	String	16	View
ASSETIDSUF	Asset ID Suffix	Integer	2	View
SHRTNAME	Short Name	String	16	View
ASSETDESC	Asset Description	String	42	View
EXTASSETDESC	Extended Asset Description	String	42	View
Master_Asset_ID	Master Asset ID	String	20	View
STRUCTUREID	Structure ID	String	32	View
ASSETCLASSID	Asset Class ID	String	16	View
LOCATNID	Location ID	String	16	View
ACQDATE	Acquisition Date	Date	4	View
Acquisition_Cost	Acquisition Cost	Currency	10	View
ASSETTYPE	Asset Type	Integer	2	View
ASSETSTATUS	Asset Status	Integer	2	View
PROPTYPE	Property Type	Integer	2	View
ASSETQTY	Asset Quantity	Long Integer	4	View
ASSETBEGQTY	Asset Begin Quantity	Long Integer	4	View
ASSETCURRMAINT	Current Maintenance Amount	Currency	10	View
ASSETYTDMAINT	YTD Maintenance Amount	Currency	10	View
ASSETLTDMAINT	LTD Maintenance Amount	Currency	10	View
LASTMAINTDATE	Last Maintenance Date	Date	4	View
ASSESSEDVALUE	Assessed Value	Currency	10	View
MFGRNAME	Manufacturer Name	String	26	View
SERLNMBR	Serial Number	String	22	View
MODELNUMBER	Model Number	String	22	View
WARRENTYDATE	Warranty Date	Date	4	View
CUSTODIAN	Custodian	String	26	View
NOTEINDX	Note Index	Currency	10	View
DATEADDED	Date Added	Date	4	View
DELETEDATE	Delete Date	Date	4	View
Physical_Location_ID	Physical Location ID	String	16	View
Asset_Label	Asset Label	String	20	View
Verified_Date	Verified Date	Date	4	View
PIN	PIN	String	16	View
LASTPURCHLINESEQ	Last Purchase Line Sequence	Long Integer	4	View
LASTMNTDDATE	Last Maintained Date	Date	4	View
LASTMNTDTIME	Last Maintained Time	Time	4	View
LASTMNTDUSERID	Last Maintained User ID	String	16	View
aaAliasID	aaAliasID	Long Integer	4	View

FA00100 - Asset General Information Master

Query Builder

Customer Service

Information

My Account

Contact Us