Module List >
Module HRM tables
APR_APR70250
You are currently viewing the COMPANY
database.
Change
|
COMPANY..APR_APR70250 Table Definition
(COMPANY..APR Distribution Report Detail)
Field Definitions:
What is the 'source' column?
| USERID |
char(15)
''
|
The user t...(more) Join Now
|
|
|
join ... more text available
|
| APR_Fund |
char(67)
''
|
|
|
|
|
| DEPRTMNT |
char(7)
''
|
Department...(more) Join Now
|
TATX1030.DEPRTMNT
|
|
join ... more text available
|
| EMPLOYID |
char(15)
''
|
Employee I...(more) Join Now
|
|
|
join ... more text available
|
| SEQNUMBR |
int
0
|
Sequence N...(more) Join Now
|
|
|
|
| APR_Code |
char(11)
''
|
|
|
|
|
| APR_TRX_Department |
char(7)
''
|
|
|
|
|
| DSCRIPTN |
char(31)
''
|
|
|
|
|
| UNTSTOPY |
numeric(19,5)
0
|
Units to p...(more) Join Now
|
UPR30300.UNTSTOPY
|
|
|
| APR_First |
numeric(19,5)
0
|
|
|
|
|
| APR_Second |
numeric(19,5)
0
|
|
|
|
|
| APR_Third |
numeric(19,5)
0
|
|
|
|
|
| TOTALPAY |
numeric(19,5)
0
|
|
|
|
|
| FDWGPYRN |
numeric(19,5)
0
|
|
|
|
|
| FDWDGPRN |
numeric(19,5)
0
|
Federal Wi...(more) Join Now
|
|
|
|
| FCASWPR |
numeric(19,5)
0
|
|
|
|
|
| EPFICASS |
numeric(19,5)
0
|
|
|
|
|
| FICAMWPR |
numeric(19,5)
0
|
|
|
|
|
| EFICAMCR |
numeric(19,5)
0
|
|
|
|
|
| STATECD |
char(3)
''
|
State Code...(more) Join Now
|
UPR00300.STATECD
|
|
|
| TXBLWAGS |
numeric(19,5)
0
|
|
|
|
|
| TTLSTTAX |
numeric(19,5)
0
|
|
|
|
|
| TXSHANTY |
tinyint
0
|
Tax Shelte...(more) Join Now
|
|
|
|
| VARDBAMT |
numeric(19,5)
0
|
|
|
|
|
| TTLDEDTN |
numeric(19,5)
0
|
|
|
|
|
| NTWPYRN |
numeric(19,5)
0
|
|
|
|
|
| FLAG |
char(1)
''
|
|
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|
|