Module List >
Module UPR tables
UPR19900
You are currently viewing the COMPANY
database.
Change
|
COMPANY..UPR19900 Table Definition
(COMPANY..Payroll Flat Tax Records)
Field Definitions:
What is the 'source' column?
| ISTIPPAY |
tinyint
0
|
|
|
|
|
| ACTINDX |
int
0
|
Account In...(more) Join Now
|
|
|
join ... more text available
|
| ACCTAMNT |
numeric(19,5)
0.00
|
Account Am...(more) Join Now
|
|
|
|
| ACCTTYPE |
smallint
0
|
p>Account ...(more) Join Now
|
GL00100.ACCTTYPE
|
|
|
| STATECD |
char(3)
''
|
State Code...(more) Join Now
|
|
|
|
| PAYRCORD |
char(7)
''
|
Pay Record...(more) Join Now
|
|
|
|
| PAYTYPE |
smallint
0
|
Pay Type: ...(more) Join Now
|
|
|
|
| GROSWAGS_1 |
numeric(19,5)
0.00
|
Gross Wage...(more) Join Now
|
|
|
|
| GROSWAGS_2 |
numeric(19,5)
0.00
|
|
|
|
|
| GROSWAGS_3 |
numeric(19,5)
0.00
|
|
|
|
|
| GROSWAGS_4 |
numeric(19,5)
0.00
|
|
|
|
|
| GROSWAGS_5 |
numeric(19,5)
0.00
|
|
|
|
|
| GROSWAGS_6 |
numeric(19,5)
0.00
|
|
|
|
|
| GROSWAGS_7 |
numeric(19,5)
0.00
|
|
|
|
|
| GROSWAGS_8 |
numeric(19,5)
0.00
|
|
|
|
|
| GROSWAGS_9 |
numeric(19,5)
0.00
|
|
|
|
|
| GROSWAGS_10 |
numeric(19,5)
0.00
|
|
|
|
|
| GROSWAGS_11 |
numeric(19,5)
0.00
|
|
|
|
|
| GROSWAGS_12 |
numeric(19,5)
0.00
|
|
|
|
|
| FFEDTXRT |
smallint
0
|
Flat Feder...(more) Join Now
|
|
|
|
| FLSTTXRT |
smallint
0
|
Flat State...(more) Join Now
|
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|
|