Fixed Assets Batch Headers (FA15000)

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

Display Name: Fixed Assets Batch Headers
Physical Name: FA15000
Technical Name: FA_Batch_Headers

Group Display Name: Fixed Assets Master
Group Technical Name: Fixed Assets Master

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	GLINTBTCHNUM	GL Interface Batch Number	String	STR15_LBAU	15
2	POSTED	Posted	Boolean	True/False	0
3	GLINTTRXDATE	GL Interface TRX Date	Date	DT	8
4	GL_Interface_Comment	GL Interface Comment	String	STR30_GL_Interface_Comment	30
5	GL_Intf_Begin_Period	GL Interface Begin Period	Integer	INT3	3
6	GL_Interface_Begin_Year	GL Interface Begin Year	Integer	Year	4
7	GL_Interface_End_Period	GL Interface End Period	Integer	INT3	3
8	GL_Interface_End_Year	GL Interface End Year	Integer	Year	4
9	SSRCEDOC	Start Source Document	String	STR10_Source_Document	10
10	ENDSRCDC	End Source Document	String	STR10_Source_Document	10
11	Start_Asset_ID	Start Asset ID	String	STR15_Asset_ID	15
12	End_Asset_ID	End Asset ID	String	STR15_Asset_ID	15
13	Start_Asset_ID_Suffix	Start Asset ID Suffix	Integer	INT3_U0	3
14	End_Asset_ID_Suffix	End Asset ID Suffix	Integer	INT3_U0	3
15	STTCLSID	Start Class ID	String	STR15_LBAU	15
16	ENDCLSID	End Class ID	String	STR15_LBAU	15
17	BOOKINDX	Book Index	Long Integer	LI_14	14
18	JRNENTRY	Journal Entry	Long Integer	LI8_U0	8
19	DEBITAMT	Debit Amount	Currency	DLR19_$S2	19
20	CRDTAMNT	Credit Amount	Currency	DLR19_$S2	19
21	USERID	User ID	String	STR15_User_ID	15
	Key to the Users Master (SY01400). Click to show/hide SELECT ['Fixed Assets Batch Headers'].USERID AS 'Fixed Assets Batch Headers-User ID' ,['Users Master'].USERID AS 'Users Master-User ID' FROM FA15000 AS ['Fixed Assets Batch Headers'] INNER JOIN DYNAMICS..SY01400 AS ['Users Master'] ON ['Fixed Assets Batch Headers'].USERID = ['Users Master'].USERID