aurora_standard.stp1099c
| Field | Type | Null | Default | Key | Extra | Comment |
|---|---|---|---|---|---|---|
| tax_year | varchar(4) | YES | ||||
| prior_year | varchar(1) | YES | ||||
| trans_code | varchar(5) | YES | ||||
| replace_code | varchar(2) | YES | ||||
| test_file | varchar(1) | YES | ||||
| company_name | varchar(40) | YES | ||||
| company_addr | varchar(40) | YES | ||||
| company_city | varchar(40) | YES | ||||
| company_state | varchar(2) | YES | ||||
| company_zip | varchar(9) | YES | ||||
| contact_name | varchar(40) | YES | ||||
| contact_phone | varchar(15) | YES | ||||
| contact_email | varchar(35) | YES | ||||
| software_vend_name | varchar(40) | YES | ||||
| vend_addr | varchar(40) | YES | ||||
| vend_city | varchar(40) | YES | ||||
| vend_state | varchar(2) | YES | ||||
| vend_zip | varchar(9) | YES | ||||
| vend_contact | varchar(40) | YES | ||||
| vend_phone | varchar(15) | YES | ||||
| vend_email | varchar(35) | YES | ||||
| fac_no | varchar(3) | YES | ||||
| fed_state | varchar(1) | YES | ||||
| chs_rowID | bigint(20) unsigned | NO | PRI | auto_increment |