| The table used to store Client overrides for the 1099s. |
| client_1099_override_KEY | int (4) | NOT NULL | Primary key. |
| client_KEY | int (4) | NOT NULL | Foreign key into the Client table. |
| client_id | nvarchar (22) | | The override for the client's id. |
| client_ein | nvarchar (22) | | The override for the client's ein. |
| final_return | bit (1) | | The override for whether or not this is the client's final return. |
| payroll_name | nvarchar (100) | | The override for the client's payroll name. |
| address_1 | nvarchar (80) | | The override for the client's address line 1. |
| address_2 | nvarchar (80) | | The override for the client's address line 2. |
| city | nvarchar (60) | | The override for the client's city. |
| state_abbreviation | nvarchar (4) | | The override for the client's state. |
| postal_code | nvarchar (20) | | The override for the client's postal code. |
| employer_type_KEY | int (4) | | The override for the client's employer type. |
| establishment_number | nvarchar (8) | | The override for the client's establishment number. |
| contact_name | nvarchar (100) | | The override for the client's contact name. |
| contact_email | nvarchar (80) | | The override for the client's contact email. |
| contact_phone | nvarchar (50) | | The override for the client's contact phone. |
| contact_fax | nvarchar (50) | | The override for the client's contact fax. |
| title | nvarchar (40) | | The override for the client's title. |
| signature_date | datetime (8, 3) | | The override for the client's signature date. |