Table: Filter_Line_Type
Tags: read-only Content of first 30 of 185 rows:
1 | <Staff> | Staff | staff_KEY | 1
2 | <Staff> Type | Staff_Level | staff_level_KEY
3 | <Office> | Office | office_KEY | 7
4 | <Department> | Department | department_KEY
6 | <Activity> | Activity | activity_KEY | 2
7 | <Activity> Type | Activity_Method | activity_method_KEY
8 | Referral Type | Referral_Type | referral_type_KEY
9 | Referral Source | Referral_Source | referral_source_KEY
10 | <Client> | Client | client_KEY | 4
12 | Industry Code | Client | industry_code
14 | Entity | Entity | entity_KEY
15 | <Engagement> | Engagement | engagement_KEY | 5
16 | Date | Sheet_Entry | entry_date
17 | <Activity> Category | Activity_Category | activity_category_KEY
18 | <Activity> Class | Activity_Class | activity_class_KEY
19 | <Client> Type | Client_Class | client_class_KEY
20 | <Engagement> Template | Engagement_Template | engagement_template_KEY
21 | <Engagement> Type | Engagement_Type | engagement_type_KEY
22 | Bank Account | Bank_Account | bank_account_KEY
23 | Ledger Entry Type | Ledger_Entry_Type | ledger_entry_type_KEY
24 | Recurring Bill | Recurring_Bill | recurring_bill_KEY
25 | Date | Sheet_Entry | sheet_date
26 | Date | Invoice | invoice_date
27 | Date | Invoice | due_date
28 | Date | Ledger_Entry | control_date
29 | Date | Ledger_Entry | entry_date
30 | <Project> | Project | project_KEY | 6
31 | <Project> Template | Project_Template | project_template_KEY
32 | Date | Project | current_due_date
33 | Priority | Priority | priority_KEY
Columns
Name | Type | Constraints | Description
filter_line_type_KEY | int | NOT NULL | Database assigned primary key for this table.
description | nvarchar (30) | NOT NULL | The description of this type of critera (overridden by Filter Base Type).
lookup_list_name | nvarchar (128) | NOT NULL | Name of the list that provides data for this type of criteria or an empty string.
lookup_value_member | nvarchar (128) | NOT NULL | Name of the property in the lookup list to compare to Filter_Base_Type.filter_column or an empty string.
subfilter__filter_type_KEY | int |  | A key to a Filter Type if another filter can be used as a method.
update__staff_KEY | int | NOT NULL |
update_date | datetime | NOT NULL |

Primary key
Name | Columns | Description
PK_Filter_Line_Type$filter_line_type_KEY | filter_line_type_KEY | CLUSTERED
Indexes
Name | Columns | Description
IX_Filter_Line_Type$subfilter__filter_type_KEY | subfilter__filter_type_KEY | Index supports foreign key FK_Filter_Line_Type__Filter_Type__subfilter__filter_type_KEY

Foreign keys
Name | Columns | Referenced table | Description
FK_Filter_Line_Type__Filter_Type__subfilter__filter_type_KEY | subfilter__filter_type_KEY | Filter_Type |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Filter_Base_Type__Filter_Line_Type__filter_line_type_KEY | filter_line_type_KEY | Filter_Base_Type |
FK_Filter_Range_Type__Filter_Line_Type__filter_line_type_KEY | filter_line_type_KEY | Filter_Range_Type |