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

COMPANY..UPR00221 Table Definition

(COMPANY..uprTimecardTemplateTrxDtl)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
EMPLOYID char
''
Employee I...(more) Join Now PA11801.EMPLOYID
join ... more text available
SEQNUMBR int
0
Sequence N...(more) Join Now HR2EMP02.SEQNUMBR
DayOfWeek smallint
0

DEPRTMNT char
''
Department...(more) Join Now WC010931.DEPRTMNT
join ... more text available
JOBTITLE char
''

STATECD char
''
State Code...(more) Join Now PA11801.STATECD
LOCALTAX char
''

SHFTCODE char
''
Shift Code...(more) Join Now
DAYSWRDK int
0

WKSWRKD int
0

DEX_ROW_ID int
auto number (1,1)
Unique ide...(more) Join Now
CMMTTEXT text


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