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

COMPANY..UPR10200 Table Definition

(COMPANY..Payroll Work Master)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
USERID char(15)
''
The user t...(more) Join Now
join ... more text available
AUCTRLCD char(13)
''

BLDCHDID char(15)
''

BLDCHKDT datetime
'1/1/1900'

BLDCHTIM datetime
'1/1/1900'

PYRNTYPE smallint
0

COMPPYRN smallint
0

EMPCLRNG smallint
0

STTEMPCL char(15)
''

ENEMPCLS char(15)
''

EMPIDRNG smallint
0

STTEMPID char(15)
''

ENDEMPL char(15)
''

PYRNSTDT datetime
'1/1/1900'

PYRNENDT datetime
'1/1/1900'

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

PYRNIPTP smallint
0

PYRNIDED smallint
0

PYRNIBFT smallint
0

DAYSWRDK int
0

WKSWRKD int
0

BLCHWREX tinyint
0

BDCHEREX tinyint
0

PRCHKPTD tinyint
0

PYRLCHPS tinyint
0

CHEKDATE datetime
'1/1/1900'
Check Date...(more) Join Now PM10000.CHEKDATE
POSTEDDT datetime
'1/1/1900'
Posted Dat...(more) Join Now RM10301.POSTEDDT
NUMOFTRX int
0
Number Of ...(more) Join Now SY00500.NUMOFTRX
NUMOFEMP smallint
0

CNTRLTRX int
0
Control TR...(more) Join Now SY00500.CNTRLTRX
CTRLEMPCT smallint
0

APPROVL tinyint
0
Approval: ...(more) Join Now SY00500.APPROVL
APPRVLDT datetime
'1/1/1900'
Approval D...(more) Join Now SY00500.APPRVLDT
APRVLUSERID char(15)
''
Approval U...(more) Join Now SY00500.APRVLUSERID
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