aurora_standard.stypayre
| Field | Type | Null | Default | Key | Extra | Comment |
|---|---|---|---|---|---|---|
| doc_no | bigint(20) unsigned | NO | PRI | auto_increment | ||
| empl_code | varchar(6) | NO | MUL | |||
| doc_date | date | YES | ||||
| pay_date | date | YES | ||||
| eop_date | date | YES | ||||
| print_check | varchar(1) | YES | ||||
| cash_acct_no | int(11) | YES | ||||
| department | varchar(3) | YES | ||||
| cash_amount | decimal(12,2) | YES | ||||
| check_no | varchar(10) | YES | ||||
| inc_gross | decimal(12,2) | YES | ||||
| ded_fica | decimal(12,2) | YES | ||||
| inc_taxable | decimal(12,2) | YES | ||||
| ded_medicare | decimal(12,2) | YES | ||||
| ded_fedtax | decimal(12,2) | YES | ||||
| ded_statax | decimal(12,2) | YES | ||||
| ded_loctax | decimal(12,2) | YES | ||||
| ded_other | decimal(12,2) | YES | ||||
| obl_futa | decimal(12,2) | YES | ||||
| obl_fica | decimal(12,2) | YES | ||||
| obl_medicare | decimal(12,2) | YES | ||||
| obl_other | decimal(12,2) | YES | ||||
| obl_total | decimal(12,2) | YES | ||||
| inc_net | decimal(12,2) | YES | ||||
| inc_expense | decimal(12,2) | YES | ||||
| total_hours | decimal(12,2) | YES | ||||
| ok_to_post | varchar(1) | YES | ||||
| accrue_sick | varchar(1) | YES | ||||
| accrue_vac | varchar(1) | YES | ||||
| bonus | varchar(1) | YES | ||||
| deposit | varchar(1) | YES | ||||
| cash_fac_no | varchar(3) | YES |