SVC_Misc_Address (SVC00980)

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

Display Name: SVC_Misc_Address
Physical Name: SVC00980
Technical Name: SVC_Misc_Address

Group Display Name: Service Table Group
Group Technical Name: Service

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	SVC_Misc_Address_Code	SVC_Misc_Address_Code	String	STR15_Address_Code	15
2	DSCRIPTN	Description	String	STR30	30
3	ADDRESS1	Address 1	String	STR60	60
4	ADDRESS2	Address 2	String	STR60	60
5	CITY	City	String	STR35	35
6	STATE	State	String	STR30_State	29
7	ZIP	Zip	String	STR10	10
8	COUNTRY	Country	String	STR60	60
9	SHIPMTHD	Shipping Method	String	STR15_Shipping_Method	15
	Key to the Shipping Methods Master (SY03000). Click to show/hide SELECT ['SVC_Misc_Address'].SHIPMTHD AS 'SVC_Misc_Address-Shipping Method' ,['Shipping Methods Master'].SHIPMTHD AS 'Shipping Methods Master-Shipping Method' FROM SVC00980 AS ['SVC_Misc_Address'] INNER JOIN SY03000 AS ['Shipping Methods Master'] ON ['SVC_Misc_Address'].SHIPMTHD = ['Shipping Methods Master'].SHIPMTHD
10	NAME	Name	String	STR30	30
11	ADDRESS3	Address 3	String	STR60	60
12	TAXSCHID	Tax Schedule ID	String	STR15_Tax_Schedule_ID	15
	Key to the Sales/Purchases Tax Schedule Header Master (TX00101). Click to show/hide SELECT ['SVC_Misc_Address'].TAXSCHID AS 'SVC_Misc_Address-Tax Schedule ID' ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID' FROM SVC00980 AS ['SVC_Misc_Address'] INNER JOIN TX00101 AS ['Sales/Purchases Tax Schedule Header Master'] ON ['SVC_Misc_Address'].TAXSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID