FA01100 - FA-AP Post Master | Prospr - Dynamics GP Table Reference

FA01100 - FA-AP Post Master

Query Builder

Select * from FA01100

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
FA_AP_Post_Index	FA AP Post Index	Long Integer	4	View
MARKED	Marked	Boolean	2	View
FAPRIMARY	Primary	Integer	2	View
CNTRLTYP	Control Type	Integer	2	View
APPLDAMT	Applied Amount	Currency	10	View
ORAPPAMT	Originating Applied Amount	Currency	10	View
Purchased_Quantity	Purchased Quantity	Long Integer	4	View
Applied_Quantity	Applied Quantity	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
Orig_Acquisition_Cost	Originating Acquisition Cost	Currency	10	View
ASSETTYPE	Asset Type	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
VENDORID	Vendor ID	String	16	View
DOCNUMBR	Document Number	String	22	View
DOCDATE	Document Date	Date	4	View
TRXSORCE	TRX Source	String	14	View
ORCTRNUM	Originating Control Number	String	22	View
PORDNMBR	Purchase Order Number	String	22	View
PO_Line	PO Line	String	8	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
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
CURNCYID	Currency ID	String	16	View
CURRNIDX	Currency Index	Integer	2	View
XCHGRATE	Exchange Rate	Currency (Variable)	10	View
EXCHDATE	Exchange Date	Date	4	View
TIME1	Time	Time	4	View
EXGTBLID	Exchange Table ID	String	16	View
RATETPID	Rate Type ID	String	16	View
RTCLCMTD	Rate Calculation Method	Integer	2	View
DENXRATE	Denomination Exchange Rate	Currency (Variable)	10	View
MCTRXSTT	MC Transaction State 0 = Euro currency is not created or no denomination currencies are enabled. 1 = Originating is not a denomination; Functional is not a denomination 2 = Originating is not a denomination; Functional is the Euro currency. 3 = Originating is not a denomination; Functional is a denomination. 4 = Originating is a denomination; Functional is not a denomination. 5 = Originating is a denomination; Functional is a denomination. 6 = Originating is a denomination; Functional is the Euro currency. 7 = Originating is the Euro currency; Functional is a denomination. 8 = Originating is the Euro currency; Functional is not a denomination.	Integer	2	View
LASTMNTDDATE	Last Maintained Date	Date	4	View
LASTMNTDTIME	Last Maintained Time	Time	4	View
LASTMNTDUSERID	Last Maintained User ID	String	16	View

FA01100 - FA-AP Post Master

Query Builder

Customer Service

Information

My Account

Contact Us