Table: History_Of_Engagement | |||
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 | |
engagement_KEY | int | NOT NULL | |
client_KEY | int | ||
engagement_template_KEY | int | NOT NULL | |
description | nvarchar (250) | NOT NULL | |
long_description | nvarchar (-1) | NOT NULL | |
engagement_type_KEY | int | ||
engagement_status_KEY | int | NOT NULL | |
office_KEY | int | ||
biller__staff_KEY | int | ||
reviewer__staff_KEY | int | ||
manager__staff_KEY | int | ||
rate_type_KEY | int | NOT NULL | |
billing_rate_type_KEY | int | ||
fixed_rate | decimal (9, 2) | NOT NULL | |
markup_factor | decimal (6, 4) | NOT NULL | |
tax_area_KEY | int | ||
recurring_bill_KEY | int | ||
recurring_bill_method_KEY | int | ||
recurring_bill_amount | decimal (9, 2) | NOT NULL | |
recurring_bill__staff_KEY | int | ||
recurring_bill__activity_KEY | int | ||
gl_account | nvarchar (60) | NOT NULL | |
engagement_surcharge_method_KEY | int | NOT NULL | |
surcharge_amount | decimal (9, 2) | NOT NULL |
Primary key | |||
Name | Columns | Description | |
PK_History_Of_Engagement$engagement_KEY$create__changeset_KEY$revise__changeset_KEY | engagement_KEY, create__changeset_KEY, revise__changeset_KEY | CLUSTERED |