aurora_standard.stycntrc
| Field | Type | Null | Default | Key | Extra | Comment |
|---|---|---|---|---|---|---|
| post_gl | varchar(1) | YES | ||||
| ein_number | varchar(10) | YES | ||||
| state_number | varchar(15) | YES | ||||
| fedtax_code | varchar(6) | YES | ||||
| fica_code | varchar(6) | YES | ||||
| medicare_code | varchar(6) | YES | ||||
| statax_code | varchar(6) | YES | ||||
| loctax_code | varchar(6) | YES | ||||
| futa_code | varchar(6) | YES | ||||
| fica_ob_code | varchar(6) | YES | ||||
| medicare_ob_code | varchar(6) | YES | ||||
| eic_code | varchar(6) | YES | ||||
| exp_acct | int(11) | YES | ||||
| liab_acct | int(11) | YES | ||||
| cash_acct | int(11) | YES | ||||
| mmedia_file | varchar(100) | YES | ||||
| mmedia_command | varchar(100) | YES | ||||
| py_doc_no | int(11) | YES | ||||
| py_post_no | int(11) | YES | ||||
| immed_dest_dfi | int(11) | YES | ||||
| immed_chk_digit | smallint(6) | YES | ||||
| immed_dest_name | varchar(23) | YES | ||||
| co_bank_acct_no | varchar(17) | YES | ||||
| offset_debit | varchar(1) | YES | ||||
| set_up | varchar(1) | YES | ||||
| suta_code | varchar(6) | YES | ||||
| fac_no | varchar(3) | YES | ||||
| due_to_acct | int(11) | YES | ||||
| due_from_acct | int(11) | YES | ||||
| apply_date_flag | varchar(1) | YES | ||||
| w2_tax_year | varchar(4) | YES | ||||
| suta_number | varchar(20) | YES | ||||
| gl_cut_off | date | YES | ||||
| immed_orig_dfi | int(11) | YES | ||||
| immed_orig_chk | smallint(6) | YES | ||||
| immed_orig_name | varchar(23) | YES | ||||
| emp_ar_code | varchar(6) | YES | ||||
| base_inc_code | char(6) | YES | ||||
| bonus_chk_flag | char(1) | YES | ||||
| chs_rowID | bigint(20) unsigned | NO | PRI | auto_increment |