Module List >
Module UPR tables
UPR40900
You are currently viewing the COMPANY
database.
Change
|
COMPANY..UPR40900 Table Definition
(COMPANY..Payroll Deduction Setup)
Field Definitions:
What is the 'source' column?
| DEDUCTON |
char(7)
''
|
Deduction:...(more) Join Now
|
|
|
|
| DSCRIPTN |
char(31)
''
|
|
|
|
|
| INACTIVE |
tinyint
0
|
|
|
|
|
| DEDBEGDT |
datetime
'1/1/1900'
|
Deduction ...(more) Join Now
|
|
|
|
| DEDENDDT |
datetime
'1/1/1900'
|
Deduction ...(more) Join Now
|
|
|
|
| VARDEDTN |
tinyint
0
|
Variable D...(more) Join Now
|
|
|
|
| DEDNFREQ |
smallint
0
|
Deduction ...(more) Join Now
|
|
|
|
| TXSHANTY |
tinyint
0
|
Tax Shelte...(more) Join Now
|
|
|
|
| SFRFEDTX |
tinyint
0
|
Sheltered ...(more) Join Now
|
|
|
|
| SHFRFICA |
tinyint
0
|
Sheltered ...(more) Join Now
|
|
|
|
| SHFRSTTX |
tinyint
0
|
Sheltered ...(more) Join Now
|
|
|
|
| SFRLCLTX |
tinyint
0
|
Sheltered ...(more) Join Now
|
|
|
|
| BSDORCDS |
smallint
0
|
Based On R...(more) Join Now
|
|
|
|
| DEDNMTHD |
smallint
0
|
Deduction ...(more) Join Now
|
|
|
|
| DEDFRMLA |
smallint
0
|
Deduction ...(more) Join Now
|
|
|
|
| DEDCAMNT_1 |
numeric(19,5)
0.00
|
Deduction ...(more) Join Now
|
|
|
|
| DEDCAMNT_2 |
numeric(19,5)
0.00
|
|
|
|
|
| DEDCAMNT_3 |
numeric(19,5)
0.00
|
|
|
|
|
| DEDCAMNT_4 |
numeric(19,5)
0.00
|
|
|
|
|
| DEDCAMNT_5 |
numeric(19,5)
0.00
|
|
|
|
|
| DEDNPRCT_1 |
numeric(19,5)
0.00
|
Deduction ...(more) Join Now
|
|
|
|
| DEDNPRCT_2 |
numeric(19,5)
0.00
|
|
|
|
|
| DEDNPRCT_3 |
numeric(19,5)
0.00
|
|
|
|
|
| DEDNPRCT_4 |
numeric(19,5)
0.00
|
|
|
|
|
| DEDNPRCT_5 |
numeric(19,5)
0.00
|
|
|
|
|
| DEDTRMAX_1 |
numeric(19,5)
0.00
|
Deduction ...(more) Join Now
|
|
|
|
| DEDTRMAX_2 |
numeric(19,5)
0.00
|
|
|
|
|
| DEDTRMAX_3 |
numeric(19,5)
0.00
|
|
|
|
|
| DEDTRMAX_4 |
numeric(19,5)
0.00
|
|
|
|
|
| DEDTRMAX_5 |
numeric(19,5)
0.00
|
|
|
|
|
| DETRMXUN_1 |
int
0
|
Deduction ...(more) Join Now
|
|
|
|
| DETRMXUN_2 |
int
0
|
|
|
|
|
| DETRMXUN_3 |
int
0
|
|
|
|
|
| DETRMXUN_4 |
int
0
|
|
|
|
|
| DETRMXUN_5 |
int
0
|
|
|
|
|
| DEPYPRMX |
numeric(19,5)
0.00
|
Deduction ...(more) Join Now
|
|
|
|
| DEDYRMAX |
numeric(19,5)
0.00
|
Deduction ...(more) Join Now
|
|
|
|
| DEDLTMAX |
numeric(19,5)
0.00
|
Deduction ...(more) Join Now
|
|
|
|
| W2BXNMBR |
smallint
0
|
W2 Box Num...(more) Join Now
|
|
|
|
| W2BXLABL |
char(7)
''
|
W2 Box Lab...(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
|
|
|
|
| DEDTYPE |
smallint
0
|
|
|
|
|
| GARNCAT |
smallint
0
|
|
|
|
|
| EARNINGSCODE |
char(15)
''
|
Earnings C...(more) Join Now
|
|
|
|
| W2BXNMBR2 |
smallint
0
|
|
|
|
|
| W2BXLABL2 |
char(7)
''
|
|
|
|
|
| W2BXNMBR3 |
smallint
0
|
|
|
|
|
| W2BXLABL3 |
char(7)
''
|
|
|
|
|
| W2BXNMBR4 |
smallint
0
|
|
|
|
|
| W2BXLABL4 |
char(7)
''
|
|
|
|
|
| Deduction_Fiscal_Yr_Max |
numeric(19,5)
0.00
|
|
|
|
|
| SHFRFICAMED |
tinyint
0
|
|
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|
|