Table: Sheet_Entry_Open_Value_Cache
Columns
NameTypeConstraintsDescription
sheet_entry_KEYintNOT NULLKey to a Sheet_Entry row.
billable_live_open_amountdecimal (17, 2)NOT NULLThe billable live open amount for the Sheet_Entry row.
billable_live_open_unitsdecimal (9, 2)NOT NULLThe billable live open units for the Sheet_Entry row.
nonbillable_live_open_amountdecimal (17, 2)NOT NULLThe nonbillable live open amount for the Sheet_Entry row.
nonbillable_live_open_unitsdecimal (9, 2)NOT NULLThe nonbillable live open units for the Sheet_Entry row.
Primary key
NameColumnsDescription
PK_Sheet_Entry_Open_Value_Cache$sheet_entry_KEYsheet_entry_KEYCLUSTERED
Foreign keys
NameColumnsReferenced tableDescription
FK_Sheet_Entry_Open_Value_Cache__Sheet_Entry__sheet_entry_KEYsheet_entry_KEYSheet_Entryon delete cascade;

Schema diagram