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. |