Table: User_Preference_Default_Wip_Date
User preference default wip date types
Tags: read-only

Content:
1Invoice date
2Today's date
3Period end date
4Prior period end date
5Month end date
6Prior month end date
7Custom date
Columns
NameTypeConstraintsDescription
user_preference_default_wip_date_KEYintNOT NULLSystem assigned primary key for this table.
descriptionnvarchar (30)NOT NULLSystem descripton.
Primary key
NameColumnsDescription
PK_User_Preference_Default_Wip_Date$user_preference_default_wip_date_KEYuser_preference_default_wip_date_KEYCLUSTERED
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_User_Preference__User_Preference_Default_Wip_Date__billing__user_preference_default_wip_date_KEYbilling__user_preference_default_wip_date_KEYUser_Preference

Schema diagram