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. |
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_utc | 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_utc | 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. |