Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/SVC00953
Product: FieldService (949)
Series:
Display Name: SVC_Site_Ext Group Display Name: Service Table Group
Physical Name: SVC00953
Technical Name: SVC_Site_Ext
Group Technical Name: Service
| Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
|---|---|---|---|---|---|---|
| 1 | LOCNCODE  | Location Code | String | STR10_Location_Code | 10 | |
Key to the Site Setup (IV40700).
Click to show/hideSELECT
['SVC_Site_Ext'].LOCNCODE AS 'SVC_Site_Ext-Location Code'
,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code'
FROM
SVC00953 AS ['SVC_Site_Ext']
INNER JOIN
IV40700 AS ['Site Setup']
ON
['SVC_Site_Ext'].LOCNCODE = ['Site Setup'].LOCNCODE | ||||||
| 2 | TIMEZONE | TimeZone | String | STR3_LBU | 3 | |