FA00902 - Asset Financial Detail Master | Prospr

FA00902 - Asset Financial Detail Master

Select * from FA00902

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
FINANCIALINDX	Financial Index	Long Integer	4	View
ASSETINDEX	Asset Index	Long Integer	4	View
BOOKINDX	Book Index	Long Integer	4	View
FA_Doc_Number	FA Document Number	String	18	View
TRANSDATESTAMP	Transaction Date Stamp	Date	4	View
TRANSTIMESTAMP	Transaction Time Stamp	Time	4	View
FISCALYRADDED	Fiscal Year Added	Integer	2	View
FAYEAR	FA Year	Integer	2	View
FAPERIOD	FA Period	Integer	2	View
DEPRFROMDATE	Depreciation from Date	Date	4	View
DEPRTODATE	Depreciated to Date	Date	4	View
AMOUNT	Amount	Currency	10	View
TRANSUSERID	Transaction User ID	String	16	View
SOURCDOC	Source Document 1= Invoice 2= Finance Charge 3= Miscellaneous Charges 4= Return 5= Credit Memo	String	12	View
TRANSACCTTYPE	Transaction Account Type	Integer	2	View
INTERFACEGL	Interface to GL	Boolean	2	View
GLINTTRXDATE	GL Interface TRX Date	Date	4	View
GLINTDATESTAMP	GL Interface Date Stamp	Date	4	View
GLINTTIMESTAMP	GL Interface Time Stamp	Time	4	View
GLINTACCTINDX	GL Interface Account Index	Long Integer	4	View
GLINTBTCHNUM	GL Interface Batch Number	String	16	View
FA_Reset_Offset_Index	FA Reset Offset Index	Long Integer	4	View
FA_Reset_User_ID	FA Reset User ID	String	16	View
FA_Reset_Date	FA Reset Date	Date	4	View
FA_Reset_Time	FA Reset Time	Time	4	View
Ledger_ID	Ledger ID	Integer	2	View
REFRENCE	Reference	String	32	View