FA00100 - Asset General Information Master

Dynamics GP table FA00100 (Asset General Information Master) contains 39 columns including ASSETINDEX, ASSETID, ASSETIDSUF....

SQL Query Builder

SELECT * FROM FA00100

Select all

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