Table: Integration_Sheet_Entry
This table is a holding area for Sheet Entry rows that are imported from a Disconnected Database, before they are verified by a user. There is intentionally no foreign keys to this table, so that rows can still be accepted into the database should the related rows not exist.
Columns
NameTypeConstraintsDescription
integration_sheet_entry_KEYintNOT NULLAssigned by COMMON_dp_Allocate_Unique_Identifiers. Database assigned primary key for this table.
row_versiontimestampNOT NULL
update__staff_KEYintNOT NULL
update_date_utcdatetimeNOT NULL
client_KEYintKey to the Client that this entry is for. The client must be the client of the Engagement.
engagement_KEYintKey to the Engagement this entry is for.
activity_KEYintKey to the Activity this entry is for.
entry_datesmalldatetimeDate this entry is for.
staff_billing_rate_KEYintKey to the Staff Billing Rate used to calculate the amount.
unitsdecimal (9, 2)Quantity of units (or hours).
unit_costdecimal (9, 4)Cost per unit (or hour) at the time the amount was computed.
unit_pricedecimal (9, 4)Price per unit (or hour) at the time the amount was computed. Storage is required because amount can be rounded.
amountdecimal (9, 2)Overridden extended price after computation and rounding.
commentnvarchar (-1)NOT NULLAn optional comment.
biller_notenvarchar (-1)NOT NULLAn optional comment for the biller.
sheet_entry_type_KEYintNOT NULLKey to Sheet Entry Type indicating what type of entry this is.
staff_KEYintStaff this Sheet Entry is for.
sheet_datesmalldatetimeDate of the Sheet, also known as control date.
approved_datesmalldatetimeDate this item was approved.
approved__staff_KEYintKey of the Staff who approved this item.
posted_datesmalldatetimeDate this item was posted.
posted__staff_KEYintKey of the Staff who posted this item.
create_date_utcdatetimeNOT NULL
project_KEYintOptionally links this Sheet Entry to a Project.
task_KEYintOptionally links this Sheet Entry to a Task.
calculated_amountdecimal (9, 2)Calculated extended price after computation and rounding.
amount_is_overriddenbitNOT NULLTrue when the calculated_amount is overridden and is necessary so that the override is not deleted if the values happen to match later.
integration_application__descriptionnvarchar (-1)NOT NULLThe string description of the source application for this entry.
Primary key
NameColumnsDescription
PK_Integration_Sheet_Entry$integration_sheet_entry_KEYintegration_sheet_entry_KEYCLUSTERED
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Integration_Custom_Value__Integration_Sheet_Entry__row_KEYrow_KEYIntegration_Custom_Valueon delete cascade;

Schema diagram