Table: dbo.Client_1099_Override
The table used to store Client overrides for the 1099s.
Columns
Name | Type | Constraints | Description
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.

Primary key
Name | Columns | Description
PK_Client_1099_Override | client_1099_override_KEY |
Unique constraints
Name | Columns | Description
UK_Client_1099_Override$client_KEY | client_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Client_1099_Override__Client__client_KEY | client_KEY | Client (client_KEY) |
FK_Client_1099_Override__Employer_Type__employer_type_KEY | employer_type_KEY | Employer_Type (employer_type_KEY) |