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

COMPANY..UPR40600 Table Definition

(COMPANY..Payroll Pay Code Setup)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
PAYRCORD char(7)
''
Pay Record...(more) Join Now
DSCRIPTN char(31)
''

INACTIVE tinyint
0

PAYTYPE smallint
0
Pay Type: ...(more) Join Now
BSPAYRCD char(7)
''
Base Pay R...(more) Join Now
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
MXPYPPER numeric(19,5)
0.00
Maximum Pa...(more) Join Now
TipType smallint
0
Tip Type: ...(more) Join Now
PAYADVNC numeric(19,5)
0.00
Pay Advanc...(more) Join Now
RPTASWGS tinyint
0
Report as ...(more) Join Now
W2BXNMBR smallint
0
W2 Box Num...(more) Join Now
W2BXLABL char(7)
''
W2 Box Lab...(more) Join Now
TAXABLE tinyint
0
Taxable: ...(more) Join Now
SBJTFDTX tinyint
0
Subject To...(more) Join Now
SBJTSSEC tinyint
0
Subject To...(more) Join Now
SBJTMCAR tinyint
0
Subject To...(more) Join Now
SBJTSTTX tinyint
0
Subject to...(more) Join Now
SBJTLTAX tinyint
0
Subject to...(more) Join Now
SBJTFUTA tinyint
0

SBJTSUTA tinyint
0
Subject to...(more) Join Now
FFEDTXRT smallint
0
Flat Feder...(more) Join Now
FLSTTXRT smallint
0
Flat State...(more) Join Now
ACRUVACN tinyint
0
Accrue Vac...(more) Join Now
ACRUSTIM tinyint
0
Accrue Sic...(more) Join Now
NOTEINDX numeric(19,5)
0.00
Note Index...(more) Join Now
join ... more text available
DATAENTDFLT tinyint
0
Data Entry...(more) Join Now
SHFTCODE char(7)
''
Shift Code...(more) Join Now
PAYFACTR numeric(19,5)
0.00
Pay Factor...(more) Join Now
BSDONRTE numeric(19,5)
0.00

W2BXNMBR2 smallint
0

W2BXLABL2 char(7)
''

W2BXNMBR3 smallint
0

W2BXLABL3 char(7)
''

W2BXNMBR4 smallint
0

W2BXLABL4 char(7)
''

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