FA01300 - PO Additional Information Master | Prospr

FA01300 - PO Additional Information Master

Select * from FA01300

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
POPRCTNM	POP Receipt Number	String	18	View
RCPTLNNM	Receipt Line Number	Long Integer	4	View
ASSETID	Asset ID	String	16	View
ASSETIDSUF	Asset ID Suffix	Integer	2	View
SHRTNAME	Short Name	String	16	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
ASSETTYPE	Asset Type	Integer	2	View
PROPTYPE	Property Type	Integer	2	View
Create_Multiple_Fixed_As	Create Multiple Fixed Assets	Boolean	2	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
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
LASTMNTDDATE	Last Maintained Date	Date	4	View
LASTMNTDTIME	Last Maintained Time	Time	4	View
LASTMNTDUSERID	Last Maintained User ID	String	16	View