Location ID Setup (FA41100)

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

Display Name: Location ID Setup
Physical Name: FA41100
Technical Name: FA_Location_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	LOCATIONINDX	Location Index	Long Integer	LI_14	14
2	LOCATNID	Location ID	String	STR15_Location_ID	15
3	STATEDESCR	State Description	String	STR30_State_Description	30
4	COUNTYDESCR	County Description	String	STR30_County_Description	30
5	CITYDESCR	City Description	String	STR30_City_Description	30
6	STATEABBREV	State Abbreviation	String	STR2_State_Abbreviation	2
7	STATECD	State Code	String	STR2_State_Code	2
8	COUNTYCODE	County Code	String	STR3_County_Code	3
9	CITYCODE	City Code	String	STR4_City_Code	4
10	NOTEINDX	Note Index	Currency	DLR14	14
	Key to the Record Notes Master (SY03900). Click to show/hide SELECT ['Location ID Setup'].NOTEINDX AS 'Location ID Setup-Note Index' ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index' FROM FA41100 AS ['Location ID Setup'] INNER JOIN SY03900 AS ['Record Notes Master'] ON ['Location ID Setup'].NOTEINDX = ['Record Notes Master'].NOTEINDX
11	LASTMNTDDATE	Last Maintained Date	Date	DT	8
12	LASTMNTDTIME	Last Maintained Time	Time	TM6	6
13	LASTMNTDUSERID	Last Maintained User ID	String	User_ID	15
	Key to the Users Master (SY01400). Click to show/hide SELECT ['Location ID Setup'].LASTMNTDUSERID AS 'Location ID Setup-Last Maintained User ID' ,['Users Master'].USERID AS 'Users Master-User ID' FROM FA41100 AS ['Location ID Setup'] INNER JOIN DYNAMICS..SY01400 AS ['Users Master'] ON ['Location ID Setup'].LASTMNTDUSERID = ['Users Master'].USERID