Table: History_Of_Client
Columns
NameTypeConstraintsDescription
create__changeset_KEYintNOT NULL
update__changeset_KEYintNOT NULL
revise__changeset_KEYintNOT NULL
history_action_KEYtinyint (3)NOT NULL
client_KEYintNOT NULL
client_idnvarchar (11)NOT NULL
descriptionnvarchar (250)NOT NULL
client_class_KEYintNOT NULL
name_1nvarchar (250)NOT NULL
name_2nvarchar (250)NOT NULL
federal_tinnvarchar (11)NOT NULL
individual_first_namenvarchar (100)NOT NULL
individual_last_namenvarchar (100)NOT NULL
spouse_first_namenvarchar (100)NOT NULL
spouse_last_namenvarchar (100)NOT NULL
client_status_KEYintNOT NULL
office_KEYint
entity_KEYint
manager__staff_KEYint
associate__staff_KEYint
industry_codenvarchar (6)NOT NULL
fiscal_year_end_monthintNOT NULL
date_openedsmalldatetime
date_leftsmalldatetime
commentsnvarchar (-1)NOT NULL
principal__client_KEYintNOT NULL
assess_service_chargebitNOT NULL
service_charge_KEYint
print_statementsbitNOT NULL
use_wip_limitbitNOT NULL
wip_limitdecimal (17, 2)NOT NULL
use_accounts_receivable_limitbitNOT NULL
accounts_receivable_limitdecimal (17, 2)NOT NULL
contact_KEYintNOT NULL
days_to_due_dateintNOT NULL
billing_instructionsnvarchar (-1)NOT NULL
invoice__report_definition_KEYintNOT NULL
statement__report_definition_KEYintNOT NULL
referral_type_KEYint
referred_by__client_KEYint
referred_by__contact_KEYint
referred_by__referral_source_KEYint
referred_by__staff_KEYint
won_datesmalldatetime
won_reason_KEYint
lost_reason_KEYint
lost_to_KEYint
client_id_sortablevarchar (48)NOT NULL
client_guiduniqueidentifierNOT NULL
client_note_datanvarchar (-1)NOT NULL
spouse_federal_tinnvarchar (11)NOT NULL
billing__contact_KEYintNOT NULL
billing_email_recipientsnvarchar (500)NOT NULL
preferred__contact_KEYintNOT NULL
complexityint
complexity_event_date_utcdatetime
complexity_product_yearint
digita_out_of_datebitNOT NULL
individual_date_of_birthsmalldatetime
spouse_date_of_birthsmalldatetime
Primary key
NameColumnsDescription
PK_History_Of_Client$client_KEY$create__changeset_KEY$revise__changeset_KEYclient_KEY, create__changeset_KEY, revise__changeset_KEYCLUSTERED

Schema diagram