Table: Filter_Line_Type
Tags: read-only

Content of first 30 of 190 rows:
1<Staff>Staffstaff_KEY1
2<Staff> TypeStaff_Levelstaff_level_KEY
3<Office>Officeoffice_KEY7
4<Department>Departmentdepartment_KEY
6<Activity>Activityactivity_KEY2
7<Activity> TypeActivity_Methodactivity_method_KEY
8Referral TypeReferral_Typereferral_type_KEY
9Referral SourceReferral_Sourcereferral_source_KEY
10<Client>Clientclient_KEY4
12Industry CodeClientindustry_code
14EntityEntityentity_KEY
15<Engagement>Engagementengagement_KEY5
16DateSheet_Entryentry_date
17<Activity> CategoryActivity_Categoryactivity_category_KEY
18<Activity> ClassActivity_Classactivity_class_KEY
19<Client> TypeClient_Classclient_class_KEY
20<Engagement> TemplateEngagement_Templateengagement_template_KEY
21<Engagement> TypeEngagement_Typeengagement_type_KEY
22Bank AccountBank_Accountbank_account_KEY
23Ledger Entry TypeLedger_Entry_Typeledger_entry_type_KEY
24Recurring BillRecurring_Billrecurring_bill_KEY
25DateSheet_Entrysheet_date
26DateInvoiceinvoice_date
27DateInvoicedue_date
28DateLedger_Entrycontrol_date
29DateLedger_Entryentry_date
30<Project>Projectproject_KEY6
31<Project> TemplateProject_Templateproject_template_KEY
32DateProjectcurrent_due_date
33PriorityPrioritypriority_KEY
Columns
NameTypeConstraintsDescription
filter_line_type_KEYintNOT NULLDatabase assigned primary key for this table.
descriptionnvarchar (30)NOT NULLThe description of this type of critera (overridden by Filter Base Type).
lookup_list_namenvarchar (128)NOT NULLName of the list that provides data for this type of criteria or an empty string.
lookup_value_membernvarchar (128)NOT NULLName of the property in the lookup list to compare to Filter_Base_Type.filter_column or an empty string.
subfilter__filter_type_KEYintA key to a Filter Type if another filter can be used as a method.
update__staff_KEYintNOT NULL
update_datedatetimeNOT NULL
Primary key
NameColumnsDescription
PK_Filter_Line_Type$filter_line_type_KEYfilter_line_type_KEYCLUSTERED
Indexes
NameColumnsDescription
IX_Filter_Line_Type$subfilter__filter_type_KEYsubfilter__filter_type_KEYIndex supports foreign key FK_Filter_Line_Type__Filter_Type__subfilter__filter_type_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Filter_Line_Type__Filter_Type__subfilter__filter_type_KEYsubfilter__filter_type_KEYFilter_Type
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Filter_Base_Type__Filter_Line_Type__filter_line_type_KEYfilter_line_type_KEYFilter_Base_Type
FK_Filter_Range_Type__Filter_Line_Type__filter_line_type_KEYfilter_line_type_KEYFilter_Range_Type

Schema diagram