Table: dbo.Data_Entry_Confirmation
Lists the types of data for which Data Entry Confirmation is supported and on which ones it is enabled.
Columns
NameTypeConstraintsDescription
data_entry_confirmation_KEYint (4)NOT NULLPrimary key.
descriptionnvarchar (120)NOT NULLUser-friendly description of the type of data.
is_enabledbit (1)NOT NULLTrue if the firm has enabled DEC for fields containing the specified type of data.
sequence_numberint (4)NOT NULL1-based number determining display order in UI.
firm_KEYint (4)NOT NULLLink to Firm; allows atomic save in setup.
Primary key
NameColumnsDescription
PK_Data_Entry_Confirmationdata_entry_confirmation_KEY
Unique constraints
NameColumnsDescription
UK_Data_Entry_Confirmation$descriptiondescription
UK_Data_Entry_Confirmation$sequence_numbersequence_number
Foreign keys
NameColumnsReferenced tableDescription
FK_Data_Entry_Confirmation__Firm__firm_KEYfirm_KEYFirm (firm_KEY)

Schema diagram