Table: History_Of_Sheet_Entry
Columns
NameTypeConstraintsDescription
create__changeset_KEYintNOT NULL
update__changeset_KEYintNOT NULL
revise__changeset_KEYintNOT NULL
history_action_KEYtinyint (3)NOT NULL
sheet_entry_KEYintNOT NULL
activity_KEYint
amountdecimal (9, 2)
amount_is_overriddenbitNOT NULL
approved__staff_KEYint
approved_datesmalldatetime
biller_notenvarchar (-1)NOT NULL
calculated_amountdecimal (9, 2)
client_KEYint
commentnvarchar (-1)NOT NULL
completebitNOT NULL
education_course__schedule_item_KEYint
engagement_KEYint
entry_datesmalldatetime
posted__staff_KEYint
posted_datesmalldatetime
project_KEYint
row_versionbinary (8)NOT NULL
sheet_datesmalldatetime
sheet_entry_type_KEYintNOT NULL
staff_billing_rate_KEYint
staff_KEYint
task_KEYint
unit_costdecimal (9, 4)
unit_pricedecimal (9, 4)
unitsdecimal (9, 2)
integration_application_KEYintNOT NULL
activity__activity_class_KEYint
activity__activity_method_KEYint
project__schedule_item_KEYint
task__schedule_item_KEYint
Primary key
NameColumnsDescription
PK_History_Of_Sheet_Entry$sheet_entry_KEY$create__changeset_KEY$revise__changeset_KEYsheet_entry_KEY, create__changeset_KEY, revise__changeset_KEYCLUSTERED

Schema diagram