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_checksum | Address | int | Checksum used for fast lookup based on address content
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 (25) | City.
city | History_Of_Contact_Address | nvarchar (25) |
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 | History_Of_Custom_Field | int |
custom_field_type_KEY | Custom_Field | int | Foreign key to specify what data type this column is.
custom_field_type_KEY | History_Of_Custom_Field | 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_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.
email | Contact_Email | nvarchar (320) | E-mail address.
email | 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
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_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_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_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_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_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_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.
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_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 | 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) |
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 |