Module List >
Module UPR tables
UPR10203
You are currently viewing the COMPANY
database.
Change
|
COMPANY..UPR10203 Table Definition
(COMPANY..Payroll Work Pay Code)
Field Definitions:
What is the 'source' column?
| USERID |
char(15)
''
|
The user t...(more) Join Now
|
|
|
join ... more text available
|
| PYRNTYPE |
smallint
0
|
|
|
|
|
| EMPLOYID |
char(15)
''
|
Employee I...(more) Join Now
|
|
|
join ... more text available
|
| TRXNUMBER |
int
0
|
|
|
|
|
| PAYRCORD |
char(7)
''
|
Pay Record...(more) Join Now
|
|
|
|
| PRCSSQNC |
smallint
0
|
|
|
|
|
| PAYTYPE |
smallint
0
|
Pay Type: ...(more) Join Now
|
|
|
|
| BSPAYRCD |
char(7)
''
|
Base Pay R...(more) Join Now
|
|
|
|
| BSPAYTYP |
smallint
0
|
|
|
|
|
| BSDONRTE |
numeric(19,5)
0.00
|
|
|
|
|
| PAYRTAMT |
numeric(19,5)
0.00
|
Pay Rate A...(more) Join Now
|
|
|
|
| PAYUNIT |
char(25)
''
|
Pay Unit: ...(more) Join Now
|
|
|
|
| PAYUNPER |
smallint
0
|
Pay Unit P...(more) Join Now
|
|
|
|
| PAYPEROD |
smallint
0
|
|
|
|
|
| PAYPRPRD |
numeric(19,5)
0.00
|
Pay Per Pe...(more) Join Now
|
|
|
|
| PAYADVNC |
numeric(19,5)
0.00
|
Pay Advanc...(more) Join Now
|
|
|
|
| TIMETYPE_I |
smallint
0
|
|
|
|
|
| TIMEAVAILABLE |
numeric(19,5)
0.00
|
|
|
|
|
| ACRUVACN |
tinyint
0
|
Accrue Vac...(more) Join Now
|
|
|
|
| ACRUSTIM |
tinyint
0
|
Accrue Sic...(more) Join Now
|
|
|
|
| RPTASWGS |
tinyint
0
|
Report as ...(more) Join Now
|
|
|
|
| DAYSWRDK |
int
0
|
|
|
|
|
| WKSWRKD |
int
0
|
|
|
|
|
| RECEIPTS |
numeric(19,5)
0.00
|
|
|
|
|
| TipType |
smallint
0
|
Tip Type: ...(more) Join Now
|
|
|
|
| DEPRTMNT |
char(7)
''
|
Department...(more) Join Now
|
|
|
join ... more text available
|
| JOBTITLE |
char(7)
''
|
|
|
|
|
| STATECD |
char(3)
''
|
State Code...(more) Join Now
|
|
|
|
| LOCALTAX |
char(7)
''
|
|
|
|
|
| SUTASTAT |
char(3)
''
|
Suta State...(more) Join Now
|
|
|
|
| WRKRCOMP |
char(7)
''
|
Workers Co...(more) Join Now
|
|
|
|
| UNTSTOPY |
numeric(19,5)
0.00
|
Units to p...(more) Join Now
|
|
|
|
| ADJUNITS |
numeric(19,5)
0.00
|
|
|
|
|
| TOTALPAY |
numeric(19,5)
0.00
|
|
|
|
|
| BCHSOURC |
char(15)
''
|
Batch Sour...(more) Join Now
|
|
|
|
| PRTRXSRC |
int
0
|
|
|
|
|
| LASTUSER |
char(15)
''
|
Last User:...(more) Join Now
|
GL10000.LASTUSER
|
|
|
| LSTDTEDT |
datetime
'1/1/1900'
|
Last Date ...(more) Join Now
|
GL10000.LSTDTEDT
|
|
|
| TRXBEGDT |
datetime
'1/1/1900'
|
|
|
|
|
| TRXENDDT |
datetime
'1/1/1900'
|
|
|
|
|
| BLDCHWRG |
binary(4)
0
|
|
|
|
|
| BLDCHERR |
binary(4)
0
|
|
|
|
|
| SHFTCODE |
char(7)
''
|
Shift Code...(more) Join Now
|
|
|
|
| SHFTPREM |
numeric(19,5)
0.00
|
|
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|
|