SVC_Site_Ext (SVC00953)

azurecurve Products FieldService (949)ProjectSVC_Site_Ext (SVC00953)

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

Product: FieldService (949)
Series:

Display Name: SVC_Site_Ext
Physical Name: SVC00953
Technical Name: SVC_Site_Ext

Group Display Name: Service Table Group
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/hide SELECT ['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

Seq No

Physical Name

Display Name

Dexterity Data Type

SQL Data Type

Length

LOCNCODE

Location Code

String

STR10_Location_Code

Key to the Site Setup (IV40700).

Click to show/hide

SELECT
       ['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

TIMEZONE

TimeZone

String

STR3_LBU

azurecurve Products FieldService (949)ProjectSVC_Site_Ext (SVC00953)

Click to show/hide

Leave a Reply Cancel reply