Column Dictionary | |||
A B C D E F G H I L M N O P R S T U V W Y | |||
Column | Table | Type | Description |
accounts_receivable_dunning_1 | Firm | nvarchar (-1) | Dunning message to print when the oldest outstanding item is 1 period old. |
accounts_receivable_dunning_2 | Firm | nvarchar (-1) | Dunning message to print when the oldest outstanding item is 2 periods old. |
accounts_receivable_dunning_3 | Firm | nvarchar (-1) | Dunning message to print when the oldest outstanding item is 3 periods old. |
accounts_receivable_dunning_4 | Firm | nvarchar (-1) | Dunning message to print when the oldest outstanding item is 4 periods old. |
accounts_receivable_dunning_5 | Firm | nvarchar (-1) | Dunning message to print when the oldest outstanding item is 5 or more periods old. |
accounts_receivable_gl_account | GL_Entry_Export_Option | nvarchar (60) | |
accounts_receivable_limit | Client | decimal (17, 2) | Accounts Receivable limit. |
accounts_receivable_limit | History_Of_Client | decimal (17, 2) | |
accounts_receivable_terms | Firm | nvarchar (-1) | Payment terms included on invoices and statements. |
accruable_benefit_allowance_by_month_KEY | Accruable_Benefit_Allowance_By_Month | int | Assigned by COMMON_dp_Allocate_Unique_Identifiers. Primary key for this table. |
accruable_benefit_allowance_by_staff_level_KEY | Accruable_Benefit_Allowance_By_Staff_Level | int | Assigned by COMMON_dp_Allocate_Unique_Identifiers. Primary key for this table. |
accruable_benefit_KEY | Accruable_Benefit | int | Primary key for this table, same value as [benefit_KEY]. |
accumulate_time_before_rounding | History_Of_Timer | bit | |
accumulate_time_before_rounding | Timer | bit | The Accumulte Time setting that was in place when the Timer was started. |
action | Last_Table_Modification | char (1) | |
active | Benefit | bit | Whether this benefit is active. |
active | Staff_Benefit | bit | Determines whether the benefit is enabled for this Staff. |
active_filter_KEY | Active_Filter | int | AUTO-INCREMENT: Database assigned primary key for this table |
activity__activity_class_KEY | History_Of_Sheet_Entry | int | |
activity__activity_class_KEY | Sheet_Entry | int | Cached value of the activity class: 1=Billable 2=Non-billable 3=Administrative |
activity__activity_method_KEY | History_Of_Sheet_Entry | int | |
activity__activity_method_KEY | Sheet_Entry | int | Cached value of the activity method: 1=Time 2=Expense |
activity_category_id | Activity_Category | nvarchar (11) | User defined identifier (unique). |
activity_category_id_sortable | Activity_Category | varchar (48) | A representation of the activity_category_id column that sorts in natural order, meaning that digits are sorted as numbers while non-digits are sorted alphabetically. A trigger keeps this field synchronized with the content of activity_category_id. |
activity_category_KEY | Activity | int | KEY of the Activity Category that this row is assigned. |
activity_category_KEY | Activity_Category | int | AUTO-INCREMENT: Database assigned primary key for this table |
activity_class_KEY | Activity | int | KEY of the Activity Class that this row is assigned |
activity_id | Activity | nvarchar (11) | User defined identifier (unique) |
activity_id_sortable | Activity | varchar (48) | A representation of the activity_id column that sorts in natural order, meaning that digits are sorted as numbers while non-digits are sorted alphabetically. A trigger keeps this field synchronized with the content of activity_id. |
activity_KEY | Accruable_Benefit | int | Key to an Activity that the accruable benefit is for. |
activity_KEY | Activity | int | AUTO-INCREMENT: Database assigned primary key for this table |
activity_KEY | History_Of_Schedule_Item | int | |
activity_KEY | History_Of_Sheet_Entry | int | |
activity_KEY | Integration_Sheet_Entry | int | Key to the Activity this entry is for. |
activity_KEY | Schedule_Item | int | The linked [Activity]. |
activity_KEY | Sheet_Entry | int | Key to the Activity this entry is for. |
activity_KEY | Task_Template | int | |
activity_method_KEY | Activity | int | 1=Time, 2=Expense |
activity_status_KEY | Activity | int | KEY of the Activity Status that this row is assigned |
activity_surcharge_method_KEY | Activity | int | 1=No surcharge, 2=Per Unit, 3=Percent |
actual_complete_date | History_Of_Project | smalldatetime | |
actual_complete_date | History_Of_Task | smalldatetime | |
actual_complete_date | Project | smalldatetime | The actual complete date. |
actual_complete_date | Task | smalldatetime | The actual complete date. |
actual_start_date | History_Of_Project | smalldatetime | |
actual_start_date | History_Of_Task | smalldatetime | |
actual_start_date | Project | smalldatetime | The actual start date. |
actual_start_date | Task | smalldatetime | The actual start date. |
additional_contact_KEY | Additional_Contact | int | AUTO-INCREMENT: Database assigned primary key for this table. |
additional_contact_KEY | History_Of_Additional_Contact | int | |
address_1 | Address | nvarchar (40) | First line of address. |
address_1 | Contact_Address | nvarchar (40) | First line of address. |
address_1 | History_Of_Contact_Address | nvarchar (40) | |
address_2 | Address | nvarchar (40) | Second line of address. |
address_2 | Contact_Address | nvarchar (40) | Second line of address. |
address_2 | History_Of_Contact_Address | nvarchar (40) | |
address_3 | Address | nvarchar (128) | Third line of address. |
address_3 | Contact_Address | nvarchar (128) | Third line of address. |
address_3 | History_Of_Contact_Address | nvarchar (128) | |
address_checksum | Address | int | |
address_KEY | Address | int | Assigned by COMMON_dp_Allocate_Unique_Identifiers. Database assigned primary key for this table. |
address_position | Contact | nvarchar (4) | Semicolon seperated list of contact_address_type_KEY values indicating the user's preferred order of displaying addresses. |
address_position | History_Of_Contact | nvarchar (4) | |
adjustment | Billing_Decision | decimal (9, 2) | Adjustment (a negative adjustment is a write down). |
adjustment | Client_Date_Cache | decimal (9, 2) | Adjustment sum for the Client, principal Client, and entry date |
administrative_activity_type_KEY | Activity | int | KEY of the Administrative Activity Type that this row is assigned. |
alert_level_KEY | Monitored_Event | int | |
alert_level_KEY | Recorded_Event | int | Alert level for event. |
allowance | Accruable_Benefit_Allowance_By_Month | decimal (9, 2) | The allowance amount. |
allowance | Accruable_Benefit_Allowance_By_Staff_Level | decimal (9, 2) | The allowance amount. |
alternate_row_color | User_Preference | bit | Presents all lists and grids with alternating row colors when true |
amount | Billing_Decision_Taxing_Authority | decimal (9, 2) | The amount of tax charged. |
amount | History_Of_Sheet_Entry | decimal (9, 2) | |
amount | Integration_Invoice | decimal (17, 2) | The total amount of this item. |
amount | Integration_Sheet_Entry | decimal (9, 2) | Overridden extended price after computation and rounding. |
amount | Ledger_Entry | decimal (17, 2) | The total amount of this item. |
amount | Ledger_Entry_Service_Charge | decimal (17, 2) | Amount charged because past_due__ledger_entry_KEY has not been paid. |
amount | Sheet_Entry | decimal (9, 2) | Overridden extended price after computation and rounding. |
amount_collected | Billing_Decision_Tax_Collection | decimal (9, 2) | The amount collected for the tax. |
amount_is_overridden | Billing_Decision_Taxing_Authority | bit | True when the calculated_amount is overridden and is necessary so that the override is not deleted if the values happen to match later. |
amount_is_overridden | History_Of_Sheet_Entry | bit | |
amount_is_overridden | Integration_Sheet_Entry | bit | True when the calculated_amount is overridden and is necessary so that the override is not deleted if the values happen to match later. |
amount_is_overridden | Sheet_Entry | bit | True when the calculated_amount is overridden and is necessary so that the override is not deleted if the values happen to match later. |
annual_rate | Service_Charge | decimal (7, 6) | Rate to be used for the service charge calculation. |
applied_amount | Ledger_Entry_Application | decimal (17, 2) | The amount of "from" entry that is applied to "to" |
apply_to_discount | Taxing_Authority | bit | Flag, true if this tax applies to discount amounts |
apply_to_shipping | Taxing_Authority | bit | Flag, true if this tax applies to shipping amounts |
approvalcode | Ledger_Entry_Submittal_Result | nvarchar (6) | Contents of the approvalcode field in the response returned by Intercept. |
approved__staff_KEY | History_Of_Schedule_Item | int | |
approved__staff_KEY | History_Of_Sheet_Entry | int | |
approved__staff_KEY | Integration_Sheet_Entry | int | Key of the Staff who approved this item. |
approved__staff_KEY | Ledger_Entry | int | Key of the Staff who approved this item. |
approved__staff_KEY | Schedule_Item | int | The Staff that approved the item. |
approved__staff_KEY | Sheet_Entry | int | Key of the Staff who approved this item. |
approved_date | History_Of_Schedule_Item | smalldatetime | |
approved_date | History_Of_Sheet_Entry | smalldatetime | |
approved_date | Integration_Invoice | smalldatetime | Date this item was approved. |
approved_date | Integration_Sheet_Entry | smalldatetime | Date this item was approved. |
approved_date | Ledger_Entry | smalldatetime | Date this item was approved. |
approved_date | Schedule_Item | smalldatetime | The date the item was approved. |
approved_date | Sheet_Entry | smalldatetime | Date this item was approved. |
ar_adjustment | Client_Date_Cache | decimal (9, 2) | ar_adjustment sum for the Client, principal Client, and entry date |
ar_received | Client_Date_Cache | decimal (9, 2) | ar_received sum for the Client, principal Client, and entry date |
ar_service_charge | Client_Date_Cache | decimal (9, 2) | ar_service_charge sum for the Client, principal Client, and entry date |
assess_service_charge | Client | bit | Default should be set to whatever is set in firm setup. |
assess_service_charge | Firm | bit | Default for new clients. |
assess_service_charge | History_Of_Client | bit | |
assigned__staff_grouping_type_KEY | Project_Template | int | Key to a Staff Grouping Type that indicates how to determine which staff will be assigned to generated projects. |
assigned_staff_id_list | Schedule_Item_Assignment_List_Cache | nvarchar (-1) | List of [Staff].[staff_id] (or work queue). |
assigned_staff_list | Schedule_Item_Assignment_List_Cache | nvarchar (-1) | List of [Staff].[description] (or work queue). |
associate__staff_KEY | Client | int | Key to a Staff record. |
associate__staff_KEY | History_Of_Client | int | |
associate_with_contact | Interaction_Association | bit | True when this type of association is an association between an Interaction and a Contact. |
associate_with_object | Interaction_Association | bit | True when this type of association is an association between an Interaction and a "object" like a Staff, Client or Office.. |
attachment_comment | Attachment | nvarchar (-1) | |
attachment_comment | History_Of_Attachment | nvarchar (-1) | |
attachment_content | Attachment_Content | varbinary (-1) | The raw data for this attachment |
attachment_content | History_Of_Attachment_Content | varbinary (-1) | |
attachment_content_hash_code | Attachment_Content | varchar (40) | 40-character hexadecimal-formatted string from the SHA-1 hash of the image for faster look-up. |
attachment_content_hash_code | History_Of_Attachment_Content | varchar (40) | |
attachment_content_KEY | Attachment | int | What is the content of the associated attachment. |
attachment_content_KEY | Attachment_Content | int | |
attachment_content_KEY | History_Of_Attachment | int | |
attachment_content_KEY | History_Of_Attachment_Content | int | |
attachment_content_length | Attachment_Content | int | The size of the attachment_content, in bytes |
attachment_content_length | History_Of_Attachment_Content | int | |
attachment_name | Attachment | nvarchar (260) | The name of a particular attachment. This is usually the file name of the source file. |
attachment_name | History_Of_Attachment | nvarchar (260) | |
bank_account_id | Bank_Account | nvarchar (11) | User defined identifier (unique) |
bank_account_id_sortable | Bank_Account | varchar (48) | A representation of the bank_account_id column that sorts in natural order, meaning that digits are sorted as numbers while non-digits are sorted alphabetically. A trigger keeps this field synchronized with the content of bank_account_id. |
bank_account_KEY | Bank_Account | int | AUTO-INCREMENT: Database assigned primary key for this table |
bank_account_KEY | Ledger_Entry | int | A bank account is required for all types except Invoices and Service Charges which must not specify a bank account. |
begin_date_utc | Changeset | datetime | When this changeset was created. |
begin_date_utc | Changeset_Active | datetime | The same value that is in Changeset.begin_date_utc |
benefit_entry_type_KEY | Benefit_Factor | int | Key to a benefit entry type that this benefit factor is. |
benefit_entry_type_KEY | Staff_Benefit_Entry | int | Key to a staff benefit entry type. |
benefit_factor_KEY | Benefit_Factor | int | Assigned by COMMON_dp_Allocate_Unique_Identifiers. Primary key for this table, same value as activity_KEY. |
benefit_KEY | Accruable_Benefit | int | Key to a Benefit that the accruable benefit is for. |
benefit_KEY | Accruable_Benefit_Allowance_By_Month | int | Key to a benefit. |
benefit_KEY | Accruable_Benefit_Allowance_By_Staff_Level | int | Key to a benefit. |
benefit_KEY | Benefit | int | Assigned by COMMON_dp_Allocate_Unique_Identifiers. Primary key for this table, same value as activity_KEY. |
benefit_KEY | Benefit_Factor | int | Key to a Benefit that the benefit factor is for. |
benefit_KEY | History_Of_Schedule_Item | int | |
benefit_KEY | Schedule_Item | int | Link to the benefit for items of type scheduled benefit. |
benefit_KEY | Staff_Benefit | int | Key to a Benefit. |
benefit_type_KEY | Benefit | int | Key to a Benefit Type. |
benefit_year_begin_date | Firm | smalldatetime | Begin date of the benefit year. |
benefit_year_end_date | Firm | smalldatetime | End date of the benefit year. |
bill_amount | Billing_Decision | decimal (9, 2) | Amount billed for this invoice. |
bill_amount_collected | Billing_Decision_Collection | decimal (9, 2) | The amount collected for the bill_amount of the Billing_Decision. |
billable_amount | Staff_Target_Range | decimal (17, 2) | If [billable_amount_is_overridden] is TRUE, this is the total billable amount to be spread across all target billable hours for the date range. |
billable_amount_is_overridden | Staff_Target_Range | bit | When TRUE, indicates that the value of [billable_amount] is used, otherwise a rate is computed from an associated [Staff_Target_Range_Rate] record. |
billable_live_open_amount | Sheet_Entry_Open_Value_Cache | decimal (17, 2) | The billable live open amount for the Sheet_Entry row. |
billable_live_open_units | Sheet_Entry_Open_Value_Cache | decimal (9, 2) | The billable live open units for the Sheet_Entry row. |
billable_percent | Staff_Target_Range | decimal (7, 6) | The billable target hours are calculated from the target hours specified * this percentage. |
billable_rate | Staff_Billing_Rate | decimal (9, 2) | The rate billed per hour for this Staff Billing Rate. |
billed__staff_KEY | Invoice | int | Key of the Staff who billed this invoice. |
billed_date | Integration_Invoice | smalldatetime | Date this integration_invoice was saved. |
billed_date | Invoice | smalldatetime | Date this invoice was saved. |
biller__staff_grouping_type_KEY | Engagement_Template | int | Key to a Staff Grouping Type that indicates how to determine which staff will be assigned to generated engagements. |
biller__staff_KEY | Engagement | int | Key to a Staff record. |
biller__staff_KEY | History_Of_Engagement | int | |
biller_note | History_Of_Sheet_Entry | nvarchar (-1) | |
biller_note | Integration_Sheet_Entry | nvarchar (-1) | An optional comment for the biller. |
biller_note | Sheet_Entry | nvarchar (-1) | An optional comment for the biller. |
billing__address_KEY | Credit_Card | int | Billing address. |
billing__billing_method_KEY | User_Preference | int | Billing by Client or Engagement |
billing__contact_KEY | Client | int | Primary contact for invoice and statement delivery. By default will be the contact key of the client |
billing__contact_KEY | History_Of_Client | int | |
billing__custom_wip_date | User_Preference | smalldatetime | The billing default custom wip date. |
billing__user_preference_default_invoice_date_KEY | User_Preference | int | Default Invoice date for Detail Billing. |
billing__user_preference_default_wip_date_KEY | User_Preference | int | Key of the User Preference Default Wip Date that this row is assigned. |
billing_activity_description_hide | User_Preference | bit | |
billing_auto_apply_open_credits | User_Preference | bit | Determines if we automatically apply any open credits when saving a detail billing decision. |
billing_auto_check_spelling | User_Preference | bit | |
billing_auto_select_child_clients | User_Preference | bit | |
billing_biller_note_hide | User_Preference | bit | |
billing_client_description_hide | User_Preference | bit | |
billing_comment_hide | User_Preference | bit | |
billing_decision_guid | Billing_Decision | uniqueidentifier | A unique key for this row generated in detail billing otherwise by the database. |
billing_decision_KEY | Billing_Decision | int | AUTO-INCREMENT: Database assigned primary key for this table |
billing_decision_KEY | Billing_Decision_Taxing_Authority | int | DEPRECATED. Identifies the Billing_Decision row this tax is charged for. |
billing_decision_taxing_authority_KEY | Billing_Decision_Taxing_Authority | int | AUTO-INCREMENT: DEPRECATED. Database assigned primary key for this table. |
billing_email_recipients | Client | nvarchar (500) | Any additional email address to whom the billing information should be emailed |
billing_email_recipients | History_Of_Client | nvarchar (500) | |
billing_engagement_description_hide | User_Preference | bit | |
billing_implied_decimal | User_Preference | bit | Automatically inserts decimal point at end of amount |
billing_instructions | Client | nvarchar (-1) | Any notes for the biller. |
billing_instructions | History_Of_Client | nvarchar (-1) | |
billing_mark_zero_invoice_as_printed | User_Preference | bit | |
billing_name | Credit_Card | nvarchar (50) | Name on billing information. |
billing_project_description_hide | User_Preference | bit | |
billing_prompt_to_apply_open_credits | User_Preference | bit | Determines if we prompt to apply credits when saving in the Billing Details screen. |
billing_rate_type_KEY | Activity | int | KEY of the Billing Rate Type that this row is assigned (required when rate_type_KEY=2). |
billing_rate_type_KEY | Billing_Rate_Type | int | AUTO-INCREMENT: Database assigned primary key for this table. |
billing_rate_type_KEY | Engagement | int | Key to a Billing Rate Type record (required when rate_type_KEY=2). |
billing_rate_type_KEY | History_Of_Engagement | int | |
billing_rate_type_KEY | Staff_Billing_Rate | int | Foreign key to one of the already set up Billing Rate Types (unique per staff_rate_table_KEY). |
billing_rate_type_KEY | Staff_Target_Range | int | Links to a Billing_Rate_Type record. The staff must have this rate used for the entire time the range is applicable. |
billing_show_wip_during_selection | User_Preference | bit | WIP column should show in the billing selection list and be populated with WIP balances. |
billing_staff_description_hide | User_Preference | bit | When true the staff description column in billing will be hidden |
billing_standard__rounding_method_KEY | User_Preference | int | Rounding method for Bill At Standard |
billing_standard_rounding_increment | User_Preference | decimal (4, 2) | Rounding increment for Bill At Standard |
billing_startup_tab | User_Preference | nvarchar (100) | Startup tab of Detail Billing |
body | File_Transfer | nvarchar (-1) | body of the File Transfer message |
body | History_Of_File_Transfer | nvarchar (-1) | |
body | Interaction | nvarchar (-1) | Body of this interaction, sometimes unused (empty string) and sometimes truncated (e-mail body for example.) |
budget_generation_KEY | History_Of_Schedule_Item_Series | int | |
budget_generation_KEY | Schedule_Item_Series | int | Key to a Budget Generation that indicates the source of the budget information. |
budgeted_amount | History_Of_Project | decimal (9, 2) | |
budgeted_amount | History_Of_Task | decimal (9, 2) | |
budgeted_amount | Project | decimal (9, 2) | Amount budgeted to this project (when budgeted_based_on_tasks = 0). |
budgeted_amount | Project_Template | decimal (9, 2) | Amount budgeted to this project (when budgeted_based_on_tasks = 0). |
budgeted_amount | Task | decimal (9, 2) | Amount budgeted to this task. |
budgeted_amount | Task_Template | decimal (9, 2) | |
budgeted_amount_is_calculated | History_Of_Project | bit | |
budgeted_amount_is_calculated | History_Of_Task | bit | |
budgeted_amount_is_calculated | Project | bit | |
budgeted_amount_is_calculated | Project_Template | bit | |
budgeted_amount_is_calculated | Task | bit | |
budgeted_amount_is_calculated | Task_Template | bit | |
budgeted_based_on_tasks | History_Of_Project | bit | |
budgeted_based_on_tasks | Project | bit | When set to 1 will indicate that the budget is entirely based off the budget of the Tasks for the generated project. |
budgeted_based_on_tasks | Project_Template | bit | When set to 1 will indicate that the budget is entirely based off the budget of the Tasks for the generated project. |
budgeted_hours | History_Of_Schedule_Item | decimal (9, 2) | |
budgeted_hours | History_Of_Schedule_Item_Assignment | decimal (9, 2) | |
budgeted_hours | Project_Template | decimal (9, 2) | Number of hours budgeted to this project (when budgeted_based_on_tasks = 0). |
budgeted_hours | Project_Template_Assignment | decimal (9, 2) | Must be greater than or equal to zero, or -1.00 (to indicate assignment only without a budget.) |
budgeted_hours | Schedule_Item | decimal (9, 2) | Number of hours budgeted to this item. Items can have a wide target range specified, but only use a small portion of it. |
budgeted_hours | Schedule_Item_Assignment | decimal (9, 2) | Must be greater than or equal to zero, or -1.00 (to indicate assignment only without a budget.) |
budgeted_hours | Task_Template | decimal (9, 2) | |
budgeted_hours | Task_Template_Assignment | decimal (9, 2) | Must be greater than or equal to zero, or -1.00 (to indicate assignment only without a budget.) |
byte_count | Report_Image | int | |
calculated_amount | Billing_Decision_Taxing_Authority | decimal (9, 2) | Calculated amount of tax charged. |
calculated_amount | History_Of_Sheet_Entry | decimal (9, 2) | |
calculated_amount | Integration_Sheet_Entry | decimal (9, 2) | Calculated extended price after computation and rounding. |
calculated_amount | Sheet_Entry | decimal (9, 2) | Calculated extended price after computation and rounding. |
calendar_category_KEY | Calendar_Category | int | Assigned by COMMON_dp_Allocate_Unique_Identifiers. Database assigned primary key for this table. |
calendar_category_KEY | History_Of_Calendar_Category | int | |
calendar_category_KEY | History_Of_Schedule_Entry | int | |
calendar_category_KEY | Schedule_Entry | int | |
cardholder_name | Credit_Card | nvarchar (50) | Credit card holder name. |
category | Custom_Field | nvarchar (30) | |
category | History_Of_Custom_Field | nvarchar (30) | |
certification_number | Staff | nvarchar (250) | Certification number. |
change | Update_Data_Change_Log | nvarchar (-1) | |
changeset_KEY | Changeset | int | AUTO-INCREMENT: Database assigned auto-incrementing value. |
changeset_KEY | Changeset_Active | int | A link to an active Changeset. |
changeset_KEY | Changeset_Modified_Table | int | A link to a Changeset. |
charge_sales_tax | Activity | bit | Used to determine if Sales Tax should be calculated |
charge_service_tax | Activity | bit | Used to determine if Service Tax should be calulated |
chart | Custom_Chart | nvarchar (-1) | The serialized custom chart, or the standard chart XML resource. |
chart | History_Of_Custom_Chart | nvarchar (-1) | |
child__contact_KEY | Additional_Contact | int | Key to the child contact record. |
child__contact_KEY | History_Of_Additional_Contact | int | |
city | Address | nvarchar (40) | City. |
city | Contact_Address | nvarchar (40) | City. |
city | History_Of_Contact_Address | nvarchar (40) | |
cleared | Interaction | bit | |
client_application_name | Update_Data_Version_History | nvarchar (200) | |
client_application_name | User_Session_Pattern | nvarchar (200) | |
client_class_KEY | Client | int | Key to a Client Class record. |
client_class_KEY | History_Of_Client | int | |
client_dashboard_layout | User_Preference | nvarchar (-1) | Layout of the Client Dashboard stored as XML |
client_date_cache_KEY | Client_Date_Cache | int | AUTO-INCREMENT: Primary key of table. |
client_financial_data_description_KEY | Client_Financial_Data | int | Description of this financial data |
client_financial_data_description_KEY | Client_Financial_Data_Description | int | Assigned by COMMON_dp_Allocate_Unique_Identifiers. unique key of this table |
client_financial_data_description_KEY | History_Of_Client_Financial_Data | int | |
client_financial_data_description_KEY | History_Of_Client_Financial_Data_Description | int | |
client_financial_data_KEY | Client_Financial_Data | int | Assigned by COMMON_dp_Allocate_Unique_Identifiers. primary key for this table |
client_financial_data_KEY | History_Of_Client_Financial_Data | int | |
client_guid | Client | uniqueidentifier | A unique id for this row generated by the database. |
client_guid | History_Of_Client | uniqueidentifier | |
client_id | Client | nvarchar (11) | User defined identifier (unique) |
client_id | History_Of_Client | nvarchar (11) | |
client_id | Integration_Invoice | nvarchar (11) | The Client ID that this invoice is for (in text form). |
client_id_sortable | Client | varchar (48) | A representation of the client_id column that sorts in natural order, meaning that digits are sorted as numbers while non-digits are sorted alphabetically. A trigger keeps this field synchronized with the content of client_id. |
client_id_sortable | History_Of_Client | varchar (48) | |
client_KEY | Client | int | Assigned by COMMON_dp_Allocate_Unique_Identifiers. Database assigned primary key for this table |
client_KEY | Client_Date_Cache | int | Key to Client that the sums are associated with. |
client_KEY | Client_Financial_Data | int | Client this data refers to |
client_KEY | Client_Shortcut_Group | int | The client who own this solution group. |
client_KEY | Client_Staff_Grouping | int | |
client_KEY | Client_Status_Event | int | Key to the Client record that this status event was recorded for. |
client_KEY | Engagement | int | When NULL the record is an Engagement Template, otherwise the record is an Engagement that belongs to a single Client record. |
client_KEY | History_Of_Client | int | |
client_KEY | History_Of_Client_Financial_Data | int | |
client_KEY | History_Of_Client_Staff_Grouping | int | |
client_KEY | History_Of_Engagement | int | |
client_KEY | History_Of_Schedule_Item | int | |
client_KEY | History_Of_Sheet_Entry | int | |
client_KEY | Integration_Sheet_Entry | int | Key to the Client that this entry is for. The client must be the client of the Engagement. |
client_KEY | Ledger_Entry | int | Key to a Client row |
client_KEY | Recorded_Event | int | Client that was affected by the event. Null if not associated with a clint. |
client_KEY | Schedule_Item | int | The linked [Client]. If of__contact_KEY is specified and is the primary contact of a Client, that client_KEY is also this value. |
client_KEY | Sheet_Entry | int | Key to the Client that this entry is for. The client must be the client of the Engagement. |
client_name | Gofileroom_Workflow | nvarchar (255) | GoFileRoom Client name of this workflow. |
client_note_data | Client | nvarchar (-1) | Data used by the Client Note control. |
client_note_data | History_Of_Client | nvarchar (-1) | |
client_number | Gofileroom_Workflow | nvarchar (255) | GoFileRoom Client number of this workflow. |
client_shortcut_group_KEY | Client_Shortcut | int | Associates this solution with its solution group. |
client_shortcut_group_KEY | Client_Shortcut_Group | int | Assigned by COMMON_dp_Allocate_Unique_Identifiers. Database assigned primary key for this table |
client_shortcut_KEY | Client_Shortcut | int | Assigned by COMMON_dp_Allocate_Unique_Identifiers. Database assigned primary key for this table |
client_staff_grouping_KEY | Client_Staff_Grouping | int | |
client_staff_grouping_KEY | History_Of_Client_Staff_Grouping | int | |
client_staff_grouping_type_KEY | Client_Staff_Grouping | int | |
client_staff_grouping_type_KEY | History_Of_Client_Staff_Grouping | int | |
client_status_event_KEY | Client_Status_Event | int | AUTO-INCREMENT: Database assigned primary key for this table |
client_status_KEY | Client | int | Key to a Client Status record. |
client_status_KEY | History_Of_Client | int | |
code | Privilege | nvarchar (10) | This is a shorter version of Description that is used for the privilege path. |
collate_copies | Print_Option | bit | Collate copies. |
collected | Billing_Decision_Collection | decimal (9, 2) | The total amount collected for the Billing_Decision. |
collected | Client_Date_Cache | decimal (9, 2) | collected sum for the Client, principal Client, and entry date |
collection_source__ledger_entry_KEY | Billing_Decision_Collection | int | Identifies the source of the application - usually this is the [Ledger_Entry] row of a payment, but it can also be the same as [ledger_entry_KEY] in adjustment scenarios. Should have been named to__ledger_entry_KEY. |
collection_source__ledger_entry_KEY | Billing_Decision_Tax_Collection | int | Identifies the receipt in the Ledger_Entry table that paid for this collection. |
color | Calendar_Category | int | The Win32 value of the color. |
color | History_Of_Calendar_Category | int | |
COLUMN_COLLATION | COMMON_Metadata_About_Columns | nvarchar (128) | |
COLUMN_NAME | COMMON_Metadata_About_Columns | nvarchar (128) | |
COLUMN_NAME | COMMON_Metadata_About_Foreign_Keys | nvarchar (128) | |
COLUMN_NAME | COMMON_Metadata_About_Keys | nvarchar (128) | |
column_name | COMMON_Unique_Identifier_Counter | nvarchar (128) | |
column_name | Department_Grouping_Type | nvarchar (128) | Name of the column used to find the value. |
column_name | Staff_Grouping_Type | nvarchar (128) | Name of the column used to find the value. |
COLUMN_PRECISION | COMMON_Metadata_About_Columns | int | |
COLUMN_SCALE | COMMON_Metadata_About_Columns | int | |
comment | History_Of_Link | nvarchar (-1) | |
comment | History_Of_Sheet_Entry | nvarchar (-1) | |
comment | Integration_Sheet_Entry | nvarchar (-1) | An optional comment. |
comment | Link | nvarchar (-1) | Optional reason why this link was created |
comment | Sheet_Entry | nvarchar (-1) | An optional comment. |
comments | Client | nvarchar (-1) | Any comments about the Client. |
comments | Client_Status_Event | nvarchar (-1) | User defined comments. |
comments | History_Of_Client | nvarchar (-1) | |
comments | History_Of_Schedule_Item_Budget_Remaining_Entry | nvarchar (-1) | |
comments | Integration_Invoice | nvarchar (-1) | Comments about this item that can be included on reports. |
comments | Ledger_Entry | nvarchar (-1) | Comments about this item that can be included on reports. |
comments | Schedule_Item_Budget_Remaining_Entry | nvarchar (-1) | User entered comments. |
comments | Staff | nvarchar (-1) | Any comments about the Staff. |
comments | Staff_Benefit_Entry | nvarchar (-1) | Comments about this entry. |
comments | Staff_Locator | nvarchar (-1) | Any comments entered by the user. |
comments | Task_Template | nvarchar (-1) | |
company | Contact | nvarchar (250) | Company of the contact. |
company | History_Of_Contact | nvarchar (250) | |
complete | History_Of_Sheet_Entry | bit | |
complete | Sheet_Entry | bit | |
complete__target_date_method_KEY | History_Of_Schedule_Item_Series | int | |
complete__target_date_method_KEY | Project_Template_Definition | int | |
complete__target_date_method_KEY | Schedule_Item_Series | int | The method used to calculate the target complete date. |
complete__target_date_method_KEY | Task_Template | int | |
complete_date_utc | File_Transfer | datetime | The File_Transfer_Event.event_date_utc of the event that completed this File Transfer |
complete_date_utc | History_Of_File_Transfer | datetime | |
completion_event | History_Of_Project | nvarchar (50) | |
completion_event | History_Of_Task | nvarchar (50) | |
completion_event | Project | nvarchar (50) | Description of a "User" type client status event that will mark this Project as being complete. |
completion_event | Project_Template | nvarchar (50) | Description of an event that will mark the generated project as being complete. |
completion_event | Task | nvarchar (50) | Description of a "User" type client status event that will mark this Task as being complete. |
completion_event | Task_Template | nvarchar (50) | |
completion_event_recorded_date_utc | History_Of_Project | datetime | |
completion_event_recorded_date_utc | History_Of_Task | datetime | |
completion_event_recorded_date_utc | Project | datetime | Only completion events recorded after this date (in UTC) are eligible to complete this Project. When the completion event is used to complete the Project this value must be updated. |
completion_event_recorded_date_utc | Task | datetime | Only completion events recorded after this date (in UTC) are eligible to complete this Task. When the completion event is used to complete the Task this value must be updated. |
completion_order | History_Of_Task | int | |
completion_order | Task | int | The user defined order the tasks are to be completed in (not unique). |
completion_order | Task_Template | int | |
complexity | Client | int | |
complexity | History_Of_Client | int | |
complexity_event_date_utc | Client | datetime | |
complexity_event_date_utc | History_Of_Client | datetime | |
complexity_product_year | Client | int | |
complexity_product_year | History_Of_Client | int | |
compound | Service_Charge | bit | Determines whether prior service charges should be included in the balance that is going to be used for the service charge. |
computer | Recorded_Event | nvarchar (15) | Name of computer that was running Practice when the event was detected. |
confirm_changes | Outlook_Contact_Synchronization_Folder | bit | true if this profile should display a confirmation dialog prior to committing sync changes between the database and Outlook?. |
CONSTRAINT_NAME | COMMON_Metadata_About_Foreign_Keys | nvarchar (128) | |
CONSTRAINT_NAME | COMMON_Metadata_About_Keys | nvarchar (128) | |
contact__contact_KEY | File_Transfer | int | contact that this transfer is to |
contact__contact_KEY | History_Of_File_Transfer | int | |
contact__portal_user_KEY | File_Transfer | int | portal that this transfer is to |
contact__portal_user_KEY | History_Of_File_Transfer | int | |
contact_address_KEY | Contact_Address | int | AUTO-INCREMENT: Database assigned primary key for this table. |
contact_address_KEY | History_Of_Contact_Address | int | |
contact_address_type_KEY | Contact_Address | int | Key to a Contact Address Type record. |
contact_address_type_KEY | History_Of_Contact_Address | int | |
contact_category_id | Contact_Category | nvarchar (11) | User defined identifier (unique). |
contact_category_id | History_Of_Contact_Category | nvarchar (11) | |
contact_category_id_sortable | Contact_Category | varchar (48) | A representation of the contact_category_id column that sorts in natural order, meaning that digits are sorted as numbers while non-digits are sorted alphabetically. A trigger keeps this field synchronized with the content of contact_category_id. |
contact_category_id_sortable | History_Of_Contact_Category | varchar (48) | |
contact_category_KEY | Contact_Category | int | AUTO-INCREMENT: Database assigned primary key for this table. |
contact_category_KEY | Contact_Contact_Category | int | Key to the assigned category. |
contact_category_KEY | History_Of_Contact_Category | int | |
contact_category_KEY | History_Of_Contact_Contact_Category | int | |
contact_contact_category_KEY | Contact_Contact_Category | int | AUTO-INCREMENT: Database assigned primary key for this table. |
contact_contact_category_KEY | History_Of_Contact_Contact_Category | int | |
contact_email_KEY | Contact_Email | int | AUTO-INCREMENT: Database assigned primary key for this table. |
contact_email_KEY | History_Of_Contact_Email | int | |
contact_email_KEY | Monitored_Event_Action | int | Specifes non-staff email address to notify when event occurs. |
contact_email_KEY | Recorded_Event_Notification | int | Key if someone was notified via email. |
contact_email_type_KEY | Contact_Email | int | Key to a Contact Email Type record. |
contact_email_type_KEY | History_Of_Contact_Email | int | |
contact_guid | Contact | uniqueidentifier | |
contact_guid | History_Of_Contact | uniqueidentifier | |
contact_KEY | Client | int | Key to the primary Contact record for this Client. |
contact_KEY | Contact | int | Assigned by COMMON_dp_Allocate_Unique_Identifiers. Database assigned primary key for this table. |
contact_KEY | Contact_Address | int | Key to a Contact record. |
contact_KEY | Contact_Contact_Category | int | Key to the parent contact record. |
contact_KEY | Contact_Email | int | Key to a Contact record. |
contact_KEY | Contact_Phone | int | Key to a Contact record. |
contact_KEY | History_Of_Client | int | |
contact_KEY | History_Of_Contact | int | |
contact_KEY | History_Of_Contact_Address | int | |
contact_KEY | History_Of_Contact_Contact_Category | int | |
contact_KEY | History_Of_Contact_Email | int | |
contact_KEY | History_Of_Contact_Phone | int | |
contact_KEY | Interaction_Contact | int | A reference to one of the Contact rows. |
contact_KEY | Legacy_Contact_Portal_Mapping | int | The contact key. |
contact_KEY | Office | int | Key to the primary Contact record for this Client. |
contact_KEY | Staff | int | Key to the primary Contact record for this Staff. |
contact_phone_KEY | Contact_Phone | int | AUTO-INCREMENT: Database assigned primary key for this table. |
contact_phone_KEY | History_Of_Contact_Phone | int | |
contact_phone_type_KEY | Contact_Phone | int | Key to a Contact Phone Type record. |
contact_phone_type_KEY | History_Of_Contact_Phone | int | |
contact_phone_type_KEY | Interaction_Phone_Number | int | Key to a Contact Phone Type record. |
contact_type_KEY | Contact | int | Key to Contact Type. |
contact_type_KEY | History_Of_Contact | int | |
content | Feed_Channel_Item | nvarchar (-1) | |
control_date | Ledger_Entry | smalldatetime | Date used to group Ledger Entries together. |
cost | History_Of_Schedule_Item | decimal (9, 2) | |
cost | Schedule_Item | decimal (9, 2) | |
country | Address | nvarchar (25) | Country. |
country | Contact_Address | nvarchar (25) | Country. |
country | History_Of_Contact_Address | nvarchar (25) | |
county | Address | nvarchar (25) | County. |
county | Contact_Address | nvarchar (25) | County. |
county | History_Of_Contact_Address | nvarchar (25) | |
create__changeset_KEY | Additional_Contact | int | |
create__changeset_KEY | Attachment | int | |
create__changeset_KEY | Attachment_Content | int | |
create__changeset_KEY | Calendar_Category | int | |
create__changeset_KEY | Client | int | |
create__changeset_KEY | Client_Financial_Data | int | |
create__changeset_KEY | Client_Financial_Data_Description | int | |
create__changeset_KEY | Client_Staff_Grouping | int | |
create__changeset_KEY | Contact | int | |
create__changeset_KEY | Contact_Address | int | |
create__changeset_KEY | Contact_Category | int | |
create__changeset_KEY | Contact_Contact_Category | int | |
create__changeset_KEY | Contact_Email | int | |
create__changeset_KEY | Contact_Phone | int | |
create__changeset_KEY | Custom_Chart | int | |
create__changeset_KEY | Custom_Field | int | |
create__changeset_KEY | Custom_Value | int | |
create__changeset_KEY | Digita_Vat_Period | int | |
create__changeset_KEY | Engagement | int | |
create__changeset_KEY | File_Transfer | int | |
create__changeset_KEY | File_Transfer_Event | int | |
create__changeset_KEY | File_Transfer_File | int | |
create__changeset_KEY | History_Of_Additional_Contact | int | |
create__changeset_KEY | History_Of_Attachment | int | |
create__changeset_KEY | History_Of_Attachment_Content | int | |
create__changeset_KEY | History_Of_Calendar_Category | int | |
create__changeset_KEY | History_Of_Client | int | |
create__changeset_KEY | History_Of_Client_Financial_Data | int | |
create__changeset_KEY | History_Of_Client_Financial_Data_Description | int | |
create__changeset_KEY | History_Of_Client_Staff_Grouping | int | |
create__changeset_KEY | History_Of_Contact | int | |
create__changeset_KEY | History_Of_Contact_Address | int | |
create__changeset_KEY | History_Of_Contact_Category | int | |
create__changeset_KEY | History_Of_Contact_Contact_Category | int | |
create__changeset_KEY | History_Of_Contact_Email | int | |
create__changeset_KEY | History_Of_Contact_Phone | int | |
create__changeset_KEY | History_Of_Custom_Chart | int | |
create__changeset_KEY | History_Of_Custom_Field | int | |
create__changeset_KEY | History_Of_Custom_Value | int | |
create__changeset_KEY | History_Of_Digita_Vat_Period | int | |
create__changeset_KEY | History_Of_Engagement | int | |
create__changeset_KEY | History_Of_File_Transfer | int | |
create__changeset_KEY | History_Of_File_Transfer_Event | int | |
create__changeset_KEY | History_Of_File_Transfer_File | int | |
create__changeset_KEY | History_Of_Link | int | |
create__changeset_KEY | History_Of_Link_Group | int | |
create__changeset_KEY | History_Of_Portal_User | int | |
create__changeset_KEY | History_Of_Project | int | |
create__changeset_KEY | History_Of_Project_Extension | int | |
create__changeset_KEY | History_Of_Schedule_Entry | int | |
create__changeset_KEY | History_Of_Schedule_Item | int | |
create__changeset_KEY | History_Of_Schedule_Item_Assignment | int | |
create__changeset_KEY | History_Of_Schedule_Item_Budget_Remaining_Entry | int | |
create__changeset_KEY | History_Of_Schedule_Item_Series | int | |
create__changeset_KEY | History_Of_Sheet_Entry | int | |
create__changeset_KEY | History_Of_Tag | int | |
create__changeset_KEY | History_Of_Tagged_Item | int | |
create__changeset_KEY | History_Of_Task | int | |
create__changeset_KEY | History_Of_Time_Zone | int | |
create__changeset_KEY | History_Of_Timer | int | |
create__changeset_KEY | Link | int | |
create__changeset_KEY | Link_Group | int | |
create__changeset_KEY | Portal_User | int | |
create__changeset_KEY | Project | int | |
create__changeset_KEY | Project_Extension | int | |
create__changeset_KEY | Schedule_Entry | int | |
create__changeset_KEY | Schedule_Item | int | |
create__changeset_KEY | Schedule_Item_Assignment | int | |
create__changeset_KEY | Schedule_Item_Budget_Remaining_Entry | int | |
create__changeset_KEY | Schedule_Item_Series | int | |
create__changeset_KEY | Sheet_Entry | int | |
create__changeset_KEY | Tag | int | |
create__changeset_KEY | Tagged_Item | int | |
create__changeset_KEY | Task | int | |
create__changeset_KEY | Time_Zone | int | |
create__changeset_KEY | Timer | int | |
create__staff_KEY | History_Of_Link | int | |
create__staff_KEY | Link | int | Key of Staff who created this row. |
create_date | Filter | datetime | |
create_date | Filter_Line | datetime | |
create_date | Filter_Select | datetime | |
create_date_utc | Accruable_Benefit | datetime | |
create_date_utc | Accruable_Benefit_Allowance_By_Month | datetime | |
create_date_utc | Accruable_Benefit_Allowance_By_Staff_Level | datetime | |
create_date_utc | Active_Filter | datetime | |
create_date_utc | Activity | datetime | |
create_date_utc | Activity_Category | datetime | |
create_date_utc | Bank_Account | datetime | |
create_date_utc | Benefit | datetime | |
create_date_utc | Benefit_Factor | datetime | |
create_date_utc | Billing_Decision | datetime | |
create_date_utc | Billing_Decision_Collection | datetime | |
create_date_utc | Billing_Decision_Tax_Collection | datetime | |
create_date_utc | Billing_Decision_Taxing_Authority | datetime | |
create_date_utc | Billing_Rate_Type | datetime | |
create_date_utc | Client_Shortcut | datetime | |
create_date_utc | Client_Shortcut_Group | datetime | |
create_date_utc | Client_Status_Event | datetime | |
create_date_utc | Contact | datetime | |
create_date_utc | Contact_Address | datetime | |
create_date_utc | Contact_Email | datetime | |
create_date_utc | Contact_Phone | datetime | |
create_date_utc | Custom_Fieldview | datetime | |
create_date_utc | Custom_Fieldview_Type | datetime | |
create_date_utc | Custom_Formula | datetime | |
create_date_utc | Custom_Grouping | datetime | |
create_date_utc | Custom_Portlet | datetime | |
create_date_utc | Dashboard_Layout | datetime | |
create_date_utc | Department | datetime | |
create_date_utc | Education_Sponsor | datetime | |
create_date_utc | Engagement_Template | datetime | |
create_date_utc | Engagement_Type | datetime | |
create_date_utc | Entity | datetime | |
create_date_utc | Feed_Channel | datetime | |
create_date_utc | Feed_Channel_Item | datetime | |
create_date_utc | Feed_Channel_Item_Enclosure | datetime | |
create_date_utc | Feed_Channel_Item_Staff_Read | datetime | |
create_date_utc | Feed_Portlet | datetime | |
create_date_utc | Firm | datetime | |
create_date_utc | Firm_Date | datetime | |
create_date_utc | Firm_Shortcut | datetime | |
create_date_utc | Firm_Shortcut_Group | datetime | |
create_date_utc | GL_Entry_Export_Option | datetime | |
create_date_utc | Integration_Application | datetime | |
create_date_utc | Integration_Invoice | datetime | |
create_date_utc | Integration_Invoice_Prior_Payment | datetime | |
create_date_utc | Integration_Sheet_Entry | datetime | |
create_date_utc | Interaction_Link | datetime | |
create_date_utc | Invoice | datetime | |
create_date_utc | Ledger_Entry | datetime | |
create_date_utc | Ledger_Entry_Application | datetime | |
create_date_utc | Ledger_Entry_Service_Charge | datetime | |
create_date_utc | Lost_Reason | datetime | |
create_date_utc | Lost_To | datetime | |
create_date_utc | Monitored_Event | datetime | |
create_date_utc | Monitored_Event_Action | datetime | |
create_date_utc | Observed_Holiday | datetime | |
create_date_utc | Office | datetime | |
create_date_utc | Online_Invoice | datetime | |
create_date_utc | Online_Payment | datetime | |
create_date_utc | Outlook_Contact_Synchronization_Folder | datetime | |
create_date_utc | Outlook_Contact_Synchronization_Profile | datetime | |
create_date_utc | Print_Option | datetime | |
create_date_utc | Project_Template | datetime | |
create_date_utc | Project_Template_Assignment | datetime | |
create_date_utc | Project_Template_Definition | datetime | |
create_date_utc | Project_Template_Definition_Extension | datetime | |
create_date_utc | Project_Template_Definition_Imported | datetime | |
create_date_utc | Project_Template_Entity | datetime | |
create_date_utc | Project_Template_Extension | datetime | |
create_date_utc | Recorded_Event | datetime | |
create_date_utc | Recurring_Bill | datetime | |
create_date_utc | Referral_Source | datetime | |
create_date_utc | Report_Definition | datetime | |
create_date_utc | Report_Definition_Security_Group | datetime | |
create_date_utc | Report_Definition_Update_List | datetime | |
create_date_utc | Report_Image | datetime | |
create_date_utc | Report_Profile | datetime | |
create_date_utc | Report_Profile_Report_Definition | datetime | |
create_date_utc | Schedule_Item | datetime | |
create_date_utc | Security_Group | datetime | |
create_date_utc | Service_Charge | datetime | |
create_date_utc | Staff | datetime | |
create_date_utc | Staff_Area_Rating | datetime | |
create_date_utc | Staff_Benefit | datetime | |
create_date_utc | Staff_Benefit_Entry | datetime | |
create_date_utc | Staff_Billing_Rate | datetime | |
create_date_utc | Staff_Level | datetime | |
create_date_utc | Staff_Locator | datetime | |
create_date_utc | Staff_Rate_Table | datetime | |
create_date_utc | Staff_Report_Definition | datetime | |
create_date_utc | Staff_Security_Group | datetime | |
create_date_utc | Staff_Shortcut | datetime | |
create_date_utc | Staff_Shortcut_Group | datetime | |
create_date_utc | Staff_Skill_Area | datetime | |
create_date_utc | Staff_Skill_Rating | datetime | |
create_date_utc | Standard_Text | datetime | |
create_date_utc | Status_Event | datetime | |
create_date_utc | Status_Event_Type | datetime | |
create_date_utc | Task_Template | datetime | |
create_date_utc | Task_Template_Assignment | datetime | |
create_date_utc | Tax_Area | datetime | |
create_date_utc | Tax_Area_Taxing_Authority | datetime | |
create_date_utc | Taxing_Authority | datetime | |
create_date_utc | Term | datetime | |
create_date_utc | Tracking_Description | datetime | |
create_date_utc | Update_Data_Change_Log | datetime | |
create_date_utc | User_Preference | datetime | |
create_date_utc | Web_Page_Portlet | datetime | |
create_date_utc | Won_Reason | datetime | |
create_file_cabinet_folder_for_new_clients | Firm | bit | Automatically create FileCabinet folder for new clients |
create_machine_name | History_Of_Link | nvarchar (50) | |
create_machine_name | Link | nvarchar (50) | Machine name of the machine on which this link was created |
create_portals_for_new_clients | Firm | bit | Automatically create NetClient CS portals for new Clients |
create_portals_for_new_prospects | Firm | bit | Automatically create NetClient CS portals for new Prospects |
create_portals_for_new_staff | Firm | bit | Automatically create NetStaff CS portals for new Staff |
credit | Education_Credit | decimal (9, 2) | |
credit_card_id | Credit_Card_Type | nvarchar (4) | ID (abbreviation) for the credit card type. |
credit_card_id_sortable | Credit_Card_Type | varchar (48) | A representation of the credit_card_id column that sorts in natural order, meaning that digits are sorted as numbers while non-digits are sorted alphabetically. A trigger keeps this field synchronized with the content of credit_card_id. |
credit_card_KEY | Credit_Card | int | Assigned by COMMON_dp_Allocate_Unique_Identifiers. Database assigned key for this record. |
credit_card_KEY | Ledger_Entry_Submittal | int | Credit card info used in this submittal. |
credit_card_type_KEY | Credit_Card | int | Database assigned key for this credit card type. |
credit_card_type_KEY | Credit_Card_Type | int | Database assigned key for this record. |
credit_memos_gl_account | GL_Entry_Export_Option | nvarchar (60) | |
CSI_firm_ID | Firm | int | |
currency_decimal_digits | Firm | smallint (5) | Number of digits to support on currency values. |
currency_symbol | Firm | nvarchar (3) | Symbol to use for currency values. |
current_due_date_exclusive_utc | History_Of_Schedule_Item | datetime | |
current_due_date_exclusive_utc | Schedule_Item | datetime | Current due date (exclusive) of this schedule item. |
custom_chart_KEY | Custom_Chart | int | Assigned by COMMON_dp_Allocate_Unique_Identifiers. Database assigned primary key for this table. |
custom_chart_KEY | History_Of_Custom_Chart | int | |
custom_chart_type_KEY | Custom_Chart | int | Foriegn key to specify what type this custom chart is. |
custom_chart_type_KEY | History_Of_Custom_Chart | int | |
custom_field_description | Integration_Custom_Value | nvarchar (250) | |
custom_field_KEY | Custom_Field | int | |
custom_field_KEY | Custom_Grouping | int | Key to a Custom Field. |
custom_field_KEY | Custom_Value | int | Key of the Custom field that this value is for. |
custom_field_KEY | History_Of_Custom_Field | int | |
custom_field_KEY | History_Of_Custom_Value | int | |
custom_field_KEY | Integration_Custom_Value | int | |
custom_field_KEY | User_Preference_Custom_Field_Column | int | Key of the Custom Field that this entry is for |
custom_field_slot | Custom_Field | int | Which slot this field is in, used for sorting items by custom field columns. |
custom_field_slot | Custom_Value | int | |
custom_field_slot | History_Of_Custom_Field | int | |
custom_field_slot | History_Of_Custom_Value | int | |
custom_field_type_KEY | Custom_Field | int | Foreign key to specify what data type this column is. |
custom_field_type_KEY | Custom_Value | int | |
custom_field_type_KEY | History_Of_Custom_Field | int | |
custom_field_type_KEY | History_Of_Custom_Value | int | |
custom_field_type_KEY | Integration_Custom_Value | int | |
custom_fieldview_KEY | Custom_Fieldview | int | AUTO-INCREMENT: Database assigned primary key for this table. |
custom_fieldview_type_KEY | Custom_Fieldview | int | Key of an existing of the the Custom Fieldview Type. |
custom_fieldview_type_KEY | Custom_Fieldview_Type | int | AUTO-INCREMENT: Hardcoded primary key. |
custom_formula_data_type_KEY | Custom_Formula | int | Foriegn key to specify what data type this custom formula is. |
custom_formula_KEY | Custom_Formula | int | Assigned by COMMON_dp_Allocate_Unique_Identifiers. Database assigned primary key for this table. |
custom_grouping_id | Custom_Grouping | nvarchar (11) | User defined identifier (unique). |
custom_grouping_id_sortable | Custom_Grouping | varchar (48) | A representation of the custom_grouping_id column that sorts in natural order, meaning that digits are sorted as numbers while non-digits are sorted alphabetically. A trigger keeps this field synchronized with the content of custom_grouping_id. |
custom_grouping_KEY | Custom_Grouping | int | |
custom_portlet_KEY | Custom_Portlet | int | Assigned by COMMON_dp_Allocate_Unique_Identifiers. Key assigned to identify this record. |
custom_portlet_KEY | Feed_Portlet | int | |
custom_portlet_KEY | Report_Based_Portlet | int | Key of the Custom_Portlet row that this table holds additional information for. |
custom_portlet_KEY | Web_Page_Portlet | int | |
custom_portlet_type_KEY | Custom_Portlet | int | Reference to the type of custom portlet that this is. |
custom_portlet_type_KEY | Custom_Portlet_Type | int | Key assigned to identify this record. |
custom_report_layout | Report_Definition | nvarchar (-1) | ActiveReports RPX layout definition. |
custom_value | Custom_Value | nvarchar (4000) | A string representation of the actual value. |
custom_value | History_Of_Custom_Value | nvarchar (4000) | |
custom_value | Integration_Custom_Value | nvarchar (4000) | |
custom_value__custom_grouping_KEY | Custom_Value | int | |
custom_value__custom_grouping_KEY | History_Of_Custom_Value | int | |
custom_value__staff_KEY | Custom_Value | int | |
custom_value__staff_KEY | History_Of_Custom_Value | int | |
custom_value_as_checkbox | Custom_Value | bit | |
custom_value_as_checkbox | History_Of_Custom_Value | bit | |
custom_value_as_date | Custom_Value | datetime | |
custom_value_as_date | History_Of_Custom_Value | datetime | |
custom_value_as_number | Custom_Value | decimal (25, 10) | |
custom_value_as_number | History_Of_Custom_Value | decimal (25, 10) | |
custom_value_KEY | Custom_Value | int | Assigned by COMMON_dp_Allocate_Unique_Identifiers. Primary key for this table. |
custom_value_KEY | History_Of_Custom_Value | int | |
dashboard_layout_KEY | Dashboard_Layout | int | Assigned by COMMON_dp_Allocate_Unique_Identifiers. Primary key for this table |
dashboard_layout_KEY | Firm_Dashboard_Layout | int | Key to the dashboard layout that is to be used. |
dashboard_layout_type_KEY | Dashboard_Layout | int | Type of dashboad layout |
dashboard_layout_type_KEY | Firm_Dashboard_Layout | int | The type of dashboard layout that this firm preference is referring to (Home, Client, Staff, etc). |
database_property_KEY | Database_Property | int | AUTO-INCREMENT: Database assigned primary key for this table. |
datasharing_application_KEY | Datasharing_Path | int | The datasharing application that this path is associated with. |
datasharing_group_KEY | Datasharing_Group | int | Assigned by COMMON_dp_Allocate_Unique_Identifiers. Primary key for this table. This table is used to associate Datasharing_Path rows together |
datasharing_group_KEY | Datasharing_Path | int | Used to associate Datasharing_Path rows together in a group |
datasharing_path_KEY | Datasharing_Path | int | Assigned by COMMON_dp_Allocate_Unique_Identifiers. Primary key for this table |
date_certified | Staff | smalldatetime | Date certified. |
date_education_met | Staff | smalldatetime | Date education met. |
date_exam_passed | Staff | smalldatetime | Date exam passed. |
date_experience_met | Staff | smalldatetime | Date experience met. |
date_hired | Staff | smalldatetime | Date hired. |
date_left | Client | smalldatetime | Date your firm terminated the client/firm relationship. |
date_left | History_Of_Client | smalldatetime | |
date_left | Staff | smalldatetime | Date Staff no longer employed. |
date_opened | Client | smalldatetime | Date the client came to your firm, default system date when a new client is added. |
date_opened | History_Of_Client | smalldatetime | |
days_to_due_date | Client | int | Number of days to be used when calculating a due date in billing. |
days_to_due_date | Firm | int | Number of days to use in calculating due dates. |
days_to_due_date | History_Of_Client | int | |
debit_memos_gl_account | GL_Entry_Export_Option | nvarchar (60) | |
default_alias | Table_Information | nvarchar (128) | The default alias to use for this table. |
default_block_size | COMMON_Unique_Identifier_Counter | int | |
default_options | Staff_Report_Definition | nvarchar (-1) | The default report options in serialized XML format. |
default_report_layout | Report_Definition | nvarchar (100) | Default report layout XML resource. |
default_value | User_Preference_Custom_Field_Column | nvarchar (4000) | The default value for this field in Time and expense entry |
department_grouping_type_KEY | Department_Grouping_Type | int | Primary key for this table. |
department_grouping_type_KEY | Project_Template | int | Key to a Department Grouping Type that indicates how to determine which department will be assigned to generated projects. |
department_id | Department | nvarchar (11) | User defined identifier (unique). |
department_id_sortable | Department | varchar (48) | A representation of the department_id column that sorts in natural order, meaning that digits are sorted as numbers while non-digits are sorted alphabetically. A trigger keeps this field synchronized with the content of department_id. |
department_KEY | Department | int | AUTO-INCREMENT: Database assigned primary key for this table. |
department_KEY | History_Of_Project | int | |
department_KEY | Project | int | Key to a Department that will be used for generated projects. |
department_KEY | Project_Template | int | Key to a Department that will be used for generated projects. |
department_KEY | Staff | int | Key from one of the already set up Departments. |
dependent__privilege_KEY | Privilege_Dependency | int | Foreign key to a [Privilege] that [privilege_KEY] depends on. |
description | Active_Filter | nvarchar (250) | Description of where this filter is being used. |
description | Activity | nvarchar (250) | User defined description. |
description | Activity_Category | nvarchar (250) | User Defined description |
description | Bank_Account | nvarchar (250) | User defined description. |
description | Billing_Rate_Type | nvarchar (250) | User defined description. |
description | Calendar_Category | nvarchar (250) | User defined description. |
description | Client | nvarchar (250) | User defined description. |
description | Client_Financial_Data_Description | nvarchar (100) | unique description of this table |
description | Client_Shortcut | nvarchar (260) | The length of 260 was chosen since it fits within unique constraints and it is the maximum possible length of a file path in Windows. |
description | Client_Shortcut_Group | nvarchar (250) | User-configurable display name for the solution group. |
description | Contact_Category | nvarchar (250) | User defined description. |
description | Credit_Card_Type | nvarchar (20) | Description for this record |
description | Custom_Chart | nvarchar (250) | Description of the custom chart. The same description can only be used once per owner_table_name. |
description | Custom_Field | nvarchar (250) | The decription of this custom field as it would appear in the user interface. The same description can only be used once per table_information_KEY. |
description | Custom_Fieldview | nvarchar (250) | User defined description (unique per custom_fieldview_type_KEY). |
description | Custom_Fieldview_Type | nvarchar (250) | Description of this Custom Fieldview Type. |
description | Custom_Formula | nvarchar (250) | Description of the custom formula. The same description can only be used once per owner_table_name. |
description | Custom_Grouping | nvarchar (250) | User defined description. |
description | Custom_Portlet | nvarchar (250) | Description of the portlet (unique per private__staff_KEY.) |
description | Custom_Portlet_Type | nvarchar (30) | Description. |
description | Dashboard_Layout | nvarchar (250) | User defined description |
description | Department | nvarchar (250) | User defined description. |
description | Department_Grouping_Type | nvarchar (250) | Description. |
description | Education_Accountancy | nvarchar (50) | |
description | Education_Accountancy_Category | nvarchar (50) | |
description | Education_Accountancy_Type | nvarchar (50) | |
description | Education_Sponsor | nvarchar (250) | User defined description. |
description | Engagement | nvarchar (250) | User defined description. |
description | Engagement_Template | nvarchar (250) | User defined description. |
description | Engagement_Type | nvarchar (250) | User Defined description |
description | Entity | nvarchar (250) | User Defined description |
description | Event_Class_Type | nvarchar (30) | Practice-defined description (unique). |
description | Filter | nvarchar (250) | User defined description (unique per filter_type_KEY). |
description | Filter_Base_Type | nvarchar (300) | Description that is presented to the user. |
description | Filter_Line_Type | nvarchar (30) | The description of this type of critera (overridden by Filter Base Type). |
description | Filter_Range_Type | nvarchar (30) | Name of this range as it should appear to the user. |
description | Filter_Type | nvarchar (30) | User friendly name for this type of filter. |
description | Firm_Date_Type | nvarchar (250) | User defined description (unique). |
description | Firm_Shortcut | nvarchar (260) | The length of 260 was chosen since it fits within unique constraints and it is the maximum possible length of a file path in Windows. |
description | Firm_Shortcut_Group | nvarchar (250) | User-configurable display name for the solution group. |
description | GL_Entry_Export_Type | nvarchar (30) | |
description | History_Action | nvarchar (30) | What action took place to create a history record. |
description | History_Of_Calendar_Category | nvarchar (250) | |
description | History_Of_Client | nvarchar (250) | |
description | History_Of_Client_Financial_Data_Description | nvarchar (100) | |
description | History_Of_Contact_Category | nvarchar (250) | |
description | History_Of_Custom_Chart | nvarchar (250) | |
description | History_Of_Custom_Field | nvarchar (250) | |
description | History_Of_Engagement | nvarchar (250) | |
description | History_Of_Link | nvarchar (260) | |
description | History_Of_Link_Group | nvarchar (260) | |
description | History_Of_Schedule_Item | nvarchar (250) | |
description | History_Of_Tag | nvarchar (250) | |
description | Integration_Application | nvarchar (250) | User defined description (unique). |
description | Integration_Invoice_Prior_Payment | nvarchar (250) | Description of the payment. |
description | Interaction_Association | nvarchar (250) | The type of association that a Contact has to an Interaction. |
description | Interaction_Subtype | nvarchar (250) | Description (unique per interaction_type_KEY). |
description | Ledger_Entry_Subtype | nvarchar (30) | Description (unique per ledger_entry_type_KEY). |
description | Ledger_Entry_Type | nvarchar (250) | User defined description (unique). |
description | Link | nvarchar (260) | User-configurable name of this link |
description | Link_Group | nvarchar (260) | The user-configurable name of this group |
description | Lost_Reason | nvarchar (250) | User defined description (unique). |
description | Lost_To | nvarchar (250) | User defined description (unique). |
description | Month_Info | nvarchar (250) | The name of the month (January, December, etc.) |
description | Observed_Holiday | nvarchar (250) | Description of the holiday. |
description | Office | nvarchar (250) | User defined description. |
description | Option_List | nvarchar (250) | |
description | Priority | nvarchar (250) | User defined description (unique). |
description | Privilege | nvarchar (50) | This is the description that users will see. |
description | Project_Template | nvarchar (250) | User defined description. |
description | Project_Template_Definition | nvarchar (250) | User defined description. |
description | Recurrence_Expiration_Method | nvarchar (250) | User defined description (unique). |
description | Recurrence_Generation_Method | nvarchar (250) | User defined description (unique). |
description | Recurrence_Method | nvarchar (250) | User defined description (unique). |
description | Recurring_Bill | nvarchar (250) | User defined description (unique). |
description | Referral_Source | nvarchar (250) | User defined description (unique). |
description | Report_Category | nvarchar (30) | User defined description (unique). |
description | Report_Definition | nvarchar (250) | User defined description. |
description | Report_Profile | nvarchar (250) | User defined description (unique). |
description | Schedule_Item | nvarchar (250) | User defined description. |
description | Security_Group | nvarchar (250) | User defined identifier (unique). |
description | Service_Charge | nvarchar (250) | User defined description (unique). |
description | Staff | nvarchar (250) | User defined description. |
description | Staff_Grouping_Type | nvarchar (250) | User defined description (unique). |
description | Staff_Level | nvarchar (250) | User defined description. |
description | Staff_Shortcut | nvarchar (260) | The length of 260 was chosen since it fits within unique constraints and it is the maximum possible length of a file path in Windows. |
description | Staff_Shortcut_Group | nvarchar (260) | User-configurable display name for the solution group. |
description | Staff_Skill_Area | nvarchar (250) | User defined description (unique). |
description | Staff_Skill_Rating | nvarchar (250) | User defined description (unique). |
description | Status_Event | nvarchar (50) | User defined description (unique). |
description | Status_Event_Type | nvarchar (250) | User defined description (unique). |
description | Tag | nvarchar (250) | The tag text. |
description | Target_Date_Method | nvarchar (250) | User defined description (unique). |
description | Task_Template | nvarchar (250) | |
description | Tax_Area | nvarchar (250) | Describes a Tax Area |
description | Taxing_Authority | nvarchar (250) | Description for this Taxing Authority |
description | Term | nvarchar (50) | System description. |
description | Tracking_Description | nvarchar (250) | User defined description (unique). |
description | Won_Reason | nvarchar (250) | User defined description (unique). |
details | Monitored_Event | nvarchar (-1) | XML blob with details about testing for the event that aren't practical to store in column form. |
details | Recorded_Event | nvarchar (-1) | XML blob that contains raw data upon which the event was based, probably the essence of the Montored_Event record as well as details about the specific occurrence. |
digit_KEY | Digit | tinyint (3) | Holds the values 0 to 9. Named for backwards compatibility. |
digita_entityid | Contact | uniqueidentifier | The entity id is a unique identifier which is used to identify the same entity across products. Each product may have their own primary or identifying key for an entity. This identifier allows data for the same entity to flow between applications. |
digita_entityid | History_Of_Contact | uniqueidentifier | |
digita_integration_config | Firm | nvarchar (-1) | The digita integration config is a block of xml (serialized object) which describes the configuration of digita integration. |
digita_metadata | Contact | nvarchar (-1) | The metadata is a block of xml (serialized object) which describes the scope of the entities data this product is interested in. This reduces the number of phantom changes being fired when changes are outside of the scope. |
digita_metadata | History_Of_Contact | nvarchar (-1) | |
digita_out_of_date | Client | bit | Flag that is set when changes are detected to the entity that have not been applied to this database. |
digita_out_of_date | History_Of_Client | bit | |
digita_proforma__ledger_entry_KEY | Ledger_Entry | int | The new key for the digita proforma ledger entry related to this ledger entry. |
digita_tax_point_date_override | Ledger_Entry | datetime | Allows entry_date to be overridden as the tax point. |
digita_using_continuous_supply | Firm | bit | The digita using continuous supply field is a flag which specifies whether or not the user is using continuous supply of service. |
digita_vat_period_KEY | Digita_Vat_Period | int | |
digita_vat_period_KEY | History_Of_Digita_Vat_Period | int | |
digita_vat_period_KEY | Ledger_Entry | int | The key for the closed digita VAT period. |
discount | Billing_Decision | decimal (9, 2) | Discount applied to this item. |
discount | Client_Date_Cache | decimal (9, 2) | discount sum for the Client, principal Client, and entry date |
discount | Integration_Invoice | decimal (17, 2) | The discount amount on this integration_invoice (always 0 or negative.) |
discount | Invoice | decimal (17, 2) | The discount amount on this invoice (always 0 or negative.) |
discount_collected | Billing_Decision_Collection | decimal (9, 2) | The amount collected for the discount of the Billing_Decision. |
dismissed_date_utc | Recorded_Event_Notification | datetime | Date recipent dismissed (don't show me this again) the notification in UTC. |
display_as | Contact_Email | nvarchar (320) | |
display_as | History_Of_Contact_Email | nvarchar (320) | |
due_date | History_Of_Project_Extension | smalldatetime | |
due_date | Integration_Invoice | smalldatetime | Due date |
due_date | Invoice | smalldatetime | Due date |
due_date | Project_Extension | smalldatetime | Current due date of this extension. |
due_date_based_on_fiscal_year_end | Project_Template_Definition | bit | When the value is 1 the due date is adjusted for the Client's fiscal year end. |
due_date_must_occur_on_weekdays | Project_Template_Definition | bit | When the value is 1 the due date is adjusted so that it does not fall on a weekend. |
education_accountancy_category_KEY | Education_Accountancy_Category | int | |
education_accountancy_category_KEY | Education_Credit | int | |
education_accountancy_KEY | Education_Accountancy | int | |
education_accountancy_KEY | Education_Accountancy_Category | int | |
education_accountancy_KEY | Education_Accountancy_Type | int | |
education_accountancy_KEY | Education_Credit | int | |
education_accountancy_type_KEY | Education_Accountancy_Type | int | |
education_accountancy_type_KEY | Education_Credit | int | |
education_course__schedule_item_KEY | History_Of_Sheet_Entry | int | |
education_course__schedule_item_KEY | Sheet_Entry | int | Optionally links this Sheet Entry to a [Education_Course] row. |
education_credit_KEY | Education_Credit | int | |
education_delivery_format_KEY | History_Of_Schedule_Item | int | |
education_delivery_format_KEY | Schedule_Item | int | |
education_sponsor_id | Education_Sponsor | nvarchar (11) | User defined identifier (unique). |
education_sponsor_id_sortable | Education_Sponsor | varchar (48) | A representation of the education_sponsor_id column that sorts in natural order, meaning that digits are sorted as numbers while non-digits are sorted alphabetically. A trigger keeps this field synchronized with the content of education_sponsor_id. |
education_sponsor_KEY | Education_Sponsor | int | AUTO-INCREMENT: Database assigned primary key for this table. |
education_sponsor_KEY | History_Of_Schedule_Item | int | |
education_sponsor_KEY | Schedule_Item | int | |
effective_date | Staff_Benefit | smalldatetime | The effective date of this staff benefit. |
effective_date | Staff_Rate_Table | smalldatetime | The date this rate table becomes effective. |
elapsed_seconds | History_Of_Timer | int | |
elapsed_seconds | Timer | int | The number of seconds this timer ran before it was stopped, or 0 if it is still running. |
Contact_Email | nvarchar (320) | E-mail address. | |
History_Of_Contact_Email | nvarchar (320) | ||
email_address | Email_Address | nvarchar (320) | Each e-mail address must be unique and stored as lower case. It is expected that the e-mail address look like "user.name@place.net" |
email_address | History_Of_Portal_User | nvarchar (150) | |
email_address | Portal_User | nvarchar (150) | email address associated with this portal |
email_address_field | Interaction_Email_Address | varchar (4) | The e-mail address field this link came from (Bcc, Cc, From or To.) |
email_address_KEY | Email_Address | int | Assigned by COMMON_dp_Allocate_Unique_Identifiers. A unique value assigned to this e-mail address so that linking to this e-mail address uses only 4 bytes. |
email_address_KEY | Interaction_Email_Address | int | A reference to one of the e-mail addresses stored in the Email_Address table. |
email_output_type | Print_Option | int | The type of file format to email reports in. |
email_position | Contact | nvarchar (6) | Semicolon seperated list of contact_email_type_KEY values indicating the user's preferred order of displaying e-mail addresses. |
email_position | History_Of_Contact | nvarchar (6) | |
email_recipients | Print_Option | nvarchar (-1) | The email recipients. |
email_save_drafts | Print_Option | bit | Save e-mails to Drafts folder (do not send). |
email_staff | Monitored_Event_Action | bit | Indicates whether all staff specified by this record should be emailed when the event occurs. |
enable_ach_processing | Firm | bit | Whether or not Ach Processing is enabled. |
enable_automatic_import | Outlook_Contact_Synchronization_Profile | bit | Determines if contacts added in Outlook? should automatically be added to the database without user intervention. |
enable_credit_card_processing | Firm | bit | Whether or not Credit Card Processing is enabled. |
enable_desktop_alerts_for_notifications | User_Preference | bit | Enables desktop alerts for notifications. |
enabled | Outlook_Contact_Synchronization_Folder | bit | true if this profile is to be used to export contacts when the Sync button is pushed. |
end_date | Digita_Vat_Period | datetime | The end date for the VAT period. |
end_date | History_Of_Digita_Vat_Period | datetime | |
end_date | History_Of_Portal_User | datetime | |
end_date | Portal_User | datetime | time at which the portal server was made inactive |
end_date_utc | Changeset | datetime | When this changeset was ended. This is as close to the commit time of the transaction as possible. |
ending_date | Firm_Date | smalldatetime | Date that this period ends. |
ending_date | Staff_Target_Range | smalldatetime | REDUNDANT: For backwards compatibility and ease of display on reports and screens, this is 24 hours prior to the [upper_date_exclusive]. |
engagement | Gofileroom_Workflow | nvarchar (255) | GoFileRoom engagement of this workflow. |
engagement_KEY | Engagement | int | Assigned by COMMON_dp_Allocate_Unique_Identifiers. Database assigned primary key for this table |
engagement_KEY | History_Of_Engagement | int | |
engagement_KEY | History_Of_Schedule_Item | int | |
engagement_KEY | History_Of_Sheet_Entry | int | |
engagement_KEY | Integration_Sheet_Entry | int | Key to the Engagement this entry is for. |
engagement_KEY | Schedule_Item | int | The linked [Engagement]. |
engagement_KEY | Sheet_Entry | int | Key to the Engagement this entry is for. |
engagement_status_KEY | Engagement | int | Key to a Engagement Status record. |
engagement_status_KEY | History_Of_Engagement | int | |
engagement_surcharge_method_KEY | Engagement | int | Key to an Engagement Surcharge Method record. (1=No surcharge, 2=Based on Activity, 3=Flat amount) |
engagement_surcharge_method_KEY | History_Of_Engagement | int | |
engagement_template_id | Engagement_Template | nvarchar (11) | User defined identifier (unique). |
engagement_template_id_sortable | Engagement_Template | varchar (48) | A representation of the engagement_template_id column that sorts in natural order, meaning that digits are sorted as numbers while non-digits are sorted alphabetically. A trigger keeps this field synchronized with the content of engagement_template_id. |
engagement_template_KEY | Engagement | int | Key to a Engagement Template record. |
engagement_template_KEY | Engagement_Template | int | AUTO-INCREMENT: Database assigned primary key for this table. |
engagement_template_KEY | History_Of_Engagement | int | |
engagement_template_KEY | Project_Template | int | Key to a Engagement Template that will be used for generated projects. |
engagement_type_id | Engagement_Type | nvarchar (11) | User defined identifier (unique). |
engagement_type_id_sortable | Engagement_Type | varchar (48) | A representation of the engagement_type_id column that sorts in natural order, meaning that digits are sorted as numbers while non-digits are sorted alphabetically. A trigger keeps this field synchronized with the content of engagement_type_id. |
engagement_type_KEY | Engagement | int | Key to a Engagement Type record. |
engagement_type_KEY | Engagement_Type | int | AUTO-INCREMENT: Database assigned primary key for this table |
engagement_type_KEY | History_Of_Engagement | int | |
enter_as_tab | User_Preference | bit | Enter key functions as Tab |
entity | Integration_Invoice | nvarchar (11) | Entity as defined by the exporting applciation. |
entity_id | Entity | nvarchar (11) | User defined identifier (unique). |
entity_id_sortable | Entity | varchar (48) | A representation of the entity_id column that sorts in natural order, meaning that digits are sorted as numbers while non-digits are sorted alphabetically. A trigger keeps this field synchronized with the content of entity_id. |
entity_KEY | Client | int | Key to an Entity record. |
entity_KEY | Entity | int | AUTO-INCREMENT: Database assigned primary key for this table |
entity_KEY | History_Of_Client | int | |
entity_KEY | Project_Template_Entity | int | Key to an Entity record. |
entry__client_KEY | User_Preference | int | Key of one of the Client records |
entry__engagement_template_KEY | User_Preference | int | Key of one of the Engagement Template records |
entry__rounding_method_KEY | User_Preference | int | Key of one of the Rounding Method records |
entry__time_style_KEY | User_Preference | int | Key of one of the Time Style records |
entry__user_preference_default_entry_date_KEY | User_Preference | int | Key of one of the User Preference Default Entry Date records |
entry__user_preference_default_sheet_date_KEY | User_Preference | int | Key of one of the User Preference Default Sheet Date records |
entry_accumulate_time_before_rounding | User_Preference | bit | |
entry_activity_description_hide | User_Preference | bit | |
entry_allow_simultaneous_timers | User_Preference | bit | Allow as many timers running at the same time as they want. |
entry_auto_check_spelling | User_Preference | bit | |
entry_auto_fill_from_last | User_Preference | bit | |
entry_biller_note | User_Preference | nvarchar (-1) | Default biller note for each entry |
entry_biller_note_hide | User_Preference | bit | Hides the Biller Note column |
entry_biller_note_skip | User_Preference | bit | Skips the Biller Note column |
entry_client_description_hide | User_Preference | bit | |
entry_client_hide | User_Preference | bit | Hides the Client column |
entry_client_skip | User_Preference | bit | Skips the Client column |
entry_comment | User_Preference | nvarchar (-1) | Default comment for each entry |
entry_comment_hide | User_Preference | bit | Hides the Comment column |
entry_comment_skip | User_Preference | bit | Skips the Comment column |
entry_custom_fields_hide | User_Preference | bit | |
entry_custom_fields_skip | User_Preference | bit | |
entry_date | Client_Date_Cache | smalldatetime | Entry date that the sums are associated with. |
entry_date | History_Of_Schedule_Item_Budget_Remaining_Entry | smalldatetime | |
entry_date | History_Of_Sheet_Entry | smalldatetime | |
entry_date | Integration_Sheet_Entry | smalldatetime | Date this entry is for. |
entry_date | Ledger_Entry | smalldatetime | Date of this item (check date, invoice date, receipt date). |
entry_date | Schedule_Item_Budget_Remaining_Entry | smalldatetime | The date that this row was entered. |
entry_date | Sheet_Entry | smalldatetime | Date this entry is for. |
entry_date | Staff_Benefit_Entry | smalldatetime | The date that this entry corresponds to. |
entry_date_hide | User_Preference | bit | Hides the Date column |
entry_date_skip | User_Preference | bit | Skips the Date column |
entry_date_utc | Client_Financial_Data | datetime | The date the integration application provided this data, in UTC. |
entry_date_utc | History_Of_Client_Financial_Data | datetime | |
entry_date_utc | Interaction | datetime | Date and time of this interaction in UTC. |
entry_display_billed | User_Preference | bit | Displays billed entries |
entry_display_custom_fields | User_Preference | bit | |
entry_display_education_course_selection | User_Preference | bit | |
entry_display_hash_totals | User_Preference | bit | Displays hash totals |
entry_display_task_selection | User_Preference | bit | Automatically displays the task selection screen after the project is selected |
entry_education_course_selection_hide | User_Preference | bit | |
entry_education_course_selection_skip | User_Preference | bit | |
entry_engagement_description_hide | User_Preference | bit | |
entry_engagement_template_hide | User_Preference | bit | Hides the Engagement column |
entry_engagement_template_skip | User_Preference | bit | Skips the Engagement column |
entry_expense__activity_KEY | User_Preference | int | Key of one of the Activity records for expenses |
entry_expense__billing_rate_type_KEY | User_Preference | int | Default rate for expense |
entry_expense_activity_hide | User_Preference | bit | Hides the Activity column for expenses |
entry_expense_activity_skip | User_Preference | bit | Skips the Activity column for expenses |
entry_expense_rate_hide | User_Preference | bit | Hides the Rate column for time |
entry_expense_rate_skip | User_Preference | bit | Skips the Rate column for time |
entry_id | Outlook_Contact_Synchronization_Folder | varbinary (4096) | Holds the binary value of the Outlook? EntryID. Convert to a hexadecimal string without the 0x prefix (2 characters for each byte) the COM interface representation. |
entry_id | Outlook_Index_Folder_Firm | varbinary (4096) | Holds the binary value of the Outlook(R) EntryID. Convert to a hexadecimal string without the 0x prefix (2 characters for each byte) the COM interface representation. |
entry_id | Outlook_Item | varbinary (4096) | Holds the binary value of the Outlook(R) EntryID. Convert to a hexadecimal string without the 0x prefix (2 characters for each byte) the COM interface representation. |
entry_id_checksum | Outlook_Contact_Synchronization_Folder | int | |
entry_id_checksum | Outlook_Index_Folder_Firm | int | Since the entry_id column is wider than 900 bytes, the SQL Server CHECKSUM function is used to compute an indexable column. |
entry_id_checksum | Outlook_Item | int | |
entry_implied_decimal | User_Preference | bit | Automatically inserts decimal point at end of hours |
entry_new_row_at_top | User_Preference | bit | Shows the new row at the top when true, at the bottom when false. |
entry_number | Ledger_Entry | int | Each entry will be assigned a number that is unique by Ledger Entry Type that the user can select. |
entry_project_description_hide | User_Preference | bit | |
entry_project_solution_button_hide | User_Preference | bit | When true the project solution button column in time entry will be hidden |
entry_project_solution_button_skip | User_Preference | bit | When true the project solution button column in time entry will be skipped |
entry_project_template_hide | User_Preference | bit | Specifies Project field is to be hidden on the Time and Expense Entry screen |
entry_project_template_skip | User_Preference | bit | Specifies Project field is to be skipped on the Time and Expense Entry screen |
entry_remote_time_entry__filter_KEY | User_Preference | int | KEY of the filter used to narrow the clients being exported for Remote Entry |
entry_remote_time_entry_enabled | User_Preference | bit | Enables the ability to use the quick Remote Entry export feature |
entry_rounding_increment | User_Preference | decimal (4, 2) | Increment for rounding time from the timer in hours |
entry_sheet_date_skip | User_Preference | bit | Skips the SheetDate entry field on the entry screen. |
entry_staff_description_hide | User_Preference | bit | When true the staff description column in time entry will be hidden |
entry_start_phone_timers | User_Preference | bit | Specifies if timers are to be started when solutions are launched from Phone Calls |
entry_start_project_timers | User_Preference | bit | Specifies if timers are to be started when solutions are launched from Projects/Tasks |
entry_startup_tab | User_Preference | nvarchar (100) | Which tab to start on. |
entry_task_hide | User_Preference | bit | When true the task dropdown column in time entry will be hidden |
entry_task_selection_button_hide | User_Preference | bit | When true the task selection button column in time entry will be hidden |
entry_task_selection_button_skip | User_Preference | bit | When true the task selection button column in time entry will be skipped |
entry_task_skip | User_Preference | bit | When true the task dropdown column in time entry will be skipped |
entry_task_solution_button_hide | User_Preference | bit | When true the task solution button column in receipt entry will be hidden |
entry_task_solution_button_skip | User_Preference | bit | When true the task solution button column in time entry will be skipped |
entry_time__activity_KEY | User_Preference | int | Key of one of the Activity records for time |
entry_time__billing_rate_type_KEY | User_Preference | int | Default rate for time |
entry_time_activity_hide | User_Preference | bit | Hides the Activity column for time |
entry_time_activity_skip | User_Preference | bit | Skips the Activity column for time |
entry_time_rate_hide | User_Preference | bit | Hides the Rate column for time |
entry_time_rate_skip | User_Preference | bit | Skips the Rate column for time |
entry_timer_hide | User_Preference | bit | Hides the Timer Column |
entry_timer_skip | User_Preference | bit | Skips the Timer column |
errorcode | Ledger_Entry_Submittal_Result | nvarchar (6) | Contents of the errorcode field in the response returned by Intercept. |
errordesc | Ledger_Entry_Submittal_Result | nvarchar (200) | Contents of the errordesc field in the response returned by Intercept. |
event_class_property_type_KEY | Monitored_Event | int | Key of property type for the given object type. |
event_class_type_KEY | Event_Class_Type | int | Primary key for this table. |
event_class_type_KEY | Monitored_Event | int | Key of object type. |
event_class_type_KEY | Recorded_Event | int | Key of object type affected by the event. |
event_date_utc | Client_Status_Event | datetime | The date and time the status event was recorded in UTC. |
event_date_utc | File_Transfer_Event | datetime | The time at which this event occurred |
event_date_utc | History_Of_File_Transfer_Event | datetime | |
event_type_KEY | Monitored_Event | int | Key of the event type that's being monitored. |
event_type_KEY | Recorded_Event | int | Key of event type that occurred. |
expense_amount_adjusted | Invoice | decimal (17, 2) | Denormalized |
expense_amount_billed | Integration_Invoice | decimal (17, 2) | If the exporting application understands time and expense, the amount of the invoice that should be matched up with expense. (Optional) |
expense_amount_billed | Invoice | decimal (17, 2) | Denormalized |
expiration_date | History_Of_Portal_User | datetime | |
expiration_date | Portal_User | datetime | If a value exists then this portal is a temporary type portal and will expire at this time |
expiration_date | User_Session | datetime | The date and time that this session will expire in UTC. |
expiration_date_utc | File_Transfer | datetime | date that this File Transfer will no longer be available on the Portal server |
expiration_date_utc | History_Of_File_Transfer | datetime | |
expiration_date_utc | History_Of_Schedule_Item_Series | smalldatetime | |
expiration_date_utc | Schedule_Item_Series | smalldatetime | Indicates the ending date of this series or null if none. |
expiration_month | Credit_Card | int | Credit card expiration date month |
expiration_occurrences | History_Of_Schedule_Item_Series | int | |
expiration_occurrences | Schedule_Item_Series | int | Indicates the ending number of occurrences or 0 if none. |
expiration_year | Credit_Card | int | Credit card expiration date year |
expires_utc | Login_Ticket | datetime | A timestamp after which the ticket should be considered invalid and can be deleted. |
extension | Contact_Phone | nvarchar (5) | Extension. |
extension | History_Of_Contact_Phone | nvarchar (5) | |
extension | Interaction_Phone_Number | nvarchar (5) | Extension. |
extension_day | Project_Template_Definition_Extension | int | Days to extend the project. |
extension_day | Project_Template_Extension | int | Days to extend the project. |
extension_event | History_Of_Project | nvarchar (50) | |
extension_event | Project | nvarchar (50) | Description of a "User" type client status event that will cause this [Project] to be extended. |
extension_event | Project_Template | nvarchar (50) | Description of a "User" type client status event that will cause this [Project] to be extended. |
extension_month | Project_Template_Definition_Extension | int | Months to extend the project. |
extension_month | Project_Template_Extension | int | Months to extend the project. |
extension_number | History_Of_Project | int | |
extension_number | History_Of_Project_Extension | int | |
extension_number | Project | int | Number of the current extension. 0=not extended, 1=first extension, etc. We expect to find a record in dbo.Project_Extension with this project_KEY and extension_number but not absolutely required (weak relationship). |
extension_number | Project_Extension | int | Number of this extension (unique per project_KEY). Extension 0 is the original due date. |
extension_number | Project_Template_Definition_Extension | int | Number of this extension (unique per project_template_definition_KEY). |
extension_number | Project_Template_Extension | int | Number of this extension (unique per project_template_KEY). |
factor | Benefit_Factor | decimal (9, 2) | The allowance benefit factor. |
fcs__client_KEY | Print_Option | int | The client whose drawer reports will be output to. |
fcs__staff_KEY | Print_Option | int | The staff whose drawer reports will be output to. |
fcs_create_link | Print_Option | bit | |
fcs_data_location | Print_Option | nvarchar (260) | FileCabinet Solution data location to output to. |
fcs_file_by_type | Print_Option | int | How to file a report (e.g., by the firm's current-year-end date). |
fcs_firm_data | Print_Option | bit | Send to firm drawer. |
federal_tin | Client | nvarchar (11) | This field will hold the Fed Tax ID if the client is a non-individual, it will hold the taxpayer SSN for individual clients. |
federal_tin | Firm | nvarchar (11) | This field will hold the Fed Tax ID of the firm. |
federal_tin | History_Of_Client | nvarchar (11) | |
feed_channel_item_enclosure_KEY | Feed_Channel_Item_Enclosure | int | |
feed_channel_item_guid | Feed_Channel_Item | uniqueidentifier | |
feed_channel_item_KEY | Feed_Channel_Item | int | |
feed_channel_item_KEY | Feed_Channel_Item_Enclosure | int | |
feed_channel_item_KEY | Feed_Channel_Item_Staff_Read | int | |
feed_channel_item_staff_read_KEY | Feed_Channel_Item_Staff_Read | int | |
feed_channel_KEY | Feed_Channel | int | |
feed_channel_KEY | Feed_Channel_Item | int | |
feed_channel_KEY | Feed_Portlet | int | |
feed_portlet_KEY | Feed_Portlet | int | |
field_name | Monitored_Event_Action | nvarchar (128) | Field in table_name that specifies entity to notify. |
file_as | Contact | nvarchar (250) | Name as it appears in Outlook's "File as" |
file_as | History_Of_Contact | nvarchar (250) | |
file_cabinet_data_location_for_new_clients | Firm | nvarchar (2048) | Data path of the FileCabinet in which to create a FileCabinet folder for new clients |
file_count | File_Transfer | int | number of files associated to this File Transfer |
file_count | History_Of_File_Transfer | int | |
file_create_link | Print_Option | bit | |
file_destination | Print_Option | nvarchar (260) | The path to output reports to. |
file_name | File_Transfer_File | nvarchar (260) | File name of this file |
file_name | History_Of_File_Transfer_File | nvarchar (260) | |
file_output_type | Print_Option | int | The type of file format to output reports to. |
file_path | Report_Image | nvarchar (260) | |
file_size | File_Transfer_Event | int | File size of the file associated with this event, if any |
file_size | File_Transfer_File | int | File size of this file |
file_size | History_Of_File_Transfer_Event | int | |
file_size | History_Of_File_Transfer_File | int | |
file_transfer_create_date_utc | File_Transfer | datetime | date that this File Transfer was created |
file_transfer_create_date_utc | History_Of_File_Transfer | datetime | |
file_transfer_event_KEY | File_Transfer_Event | int | Assigned by COMMON_dp_Allocate_Unique_Identifiers. Unique and immutable primary key of this event provided by the Portal server which is also used as this table's primary key |
file_transfer_event_KEY | History_Of_File_Transfer_Event | int | |
file_transfer_event_KEY | Interaction | int | File Transfer event that this Interaction was created for |
file_transfer_event_type_KEY | File_Transfer_Event | int | Type of event |
file_transfer_event_type_KEY | History_Of_File_Transfer_Event | int | |
file_transfer_file_KEY | File_Transfer_Event | int | File associated with this event, if any |
file_transfer_file_KEY | File_Transfer_File | int | unique and immutable primary key of this file provided by the Portal server which is also used as this table's primary key |
file_transfer_file_KEY | History_Of_File_Transfer_Event | int | |
file_transfer_file_KEY | History_Of_File_Transfer_File | int | |
file_transfer_file_signature_status_KEY | File_Transfer_File | int | Status of the signature request for this file, if any |
file_transfer_file_signature_status_KEY | History_Of_File_Transfer_File | int | |
file_transfer_file_status_KEY | File_Transfer_File | int | Status of this File |
file_transfer_file_status_KEY | History_Of_File_Transfer_File | int | |
file_transfer_KEY | File_Transfer | int | unique and immutable primary key of this file transfer provided by the Portal server which is also used as this table's primary key |
file_transfer_KEY | File_Transfer_Event | int | File Transfer that this file is a part of |
file_transfer_KEY | File_Transfer_File | int | File Transfer that this file is a part of |
file_transfer_KEY | History_Of_File_Transfer | int | |
file_transfer_KEY | History_Of_File_Transfer_Event | int | |
file_transfer_KEY | History_Of_File_Transfer_File | int | |
file_transfer_status_KEY | File_Transfer | int | current status of this File Transfer |
file_transfer_status_KEY | History_Of_File_Transfer | int | |
file_transfer_type_KEY | File_Transfer | int | The type of File Transfer |
file_transfer_type_KEY | History_Of_File_Transfer | int | |
filter_base_type_KEY | Filter_Base_Type | int | Database assigned primary key for this table. |
filter_base_type_KEY | Filter_Line | int | What this line is based on. |
filter_by_dashboard_context | Report_Based_Portlet | bit | |
filter_column | Filter_Base_Type | nvarchar (512) | Name of the property in Filter_Type.list_name that values will be compared to. |
filter_KEY | Active_Filter | int | Key to the Filter being used for this Staff and description. |
filter_KEY | Filter | int | AUTO-INCREMENT: Database assigned primary key for this table. |
filter_KEY | Filter_Line | int | Key to the Filter that this Line is for. |
filter_KEY | Outlook_Contact_Synchronization_Folder | int | Reference to a Contact filter used to define which Contacts to send to Outlook? as part of the synchronization. |
filter_line_KEY | Filter_Line | int | AUTO-INCREMENT: Database assigned primary key for this table. |
filter_line_KEY | Filter_Select | int | Key of the Filter Line this value is for. |
filter_line_type_KEY | Filter_Base_Type | int | Key to the type of criteria that this Filter Base Type uses. |
filter_line_type_KEY | Filter_Line_Type | int | Database assigned primary key for this table. |
filter_line_type_KEY | Filter_Range_Type | int | Key to the Filter Line Type this Range Type belongs to. |
filter_range_type_KEY | Filter_Line | int | If the method is Range, Key to a valid range for this base; otherwise null. |
filter_range_type_KEY | Filter_Range_Type | int | Database assigned primary key for this table. |
filter_select_KEY | Filter_Select | int | AUTO-INCREMENT: Database assigned primary key for this table. |
filter_type_KEY | Filter | int | Key to a Filter Type record. |
filter_type_KEY | Filter_Base_Type | int | Key to the Filter Type that this Filter Base Type belongs to. |
filter_type_KEY | Filter_Type | int | Primary key for this table. |
financial_value | Client_Financial_Data | decimal (25, 6) | Whole percentages or whole dollar amounts |
financial_value | History_Of_Client_Financial_Data | decimal (25, 6) | |
financial_value_format | Client_Financial_Data_Description | nvarchar (100) | description of the format |
financial_value_format | History_Of_Client_Financial_Data_Description | nvarchar (100) | |
firm_alias | Firm | nvarchar (50) | |
firm_dashboard_layout | User_Preference | nvarchar (-1) | Layout of the Firm Dashboard stored as XML |
firm_dashboard_layout_KEY | Firm_Dashboard_Layout | int | Artificial key column created to make this table more compatible with the DAL. |
firm_date_KEY | Firm_Date | int | AUTO-INCREMENT: Database assigned primary key for this table. |
firm_date_type_KEY | Firm_Date | int | Key to a Firm Date Type row (1=Year, 2=Period). |
firm_date_type_KEY | Firm_Date_Type | int | Database assigned primary key for this table. |
firm_id | History_Of_Portal_User | int | |
firm_id | Portal_User | int | The firm id in the license file at the time this record was last modified. |
firm_KEY | Firm | int | Database assigned primary key for this table. |
firm_KEY | Firm_Dashboard_Layout | int | Key to the Firm that these preferences are for. |
firm_KEY | GL_Entry_Export_Option | int | |
firm_KEY | Outlook_Index_Folder_Firm | int | A reference to one of the Firm rows. |
firm_shortcut_group_KEY | Firm_Shortcut | int | Associates this solution with its solution group. |
firm_shortcut_group_KEY | Firm_Shortcut_Group | int | Assigned by COMMON_dp_Allocate_Unique_Identifiers. Database assigned primary key for this table |
firm_shortcut_KEY | Firm_Shortcut | int | Assigned by COMMON_dp_Allocate_Unique_Identifiers. Database assigned primary key for this table |
first_name | History_Of_Portal_User | nvarchar (70) | |
first_name | Portal_User | nvarchar (70) | first name of person associated with this portal |
first_name | Staff | nvarchar (30) | The first name of this Staff. |
fiscal_year_end | Integration_Invoice | smalldatetime | FYE as defined by the exporting applciation. |
fiscal_year_end_month | Client | int | End month of the client's fiscal year end. |
fiscal_year_end_month | History_Of_Client | int | |
fixed_rate | Engagement | decimal (9, 2) | Rate to use when rate_type_KEY=3 |
fixed_rate | History_Of_Engagement | decimal (9, 2) | |
folder_id | Gofileroom_Workflow | nvarchar (10) | One of four required fields that uniquely identify a workflow, not intended to be viewed by users. |
formula | Custom_Formula | nvarchar (-1) | The custom formula. |
from__ledger_entry_KEY | Billing_Decision_Collection | int | Indicates which [Invoice] row was the source of the application in scenarios such as progress billing. Standard entries that users can create have [from__ledger_entry_KEY] set to the same value as [ledger_entry_KEY]. |
from__ledger_entry_KEY | Billing_Decision_Tax_Collection | int | Indicates which [Invoice] row was the source of the application in scenarios such as progress billing. Standard entries that users can create have [from__ledger_entry_KEY] set to the same value as [ledger_entry_KEY]. |
from__ledger_entry_KEY | Ledger_Entry_Application | int | The Ledger Entry that amount_applied is subtracted from. |
from_value | Filter_Line | nvarchar (100) | The lesser of the two values. |
generate_assigned_from_project | History_Of_Schedule_Item_Series | bit | |
generate_assigned_from_project | Schedule_Item_Series | bit | When set to 1 will indicate that next project generation should use the assigned from the project instead of the template. |
generate_assigned_from_task | History_Of_Schedule_Item_Series | bit | |
generate_assigned_from_task | Schedule_Item_Series | bit | When set to 1 will indicate that next project generation should use the assigned from the task instead of the template. |
generate_budgeted_amount_factor | History_Of_Schedule_Item_Series | decimal (6, 4) | |
generate_budgeted_amount_factor | Schedule_Item_Series | decimal (6, 4) | Factor to be used to adjust the amount when generating from the project. |
generate_budgeted_hours_factor | History_Of_Schedule_Item_Series | decimal (6, 4) | |
generate_budgeted_hours_factor | Schedule_Item_Series | decimal (6, 4) | Factor to be used to adjust the hours when generating from the project. |
generate_calendar_entries_from_project | History_Of_Schedule_Item_Series | bit | |
generate_calendar_entries_from_project | Schedule_Item_Series | bit | When set to 1 will indicate that next project generation should copy the calendar entries from the prior project. |
generate_calendar_entries_from_task | History_Of_Schedule_Item_Series | bit | |
generate_calendar_entries_from_task | Schedule_Item_Series | bit | When set to 1 will indicate that next project generation should copy the calendar entries from the prior task. |
generate_custom_values_from_project | History_Of_Schedule_Item_Series | bit | |
generate_custom_values_from_project | Schedule_Item_Series | bit | When set to 1 will indicate that next project generation should copy custom val |
generate_custom_values_from_task | History_Of_Schedule_Item_Series | bit | |
generate_custom_values_from_task | Schedule_Item_Series | bit | When set to 1 will indicate that next project generation should copy custom val |
generate_descriptions_from_project | History_Of_Schedule_Item_Series | bit | |
generate_descriptions_from_project | Schedule_Item_Series | bit | When set to 1 will indicate that next project generation should use the descriptions from the project instead of the template. |
generate_descriptions_from_task | History_Of_Schedule_Item_Series | bit | |
generate_descriptions_from_task | Schedule_Item_Series | bit | When set to 1 will indicate that next project generation should use the descriptions from the task instead of the template. |
generate_engagement_from_project | History_Of_Schedule_Item_Series | bit | |
generate_engagement_from_project | Schedule_Item_Series | bit | When set to 1 will indicate that next project generation should use the engagement from the project instead of the template. |
generate_groupings_from_project | History_Of_Schedule_Item_Series | bit | |
generate_groupings_from_project | Schedule_Item_Series | bit | When set to 1 will indicate that next project generation should use the groupings from the project instead of the template. |
generate_links_from_project | History_Of_Schedule_Item_Series | bit | |
generate_links_from_project | Schedule_Item_Series | bit | When set to 1 will indicate that next project generation should use the links from the project instead of the template. |
generate_links_from_task | History_Of_Schedule_Item_Series | bit | |
generate_links_from_task | Schedule_Item_Series | bit | When set to 1 will indicate that next project generation should use the links from the task instead of the template. |
generate_notes_from_project | History_Of_Schedule_Item_Series | bit | |
generate_notes_from_project | Schedule_Item_Series | bit | When set to 1 will indicate that next project generation should use the notes from the project instead of the template. |
generate_notes_from_task | History_Of_Schedule_Item_Series | bit | |
generate_notes_from_task | Schedule_Item_Series | bit | When set to 1 will indicate that next project generation should use the notes from the task instead of the template. |
generate_tasks_from_project | History_Of_Schedule_Item_Series | bit | |
generate_tasks_from_project | Schedule_Item_Series | bit | When set to 1 will indicate that next project generation should use the tasks from the project instead of the template. |
generation_date_based_on_fiscal_year_end | History_Of_Schedule_Item_Series | bit | |
generation_date_based_on_fiscal_year_end | Schedule_Item_Series | bit | When the value is 1 the generation date is adjusted for the Client's fiscal year end. |
generation_date_must_occur_on_weekdays | History_Of_Schedule_Item_Series | bit | |
generation_date_must_occur_on_weekdays | Schedule_Item_Series | bit | When the value is 1 the generation date is adjusted so that it does not fall on a weekend. |
generation_day | History_Of_Schedule_Item_Series | int | |
generation_day | Project_Template_Definition | int | |
generation_day | Schedule_Item_Series | int | Number of days before the next date to generate the project. |
generation_month | History_Of_Schedule_Item_Series | int | |
generation_month | Project_Template_Definition | int | |
generation_month | Schedule_Item_Series | int | Number of months before the next date to generate the project. |
gl_account | Activity | nvarchar (60) | Defines the GL Account to which this activity will be exported. |
gl_account | Engagement | nvarchar (60) | Defines the GL Account to which this engagement will be exported. |
gl_account | History_Of_Engagement | nvarchar (60) | |
gl_account | Taxing_Authority | nvarchar (60) | General Ledger account number used in CSA |
gl_entry_export_accounting_method_KEY | GL_Entry_Export_Option | int | |
gl_entry_export_option_KEY | GL_Entry_Export_Option | int | |
gl_entry_export_tax_basis_KEY | GL_Entry_Export_Option | int | |
gl_entry_export_type_KEY | GL_Entry_Export_Type | int | |
gofileroom_configuration | Firm | nvarchar (-1) | Contains GoFileRoom integration configuration data in an xml format. |
gofileroom_create_link | Print_Option | bit | |
gofileroom_output_type | Print_Option | int | The type of file format to export to GoFileRoom. |
gofileroom_workflow_KEY | Gofileroom_Workflow | int | Assigned by COMMON_dp_Allocate_Unique_Identifiers. Primary key for this table. |
gofileroom_workflow_KEY | History_Of_Project | int | |
gofileroom_workflow_KEY | Project | int | GoFileRoom Workflow associated with this Project. |
grace_days | Service_Charge | int | Number of days after the due date the client is given until service charges begin calculating. |
hash_code | Report_Image | varchar (40) | 40-character hexadecimal-formatted string from the SHA-1 hash of the image for faster look-up. |
hide_column | User_Preference_Custom_Field_Column | bit | Whether or not this field should be hidden in Time and expense entry |
hide_description_column | User_Preference_Custom_Field_Column | bit | Whether or not the description column related to this field should be hidden in Time and expense entry |
hierarchy | Privilege | nvarchar (450) | Calculated by the database to allow privileges to be sorted quickly in tree structure. |
history_action_KEY | History_Action | tinyint (3) | Primary key of a history action. |
history_action_KEY | History_Of_Additional_Contact | tinyint (3) | |
history_action_KEY | History_Of_Attachment | tinyint (3) | |
history_action_KEY | History_Of_Attachment_Content | tinyint (3) | |
history_action_KEY | History_Of_Calendar_Category | tinyint (3) | |
history_action_KEY | History_Of_Client | tinyint (3) | |
history_action_KEY | History_Of_Client_Financial_Data | tinyint (3) | |
history_action_KEY | History_Of_Client_Financial_Data_Description | tinyint (3) | |
history_action_KEY | History_Of_Client_Staff_Grouping | tinyint (3) | |
history_action_KEY | History_Of_Contact | tinyint (3) | |
history_action_KEY | History_Of_Contact_Address | tinyint (3) | |
history_action_KEY | History_Of_Contact_Category | tinyint (3) | |
history_action_KEY | History_Of_Contact_Contact_Category | tinyint (3) | |
history_action_KEY | History_Of_Contact_Email | tinyint (3) | |
history_action_KEY | History_Of_Contact_Phone | tinyint (3) | |
history_action_KEY | History_Of_Custom_Chart | tinyint (3) | |
history_action_KEY | History_Of_Custom_Field | tinyint (3) | |
history_action_KEY | History_Of_Custom_Value | tinyint (3) | |
history_action_KEY | History_Of_Digita_Vat_Period | tinyint (3) | |
history_action_KEY | History_Of_Engagement | tinyint (3) | |
history_action_KEY | History_Of_File_Transfer | tinyint (3) | |
history_action_KEY | History_Of_File_Transfer_Event | tinyint (3) | |
history_action_KEY | History_Of_File_Transfer_File | tinyint (3) | |
history_action_KEY | History_Of_Link | tinyint (3) | |
history_action_KEY | History_Of_Link_Group | tinyint (3) | |
history_action_KEY | History_Of_Portal_User | tinyint (3) | |
history_action_KEY | History_Of_Project | tinyint (3) | |
history_action_KEY | History_Of_Project_Extension | tinyint (3) | |
history_action_KEY | History_Of_Schedule_Entry | tinyint (3) | |
history_action_KEY | History_Of_Schedule_Item | tinyint (3) | |
history_action_KEY | History_Of_Schedule_Item_Assignment | tinyint (3) | |
history_action_KEY | History_Of_Schedule_Item_Budget_Remaining_Entry | tinyint (3) | |
history_action_KEY | History_Of_Schedule_Item_Series | tinyint (3) | |
history_action_KEY | History_Of_Sheet_Entry | tinyint (3) | |
history_action_KEY | History_Of_Tag | tinyint (3) | |
history_action_KEY | History_Of_Tagged_Item | tinyint (3) | |
history_action_KEY | History_Of_Task | tinyint (3) | |
history_action_KEY | History_Of_Time_Zone | tinyint (3) | |
history_action_KEY | History_Of_Timer | tinyint (3) | |
holiday_date | Observed_Holiday | smalldatetime | The date that this entry corresponds to. |
home_dashboard_layout | User_Preference | nvarchar (-1) | Layout of the Home Dashboard stored as XML |
host_name | Changeset | nvarchar (128) | The host (computer) if known. Should be as close to the user as possible. |
host_name | Update_Data_Version_History | nvarchar (50) | |
host_name | User_Session_Pattern | nvarchar (50) | |
hourly_cost | Staff_Rate_Table | decimal (9, 2) | The cost per hour. |
hours | History_Of_Schedule_Item_Budget_Remaining_Entry | decimal (9, 2) | |
hours | Schedule_Item_Budget_Remaining_Entry | decimal (9, 2) | The number of hours this entry is adjusting the remaining hours value. |
hours | Staff_Benefit_Entry | decimal (9, 2) | The number of hours included in this entry. |
hours_entered | Staff_Benefit_Entry | decimal (9, 2) | The number of hours entered included in this entry. |
import_as__contact_type_KEY | Outlook_Contact_Synchronization_Profile | int | Determines what type of contact is created in the database for contacts imported from Outlook?. |
index_email | Firm | bit | True to index email |
individual_date_of_birth | Client | smalldatetime | Date of birth of the client if the client is an individual |
individual_date_of_birth | History_Of_Client | smalldatetime | |
individual_first_name | Client | nvarchar (100) | First name of the client if the client is an individual. |
individual_first_name | History_Of_Client | nvarchar (100) | |
individual_last_name | Client | nvarchar (100) | Last name of the client if the client is an individual. |
individual_last_name | History_Of_Client | nvarchar (100) | |
industry_code | Client | nvarchar (6) | Industry code. |
industry_code | History_Of_Client | nvarchar (6) | |
instructor | History_Of_Schedule_Item | nvarchar (250) | |
instructor | Schedule_Item | nvarchar (250) | |
integration_application__description | Integration_Sheet_Entry | nvarchar (-1) | The string description of the source application for this entry. |
integration_application_KEY | Client_Financial_Data | int | The application that provided this data |
integration_application_KEY | History_Of_Client_Financial_Data | int | |
integration_application_KEY | History_Of_Sheet_Entry | int | |
integration_application_KEY | Integration_Application | int | AUTO-INCREMENT: Database assigned primary key for this table |
integration_application_KEY | Integration_Invoice | int | Key to a record in Integration_Application indicating which application exported this data. |
integration_application_KEY | Interaction | int | |
integration_application_KEY | Sheet_Entry | int | Key to the Integration Application table to denote the source application for this entry. |
integration_application_KEY | Status_Event | int | Key to one of the records in the Integration_Application table. |
integration_application_name | History_Of_Timer | nvarchar (30) | |
integration_application_name | Timer | nvarchar (30) | Identifies the application integration application name that is using the timer (if any) |
integration_application_year | Client_Financial_Data | int | The version year of the application that provided this data |
integration_application_year | History_Of_Client_Financial_Data | int | |
integration_custom_value_KEY | Integration_Custom_Value | int | |
integration_date_utc | Integration_Invoice | datetime | Date the data was exported from the remote application, in UTC. |
integration_invoice_KEY | Integration_Invoice | int | AUTO-INCREMENT: Database assigned primary key for this table |
integration_invoice_KEY | Integration_Invoice_Prior_Payment | int | Key of the Integration Invoice record that this payment info applies to. |
integration_invoice_prior_payment_KEY | Integration_Invoice_Prior_Payment | int | AUTO-INCREMENT: Database assigned primary key for this table |
integration_sheet_entry_KEY | Integration_Sheet_Entry | int | Assigned by COMMON_dp_Allocate_Unique_Identifiers. Database assigned primary key for this table. |
interaction_association_KEY | Interaction_Association | tinyint (3) | A unique value assigned to this row so that linking to this row uses only 1 byte. Stored as an Int8 to save storage space on the millions of Interaction rows. |
interaction_association_KEY | Interaction_Contact | tinyint (3) | |
interaction_KEY | Interaction | int | Assigned by COMMON_dp_Allocate_Unique_Identifiers. A unique value assigned to this row so that linking to this row uses only 4 bytes. |
interaction_KEY | Interaction_Contact | int | A reference to one of the Interaction rows. |
interaction_KEY | Interaction_Email_Address | int | A reference to one of the Interaction rows. |
interaction_KEY | Interaction_Link | int | Key to the interaction that this link links to |
interaction_KEY | Interaction_Phone_Number | int | A reference to one of the Interaction rows. |
interaction_KEY | Outlook_Item | int | A reference to exactly one of the Interaction rows. |
interaction_subtype_KEY | Interaction | tinyint (3) | A reference to Interaction_Subtype that indicates what subtype of interaction this is (E-mail, Note, Incoming Phone Call, Outgoing Phone Call, Please Call Back, or Will Call Back, Returned Your Call Phone Message etc.) The Interaction_Subtype table holds a reference to the main Interaction_Type. |
interaction_subtype_KEY | Interaction_Subtype | tinyint (3) | A unique value assigned to this row so that linking to this row uses only 1 byte. Stored as an Int8 to save storage space on the millions of Interaction rows. |
interaction_type_KEY | Interaction_Subtype | int | The granular interaction type that this subtype applies to. |
internal_comments | Ledger_Entry | nvarchar (-1) | Comments about this item that are internal to the firm. |
invoice__report_definition_KEY | Client | int | Key to an Invoice Report Definition record. |
invoice__report_definition_KEY | Firm | int | Default invoice format for new clients. |
invoice__report_definition_KEY | History_Of_Client | int | |
invoice_date | Integration_Invoice | smalldatetime | Date of the invoice. |
invoice_email_body | Firm | nvarchar (-1) | |
invoice_email_subject | Firm | nvarchar (255) | |
invoice_format | Invoice | nvarchar (-1) | The uncompressed invoice format containing a copy of the invoice Report Definition and composed field values. |
invoice_format_compressed | Invoice | varbinary (-1) | The compressed invoice format containing a copy of the invoice Report Definition and composed field values. |
invoice_format_storage_style_KEY | Invoice | int | Key of the Invoice Format Storage Style that indicates how the invoice format is stored. |
invoice_KEY | Billing_Decision | int | The Invoice this billing apears on. |
invoice_KEY | Integration_Invoice | int | Key to the Invoice record created for this exported invoice. |
invoice_KEY | Invoice | int | Database assigned primary key for this table |
invoice_KEY | Report_Definition_Update_List | int | |
invoice_number | Integration_Invoice | nvarchar (30) | Invoice number as it is in the exporting application. |
invoice_reference_number_layout | Firm | nvarchar (-1) | The XML layout for an invoice reference number. |
invoiced | Billing_Decision | decimal (9, 2) | Total amount that this Billing_Decision is invoiced, including taxes and discounts, if this Billing_Decision is billable. This is always calculated even it the Billing_Decision is non-billable. |
invoiced | Client_Date_Cache | decimal (9, 2) | invoiced sum for the Client, principal Client, and entry date |
ip_address | File_Transfer_Event | varchar (39) | IP Address of machine that triggered this event |
ip_address | History_Of_File_Transfer_Event | varchar (39) | |
is_all_day_event | History_Of_Schedule_Item | bit | |
is_all_day_event | Schedule_Item | bit | When true, the time on [target_start_date_utc] and [target_complete_date_utc] must be 0:00:00 and may appear offset to whole days in local time for the user. |
is_all_day_event | Schedule_Item_Date_Index | bit | |
IS_AUTO_NUM | COMMON_Metadata_About_Columns | bit | |
is_cash_basis | Digita_Vat_Period | bit | Indicate whether the VAT period is reported using a cach or accrual basis. |
is_cash_basis | History_Of_Digita_Vat_Period | bit | |
is_closed | Digita_Vat_Period | bit | Indicates whether the period is open or closed. |
is_closed | History_Of_Digita_Vat_Period | bit | |
is_default | Engagement_Template | bit | Whether or not this engagement will be used as a default for new clients that are entered. |
is_method_all | Filter_Line | bit | True when the method is All, false otherwise. |
IS_NULLABLE | COMMON_Metadata_About_Columns | bit | |
is_open | History_Of_Schedule_Item | bit | |
is_open | Schedule_Item | bit | False when this item is closed by state (tracking description or status). May be true for items that are closed now because they have elapsed, like a Meeting in the past. |
is_primary_assignment | History_Of_Schedule_Item_Assignment | bit | |
is_primary_assignment | Project_Template_Assignment | bit | Exactly one record per [project_template_KEY] should be set to true. |
is_primary_assignment | Schedule_Item_Assignment | bit | Exactly one record per [schedule_item_KEY] should be set to true. |
is_primary_assignment | Task_Template_Assignment | bit | Exactly one record per [task_template_KEY] should be set to true. |
IS_PRIMARY_KEY | COMMON_Metadata_About_Keys | bit | |
is_system_event | Recorded_Event | bit | Indicates whether this is a system level event and therefore not to be displayed to users. |
items_to_keep | Feed_Channel | int | |
label | File_Transfer_Event | nvarchar (260) | Label for this event, as provided by Portal server |
label | History_Of_File_Transfer_Event | nvarchar (260) | |
label__report_definition_KEY | Print_Option | int | The label format to use when printing labels. |
label_printer_name | Print_Option | nvarchar (260) | Printer name to print labels to. |
last_access_date | User_Session | datetime | Date and time this session was last active in UTC. |
last_check_date | Monitored_Event | datetime | |
last_check_state | Monitored_Event | nvarchar (-1) | XML blob with context-specific state information for state transition comparisons. |
last_modification_date | History_Of_Portal_User | datetime | |
last_modification_date | Portal_User | datetime | time at which the portal server last updated this portal data |
last_modification_time | Outlook_Item | datetime | The value of the LastModificationTime property from Outlook(R). |
last_name | History_Of_Portal_User | nvarchar (256) | |
last_name | Portal_User | nvarchar (256) | last name of person associated with this portal |
last_name | Staff | nvarchar (30) | The last name of this Staff. |
layout | Dashboard_Layout | nvarchar (-1) | User defined dashboard layout |
leaf | Privilege | tinyint (3) | 1 if this is a privilege and 0 if it is a privilege folder. |
ledger_entry_application_KEY | Ledger_Entry_Application | int | AUTO-INCREMENT: Database assigned primary key for this table |
ledger_entry_KEY | Billing_Decision | int | The Invoice this billing apears on (same as invoice_KEY column of Billing_Decision.) |
ledger_entry_KEY | Billing_Decision_Collection | int | The combination of ledger_entry_KEY and sheet_entry_KEY identifies the billing decision this collection is for. |
ledger_entry_KEY | Billing_Decision_Tax_Collection | int | The combination of ledger_entry_KEY, sheet_entry_KEY and taxing_authority_KEY identifies the BDTA row this collection is for. |
ledger_entry_KEY | Billing_Decision_Taxing_Authority | int | The combination of ledger_entry_KEY and sheet_entry_KEY identifies the Billing_Decision row this tax is charged for. |
ledger_entry_KEY | Invoice | int | |
ledger_entry_KEY | Invoice_Office | int | Key of the Ledger Entry. |
ledger_entry_KEY | Ledger_Entry | int | Assigned by COMMON_dp_Allocate_Unique_Identifiers. Database assigned primary key for this table |
ledger_entry_KEY | Ledger_Entry_Submittal | int | The ledger entry this submittal applies to. |
ledger_entry_KEY | Ledger_Entry_Submittal_Result | int | The ledger entry this submittal applies to. |
ledger_entry_KEY | Online_Invoice | int | Primary key for this row and the key of the associated Invoice. |
ledger_entry_KEY | Online_Payment | int | Primary key for this row and the key of the associated Payment. |
ledger_entry_service_charge_KEY | Ledger_Entry_Service_Charge | int | AUTO-INCREMENT: Database assigned primary key for this table |
ledger_entry_subtype_KEY | Ledger_Entry | int | The subtype of this Ledger Entry. |
ledger_entry_subtype_KEY | Ledger_Entry_Subtype | int | A unique value assigned to this row so that linking to this row uses only 1 byte. Stored as an Int8 to save storage space on the millions of Ledger_Entry rows. |
ledger_entry_type_id | Ledger_Entry_Type | nvarchar (250) | User defined identifier (unique). |
ledger_entry_type_id_sortable | Ledger_Entry_Type | varchar (250) | A representation of the ledger_entry_type_id column that sorts in natural order, meaning that digits are sorted as numbers while non-digits are sorted alphabetically. A trigger keeps this field synchronized with the content of ledger_entry_type_id. |
ledger_entry_type_KEY | Ledger_Entry | int | The type of this Ledger Entry. |
ledger_entry_type_KEY | Ledger_Entry_Subtype | int | The granular ledger entry type that this subtype applies to. |
ledger_entry_type_KEY | Ledger_Entry_Type | int | Database assigned primary key for this table. |
length | Custom_Field | int | Length of character columns, precision of number columns, storage length of other types. |
length | History_Of_Custom_Field | int | |
letter__report_definition_KEY | Print_Option | int | The letter format to use when printing letters. |
license__report_definition_guid | Report_Definition | uniqueidentifier | Unique id for licensing purposes. |
license__report_definition_guid | Report_Definition_Privilege_Dependency | uniqueidentifier | Unique id for licensing purposes. |
link | Feed_Channel | nvarchar (-1) | |
link_group_KEY | History_Of_Link | int | |
link_group_KEY | History_Of_Link_Group | int | |
link_group_KEY | Link | int | Parent group of this link |
link_group_KEY | Link_Group | int | Assigned by COMMON_dp_Allocate_Unique_Identifiers. Database assigned primary key for this table |
link_KEY | History_Of_Link | int | |
link_KEY | Interaction_Link | int | Primary key, and key to parent table |
link_KEY | Link | int | Assigned by COMMON_dp_Allocate_Unique_Identifiers. Primary key of this table |
link_type_KEY | History_Of_Link | int | |
link_type_KEY | Link | int | Type of link this is |
list_name | Filter_Type | nvarchar (128) | Name of the list that this type of filter limits. |
live_actual_amount | History_Of_Schedule_Item | decimal (17, 2) | |
live_actual_amount | Schedule_Item | decimal (17, 2) | Cached value of the amount on all Sheet_Entry rows associated with this row. |
live_actual_hours | History_Of_Schedule_Item | decimal (17, 2) | |
live_actual_hours | Schedule_Item | decimal (17, 2) | Cached value of the hours on all Sheet_Entry rows associated with this row. |
locale | Option_List | nvarchar (128) | |
location | History_Of_Schedule_Item | nvarchar (250) | |
location | Schedule_Item | nvarchar (250) | |
login | History_Of_Portal_User | nvarchar (150) | |
login | Legacy_Contact_Portal_Mapping | nvarchar (50) | Unique but mutable login name |
login | Portal_User | nvarchar (150) | unique but mutable login name |
login_date | User_Session | datetime | The date and time the session was opened in UTC. |
logout_date | User_Session | datetime | The date and time that the user logged out, or that the session was deemed expired or killed, in UTC. |
long_description | Activity | nvarchar (-1) | Long user defined description |
long_description | Activity_Category | nvarchar (-1) | |
long_description | Engagement | nvarchar (-1) | Long user defined description |
long_description | Engagement_Type | nvarchar (-1) | |
long_description | History_Of_Engagement | nvarchar (-1) | |
long_description | History_Of_Project | nvarchar (-1) | |
long_description | Project | nvarchar (-1) | Long description to use on invoices. |
long_description | Project_Template | nvarchar (-1) | Long description to use on invoices. |
long_description | Project_Template_Definition | nvarchar (-1) | Long description to use on invoices. |
long_description | Report_Definition | nvarchar (-1) | Long description of report. |
long_description | Standard_Text | nvarchar (-1) | Text to use as a standard comment |
lookup_display_member | Filter_Range_Type | nvarchar (128) | Name of the property in the lookup list that has the value that should be used for the range criteria. |
lookup_list_name | Filter_Line_Type | nvarchar (128) | Name of the list that provides data for this type of criteria or an empty string. |
lookup_table_name | Monitored_Event_Action | nvarchar (128) | Table that specifies entity to notify. |
lookup_value_member | Filter_Line_Type | nvarchar (128) | Name of the property in the lookup list to compare to Filter_Base_Type.filter_column or an empty string. |
lost_reason_KEY | Client | int | Key to a Lost Reason record. |
lost_reason_KEY | History_Of_Client | int | |
lost_reason_KEY | Lost_Reason | int | AUTO-INCREMENT: Database assigned primary key for this table. |
lost_to_KEY | Client | int | Key to a Lost To record. |
lost_to_KEY | History_Of_Client | int | |
lost_to_KEY | Lost_To | int | AUTO-INCREMENT: Database assigned primary key for this table. |
lower_date_inclusive | Client_Staff_Grouping | smalldatetime | |
lower_date_inclusive | History_Of_Client_Staff_Grouping | smalldatetime | |
lower_date_inclusive | Staff_Target_Range | smalldatetime | REDUNDANT: For performance we store the date that this range becomes effective. It can be computed from [upper_date_exclusive] and [firm_date_KEY]. |
lower_date_utc | Schedule_Item_Date_Index | datetime | |
mailing__contact_address_type_KEY | Contact | int | Indicates which address type is the mailing address. |
mailing__contact_address_type_KEY | History_Of_Contact | int | |
manager__staff_grouping_type_KEY | Engagement_Template | int | Key to a Staff Grouping Type that indicates how to determine which staff will be assigned to generated engagements. |
manager__staff_KEY | Client | int | Key to a Staff record. |
manager__staff_KEY | Engagement | int | Key to a Staff record. |
manager__staff_KEY | History_Of_Client | int | |
manager__staff_KEY | History_Of_Engagement | int | |
markup_factor | Engagement | decimal (6, 4) | Multiplied by the extension amount so work can be marked up or down. |
markup_factor | History_Of_Engagement | decimal (6, 4) | |
match_all | Filter | bit | Use AND logic when true, OR logic when false. |
maximum_carryover | Benefit | decimal (9, 2) | The maximum amount allowed to carryover annually. |
maximum_charge | Service_Charge | decimal (17, 2) | If the system calculates a service charge amount and it is greater than this amount then the calculated amount should be dropped and this amount should be used. |
middle_name | Staff | nvarchar (30) | The middle name of this Staff. |
minimum_balance | Service_Charge | decimal (17, 2) | The system will not calculate service charges for clients unless their A/R balance is equal to or greater than this value. |
minimum_charge | Service_Charge | decimal (17, 2) | If the system calculates a service charge amount and it is less than this amount then the calculated amount should be dropped and this amount should be used. |
minutes_to_live | Feed_Channel | int | |
mobilecs_enabled | History_Of_Portal_User | bit | |
mobilecs_enabled | Legacy_Contact_Portal_Mapping | bit | Whether mobilecs is enabled if this mapping was a netstaff |
mobilecs_enabled | Portal_User | bit | whether or not this portal is authorized for mobile cs |
monitored_event_action_KEY | Monitored_Event_Action | int | AUTO-INCREMENT: Database assigned primary key for this table |
monitored_event_KEY | Monitored_Event | int | AUTO-INCREMENT: Database assigned key for this table |
monitored_event_KEY | Monitored_Event_Action | int | Key to parent record. |
month_info_id | Month_Info | nvarchar (11) | The same value as month_info_KEY as a string (1 for January, 12 for December.) |
month_info_id_sortable | Month_Info | nvarchar (48) | A representation of the month_info_id column that sorts in natural order, meaning that digits are sorted as numbers while non-digits are sorted alphabetically. A trigger keeps this field synchronized with the content of month_info_id. |
month_info_KEY | Month_Info | int | The number of the month (1 for January, 12 for December.) |
must_change_password | Practice_User | bit | |
name | Contact | nvarchar (250) | Name of the contact. |
name | History_Of_Contact | nvarchar (250) | |
name | Last_Table_Modification | nvarchar (128) | |
name | Table_Information | nvarchar (128) | Name of the table. |
name_1 | Client | nvarchar (250) | Name of company if the client type is a non-individual, otherwise it is the display name for the client. |
name_1 | Firm | nvarchar (250) | |
name_1 | History_Of_Client | nvarchar (250) | |
name_2 | Client | nvarchar (250) | Only shown on the UI for non-individual clients |
name_2 | Firm | nvarchar (250) | |
name_2 | History_Of_Client | nvarchar (250) | |
negative_invoiced | Invoice | decimal (17, 2) | Sum of Billing_Decision.invoiced for this invoice where Billing_Decision.invoiced < 0. |
negative_nonprogress_invoiced | Invoice | decimal (17, 2) | Sum of Billing_Decision.invoiced for this invoice where Billing_Decision.invoiced < 0 and the Billing_Decision is not progress or progress relief. |
negative_progress_invoiced | Invoice | decimal (17, 2) | Sum of Billing_Decision.invoiced for this invoice where Billing_Decision.invoiced < 0 and the Billing_Decision is progress or progress relief. |
netstaff_id | Legacy_Contact_Portal_Mapping | int | Unique and immutable primary key of the staff portal |
next_check_date | Monitored_Event | datetime | Date by which this event must be checked (if polled). |
next_generation_date | Schedule_Item_Generation_Date | datetime | The date that the next project generation to be performed (in UTC). |
next_value | COMMON_Unique_Identifier_Counter | int | |
nonbillable_live_open_amount | Sheet_Entry_Open_Value_Cache | decimal (17, 2) | The nonbillable live open amount for the Sheet_Entry row. |
nonbillable_live_open_units | Sheet_Entry_Open_Value_Cache | decimal (9, 2) | The nonbillable live open units for the Sheet_Entry row. |
nonprogress_bill_amount | Client_Date_Cache | decimal (9, 2) | nonprogress_bill_amount sum for the Client, principal Client, and entry date |
normal_sign | GL_Entry_Export_Type | decimal (1) | |
normal_sign | Ledger_Entry_Type | decimal (1) | Debit (1) or Credit (-1). |
number_of_copies | Print_Option | int | Number of copies to print. |
observed_holiday_KEY | Observed_Holiday | int | Assigned by COMMON_dp_Allocate_Unique_Identifiers. Primary key for this table. |
of__contact_KEY | File_Transfer | int | contact that contact__contact_KEY is of |
of__contact_KEY | History_Of_File_Transfer | int | |
of__contact_KEY | History_Of_Schedule_Item | int | |
of__contact_KEY | Schedule_Item | int | For scheduled phone calls, the association of with__contact_KEY involved - for example which Client if of__contact_KEY is associated to multiple Clients. |
office_grouping_type_KEY | Engagement_Template | int | Key to a Office Grouping Type that indicates how to determine which office will be assigned to generated engagements. |
office_id | Office | nvarchar (11) | User defined identifier (unique). |
office_id_sortable | Office | varchar (48) | A representation of the office_id column that sorts in natural order, meaning that digits are sorted as numbers while non-digits are sorted alphabetically. A trigger keeps this field synchronized with the content of office_id. |
office_KEY | Client | int | Key to an Office record. |
office_KEY | Engagement | int | Key to an Office record. |
office_KEY | Firm | int | Key from the main office. |
office_KEY | History_Of_Client | int | |
office_KEY | History_Of_Engagement | int | |
office_KEY | Invoice_Office | int | Key of the Office of the Staff who billed this invoice. |
office_KEY | Office | int | Assigned by COMMON_dp_Allocate_Unique_Identifiers. Database assigned primary key for this table. |
office_KEY | Staff | int | Key from one of the already set up Offices. |
ON_INSERT | COMMON_Metadata_About_Columns | varchar (10) | |
online_bill_pay_enabled | Firm | bit | Determines whether invoices can be sent to the online bill pay service. |
online_bill_pay_enabled | History_Of_Portal_User | bit | |
online_bill_pay_enabled | Portal_User | bit | whether or not this portal is authorized for online bill pay |
online_invoice_guid | Online_Invoice | uniqueidentifier | A unique value that is used to identify this invoice on the portal and in online payments. |
online_payment_guid | Online_Payment | uniqueidentifier | A unique value that is used to identify this payment on the portal and in online payments. |
onvio_documents__client_KEY | Print_Option | int | The client whose folder reports will be output to. |
onvio_documents_create_link | Print_Option | bit | |
onvio_documents_file_by_type | Print_Option | int | How to file a report (e.g., by the firm's current-year-end date). |
onvio_documents_firm_data | Print_Option | bit | Send to firm documents. |
onvio_documents_output_type | Print_Option | int | The type of file format to export to Onvio Documents. |
option_value | Option_List | int | |
order_number | Ledger_Entry_Submittal | nvarchar (40) | Unique order number assigned by the program |
ORDINAL_POSITION | COMMON_Metadata_About_Foreign_Keys | int | |
ordinal_position | Report_Profile_Report_Definition | int | The order of the reports in the profile. |
original_due_date | History_Of_Project | smalldatetime | |
original_due_date | History_Of_Project_Extension | smalldatetime | |
original_due_date | Project | smalldatetime | The original due date of the project; readonly once the record is created. |
original_due_date | Project_Extension | smalldatetime | The original due date of the project extension; readonly once the record is created. |
original_publication_date | Feed_Channel_Item | datetime | |
outlook_contact_synchronization_folder_KEY | Outlook_Contact_Synchronization_Folder | int | Assigned by COMMON_dp_Allocate_Unique_Identifiers. Program assigned primary key for this table. |
outlook_contact_synchronization_profile_KEY | Outlook_Contact_Synchronization_Folder | int | Reference to the contact synchronization profile this folder is for. |
outlook_contact_synchronization_profile_KEY | Outlook_Contact_Synchronization_Profile | int | Assigned by COMMON_dp_Allocate_Unique_Identifiers. Program assigned primary key for this table. |
outlook_index_folder_firm_KEY | Outlook_Index_Folder_Firm | int | Assigned by COMMON_dp_Allocate_Unique_Identifiers. A unique value assigned to this row. The natural key would be (firm_KEY, outlook_store_KEY, entry_id) but that exceeds the 900 byte limit. |
outlook_item_guid | Outlook_Item | uniqueidentifier | The value of a custom property that has been added to the Outlook(R) item. |
outlook_store_KEY | Outlook_Contact_Synchronization_Folder | int | A reference to one of the Outlook_Store rows that has the binary value of the Outlook? StoreID of this item. |
outlook_store_KEY | Outlook_Index_Folder_Firm | int | A reference to one of the Outlook_Store rows that has the binary value of the Outlook(R) StoreID of this item. |
outlook_store_KEY | Outlook_Item | int | A reference to one of the Outlook_Store rows that has the binary value of the Outlook(R) StoreID of this item. |
outlook_store_KEY | Outlook_Store | int | Assigned by COMMON_dp_Allocate_Unique_Identifiers. A unique value assigned to this StoreID so that linking to this StoreID uses only 4 bytes. |
output_labels_to_printer | Print_Option | bit | Output labels to printer. |
output_letters_to_printer | Print_Option | bit | Output letters to printer. |
output_to_email | Print_Option | bit | Output reports to email. |
output_to_fcs | Print_Option | bit | Output reports to FileCabinet Solution. |
output_to_file | Print_Option | bit | Output reports to file. |
output_to_gofileroom | Print_Option | bit | Determines if output will be sent to GoFileRoom |
output_to_online_bill_pay | Print_Option | bit | Output reports to Online Bill Pay. |
output_to_onvio_documents | Print_Option | bit | Determines if output will be sent to Onvio Documents. |
output_to_printer | Print_Option | bit | Output reports to printer. |
owner_table_name | Custom_Chart | nvarchar (128) | Name of the table that this custom chart is associated with. |
owner_table_name | Custom_Formula | nvarchar (128) | Name of the table that this custom formula is associated with. |
owner_table_name | History_Of_Custom_Chart | nvarchar (128) | |
PARAMETER_NAME | COMMON_Metadata_About_Sprocs | nvarchar (128) | |
parent__contact_KEY | Additional_Contact | int | Key to the parent contact record. |
parent__contact_KEY | History_Of_Additional_Contact | int | |
parent__privilege_KEY | Privilege | int | Foreign key to the parent of this Privilege. |
parent__report_definition_KEY | Report_Definition | int | Key of the Report Definition that this row is assigned |
password_hash | Practice_User | nvarchar (28) | Specifies whether the user must change the password at the next logon. |
past_due__ledger_entry_KEY | Ledger_Entry_Service_Charge | int | Key to a Ledger Entry that was past due and was charged a fee. |
payment_amount | Integration_Invoice_Prior_Payment | decimal (17, 2) | Amount of the payment |
payment_date | Integration_Invoice_Prior_Payment | smalldatetime | Date of the payment |
percent_complete | History_Of_Project | decimal (3, 2) | |
percent_complete | Project | decimal (3, 2) | Percent complete as a decimal (0 to 1.00). |
percent_complete_is_overridden | History_Of_Project | bit | |
percent_complete_is_overridden | Project | bit | |
period_begin_date | Firm | smalldatetime | |
period_end | Gofileroom_Workflow | nvarchar (255) | GoFileRoom period end date part of this workflow. |
period_end_date | Firm | smalldatetime | |
person_in_charge | Gofileroom_Workflow | nvarchar (100) | GoFileRoom name of the person in charge of this workflow. |
phone | Contact_Phone | nvarchar (30) | Phone number. |
phone | History_Of_Contact_Phone | nvarchar (30) | |
phone_number | Interaction_Phone_Number | nvarchar (30) | Phone number. |
phone_number_format | Firm | nvarchar (30) | |
phone_position | Contact | nvarchar (14) | Semicolon seperated list of contact_phone_type_KEY values indicating the user's preferred order of phone numbers. |
phone_position | History_Of_Contact | nvarchar (14) | |
photograph | Staff | varbinary (-1) | The contents of a image file for the staff's photograph. |
plural | Term | nvarchar (50) | User defined plural description. |
portal_event_id | File_Transfer_Event | int | Unique and immutable identifier of this event provided by the Portal server |
portal_event_id | History_Of_File_Transfer_Event | int | |
portal_user_KEY | Contact | int | |
portal_user_KEY | File_Transfer_Event | int | Portal_User who triggered this event |
portal_user_KEY | History_Of_Contact | int | |
portal_user_KEY | History_Of_File_Transfer_Event | int | |
portal_user_KEY | History_Of_Portal_User | int | |
portal_user_KEY | Portal_User | int | unique and immutable primary key of this portal which is also used as this table's primary key |
portal_user_type_KEY | History_Of_Portal_User | int | |
portal_user_type_KEY | Portal_User | int | |
positive_invoiced | Invoice | decimal (17, 2) | Sum of Billing_Decision.invoiced for this invoice where Billing_Decision.invoiced > 0. |
positive_nonprogress_invoiced | Invoice | decimal (17, 2) | Sum of Billing_Decision.invoiced for this invoice where Billing_Decision.invoiced > 0 and the Billing_Decision is not progress or progress relief. |
positive_progress_invoiced | Invoice | decimal (17, 2) | Sum of Billing_Decision.invoiced for this invoice where Billing_Decision.invoiced > 0 and the Billing_Decision is progress or progress relief. |
postal_code | Address | nvarchar (10) | ZipCode / postal code. |
postal_code | Contact_Address | nvarchar (10) | ZipCode / postal code. |
postal_code | History_Of_Contact_Address | nvarchar (10) | |
posted__staff_KEY | History_Of_Sheet_Entry | int | |
posted__staff_KEY | Integration_Sheet_Entry | int | Key of the Staff who posted this item. |
posted__staff_KEY | Ledger_Entry | int | Key of the Staff who posted this item. |
posted__staff_KEY | Sheet_Entry | int | Key of the Staff who posted this item. |
posted_actual_amount | History_Of_Schedule_Item | decimal (17, 2) | |
posted_actual_amount | Schedule_Item | decimal (17, 2) | Cached value of the amount on posted Sheet_Entry rows associated with this row. |
posted_actual_hours | History_Of_Schedule_Item | decimal (17, 2) | |
posted_actual_hours | Schedule_Item | decimal (17, 2) | Cached value of the hours on posted Sheet_Entry rows associated with this row. |
posted_date | History_Of_Sheet_Entry | smalldatetime | |
posted_date | Integration_Invoice | smalldatetime | Date this item was posted. |
posted_date | Integration_Sheet_Entry | smalldatetime | Date this item was posted. |
posted_date | Ledger_Entry | smalldatetime | Date this item was posted. |
posted_date | Sheet_Entry | smalldatetime | Date this item was posted. |
practice_user_KEY | Practice_User | int | AUTO-INCREMENT: Database assigned primary key for this table. |
preferred__contact_KEY | Client | int | |
preferred__contact_KEY | History_Of_Client | int | |
preferred_locale | Contact | nvarchar (50) | Preferred locale for the contact used for language and formatting of dates, times, numbers when the locale is not available or if code running in another place needs to use it |
preferred_locale | History_Of_Contact | nvarchar (50) | |
previous_version | Update_Data_Version_History | nvarchar (19) | |
primary__contact_address_type_KEY | Contact | int | Indicates which address type is the primary address. |
primary__contact_address_type_KEY | History_Of_Contact | int | |
primary__contact_email_type_KEY | Contact | int | Indicates which email type is the primary email. |
primary__contact_email_type_KEY | History_Of_Contact | int | |
primary__contact_KEY | Legacy_Contact_Portal_Mapping | int | The primary key. |
primary__contact_phone_type_KEY | Contact | int | Indicates which phone type is the primary phone number. |
primary__contact_phone_type_KEY | History_Of_Contact | int | |
principal__client_KEY | Client | int | This should be a drop list of all clients, it is required if Bill To Principal is selected. |
principal__client_KEY | Client_Date_Cache | int | Key to principal Client that the sums are associated with. |
principal__client_KEY | History_Of_Client | int | |
print_option_KEY | Print_Option | int | AUTO-INCREMENT: Database assigned primary key for this table |
print_statements | Client | bit | Determines whether statements are printed for this client. |
print_statements | History_Of_Client | bit | |
printed | Invoice | bit | Indicates if this Invoice has been printed. |
printer_name | Print_Option | nvarchar (260) | Printer name to print to. |
prior_payment_amount | Integration_Invoice | decimal (17, 2) | Total amount of all prior payments received at the time of this invoice. |
priority_KEY | History_Of_Schedule_Item | int | |
priority_KEY | Interaction | int | |
priority_KEY | Priority | int | Primary key for this table. |
priority_KEY | Project_Template | int | Key to a Priority that will be used for generated projects. |
priority_KEY | Schedule_Item | int | If Priority does not apply to this type of Schedule_Item, use Normal priority. 998=Low 999=Normal 1000=High |
private__staff_KEY | Custom_Portlet | int | Key of Staff who this portlet belongs to, null if this is a public portlet. |
privilege_data | Security_Group | nvarchar (1024) | A string of 1's and 0's that holds the privileges for this Security Group. The position in the string (0 based) corresponds to Privilege.privilege_KEY. |
privilege_data | User_Session_Pattern | nvarchar (1024) | |
privilege_dependency_KEY | Privilege_Dependency | int | Primary key for this table. |
privilege_KEY | Privilege | int | Database assigned primary key for this table. |
privilege_KEY | Privilege_Dependency | int | Foreign key to a [Privilege]. |
privilege_KEY | Report_Definition_Privilege_Dependency | int | Key of the privilege that this report depends upon. |
processed_for_project_extension | Client_Status_Event | bit | |
produced | Client_Date_Cache | decimal (9, 2) | Produced sum for the Client, principal Client, and entry date |
product_code | Report_Definition_Product | varchar (4) | A product code from license files. |
program_name | Changeset | nvarchar (128) | The friendly name of the application making the changes. |
progress_amount_billed | Integration_Invoice | decimal (17, 2) | If the exporting application understands time and expense, the amount of the invoice that should be matched up with progress. (Optional) |
progress_amount_billed | Invoice | decimal (17, 2) | Denormalized |
progress_bill__gl_entry_export_bill_amount_basis_KEY | GL_Entry_Export_Option | int | |
progress_bill_amount | Client_Date_Cache | decimal (9, 2) | progress_bill_amount sum for the Client, principal Client, and entry date |
progress_bill_gl_account | GL_Entry_Export_Option | nvarchar (60) | |
project__schedule_item_KEY | History_Of_Sheet_Entry | int | |
project__schedule_item_KEY | Sheet_Entry | int | Cached value of the schedule_item_KEY for the associated Project. |
project_extension_KEY | History_Of_Project_Extension | int | |
project_extension_KEY | Project_Extension | int | AUTO-INCREMENT: Database assigned primary key for this table. |
project_KEY | History_Of_Project | int | |
project_KEY | History_Of_Project_Extension | int | |
project_KEY | History_Of_Sheet_Entry | int | |
project_KEY | History_Of_Task | int | |
project_KEY | Integration_Sheet_Entry | int | Optionally links this Sheet Entry to a Project. |
project_KEY | Project | int | AUTO-INCREMENT: Database assigned primary key for this table. |
project_KEY | Project_Extension | int | Key to a Project record. |
project_KEY | Sheet_Entry | int | Optionally links this Sheet Entry to a Project. |
project_KEY | Task | int | Key of the Project this Task belongs to. |
project_number | History_Of_Project | int | |
project_number | Project | int | User defined number (unique). |
project_template_assignment_KEY | Project_Template_Assignment | int | |
project_template_definition_extension_KEY | Project_Template_Definition_Extension | int | Database assigned primary key for this table. |
project_template_definition_id | Project_Template_Definition | nvarchar (11) | User defined ID (unique). A Project Template created from this Project Template Definition will this as its ID. |
project_template_definition_id_sortable | Project_Template_Definition | varchar (48) | A representation of the project_template_definition_id column that sorts in natural order, meaning that digits are sorted as numbers while non-digits are sorted alphabetically. A trigger keeps this field synchronized with the content of project_template_definition_id. |
project_template_definition_imported_KEY | Project_Template_Definition_Imported | int | Assigned by COMMON_dp_Allocate_Unique_Identifiers. Database assigned primary key for this table. |
project_template_definition_KEY | Project_Template_Definition | int | Database assigned primary key for this table. |
project_template_definition_KEY | Project_Template_Definition_Extension | int | Key to a Project Template Definition record. |
project_template_definition_KEY | Project_Template_Definition_Imported | int | |
project_template_entity_KEY | Project_Template_Entity | int | AUTO-INCREMENT: Database assigned primary key for this table. |
project_template_extension_KEY | Project_Template_Extension | int | AUTO-INCREMENT: Database assigned primary key for this table. |
project_template_id | History_Of_Project | nvarchar (11) | |
project_template_id | Project | nvarchar (11) | Cached value of the project_template_id for the associated Project template. |
project_template_id | Project_Template | nvarchar (11) | User defined ID (unique). |
project_template_id_sortable | History_Of_Project | varchar (48) | |
project_template_id_sortable | Project | varchar (48) | Cached value of the project_template_id_sortable for the associated Project template. |
project_template_id_sortable | Project_Template | varchar (48) | A representation of the project_template_id column that sorts in natural order, meaning that digits are sorted as numbers while non-digits are sorted alphabetically. A trigger keeps this field synchronized with the content of project_template_id. |
project_template_KEY | History_Of_Project | int | |
project_template_KEY | History_Of_Task | int | |
project_template_KEY | Project | int | Key to the Project Template that was used to generate this Project. |
project_template_KEY | Project_Template | int | Assigned by COMMON_dp_Allocate_Unique_Identifiers. Database assigned primary key for this table. |
project_template_KEY | Project_Template_Assignment | int | Which project template this assignment is for. |
project_template_KEY | Project_Template_Entity | int | Key to a Project Template record. |
project_template_KEY | Project_Template_Extension | int | Key to a Project Template record. |
project_template_KEY | Task | int | Key of the Project Template of the Project this Task belongs to, copied here so that Declarative Referential Integrity can be used between Task and Task_Template. |
project_template_KEY | Task_Template | int | |
property_name | Database_Property | nvarchar (128) | Name of this property (unique). |
property_value | Database_Property | nvarchar (-1) | Value of the property stored as a unicode string. |
publication_date | Feed_Channel | datetime | |
rate | Taxing_Authority | decimal (7, 6) | Percentage rate that this Taxing Authority's tax calculation. |
rate_type_KEY | Activity | int | 1=No Rate, 2=Staff Rate, 3=Fixed Rate (Always 3 for expense) |
rate_type_KEY | Engagement | int | Key to a Rate Type record. (1=No Rate, 2=Staff Rate, 3=Fixed Rate) |
rate_type_KEY | History_Of_Engagement | int | |
read_date_utc | Recorded_Event_Notification | datetime | Date recipent read the notification in UTC. |
receipt_entry__bank_account_KEY | User_Preference | int | Default Bank. |
receipt_entry__ledger_entry_type_KEY | User_Preference | int | Default Type. |
receipt_entry__user_preference_default_entry_date_KEY | User_Preference | int | Default Date. |
receipt_entry__user_preference_default_sheet_date_KEY | User_Preference | int | Default Control Date. |
receipt_entry_adjustment__bank_account_KEY | User_Preference | int | Default Bank for adjusting entries (CCR, NSF, DM, CM, WO). |
receipt_entry_adjustment_bank_description_hide | User_Preference | bit | Hides Bank description for adjusting entries (CCR, NSF, DM, CM, WO). |
receipt_entry_adjustment_bank_hide | User_Preference | bit | Hides Bank for adjusting entries (CCR, NSF, DM, CM, WO). |
receipt_entry_adjustment_bank_skip | User_Preference | bit | Skips Bank for adjusting entries (CCR, NSF, DM, CM, WO). |
receipt_entry_auto_apply_to_oldest | User_Preference | bit | Automatically apply new receipts to the oldest outstanding items. |
receipt_entry_auto_check_spelling | User_Preference | bit | |
receipt_entry_bank_description_hide | User_Preference | bit | |
receipt_entry_bank_hide | User_Preference | bit | Hides Bank. |
receipt_entry_bank_skip | User_Preference | bit | Skips Bank. |
receipt_entry_client_description_hide | User_Preference | bit | |
receipt_entry_comment | User_Preference | nvarchar (-1) | Default Comment. |
receipt_entry_comment_hide | User_Preference | bit | Hides Comment. |
receipt_entry_comment_skip | User_Preference | bit | Skips Comment. |
receipt_entry_custom_fields_hide | User_Preference | bit | When true the custom fields button column in receipt entry will be hidden |
receipt_entry_custom_fields_skip | User_Preference | bit | When true the custom fields button column in receipt entry will be skipped |
receipt_entry_display_applied_amounts_screen | User_Preference | bit | Automatically display the Applied Amounts form after they enter an amount. |
receipt_entry_display_custom_fields | User_Preference | bit | When true the custom fields button column in receipt entry will be auto-displayed |
receipt_entry_display_hash_totals | User_Preference | bit | Displays hash totals. |
receipt_entry_display_links | User_Preference | bit | When true the links button column in receipt entry will be auto-displayed |
receipt_entry_entry_date_hide | User_Preference | bit | Hides Date. |
receipt_entry_entry_date_skip | User_Preference | bit | Skips Date. |
receipt_entry_implied_decimal | User_Preference | bit | Automatically inserts decimal point at end of Amount. |
receipt_entry_invoice_search_hide | User_Preference | bit | When true the invoice search column in receipt entry will be hidden |
receipt_entry_invoice_search_skip | User_Preference | bit | When true the invoice search column in receipt entry will be skipped |
receipt_entry_ledger_entry_type_skip | User_Preference | bit | Skips Type. |
receipt_entry_links_hide | User_Preference | bit | When true the links button column in receipt entry will be hidden |
receipt_entry_links_skip | User_Preference | bit | When true the links button column in receipt entry will be skipped |
receipt_entry_reference_hide | User_Preference | bit | Hides Reference. |
receipt_entry_reference_skip | User_Preference | bit | Skips Reference. |
receipt_entry_sheet_date_skip | User_Preference | bit | Skips Control Date. |
receipt_entry_startup_tab | User_Preference | nvarchar (100) | Which tab to start on. |
receipt_entry_type_description_hide | User_Preference | bit | |
receipts_gl_account | GL_Entry_Export_Option | nvarchar (60) | |
received_date | History_Of_Project | smalldatetime | |
received_date | Project | smalldatetime | Date the information required to begin the project was recieved. |
recorded_event_KEY | Recorded_Event | int | AUTO-INCREMENT: Database assigned primary key for this table |
recorded_event_KEY | Recorded_Event_Notification | int | Key of parent Recorded_Event record. |
recorded_event_KEY | Schedule_Item_Reminder_Recorded_Event | int | The [Recorded_Event] that is the reminder. |
recorded_event_notification_KEY | Recorded_Event_Notification | int | AUTO-INCREMENT: Database assigned primary key for this table |
recurrence_expiration_method_KEY | History_Of_Schedule_Item_Series | int | |
recurrence_expiration_method_KEY | Recurrence_Expiration_Method | int | Assigned primary key for this table. |
recurrence_expiration_method_KEY | Schedule_Item_Series | int | |
recurrence_generation_method_KEY | History_Of_Schedule_Item_Series | int | |
recurrence_generation_method_KEY | Project_Template_Definition | int | |
recurrence_generation_method_KEY | Recurrence_Generation_Method | int | Assigned primary key for this table. |
recurrence_generation_method_KEY | Schedule_Item_Series | int | Indicates how this schedule item will be generated. |
recurrence_method_KEY | History_Of_Schedule_Item_Series | int | |
recurrence_method_KEY | Recurrence_Method | int | Assigned primary key for this table. |
recurrence_method_KEY | Schedule_Item_Series | int | Indicates whether this recurrs and where to get the recurrence information from. |
recurrence_rule | Benefit | nvarchar (-1) | Text of the iCalendar recurrence rules and exteneded properties that make up the benefit recurrence. |
recurrence_rule | History_Of_Schedule_Item_Series | nvarchar (-1) | |
recurrence_rule | Monitored_Event | nvarchar (-1) | iCalendar expression for computing the next_check_date. |
recurrence_rule | Project_Template_Definition | nvarchar (-1) | Text of the iCalendar recurrence rules and exteneded properties that make up the due date recurrence. |
recurrence_rule | Schedule_Item_Series | nvarchar (-1) | Text of the iCalendar recurrence rules and exteneded properties that make up the date recurrence. |
recurring_bill | Billing_Decision | bit | When set to 1 will indicate that this billing decision is from a recurring bill engagement. Billing decisions that existed prior to Practice CS 2011.2 will not be marked as recurring bill. |
recurring_bill__activity_KEY | Engagement | int | Key to an Activity record to be used for a progress method recurring bill (required if and only if recurring_bill_method_KEY=1). |
recurring_bill__activity_KEY | History_Of_Engagement | int | |
recurring_bill__staff_KEY | Engagement | int | Key to a Staff record to be used for progress method recurring bill (required if and only if recurring_bill_method_KEY=1). |
recurring_bill__staff_KEY | History_Of_Engagement | int | |
recurring_bill_amount | Engagement | decimal (9, 2) | The user will need to enter an amount if the engagement is going to be setup for recurring billing. |
recurring_bill_amount | History_Of_Engagement | decimal (9, 2) | |
recurring_bill_KEY | Engagement | int | Key to a Recurring Bill record. |
recurring_bill_KEY | History_Of_Engagement | int | |
recurring_bill_KEY | Recurring_Bill | int | AUTO-INCREMENT: Database assigned primary key for this table |
recurring_bill_method_KEY | Engagement | int | Key to a Recurring Bill Method record (required if and only if recurring_bill_KEY is not null). |
recurring_bill_method_KEY | History_Of_Engagement | int | |
reference | Integration_Invoice | nvarchar (30) | User defined reference for this entry. |
reference | Ledger_Entry | nvarchar (30) | User defined reference for this entry. |
REFERENCED_COLUMN_NAME | COMMON_Metadata_About_Foreign_Keys | nvarchar (128) | |
REFERENCED_TABLE_NAME | COMMON_Metadata_About_Foreign_Keys | nvarchar (128) | |
referral_source_KEY | Referral_Source | int | AUTO-INCREMENT: Database assigned primary key for this table. |
referral_type_KEY | Client | int | Key to a Referral Type record. |
referral_type_KEY | History_Of_Client | int | |
referred_by__client_KEY | Client | int | Key to a Client record. |
referred_by__client_KEY | History_Of_Client | int | |
referred_by__contact_KEY | Client | int | Key to a Contact record. |
referred_by__contact_KEY | History_Of_Client | int | |
referred_by__referral_source_KEY | Client | int | Key to a Referral Source record. |
referred_by__referral_source_KEY | History_Of_Client | int | |
referred_by__staff_KEY | Client | int | Key to a Staff record. |
referred_by__staff_KEY | History_Of_Client | int | |
registration_date | History_Of_Portal_User | datetime | |
registration_date | Portal_User | datetime | The time at which this Portal's registration was completed |
registration_sent_date | History_Of_Portal_User | datetime | |
registration_sent_date | Portal_User | datetime | The time at which this Portal's registration email was sent |
relieve_nonbillable_wip | Firm | bit | |
remaining_hours_adjustment | History_Of_Schedule_Item | decimal (9, 2) | |
remaining_hours_adjustment | Schedule_Item | decimal (9, 2) | Cached value of the hours on Schedule_Item_Budget_Remaining_Entry rows associated with this row. |
remaining_hours_adjustment_count | History_Of_Schedule_Item | int | |
remaining_hours_adjustment_count | Schedule_Item | int | Cached count of the Schedule_Item_Budget_Remaining_Entry rows associated with this row. |
remember_logon_allowed | Firm | bit | |
reminder_date_utc | History_Of_Schedule_Item | datetime | |
reminder_date_utc | Schedule_Item | datetime | The date the reminder is to be recorded. |
reminder_date_utc | Schedule_Item_Pending_Reminder | datetime | The date the reminder is to be recorded. This value must match the value in [Schedule_Item_Reminder]. |
report_based_portlet_KEY | Report_Based_Portlet | int | Primary key |
report_category_KEY | Report_Category | int | Primary key for this table |
report_category_KEY | Report_Definition | int | Key of the Report Category that this row is assigned |
report_definition_guid | Report_Definition | uniqueidentifier | A database generated unique key for this table. |
report_definition_guid | Report_Definition_Product | uniqueidentifier | The license__report_definition_guid value from Report_Definition that depends on product_code. |
report_definition_guid | Report_Definition_Security_Group | uniqueidentifier | Foreign key to Report Definition. |
report_definition_KEY | Invoice | int | Key to an Invoice Report Definition record. |
report_definition_KEY | Report_Based_Portlet | int | Key of the report definition of the report that this report-based portlet will display. |
report_definition_KEY | Report_Definition | int | AUTO-INCREMENT: Database assigned primary key for this table. |
report_definition_KEY | Report_Definition_Update_List | int | |
report_definition_KEY | Report_Profile_Report_Definition | int | Key to a Report Definition that belongs to this profile. |
report_definition_KEY | Staff_Report_Definition | int | Key to a Report Definition to which these default options belong. |
report_definition_security_group_KEY | Report_Definition_Security_Group | int | AUTO-INCREMENT: Database assigned primary key for this table |
report_definition_update_list_KEY | Report_Definition_Update_List | int | |
report_image | Report_Image | varbinary (-1) | |
report_image_KEY | Report_Image | int | |
report_options | Report_Profile_Report_Definition | nvarchar (-1) | The report options in serialized XML format. |
report_profile_KEY | Report_Profile | int | AUTO-INCREMENT: Database assigned primary key for this table |
report_profile_KEY | Report_Profile_Report_Definition | int | Key to the Report Profile that this report is used on. |
report_profile_report_definition_KEY | Report_Profile_Report_Definition | int | AUTO-INCREMENT: Database assigned primary key for this table |
report_type_KEY | Report_Definition | int | Key of the Report Type that this row is assigned |
report_type_KEY | Report_Profile | int | Key of the Report Type that this row is assigned. |
require_billing_approval | Firm | bit | True if the approval and posting process is required for Billing. |
require_entry_project | Firm | bit | |
require_receipt_approval | Firm | bit | True if the approval and posting process is required for Receipt Entry. |
require_sheet_approval | Firm | bit | True if the approval and posting process is required for Time and Expense Entry. |
resolved_end_date_utc | Changeset | datetime | The value to use for the ending time of this Changeset. |
response | Ledger_Entry_Submittal_Result | nvarchar (200) | Contents of the response field in the response returned by Intercept. |
responsecode | Ledger_Entry_Submittal_Result | nvarchar (6) | Contents of the responsecode field in the response returned by Intercept. |
responsible__staff_grouping_type_KEY | Project_Template | int | Key to a Staff Grouping Type that indicates how to determine which staff will be responsible for generated projects. |
responsible__staff_KEY | History_Of_Project | int | |
responsible__staff_KEY | Project | int | Key to a Staff that will be responsible for generated projects. |
responsible__staff_KEY | Project_Template | int | Key to a Staff that will be responsible for generated projects. |
returning_utc | Staff_Locator | datetime | Date and time the staff will return in UTC. |
reviewer__staff_grouping_type_KEY | Engagement_Template | int | Key to a Staff Grouping Type that indicates how to determine which staff will be assigned to generated engagements. |
reviewer__staff_KEY | Engagement | int | Key to a Staff record. |
reviewer__staff_KEY | History_Of_Engagement | int | |
revise__changeset_KEY | History_Of_Additional_Contact | int | |
revise__changeset_KEY | History_Of_Attachment | int | |
revise__changeset_KEY | History_Of_Attachment_Content | int | |
revise__changeset_KEY | History_Of_Calendar_Category | int | |
revise__changeset_KEY | History_Of_Client | int | |
revise__changeset_KEY | History_Of_Client_Financial_Data | int | |
revise__changeset_KEY | History_Of_Client_Financial_Data_Description | int | |
revise__changeset_KEY | History_Of_Client_Staff_Grouping | int | |
revise__changeset_KEY | History_Of_Contact | int | |
revise__changeset_KEY | History_Of_Contact_Address | int | |
revise__changeset_KEY | History_Of_Contact_Category | int | |
revise__changeset_KEY | History_Of_Contact_Contact_Category | int | |
revise__changeset_KEY | History_Of_Contact_Email | int | |
revise__changeset_KEY | History_Of_Contact_Phone | int | |
revise__changeset_KEY | History_Of_Custom_Chart | int | |
revise__changeset_KEY | History_Of_Custom_Field | int | |
revise__changeset_KEY | History_Of_Custom_Value | int | |
revise__changeset_KEY | History_Of_Digita_Vat_Period | int | |
revise__changeset_KEY | History_Of_Engagement | int | |
revise__changeset_KEY | History_Of_File_Transfer | int | |
revise__changeset_KEY | History_Of_File_Transfer_Event | int | |
revise__changeset_KEY | History_Of_File_Transfer_File | int | |
revise__changeset_KEY | History_Of_Link | int | |
revise__changeset_KEY | History_Of_Link_Group | int | |
revise__changeset_KEY | History_Of_Portal_User | int | |
revise__changeset_KEY | History_Of_Project | int | |
revise__changeset_KEY | History_Of_Project_Extension | int | |
revise__changeset_KEY | History_Of_Schedule_Entry | int | |
revise__changeset_KEY | History_Of_Schedule_Item | int | |
revise__changeset_KEY | History_Of_Schedule_Item_Assignment | int | |
revise__changeset_KEY | History_Of_Schedule_Item_Budget_Remaining_Entry | int | |
revise__changeset_KEY | History_Of_Schedule_Item_Series | int | |
revise__changeset_KEY | History_Of_Sheet_Entry | int | |
revise__changeset_KEY | History_Of_Tag | int | |
revise__changeset_KEY | History_Of_Tagged_Item | int | |
revise__changeset_KEY | History_Of_Task | int | |
revise__changeset_KEY | History_Of_Time_Zone | int | |
revise__changeset_KEY | History_Of_Timer | int | |
round | Service_Charge | bit | Round to the nearest dollar when true. |
round_extension | Activity | bit | Used to determine if WIP will be rounded to the nearest dollar when it is calculated |
rounding_increment | History_Of_Timer | decimal (4, 2) | |
rounding_increment | Timer | decimal (4, 2) | The Rounding Increment that was in place when the Timer was started. |
rounding_method_KEY | History_Of_Timer | int | |
rounding_method_KEY | Timer | int | The Rounding Method that was in place when the Timer was started. |
row_KEY | Attachment | int | Which row in the table indicated by [table_information_KEY]. |
row_KEY | Custom_Value | int | Which row in the table indicated by [table_information_KEY]. |
row_KEY | History_Of_Attachment | int | |
row_KEY | History_Of_Custom_Value | int | |
row_KEY | History_Of_Link_Group | int | |
row_KEY | History_Of_Tagged_Item | int | |
row_KEY | Integration_Custom_Value | int | |
row_KEY | Link_Group | int | The primary key to the Practice item that this group aggregates links for. |
row_KEY | Monitored_Event_Action | int | Optional key value that specifies entity to notify. |
row_KEY | Tagged_Item | int | Which row in that table indicated by [table_information_KEY]. |
row_version | Changeset | timestamp | |
row_version | Client_Status_Event | timestamp | |
row_version | Firm_Date | timestamp | |
row_version | History_Of_Project | binary (8) | |
row_version | History_Of_Project_Extension | binary (8) | |
row_version | History_Of_Sheet_Entry | binary (8) | |
row_version | History_Of_Task | binary (8) | |
row_version | Integration_Application | timestamp | |
row_version | Integration_Invoice | timestamp | |
row_version | Integration_Invoice_Prior_Payment | timestamp | |
row_version | Integration_Sheet_Entry | timestamp | |
row_version | Invoice | timestamp | |
row_version | Ledger_Entry | timestamp | |
row_version | Ledger_Entry_Application | timestamp | |
row_version | Ledger_Entry_Service_Charge | timestamp | |
row_version | Lost_Reason | timestamp | |
row_version | Lost_To | timestamp | |
row_version | Project | timestamp | |
row_version | Project_Extension | timestamp | |
row_version | Project_Template | timestamp | |
row_version | Project_Template_Definition | timestamp | |
row_version | Project_Template_Definition_Extension | timestamp | |
row_version | Project_Template_Definition_Imported | timestamp | |
row_version | Project_Template_Entity | timestamp | |
row_version | Project_Template_Extension | timestamp | |
row_version | Referral_Source | timestamp | |
row_version | Sheet_Entry | timestamp | |
row_version | Staff_Skill_Area | timestamp | |
row_version | Staff_Skill_Rating | timestamp | |
row_version | Status_Event | timestamp | |
row_version | Status_Event_Type | timestamp | |
row_version | Task | timestamp | |
row_version | Task_Template | timestamp | |
row_version | Tracking_Description | timestamp | |
row_version | Won_Reason | timestamp | |
sales_tax | Billing_Decision | decimal (9, 2) | Sum of Billing_Decision_Taxing_Authority.amount for this Billing_Decision for Taxing_Authority records of sales tax. |
sales_tax | Client_Date_Cache | decimal (9, 2) | sales_tax sum for the Client, principal Client, and entry date |
sales_tax | Integration_Invoice | decimal (17, 2) | Amount of sales tax on this invoice. |
sales_tax | Invoice | decimal (17, 2) | Denormalized |
sales_tax_collected | Billing_Decision_Collection | decimal (9, 2) | The amount collected for the sales tax of the Billing_Decision. |
salt | Practice_User | nvarchar (8) | |
salutation | Contact | nvarchar (40) | Salutation for opening letters. |
salutation | History_Of_Contact | nvarchar (40) | |
scale | Custom_Field | int | |
scale | History_Of_Custom_Field | int | |
schedule_entry_duration | History_Of_Schedule_Entry | int | |
schedule_entry_duration | Schedule_Entry | int | The duration of the schedule entry on the timeline in minutes. |
schedule_entry_end__time_zone_KEY | History_Of_Schedule_Entry | smallint (5) | |
schedule_entry_end__time_zone_KEY | Schedule_Entry | smallint (5) | The time zone selected by the last person editing [schedule_entry_end_utc]. |
schedule_entry_end_utc | History_Of_Schedule_Entry | datetime | |
schedule_entry_end_utc | Schedule_Entry | datetime | COMPUTED: The ending date and time in UTC computed from [schedule_entry_start_utc] and [schedule_entry_duration]. |
schedule_entry_KEY | History_Of_Schedule_Entry | int | |
schedule_entry_KEY | Schedule_Entry | int | |
schedule_entry_scheduled | History_Of_Schedule_Entry | int | |
schedule_entry_scheduled | Schedule_Entry | int | The number of minutes this entry has actually been scheduled for. It can be any amount less than or equal to [schedule_entry_duration]. |
schedule_entry_start__time_zone_KEY | History_Of_Schedule_Entry | smallint (5) | |
schedule_entry_start__time_zone_KEY | Schedule_Entry | smallint (5) | The time zone selected by the last person editing [schedule_entry_start_utc]. |
schedule_entry_start_utc | History_Of_Schedule_Entry | datetime | |
schedule_entry_start_utc | Schedule_Entry | datetime | The starting date and time in UTC. |
schedule_item_assignment_KEY | History_Of_Schedule_Item_Assignment | int | |
schedule_item_assignment_KEY | Schedule_Item_Assignment | int | |
schedule_item_assignment_rank | History_Of_Schedule_Item_Assignment | int | |
schedule_item_assignment_rank | Schedule_Item_Assignment | int | This is a ranking per [staff_KEY] of which schedule items to do first. Duplicates are allowed to reduce concurrency issues. A value of 999999999 indicates the assignment is not ranked. |
schedule_item_budget_remaining_entry_KEY | History_Of_Schedule_Item_Budget_Remaining_Entry | int | |
schedule_item_budget_remaining_entry_KEY | Schedule_Item_Budget_Remaining_Entry | int | Assigned by COMMON_dp_Allocate_Unique_Identifiers. Primary key for this table. |
schedule_item_KEY | Education_Credit | int | |
schedule_item_KEY | History_Of_Project | int | |
schedule_item_KEY | History_Of_Schedule_Entry | int | |
schedule_item_KEY | History_Of_Schedule_Item | int | |
schedule_item_KEY | History_Of_Schedule_Item_Assignment | int | |
schedule_item_KEY | History_Of_Schedule_Item_Budget_Remaining_Entry | int | |
schedule_item_KEY | History_Of_Task | int | |
schedule_item_KEY | Project | int | The [Schedule_Item] that owns this link. |
schedule_item_KEY | Schedule_Entry | int | Link to the schedule item of the assignment that is being scheduled (or at least partially scheduled) by this record. |
schedule_item_KEY | Schedule_Item | int | Assigned by COMMON_dp_Allocate_Unique_Identifiers. Assigned primary key for this table. |
schedule_item_KEY | Schedule_Item_Assignment | int | Which schedule item this assignment is for. |
schedule_item_KEY | Schedule_Item_Assignment_List_Cache | int | Key to the [Schedule_Item] row that these assignments are associated with. |
schedule_item_KEY | Schedule_Item_Budget_Remaining_Entry | int | Schedule item key to which this entry belongs. |
schedule_item_KEY | Schedule_Item_Date_Index | int | |
schedule_item_KEY | Schedule_Item_Last_In_Series | int | Key of the last Schedule Item in the series. |
schedule_item_KEY | Schedule_Item_Pending_Reminder | int | The [Schedule_Item_Reminder] that owns this link. |
schedule_item_KEY | Schedule_Item_Reminder_Recorded_Event | int | The [Schedule_Item] that the reminder is for. |
schedule_item_KEY | Task | int | |
schedule_item_note | History_Of_Schedule_Item | nvarchar (-1) | |
schedule_item_note | Schedule_Item | nvarchar (-1) | Any comments or notes about the item. |
schedule_item_series_KEY | History_Of_Schedule_Item | int | |
schedule_item_series_KEY | History_Of_Schedule_Item_Series | int | |
schedule_item_series_KEY | Project_Template | int | Key of series that goes with this project template. |
schedule_item_series_KEY | Schedule_Item | int | The linked [Schedule Item Series]. |
schedule_item_series_KEY | Schedule_Item_Generation_Date | int | Key of the schedule item series. |
schedule_item_series_KEY | Schedule_Item_Last_In_Series | int | Primary key for this table. |
schedule_item_series_KEY | Schedule_Item_Series | int | Assigned by COMMON_dp_Allocate_Unique_Identifiers. Assigned primary key for this table. |
schedule_item_type_KEY | History_Of_Schedule_Item | int | |
schedule_item_type_KEY | Schedule_Item | int | Key to one of the [Schedule_Item_Type] records. Knowing the type can make finding the associated data easier. 1=Project 2=Task 3=To Do 4=Scheduled Benefit 5=Scheduled Phone Call 6=Meeting 7=Education Course |
scheduled_benefit_status_KEY | History_Of_Schedule_Item | int | |
scheduled_benefit_status_KEY | Schedule_Item | int | Only allowed for items of type scheduled benefit. 1=Pending 2=Approved 3=Denied |
scheduled_phone_call_status_KEY | History_Of_Schedule_Item | int | |
scheduled_phone_call_status_KEY | Schedule_Item | int | Only allowed for items of type scheduled phone call. 1=Scheduled 2=Attempted 3=Completed |
search_subfolders | Outlook_Index_Folder_Firm | bit | Specifies if subfolders should also be searched. |
security_enabled | Firm | bit | |
security_group_KEY | Report_Definition_Security_Group | int | Foreign key to Security Group. |
security_group_KEY | Security_Group | int | AUTO-INCREMENT: Database assigned primary key for this table. |
security_group_KEY | Staff_Security_Group | int | Foreign key to Security Group. |
selected | Filter_Select | int | The value of the primary key for the selected item. |
separate_zero_invoice_numbering | Firm | bit | Use separate invoice numbering sequence for zero amounts. |
server_application_name | Update_Data_Version_History | nvarchar (200) | |
server_application_name | User_Session_Pattern | nvarchar (200) | |
service_charge__ledger_entry_KEY | Ledger_Entry_Service_Charge | int | Key to the Ledger Entry that is the Service Charge. |
service_charge_KEY | Client | int | Key to a Service Charge record. |
service_charge_KEY | Firm | int | Key to a Service Charge record. |
service_charge_KEY | History_Of_Client | int | |
service_charge_KEY | Service_Charge | int | AUTO-INCREMENT: Database assigned primary key for this table |
service_charge_type_KEY | Service_Charge | int | Key from one of the Service Charge Types. 1=Invoice Date, 2=Due Date, 3=Due Date + Grace Days |
service_charges_gl_account | GL_Entry_Export_Option | nvarchar (60) | |
service_tax | Billing_Decision | decimal (9, 2) | Sum of Billing_Decision_Taxing_Authority.amount for this Billing_Decision for Taxing_Authority records of type service tax. |
service_tax | Client_Date_Cache | decimal (9, 2) | service_tax sum for the Client, principal Client, and entry date |
service_tax | Integration_Invoice | decimal (17, 2) | Amount of service tax on this invoice. |
service_tax | Invoice | decimal (17, 2) | Denormalized |
service_tax_collected | Billing_Decision_Collection | decimal (9, 2) | The amount collected for the service tax of the Billing_Decision. |
service_type | Gofileroom_Workflow | nvarchar (255) | GoFileRoom folder name in which this workflow exists. |
service_type_id | Gofileroom_Workflow | int | One of four required fields that uniquely identify a workflow, not intended to be viewed by users. |
sheet_date | History_Of_Sheet_Entry | smalldatetime | |
sheet_date | Integration_Sheet_Entry | smalldatetime | Date of the Sheet, also known as control date. |
sheet_date | Sheet_Entry | smalldatetime | Date of the Sheet, also known as control date. |
sheet_date | Staff_Benefit_Entry | smalldatetime | The sheet date that this entry corresponds to. |
sheet_entry_KEY | Billing_Decision | int | The Sheet Entry this billing is for. |
sheet_entry_KEY | Billing_Decision_Collection | int | The combination of ledger_entry_KEY and sheet_entry_KEY identifies the billing decision this collection is for. |
sheet_entry_KEY | Billing_Decision_Tax_Collection | int | The combination of ledger_entry_KEY, sheet_entry_KEY and taxing_authority_KEY identifies the BDTA row this collection is for. |
sheet_entry_KEY | Billing_Decision_Taxing_Authority | int | The combination of ledger_entry_KEY and sheet_entry_KEY identifies the Billing_Decision row this tax is charged for. |
sheet_entry_KEY | History_Of_Sheet_Entry | int | |
sheet_entry_KEY | History_Of_Timer | int | |
sheet_entry_KEY | Sheet_Entry | int | Assigned by COMMON_dp_Allocate_Unique_Identifiers. Database assigned primary key for this table. |
sheet_entry_KEY | Sheet_Entry_Open_Value_Cache | int | Key to a Sheet_Entry row. |
sheet_entry_KEY | Timer | int | The key to the Sheet Entry row this timer is for. |
sheet_entry_type_KEY | History_Of_Sheet_Entry | int | |
sheet_entry_type_KEY | Integration_Sheet_Entry | int | Key to Sheet Entry Type indicating what type of entry this is. |
sheet_entry_type_KEY | Sheet_Entry | int | 1=Standard 2=Progress Billing 3=Billing Adjustment 4=Timer Entry 5=Remote Standard 6=Exported Remote Standard |
show_desktop_notifications_until_closed | User_Preference | bit | |
signature_reject_date_utc | File_Transfer_File | datetime | The time at which this file's signature request was rejected |
signature_reject_date_utc | History_Of_File_Transfer_File | datetime | |
signature_request_date_utc | File_Transfer_File | datetime | The time at which this file's signature request was created |
signature_request_date_utc | History_Of_File_Transfer_File | datetime | |
signature_sign_date_utc | File_Transfer_File | datetime | The time at which this file's signature request was signed |
signature_sign_date_utc | History_Of_File_Transfer_File | datetime | |
singular | Term | nvarchar (50) | User defined singular description. |
skip_column | User_Preference_Custom_Field_Column | bit | Whether or not this field should be skipped in Time and expense entry |
social_security_number | Staff | nvarchar (11) | Social Security Number. |
solution_type_name | History_Of_Project | nvarchar (50) | |
solution_type_name | History_Of_Task | nvarchar (50) | |
solution_type_name | Project | nvarchar (50) | Name of the type of solution that is used for this Project. The system has a finite set of solution type names defined. |
solution_type_name | Project_Template | nvarchar (50) | Name of the type of solution that is used for Projects generated from this Template. The system has a finite set of solution type names defined. |
solution_type_name | Task | nvarchar (50) | Name of the type of solution that is used for this Task. The system has a finite set of solution type names defined. |
solution_type_name | Task_Template | nvarchar (50) | |
sort | Client_Shortcut | int | A value indicating what order to sort items in. Ideally this would be constrained to be unique per shortcut group, but that adds unneccessary complication to the code that saves these records. |
sort | Client_Shortcut_Group | int | User-configurable sequence number that defines the order in which the solution group will appear in the Solutions portlet. |
sort | Custom_Field | int | Sort order of this custom field when it is displayed. The fields should be sorted by position and description. |
sort | Department_Grouping_Type | int | User defined sort for this table. |
sort | Firm_Date_Type | int | User defined sort for this table. |
sort | Firm_Shortcut | int | A value indicating what order to sort items in. Ideally this would be constrained to be unique per shortcut group, but that adds unneccessary complication to the code that saves these records. |
sort | Firm_Shortcut_Group | int | User-configurable sequence number that defines the order in which the solution group will appear in the Solutions portlet. |
sort | History_Of_Custom_Field | int | |
sort | History_Of_Link | int | |
sort | History_Of_Link_Group | int | |
sort | Link | int | A value indicating what order to sort items in |
sort | Link_Group | int | The order in which this group will be displayed |
sort | Priority | int | User defined sort for this table. |
sort | Privilege | int | It is required that the privileges sort in a particular order. This is how the order is specified. |
sort | Recurrence_Expiration_Method | int | User defined sort for this table. |
sort | Recurrence_Generation_Method | int | User defined sort for this table. |
sort | Recurrence_Method | int | User defined sort for this table. |
sort | Staff_Grouping_Type | int | User defined sort for this table. |
sort | Staff_Shortcut | int | A value indicating what order to sort items in. Ideally this would be constrained to be unique per shortcut group, but that adds unneccessary complication to the code that saves these records. |
sort | Staff_Shortcut_Group | int | User-configurable sequence number that defines the order in which the solution group will appear in the Solutions portlet. |
sort | Target_Date_Method | int | User defined sort for this table. |
sort | Tracking_Description | int | User defined sort for this table. |
sort_hierarchy | Privilege | nvarchar (450) | Same as Hierarchy except that the values from Sort column are used. |
sort_order | Report_Category | int | |
sortable_to_date | Benefit_Factor | smalldatetime | The [to_month] and [to_day] columns are combined into the [sortable_to_date] column for sorting and comparison. The year 2000 was selected as the year to base this date on because it is a leap year and it is a nice even number. |
source_machine_name | File_Transfer_File | nvarchar (50) | The original machine name from which the file was uploaded |
source_machine_name | History_Of_File_Transfer_File | nvarchar (50) | |
source_path | File_Transfer_File | nvarchar (260) | The original full path of this file at the time this file was uploaded as part of a File Transfer |
source_path | History_Of_File_Transfer_File | nvarchar (260) | |
SPECIFIC_NAME | COMMON_Metadata_About_Sprocs | nvarchar (128) | |
spouse_date_of_birth | Client | smalldatetime | Date of birth for the spouse of the client if the client is an individual |
spouse_date_of_birth | History_Of_Client | smalldatetime | |
spouse_federal_tin | Client | nvarchar (11) | This field will hold the SSN for an individual client's spouse. |
spouse_federal_tin | History_Of_Client | nvarchar (11) | |
spouse_first_name | Client | nvarchar (100) | First name of the clients spouse if the client type is an individual. |
spouse_first_name | History_Of_Client | nvarchar (100) | |
spouse_last_name | Client | nvarchar (100) | Last name of the clients spouse if the client type is an individual. |
spouse_last_name | History_Of_Client | nvarchar (100) | |
staff__contact_KEY | File_Transfer | int | Staff Contact associated with this File Transfer |
staff__contact_KEY | History_Of_File_Transfer | int | |
staff__portal_user_KEY | File_Transfer | int | Staff Portal_User associated with this File Transfer |
staff__portal_user_KEY | History_Of_File_Transfer | int | |
staff_area_rating_KEY | Staff_Area_Rating | int | AUTO-INCREMENT: Database assigned primary key for this table. |
staff_assignment_method_KEY | History_Of_Schedule_Item | int | |
staff_assignment_method_KEY | Project_Template | int | |
staff_assignment_method_KEY | Schedule_Item | int | 1=Assigned Staff 2=Work Queue |
staff_assignment_method_KEY | Task_Template | int | |
staff_benefit_entry_KEY | Staff_Benefit_Entry | int | Assigned by COMMON_dp_Allocate_Unique_Identifiers. Primary key for this table. |
staff_benefit_KEY | Staff_Benefit | int | Assigned by COMMON_dp_Allocate_Unique_Identifiers. Primary key for this table. |
staff_benefit_KEY | Staff_Benefit_Entry | int | Key to a staff benefit. |
staff_billing_rate_KEY | History_Of_Sheet_Entry | int | |
staff_billing_rate_KEY | Integration_Sheet_Entry | int | Key to the Staff Billing Rate used to calculate the amount. |
staff_billing_rate_KEY | Sheet_Entry | int | Key to the Staff Billing Rate used to calculate the amount. |
staff_billing_rate_KEY | Staff_Billing_Rate | int | AUTO-INCREMENT: Database assigned primary key for this table. |
staff_dashboard_layout | User_Preference | nvarchar (-1) | Layout of the Staff Dashboard stored as XML |
staff_grouping_type_KEY | Staff_Grouping_Type | int | Primary key for this table. |
staff_grouping_type_KEY | Task_Template | int | |
staff_id | Staff | nvarchar (11) | User defined identifier (unique). |
staff_id_sortable | Staff | varchar (48) | A representation of the staff_id column that sorts in natural order, meaning that digits are sorted as numbers while non-digits are sorted alphabetically. A trigger keeps this field synchronized with the content of staff_id. |
staff_KEY | Active_Filter | int | Key to the Staff this filter is in use by. |
staff_KEY | Client_Staff_Grouping | int | |
staff_KEY | Feed_Channel_Item_Staff_Read | int | |
staff_KEY | History_Of_Client_Staff_Grouping | int | |
staff_KEY | History_Of_Schedule_Entry | int | |
staff_KEY | History_Of_Schedule_Item_Assignment | int | |
staff_KEY | History_Of_Sheet_Entry | int | |
staff_KEY | Integration_Sheet_Entry | int | Staff this Sheet Entry is for. |
staff_KEY | Login_Ticket | int | The staff that can be logged in using this ticket. |
staff_KEY | Outlook_Contact_Synchronization_Profile | int | Reference to the staff that owns this filter profile. |
staff_KEY | Practice_User | int | |
staff_KEY | Print_Option | int | The staff these print option are for. |
staff_KEY | Project_Template_Assignment | int | Which staff is assigned. |
staff_KEY | Recorded_Event_Notification | int | Key of staff member who should see the event record in their portal, etc. Null for non staff. |
staff_KEY | Report_Profile | int | Key of the Staff to whom the profile belongs. |
staff_KEY | Restricted_Clearance_Staff | int | A reference to a Staff row that may access a restricted access database. |
staff_KEY | Schedule_Entry | int | Link to the staff of the assignment that is being scheduled (or at least partially scheduled) by this record. |
staff_KEY | Schedule_Item_Assignment | int | Which staff is assigned. |
staff_KEY | Sheet_Entry | int | Staff this Sheet Entry is for. |
staff_KEY | Staff | int | Assigned by COMMON_dp_Allocate_Unique_Identifiers. Database assigned primary key for this table. |
staff_KEY | Staff_Area_Rating | int | Foreign key of the staff this Rate Table belongs to. |
staff_KEY | Staff_Benefit | int | Key to a Staff. |
staff_KEY | Staff_Locator | int | Key to a Staff record |
staff_KEY | Staff_Rate_Table | int | Foreign key of the staff this Rate Table belongs to. |
staff_KEY | Staff_Report_Definition | int | Key to the staff to whom these default options belong. |
staff_KEY | Staff_Security_Group | int | Foreign key to Staff. |
staff_KEY | Staff_Shortcut_Group | int | The staff who own this solution group. |
staff_KEY | Staff_Target_Range | int | Links this record to a particular staff. |
staff_KEY | Task_Template_Assignment | int | Which staff is assigned. |
staff_KEY | User_Preference | int | Key of one of the Staff records |
staff_KEY | User_Session | int | Key to the Staff that this session is for. |
staff_level_id | Staff_Level | nvarchar (11) | User defined identifier (unique). |
staff_level_id_sortable | Staff_Level | varchar (48) | A representation of the staff_level_id column that sorts in natural order, meaning that digits are sorted as numbers while non-digits are sorted alphabetically. A trigger keeps this field synchronized with the content of staff_level_id. |
staff_level_KEY | Accruable_Benefit_Allowance_By_Staff_Level | int | Key to a staff level. |
staff_level_KEY | Staff | int | Key from one of the already set up Staff Levels. |
staff_level_KEY | Staff_Level | int | AUTO-INCREMENT: Database assigned primary key for this table. |
staff_locator_KEY | Staff_Locator | int | AUTO-INCREMENT: Database assigned primary key for this table |
staff_locator_status_KEY | Staff_Locator | int | Key to a Staff Locator Status row |
staff_qualifications__filter_KEY | History_Of_Schedule_Item | int | |
staff_qualifications__filter_KEY | Project_Template | int | |
staff_qualifications__filter_KEY | Schedule_Item | int | An optional Staff filter that represents Staff qualified to work on this item. Some types do not allow Staff qualifications. |
staff_qualifications__filter_KEY | Task_Template | int | |
staff_rate_table_KEY | Staff_Billing_Rate | int | Foreign key to the Staff Rate Table. There can be several Staff Billing Rates per Staff Rate Table |
staff_rate_table_KEY | Staff_Rate_Table | int | AUTO-INCREMENT: Database assigned primary key for this table. |
staff_report_definition_KEY | Staff_Report_Definition | int | AUTO-INCREMENT: Database assigned primary key for this table. |
staff_security_group_KEY | Staff_Security_Group | int | AUTO-INCREMENT: Database assigned primary key for this table. |
staff_shortcut_group_KEY | Staff_Shortcut | int | Associates this solution with its solution group. |
staff_shortcut_group_KEY | Staff_Shortcut_Group | int | Assigned by COMMON_dp_Allocate_Unique_Identifiers. Database assigned primary key for this table |
staff_shortcut_KEY | Staff_Shortcut | int | Assigned by COMMON_dp_Allocate_Unique_Identifiers. Database assigned primary key for this table |
staff_skill_area_KEY | Staff_Area_Rating | int | Foreign key - Registers area of expertise for a given staff. |
staff_skill_area_KEY | Staff_Skill_Area | int | AUTO-INCREMENT: Database assigned primary key for this table. |
staff_skill_area_KEY | Staff_Skill_Area_Rating | int | |
staff_skill_area_rating_KEY | Staff_Skill_Area_Rating | int | |
staff_skill_rating_KEY | Staff_Area_Rating | int | Foreign key - Registers rates expertise for a staff in a particular area |
staff_skill_rating_KEY | Staff_Skill_Area_Rating | int | |
staff_skill_rating_KEY | Staff_Skill_Rating | int | AUTO-INCREMENT: Database assigned primary key for this table. |
staff_status_KEY | Staff | int | Key from one of the already set up Staff Status. |
staff_target_range_KEY | Staff_Target_Range | int | Assigned by COMMON_dp_Allocate_Unique_Identifiers. Manufactured primary key for this table. |
standard_text_id | Standard_Text | nvarchar (11) | User defined identifier (unique). |
standard_text_id_sortable | Standard_Text | varchar (48) | A representation of the standard_text_id column that sorts in natural order, meaning that digits are sorted as numbers while non-digits are sorted alphabetically. A trigger keeps this field synchronized with the content of standard_text_id. |
standard_text_KEY | Standard_Text | int | AUTO-INCREMENT: Database assigned primary key for this table |
standard_vat_rate | Digita_Vat_Period | decimal (4, 2) | The standard vat rate to use for this period |
standard_vat_rate | History_Of_Digita_Vat_Period | decimal (4, 2) | |
start__target_date_method_KEY | History_Of_Schedule_Item_Series | int | |
start__target_date_method_KEY | Project_Template_Definition | int | |
start__target_date_method_KEY | Schedule_Item_Series | int | The method used to calculate the target start date. |
start__target_date_method_KEY | Task_Template | int | |
start_date | Digita_Vat_Period | datetime | The start date for the VAT period. |
start_date | History_Of_Digita_Vat_Period | datetime | |
startup_window | User_Preference | nvarchar (100) | Screen to open at startup |
state_abbreviation | Address | nvarchar (2) | State. |
state_abbreviation | Contact_Address | nvarchar (2) | State. |
state_abbreviation | History_Of_Contact_Address | nvarchar (2) | |
statement__report_definition_KEY | Client | int | Key to an Statement Report Definition record. |
statement__report_definition_KEY | Firm | int | Default statement format for new clients |
statement__report_definition_KEY | History_Of_Client | int | |
statement_email_body | Firm | nvarchar (-1) | |
statement_email_subject | Firm | nvarchar (255) | |
statement_exclude_current_invoice_activity_clients | User_Preference | bit | Excludes clients that have recently been invoiced. |
statement_include_credits | User_Preference | bit | Includes clients that have a credit balance. |
statement_include_debits | User_Preference | bit | Includes clients with debits if they meet over_balance or over_age |
statement_include_debits_over_age | User_Preference | int | Includes a client if the client has a debit older than this many days. |
statement_include_debits_over_balance | User_Preference | decimal (17, 2) | Includes a client if their balance is greater than this. |
statement_include_zero_balance_with_current_activity | User_Preference | bit | Includes clients that have a zero balance but had recent activity. |
status_event_code | Status_Event | nvarchar (11) | |
status_event_KEY | Client_Status_Event | int | Key to the Status_Event that was recorded. |
status_event_KEY | Status_Event | int | AUTO-INCREMENT: Database assigned primary key for this table |
status_event_type_KEY | Status_Event | int | Key to one of the records in the Status_Event_Type table. |
status_event_type_KEY | Status_Event_Type | int | AUTO-INCREMENT: Database assigned primary key for this table |
store_id | Outlook_Store | varbinary (4096) | Holds the binary value of the Outlook(R) StoreID. Convert to a hexadecimal string without the 0x prefix (2 characters for each byte) the COM interface representation. Unique (enforced by a trigger.) |
store_id_checksum | Outlook_Store | int | Since the store_id column is wider than 900 bytes, the SQL Server CHECKSUM function is used to compute an indexable column. This column is not unique. |
subfilter__filter_KEY | Filter_Line | int | If the method is Filter, the key to the filter; otherwise null. |
subfilter__filter_type_KEY | Filter_Line_Type | int | A key to a Filter Type if another filter can be used as a method. |
subject | File_Transfer | nvarchar (255) | subject line of this File Transfer |
subject | History_Of_File_Transfer | nvarchar (255) | |
subject | Interaction | nvarchar (50) | The subject of the interaction, currently limited to 50 characters. |
submittal_status_KEY | Ledger_Entry_Submittal | int | The status for this ledger entry. |
supervisor__staff_KEY | Staff | int | Key of the staff that is this Staff's supervisor. |
surcharge | Billing_Decision | decimal (9, 2) | Surcharge applied to this item, calculated before discount (surcharge rate x bill_amount). |
surcharge | Client_Date_Cache | decimal (9, 2) | surcharge sum for the Client, principal Client, and entry date |
surcharge | Integration_Invoice | decimal (17, 2) | The surcharge amount on this integration_invoice (always 0 or positive.) |
surcharge | Invoice | decimal (17, 2) | Denormalized |
surcharge_amount | Engagement | decimal (9, 2) | Rate to use when surcharge_type_KEY = 3 |
surcharge_amount | History_Of_Engagement | decimal (9, 2) | |
surcharge_collected | Billing_Decision_Collection | decimal (9, 2) | The amount collected for the surcharge of the Billing_Decision. |
surcharge_rate | Activity | decimal (9, 4) | Amount to charge if surcharge_method_KEY=1; Percent to charge if surcharge_method_KEY=2 |
swipe | Ledger_Entry_Submittal | bit | Indicates the user chose to swipe the card on Secure Pay through an external browser |
table_information_KEY | Attachment | int | Which table is the row indicated by row_KEY in. |
table_information_KEY | Changeset_Modified_Table | int | Which table was modified. |
table_information_KEY | Custom_Field | int | Main table that this custom field is associated with. See Custom_Value.table_information_KEY |
table_information_KEY | Custom_Value | int | Which table is the row indicated by [row_KEY] in. This is usually the same as table_information_KEY specified in Custom_Field, but it can be different if you are reusing the Custom Fields of a different type (for example the Project and Project Template tables share the same custom field). |
table_information_KEY | History_Of_Attachment | int | |
table_information_KEY | History_Of_Custom_Field | int | |
table_information_KEY | History_Of_Custom_Value | int | |
table_information_KEY | History_Of_Link_Group | int | |
table_information_KEY | History_Of_Tagged_Item | int | |
table_information_KEY | Link_Group | int | Defines the type of Practice information that this group aggregates links for |
table_information_KEY | Option_List | int | |
table_information_KEY | Table_Information | int | |
table_information_KEY | Tagged_Item | int | Which table is the row indicated by [row_KEY] in. |
TABLE_NAME | COMMON_Metadata_About_Columns | nvarchar (128) | |
TABLE_NAME | COMMON_Metadata_About_Foreign_Keys | nvarchar (128) | |
TABLE_NAME | COMMON_Metadata_About_Keys | nvarchar (128) | |
table_name | COMMON_Unique_Identifier_Counter | nvarchar (128) | |
table_name | Department_Grouping_Type | nvarchar (128) | Name of the table used to find the value. |
table_name | Staff_Grouping_Type | nvarchar (128) | Name of the table used to find the value. |
TABLE_TYPE | COMMON_Metadata_About_Columns | varchar (10) | |
tag_KEY | History_Of_Tag | int | |
tag_KEY | History_Of_Tagged_Item | int | |
tag_KEY | Tag | int | Assigned by COMMON_dp_Allocate_Unique_Identifiers. Key that represents a tag. |
tag_KEY | Tagged_Item | int | Which tag is associated. |
tagged_item_sort | History_Of_Tagged_Item | int | |
tagged_item_sort | Tagged_Item | int | The sort order of the tags on a particular item. |
target | Client_Shortcut | nvarchar (2048) | Target to execute. File name or url. |
target | Datasharing_Path | nvarchar (260) | The file system path in which to read or write datasharing data. |
target | Firm_Shortcut | nvarchar (2048) | Target to execute. File name or url. |
target | History_Of_Link | nvarchar (2048) | |
target | History_Of_Project | nvarchar (1000) | |
target | History_Of_Task | nvarchar (1000) | |
target | Link | nvarchar (2048) | The information used to resolve the link. Depending on the link_type_KEY, this column can store a file system location, an URI, a GoFileRoom document ID, a FileCabinet item ID, etc. |
target | Project | nvarchar (1000) | Target to execute. File name or url. |
target | Project_Template | nvarchar (1000) | Target to execute. File name or url. |
target | Staff_Shortcut | nvarchar (2048) | Target to execute. File name or url. |
target | Task | nvarchar (1000) | Target to execute. File name or url. |
target | Task_Template | nvarchar (1000) | |
target_complete__time_zone_KEY | History_Of_Schedule_Item | smallint (5) | |
target_complete__time_zone_KEY | Schedule_Item | smallint (5) | |
target_complete_date_exclusive_utc | History_Of_Schedule_Item | datetime | |
target_complete_date_exclusive_utc | Schedule_Item | datetime | The end of the valid period (exclusive) for this item to be scheduled. |
target_complete_day | History_Of_Schedule_Item_Series | int | |
target_complete_day | Project_Template_Definition | int | |
target_complete_day | Schedule_Item_Series | int | Number of days relative to complete__target_date_method_KEY to use as the target complete date. |
target_complete_day | Task_Template | int | |
target_complete_month | History_Of_Schedule_Item_Series | int | |
target_complete_month | Project_Template_Definition | int | |
target_complete_month | Schedule_Item_Series | int | Number of months relative to complete__target_date_method_KEY to use as the target complete date. |
target_complete_month | Task_Template | int | |
target_date_method_KEY | Target_Date_Method | int | Primary key for this table. |
target_hours_friday | Staff_Target_Range | decimal (4, 2) | The number of hours expected to be worked on this day of the week. The value must be between 0.00 and 24.00. |
target_hours_monday | Staff_Target_Range | decimal (4, 2) | The number of hours expected to be worked on this day of the week. The value must be between 0.00 and 24.00. |
target_hours_saturday | Staff_Target_Range | decimal (4, 2) | The number of hours expected to be worked on this day of the week. The value must be between 0.00 and 24.00. |
target_hours_sunday | Staff_Target_Range | decimal (4, 2) | The number of hours expected to be worked on this day of the week. The value must be between 0.00 and 24.00. |
target_hours_thursday | Staff_Target_Range | decimal (4, 2) | The number of hours expected to be worked on this day of the week. The value must be between 0.00 and 24.00. |
target_hours_tuesday | Staff_Target_Range | decimal (4, 2) | The number of hours expected to be worked on this day of the week. The value must be between 0.00 and 24.00. |
target_hours_wednesday | Staff_Target_Range | decimal (4, 2) | The number of hours expected to be worked on this day of the week. The value must be between 0.00 and 24.00. |
target_start__time_zone_KEY | History_Of_Schedule_Item | smallint (5) | |
target_start__time_zone_KEY | Schedule_Item | smallint (5) | |
target_start_date_utc | History_Of_Schedule_Item | datetime | |
target_start_date_utc | Schedule_Item | datetime | The start of the valid period for this item to be scheduled. |
target_start_day | History_Of_Schedule_Item_Series | int | |
target_start_day | Project_Template_Definition | int | |
target_start_day | Schedule_Item_Series | int | Number of days relative to start__target_date_method_KEY to use as the target start date. |
target_start_day | Task_Template | int | |
target_start_month | History_Of_Schedule_Item_Series | int | |
target_start_month | Project_Template_Definition | int | |
target_start_month | Schedule_Item_Series | int | Number of months relative to start__target_date_method_KEY to use as the target start date. |
target_start_month | Task_Template | int | |
task__schedule_item_KEY | History_Of_Sheet_Entry | int | |
task__schedule_item_KEY | Sheet_Entry | int | Cached value of the schedule_item_KEY for the associated Task. |
task_KEY | History_Of_Sheet_Entry | int | |
task_KEY | History_Of_Task | int | |
task_KEY | Integration_Sheet_Entry | int | Optionally links this Sheet Entry to a Task. |
task_KEY | Sheet_Entry | int | Optionally links this Sheet Entry to a Task. |
task_KEY | Task | int | AUTO-INCREMENT: Database assigned primary key for this table. |
task_number | History_Of_Task | int | |
task_number | Task | int | Each Task will be assigned a number that is unique that the user can select. |
task_template_assignment_KEY | Task_Template_Assignment | int | |
task_template_KEY | History_Of_Task | int | |
task_template_KEY | Task | int | The linked [Task_Template]. |
task_template_KEY | Task_Template | int | |
task_template_KEY | Task_Template_Assignment | int | Which task template this assignment is for. |
tax_area_KEY | Engagement | int | Key to a Tax Area record. |
tax_area_KEY | History_Of_Engagement | int | |
tax_area_KEY | Tax_Area | int | AUTO-INCREMENT: Database assigned primary key for this table. |
tax_area_KEY | Tax_Area_Taxing_Authority | int | KEY value from the Tax Area table. |
tax_area_taxing_authority_KEY | Tax_Area_Taxing_Authority | int | |
tax_gl_account | GL_Entry_Export_Option | nvarchar (60) | |
tax_year | Client_Financial_Data | int | |
tax_year | History_Of_Client_Financial_Data | int | |
taxing_authority_KEY | Billing_Decision_Tax_Collection | int | The combination of ledger_entry_KEY, sheet_entry_KEY and taxing_authority_KEY identifies the BDTA row this collection is for. |
taxing_authority_KEY | Billing_Decision_Taxing_Authority | int | Key to the Taxing Authority that this tax is charged for. |
taxing_authority_KEY | Tax_Area_Taxing_Authority | int | KEY value from the Tax Authority table. |
taxing_authority_KEY | Taxing_Authority | int | AUTO-INCREMENT: Database assigned primary key for this table. |
taxing_authority_type_KEY | Taxing_Authority | int | The type of tax that this authority is authorized to tax. |
term_KEY | Term | int | Hardcoded primary key. |
text | Recorded_Event | nvarchar (-1) | Summary of what happened in a format suitable for reporting, viewing in a portlet, and so on. |
this_data_path | Firm | nvarchar (260) | |
ticket_guid | Login_Ticket | uniqueidentifier | An identifier for the ticket, randomly generated. |
time_amount_adjusted | Invoice | decimal (17, 2) | Denormalized |
time_amount_billed | Integration_Invoice | decimal (17, 2) | If the exporting application understands time and expense, the amount of the invoice that should be matched up with time. (Optional) |
time_amount_billed | Invoice | decimal (17, 2) | Denormalized |
time_expense__gl_entry_export_bill_amount_basis_KEY | GL_Entry_Export_Option | int | |
time_expense_gl_account | GL_Entry_Export_Option | nvarchar (60) | |
time_zone_base_utc_offset | History_Of_Time_Zone | int | |
time_zone_base_utc_offset | Time_Zone | int | Gets the time difference between this time zone's standard time and Coordinated Universal Time (UTC) in minutes. |
time_zone_identifier | History_Of_Time_Zone | nvarchar (200) | |
time_zone_identifier | Time_Zone | nvarchar (200) | The time zone identifier from Windows (for example from the System.TimeZoneInfo.Id property). |
time_zone_KEY | Contact | smallint (5) | The preferred timezone for the contact. Use this when displaying time to the user and the time zone is not known. |
time_zone_KEY | History_Of_Contact | smallint (5) | |
time_zone_KEY | History_Of_Time_Zone | smallint (5) | |
time_zone_KEY | Time_Zone | smallint (5) | |
timed_out | Ledger_Entry_Submittal_Result | bit | Whether or not we gave up waiting for a response from Intercept. |
timer_KEY | History_Of_Timer | int | |
timer_KEY | Timer | int | Assigned by COMMON_dp_Allocate_Unique_Identifiers. Primary key for this table. |
timer_start_utc | History_Of_Timer | datetime | |
timer_start_utc | Timer | datetime | The date and time this timer was started in UTC. |
tin | Integration_Invoice | nvarchar (11) | TIN of the client the invoice is for. |
title | Contact | nvarchar (250) | Title of the contact. |
title | Feed_Channel | nvarchar (500) | |
title | Feed_Channel_Item | nvarchar (500) | |
title | Feed_Channel_Item_Enclosure | nvarchar (500) | |
title | History_Of_Contact | nvarchar (250) | |
to__ledger_entry_KEY | Ledger_Entry_Application | int | The Ledger Entry that amount_applied is added to. |
to_day | Benefit_Factor | int | The end day of this benefit factor. |
to_month | Accruable_Benefit_Allowance_By_Month | int | The month to which this allowance applies. |
to_month | Benefit_Factor | int | The end month of this benefit factor. |
to_value | Filter_Line | nvarchar (100) | The greater of the two values. |
total_amount_billed | Integration_Invoice | decimal (17, 2) | Total amount of WIP billed by the invoice. |
total_file_size | File_Transfer | int | sum of file sizes of files associated to this File Transfer |
total_file_size | History_Of_File_Transfer | int | |
tracking_description_KEY | History_Of_Schedule_Item | int | |
tracking_description_KEY | Project_Template | int | Key to a Tracking Description that will be used for generated projects. |
tracking_description_KEY | Schedule_Item | int | The linked [Tracking_Description]. |
tracking_description_KEY | Task_Template | int | |
tracking_description_KEY | Tracking_Description | int | AUTO-INCREMENT: Database assigned primary key for this table. |
transaction_id | Changeset_Active | bigint (19) | The SQL Server transaction_id from sys.dm_tran_current_transaction. |
transactionid | Ledger_Entry_Submittal_Result | nvarchar (60) | Contents of the transactionid field in the response returned by Intercept. |
tree_level | Privilege | int | The level in the tree. |
type | Feed_Channel_Item_Enclosure | nvarchar (30) | |
TYPE_NAME | COMMON_Metadata_About_Columns | nvarchar (128) | |
unapplied_receipts_gl_account | GL_Entry_Export_Option | nvarchar (60) | |
unit_cost | Activity | decimal (9, 4) | Cost per unit for expense, 0.0000 for time. |
unit_cost | History_Of_Sheet_Entry | decimal (9, 4) | |
unit_cost | Integration_Sheet_Entry | decimal (9, 4) | Cost per unit (or hour) at the time the amount was computed. |
unit_cost | Sheet_Entry | decimal (9, 4) | Cost per unit (or hour) at the time the amount was computed. |
unit_price | Activity | decimal (9, 4) | Price per unit for expense, price per hour for time when rate_type_KEY=3 or 0.0000 otherwise. |
unit_price | History_Of_Sheet_Entry | decimal (9, 4) | |
unit_price | Integration_Sheet_Entry | decimal (9, 4) | Price per unit (or hour) at the time the amount was computed. Storage is required because amount can be rounded. |
unit_price | Sheet_Entry | decimal (9, 4) | Price per unit (or hour) at the time the amount was computed. Storage is required because amount can be rounded. |
units | History_Of_Sheet_Entry | decimal (9, 2) | |
units | Integration_Sheet_Entry | decimal (9, 2) | Quantity of units (or hours). |
units | Sheet_Entry | decimal (9, 2) | Quantity of units (or hours). |
units_closed | Billing_Decision | decimal (9, 2) | Sheet Entry units closed out by this billing. wip_closed = bill_amount - adjustment. |
update__changeset_KEY | Additional_Contact | int | |
update__changeset_KEY | Attachment | int | |
update__changeset_KEY | Attachment_Content | int | |
update__changeset_KEY | Calendar_Category | int | |
update__changeset_KEY | Client | int | |
update__changeset_KEY | Client_Financial_Data | int | |
update__changeset_KEY | Client_Financial_Data_Description | int | |
update__changeset_KEY | Client_Staff_Grouping | int | |
update__changeset_KEY | Contact | int | |
update__changeset_KEY | Contact_Address | int | |
update__changeset_KEY | Contact_Category | int | |
update__changeset_KEY | Contact_Contact_Category | int | |
update__changeset_KEY | Contact_Email | int | |
update__changeset_KEY | Contact_Phone | int | |
update__changeset_KEY | Custom_Chart | int | |
update__changeset_KEY | Custom_Field | int | |
update__changeset_KEY | Custom_Value | int | |
update__changeset_KEY | Digita_Vat_Period | int | |
update__changeset_KEY | Engagement | int | |
update__changeset_KEY | File_Transfer | int | |
update__changeset_KEY | File_Transfer_Event | int | |
update__changeset_KEY | File_Transfer_File | int | |
update__changeset_KEY | History_Of_Additional_Contact | int | |
update__changeset_KEY | History_Of_Attachment | int | |
update__changeset_KEY | History_Of_Attachment_Content | int | |
update__changeset_KEY | History_Of_Calendar_Category | int | |
update__changeset_KEY | History_Of_Client | int | |
update__changeset_KEY | History_Of_Client_Financial_Data | int | |
update__changeset_KEY | History_Of_Client_Financial_Data_Description | int | |
update__changeset_KEY | History_Of_Client_Staff_Grouping | int | |
update__changeset_KEY | History_Of_Contact | int | |
update__changeset_KEY | History_Of_Contact_Address | int | |
update__changeset_KEY | History_Of_Contact_Category | int | |
update__changeset_KEY | History_Of_Contact_Contact_Category | int | |
update__changeset_KEY | History_Of_Contact_Email | int | |
update__changeset_KEY | History_Of_Contact_Phone | int | |
update__changeset_KEY | History_Of_Custom_Chart | int | |
update__changeset_KEY | History_Of_Custom_Field | int | |
update__changeset_KEY | History_Of_Custom_Value | int | |
update__changeset_KEY | History_Of_Digita_Vat_Period | int | |
update__changeset_KEY | History_Of_Engagement | int | |
update__changeset_KEY | History_Of_File_Transfer | int | |
update__changeset_KEY | History_Of_File_Transfer_Event | int | |
update__changeset_KEY | History_Of_File_Transfer_File | int | |
update__changeset_KEY | History_Of_Link | int | |
update__changeset_KEY | History_Of_Link_Group | int | |
update__changeset_KEY | History_Of_Portal_User | int | |
update__changeset_KEY | History_Of_Project | int | |
update__changeset_KEY | History_Of_Project_Extension | int | |
update__changeset_KEY | History_Of_Schedule_Entry | int | |
update__changeset_KEY | History_Of_Schedule_Item | int | |
update__changeset_KEY | History_Of_Schedule_Item_Assignment | int | |
update__changeset_KEY | History_Of_Schedule_Item_Budget_Remaining_Entry | int | |
update__changeset_KEY | History_Of_Schedule_Item_Series | int | |
update__changeset_KEY | History_Of_Sheet_Entry | int | |
update__changeset_KEY | History_Of_Tag | int | |
update__changeset_KEY | History_Of_Tagged_Item | int | |
update__changeset_KEY | History_Of_Task | int | |
update__changeset_KEY | History_Of_Time_Zone | int | |
update__changeset_KEY | History_Of_Timer | int | |
update__changeset_KEY | Link | int | |
update__changeset_KEY | Link_Group | int | |
update__changeset_KEY | Portal_User | int | |
update__changeset_KEY | Project | int | |
update__changeset_KEY | Project_Extension | int | |
update__changeset_KEY | Schedule_Entry | int | |
update__changeset_KEY | Schedule_Item | int | |
update__changeset_KEY | Schedule_Item_Assignment | int | |
update__changeset_KEY | Schedule_Item_Budget_Remaining_Entry | int | |
update__changeset_KEY | Schedule_Item_Series | int | |
update__changeset_KEY | Sheet_Entry | int | |
update__changeset_KEY | Tag | int | |
update__changeset_KEY | Tagged_Item | int | |
update__changeset_KEY | Task | int | |
update__changeset_KEY | Time_Zone | int | |
update__changeset_KEY | Timer | int | |
update__staff_KEY | Accruable_Benefit | int | |
update__staff_KEY | Accruable_Benefit_Allowance_By_Month | int | |
update__staff_KEY | Accruable_Benefit_Allowance_By_Staff_Level | int | |
update__staff_KEY | Active_Filter | int | |
update__staff_KEY | Activity | int | |
update__staff_KEY | Activity_Category | int | |
update__staff_KEY | Additional_Contact | int | |
update__staff_KEY | Address | int | |
update__staff_KEY | Bank_Account | int | |
update__staff_KEY | Benefit | int | |
update__staff_KEY | Benefit_Factor | int | |
update__staff_KEY | Billing_Decision | int | |
update__staff_KEY | Billing_Decision_Collection | int | |
update__staff_KEY | Billing_Decision_Tax_Collection | int | |
update__staff_KEY | Billing_Decision_Taxing_Authority | int | |
update__staff_KEY | Billing_Rate_Type | int | |
update__staff_KEY | Client | int | |
update__staff_KEY | Client_Shortcut | int | |
update__staff_KEY | Client_Shortcut_Group | int | |
update__staff_KEY | Client_Status_Event | int | |
update__staff_KEY | Contact | int | |
update__staff_KEY | Contact_Address | int | |
update__staff_KEY | Contact_Category | int | |
update__staff_KEY | Contact_Contact_Category | int | |
update__staff_KEY | Contact_Email | int | |
update__staff_KEY | Contact_Phone | int | |
update__staff_KEY | Credit_Card | int | |
update__staff_KEY | Custom_Fieldview | int | |
update__staff_KEY | Custom_Fieldview_Type | int | |
update__staff_KEY | Custom_Formula | int | |
update__staff_KEY | Custom_Grouping | int | |
update__staff_KEY | Custom_Portlet | int | |
update__staff_KEY | Dashboard_Layout | int | Key of Staff who last modified this row. This Staff is considered to be the owner of this dashboard layout. |
update__staff_KEY | Database_Property | int | |
update__staff_KEY | Department | int | |
update__staff_KEY | Education_Credit | int | |
update__staff_KEY | Education_Sponsor | int | |
update__staff_KEY | Engagement | int | |
update__staff_KEY | Engagement_Template | int | |
update__staff_KEY | Engagement_Type | int | |
update__staff_KEY | Entity | int | |
update__staff_KEY | Feed_Channel | int | |
update__staff_KEY | Feed_Channel_Item | int | |
update__staff_KEY | Feed_Channel_Item_Enclosure | int | |
update__staff_KEY | Feed_Channel_Item_Staff_Read | int | |
update__staff_KEY | Feed_Portlet | int | |
update__staff_KEY | Filter | int | |
update__staff_KEY | Filter_Base_Type | int | |
update__staff_KEY | Filter_Line | int | |
update__staff_KEY | Filter_Line_Type | int | |
update__staff_KEY | Filter_Range_Type | int | |
update__staff_KEY | Filter_Select | int | |
update__staff_KEY | Filter_Type | int | |
update__staff_KEY | Firm | int | |
update__staff_KEY | Firm_Date | int | |
update__staff_KEY | Firm_Shortcut | int | |
update__staff_KEY | Firm_Shortcut_Group | int | |
update__staff_KEY | GL_Entry_Export_Option | int | |
update__staff_KEY | History_Of_Project | int | |
update__staff_KEY | History_Of_Project_Extension | int | |
update__staff_KEY | History_Of_Schedule_Item | int | |
update__staff_KEY | History_Of_Schedule_Item_Assignment | int | |
update__staff_KEY | History_Of_Schedule_Item_Budget_Remaining_Entry | int | |
update__staff_KEY | History_Of_Schedule_Item_Series | int | |
update__staff_KEY | History_Of_Task | int | |
update__staff_KEY | Integration_Application | int | |
update__staff_KEY | Integration_Custom_Value | int | |
update__staff_KEY | Integration_Invoice | int | |
update__staff_KEY | Integration_Invoice_Prior_Payment | int | |
update__staff_KEY | Integration_Sheet_Entry | int | |
update__staff_KEY | Interaction_Link | int | |
update__staff_KEY | Invoice | int | |
update__staff_KEY | Ledger_Entry | int | |
update__staff_KEY | Ledger_Entry_Application | int | |
update__staff_KEY | Ledger_Entry_Service_Charge | int | |
update__staff_KEY | Ledger_Entry_Submittal | int | |
update__staff_KEY | Link | int | |
update__staff_KEY | Link_Group | int | |
update__staff_KEY | Lost_Reason | int | |
update__staff_KEY | Lost_To | int | |
update__staff_KEY | Monitored_Event | int | |
update__staff_KEY | Monitored_Event_Action | int | |
update__staff_KEY | Observed_Holiday | int | |
update__staff_KEY | Office | int | |
update__staff_KEY | Online_Invoice | int | |
update__staff_KEY | Online_Payment | int | |
update__staff_KEY | Outlook_Contact_Synchronization_Folder | int | |
update__staff_KEY | Outlook_Contact_Synchronization_Profile | int | |
update__staff_KEY | Practice_User | int | |
update__staff_KEY | Print_Option | int | |
update__staff_KEY | Project | int | |
update__staff_KEY | Project_Extension | int | |
update__staff_KEY | Project_Template | int | |
update__staff_KEY | Project_Template_Assignment | int | |
update__staff_KEY | Project_Template_Definition | int | |
update__staff_KEY | Project_Template_Definition_Extension | int | |
update__staff_KEY | Project_Template_Definition_Imported | int | |
update__staff_KEY | Project_Template_Entity | int | |
update__staff_KEY | Project_Template_Extension | int | |
update__staff_KEY | Recorded_Event | int | |
update__staff_KEY | Recurring_Bill | int | |
update__staff_KEY | Referral_Source | int | |
update__staff_KEY | Report_Definition | int | |
update__staff_KEY | Report_Definition_Security_Group | int | |
update__staff_KEY | Report_Profile | int | |
update__staff_KEY | Report_Profile_Report_Definition | int | |
update__staff_KEY | Schedule_Item | int | |
update__staff_KEY | Schedule_Item_Assignment | int | |
update__staff_KEY | Schedule_Item_Budget_Remaining_Entry | int | Key of Staff who last modified this row. |
update__staff_KEY | Schedule_Item_Series | int | Key of Staff who last modified this row. |
update__staff_KEY | Security_Group | int | |
update__staff_KEY | Service_Charge | int | |
update__staff_KEY | Sheet_Entry | int | |
update__staff_KEY | Staff | int | |
update__staff_KEY | Staff_Area_Rating | int | |
update__staff_KEY | Staff_Benefit | int | |
update__staff_KEY | Staff_Benefit_Entry | int | |
update__staff_KEY | Staff_Billing_Rate | int | |
update__staff_KEY | Staff_Level | int | |
update__staff_KEY | Staff_Locator | int | |
update__staff_KEY | Staff_Rate_Table | int | |
update__staff_KEY | Staff_Report_Definition | int | |
update__staff_KEY | Staff_Security_Group | int | |
update__staff_KEY | Staff_Shortcut | int | |
update__staff_KEY | Staff_Shortcut_Group | int | |
update__staff_KEY | Staff_Skill_Area | int | |
update__staff_KEY | Staff_Skill_Rating | int | |
update__staff_KEY | Standard_Text | int | |
update__staff_KEY | Status_Event | int | |
update__staff_KEY | Status_Event_Type | int | |
update__staff_KEY | Task | int | |
update__staff_KEY | Task_Template | int | |
update__staff_KEY | Task_Template_Assignment | int | |
update__staff_KEY | Tax_Area | int | |
update__staff_KEY | Tax_Area_Taxing_Authority | int | |
update__staff_KEY | Taxing_Authority | int | |
update__staff_KEY | Term | int | |
update__staff_KEY | Timer | int | |
update__staff_KEY | Tracking_Description | int | |
update__staff_KEY | User_Preference | int | |
update__staff_KEY | Web_Page_Portlet | int | |
update__staff_KEY | Won_Reason | int | |
update_data_change_log_KEY | Update_Data_Change_Log | int | |
update_date | Filter | datetime | |
update_date | Filter_Base_Type | datetime | |
update_date | Filter_Line | datetime | |
update_date | Filter_Line_Type | datetime | |
update_date | Filter_Range_Type | datetime | |
update_date | Filter_Select | datetime | |
update_date | Filter_Type | datetime | |
update_date | Update_Data_Version_History | datetime | |
update_date_utc | Accruable_Benefit | datetime | |
update_date_utc | Accruable_Benefit_Allowance_By_Month | datetime | |
update_date_utc | Accruable_Benefit_Allowance_By_Staff_Level | datetime | |
update_date_utc | Active_Filter | datetime | |
update_date_utc | Activity | datetime | |
update_date_utc | Activity_Category | datetime | |
update_date_utc | Address | datetime | |
update_date_utc | Bank_Account | datetime | |
update_date_utc | Benefit | datetime | |
update_date_utc | Benefit_Factor | datetime | |
update_date_utc | Billing_Decision | datetime | |
update_date_utc | Billing_Decision_Collection | datetime | |
update_date_utc | Billing_Decision_Tax_Collection | datetime | |
update_date_utc | Billing_Decision_Taxing_Authority | datetime | |
update_date_utc | Billing_Rate_Type | datetime | |
update_date_utc | Client_Shortcut | datetime | |
update_date_utc | Client_Shortcut_Group | datetime | |
update_date_utc | Client_Status_Event | datetime | |
update_date_utc | Contact | datetime | |
update_date_utc | Contact_Address | datetime | |
update_date_utc | Contact_Email | datetime | |
update_date_utc | Contact_Phone | datetime | |
update_date_utc | Credit_Card | datetime | |
update_date_utc | Custom_Fieldview | datetime | |
update_date_utc | Custom_Fieldview_Type | datetime | |
update_date_utc | Custom_Formula | datetime | |
update_date_utc | Custom_Grouping | datetime | |
update_date_utc | Custom_Portlet | datetime | |
update_date_utc | Dashboard_Layout | datetime | |
update_date_utc | Database_Property | datetime | |
update_date_utc | Department | datetime | |
update_date_utc | Education_Credit | datetime | |
update_date_utc | Education_Sponsor | datetime | |
update_date_utc | Engagement_Template | datetime | |
update_date_utc | Engagement_Type | datetime | |
update_date_utc | Entity | datetime | |
update_date_utc | Feed_Channel | datetime | |
update_date_utc | Feed_Channel_Item | datetime | |
update_date_utc | Feed_Channel_Item_Enclosure | datetime | |
update_date_utc | Feed_Channel_Item_Staff_Read | datetime | |
update_date_utc | Feed_Portlet | datetime | |
update_date_utc | Firm | datetime | |
update_date_utc | Firm_Date | datetime | |
update_date_utc | Firm_Shortcut | datetime | |
update_date_utc | Firm_Shortcut_Group | datetime | |
update_date_utc | GL_Entry_Export_Option | datetime | |
update_date_utc | Integration_Application | datetime | |
update_date_utc | Integration_Custom_Value | datetime | |
update_date_utc | Integration_Invoice | datetime | |
update_date_utc | Integration_Invoice_Prior_Payment | datetime | |
update_date_utc | Integration_Sheet_Entry | datetime | |
update_date_utc | Interaction_Link | datetime | |
update_date_utc | Invoice | datetime | |
update_date_utc | Last_Table_Modification | datetime | |
update_date_utc | Ledger_Entry | datetime | |
update_date_utc | Ledger_Entry_Application | datetime | |
update_date_utc | Ledger_Entry_Service_Charge | datetime | |
update_date_utc | Ledger_Entry_Submittal | datetime | |
update_date_utc | Lost_Reason | datetime | |
update_date_utc | Lost_To | datetime | |
update_date_utc | Monitored_Event | datetime | |
update_date_utc | Monitored_Event_Action | datetime | |
update_date_utc | Observed_Holiday | datetime | |
update_date_utc | Office | datetime | |
update_date_utc | Online_Invoice | datetime | |
update_date_utc | Online_Payment | datetime | |
update_date_utc | Outlook_Contact_Synchronization_Folder | datetime | |
update_date_utc | Outlook_Contact_Synchronization_Profile | datetime | |
update_date_utc | Practice_User | datetime | |
update_date_utc | Print_Option | datetime | |
update_date_utc | Project_Template | datetime | |
update_date_utc | Project_Template_Assignment | datetime | |
update_date_utc | Project_Template_Definition | datetime | |
update_date_utc | Project_Template_Definition_Extension | datetime | |
update_date_utc | Project_Template_Definition_Imported | datetime | |
update_date_utc | Project_Template_Entity | datetime | |
update_date_utc | Project_Template_Extension | datetime | |
update_date_utc | Recorded_Event_Notification | datetime | |
update_date_utc | Recurring_Bill | datetime | |
update_date_utc | Referral_Source | datetime | |
update_date_utc | Report_Definition | datetime | |
update_date_utc | Report_Definition_Security_Group | datetime | |
update_date_utc | Report_Profile | datetime | |
update_date_utc | Report_Profile_Report_Definition | datetime | |
update_date_utc | Schedule_Item | datetime | |
update_date_utc | Security_Group | datetime | |
update_date_utc | Service_Charge | datetime | |
update_date_utc | Staff | datetime | |
update_date_utc | Staff_Area_Rating | datetime | |
update_date_utc | Staff_Benefit | datetime | |
update_date_utc | Staff_Benefit_Entry | datetime | |
update_date_utc | Staff_Billing_Rate | datetime | |
update_date_utc | Staff_Level | datetime | |
update_date_utc | Staff_Locator | datetime | Date and time this record was last updated in UTC. |
update_date_utc | Staff_Rate_Table | datetime | |
update_date_utc | Staff_Report_Definition | datetime | |
update_date_utc | Staff_Security_Group | datetime | |
update_date_utc | Staff_Shortcut | datetime | |
update_date_utc | Staff_Shortcut_Group | datetime | |
update_date_utc | Staff_Skill_Area | datetime | |
update_date_utc | Staff_Skill_Rating | datetime | |
update_date_utc | Standard_Text | datetime | |
update_date_utc | Status_Event | datetime | |
update_date_utc | Status_Event_Type | datetime | |
update_date_utc | Task_Template | datetime | |
update_date_utc | Task_Template_Assignment | datetime | |
update_date_utc | Tax_Area | datetime | |
update_date_utc | Tax_Area_Taxing_Authority | datetime | |
update_date_utc | Taxing_Authority | datetime | |
update_date_utc | Term | datetime | |
update_date_utc | Tracking_Description | datetime | |
update_date_utc | Update_Data_Change_Log | datetime | |
update_date_utc | User_Preference | datetime | |
update_date_utc | User_Session_Pattern | datetime | |
update_date_utc | Web_Page_Portlet | datetime | |
update_date_utc | Won_Reason | datetime | |
upper_date_exclusive | Staff_Target_Range | smalldatetime | This is the important date - this is the date that the next range begins and therefore where this ends. |
upper_date_utc | Schedule_Item_Date_Index | datetime | |
urgent__filter_KEY | User_Preference | int | KEY of the filter used to narrow the schedule items to be displayed in the urgent tab |
urgent_due_within_unassigned | User_Preference | bit | When true the urgent tab includes schedule items where the target complete date is less than today plus urgent_due_within_unassigned_days and does not have any schedule item assignments |
urgent_due_within_unassigned_days | User_Preference | int | When urgent_target_start_past_unassigned is true, the urgent tab includes schedule items where the target complete date is less than today plus urgent_due_within_unassigned_days and does not have any schedule item assignments |
urgent_due_within_unscheduled | User_Preference | bit | When true the urgent tab includes schedule items where the target complete date is less than today plus urgent_due_within_unscheduled_days and does not have any schedule entries |
urgent_due_within_unscheduled_days | User_Preference | int | When urgent_target_start_past_unscheduled is true, the urgent tab includes schedule items where the target complete date is less than today plus urgent_due_within_unscheduled_days and does not have any schedule entries |
urgent_high_priority_unassigned | User_Preference | bit | When true the urgent tab includes high priority schedule items with no schedule item assignments |
urgent_high_priority_unscheduled | User_Preference | bit | When true the urgent tab includes high priority schedule items with no schedule entries |
urgent_overscheduled | User_Preference | bit | When true the urgent tab includes schedule items where the number of total scheduled hours for the item is greater than the remaining hours of work for the item |
urgent_past_due | User_Preference | bit | When true the urgent tab includes schedule items that are past due |
urgent_tab_enabled | User_Preference | bit | When true the urgent tab will be displayed in scheduling screens |
urgent_target_start_past_unassigned | User_Preference | bit | When true the urgent tab includes schedule items where the target start date has past and does not have any schedule item assignments |
urgent_target_start_past_unscheduled | User_Preference | bit | When true the urgent tab includes schedule items where the target start date has past and does not have any schedule entries |
url | Contact | nvarchar (2048) | Website address. |
url | Feed_Channel | nvarchar (2048) | |
url | Feed_Channel_Item | nvarchar (2048) | |
url | Feed_Channel_Item_Enclosure | nvarchar (2048) | |
url | History_Of_Contact | nvarchar (2048) | |
url | Web_Page_Portlet | nvarchar (2048) | |
use_accounts_receivable_limit | Client | bit | Determines whether the accounts receivable limit is enforced. |
use_accounts_receivable_limit | History_Of_Client | bit | |
use_maximum_carryover | Benefit | bit | Determines whether the maximum carryover amount is enforced. |
use_maximum_charge | Service_Charge | bit | Determines whether the maximum charge is enforced. |
use_wip_limit | Client | bit | Determines whether the WIP limit is enforced. |
use_wip_limit | History_Of_Client | bit | |
user_name | Changeset | nvarchar (128) | The application user name if known. |
user_name | Client_Status_Event | nvarchar (30) | The name of the user that recorded the event. |
user_name | History_Of_Timer | nvarchar (50) | |
user_name | Integration_Invoice | nvarchar (30) | User name of the person who triggered the export. |
user_name | Staff | nvarchar (30) | The name used on the login screen. |
user_name | Timer | nvarchar (50) | The name of the user that started the timer. |
user_name | Update_Data_Version_History | nvarchar (11) | |
user_name | User_Session_Pattern | nvarchar (11) | |
user_preference_KEY | User_Preference | int | AUTO-INCREMENT: Database assigned primary key for this table. |
user_preference_KEY | User_Preference_Custom_Field_Column | int | Key of the User Preference that this entry is for |
user_session_guid | User_Session | uniqueidentifier | A database generated unique key for this table. |
user_session_pattern_guid | Changeset | uniqueidentifier | Reference to other information known about a user session. |
user_session_pattern_guid | User_Session | uniqueidentifier | Key to the User_Session_Pattern table. |
user_session_pattern_guid | User_Session_Pattern | uniqueidentifier | |
user_session_status_KEY | User_Session | int | The status of this session (1=Open, 2=Closed, 3=Expired, 4=Killed) |
user_visible | Update_Data_Change_Log | varchar (1) | |
valid_date | Valid_Date | smalldatetime | Holds a date without a time set (stored as midnight.) |
valid_date_KEY | Valid_Date | int | Key for backwards compatibility. Should be the number of days since 1989-12-31. |
version | Custom_Chart | nvarchar (19) | The version of the custom chart. |
version | Custom_Formula | nvarchar (19) | The version of the custom formula. |
version | History_Of_Custom_Chart | nvarchar (19) | |
version | Update_Data_Change_Log | nvarchar (19) | |
version | Update_Data_Version_History | nvarchar (19) | |
web_page_portlet_KEY | Web_Page_Portlet | int | |
windows_user_name | Changeset | nvarchar (128) | The operating system user name if known. |
windows_user_name | Update_Data_Version_History | nvarchar (50) | |
windows_user_name | User_Session_Pattern | nvarchar (50) | |
wip_limit | Client | decimal (17, 2) | WIP limit. |
wip_limit | History_Of_Client | decimal (17, 2) | |
with__contact_KEY | History_Of_Schedule_Item | int | |
with__contact_KEY | Schedule_Item | int | For scheduled phone calls, the contact that is to be called. |
won_date | Client | smalldatetime | The date this client was won. |
won_date | History_Of_Client | smalldatetime | |
won_reason_KEY | Client | int | Key to a Won Reason record. |
won_reason_KEY | History_Of_Client | int | |
won_reason_KEY | Won_Reason | int | AUTO-INCREMENT: Database assigned primary key for this table. |
workflow | Gofileroom_Workflow | nvarchar (255) | GoFileRoom workflow template description of this workflow. |
workflow_description | Gofileroom_Workflow | nvarchar (255) | GoFileRoom workflow description of this workflow. |
workflow_id | Gofileroom_Workflow | int | One of four required fields that uniquely identify a workflow, not intended to be viewed by users. |
workflow_template_id | Gofileroom_Workflow | int | One of four required fields that uniquely identify a workflow, not intended to be viewed by users. |
workflow_year | Gofileroom_Workflow | nvarchar (255) | GoFileRoom year of this workflow. |
write_off_gl_account | GL_Entry_Export_Option | nvarchar (60) | |
year_begin_date | Firm | smalldatetime | |
year_end_date | Firm | smalldatetime |