Table: History_Of_Client
Columns
Name | Type | Constraints | Description
create__changeset_KEY | int | NOT NULL |
update__changeset_KEY | int | NOT NULL |
revise__changeset_KEY | int | NOT NULL |
history_action_KEY | tinyint (3) | NOT NULL |
client_KEY | int | NOT NULL |
client_id | nvarchar (11) | NOT NULL |
description | nvarchar (30) | NOT NULL |
client_class_KEY | int | NOT NULL |
name_1 | nvarchar (50) | NOT NULL |
name_2 | nvarchar (50) | NOT NULL |
federal_tin | nvarchar (11) | NOT NULL |
individual_first_name | nvarchar (14) | NOT NULL |
individual_last_name | nvarchar (20) | NOT NULL |
spouse_first_name | nvarchar (14) | NOT NULL |
spouse_last_name | nvarchar (20) | NOT NULL |
client_status_KEY | int | NOT NULL |
office_KEY | int |  |
entity_KEY | int |  |
manager__staff_KEY | int |  |
associate__staff_KEY | int |  |
industry_code | nvarchar (6) | NOT NULL |
fiscal_year_end_month | int | NOT NULL |
date_opened | smalldatetime |  |
date_left | smalldatetime |  |
comments | nvarchar (-1) | NOT NULL |
principal__client_KEY | int | NOT NULL |
assess_service_charge | bit | NOT NULL |
service_charge_KEY | int |  |
print_statements | bit | NOT NULL |
use_wip_limit | bit | NOT NULL |
wip_limit | decimal (17, 2) | NOT NULL |
use_accounts_receivable_limit | bit | NOT NULL |
accounts_receivable_limit | decimal (17, 2) | NOT NULL |
contact_KEY | int | NOT NULL |
days_to_due_date | int | NOT NULL |
billing_instructions | nvarchar (-1) | NOT NULL |
invoice__report_definition_KEY | int | NOT NULL |
statement__report_definition_KEY | int | NOT NULL |
referral_type_KEY | int |  |
referred_by__client_KEY | int |  |
referred_by__contact_KEY | int |  |
referred_by__referral_source_KEY | int |  |
referred_by__staff_KEY | int |  |
won_date | smalldatetime |  |
won_reason_KEY | int |  |
lost_reason_KEY | int |  |
lost_to_KEY | int |  |
client_id_sortable | varchar (48) | NOT NULL |
client_guid | uniqueidentifier | NOT NULL |
client_note_data | nvarchar (-1) | NOT NULL |
spouse_federal_tin | nvarchar (11) | NOT NULL |
billing__contact_KEY | int | NOT NULL |
billing_email_recipients | nvarchar (500) | NOT NULL |
preferred__contact_KEY | int | NOT NULL |
complexity | int |  |
complexity_event_date | datetime |  |
complexity_product_year | int |  |

Primary key
Name | Columns | Description
PK_History_Of_Client$client_KEY$create__changeset_KEY$revise__changeset_KEY | client_KEY, create__changeset_KEY, revise__changeset_KEY | CLUSTERED