Table: Sheet_Entry_Open_Value_Cache | |||
Columns | |||
Name | Type | Constraints | Description |
sheet_entry_KEY | int | NOT NULL | Key to a Sheet_Entry row. |
billable_live_open_amount | decimal (17, 2) | NOT NULL | The billable live open amount for the Sheet_Entry row. |
billable_live_open_units | decimal (9, 2) | NOT NULL | The billable live open units for the Sheet_Entry row. |
nonbillable_live_open_amount | decimal (17, 2) | NOT NULL | The nonbillable live open amount for the Sheet_Entry row. |
nonbillable_live_open_units | decimal (9, 2) | NOT NULL | The nonbillable live open units for the Sheet_Entry row. |
Primary key | |||
Name | Columns | Description | |
PK_Sheet_Entry_Open_Value_Cache$sheet_entry_KEY | sheet_entry_KEY | CLUSTERED |
Foreign keys | |||
Name | Columns | Referenced table | Description |
FK_Sheet_Entry_Open_Value_Cache__Sheet_Entry__sheet_entry_KEY | sheet_entry_KEY | Sheet_Entry | on delete cascade; |