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
Name | Type | Constraints | Description
integration_sheet_entry_KEY | int | NOT NULL | Assigned by COMMON_dp_Allocate_Unique_Identifiers. Database assigned primary key for this table.
row_version | timestamp | NOT NULL |
update__staff_KEY | int | NOT NULL |
update_date | datetime | NOT NULL |
client_KEY | int |  | Key to the Client that this entry is for. The client must be the client of the Engagement.
engagement_KEY | int |  | Key to the Engagement this entry is for.
activity_KEY | int |  | Key to the Activity this entry is for.
entry_date | smalldatetime |  | Date this entry is for.
staff_billing_rate_KEY | int |  | Key to the Staff Billing Rate used to calculate the amount.
units | decimal (9, 2) |  | Quantity of units (or hours).
unit_cost | decimal (9, 4) |  | Cost per unit (or hour) at the time the amount was computed.
unit_price | decimal (9, 4) |  | Price per unit (or hour) at the time the amount was computed. Storage is required because amount can be rounded.
amount | decimal (9, 2) |  | Overridden extended price after computation and rounding.
comment | nvarchar (-1) | NOT NULL | An optional comment.
biller_note | nvarchar (-1) | NOT NULL | An optional comment for the biller.
sheet_entry_type_KEY | int | NOT NULL | Key to Sheet Entry Type indicating what type of entry this is.
staff_KEY | int |  | Staff this Sheet Entry is for.
sheet_date | smalldatetime |  | Date of the Sheet, also known as control date.
approved_date | smalldatetime |  | Date this item was approved.
approved__staff_KEY | int |  | Key of the Staff who approved this item.
posted_date | smalldatetime |  | Date this item was posted.
posted__staff_KEY | int |  | Key of the Staff who posted this item.
create_date | datetime | NOT NULL |
project_KEY | int |  | Optionally links this Sheet Entry to a Project.
task_KEY | int |  | Optionally links this Sheet Entry to a Task.
calculated_amount | decimal (9, 2) |  | Calculated extended price after computation and rounding.
amount_is_overridden | bit | NOT NULL | True 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__description | nvarchar (-1) | NOT NULL | The string description of the source application for this entry.

Primary key
Name | Columns | Description
PK_Integration_Sheet_Entry$integration_sheet_entry_KEY | integration_sheet_entry_KEY | CLUSTERED

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Integration_Custom_Value__Integration_Sheet_Entry__row_KEY | row_KEY | Integration_Custom_Value | on delete cascade;