Table: History_Of_Sheet_Entry | |||
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 | |
sheet_entry_KEY | int | NOT NULL | |
activity_KEY | int | ||
amount | decimal (9, 2) | ||
amount_is_overridden | bit | NOT NULL | |
approved__staff_KEY | int | ||
approved_date | smalldatetime | ||
biller_note | nvarchar (-1) | NOT NULL | |
calculated_amount | decimal (9, 2) | ||
client_KEY | int | ||
comment | nvarchar (-1) | NOT NULL | |
complete | bit | NOT NULL | |
education_course__schedule_item_KEY | int | ||
engagement_KEY | int | ||
entry_date | smalldatetime | ||
posted__staff_KEY | int | ||
posted_date | smalldatetime | ||
project_KEY | int | ||
row_version | binary (8) | NOT NULL | |
sheet_date | smalldatetime | ||
sheet_entry_type_KEY | int | NOT NULL | |
staff_billing_rate_KEY | int | ||
staff_KEY | int | ||
task_KEY | int | ||
unit_cost | decimal (9, 4) | ||
unit_price | decimal (9, 4) | ||
units | decimal (9, 2) | ||
integration_application_KEY | int | NOT NULL | |
activity__activity_class_KEY | int | ||
activity__activity_method_KEY | int | ||
project__schedule_item_KEY | int | ||
task__schedule_item_KEY | int |
Primary key | |||
Name | Columns | Description | |
PK_History_Of_Sheet_Entry$sheet_entry_KEY$create__changeset_KEY$revise__changeset_KEY | sheet_entry_KEY, create__changeset_KEY, revise__changeset_KEY | CLUSTERED |