Payroll Address Master (UPR00102)

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

Product: Microsoft Dynamics GP (0)
Series: Payroll

Display Name: Payroll Address Master
Physical Name: UPR00102
Technical Name: uprMstrAddress

Group Display Name: Payroll Employee Master
Group Technical Name: Payroll Employee Master

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1EMPLOYID SearchEmployee IDStringSTR15_Employee_ID15
2ADRSCODE SearchAddress CodeStringSTR15_Address_Code15
3ADDRESS1 SearchAddress 1StringSTR6060
4ADDRESS2 SearchAddress 2StringSTR6060
5ADDRESS3 SearchAddress 3StringSTR6060
6CITY SearchCityStringSTR3535
7STATE SearchStateStringSTR30_State29
8ZIPCODE SearchZip CodeStringSTR1010
9COUNTY SearchCountyStringSTR6060
10COUNTRY SearchCountryStringSTR6060
11PHONE1 SearchPhone 1StringPhone_Number14
12PHONE2 SearchPhone 2StringPhone_Number14
13PHONE3 SearchPhone 3StringPhone_Number314
14FAX SearchFaxStringSTR14_FAX14
15Foreign_Address SearchForeign AddressBooleanCB_Foreign_Address0
16Foreign_StateProvince SearchForeign State/ProvinceStringSTR2323
17Foreign_Postal_Code SearchForeign Postal CodeStringSTR15_LBAU15
18CCode SearchCountry CodeStringSTR6_VAT6
Key to the VAT Country Code MSTR (VAT10001).

Click to show/hide

SELECT
       ['Payroll Address Master'].CCode AS 'Payroll Address Master-Country Code'
       ,['VAT Country Code MSTR'].CCode AS 'VAT Country Code MSTR-Country Code'
FROM
       UPR00102 AS ['Payroll Address Master']
INNER JOIN
       VAT10001 AS ['VAT Country Code MSTR']
              ON
                     ['Payroll Address Master'].CCode = ['VAT Country Code MSTR'].CCode

Leave a Reply

Your email address will not be published. Required fields are marked *