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 (250)
NOT NULL
client_class_KEY
int
NOT NULL
name_1
nvarchar (250)
NOT NULL
name_2
nvarchar (250)
NOT NULL
federal_tin
nvarchar (11)
NOT NULL
individual_first_name
nvarchar (100)
NOT NULL
individual_last_name
nvarchar (100)
NOT NULL
spouse_first_name
nvarchar (100)
NOT NULL
spouse_last_name
nvarchar (100)
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_utc
datetime
complexity_product_year
int
digita_out_of_date
bit
NOT NULL
individual_date_of_birth
smalldatetime
spouse_date_of_birth
smalldatetime
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