Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/UPRA0102
Product: Human Resources (414)
Series:
Display Name: Payroll Address Master - Archive
Physical Name: UPRA0102
Technical Name: Archive_uprMstrAddressSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 EMPLOYID Employee ID String STR15_Employee_ID 15 2 ADRSCODE Address Code String STR15_Address_Code 15 3 ADDRESS1 Address 1 String STR60 60 4 ADDRESS2 Address 2 String STR60 60 5 ADDRESS3 Address 3 String STR60 60 6 CITY City String STR35 35 7 STATE State String STR30_State 29 8 ZIPCODE Zip Code String STR10 10 9 COUNTY County String STR60 60 10 COUNTRY Country String STR60 60 11 PHONE1 Phone 1 String Phone_Number 14 12 PHONE2 Phone 2 String Phone_Number 14 13 PHONE3 Phone 3 String Phone_Number3 14 14 FAX Fax String STR14_FAX 14 15 Foreign_Address Foreign Address Boolean CB_Foreign_Address 0 16 Foreign_StateProvince Foreign State/Province String STR23 23 17 Foreign_Postal_Code Foreign Postal Code String STR15_LBAU 15 18 CCode Country Code String STR6_VAT 6 Key to the VAT Country Code MSTR (VAT10001).
Click to show/hide
SELECT
['Payroll Address Master - Archive'].CCode AS 'Payroll Address Master - Archive-Country Code'
,['VAT Country Code MSTR'].CCode AS 'VAT Country Code MSTR-Country Code'
FROM
UPRA0102 AS ['Payroll Address Master - Archive']
INNER JOIN
VAT10001 AS ['VAT Country Code MSTR']
ON
['Payroll Address Master - Archive'].CCode = ['VAT Country Code MSTR'].CCode