Table: dbo.Transaction_Template_Frequency
Transaction Template Frequency - enumerates the supported types of frequencies for transaction templates
Columns
NameTypeConstraintsDescription
transaction_template_frequency_KEYint (4)NOT NULLPrimary key
descriptionnvarchar (60)NOT NULLValues: On demand, Weekly, Monthly, Semimonthly, Last day of posting period, Automatic
Primary key
NameColumnsDescription
PK_Transaction_Template_Frequencytransaction_template_frequency_KEY
Unique constraints
NameColumnsDescription
UK_Transaction_Template_Frequency$descriptiondescription
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Transaction_Template__Transaction_Template_Frequency__transaction_template_frequency_KEYtransaction_template_frequency_KEYTransaction_Template

Schema diagram