Module List > Module HR tables UPRA0102
You are currently viewing the COMPANY database.
Change

COMPANY..UPRA0102 Table Definition

(COMPANY..Payroll Address Master - Archive)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
EMPLOYID char(15)
''
Employee I...(more) Join Now
join ... more text available
ADRSCODE char(15)
''
Address Co...(more) Join Now
ADDRESS1 char(61)
''

ADDRESS2 char(61)
''

ADDRESS3 char(61)
''

CITY char(35)
''
City: City...(more) Join Now
STATE char(29)
''

ZIPCODE char(11)
''
Zip Code: ...(more) Join Now
COUNTY char(61)
''

COUNTRY char(61)
''

PHONE1 char(21)
''

PHONE2 char(21)
''

PHONE3 char(21)
''

FAX char(21)
''

Foreign_Address tinyint
0
Foreign Ad...(more) Join Now
Foreign_StateProvince char(23)
''
Foreign ...(more) Join Now
Foreign_Postal_Code char(15)
''
Foreign Po...(more) Join Now
CCode char(7)
''
Country Co...(more) Join Now
DEX_ROW_ID int
auto number (1,1)
Unique ide...(more) Join Now
Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3