Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/SVC00106
Product: FieldService (949)
Series:
Display Name: SVC_Vendor_Ext Group Display Name: Service Table Group
Physical Name: SVC00106
Technical Name: SVC_Vendor_Ext
Group Technical Name: Service
| Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
|---|---|---|---|---|---|---|
| 1 | VENDORID  | Vendor ID | String | STR_15_Vendor_ID | 15 | |
Key to the PM Vendor Master File (PM00200).
Click to show/hideSELECT
['SVC_Vendor_Ext'].VENDORID AS 'SVC_Vendor_Ext-Vendor ID'
,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
SVC00106 AS ['SVC_Vendor_Ext']
INNER JOIN
PM00200 AS ['PM Vendor Master File']
ON
['SVC_Vendor_Ext'].VENDORID = ['PM Vendor Master File'].VENDORID | ||||||
| 2 | ADRSCODE | Address Code | String | STR15_Address_Code | 15 | |
| 3 | LOCNCODE | Location Code | String | STR10_Location_Code | 10 | |
Key to the Site Setup (IV40700).
Click to show/hideSELECT
['SVC_Vendor_Ext'].LOCNCODE AS 'SVC_Vendor_Ext-Location Code'
,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code'
FROM
SVC00106 AS ['SVC_Vendor_Ext']
INNER JOIN
IV40700 AS ['Site Setup']
ON
['SVC_Vendor_Ext'].LOCNCODE = ['Site Setup'].LOCNCODE | ||||||
| 4 | RTV_Default_Ship_To_Loca | RTV Default Ship To Location | Boolean | CB | 0 | |