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_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