Tags: read-only
Content of first 30 of 190 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 |
|
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 | |