Book Setup (FA40200)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/FA40200

Display Name: Book Setup
Physical Name: FA40200
Technical Name: FA_Book_SETP

Group Display Name: Fixed Assets Setup
Group Technical Name: Fixed Assets Setup

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	BOOKINDX	Book Index	Long Integer	LI_14	14
2	BOOKID	Book ID	String	STR15_Book_ID	15
3	BOOKDESC	Book Description	String	STR30_Book_Description	30
4	DEPRPERIOD	Depreciation Period	Integer	DDL_Depreciation_Period	0
5	CURRFISCALYR	Current Fiscal Year	Integer	Year	4
6	YEAR1	Year	Integer	Year	4
7	Auto_Add_Book_Info	Auto Add Book Info	Boolean	CB_Auto_Add_Book_Info	0
8	NOTEINDX	Note Index	Currency	DLR14	14
	Key to the Record Notes Master (SY03900). Click to show/hide SELECT ['Book Setup'].NOTEINDX AS 'Book Setup-Note Index' ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index' FROM FA40200 AS ['Book Setup'] INNER JOIN SY03900 AS ['Record Notes Master'] ON ['Book Setup'].NOTEINDX = ['Record Notes Master'].NOTEINDX
9	LASTMNTDDATE	Last Maintained Date	Date	DT	8
10	LASTMNTDTIME	Last Maintained Time	Time	TM6	6
11	LASTMNTDUSERID	Last Maintained User ID	String	User_ID	15
	Key to the Users Master (SY01400). Click to show/hide SELECT ['Book Setup'].LASTMNTDUSERID AS 'Book Setup-Last Maintained User ID' ,['Users Master'].USERID AS 'Users Master-User ID' FROM FA40200 AS ['Book Setup'] INNER JOIN DYNAMICS..SY01400 AS ['Users Master'] ON ['Book Setup'].LASTMNTDUSERID = ['Users Master'].USERID
12	PTGENLED	Post to General Ledger	Boolean	CB_Post_To_GL	0
13	Ledger_ID	Ledger ID	Integer	INT2	2
14	CALNDRID	Calendar_ID	String	STR15_LBAU	15