Module List > Module UPR tables UPR00113
You are currently viewing the COMPANY database.
Change

COMPANY..UPR00113 Table Definition

(COMPANY..Payroll Master Contacts)

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
SEQNUMBR int
0
Sequence N...(more) Join Now DTA10200.SEQNUMBR
EMERGENCYCONTACT char(61)
''

EMERGENCYRELATION char(11)
''

ADDRESS1 char(61)
''

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

ZIPCODE char(11)
''
Zip Code: ...(more) Join Now
HOMEPHONE char(21)
''

WORKPHONE char(21)
''

EXTENSION char(5)
''

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