SVC_Vendor_Ext (SVC00106)

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

Display Name: SVC_Vendor_Ext
Physical Name: SVC00106
Technical Name: SVC_Vendor_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	VENDORID	Vendor ID	String	STR_15_Vendor_ID	15
	Key to the PM Vendor Master File (PM00200). Click to show/hide SELECT ['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/hide SELECT ['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