Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/SVC00020
Product: FieldService (949)
Series:
Display Name: SVC_Fiscal_Period
Physical Name: SVC00020
Technical Name: SVC_Fiscal_PeriodSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 UserID 
SVC User ID String STR30 30 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['SVC_Fiscal_Period'].UserID AS 'SVC_Fiscal_Period-SVC User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
SVC00020 AS ['SVC_Fiscal_Period']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['SVC_Fiscal_Period'].UserID = ['Users Master'].USERID2 period_id SVC period id Integer INT2 2 3 start_date SVC start date Date DT 8 4 end_date SVC end date Date DT 8 5 period_name SVC period name String STR20 20 6 fiscal_year SVC fiscal year Integer INT2 2