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

COMPANY..UPR10210 Table Definition

(COMPANY..Payroll Build Check Defaults)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
BLDCHDID char(15)
''

DSCRIPTN char(31)
''

COMPPYRN smallint
0

PYRNSTDT datetime
'1/1/1900'

PYRNENDT datetime
'1/1/1900'

EMPCLRNG smallint
0

STTEMPCL char(15)
''

ENEMPCLS char(15)
''

EMPIDRNG smallint
0

STTEMPID char(15)
''

ENDEMPL char(15)
''

PYRNIWLY tinyint
0

PYRNIBWK tinyint
0

PRNISMLY tinyint
0

PYRNIMLY tinyint
0

PYRNIQLY tinyint
0

PYRNISAN tinyint
0

PYRNIANN tinyint
0

PYRNIDMS tinyint
0

PYRNISRY tinyint
0

PYRNIPSN tinyint
0

PYRNIEIC tinyint
0

DAYSWRDK int
0

WKSWRKD int
0

PYRNIPTP smallint
0

PYRNIDED smallint
0

PYRNIBFT smallint
0

NOTEINDX numeric(19,5)
0.00
Note Index...(more) Join Now
join ... more text available
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