Column Dictionary
A B C D E F G H I L M N O P R S T U V W Y
ColumnTableTypeDescription
accounts_receivable_dunning_1Firmnvarchar (-1)Dunning message to print when the oldest outstanding item is 1 period old.
accounts_receivable_dunning_2Firmnvarchar (-1)Dunning message to print when the oldest outstanding item is 2 periods old.
accounts_receivable_dunning_3Firmnvarchar (-1)Dunning message to print when the oldest outstanding item is 3 periods old.
accounts_receivable_dunning_4Firmnvarchar (-1)Dunning message to print when the oldest outstanding item is 4 periods old.
accounts_receivable_dunning_5Firmnvarchar (-1)Dunning message to print when the oldest outstanding item is 5 or more periods old.
accounts_receivable_gl_accountGL_Entry_Export_Optionnvarchar (60)
accounts_receivable_limitClientdecimal (17, 2)Accounts Receivable limit.
accounts_receivable_limitHistory_Of_Clientdecimal (17, 2)
accounts_receivable_termsFirmnvarchar (-1)Payment terms included on invoices and statements.
accruable_benefit_allowance_by_month_KEYAccruable_Benefit_Allowance_By_MonthintAssigned by COMMON_dp_Allocate_Unique_Identifiers. Primary key for this table.
accruable_benefit_allowance_by_staff_level_KEYAccruable_Benefit_Allowance_By_Staff_LevelintAssigned by COMMON_dp_Allocate_Unique_Identifiers. Primary key for this table.
accruable_benefit_KEYAccruable_BenefitintPrimary key for this table, same value as [benefit_KEY].
accumulate_time_before_roundingHistory_Of_Timerbit
accumulate_time_before_roundingTimerbitThe Accumulte Time setting that was in place when the Timer was started.
actionLast_Table_Modificationchar (1)
activeBenefitbitWhether this benefit is active.
activeStaff_BenefitbitDetermines whether the benefit is enabled for this Staff.
active_filter_KEYActive_FilterintAUTO-INCREMENT: Database assigned primary key for this table
activity__activity_class_KEYHistory_Of_Sheet_Entryint
activity__activity_class_KEYSheet_EntryintCached value of the activity class:
1=Billable
2=Non-billable
3=Administrative
activity__activity_method_KEYHistory_Of_Sheet_Entryint
activity__activity_method_KEYSheet_EntryintCached value of the activity method:
1=Time
2=Expense
activity_category_idActivity_Categorynvarchar (11)User defined identifier (unique).
activity_category_id_sortableActivity_Categoryvarchar (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_KEYActivityintKEY of the Activity Category that this row is assigned.
activity_category_KEYActivity_CategoryintAUTO-INCREMENT: Database assigned primary key for this table
activity_class_KEYActivityintKEY of the Activity Class that this row is assigned
activity_idActivitynvarchar (11)User defined identifier (unique)
activity_id_sortableActivityvarchar (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_KEYAccruable_BenefitintKey to an Activity that the accruable benefit is for.
activity_KEYActivityintAUTO-INCREMENT: Database assigned primary key for this table
activity_KEYHistory_Of_Schedule_Itemint
activity_KEYHistory_Of_Sheet_Entryint
activity_KEYIntegration_Sheet_EntryintKey to the Activity this entry is for.
activity_KEYSchedule_ItemintThe linked [Activity].
activity_KEYSheet_EntryintKey to the Activity this entry is for.
activity_KEYTask_Templateint
activity_method_KEYActivityint1=Time, 2=Expense
activity_status_KEYActivityintKEY of the Activity Status that this row is assigned
activity_surcharge_method_KEYActivityint1=No surcharge, 2=Per Unit, 3=Percent
actual_complete_dateHistory_Of_Projectsmalldatetime
actual_complete_dateHistory_Of_Tasksmalldatetime
actual_complete_dateProjectsmalldatetimeThe actual complete date.
actual_complete_dateTasksmalldatetimeThe actual complete date.
actual_start_dateHistory_Of_Projectsmalldatetime
actual_start_dateHistory_Of_Tasksmalldatetime
actual_start_dateProjectsmalldatetimeThe actual start date.
actual_start_dateTasksmalldatetimeThe actual start date.
additional_contact_KEYAdditional_ContactintAUTO-INCREMENT: Database assigned primary key for this table.
additional_contact_KEYHistory_Of_Additional_Contactint
address_1Addressnvarchar (40)First line of address.
address_1Contact_Addressnvarchar (40)First line of address.
address_1History_Of_Contact_Addressnvarchar (40)
address_2Addressnvarchar (40)Second line of address.
address_2Contact_Addressnvarchar (40)Second line of address.
address_2History_Of_Contact_Addressnvarchar (40)
address_3Addressnvarchar (128)Third line of address.
address_3Contact_Addressnvarchar (128)Third line of address.
address_3History_Of_Contact_Addressnvarchar (128)
address_checksumAddressint
address_KEYAddressintAssigned by COMMON_dp_Allocate_Unique_Identifiers. Database assigned primary key for this table.
address_positionContactnvarchar (4)Semicolon seperated list of contact_address_type_KEY values indicating the user's preferred order of displaying addresses.
address_positionHistory_Of_Contactnvarchar (4)
adjustmentBilling_Decisiondecimal (9, 2)Adjustment (a negative adjustment is a write down).
adjustmentClient_Date_Cachedecimal (9, 2)Adjustment sum for the Client, principal Client, and entry date
administrative_activity_type_KEYActivityintKEY of the Administrative Activity Type that this row is assigned.
alert_level_KEYMonitored_Eventint
alert_level_KEYRecorded_EventintAlert level for event.
allowanceAccruable_Benefit_Allowance_By_Monthdecimal (9, 2)The allowance amount.
allowanceAccruable_Benefit_Allowance_By_Staff_Leveldecimal (9, 2)The allowance amount.
alternate_row_colorUser_PreferencebitPresents all lists and grids with alternating row colors when true
amountBilling_Decision_Taxing_Authoritydecimal (9, 2)The amount of tax charged.
amountHistory_Of_Sheet_Entrydecimal (9, 2)
amountIntegration_Invoicedecimal (17, 2)The total amount of this item.
amountIntegration_Sheet_Entrydecimal (9, 2)Overridden extended price after computation and rounding.
amountLedger_Entrydecimal (17, 2)The total amount of this item.
amountLedger_Entry_Service_Chargedecimal (17, 2)Amount charged because past_due__ledger_entry_KEY has not been paid.
amountSheet_Entrydecimal (9, 2)Overridden extended price after computation and rounding.
amount_collectedBilling_Decision_Tax_Collectiondecimal (9, 2)The amount collected for the tax.
amount_is_overriddenBilling_Decision_Taxing_AuthoritybitTrue 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_overriddenHistory_Of_Sheet_Entrybit
amount_is_overriddenIntegration_Sheet_EntrybitTrue 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_overriddenSheet_EntrybitTrue when the calculated_amount is overridden and is necessary so that the override is not deleted if the values happen to match later.
annual_rateService_Chargedecimal (7, 6)Rate to be used for the service charge calculation.
applied_amountLedger_Entry_Applicationdecimal (17, 2)The amount of "from" entry that is applied to "to"
apply_to_discountTaxing_AuthoritybitFlag, true if this tax applies to discount amounts
apply_to_shippingTaxing_AuthoritybitFlag, true if this tax applies to shipping amounts
approvalcodeLedger_Entry_Submittal_Resultnvarchar (6)Contents of the approvalcode field in the response returned by Intercept.
approved__staff_KEYHistory_Of_Schedule_Itemint
approved__staff_KEYHistory_Of_Sheet_Entryint
approved__staff_KEYIntegration_Sheet_EntryintKey of the Staff who approved this item.
approved__staff_KEYLedger_EntryintKey of the Staff who approved this item.
approved__staff_KEYSchedule_ItemintThe Staff that approved the item.
approved__staff_KEYSheet_EntryintKey of the Staff who approved this item.
approved_dateHistory_Of_Schedule_Itemsmalldatetime
approved_dateHistory_Of_Sheet_Entrysmalldatetime
approved_dateIntegration_InvoicesmalldatetimeDate this item was approved.
approved_dateIntegration_Sheet_EntrysmalldatetimeDate this item was approved.
approved_dateLedger_EntrysmalldatetimeDate this item was approved.
approved_dateSchedule_ItemsmalldatetimeThe date the item was approved.
approved_dateSheet_EntrysmalldatetimeDate this item was approved.
ar_adjustmentClient_Date_Cachedecimal (9, 2)ar_adjustment sum for the Client, principal Client, and entry date
ar_receivedClient_Date_Cachedecimal (9, 2)ar_received sum for the Client, principal Client, and entry date
ar_service_chargeClient_Date_Cachedecimal (9, 2)ar_service_charge sum for the Client, principal Client, and entry date
assess_service_chargeClientbitDefault should be set to whatever is set in firm setup.
assess_service_chargeFirmbitDefault for new clients.
assess_service_chargeHistory_Of_Clientbit
assigned__staff_grouping_type_KEYProject_TemplateintKey to a Staff Grouping Type that indicates how to determine which staff will be assigned to generated projects.
assigned_staff_id_listSchedule_Item_Assignment_List_Cachenvarchar (-1)List of [Staff].[staff_id] (or work queue).
assigned_staff_listSchedule_Item_Assignment_List_Cachenvarchar (-1)List of [Staff].[description] (or work queue).
associate__staff_KEYClientintKey to a Staff record.
associate__staff_KEYHistory_Of_Clientint
associate_with_contactInteraction_AssociationbitTrue when this type of association is an association between an Interaction and a Contact.
associate_with_objectInteraction_AssociationbitTrue when this type of association is an association between an Interaction and a "object" like a Staff, Client or Office..
attachment_commentAttachmentnvarchar (-1)
attachment_commentHistory_Of_Attachmentnvarchar (-1)
attachment_contentAttachment_Contentvarbinary (-1)The raw data for this attachment
attachment_contentHistory_Of_Attachment_Contentvarbinary (-1)
attachment_content_hash_codeAttachment_Contentvarchar (40)40-character hexadecimal-formatted string from the SHA-1 hash of the image for faster look-up.
attachment_content_hash_codeHistory_Of_Attachment_Contentvarchar (40)
attachment_content_KEYAttachmentintWhat is the content of the associated attachment.
attachment_content_KEYAttachment_Contentint
attachment_content_KEYHistory_Of_Attachmentint
attachment_content_KEYHistory_Of_Attachment_Contentint
attachment_content_lengthAttachment_ContentintThe size of the attachment_content, in bytes
attachment_content_lengthHistory_Of_Attachment_Contentint
attachment_nameAttachmentnvarchar (260)The name of a particular attachment. This is usually the file name of the source file.
attachment_nameHistory_Of_Attachmentnvarchar (260)
bank_account_idBank_Accountnvarchar (11)User defined identifier (unique)
bank_account_id_sortableBank_Accountvarchar (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_KEYBank_AccountintAUTO-INCREMENT: Database assigned primary key for this table
bank_account_KEYLedger_EntryintA bank account is required for all types except Invoices and Service Charges which must not specify a bank account.
begin_date_utcChangesetdatetimeWhen this changeset was created.
begin_date_utcChangeset_ActivedatetimeThe same value that is in Changeset.begin_date_utc
benefit_entry_type_KEYBenefit_FactorintKey to a benefit entry type that this benefit factor is.
benefit_entry_type_KEYStaff_Benefit_EntryintKey to a staff benefit entry type.
benefit_factor_KEYBenefit_FactorintAssigned by COMMON_dp_Allocate_Unique_Identifiers. Primary key for this table, same value as activity_KEY.
benefit_KEYAccruable_BenefitintKey to a Benefit that the accruable benefit is for.
benefit_KEYAccruable_Benefit_Allowance_By_MonthintKey to a benefit.
benefit_KEYAccruable_Benefit_Allowance_By_Staff_LevelintKey to a benefit.
benefit_KEYBenefitintAssigned by COMMON_dp_Allocate_Unique_Identifiers. Primary key for this table, same value as activity_KEY.
benefit_KEYBenefit_FactorintKey to a Benefit that the benefit factor is for.
benefit_KEYHistory_Of_Schedule_Itemint
benefit_KEYSchedule_ItemintLink to the benefit for items of type scheduled benefit.
benefit_KEYStaff_BenefitintKey to a Benefit.
benefit_type_KEYBenefitintKey to a Benefit Type.
benefit_year_begin_dateFirmsmalldatetimeBegin date of the benefit year.
benefit_year_end_dateFirmsmalldatetimeEnd date of the benefit year.
bill_amountBilling_Decisiondecimal (9, 2)Amount billed for this invoice.
bill_amount_collectedBilling_Decision_Collectiondecimal (9, 2)The amount collected for the bill_amount of the Billing_Decision.
billable_amountStaff_Target_Rangedecimal (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_overriddenStaff_Target_RangebitWhen 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_amountSheet_Entry_Open_Value_Cachedecimal (17, 2)The billable live open amount for the Sheet_Entry row.
billable_live_open_unitsSheet_Entry_Open_Value_Cachedecimal (9, 2)The billable live open units for the Sheet_Entry row.
billable_percentStaff_Target_Rangedecimal (7, 6)The billable target hours are calculated from the target hours specified * this percentage.
billable_rateStaff_Billing_Ratedecimal (9, 2)The rate billed per hour for this Staff Billing Rate.
billed__staff_KEYInvoiceintKey of the Staff who billed this invoice.
billed_dateIntegration_InvoicesmalldatetimeDate this integration_invoice was saved.
billed_dateInvoicesmalldatetimeDate this invoice was saved.
biller__staff_grouping_type_KEYEngagement_TemplateintKey to a Staff Grouping Type that indicates how to determine which staff will be assigned to generated engagements.
biller__staff_KEYEngagementintKey to a Staff record.
biller__staff_KEYHistory_Of_Engagementint
biller_noteHistory_Of_Sheet_Entrynvarchar (-1)
biller_noteIntegration_Sheet_Entrynvarchar (-1)An optional comment for the biller.
biller_noteSheet_Entrynvarchar (-1)An optional comment for the biller.
billing__address_KEYCredit_CardintBilling address.
billing__billing_method_KEYUser_PreferenceintBilling by Client or Engagement
billing__contact_KEYClientintPrimary contact for invoice and statement delivery. By default will be the contact key of the client
billing__contact_KEYHistory_Of_Clientint
billing__custom_wip_dateUser_PreferencesmalldatetimeThe billing default custom wip date.
billing__user_preference_default_invoice_date_KEYUser_PreferenceintDefault Invoice date for Detail Billing.
billing__user_preference_default_wip_date_KEYUser_PreferenceintKey of the User Preference Default Wip Date that this row is assigned.
billing_activity_description_hideUser_Preferencebit
billing_auto_apply_open_creditsUser_PreferencebitDetermines if we automatically apply any open credits when saving a detail billing decision.
billing_auto_check_spellingUser_Preferencebit
billing_auto_select_child_clientsUser_Preferencebit
billing_biller_note_hideUser_Preferencebit
billing_client_description_hideUser_Preferencebit
billing_comment_hideUser_Preferencebit
billing_decision_guidBilling_DecisionuniqueidentifierA unique key for this row generated in detail billing otherwise by the database.
billing_decision_KEYBilling_DecisionintAUTO-INCREMENT: Database assigned primary key for this table
billing_decision_KEYBilling_Decision_Taxing_AuthorityintDEPRECATED. Identifies the Billing_Decision row this tax is charged for.
billing_decision_taxing_authority_KEYBilling_Decision_Taxing_AuthorityintAUTO-INCREMENT: DEPRECATED. Database assigned primary key for this table.
billing_email_recipientsClientnvarchar (500)Any additional email address to whom the billing information should be emailed
billing_email_recipientsHistory_Of_Clientnvarchar (500)
billing_engagement_description_hideUser_Preferencebit
billing_implied_decimalUser_PreferencebitAutomatically inserts decimal point at end of amount
billing_instructionsClientnvarchar (-1)Any notes for the biller.
billing_instructionsHistory_Of_Clientnvarchar (-1)
billing_mark_zero_invoice_as_printedUser_Preferencebit
billing_nameCredit_Cardnvarchar (50)Name on billing information.
billing_project_description_hideUser_Preferencebit
billing_prompt_to_apply_open_creditsUser_PreferencebitDetermines if we prompt to apply credits when saving in the Billing Details screen.
billing_rate_type_KEYActivityintKEY of the Billing Rate Type that this row is assigned (required when rate_type_KEY=2).
billing_rate_type_KEYBilling_Rate_TypeintAUTO-INCREMENT: Database assigned primary key for this table.
billing_rate_type_KEYEngagementintKey to a Billing Rate Type record (required when rate_type_KEY=2).
billing_rate_type_KEYHistory_Of_Engagementint
billing_rate_type_KEYStaff_Billing_RateintForeign key to one of the already set up Billing Rate Types (unique per staff_rate_table_KEY).
billing_rate_type_KEYStaff_Target_RangeintLinks 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_selectionUser_PreferencebitWIP column should show in the billing selection list and be populated with WIP balances.
billing_staff_description_hideUser_PreferencebitWhen true the staff description column in billing will be hidden
billing_standard__rounding_method_KEYUser_PreferenceintRounding method for Bill At Standard
billing_standard_rounding_incrementUser_Preferencedecimal (4, 2)Rounding increment for Bill At Standard
billing_startup_tabUser_Preferencenvarchar (100)Startup tab of Detail Billing
bodyFile_Transfernvarchar (-1)body of the File Transfer message
bodyHistory_Of_File_Transfernvarchar (-1)
bodyInteractionnvarchar (-1)Body of this interaction, sometimes unused (empty string) and sometimes truncated (e-mail body for example.)
budget_generation_KEYHistory_Of_Schedule_Item_Seriesint
budget_generation_KEYSchedule_Item_SeriesintKey to a Budget Generation that indicates the source of the budget information.
budgeted_amountHistory_Of_Projectdecimal (9, 2)
budgeted_amountHistory_Of_Taskdecimal (9, 2)
budgeted_amountProjectdecimal (9, 2)Amount budgeted to this project (when budgeted_based_on_tasks = 0).
budgeted_amountProject_Templatedecimal (9, 2)Amount budgeted to this project (when budgeted_based_on_tasks = 0).
budgeted_amountTaskdecimal (9, 2)Amount budgeted to this task.
budgeted_amountTask_Templatedecimal (9, 2)
budgeted_amount_is_calculatedHistory_Of_Projectbit
budgeted_amount_is_calculatedHistory_Of_Taskbit
budgeted_amount_is_calculatedProjectbit
budgeted_amount_is_calculatedProject_Templatebit
budgeted_amount_is_calculatedTaskbit
budgeted_amount_is_calculatedTask_Templatebit
budgeted_based_on_tasksHistory_Of_Projectbit
budgeted_based_on_tasksProjectbitWhen set to 1 will indicate that the budget is entirely based off the budget of the Tasks for the generated project.
budgeted_based_on_tasksProject_TemplatebitWhen set to 1 will indicate that the budget is entirely based off the budget of the Tasks for the generated project.
budgeted_hoursHistory_Of_Schedule_Itemdecimal (9, 2)
budgeted_hoursHistory_Of_Schedule_Item_Assignmentdecimal (9, 2)
budgeted_hoursProject_Templatedecimal (9, 2)Number of hours budgeted to this project (when budgeted_based_on_tasks = 0).
budgeted_hoursProject_Template_Assignmentdecimal (9, 2)Must be greater than or equal to zero, or -1.00 (to indicate assignment only without a budget.)
budgeted_hoursSchedule_Itemdecimal (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_hoursSchedule_Item_Assignmentdecimal (9, 2)Must be greater than or equal to zero, or -1.00 (to indicate assignment only without a budget.)
budgeted_hoursTask_Templatedecimal (9, 2)
budgeted_hoursTask_Template_Assignmentdecimal (9, 2)Must be greater than or equal to zero, or -1.00 (to indicate assignment only without a budget.)
byte_countReport_Imageint
calculated_amountBilling_Decision_Taxing_Authoritydecimal (9, 2)Calculated amount of tax charged.
calculated_amountHistory_Of_Sheet_Entrydecimal (9, 2)
calculated_amountIntegration_Sheet_Entrydecimal (9, 2)Calculated extended price after computation and rounding.
calculated_amountSheet_Entrydecimal (9, 2)Calculated extended price after computation and rounding.
calendar_category_KEYCalendar_CategoryintAssigned by COMMON_dp_Allocate_Unique_Identifiers. Database assigned primary key for this table.
calendar_category_KEYHistory_Of_Calendar_Categoryint
calendar_category_KEYHistory_Of_Schedule_Entryint
calendar_category_KEYSchedule_Entryint
cardholder_nameCredit_Cardnvarchar (50)Credit card holder name.
categoryCustom_Fieldnvarchar (30)
categoryHistory_Of_Custom_Fieldnvarchar (30)
certification_numberStaffnvarchar (250)Certification number.
changeUpdate_Data_Change_Lognvarchar (-1)
changeset_KEYChangesetintAUTO-INCREMENT: Database assigned auto-incrementing value.
changeset_KEYChangeset_ActiveintA link to an active Changeset.
changeset_KEYChangeset_Modified_TableintA link to a Changeset.
charge_sales_taxActivitybitUsed to determine if Sales Tax should be calculated
charge_service_taxActivitybitUsed to determine if Service Tax should be calulated
chartCustom_Chartnvarchar (-1)The serialized custom chart, or the standard chart XML resource.
chartHistory_Of_Custom_Chartnvarchar (-1)
child__contact_KEYAdditional_ContactintKey to the child contact record.
child__contact_KEYHistory_Of_Additional_Contactint
cityAddressnvarchar (40)City.
cityContact_Addressnvarchar (40)City.
cityHistory_Of_Contact_Addressnvarchar (40)
clearedInteractionbit
client_application_nameUpdate_Data_Version_Historynvarchar (200)
client_application_nameUser_Session_Patternnvarchar (200)
client_class_KEYClientintKey to a Client Class record.
client_class_KEYHistory_Of_Clientint
client_dashboard_layoutUser_Preferencenvarchar (-1)Layout of the Client Dashboard stored as XML
client_date_cache_KEYClient_Date_CacheintAUTO-INCREMENT: Primary key of table.
client_financial_data_description_KEYClient_Financial_DataintDescription of this financial data
client_financial_data_description_KEYClient_Financial_Data_DescriptionintAssigned by COMMON_dp_Allocate_Unique_Identifiers. unique key of this table
client_financial_data_description_KEYHistory_Of_Client_Financial_Dataint
client_financial_data_description_KEYHistory_Of_Client_Financial_Data_Descriptionint
client_financial_data_KEYClient_Financial_DataintAssigned by COMMON_dp_Allocate_Unique_Identifiers. primary key for this table
client_financial_data_KEYHistory_Of_Client_Financial_Dataint
client_guidClientuniqueidentifierA unique id for this row generated by the database.
client_guidHistory_Of_Clientuniqueidentifier
client_idClientnvarchar (11)User defined identifier (unique)
client_idHistory_Of_Clientnvarchar (11)
client_idIntegration_Invoicenvarchar (11)The Client ID that this invoice is for (in text form).
client_id_sortableClientvarchar (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_sortableHistory_Of_Clientvarchar (48)
client_KEYClientintAssigned by COMMON_dp_Allocate_Unique_Identifiers. Database assigned primary key for this table
client_KEYClient_Date_CacheintKey to Client that the sums are associated with.
client_KEYClient_Financial_DataintClient this data refers to
client_KEYClient_Shortcut_GroupintThe client who own this solution group.
client_KEYClient_Staff_Groupingint
client_KEYClient_Status_EventintKey to the Client record that this status event was recorded for.
client_KEYEngagementintWhen NULL the record is an Engagement Template, otherwise the record is an Engagement that belongs to a single Client record.
client_KEYHistory_Of_Clientint
client_KEYHistory_Of_Client_Financial_Dataint
client_KEYHistory_Of_Client_Staff_Groupingint
client_KEYHistory_Of_Engagementint
client_KEYHistory_Of_Schedule_Itemint
client_KEYHistory_Of_Sheet_Entryint
client_KEYIntegration_Sheet_EntryintKey to the Client that this entry is for. The client must be the client of the Engagement.
client_KEYLedger_EntryintKey to a Client row
client_KEYRecorded_EventintClient that was affected by the event. Null if not associated with a clint.
client_KEYSchedule_ItemintThe linked [Client]. If of__contact_KEY is specified and is the primary contact of a Client, that client_KEY is also this value.
client_KEYSheet_EntryintKey to the Client that this entry is for. The client must be the client of the Engagement.
client_nameGofileroom_Workflownvarchar (255)GoFileRoom Client name of this workflow.
client_note_dataClientnvarchar (-1)Data used by the Client Note control.
client_note_dataHistory_Of_Clientnvarchar (-1)
client_numberGofileroom_Workflownvarchar (255)GoFileRoom Client number of this workflow.
client_shortcut_group_KEYClient_ShortcutintAssociates this solution with its solution group.
client_shortcut_group_KEYClient_Shortcut_GroupintAssigned by COMMON_dp_Allocate_Unique_Identifiers. Database assigned primary key for this table
client_shortcut_KEYClient_ShortcutintAssigned by COMMON_dp_Allocate_Unique_Identifiers. Database assigned primary key for this table
client_staff_grouping_KEYClient_Staff_Groupingint
client_staff_grouping_KEYHistory_Of_Client_Staff_Groupingint
client_staff_grouping_type_KEYClient_Staff_Groupingint
client_staff_grouping_type_KEYHistory_Of_Client_Staff_Groupingint
client_status_event_KEYClient_Status_EventintAUTO-INCREMENT: Database assigned primary key for this table
client_status_KEYClientintKey to a Client Status record.
client_status_KEYHistory_Of_Clientint
codePrivilegenvarchar (10)This is a shorter version of Description that is used for the privilege path.
collate_copiesPrint_OptionbitCollate copies.
collectedBilling_Decision_Collectiondecimal (9, 2)The total amount collected for the Billing_Decision.
collectedClient_Date_Cachedecimal (9, 2)collected sum for the Client, principal Client, and entry date
collection_source__ledger_entry_KEYBilling_Decision_CollectionintIdentifies 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_KEYBilling_Decision_Tax_CollectionintIdentifies the receipt in the Ledger_Entry table that paid for this collection.
colorCalendar_CategoryintThe Win32 value of the color.
colorHistory_Of_Calendar_Categoryint
COLUMN_COLLATIONCOMMON_Metadata_About_Columnsnvarchar (128)
COLUMN_NAMECOMMON_Metadata_About_Columnsnvarchar (128)
COLUMN_NAMECOMMON_Metadata_About_Foreign_Keysnvarchar (128)
COLUMN_NAMECOMMON_Metadata_About_Keysnvarchar (128)
column_nameCOMMON_Unique_Identifier_Counternvarchar (128)
column_nameDepartment_Grouping_Typenvarchar (128)Name of the column used to find the value.
column_nameStaff_Grouping_Typenvarchar (128)Name of the column used to find the value.
COLUMN_PRECISIONCOMMON_Metadata_About_Columnsint
COLUMN_SCALECOMMON_Metadata_About_Columnsint
commentHistory_Of_Linknvarchar (-1)
commentHistory_Of_Sheet_Entrynvarchar (-1)
commentIntegration_Sheet_Entrynvarchar (-1)An optional comment.
commentLinknvarchar (-1)Optional reason why this link was created
commentSheet_Entrynvarchar (-1)An optional comment.
commentsClientnvarchar (-1)Any comments about the Client.
commentsClient_Status_Eventnvarchar (-1)User defined comments.
commentsHistory_Of_Clientnvarchar (-1)
commentsHistory_Of_Schedule_Item_Budget_Remaining_Entrynvarchar (-1)
commentsIntegration_Invoicenvarchar (-1)Comments about this item that can be included on reports.
commentsLedger_Entrynvarchar (-1)Comments about this item that can be included on reports.
commentsSchedule_Item_Budget_Remaining_Entrynvarchar (-1)User entered comments.
commentsStaffnvarchar (-1)Any comments about the Staff.
commentsStaff_Benefit_Entrynvarchar (-1)Comments about this entry.
commentsStaff_Locatornvarchar (-1)Any comments entered by the user.
commentsTask_Templatenvarchar (-1)
companyContactnvarchar (250)Company of the contact.
companyHistory_Of_Contactnvarchar (250)
completeHistory_Of_Sheet_Entrybit
completeSheet_Entrybit
complete__target_date_method_KEYHistory_Of_Schedule_Item_Seriesint
complete__target_date_method_KEYProject_Template_Definitionint
complete__target_date_method_KEYSchedule_Item_SeriesintThe method used to calculate the target complete date.
complete__target_date_method_KEYTask_Templateint
complete_date_utcFile_TransferdatetimeThe File_Transfer_Event.event_date_utc of the event that completed this File Transfer
complete_date_utcHistory_Of_File_Transferdatetime
completion_eventHistory_Of_Projectnvarchar (50)
completion_eventHistory_Of_Tasknvarchar (50)
completion_eventProjectnvarchar (50)Description of a "User" type client status event that will mark this Project as being complete.
completion_eventProject_Templatenvarchar (50)Description of an event that will mark the generated project as being complete.
completion_eventTasknvarchar (50)Description of a "User" type client status event that will mark this Task as being complete.
completion_eventTask_Templatenvarchar (50)
completion_event_recorded_date_utcHistory_Of_Projectdatetime
completion_event_recorded_date_utcHistory_Of_Taskdatetime
completion_event_recorded_date_utcProjectdatetimeOnly 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_utcTaskdatetimeOnly 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_orderHistory_Of_Taskint
completion_orderTaskintThe user defined order the tasks are to be completed in (not unique).
completion_orderTask_Templateint
complexityClientint
complexityHistory_Of_Clientint
complexity_event_date_utcClientdatetime
complexity_event_date_utcHistory_Of_Clientdatetime
complexity_product_yearClientint
complexity_product_yearHistory_Of_Clientint
compoundService_ChargebitDetermines whether prior service charges should be included in the balance that is going to be used for the service charge.
computerRecorded_Eventnvarchar (15)Name of computer that was running Practice when the event was detected.
confirm_changesOutlook_Contact_Synchronization_Folderbittrue if this profile should display a confirmation dialog prior to committing sync changes between the database and Outlook?.
CONSTRAINT_NAMECOMMON_Metadata_About_Foreign_Keysnvarchar (128)
CONSTRAINT_NAMECOMMON_Metadata_About_Keysnvarchar (128)
contact__contact_KEYFile_Transferintcontact that this transfer is to
contact__contact_KEYHistory_Of_File_Transferint
contact__portal_user_KEYFile_Transferintportal that this transfer is to
contact__portal_user_KEYHistory_Of_File_Transferint
contact_address_KEYContact_AddressintAUTO-INCREMENT: Database assigned primary key for this table.
contact_address_KEYHistory_Of_Contact_Addressint
contact_address_type_KEYContact_AddressintKey to a Contact Address Type record.
contact_address_type_KEYHistory_Of_Contact_Addressint
contact_category_idContact_Categorynvarchar (11)User defined identifier (unique).
contact_category_idHistory_Of_Contact_Categorynvarchar (11)
contact_category_id_sortableContact_Categoryvarchar (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_sortableHistory_Of_Contact_Categoryvarchar (48)
contact_category_KEYContact_CategoryintAUTO-INCREMENT: Database assigned primary key for this table.
contact_category_KEYContact_Contact_CategoryintKey to the assigned category.
contact_category_KEYHistory_Of_Contact_Categoryint
contact_category_KEYHistory_Of_Contact_Contact_Categoryint
contact_contact_category_KEYContact_Contact_CategoryintAUTO-INCREMENT: Database assigned primary key for this table.
contact_contact_category_KEYHistory_Of_Contact_Contact_Categoryint
contact_email_KEYContact_EmailintAUTO-INCREMENT: Database assigned primary key for this table.
contact_email_KEYHistory_Of_Contact_Emailint
contact_email_KEYMonitored_Event_ActionintSpecifes non-staff email address to notify when event occurs.
contact_email_KEYRecorded_Event_NotificationintKey if someone was notified via email.
contact_email_type_KEYContact_EmailintKey to a Contact Email Type record.
contact_email_type_KEYHistory_Of_Contact_Emailint
contact_guidContactuniqueidentifier
contact_guidHistory_Of_Contactuniqueidentifier
contact_KEYClientintKey to the primary Contact record for this Client.
contact_KEYContactintAssigned by COMMON_dp_Allocate_Unique_Identifiers. Database assigned primary key for this table.
contact_KEYContact_AddressintKey to a Contact record.
contact_KEYContact_Contact_CategoryintKey to the parent contact record.
contact_KEYContact_EmailintKey to a Contact record.
contact_KEYContact_PhoneintKey to a Contact record.
contact_KEYHistory_Of_Clientint
contact_KEYHistory_Of_Contactint
contact_KEYHistory_Of_Contact_Addressint
contact_KEYHistory_Of_Contact_Contact_Categoryint
contact_KEYHistory_Of_Contact_Emailint
contact_KEYHistory_Of_Contact_Phoneint
contact_KEYInteraction_ContactintA reference to one of the Contact rows.
contact_KEYLegacy_Contact_Portal_MappingintThe contact key.
contact_KEYOfficeintKey to the primary Contact record for this Client.
contact_KEYStaffintKey to the primary Contact record for this Staff.
contact_phone_KEYContact_PhoneintAUTO-INCREMENT: Database assigned primary key for this table.
contact_phone_KEYHistory_Of_Contact_Phoneint
contact_phone_type_KEYContact_PhoneintKey to a Contact Phone Type record.
contact_phone_type_KEYHistory_Of_Contact_Phoneint
contact_phone_type_KEYInteraction_Phone_NumberintKey to a Contact Phone Type record.
contact_type_KEYContactintKey to Contact Type.
contact_type_KEYHistory_Of_Contactint
contentFeed_Channel_Itemnvarchar (-1)
control_dateLedger_EntrysmalldatetimeDate used to group Ledger Entries together.
costHistory_Of_Schedule_Itemdecimal (9, 2)
costSchedule_Itemdecimal (9, 2)
countryAddressnvarchar (25)Country.
countryContact_Addressnvarchar (25)Country.
countryHistory_Of_Contact_Addressnvarchar (25)
countyAddressnvarchar (25)County.
countyContact_Addressnvarchar (25)County.
countyHistory_Of_Contact_Addressnvarchar (25)
create__changeset_KEYAdditional_Contactint
create__changeset_KEYAttachmentint
create__changeset_KEYAttachment_Contentint
create__changeset_KEYCalendar_Categoryint
create__changeset_KEYClientint
create__changeset_KEYClient_Financial_Dataint
create__changeset_KEYClient_Financial_Data_Descriptionint
create__changeset_KEYClient_Staff_Groupingint
create__changeset_KEYContactint
create__changeset_KEYContact_Addressint
create__changeset_KEYContact_Categoryint
create__changeset_KEYContact_Contact_Categoryint
create__changeset_KEYContact_Emailint
create__changeset_KEYContact_Phoneint
create__changeset_KEYCustom_Chartint
create__changeset_KEYCustom_Fieldint
create__changeset_KEYCustom_Valueint
create__changeset_KEYDigita_Vat_Periodint
create__changeset_KEYEngagementint
create__changeset_KEYFile_Transferint
create__changeset_KEYFile_Transfer_Eventint
create__changeset_KEYFile_Transfer_Fileint
create__changeset_KEYHistory_Of_Additional_Contactint
create__changeset_KEYHistory_Of_Attachmentint
create__changeset_KEYHistory_Of_Attachment_Contentint
create__changeset_KEYHistory_Of_Calendar_Categoryint
create__changeset_KEYHistory_Of_Clientint
create__changeset_KEYHistory_Of_Client_Financial_Dataint
create__changeset_KEYHistory_Of_Client_Financial_Data_Descriptionint
create__changeset_KEYHistory_Of_Client_Staff_Groupingint
create__changeset_KEYHistory_Of_Contactint
create__changeset_KEYHistory_Of_Contact_Addressint
create__changeset_KEYHistory_Of_Contact_Categoryint
create__changeset_KEYHistory_Of_Contact_Contact_Categoryint
create__changeset_KEYHistory_Of_Contact_Emailint
create__changeset_KEYHistory_Of_Contact_Phoneint
create__changeset_KEYHistory_Of_Custom_Chartint
create__changeset_KEYHistory_Of_Custom_Fieldint
create__changeset_KEYHistory_Of_Custom_Valueint
create__changeset_KEYHistory_Of_Digita_Vat_Periodint
create__changeset_KEYHistory_Of_Engagementint
create__changeset_KEYHistory_Of_File_Transferint
create__changeset_KEYHistory_Of_File_Transfer_Eventint
create__changeset_KEYHistory_Of_File_Transfer_Fileint
create__changeset_KEYHistory_Of_Linkint
create__changeset_KEYHistory_Of_Link_Groupint
create__changeset_KEYHistory_Of_Portal_Userint
create__changeset_KEYHistory_Of_Projectint
create__changeset_KEYHistory_Of_Project_Extensionint
create__changeset_KEYHistory_Of_Schedule_Entryint
create__changeset_KEYHistory_Of_Schedule_Itemint
create__changeset_KEYHistory_Of_Schedule_Item_Assignmentint
create__changeset_KEYHistory_Of_Schedule_Item_Budget_Remaining_Entryint
create__changeset_KEYHistory_Of_Schedule_Item_Seriesint
create__changeset_KEYHistory_Of_Sheet_Entryint
create__changeset_KEYHistory_Of_Tagint
create__changeset_KEYHistory_Of_Tagged_Itemint
create__changeset_KEYHistory_Of_Taskint
create__changeset_KEYHistory_Of_Time_Zoneint
create__changeset_KEYHistory_Of_Timerint
create__changeset_KEYLinkint
create__changeset_KEYLink_Groupint
create__changeset_KEYPortal_Userint
create__changeset_KEYProjectint
create__changeset_KEYProject_Extensionint
create__changeset_KEYSchedule_Entryint
create__changeset_KEYSchedule_Itemint
create__changeset_KEYSchedule_Item_Assignmentint
create__changeset_KEYSchedule_Item_Budget_Remaining_Entryint
create__changeset_KEYSchedule_Item_Seriesint
create__changeset_KEYSheet_Entryint
create__changeset_KEYTagint
create__changeset_KEYTagged_Itemint
create__changeset_KEYTaskint
create__changeset_KEYTime_Zoneint
create__changeset_KEYTimerint
create__staff_KEYHistory_Of_Linkint
create__staff_KEYLinkintKey of Staff who created this row.
create_dateFilterdatetime
create_dateFilter_Linedatetime
create_dateFilter_Selectdatetime
create_date_utcAccruable_Benefitdatetime
create_date_utcAccruable_Benefit_Allowance_By_Monthdatetime
create_date_utcAccruable_Benefit_Allowance_By_Staff_Leveldatetime
create_date_utcActive_Filterdatetime
create_date_utcActivitydatetime
create_date_utcActivity_Categorydatetime
create_date_utcBank_Accountdatetime
create_date_utcBenefitdatetime
create_date_utcBenefit_Factordatetime
create_date_utcBilling_Decisiondatetime
create_date_utcBilling_Decision_Collectiondatetime
create_date_utcBilling_Decision_Tax_Collectiondatetime
create_date_utcBilling_Decision_Taxing_Authoritydatetime
create_date_utcBilling_Rate_Typedatetime
create_date_utcClient_Shortcutdatetime
create_date_utcClient_Shortcut_Groupdatetime
create_date_utcClient_Status_Eventdatetime
create_date_utcContactdatetime
create_date_utcContact_Addressdatetime
create_date_utcContact_Emaildatetime
create_date_utcContact_Phonedatetime
create_date_utcCustom_Fieldviewdatetime
create_date_utcCustom_Fieldview_Typedatetime
create_date_utcCustom_Formuladatetime
create_date_utcCustom_Groupingdatetime
create_date_utcCustom_Portletdatetime
create_date_utcDashboard_Layoutdatetime
create_date_utcDepartmentdatetime
create_date_utcEducation_Sponsordatetime
create_date_utcEngagement_Templatedatetime
create_date_utcEngagement_Typedatetime
create_date_utcEntitydatetime
create_date_utcFeed_Channeldatetime
create_date_utcFeed_Channel_Itemdatetime
create_date_utcFeed_Channel_Item_Enclosuredatetime
create_date_utcFeed_Channel_Item_Staff_Readdatetime
create_date_utcFeed_Portletdatetime
create_date_utcFirmdatetime
create_date_utcFirm_Datedatetime
create_date_utcFirm_Shortcutdatetime
create_date_utcFirm_Shortcut_Groupdatetime
create_date_utcGL_Entry_Export_Optiondatetime
create_date_utcIntegration_Applicationdatetime
create_date_utcIntegration_Invoicedatetime
create_date_utcIntegration_Invoice_Prior_Paymentdatetime
create_date_utcIntegration_Sheet_Entrydatetime
create_date_utcInteraction_Linkdatetime
create_date_utcInvoicedatetime
create_date_utcLedger_Entrydatetime
create_date_utcLedger_Entry_Applicationdatetime
create_date_utcLedger_Entry_Service_Chargedatetime
create_date_utcLost_Reasondatetime
create_date_utcLost_Todatetime
create_date_utcMonitored_Eventdatetime
create_date_utcMonitored_Event_Actiondatetime
create_date_utcObserved_Holidaydatetime
create_date_utcOfficedatetime
create_date_utcOnline_Invoicedatetime
create_date_utcOnline_Paymentdatetime
create_date_utcOutlook_Contact_Synchronization_Folderdatetime
create_date_utcOutlook_Contact_Synchronization_Profiledatetime
create_date_utcPrint_Optiondatetime
create_date_utcProject_Templatedatetime
create_date_utcProject_Template_Assignmentdatetime
create_date_utcProject_Template_Definitiondatetime
create_date_utcProject_Template_Definition_Extensiondatetime
create_date_utcProject_Template_Definition_Importeddatetime
create_date_utcProject_Template_Entitydatetime
create_date_utcProject_Template_Extensiondatetime
create_date_utcRecorded_Eventdatetime
create_date_utcRecurring_Billdatetime
create_date_utcReferral_Sourcedatetime
create_date_utcReport_Definitiondatetime
create_date_utcReport_Definition_Security_Groupdatetime
create_date_utcReport_Definition_Update_Listdatetime
create_date_utcReport_Imagedatetime
create_date_utcReport_Profiledatetime
create_date_utcReport_Profile_Report_Definitiondatetime
create_date_utcSchedule_Itemdatetime
create_date_utcSecurity_Groupdatetime
create_date_utcService_Chargedatetime
create_date_utcStaffdatetime
create_date_utcStaff_Area_Ratingdatetime
create_date_utcStaff_Benefitdatetime
create_date_utcStaff_Benefit_Entrydatetime
create_date_utcStaff_Billing_Ratedatetime
create_date_utcStaff_Leveldatetime
create_date_utcStaff_Locatordatetime
create_date_utcStaff_Rate_Tabledatetime
create_date_utcStaff_Report_Definitiondatetime
create_date_utcStaff_Security_Groupdatetime
create_date_utcStaff_Shortcutdatetime
create_date_utcStaff_Shortcut_Groupdatetime
create_date_utcStaff_Skill_Areadatetime
create_date_utcStaff_Skill_Ratingdatetime
create_date_utcStandard_Textdatetime
create_date_utcStatus_Eventdatetime
create_date_utcStatus_Event_Typedatetime
create_date_utcTask_Templatedatetime
create_date_utcTask_Template_Assignmentdatetime
create_date_utcTax_Areadatetime
create_date_utcTax_Area_Taxing_Authoritydatetime
create_date_utcTaxing_Authoritydatetime
create_date_utcTermdatetime
create_date_utcTracking_Descriptiondatetime
create_date_utcUpdate_Data_Change_Logdatetime
create_date_utcUser_Preferencedatetime
create_date_utcWeb_Page_Portletdatetime
create_date_utcWon_Reasondatetime
create_file_cabinet_folder_for_new_clientsFirmbitAutomatically create FileCabinet folder for new clients
create_machine_nameHistory_Of_Linknvarchar (50)
create_machine_nameLinknvarchar (50)Machine name of the machine on which this link was created
create_portals_for_new_clientsFirmbitAutomatically create NetClient CS portals for new Clients
create_portals_for_new_prospectsFirmbitAutomatically create NetClient CS portals for new Prospects
create_portals_for_new_staffFirmbitAutomatically create NetStaff CS portals for new Staff
creditEducation_Creditdecimal (9, 2)
credit_card_idCredit_Card_Typenvarchar (4)ID (abbreviation) for the credit card type.
credit_card_id_sortableCredit_Card_Typevarchar (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_KEYCredit_CardintAssigned by COMMON_dp_Allocate_Unique_Identifiers. Database assigned key for this record.
credit_card_KEYLedger_Entry_SubmittalintCredit card info used in this submittal.
credit_card_type_KEYCredit_CardintDatabase assigned key for this credit card type.
credit_card_type_KEYCredit_Card_TypeintDatabase assigned key for this record.
credit_memos_gl_accountGL_Entry_Export_Optionnvarchar (60)
CSI_firm_IDFirmint
currency_decimal_digitsFirmsmallint (5)Number of digits to support on currency values.
currency_symbolFirmnvarchar (3)Symbol to use for currency values.
current_due_date_exclusive_utcHistory_Of_Schedule_Itemdatetime
current_due_date_exclusive_utcSchedule_ItemdatetimeCurrent due date (exclusive) of this schedule item.
custom_chart_KEYCustom_ChartintAssigned by COMMON_dp_Allocate_Unique_Identifiers. Database assigned primary key for this table.
custom_chart_KEYHistory_Of_Custom_Chartint
custom_chart_type_KEYCustom_ChartintForiegn key to specify what type this custom chart is.
custom_chart_type_KEYHistory_Of_Custom_Chartint
custom_field_descriptionIntegration_Custom_Valuenvarchar (250)
custom_field_KEYCustom_Fieldint
custom_field_KEYCustom_GroupingintKey to a Custom Field.
custom_field_KEYCustom_ValueintKey of the Custom field that this value is for.
custom_field_KEYHistory_Of_Custom_Fieldint
custom_field_KEYHistory_Of_Custom_Valueint
custom_field_KEYIntegration_Custom_Valueint
custom_field_KEYUser_Preference_Custom_Field_ColumnintKey of the Custom Field that this entry is for
custom_field_slotCustom_FieldintWhich slot this field is in, used for sorting items by custom field columns.
custom_field_slotCustom_Valueint
custom_field_slotHistory_Of_Custom_Fieldint
custom_field_slotHistory_Of_Custom_Valueint
custom_field_type_KEYCustom_FieldintForeign key to specify what data type this column is.
custom_field_type_KEYCustom_Valueint
custom_field_type_KEYHistory_Of_Custom_Fieldint
custom_field_type_KEYHistory_Of_Custom_Valueint
custom_field_type_KEYIntegration_Custom_Valueint
custom_fieldview_KEYCustom_FieldviewintAUTO-INCREMENT: Database assigned primary key for this table.
custom_fieldview_type_KEYCustom_FieldviewintKey of an existing of the the Custom Fieldview Type.
custom_fieldview_type_KEYCustom_Fieldview_TypeintAUTO-INCREMENT: Hardcoded primary key.
custom_formula_data_type_KEYCustom_FormulaintForiegn key to specify what data type this custom formula is.
custom_formula_KEYCustom_FormulaintAssigned by COMMON_dp_Allocate_Unique_Identifiers. Database assigned primary key for this table.
custom_grouping_idCustom_Groupingnvarchar (11)User defined identifier (unique).
custom_grouping_id_sortableCustom_Groupingvarchar (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_KEYCustom_Groupingint
custom_portlet_KEYCustom_PortletintAssigned by COMMON_dp_Allocate_Unique_Identifiers. Key assigned to identify this record.
custom_portlet_KEYFeed_Portletint
custom_portlet_KEYReport_Based_PortletintKey of the Custom_Portlet row that this table holds additional information for.
custom_portlet_KEYWeb_Page_Portletint
custom_portlet_type_KEYCustom_PortletintReference to the type of custom portlet that this is.
custom_portlet_type_KEYCustom_Portlet_TypeintKey assigned to identify this record.
custom_report_layoutReport_Definitionnvarchar (-1)ActiveReports RPX layout definition.
custom_valueCustom_Valuenvarchar (4000)A string representation of the actual value.
custom_valueHistory_Of_Custom_Valuenvarchar (4000)
custom_valueIntegration_Custom_Valuenvarchar (4000)
custom_value__custom_grouping_KEYCustom_Valueint
custom_value__custom_grouping_KEYHistory_Of_Custom_Valueint
custom_value__staff_KEYCustom_Valueint
custom_value__staff_KEYHistory_Of_Custom_Valueint
custom_value_as_checkboxCustom_Valuebit
custom_value_as_checkboxHistory_Of_Custom_Valuebit
custom_value_as_dateCustom_Valuedatetime
custom_value_as_dateHistory_Of_Custom_Valuedatetime
custom_value_as_numberCustom_Valuedecimal (25, 10)
custom_value_as_numberHistory_Of_Custom_Valuedecimal (25, 10)
custom_value_KEYCustom_ValueintAssigned by COMMON_dp_Allocate_Unique_Identifiers. Primary key for this table.
custom_value_KEYHistory_Of_Custom_Valueint
dashboard_layout_KEYDashboard_LayoutintAssigned by COMMON_dp_Allocate_Unique_Identifiers. Primary key for this table
dashboard_layout_KEYFirm_Dashboard_LayoutintKey to the dashboard layout that is to be used.
dashboard_layout_type_KEYDashboard_LayoutintType of dashboad layout
dashboard_layout_type_KEYFirm_Dashboard_LayoutintThe type of dashboard layout that this firm preference is referring to (Home, Client, Staff, etc).
database_property_KEYDatabase_PropertyintAUTO-INCREMENT: Database assigned primary key for this table.
datasharing_application_KEYDatasharing_PathintThe datasharing application that this path is associated with.
datasharing_group_KEYDatasharing_GroupintAssigned by COMMON_dp_Allocate_Unique_Identifiers. Primary key for this table. This table is used to associate Datasharing_Path rows together
datasharing_group_KEYDatasharing_PathintUsed to associate Datasharing_Path rows together in a group
datasharing_path_KEYDatasharing_PathintAssigned by COMMON_dp_Allocate_Unique_Identifiers. Primary key for this table
date_certifiedStaffsmalldatetimeDate certified.
date_education_metStaffsmalldatetimeDate education met.
date_exam_passedStaffsmalldatetimeDate exam passed.
date_experience_metStaffsmalldatetimeDate experience met.
date_hiredStaffsmalldatetimeDate hired.
date_leftClientsmalldatetimeDate your firm terminated the client/firm relationship.
date_leftHistory_Of_Clientsmalldatetime
date_leftStaffsmalldatetimeDate Staff no longer employed.
date_openedClientsmalldatetimeDate the client came to your firm, default system date when a new client is added.
date_openedHistory_Of_Clientsmalldatetime
days_to_due_dateClientintNumber of days to be used when calculating a due date in billing.
days_to_due_dateFirmintNumber of days to use in calculating due dates.
days_to_due_dateHistory_Of_Clientint
debit_memos_gl_accountGL_Entry_Export_Optionnvarchar (60)
default_aliasTable_Informationnvarchar (128)The default alias to use for this table.
default_block_sizeCOMMON_Unique_Identifier_Counterint
default_optionsStaff_Report_Definitionnvarchar (-1)The default report options in serialized XML format.
default_report_layoutReport_Definitionnvarchar (100)Default report layout XML resource.
default_valueUser_Preference_Custom_Field_Columnnvarchar (4000)The default value for this field in Time and expense entry
department_grouping_type_KEYDepartment_Grouping_TypeintPrimary key for this table.
department_grouping_type_KEYProject_TemplateintKey to a Department Grouping Type that indicates how to determine which department will be assigned to generated projects.
department_idDepartmentnvarchar (11)User defined identifier (unique).
department_id_sortableDepartmentvarchar (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_KEYDepartmentintAUTO-INCREMENT: Database assigned primary key for this table.
department_KEYHistory_Of_Projectint
department_KEYProjectintKey to a Department that will be used for generated projects.
department_KEYProject_TemplateintKey to a Department that will be used for generated projects.
department_KEYStaffintKey from one of the already set up Departments.
dependent__privilege_KEYPrivilege_DependencyintForeign key to a [Privilege] that [privilege_KEY] depends on.
descriptionActive_Filternvarchar (250)Description of where this filter is being used.
descriptionActivitynvarchar (250)User defined description.
descriptionActivity_Categorynvarchar (250)User Defined description
descriptionBank_Accountnvarchar (250)User defined description.
descriptionBilling_Rate_Typenvarchar (250)User defined description.
descriptionCalendar_Categorynvarchar (250)User defined description.
descriptionClientnvarchar (250)User defined description.
descriptionClient_Financial_Data_Descriptionnvarchar (100)unique description of this table
descriptionClient_Shortcutnvarchar (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.
descriptionClient_Shortcut_Groupnvarchar (250)User-configurable display name for the solution group.
descriptionContact_Categorynvarchar (250)User defined description.
descriptionCredit_Card_Typenvarchar (20)Description for this record
descriptionCustom_Chartnvarchar (250)Description of the custom chart. The same description can only be used once per owner_table_name.
descriptionCustom_Fieldnvarchar (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.
descriptionCustom_Fieldviewnvarchar (250)User defined description (unique per custom_fieldview_type_KEY).
descriptionCustom_Fieldview_Typenvarchar (250)Description of this Custom Fieldview Type.
descriptionCustom_Formulanvarchar (250)Description of the custom formula. The same description can only be used once per owner_table_name.
descriptionCustom_Groupingnvarchar (250)User defined description.
descriptionCustom_Portletnvarchar (250)Description of the portlet (unique per private__staff_KEY.)
descriptionCustom_Portlet_Typenvarchar (30)Description.
descriptionDashboard_Layoutnvarchar (250)User defined description
descriptionDepartmentnvarchar (250)User defined description.
descriptionDepartment_Grouping_Typenvarchar (250)Description.
descriptionEducation_Accountancynvarchar (50)
descriptionEducation_Accountancy_Categorynvarchar (50)
descriptionEducation_Accountancy_Typenvarchar (50)
descriptionEducation_Sponsornvarchar (250)User defined description.
descriptionEngagementnvarchar (250)User defined description.
descriptionEngagement_Templatenvarchar (250)User defined description.
descriptionEngagement_Typenvarchar (250)User Defined description
descriptionEntitynvarchar (250)User Defined description
descriptionEvent_Class_Typenvarchar (30)Practice-defined description (unique).
descriptionFilternvarchar (250)User defined description (unique per filter_type_KEY).
descriptionFilter_Base_Typenvarchar (300)Description that is presented to the user.
descriptionFilter_Line_Typenvarchar (30)The description of this type of critera (overridden by Filter Base Type).
descriptionFilter_Range_Typenvarchar (30)Name of this range as it should appear to the user.
descriptionFilter_Typenvarchar (30)User friendly name for this type of filter.
descriptionFirm_Date_Typenvarchar (250)User defined description (unique).
descriptionFirm_Shortcutnvarchar (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.
descriptionFirm_Shortcut_Groupnvarchar (250)User-configurable display name for the solution group.
descriptionGL_Entry_Export_Typenvarchar (30)
descriptionHistory_Actionnvarchar (30)What action took place to create a history record.
descriptionHistory_Of_Calendar_Categorynvarchar (250)
descriptionHistory_Of_Clientnvarchar (250)
descriptionHistory_Of_Client_Financial_Data_Descriptionnvarchar (100)
descriptionHistory_Of_Contact_Categorynvarchar (250)
descriptionHistory_Of_Custom_Chartnvarchar (250)
descriptionHistory_Of_Custom_Fieldnvarchar (250)
descriptionHistory_Of_Engagementnvarchar (250)
descriptionHistory_Of_Linknvarchar (260)
descriptionHistory_Of_Link_Groupnvarchar (260)
descriptionHistory_Of_Schedule_Itemnvarchar (250)
descriptionHistory_Of_Tagnvarchar (250)
descriptionIntegration_Applicationnvarchar (250)User defined description (unique).
descriptionIntegration_Invoice_Prior_Paymentnvarchar (250)Description of the payment.
descriptionInteraction_Associationnvarchar (250)The type of association that a Contact has to an Interaction.
descriptionInteraction_Subtypenvarchar (250)Description (unique per interaction_type_KEY).
descriptionLedger_Entry_Subtypenvarchar (30)Description (unique per ledger_entry_type_KEY).
descriptionLedger_Entry_Typenvarchar (250)User defined description (unique).
descriptionLinknvarchar (260)User-configurable name of this link
descriptionLink_Groupnvarchar (260)The user-configurable name of this group
descriptionLost_Reasonnvarchar (250)User defined description (unique).
descriptionLost_Tonvarchar (250)User defined description (unique).
descriptionMonth_Infonvarchar (250)The name of the month (January, December, etc.)
descriptionObserved_Holidaynvarchar (250)Description of the holiday.
descriptionOfficenvarchar (250)User defined description.
descriptionOption_Listnvarchar (250)
descriptionPrioritynvarchar (250)User defined description (unique).
descriptionPrivilegenvarchar (50)This is the description that users will see.
descriptionProject_Templatenvarchar (250)User defined description.
descriptionProject_Template_Definitionnvarchar (250)User defined description.
descriptionRecurrence_Expiration_Methodnvarchar (250)User defined description (unique).
descriptionRecurrence_Generation_Methodnvarchar (250)User defined description (unique).
descriptionRecurrence_Methodnvarchar (250)User defined description (unique).
descriptionRecurring_Billnvarchar (250)User defined description (unique).
descriptionReferral_Sourcenvarchar (250)User defined description (unique).
descriptionReport_Categorynvarchar (30)User defined description (unique).
descriptionReport_Definitionnvarchar (250)User defined description.
descriptionReport_Profilenvarchar (250)User defined description (unique).
descriptionSchedule_Itemnvarchar (250)User defined description.
descriptionSecurity_Groupnvarchar (250)User defined identifier (unique).
descriptionService_Chargenvarchar (250)User defined description (unique).
descriptionStaffnvarchar (250)User defined description.
descriptionStaff_Grouping_Typenvarchar (250)User defined description (unique).
descriptionStaff_Levelnvarchar (250)User defined description.
descriptionStaff_Shortcutnvarchar (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.
descriptionStaff_Shortcut_Groupnvarchar (260)User-configurable display name for the solution group.
descriptionStaff_Skill_Areanvarchar (250)User defined description (unique).
descriptionStaff_Skill_Ratingnvarchar (250)User defined description (unique).
descriptionStatus_Eventnvarchar (50)User defined description (unique).
descriptionStatus_Event_Typenvarchar (250)User defined description (unique).
descriptionTagnvarchar (250)The tag text.
descriptionTarget_Date_Methodnvarchar (250)User defined description (unique).
descriptionTask_Templatenvarchar (250)
descriptionTax_Areanvarchar (250)Describes a Tax Area
descriptionTaxing_Authoritynvarchar (250)Description for this Taxing Authority
descriptionTermnvarchar (50)System description.
descriptionTracking_Descriptionnvarchar (250)User defined description (unique).
descriptionWon_Reasonnvarchar (250)User defined description (unique).
detailsMonitored_Eventnvarchar (-1)XML blob with details about testing for the event that aren't practical to store in column form.
detailsRecorded_Eventnvarchar (-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_KEYDigittinyint (3)Holds the values 0 to 9. Named for backwards compatibility.
digita_entityidContactuniqueidentifierThe 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_entityidHistory_Of_Contactuniqueidentifier
digita_integration_configFirmnvarchar (-1)The digita integration config is a block of xml (serialized object) which describes the configuration of digita integration.
digita_metadataContactnvarchar (-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_metadataHistory_Of_Contactnvarchar (-1)
digita_out_of_dateClientbitFlag that is set when changes are detected to the entity that have not been applied to this database.
digita_out_of_dateHistory_Of_Clientbit
digita_proforma__ledger_entry_KEYLedger_EntryintThe new key for the digita proforma ledger entry related to this ledger entry.
digita_tax_point_date_overrideLedger_EntrydatetimeAllows entry_date to be overridden as the tax point.
digita_using_continuous_supplyFirmbitThe digita using continuous supply field is a flag which specifies whether or not the user is using continuous supply of service.
digita_vat_period_KEYDigita_Vat_Periodint
digita_vat_period_KEYHistory_Of_Digita_Vat_Periodint
digita_vat_period_KEYLedger_EntryintThe key for the closed digita VAT period.
discountBilling_Decisiondecimal (9, 2)Discount applied to this item.
discountClient_Date_Cachedecimal (9, 2)discount sum for the Client, principal Client, and entry date
discountIntegration_Invoicedecimal (17, 2)The discount amount on this integration_invoice (always 0 or negative.)
discountInvoicedecimal (17, 2)The discount amount on this invoice (always 0 or negative.)
discount_collectedBilling_Decision_Collectiondecimal (9, 2)The amount collected for the discount of the Billing_Decision.
dismissed_date_utcRecorded_Event_NotificationdatetimeDate recipent dismissed (don't show me this again) the notification in UTC.
display_asContact_Emailnvarchar (320)
display_asHistory_Of_Contact_Emailnvarchar (320)
due_dateHistory_Of_Project_Extensionsmalldatetime
due_dateIntegration_InvoicesmalldatetimeDue date
due_dateInvoicesmalldatetimeDue date
due_dateProject_ExtensionsmalldatetimeCurrent due date of this extension.
due_date_based_on_fiscal_year_endProject_Template_DefinitionbitWhen the value is 1 the due date is adjusted for the Client's fiscal year end.
due_date_must_occur_on_weekdaysProject_Template_DefinitionbitWhen the value is 1 the due date is adjusted so that it does not fall on a weekend.
education_accountancy_category_KEYEducation_Accountancy_Categoryint
education_accountancy_category_KEYEducation_Creditint
education_accountancy_KEYEducation_Accountancyint
education_accountancy_KEYEducation_Accountancy_Categoryint
education_accountancy_KEYEducation_Accountancy_Typeint
education_accountancy_KEYEducation_Creditint
education_accountancy_type_KEYEducation_Accountancy_Typeint
education_accountancy_type_KEYEducation_Creditint
education_course__schedule_item_KEYHistory_Of_Sheet_Entryint
education_course__schedule_item_KEYSheet_EntryintOptionally links this Sheet Entry to a [Education_Course] row.
education_credit_KEYEducation_Creditint
education_delivery_format_KEYHistory_Of_Schedule_Itemint
education_delivery_format_KEYSchedule_Itemint
education_sponsor_idEducation_Sponsornvarchar (11)User defined identifier (unique).
education_sponsor_id_sortableEducation_Sponsorvarchar (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_KEYEducation_SponsorintAUTO-INCREMENT: Database assigned primary key for this table.
education_sponsor_KEYHistory_Of_Schedule_Itemint
education_sponsor_KEYSchedule_Itemint
effective_dateStaff_BenefitsmalldatetimeThe effective date of this staff benefit.
effective_dateStaff_Rate_TablesmalldatetimeThe date this rate table becomes effective.
elapsed_secondsHistory_Of_Timerint
elapsed_secondsTimerintThe number of seconds this timer ran before it was stopped, or 0 if it is still running.
emailContact_Emailnvarchar (320)E-mail address.
emailHistory_Of_Contact_Emailnvarchar (320)
email_addressEmail_Addressnvarchar (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_addressHistory_Of_Portal_Usernvarchar (150)
email_addressPortal_Usernvarchar (150)email address associated with this portal
email_address_fieldInteraction_Email_Addressvarchar (4)The e-mail address field this link came from (Bcc, Cc, From or To.)
email_address_KEYEmail_AddressintAssigned 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_KEYInteraction_Email_AddressintA reference to one of the e-mail addresses stored in the Email_Address table.
email_output_typePrint_OptionintThe type of file format to email reports in.
email_positionContactnvarchar (6)Semicolon seperated list of contact_email_type_KEY values indicating the user's preferred order of displaying e-mail addresses.
email_positionHistory_Of_Contactnvarchar (6)
email_recipientsPrint_Optionnvarchar (-1)The email recipients.
email_save_draftsPrint_OptionbitSave e-mails to Drafts folder (do not send).
email_staffMonitored_Event_ActionbitIndicates whether all staff specified by this record should be emailed when the event occurs.
enable_ach_processingFirmbitWhether or not Ach Processing is enabled.
enable_automatic_importOutlook_Contact_Synchronization_ProfilebitDetermines if contacts added in Outlook? should automatically be added to the database without user intervention.
enable_credit_card_processingFirmbitWhether or not Credit Card Processing is enabled.
enable_desktop_alerts_for_notificationsUser_PreferencebitEnables desktop alerts for notifications.
enabledOutlook_Contact_Synchronization_Folderbittrue if this profile is to be used to export contacts when the Sync button is pushed.
end_dateDigita_Vat_PerioddatetimeThe end date for the VAT period.
end_dateHistory_Of_Digita_Vat_Perioddatetime
end_dateHistory_Of_Portal_Userdatetime
end_datePortal_Userdatetimetime at which the portal server was made inactive
end_date_utcChangesetdatetimeWhen this changeset was ended. This is as close to the commit time of the transaction as possible.
ending_dateFirm_DatesmalldatetimeDate that this period ends.
ending_dateStaff_Target_RangesmalldatetimeREDUNDANT: For backwards compatibility and ease of display on reports and screens, this is 24 hours prior to the [upper_date_exclusive].
engagementGofileroom_Workflownvarchar (255)GoFileRoom engagement of this workflow.
engagement_KEYEngagementintAssigned by COMMON_dp_Allocate_Unique_Identifiers. Database assigned primary key for this table
engagement_KEYHistory_Of_Engagementint
engagement_KEYHistory_Of_Schedule_Itemint
engagement_KEYHistory_Of_Sheet_Entryint
engagement_KEYIntegration_Sheet_EntryintKey to the Engagement this entry is for.
engagement_KEYSchedule_ItemintThe linked [Engagement].
engagement_KEYSheet_EntryintKey to the Engagement this entry is for.
engagement_status_KEYEngagementintKey to a Engagement Status record.
engagement_status_KEYHistory_Of_Engagementint
engagement_surcharge_method_KEYEngagementintKey to an Engagement Surcharge Method record. (1=No surcharge, 2=Based on Activity, 3=Flat amount)
engagement_surcharge_method_KEYHistory_Of_Engagementint
engagement_template_idEngagement_Templatenvarchar (11)User defined identifier (unique).
engagement_template_id_sortableEngagement_Templatevarchar (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_KEYEngagementintKey to a Engagement Template record.
engagement_template_KEYEngagement_TemplateintAUTO-INCREMENT: Database assigned primary key for this table.
engagement_template_KEYHistory_Of_Engagementint
engagement_template_KEYProject_TemplateintKey to a Engagement Template that will be used for generated projects.
engagement_type_idEngagement_Typenvarchar (11)User defined identifier (unique).
engagement_type_id_sortableEngagement_Typevarchar (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_KEYEngagementintKey to a Engagement Type record.
engagement_type_KEYEngagement_TypeintAUTO-INCREMENT: Database assigned primary key for this table
engagement_type_KEYHistory_Of_Engagementint
enter_as_tabUser_PreferencebitEnter key functions as Tab
entityIntegration_Invoicenvarchar (11)Entity as defined by the exporting applciation.
entity_idEntitynvarchar (11)User defined identifier (unique).
entity_id_sortableEntityvarchar (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_KEYClientintKey to an Entity record.
entity_KEYEntityintAUTO-INCREMENT: Database assigned primary key for this table
entity_KEYHistory_Of_Clientint
entity_KEYProject_Template_EntityintKey to an Entity record.
entry__client_KEYUser_PreferenceintKey of one of the Client records
entry__engagement_template_KEYUser_PreferenceintKey of one of the Engagement Template records
entry__rounding_method_KEYUser_PreferenceintKey of one of the Rounding Method records
entry__time_style_KEYUser_PreferenceintKey of one of the Time Style records
entry__user_preference_default_entry_date_KEYUser_PreferenceintKey of one of the User Preference Default Entry Date records
entry__user_preference_default_sheet_date_KEYUser_PreferenceintKey of one of the User Preference Default Sheet Date records
entry_accumulate_time_before_roundingUser_Preferencebit
entry_activity_description_hideUser_Preferencebit
entry_allow_simultaneous_timersUser_PreferencebitAllow as many timers running at the same time as they want.
entry_auto_check_spellingUser_Preferencebit
entry_auto_fill_from_lastUser_Preferencebit
entry_biller_noteUser_Preferencenvarchar (-1)Default biller note for each entry
entry_biller_note_hideUser_PreferencebitHides the Biller Note column
entry_biller_note_skipUser_PreferencebitSkips the Biller Note column
entry_client_description_hideUser_Preferencebit
entry_client_hideUser_PreferencebitHides the Client column
entry_client_skipUser_PreferencebitSkips the Client column
entry_commentUser_Preferencenvarchar (-1)Default comment for each entry
entry_comment_hideUser_PreferencebitHides the Comment column
entry_comment_skipUser_PreferencebitSkips the Comment column
entry_custom_fields_hideUser_Preferencebit
entry_custom_fields_skipUser_Preferencebit
entry_dateClient_Date_CachesmalldatetimeEntry date that the sums are associated with.
entry_dateHistory_Of_Schedule_Item_Budget_Remaining_Entrysmalldatetime
entry_dateHistory_Of_Sheet_Entrysmalldatetime
entry_dateIntegration_Sheet_EntrysmalldatetimeDate this entry is for.
entry_dateLedger_EntrysmalldatetimeDate of this item (check date, invoice date, receipt date).
entry_dateSchedule_Item_Budget_Remaining_EntrysmalldatetimeThe date that this row was entered.
entry_dateSheet_EntrysmalldatetimeDate this entry is for.
entry_dateStaff_Benefit_EntrysmalldatetimeThe date that this entry corresponds to.
entry_date_hideUser_PreferencebitHides the Date column
entry_date_skipUser_PreferencebitSkips the Date column
entry_date_utcClient_Financial_DatadatetimeThe date the integration application provided this data, in UTC.
entry_date_utcHistory_Of_Client_Financial_Datadatetime
entry_date_utcInteractiondatetimeDate and time of this interaction in UTC.
entry_display_billedUser_PreferencebitDisplays billed entries
entry_display_custom_fieldsUser_Preferencebit
entry_display_education_course_selectionUser_Preferencebit
entry_display_hash_totalsUser_PreferencebitDisplays hash totals
entry_display_task_selectionUser_PreferencebitAutomatically displays the task selection screen after the project is selected
entry_education_course_selection_hideUser_Preferencebit
entry_education_course_selection_skipUser_Preferencebit
entry_engagement_description_hideUser_Preferencebit
entry_engagement_template_hideUser_PreferencebitHides the Engagement column
entry_engagement_template_skipUser_PreferencebitSkips the Engagement column
entry_expense__activity_KEYUser_PreferenceintKey of one of the Activity records for expenses
entry_expense__billing_rate_type_KEYUser_PreferenceintDefault rate for expense
entry_expense_activity_hideUser_PreferencebitHides the Activity column for expenses
entry_expense_activity_skipUser_PreferencebitSkips the Activity column for expenses
entry_expense_rate_hideUser_PreferencebitHides the Rate column for time
entry_expense_rate_skipUser_PreferencebitSkips the Rate column for time
entry_idOutlook_Contact_Synchronization_Foldervarbinary (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_idOutlook_Index_Folder_Firmvarbinary (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_idOutlook_Itemvarbinary (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_checksumOutlook_Contact_Synchronization_Folderint
entry_id_checksumOutlook_Index_Folder_FirmintSince the entry_id column is wider than 900 bytes, the SQL Server CHECKSUM function is used to compute an indexable column.
entry_id_checksumOutlook_Itemint
entry_implied_decimalUser_PreferencebitAutomatically inserts decimal point at end of hours
entry_new_row_at_topUser_PreferencebitShows the new row at the top when true, at the bottom when false.
entry_numberLedger_EntryintEach entry will be assigned a number that is unique by Ledger Entry Type that the user can select.
entry_project_description_hideUser_Preferencebit
entry_project_solution_button_hideUser_PreferencebitWhen true the project solution button column in time entry will be hidden
entry_project_solution_button_skipUser_PreferencebitWhen true the project solution button column in time entry will be skipped
entry_project_template_hideUser_PreferencebitSpecifies Project field is to be hidden on the Time and Expense Entry screen
entry_project_template_skipUser_PreferencebitSpecifies Project field is to be skipped on the Time and Expense Entry screen
entry_remote_time_entry__filter_KEYUser_PreferenceintKEY of the filter used to narrow the clients being exported for Remote Entry
entry_remote_time_entry_enabledUser_PreferencebitEnables the ability to use the quick Remote Entry export feature
entry_rounding_incrementUser_Preferencedecimal (4, 2)Increment for rounding time from the timer in hours
entry_sheet_date_skipUser_PreferencebitSkips the SheetDate entry field on the entry screen.
entry_staff_description_hideUser_PreferencebitWhen true the staff description column in time entry will be hidden
entry_start_phone_timersUser_PreferencebitSpecifies if timers are to be started when solutions are launched from Phone Calls
entry_start_project_timersUser_PreferencebitSpecifies if timers are to be started when solutions are launched from Projects/Tasks
entry_startup_tabUser_Preferencenvarchar (100)Which tab to start on.
entry_task_hideUser_PreferencebitWhen true the task dropdown column in time entry will be hidden
entry_task_selection_button_hideUser_PreferencebitWhen true the task selection button column in time entry will be hidden
entry_task_selection_button_skipUser_PreferencebitWhen true the task selection button column in time entry will be skipped
entry_task_skipUser_PreferencebitWhen true the task dropdown column in time entry will be skipped
entry_task_solution_button_hideUser_PreferencebitWhen true the task solution button column in receipt entry will be hidden
entry_task_solution_button_skipUser_PreferencebitWhen true the task solution button column in time entry will be skipped
entry_time__activity_KEYUser_PreferenceintKey of one of the Activity records for time
entry_time__billing_rate_type_KEYUser_PreferenceintDefault rate for time
entry_time_activity_hideUser_PreferencebitHides the Activity column for time
entry_time_activity_skipUser_PreferencebitSkips the Activity column for time
entry_time_rate_hideUser_PreferencebitHides the Rate column for time
entry_time_rate_skipUser_PreferencebitSkips the Rate column for time
entry_timer_hideUser_PreferencebitHides the Timer Column
entry_timer_skipUser_PreferencebitSkips the Timer column
errorcodeLedger_Entry_Submittal_Resultnvarchar (6)Contents of the errorcode field in the response returned by Intercept.
errordescLedger_Entry_Submittal_Resultnvarchar (200)Contents of the errordesc field in the response returned by Intercept.
event_class_property_type_KEYMonitored_EventintKey of property type for the given object type.
event_class_type_KEYEvent_Class_TypeintPrimary key for this table.
event_class_type_KEYMonitored_EventintKey of object type.
event_class_type_KEYRecorded_EventintKey of object type affected by the event.
event_date_utcClient_Status_EventdatetimeThe date and time the status event was recorded in UTC.
event_date_utcFile_Transfer_EventdatetimeThe time at which this event occurred
event_date_utcHistory_Of_File_Transfer_Eventdatetime
event_type_KEYMonitored_EventintKey of the event type that's being monitored.
event_type_KEYRecorded_EventintKey of event type that occurred.
expense_amount_adjustedInvoicedecimal (17, 2)Denormalized
expense_amount_billedIntegration_Invoicedecimal (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_billedInvoicedecimal (17, 2)Denormalized
expiration_dateHistory_Of_Portal_Userdatetime
expiration_datePortal_UserdatetimeIf a value exists then this portal is a temporary type portal and will expire at this time
expiration_dateUser_SessiondatetimeThe date and time that this session will expire in UTC.
expiration_date_utcFile_Transferdatetimedate that this File Transfer will no longer be available on the Portal server
expiration_date_utcHistory_Of_File_Transferdatetime
expiration_date_utcHistory_Of_Schedule_Item_Seriessmalldatetime
expiration_date_utcSchedule_Item_SeriessmalldatetimeIndicates the ending date of this series or null if none.
expiration_monthCredit_CardintCredit card expiration date month
expiration_occurrencesHistory_Of_Schedule_Item_Seriesint
expiration_occurrencesSchedule_Item_SeriesintIndicates the ending number of occurrences or 0 if none.
expiration_yearCredit_CardintCredit card expiration date year
expires_utcLogin_TicketdatetimeA timestamp after which the ticket should be considered invalid and can be deleted.
extensionContact_Phonenvarchar (5)Extension.
extensionHistory_Of_Contact_Phonenvarchar (5)
extensionInteraction_Phone_Numbernvarchar (5)Extension.
extension_dayProject_Template_Definition_ExtensionintDays to extend the project.
extension_dayProject_Template_ExtensionintDays to extend the project.
extension_eventHistory_Of_Projectnvarchar (50)
extension_eventProjectnvarchar (50)Description of a "User" type client status event that will cause this [Project] to be extended.
extension_eventProject_Templatenvarchar (50)Description of a "User" type client status event that will cause this [Project] to be extended.
extension_monthProject_Template_Definition_ExtensionintMonths to extend the project.
extension_monthProject_Template_ExtensionintMonths to extend the project.
extension_numberHistory_Of_Projectint
extension_numberHistory_Of_Project_Extensionint
extension_numberProjectintNumber 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_numberProject_ExtensionintNumber of this extension (unique per project_KEY). Extension 0 is the original due date.
extension_numberProject_Template_Definition_ExtensionintNumber of this extension (unique per project_template_definition_KEY).
extension_numberProject_Template_ExtensionintNumber of this extension (unique per project_template_KEY).
factorBenefit_Factordecimal (9, 2)The allowance benefit factor.
fcs__client_KEYPrint_OptionintThe client whose drawer reports will be output to.
fcs__staff_KEYPrint_OptionintThe staff whose drawer reports will be output to.
fcs_create_linkPrint_Optionbit
fcs_data_locationPrint_Optionnvarchar (260)FileCabinet Solution data location to output to.
fcs_file_by_typePrint_OptionintHow to file a report (e.g., by the firm's current-year-end date).
fcs_firm_dataPrint_OptionbitSend to firm drawer.
federal_tinClientnvarchar (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_tinFirmnvarchar (11)This field will hold the Fed Tax ID of the firm.
federal_tinHistory_Of_Clientnvarchar (11)
feed_channel_item_enclosure_KEYFeed_Channel_Item_Enclosureint
feed_channel_item_guidFeed_Channel_Itemuniqueidentifier
feed_channel_item_KEYFeed_Channel_Itemint
feed_channel_item_KEYFeed_Channel_Item_Enclosureint
feed_channel_item_KEYFeed_Channel_Item_Staff_Readint
feed_channel_item_staff_read_KEYFeed_Channel_Item_Staff_Readint
feed_channel_KEYFeed_Channelint
feed_channel_KEYFeed_Channel_Itemint
feed_channel_KEYFeed_Portletint
feed_portlet_KEYFeed_Portletint
field_nameMonitored_Event_Actionnvarchar (128)Field in table_name that specifies entity to notify.
file_asContactnvarchar (250)Name as it appears in Outlook's "File as"
file_asHistory_Of_Contactnvarchar (250)
file_cabinet_data_location_for_new_clientsFirmnvarchar (2048)Data path of the FileCabinet in which to create a FileCabinet folder for new clients
file_countFile_Transferintnumber of files associated to this File Transfer
file_countHistory_Of_File_Transferint
file_create_linkPrint_Optionbit
file_destinationPrint_Optionnvarchar (260)The path to output reports to.
file_nameFile_Transfer_Filenvarchar (260)File name of this file
file_nameHistory_Of_File_Transfer_Filenvarchar (260)
file_output_typePrint_OptionintThe type of file format to output reports to.
file_pathReport_Imagenvarchar (260)
file_sizeFile_Transfer_EventintFile size of the file associated with this event, if any
file_sizeFile_Transfer_FileintFile size of this file
file_sizeHistory_Of_File_Transfer_Eventint
file_sizeHistory_Of_File_Transfer_Fileint
file_transfer_create_date_utcFile_Transferdatetimedate that this File Transfer was created
file_transfer_create_date_utcHistory_Of_File_Transferdatetime
file_transfer_event_KEYFile_Transfer_EventintAssigned 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_KEYHistory_Of_File_Transfer_Eventint
file_transfer_event_KEYInteractionintFile Transfer event that this Interaction was created for
file_transfer_event_type_KEYFile_Transfer_EventintType of event
file_transfer_event_type_KEYHistory_Of_File_Transfer_Eventint
file_transfer_file_KEYFile_Transfer_EventintFile associated with this event, if any
file_transfer_file_KEYFile_Transfer_Fileintunique 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_KEYHistory_Of_File_Transfer_Eventint
file_transfer_file_KEYHistory_Of_File_Transfer_Fileint
file_transfer_file_signature_status_KEYFile_Transfer_FileintStatus of the signature request for this file, if any
file_transfer_file_signature_status_KEYHistory_Of_File_Transfer_Fileint
file_transfer_file_status_KEYFile_Transfer_FileintStatus of this File
file_transfer_file_status_KEYHistory_Of_File_Transfer_Fileint
file_transfer_KEYFile_Transferintunique 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_KEYFile_Transfer_EventintFile Transfer that this file is a part of
file_transfer_KEYFile_Transfer_FileintFile Transfer that this file is a part of
file_transfer_KEYHistory_Of_File_Transferint
file_transfer_KEYHistory_Of_File_Transfer_Eventint
file_transfer_KEYHistory_Of_File_Transfer_Fileint
file_transfer_status_KEYFile_Transferintcurrent status of this File Transfer
file_transfer_status_KEYHistory_Of_File_Transferint
file_transfer_type_KEYFile_TransferintThe type of File Transfer
file_transfer_type_KEYHistory_Of_File_Transferint
filter_base_type_KEYFilter_Base_TypeintDatabase assigned primary key for this table.
filter_base_type_KEYFilter_LineintWhat this line is based on.
filter_by_dashboard_contextReport_Based_Portletbit
filter_columnFilter_Base_Typenvarchar (512)Name of the property in Filter_Type.list_name that values will be compared to.
filter_KEYActive_FilterintKey to the Filter being used for this Staff and description.
filter_KEYFilterintAUTO-INCREMENT: Database assigned primary key for this table.
filter_KEYFilter_LineintKey to the Filter that this Line is for.
filter_KEYOutlook_Contact_Synchronization_FolderintReference to a Contact filter used to define which Contacts to send to Outlook? as part of the synchronization.
filter_line_KEYFilter_LineintAUTO-INCREMENT: Database assigned primary key for this table.
filter_line_KEYFilter_SelectintKey of the Filter Line this value is for.
filter_line_type_KEYFilter_Base_TypeintKey to the type of criteria that this Filter Base Type uses.
filter_line_type_KEYFilter_Line_TypeintDatabase assigned primary key for this table.
filter_line_type_KEYFilter_Range_TypeintKey to the Filter Line Type this Range Type belongs to.
filter_range_type_KEYFilter_LineintIf the method is Range, Key to a valid range for this base; otherwise null.
filter_range_type_KEYFilter_Range_TypeintDatabase assigned primary key for this table.
filter_select_KEYFilter_SelectintAUTO-INCREMENT: Database assigned primary key for this table.
filter_type_KEYFilterintKey to a Filter Type record.
filter_type_KEYFilter_Base_TypeintKey to the Filter Type that this Filter Base Type belongs to.
filter_type_KEYFilter_TypeintPrimary key for this table.
financial_valueClient_Financial_Datadecimal (25, 6)Whole percentages or whole dollar amounts
financial_valueHistory_Of_Client_Financial_Datadecimal (25, 6)
financial_value_formatClient_Financial_Data_Descriptionnvarchar (100)description of the format
financial_value_formatHistory_Of_Client_Financial_Data_Descriptionnvarchar (100)
firm_aliasFirmnvarchar (50)
firm_dashboard_layoutUser_Preferencenvarchar (-1)Layout of the Firm Dashboard stored as XML
firm_dashboard_layout_KEYFirm_Dashboard_LayoutintArtificial key column created to make this table more compatible with the DAL.
firm_date_KEYFirm_DateintAUTO-INCREMENT: Database assigned primary key for this table.
firm_date_type_KEYFirm_DateintKey to a Firm Date Type row (1=Year, 2=Period).
firm_date_type_KEYFirm_Date_TypeintDatabase assigned primary key for this table.
firm_idHistory_Of_Portal_Userint
firm_idPortal_UserintThe firm id in the license file at the time this record was last modified.
firm_KEYFirmintDatabase assigned primary key for this table.
firm_KEYFirm_Dashboard_LayoutintKey to the Firm that these preferences are for.
firm_KEYGL_Entry_Export_Optionint
firm_KEYOutlook_Index_Folder_FirmintA reference to one of the Firm rows.
firm_shortcut_group_KEYFirm_ShortcutintAssociates this solution with its solution group.
firm_shortcut_group_KEYFirm_Shortcut_GroupintAssigned by COMMON_dp_Allocate_Unique_Identifiers. Database assigned primary key for this table
firm_shortcut_KEYFirm_ShortcutintAssigned by COMMON_dp_Allocate_Unique_Identifiers. Database assigned primary key for this table
first_nameHistory_Of_Portal_Usernvarchar (70)
first_namePortal_Usernvarchar (70)first name of person associated with this portal
first_nameStaffnvarchar (30)The first name of this Staff.
fiscal_year_endIntegration_InvoicesmalldatetimeFYE as defined by the exporting applciation.
fiscal_year_end_monthClientintEnd month of the client's fiscal year end.
fiscal_year_end_monthHistory_Of_Clientint
fixed_rateEngagementdecimal (9, 2)Rate to use when rate_type_KEY=3
fixed_rateHistory_Of_Engagementdecimal (9, 2)
folder_idGofileroom_Workflownvarchar (10)One of four required fields that uniquely identify a workflow, not intended to be viewed by users.
formulaCustom_Formulanvarchar (-1)The custom formula.
from__ledger_entry_KEYBilling_Decision_CollectionintIndicates 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_KEYBilling_Decision_Tax_CollectionintIndicates 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_KEYLedger_Entry_ApplicationintThe Ledger Entry that amount_applied is subtracted from.
from_valueFilter_Linenvarchar (100)The lesser of the two values.
generate_assigned_from_projectHistory_Of_Schedule_Item_Seriesbit
generate_assigned_from_projectSchedule_Item_SeriesbitWhen set to 1 will indicate that next project generation should use the assigned from the project instead of the template.
generate_assigned_from_taskHistory_Of_Schedule_Item_Seriesbit
generate_assigned_from_taskSchedule_Item_SeriesbitWhen set to 1 will indicate that next project generation should use the assigned from the task instead of the template.
generate_budgeted_amount_factorHistory_Of_Schedule_Item_Seriesdecimal (6, 4)
generate_budgeted_amount_factorSchedule_Item_Seriesdecimal (6, 4)Factor to be used to adjust the amount when generating from the project.
generate_budgeted_hours_factorHistory_Of_Schedule_Item_Seriesdecimal (6, 4)
generate_budgeted_hours_factorSchedule_Item_Seriesdecimal (6, 4)Factor to be used to adjust the hours when generating from the project.
generate_calendar_entries_from_projectHistory_Of_Schedule_Item_Seriesbit
generate_calendar_entries_from_projectSchedule_Item_SeriesbitWhen set to 1 will indicate that next project generation should copy the calendar entries from the prior project.
generate_calendar_entries_from_taskHistory_Of_Schedule_Item_Seriesbit
generate_calendar_entries_from_taskSchedule_Item_SeriesbitWhen set to 1 will indicate that next project generation should copy the calendar entries from the prior task.
generate_custom_values_from_projectHistory_Of_Schedule_Item_Seriesbit
generate_custom_values_from_projectSchedule_Item_SeriesbitWhen set to 1 will indicate that next project generation should copy custom val
generate_custom_values_from_taskHistory_Of_Schedule_Item_Seriesbit
generate_custom_values_from_taskSchedule_Item_SeriesbitWhen set to 1 will indicate that next project generation should copy custom val
generate_descriptions_from_projectHistory_Of_Schedule_Item_Seriesbit
generate_descriptions_from_projectSchedule_Item_SeriesbitWhen set to 1 will indicate that next project generation should use the descriptions from the project instead of the template.
generate_descriptions_from_taskHistory_Of_Schedule_Item_Seriesbit
generate_descriptions_from_taskSchedule_Item_SeriesbitWhen set to 1 will indicate that next project generation should use the descriptions from the task instead of the template.
generate_engagement_from_projectHistory_Of_Schedule_Item_Seriesbit
generate_engagement_from_projectSchedule_Item_SeriesbitWhen set to 1 will indicate that next project generation should use the engagement from the project instead of the template.
generate_groupings_from_projectHistory_Of_Schedule_Item_Seriesbit
generate_groupings_from_projectSchedule_Item_SeriesbitWhen set to 1 will indicate that next project generation should use the groupings from the project instead of the template.
generate_links_from_projectHistory_Of_Schedule_Item_Seriesbit
generate_links_from_projectSchedule_Item_SeriesbitWhen set to 1 will indicate that next project generation should use the links from the project instead of the template.
generate_links_from_taskHistory_Of_Schedule_Item_Seriesbit
generate_links_from_taskSchedule_Item_SeriesbitWhen set to 1 will indicate that next project generation should use the links from the task instead of the template.
generate_notes_from_projectHistory_Of_Schedule_Item_Seriesbit
generate_notes_from_projectSchedule_Item_SeriesbitWhen set to 1 will indicate that next project generation should use the notes from the project instead of the template.
generate_notes_from_taskHistory_Of_Schedule_Item_Seriesbit
generate_notes_from_taskSchedule_Item_SeriesbitWhen set to 1 will indicate that next project generation should use the notes from the task instead of the template.
generate_tasks_from_projectHistory_Of_Schedule_Item_Seriesbit
generate_tasks_from_projectSchedule_Item_SeriesbitWhen 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_endHistory_Of_Schedule_Item_Seriesbit
generation_date_based_on_fiscal_year_endSchedule_Item_SeriesbitWhen the value is 1 the generation date is adjusted for the Client's fiscal year end.
generation_date_must_occur_on_weekdaysHistory_Of_Schedule_Item_Seriesbit
generation_date_must_occur_on_weekdaysSchedule_Item_SeriesbitWhen the value is 1 the generation date is adjusted so that it does not fall on a weekend.
generation_dayHistory_Of_Schedule_Item_Seriesint
generation_dayProject_Template_Definitionint
generation_daySchedule_Item_SeriesintNumber of days before the next date to generate the project.
generation_monthHistory_Of_Schedule_Item_Seriesint
generation_monthProject_Template_Definitionint
generation_monthSchedule_Item_SeriesintNumber of months before the next date to generate the project.
gl_accountActivitynvarchar (60)Defines the GL Account to which this activity will be exported.
gl_accountEngagementnvarchar (60)Defines the GL Account to which this engagement will be exported.
gl_accountHistory_Of_Engagementnvarchar (60)
gl_accountTaxing_Authoritynvarchar (60)General Ledger account number used in CSA
gl_entry_export_accounting_method_KEYGL_Entry_Export_Optionint
gl_entry_export_option_KEYGL_Entry_Export_Optionint
gl_entry_export_tax_basis_KEYGL_Entry_Export_Optionint
gl_entry_export_type_KEYGL_Entry_Export_Typeint
gofileroom_configurationFirmnvarchar (-1)Contains GoFileRoom integration configuration data in an xml format.
gofileroom_create_linkPrint_Optionbit
gofileroom_output_typePrint_OptionintThe type of file format to export to GoFileRoom.
gofileroom_workflow_KEYGofileroom_WorkflowintAssigned by COMMON_dp_Allocate_Unique_Identifiers. Primary key for this table.
gofileroom_workflow_KEYHistory_Of_Projectint
gofileroom_workflow_KEYProjectintGoFileRoom Workflow associated with this Project.
grace_daysService_ChargeintNumber of days after the due date the client is given until service charges begin calculating.
hash_codeReport_Imagevarchar (40)40-character hexadecimal-formatted string from the SHA-1 hash of the image for faster look-up.
hide_columnUser_Preference_Custom_Field_ColumnbitWhether or not this field should be hidden in Time and expense entry
hide_description_columnUser_Preference_Custom_Field_ColumnbitWhether or not the description column related to this field should be hidden in Time and expense entry
hierarchyPrivilegenvarchar (450)Calculated by the database to allow privileges to be sorted quickly in tree structure.
history_action_KEYHistory_Actiontinyint (3)Primary key of a history action.
history_action_KEYHistory_Of_Additional_Contacttinyint (3)
history_action_KEYHistory_Of_Attachmenttinyint (3)
history_action_KEYHistory_Of_Attachment_Contenttinyint (3)
history_action_KEYHistory_Of_Calendar_Categorytinyint (3)
history_action_KEYHistory_Of_Clienttinyint (3)
history_action_KEYHistory_Of_Client_Financial_Datatinyint (3)
history_action_KEYHistory_Of_Client_Financial_Data_Descriptiontinyint (3)
history_action_KEYHistory_Of_Client_Staff_Groupingtinyint (3)
history_action_KEYHistory_Of_Contacttinyint (3)
history_action_KEYHistory_Of_Contact_Addresstinyint (3)
history_action_KEYHistory_Of_Contact_Categorytinyint (3)
history_action_KEYHistory_Of_Contact_Contact_Categorytinyint (3)
history_action_KEYHistory_Of_Contact_Emailtinyint (3)
history_action_KEYHistory_Of_Contact_Phonetinyint (3)
history_action_KEYHistory_Of_Custom_Charttinyint (3)
history_action_KEYHistory_Of_Custom_Fieldtinyint (3)
history_action_KEYHistory_Of_Custom_Valuetinyint (3)
history_action_KEYHistory_Of_Digita_Vat_Periodtinyint (3)
history_action_KEYHistory_Of_Engagementtinyint (3)
history_action_KEYHistory_Of_File_Transfertinyint (3)
history_action_KEYHistory_Of_File_Transfer_Eventtinyint (3)
history_action_KEYHistory_Of_File_Transfer_Filetinyint (3)
history_action_KEYHistory_Of_Linktinyint (3)
history_action_KEYHistory_Of_Link_Grouptinyint (3)
history_action_KEYHistory_Of_Portal_Usertinyint (3)
history_action_KEYHistory_Of_Projecttinyint (3)
history_action_KEYHistory_Of_Project_Extensiontinyint (3)
history_action_KEYHistory_Of_Schedule_Entrytinyint (3)
history_action_KEYHistory_Of_Schedule_Itemtinyint (3)
history_action_KEYHistory_Of_Schedule_Item_Assignmenttinyint (3)
history_action_KEYHistory_Of_Schedule_Item_Budget_Remaining_Entrytinyint (3)
history_action_KEYHistory_Of_Schedule_Item_Seriestinyint (3)
history_action_KEYHistory_Of_Sheet_Entrytinyint (3)
history_action_KEYHistory_Of_Tagtinyint (3)
history_action_KEYHistory_Of_Tagged_Itemtinyint (3)
history_action_KEYHistory_Of_Tasktinyint (3)
history_action_KEYHistory_Of_Time_Zonetinyint (3)
history_action_KEYHistory_Of_Timertinyint (3)
holiday_dateObserved_HolidaysmalldatetimeThe date that this entry corresponds to.
home_dashboard_layoutUser_Preferencenvarchar (-1)Layout of the Home Dashboard stored as XML
host_nameChangesetnvarchar (128)The host (computer) if known. Should be as close to the user as possible.
host_nameUpdate_Data_Version_Historynvarchar (50)
host_nameUser_Session_Patternnvarchar (50)
hourly_costStaff_Rate_Tabledecimal (9, 2)The cost per hour.
hoursHistory_Of_Schedule_Item_Budget_Remaining_Entrydecimal (9, 2)
hoursSchedule_Item_Budget_Remaining_Entrydecimal (9, 2)The number of hours this entry is adjusting the remaining hours value.
hoursStaff_Benefit_Entrydecimal (9, 2)The number of hours included in this entry.
hours_enteredStaff_Benefit_Entrydecimal (9, 2)The number of hours entered included in this entry.
import_as__contact_type_KEYOutlook_Contact_Synchronization_ProfileintDetermines what type of contact is created in the database for contacts imported from Outlook?.
index_emailFirmbitTrue to index email
individual_date_of_birthClientsmalldatetimeDate of birth of the client if the client is an individual
individual_date_of_birthHistory_Of_Clientsmalldatetime
individual_first_nameClientnvarchar (100)First name of the client if the client is an individual.
individual_first_nameHistory_Of_Clientnvarchar (100)
individual_last_nameClientnvarchar (100)Last name of the client if the client is an individual.
individual_last_nameHistory_Of_Clientnvarchar (100)
industry_codeClientnvarchar (6)Industry code.
industry_codeHistory_Of_Clientnvarchar (6)
instructorHistory_Of_Schedule_Itemnvarchar (250)
instructorSchedule_Itemnvarchar (250)
integration_application__descriptionIntegration_Sheet_Entrynvarchar (-1)The string description of the source application for this entry.
integration_application_KEYClient_Financial_DataintThe application that provided this data
integration_application_KEYHistory_Of_Client_Financial_Dataint
integration_application_KEYHistory_Of_Sheet_Entryint
integration_application_KEYIntegration_ApplicationintAUTO-INCREMENT: Database assigned primary key for this table
integration_application_KEYIntegration_InvoiceintKey to a record in Integration_Application indicating which application exported this data.
integration_application_KEYInteractionint
integration_application_KEYSheet_EntryintKey to the Integration Application table to denote the source application for this entry.
integration_application_KEYStatus_EventintKey to one of the records in the Integration_Application table.
integration_application_nameHistory_Of_Timernvarchar (30)
integration_application_nameTimernvarchar (30)Identifies the application integration application name that is using the timer (if any)
integration_application_yearClient_Financial_DataintThe version year of the application that provided this data
integration_application_yearHistory_Of_Client_Financial_Dataint
integration_custom_value_KEYIntegration_Custom_Valueint
integration_date_utcIntegration_InvoicedatetimeDate the data was exported from the remote application, in UTC.
integration_invoice_KEYIntegration_InvoiceintAUTO-INCREMENT: Database assigned primary key for this table
integration_invoice_KEYIntegration_Invoice_Prior_PaymentintKey of the Integration Invoice record that this payment info applies to.
integration_invoice_prior_payment_KEYIntegration_Invoice_Prior_PaymentintAUTO-INCREMENT: Database assigned primary key for this table
integration_sheet_entry_KEYIntegration_Sheet_EntryintAssigned by COMMON_dp_Allocate_Unique_Identifiers. Database assigned primary key for this table.
interaction_association_KEYInteraction_Associationtinyint (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_KEYInteraction_Contacttinyint (3)
interaction_KEYInteractionintAssigned by COMMON_dp_Allocate_Unique_Identifiers. A unique value assigned to this row so that linking to this row uses only 4 bytes.
interaction_KEYInteraction_ContactintA reference to one of the Interaction rows.
interaction_KEYInteraction_Email_AddressintA reference to one of the Interaction rows.
interaction_KEYInteraction_LinkintKey to the interaction that this link links to
interaction_KEYInteraction_Phone_NumberintA reference to one of the Interaction rows.
interaction_KEYOutlook_ItemintA reference to exactly one of the Interaction rows.
interaction_subtype_KEYInteractiontinyint (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_KEYInteraction_Subtypetinyint (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_KEYInteraction_SubtypeintThe granular interaction type that this subtype applies to.
internal_commentsLedger_Entrynvarchar (-1)Comments about this item that are internal to the firm.
invoice__report_definition_KEYClientintKey to an Invoice Report Definition record.
invoice__report_definition_KEYFirmintDefault invoice format for new clients.
invoice__report_definition_KEYHistory_Of_Clientint
invoice_dateIntegration_InvoicesmalldatetimeDate of the invoice.
invoice_email_bodyFirmnvarchar (-1)
invoice_email_subjectFirmnvarchar (255)
invoice_formatInvoicenvarchar (-1)The uncompressed invoice format containing a copy of the invoice Report Definition and composed field values.
invoice_format_compressedInvoicevarbinary (-1)The compressed invoice format containing a copy of the invoice Report Definition and composed field values.
invoice_format_storage_style_KEYInvoiceintKey of the Invoice Format Storage Style that indicates how the invoice format is stored.
invoice_KEYBilling_DecisionintThe Invoice this billing apears on.
invoice_KEYIntegration_InvoiceintKey to the Invoice record created for this exported invoice.
invoice_KEYInvoiceintDatabase assigned primary key for this table
invoice_KEYReport_Definition_Update_Listint
invoice_numberIntegration_Invoicenvarchar (30)Invoice number as it is in the exporting application.
invoice_reference_number_layoutFirmnvarchar (-1)The XML layout for an invoice reference number.
invoicedBilling_Decisiondecimal (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.
invoicedClient_Date_Cachedecimal (9, 2)invoiced sum for the Client, principal Client, and entry date
ip_addressFile_Transfer_Eventvarchar (39)IP Address of machine that triggered this event
ip_addressHistory_Of_File_Transfer_Eventvarchar (39)
is_all_day_eventHistory_Of_Schedule_Itembit
is_all_day_eventSchedule_ItembitWhen 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_eventSchedule_Item_Date_Indexbit
IS_AUTO_NUMCOMMON_Metadata_About_Columnsbit
is_cash_basisDigita_Vat_PeriodbitIndicate whether the VAT period is reported using a cach or accrual basis.
is_cash_basisHistory_Of_Digita_Vat_Periodbit
is_closedDigita_Vat_PeriodbitIndicates whether the period is open or closed.
is_closedHistory_Of_Digita_Vat_Periodbit
is_defaultEngagement_TemplatebitWhether or not this engagement will be used as a default for new clients that are entered.
is_method_allFilter_LinebitTrue when the method is All, false otherwise.
IS_NULLABLECOMMON_Metadata_About_Columnsbit
is_openHistory_Of_Schedule_Itembit
is_openSchedule_ItembitFalse 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_assignmentHistory_Of_Schedule_Item_Assignmentbit
is_primary_assignmentProject_Template_AssignmentbitExactly one record per [project_template_KEY] should be set to true.
is_primary_assignmentSchedule_Item_AssignmentbitExactly one record per [schedule_item_KEY] should be set to true.
is_primary_assignmentTask_Template_AssignmentbitExactly one record per [task_template_KEY] should be set to true.
IS_PRIMARY_KEYCOMMON_Metadata_About_Keysbit
is_system_eventRecorded_EventbitIndicates whether this is a system level event and therefore not to be displayed to users.
items_to_keepFeed_Channelint
labelFile_Transfer_Eventnvarchar (260)Label for this event, as provided by Portal server
labelHistory_Of_File_Transfer_Eventnvarchar (260)
label__report_definition_KEYPrint_OptionintThe label format to use when printing labels.
label_printer_namePrint_Optionnvarchar (260)Printer name to print labels to.
last_access_dateUser_SessiondatetimeDate and time this session was last active in UTC.
last_check_dateMonitored_Eventdatetime
last_check_stateMonitored_Eventnvarchar (-1)XML blob with context-specific state information for state transition comparisons.
last_modification_dateHistory_Of_Portal_Userdatetime
last_modification_datePortal_Userdatetimetime at which the portal server last updated this portal data
last_modification_timeOutlook_ItemdatetimeThe value of the LastModificationTime property from Outlook(R).
last_nameHistory_Of_Portal_Usernvarchar (256)
last_namePortal_Usernvarchar (256)last name of person associated with this portal
last_nameStaffnvarchar (30)The last name of this Staff.
layoutDashboard_Layoutnvarchar (-1)User defined dashboard layout
leafPrivilegetinyint (3)1 if this is a privilege and 0 if it is a privilege folder.
ledger_entry_application_KEYLedger_Entry_ApplicationintAUTO-INCREMENT: Database assigned primary key for this table
ledger_entry_KEYBilling_DecisionintThe Invoice this billing apears on (same as invoice_KEY column of Billing_Decision.)
ledger_entry_KEYBilling_Decision_CollectionintThe combination of ledger_entry_KEY and sheet_entry_KEY identifies the billing decision this collection is for.
ledger_entry_KEYBilling_Decision_Tax_CollectionintThe combination of ledger_entry_KEY, sheet_entry_KEY and taxing_authority_KEY identifies the BDTA row this collection is for.
ledger_entry_KEYBilling_Decision_Taxing_AuthorityintThe combination of ledger_entry_KEY and sheet_entry_KEY identifies the Billing_Decision row this tax is charged for.
ledger_entry_KEYInvoiceint
ledger_entry_KEYInvoice_OfficeintKey of the Ledger Entry.
ledger_entry_KEYLedger_EntryintAssigned by COMMON_dp_Allocate_Unique_Identifiers. Database assigned primary key for this table
ledger_entry_KEYLedger_Entry_SubmittalintThe ledger entry this submittal applies to.
ledger_entry_KEYLedger_Entry_Submittal_ResultintThe ledger entry this submittal applies to.
ledger_entry_KEYOnline_InvoiceintPrimary key for this row and the key of the associated Invoice.
ledger_entry_KEYOnline_PaymentintPrimary key for this row and the key of the associated Payment.
ledger_entry_service_charge_KEYLedger_Entry_Service_ChargeintAUTO-INCREMENT: Database assigned primary key for this table
ledger_entry_subtype_KEYLedger_EntryintThe subtype of this Ledger Entry.
ledger_entry_subtype_KEYLedger_Entry_SubtypeintA 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_idLedger_Entry_Typenvarchar (250)User defined identifier (unique).
ledger_entry_type_id_sortableLedger_Entry_Typevarchar (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_KEYLedger_EntryintThe type of this Ledger Entry.
ledger_entry_type_KEYLedger_Entry_SubtypeintThe granular ledger entry type that this subtype applies to.
ledger_entry_type_KEYLedger_Entry_TypeintDatabase assigned primary key for this table.
lengthCustom_FieldintLength of character columns, precision of number columns, storage length of other types.
lengthHistory_Of_Custom_Fieldint
letter__report_definition_KEYPrint_OptionintThe letter format to use when printing letters.
license__report_definition_guidReport_DefinitionuniqueidentifierUnique id for licensing purposes.
license__report_definition_guidReport_Definition_Privilege_DependencyuniqueidentifierUnique id for licensing purposes.
linkFeed_Channelnvarchar (-1)
link_group_KEYHistory_Of_Linkint
link_group_KEYHistory_Of_Link_Groupint
link_group_KEYLinkintParent group of this link
link_group_KEYLink_GroupintAssigned by COMMON_dp_Allocate_Unique_Identifiers. Database assigned primary key for this table
link_KEYHistory_Of_Linkint
link_KEYInteraction_LinkintPrimary key, and key to parent table
link_KEYLinkintAssigned by COMMON_dp_Allocate_Unique_Identifiers. Primary key of this table
link_type_KEYHistory_Of_Linkint
link_type_KEYLinkintType of link this is
list_nameFilter_Typenvarchar (128)Name of the list that this type of filter limits.
live_actual_amountHistory_Of_Schedule_Itemdecimal (17, 2)
live_actual_amountSchedule_Itemdecimal (17, 2)Cached value of the amount on all Sheet_Entry rows associated with this row.
live_actual_hoursHistory_Of_Schedule_Itemdecimal (17, 2)
live_actual_hoursSchedule_Itemdecimal (17, 2)Cached value of the hours on all Sheet_Entry rows associated with this row.
localeOption_Listnvarchar (128)
locationHistory_Of_Schedule_Itemnvarchar (250)
locationSchedule_Itemnvarchar (250)
loginHistory_Of_Portal_Usernvarchar (150)
loginLegacy_Contact_Portal_Mappingnvarchar (50)Unique but mutable login name
loginPortal_Usernvarchar (150)unique but mutable login name
login_dateUser_SessiondatetimeThe date and time the session was opened in UTC.
logout_dateUser_SessiondatetimeThe date and time that the user logged out, or that the session was deemed expired or killed, in UTC.
long_descriptionActivitynvarchar (-1)Long user defined description
long_descriptionActivity_Categorynvarchar (-1)
long_descriptionEngagementnvarchar (-1)Long user defined description
long_descriptionEngagement_Typenvarchar (-1)
long_descriptionHistory_Of_Engagementnvarchar (-1)
long_descriptionHistory_Of_Projectnvarchar (-1)
long_descriptionProjectnvarchar (-1)Long description to use on invoices.
long_descriptionProject_Templatenvarchar (-1)Long description to use on invoices.
long_descriptionProject_Template_Definitionnvarchar (-1)Long description to use on invoices.
long_descriptionReport_Definitionnvarchar (-1)Long description of report.
long_descriptionStandard_Textnvarchar (-1)Text to use as a standard comment
lookup_display_memberFilter_Range_Typenvarchar (128)Name of the property in the lookup list that has the value that should be used for the range criteria.
lookup_list_nameFilter_Line_Typenvarchar (128)Name of the list that provides data for this type of criteria or an empty string.
lookup_table_nameMonitored_Event_Actionnvarchar (128)Table that specifies entity to notify.
lookup_value_memberFilter_Line_Typenvarchar (128)Name of the property in the lookup list to compare to Filter_Base_Type.filter_column or an empty string.
lost_reason_KEYClientintKey to a Lost Reason record.
lost_reason_KEYHistory_Of_Clientint
lost_reason_KEYLost_ReasonintAUTO-INCREMENT: Database assigned primary key for this table.
lost_to_KEYClientintKey to a Lost To record.
lost_to_KEYHistory_Of_Clientint
lost_to_KEYLost_TointAUTO-INCREMENT: Database assigned primary key for this table.
lower_date_inclusiveClient_Staff_Groupingsmalldatetime
lower_date_inclusiveHistory_Of_Client_Staff_Groupingsmalldatetime
lower_date_inclusiveStaff_Target_RangesmalldatetimeREDUNDANT: 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_utcSchedule_Item_Date_Indexdatetime
mailing__contact_address_type_KEYContactintIndicates which address type is the mailing address.
mailing__contact_address_type_KEYHistory_Of_Contactint
manager__staff_grouping_type_KEYEngagement_TemplateintKey to a Staff Grouping Type that indicates how to determine which staff will be assigned to generated engagements.
manager__staff_KEYClientintKey to a Staff record.
manager__staff_KEYEngagementintKey to a Staff record.
manager__staff_KEYHistory_Of_Clientint
manager__staff_KEYHistory_Of_Engagementint
markup_factorEngagementdecimal (6, 4)Multiplied by the extension amount so work can be marked up or down.
markup_factorHistory_Of_Engagementdecimal (6, 4)
match_allFilterbitUse AND logic when true, OR logic when false.
maximum_carryoverBenefitdecimal (9, 2)The maximum amount allowed to carryover annually.
maximum_chargeService_Chargedecimal (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_nameStaffnvarchar (30)The middle name of this Staff.
minimum_balanceService_Chargedecimal (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_chargeService_Chargedecimal (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_liveFeed_Channelint
mobilecs_enabledHistory_Of_Portal_Userbit
mobilecs_enabledLegacy_Contact_Portal_MappingbitWhether mobilecs is enabled if this mapping was a netstaff
mobilecs_enabledPortal_Userbitwhether or not this portal is authorized for mobile cs
monitored_event_action_KEYMonitored_Event_ActionintAUTO-INCREMENT: Database assigned primary key for this table
monitored_event_KEYMonitored_EventintAUTO-INCREMENT: Database assigned key for this table
monitored_event_KEYMonitored_Event_ActionintKey to parent record.
month_info_idMonth_Infonvarchar (11)The same value as month_info_KEY as a string (1 for January, 12 for December.)
month_info_id_sortableMonth_Infonvarchar (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_KEYMonth_InfointThe number of the month (1 for January, 12 for December.)
must_change_passwordPractice_Userbit
nameContactnvarchar (250)Name of the contact.
nameHistory_Of_Contactnvarchar (250)
nameLast_Table_Modificationnvarchar (128)
nameTable_Informationnvarchar (128)Name of the table.
name_1Clientnvarchar (250)Name of company if the client type is a non-individual, otherwise it is the display name for the client.
name_1Firmnvarchar (250)
name_1History_Of_Clientnvarchar (250)
name_2Clientnvarchar (250)Only shown on the UI for non-individual clients
name_2Firmnvarchar (250)
name_2History_Of_Clientnvarchar (250)
negative_invoicedInvoicedecimal (17, 2)Sum of Billing_Decision.invoiced for this invoice where Billing_Decision.invoiced < 0.
negative_nonprogress_invoicedInvoicedecimal (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_invoicedInvoicedecimal (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_idLegacy_Contact_Portal_MappingintUnique and immutable primary key of the staff portal
next_check_dateMonitored_EventdatetimeDate by which this event must be checked (if polled).
next_generation_dateSchedule_Item_Generation_DatedatetimeThe date that the next project generation to be performed (in UTC).
next_valueCOMMON_Unique_Identifier_Counterint
nonbillable_live_open_amountSheet_Entry_Open_Value_Cachedecimal (17, 2)The nonbillable live open amount for the Sheet_Entry row.
nonbillable_live_open_unitsSheet_Entry_Open_Value_Cachedecimal (9, 2)The nonbillable live open units for the Sheet_Entry row.
nonprogress_bill_amountClient_Date_Cachedecimal (9, 2)nonprogress_bill_amount sum for the Client, principal Client, and entry date
normal_signGL_Entry_Export_Typedecimal (1)
normal_signLedger_Entry_Typedecimal (1)Debit (1) or Credit (-1).
number_of_copiesPrint_OptionintNumber of copies to print.
observed_holiday_KEYObserved_HolidayintAssigned by COMMON_dp_Allocate_Unique_Identifiers. Primary key for this table.
of__contact_KEYFile_Transferintcontact that contact__contact_KEY is of
of__contact_KEYHistory_Of_File_Transferint
of__contact_KEYHistory_Of_Schedule_Itemint
of__contact_KEYSchedule_ItemintFor 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_KEYEngagement_TemplateintKey to a Office Grouping Type that indicates how to determine which office will be assigned to generated engagements.
office_idOfficenvarchar (11)User defined identifier (unique).
office_id_sortableOfficevarchar (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_KEYClientintKey to an Office record.
office_KEYEngagementintKey to an Office record.
office_KEYFirmintKey from the main office.
office_KEYHistory_Of_Clientint
office_KEYHistory_Of_Engagementint
office_KEYInvoice_OfficeintKey of the Office of the Staff who billed this invoice.
office_KEYOfficeintAssigned by COMMON_dp_Allocate_Unique_Identifiers. Database assigned primary key for this table.
office_KEYStaffintKey from one of the already set up Offices.
ON_INSERTCOMMON_Metadata_About_Columnsvarchar (10)
online_bill_pay_enabledFirmbitDetermines whether invoices can be sent to the online bill pay service.
online_bill_pay_enabledHistory_Of_Portal_Userbit
online_bill_pay_enabledPortal_Userbitwhether or not this portal is authorized for online bill pay
online_invoice_guidOnline_InvoiceuniqueidentifierA unique value that is used to identify this invoice on the portal and in online payments.
online_payment_guidOnline_PaymentuniqueidentifierA unique value that is used to identify this payment on the portal and in online payments.
onvio_documents__client_KEYPrint_OptionintThe client whose folder reports will be output to.
onvio_documents_create_linkPrint_Optionbit
onvio_documents_file_by_typePrint_OptionintHow to file a report (e.g., by the firm's current-year-end date).
onvio_documents_firm_dataPrint_OptionbitSend to firm documents.
onvio_documents_output_typePrint_OptionintThe type of file format to export to Onvio Documents.
option_valueOption_Listint
order_numberLedger_Entry_Submittalnvarchar (40)Unique order number assigned by the program
ORDINAL_POSITIONCOMMON_Metadata_About_Foreign_Keysint
ordinal_positionReport_Profile_Report_DefinitionintThe order of the reports in the profile.
original_due_dateHistory_Of_Projectsmalldatetime
original_due_dateHistory_Of_Project_Extensionsmalldatetime
original_due_dateProjectsmalldatetimeThe original due date of the project; readonly once the record is created.
original_due_dateProject_ExtensionsmalldatetimeThe original due date of the project extension; readonly once the record is created.
original_publication_dateFeed_Channel_Itemdatetime
outlook_contact_synchronization_folder_KEYOutlook_Contact_Synchronization_FolderintAssigned by COMMON_dp_Allocate_Unique_Identifiers. Program assigned primary key for this table.
outlook_contact_synchronization_profile_KEYOutlook_Contact_Synchronization_FolderintReference to the contact synchronization profile this folder is for.
outlook_contact_synchronization_profile_KEYOutlook_Contact_Synchronization_ProfileintAssigned by COMMON_dp_Allocate_Unique_Identifiers. Program assigned primary key for this table.
outlook_index_folder_firm_KEYOutlook_Index_Folder_FirmintAssigned 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_guidOutlook_ItemuniqueidentifierThe value of a custom property that has been added to the Outlook(R) item.
outlook_store_KEYOutlook_Contact_Synchronization_FolderintA reference to one of the Outlook_Store rows that has the binary value of the Outlook? StoreID of this item.
outlook_store_KEYOutlook_Index_Folder_FirmintA reference to one of the Outlook_Store rows that has the binary value of the Outlook(R) StoreID of this item.
outlook_store_KEYOutlook_ItemintA reference to one of the Outlook_Store rows that has the binary value of the Outlook(R) StoreID of this item.
outlook_store_KEYOutlook_StoreintAssigned 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_printerPrint_OptionbitOutput labels to printer.
output_letters_to_printerPrint_OptionbitOutput letters to printer.
output_to_emailPrint_OptionbitOutput reports to email.
output_to_fcsPrint_OptionbitOutput reports to FileCabinet Solution.
output_to_filePrint_OptionbitOutput reports to file.
output_to_gofileroomPrint_OptionbitDetermines if output will be sent to GoFileRoom
output_to_online_bill_payPrint_OptionbitOutput reports to Online Bill Pay.
output_to_onvio_documentsPrint_OptionbitDetermines if output will be sent to Onvio Documents.
output_to_printerPrint_OptionbitOutput reports to printer.
owner_table_nameCustom_Chartnvarchar (128)Name of the table that this custom chart is associated with.
owner_table_nameCustom_Formulanvarchar (128)Name of the table that this custom formula is associated with.
owner_table_nameHistory_Of_Custom_Chartnvarchar (128)
PARAMETER_NAMECOMMON_Metadata_About_Sprocsnvarchar (128)
parent__contact_KEYAdditional_ContactintKey to the parent contact record.
parent__contact_KEYHistory_Of_Additional_Contactint
parent__privilege_KEYPrivilegeintForeign key to the parent of this Privilege.
parent__report_definition_KEYReport_DefinitionintKey of the Report Definition that this row is assigned
password_hashPractice_Usernvarchar (28)Specifies whether the user must change the password at the next logon.
past_due__ledger_entry_KEYLedger_Entry_Service_ChargeintKey to a Ledger Entry that was past due and was charged a fee.
payment_amountIntegration_Invoice_Prior_Paymentdecimal (17, 2)Amount of the payment
payment_dateIntegration_Invoice_Prior_PaymentsmalldatetimeDate of the payment
percent_completeHistory_Of_Projectdecimal (3, 2)
percent_completeProjectdecimal (3, 2)Percent complete as a decimal (0 to 1.00).
percent_complete_is_overriddenHistory_Of_Projectbit
percent_complete_is_overriddenProjectbit
period_begin_dateFirmsmalldatetime
period_endGofileroom_Workflownvarchar (255)GoFileRoom period end date part of this workflow.
period_end_dateFirmsmalldatetime
person_in_chargeGofileroom_Workflownvarchar (100)GoFileRoom name of the person in charge of this workflow.
phoneContact_Phonenvarchar (30)Phone number.
phoneHistory_Of_Contact_Phonenvarchar (30)
phone_numberInteraction_Phone_Numbernvarchar (30)Phone number.
phone_number_formatFirmnvarchar (30)
phone_positionContactnvarchar (14)Semicolon seperated list of contact_phone_type_KEY values indicating the user's preferred order of phone numbers.
phone_positionHistory_Of_Contactnvarchar (14)
photographStaffvarbinary (-1)The contents of a image file for the staff's photograph.
pluralTermnvarchar (50)User defined plural description.
portal_event_idFile_Transfer_EventintUnique and immutable identifier of this event provided by the Portal server
portal_event_idHistory_Of_File_Transfer_Eventint
portal_user_KEYContactint
portal_user_KEYFile_Transfer_EventintPortal_User who triggered this event
portal_user_KEYHistory_Of_Contactint
portal_user_KEYHistory_Of_File_Transfer_Eventint
portal_user_KEYHistory_Of_Portal_Userint
portal_user_KEYPortal_Userintunique and immutable primary key of this portal which is also used as this table's primary key
portal_user_type_KEYHistory_Of_Portal_Userint
portal_user_type_KEYPortal_Userint
positive_invoicedInvoicedecimal (17, 2)Sum of Billing_Decision.invoiced for this invoice where Billing_Decision.invoiced > 0.
positive_nonprogress_invoicedInvoicedecimal (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_invoicedInvoicedecimal (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_codeAddressnvarchar (10)ZipCode / postal code.
postal_codeContact_Addressnvarchar (10)ZipCode / postal code.
postal_codeHistory_Of_Contact_Addressnvarchar (10)
posted__staff_KEYHistory_Of_Sheet_Entryint
posted__staff_KEYIntegration_Sheet_EntryintKey of the Staff who posted this item.
posted__staff_KEYLedger_EntryintKey of the Staff who posted this item.
posted__staff_KEYSheet_EntryintKey of the Staff who posted this item.
posted_actual_amountHistory_Of_Schedule_Itemdecimal (17, 2)
posted_actual_amountSchedule_Itemdecimal (17, 2)Cached value of the amount on posted Sheet_Entry rows associated with this row.
posted_actual_hoursHistory_Of_Schedule_Itemdecimal (17, 2)
posted_actual_hoursSchedule_Itemdecimal (17, 2)Cached value of the hours on posted Sheet_Entry rows associated with this row.
posted_dateHistory_Of_Sheet_Entrysmalldatetime
posted_dateIntegration_InvoicesmalldatetimeDate this item was posted.
posted_dateIntegration_Sheet_EntrysmalldatetimeDate this item was posted.
posted_dateLedger_EntrysmalldatetimeDate this item was posted.
posted_dateSheet_EntrysmalldatetimeDate this item was posted.
practice_user_KEYPractice_UserintAUTO-INCREMENT: Database assigned primary key for this table.
preferred__contact_KEYClientint
preferred__contact_KEYHistory_Of_Clientint
preferred_localeContactnvarchar (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_localeHistory_Of_Contactnvarchar (50)
previous_versionUpdate_Data_Version_Historynvarchar (19)
primary__contact_address_type_KEYContactintIndicates which address type is the primary address.
primary__contact_address_type_KEYHistory_Of_Contactint
primary__contact_email_type_KEYContactintIndicates which email type is the primary email.
primary__contact_email_type_KEYHistory_Of_Contactint
primary__contact_KEYLegacy_Contact_Portal_MappingintThe primary key.
primary__contact_phone_type_KEYContactintIndicates which phone type is the primary phone number.
primary__contact_phone_type_KEYHistory_Of_Contactint
principal__client_KEYClientintThis should be a drop list of all clients, it is required if Bill To Principal is selected.
principal__client_KEYClient_Date_CacheintKey to principal Client that the sums are associated with.
principal__client_KEYHistory_Of_Clientint
print_option_KEYPrint_OptionintAUTO-INCREMENT: Database assigned primary key for this table
print_statementsClientbitDetermines whether statements are printed for this client.
print_statementsHistory_Of_Clientbit
printedInvoicebitIndicates if this Invoice has been printed.
printer_namePrint_Optionnvarchar (260)Printer name to print to.
prior_payment_amountIntegration_Invoicedecimal (17, 2)Total amount of all prior payments received at the time of this invoice.
priority_KEYHistory_Of_Schedule_Itemint
priority_KEYInteractionint
priority_KEYPriorityintPrimary key for this table.
priority_KEYProject_TemplateintKey to a Priority that will be used for generated projects.
priority_KEYSchedule_ItemintIf Priority does not apply to this type of Schedule_Item, use Normal priority.
998=Low
999=Normal
1000=High
private__staff_KEYCustom_PortletintKey of Staff who this portlet belongs to, null if this is a public portlet.
privilege_dataSecurity_Groupnvarchar (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_dataUser_Session_Patternnvarchar (1024)
privilege_dependency_KEYPrivilege_DependencyintPrimary key for this table.
privilege_KEYPrivilegeintDatabase assigned primary key for this table.
privilege_KEYPrivilege_DependencyintForeign key to a [Privilege].
privilege_KEYReport_Definition_Privilege_DependencyintKey of the privilege that this report depends upon.
processed_for_project_extensionClient_Status_Eventbit
producedClient_Date_Cachedecimal (9, 2)Produced sum for the Client, principal Client, and entry date
product_codeReport_Definition_Productvarchar (4)A product code from license files.
program_nameChangesetnvarchar (128)The friendly name of the application making the changes.
progress_amount_billedIntegration_Invoicedecimal (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_billedInvoicedecimal (17, 2)Denormalized
progress_bill__gl_entry_export_bill_amount_basis_KEYGL_Entry_Export_Optionint
progress_bill_amountClient_Date_Cachedecimal (9, 2)progress_bill_amount sum for the Client, principal Client, and entry date
progress_bill_gl_accountGL_Entry_Export_Optionnvarchar (60)
project__schedule_item_KEYHistory_Of_Sheet_Entryint
project__schedule_item_KEYSheet_EntryintCached value of the schedule_item_KEY for the associated Project.
project_extension_KEYHistory_Of_Project_Extensionint
project_extension_KEYProject_ExtensionintAUTO-INCREMENT: Database assigned primary key for this table.
project_KEYHistory_Of_Projectint
project_KEYHistory_Of_Project_Extensionint
project_KEYHistory_Of_Sheet_Entryint
project_KEYHistory_Of_Taskint
project_KEYIntegration_Sheet_EntryintOptionally links this Sheet Entry to a Project.
project_KEYProjectintAUTO-INCREMENT: Database assigned primary key for this table.
project_KEYProject_ExtensionintKey to a Project record.
project_KEYSheet_EntryintOptionally links this Sheet Entry to a Project.
project_KEYTaskintKey of the Project this Task belongs to.
project_numberHistory_Of_Projectint
project_numberProjectintUser defined number (unique).
project_template_assignment_KEYProject_Template_Assignmentint
project_template_definition_extension_KEYProject_Template_Definition_ExtensionintDatabase assigned primary key for this table.
project_template_definition_idProject_Template_Definitionnvarchar (11)User defined ID (unique). A Project Template created from this Project Template Definition will this as its ID.
project_template_definition_id_sortableProject_Template_Definitionvarchar (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_KEYProject_Template_Definition_ImportedintAssigned by COMMON_dp_Allocate_Unique_Identifiers. Database assigned primary key for this table.
project_template_definition_KEYProject_Template_DefinitionintDatabase assigned primary key for this table.
project_template_definition_KEYProject_Template_Definition_ExtensionintKey to a Project Template Definition record.
project_template_definition_KEYProject_Template_Definition_Importedint
project_template_entity_KEYProject_Template_EntityintAUTO-INCREMENT: Database assigned primary key for this table.
project_template_extension_KEYProject_Template_ExtensionintAUTO-INCREMENT: Database assigned primary key for this table.
project_template_idHistory_Of_Projectnvarchar (11)
project_template_idProjectnvarchar (11)Cached value of the project_template_id for the associated Project template.
project_template_idProject_Templatenvarchar (11)User defined ID (unique).
project_template_id_sortableHistory_Of_Projectvarchar (48)
project_template_id_sortableProjectvarchar (48)Cached value of the project_template_id_sortable for the associated Project template.
project_template_id_sortableProject_Templatevarchar (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_KEYHistory_Of_Projectint
project_template_KEYHistory_Of_Taskint
project_template_KEYProjectintKey to the Project Template that was used to generate this Project.
project_template_KEYProject_TemplateintAssigned by COMMON_dp_Allocate_Unique_Identifiers. Database assigned primary key for this table.
project_template_KEYProject_Template_AssignmentintWhich project template this assignment is for.
project_template_KEYProject_Template_EntityintKey to a Project Template record.
project_template_KEYProject_Template_ExtensionintKey to a Project Template record.
project_template_KEYTaskintKey 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_KEYTask_Templateint
property_nameDatabase_Propertynvarchar (128)Name of this property (unique).
property_valueDatabase_Propertynvarchar (-1)Value of the property stored as a unicode string.
publication_dateFeed_Channeldatetime
rateTaxing_Authoritydecimal (7, 6)Percentage rate that this Taxing Authority's tax calculation.
rate_type_KEYActivityint1=No Rate, 2=Staff Rate, 3=Fixed Rate (Always 3 for expense)
rate_type_KEYEngagementintKey to a Rate Type record. (1=No Rate, 2=Staff Rate, 3=Fixed Rate)
rate_type_KEYHistory_Of_Engagementint
read_date_utcRecorded_Event_NotificationdatetimeDate recipent read the notification in UTC.
receipt_entry__bank_account_KEYUser_PreferenceintDefault Bank.
receipt_entry__ledger_entry_type_KEYUser_PreferenceintDefault Type.
receipt_entry__user_preference_default_entry_date_KEYUser_PreferenceintDefault Date.
receipt_entry__user_preference_default_sheet_date_KEYUser_PreferenceintDefault Control Date.
receipt_entry_adjustment__bank_account_KEYUser_PreferenceintDefault Bank for adjusting entries (CCR, NSF, DM, CM, WO).
receipt_entry_adjustment_bank_description_hideUser_PreferencebitHides Bank description for adjusting entries (CCR, NSF, DM, CM, WO).
receipt_entry_adjustment_bank_hideUser_PreferencebitHides Bank for adjusting entries (CCR, NSF, DM, CM, WO).
receipt_entry_adjustment_bank_skipUser_PreferencebitSkips Bank for adjusting entries (CCR, NSF, DM, CM, WO).
receipt_entry_auto_apply_to_oldestUser_PreferencebitAutomatically apply new receipts to the oldest outstanding items.
receipt_entry_auto_check_spellingUser_Preferencebit
receipt_entry_bank_description_hideUser_Preferencebit
receipt_entry_bank_hideUser_PreferencebitHides Bank.
receipt_entry_bank_skipUser_PreferencebitSkips Bank.
receipt_entry_client_description_hideUser_Preferencebit
receipt_entry_commentUser_Preferencenvarchar (-1)Default Comment.
receipt_entry_comment_hideUser_PreferencebitHides Comment.
receipt_entry_comment_skipUser_PreferencebitSkips Comment.
receipt_entry_custom_fields_hideUser_PreferencebitWhen true the custom fields button column in receipt entry will be hidden
receipt_entry_custom_fields_skipUser_PreferencebitWhen true the custom fields button column in receipt entry will be skipped
receipt_entry_display_applied_amounts_screenUser_PreferencebitAutomatically display the Applied Amounts form after they enter an amount.
receipt_entry_display_custom_fieldsUser_PreferencebitWhen true the custom fields button column in receipt entry will be auto-displayed
receipt_entry_display_hash_totalsUser_PreferencebitDisplays hash totals.
receipt_entry_display_linksUser_PreferencebitWhen true the links button column in receipt entry will be auto-displayed
receipt_entry_entry_date_hideUser_PreferencebitHides Date.
receipt_entry_entry_date_skipUser_PreferencebitSkips Date.
receipt_entry_implied_decimalUser_PreferencebitAutomatically inserts decimal point at end of Amount.
receipt_entry_invoice_search_hideUser_PreferencebitWhen true the invoice search column in receipt entry will be hidden
receipt_entry_invoice_search_skipUser_PreferencebitWhen true the invoice search column in receipt entry will be skipped
receipt_entry_ledger_entry_type_skipUser_PreferencebitSkips Type.
receipt_entry_links_hideUser_PreferencebitWhen true the links button column in receipt entry will be hidden
receipt_entry_links_skipUser_PreferencebitWhen true the links button column in receipt entry will be skipped
receipt_entry_reference_hideUser_PreferencebitHides Reference.
receipt_entry_reference_skipUser_PreferencebitSkips Reference.
receipt_entry_sheet_date_skipUser_PreferencebitSkips Control Date.
receipt_entry_startup_tabUser_Preferencenvarchar (100)Which tab to start on.
receipt_entry_type_description_hideUser_Preferencebit
receipts_gl_accountGL_Entry_Export_Optionnvarchar (60)
received_dateHistory_Of_Projectsmalldatetime
received_dateProjectsmalldatetimeDate the information required to begin the project was recieved.
recorded_event_KEYRecorded_EventintAUTO-INCREMENT: Database assigned primary key for this table
recorded_event_KEYRecorded_Event_NotificationintKey of parent Recorded_Event record.
recorded_event_KEYSchedule_Item_Reminder_Recorded_EventintThe [Recorded_Event] that is the reminder.
recorded_event_notification_KEYRecorded_Event_NotificationintAUTO-INCREMENT: Database assigned primary key for this table
recurrence_expiration_method_KEYHistory_Of_Schedule_Item_Seriesint
recurrence_expiration_method_KEYRecurrence_Expiration_MethodintAssigned primary key for this table.
recurrence_expiration_method_KEYSchedule_Item_Seriesint
recurrence_generation_method_KEYHistory_Of_Schedule_Item_Seriesint
recurrence_generation_method_KEYProject_Template_Definitionint
recurrence_generation_method_KEYRecurrence_Generation_MethodintAssigned primary key for this table.
recurrence_generation_method_KEYSchedule_Item_SeriesintIndicates how this schedule item will be generated.
recurrence_method_KEYHistory_Of_Schedule_Item_Seriesint
recurrence_method_KEYRecurrence_MethodintAssigned primary key for this table.
recurrence_method_KEYSchedule_Item_SeriesintIndicates whether this recurrs and where to get the recurrence information from.
recurrence_ruleBenefitnvarchar (-1)Text of the iCalendar recurrence rules and exteneded properties that make up the benefit recurrence.
recurrence_ruleHistory_Of_Schedule_Item_Seriesnvarchar (-1)
recurrence_ruleMonitored_Eventnvarchar (-1)iCalendar expression for computing the next_check_date.
recurrence_ruleProject_Template_Definitionnvarchar (-1)Text of the iCalendar recurrence rules and exteneded properties that make up the due date recurrence.
recurrence_ruleSchedule_Item_Seriesnvarchar (-1)Text of the iCalendar recurrence rules and exteneded properties that make up the date recurrence.
recurring_billBilling_DecisionbitWhen 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_KEYEngagementintKey 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_KEYHistory_Of_Engagementint
recurring_bill__staff_KEYEngagementintKey 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_KEYHistory_Of_Engagementint
recurring_bill_amountEngagementdecimal (9, 2)The user will need to enter an amount if the engagement is going to be setup for recurring billing.
recurring_bill_amountHistory_Of_Engagementdecimal (9, 2)
recurring_bill_KEYEngagementintKey to a Recurring Bill record.
recurring_bill_KEYHistory_Of_Engagementint
recurring_bill_KEYRecurring_BillintAUTO-INCREMENT: Database assigned primary key for this table
recurring_bill_method_KEYEngagementintKey to a Recurring Bill Method record (required if and only if recurring_bill_KEY is not null).
recurring_bill_method_KEYHistory_Of_Engagementint
referenceIntegration_Invoicenvarchar (30)User defined reference for this entry.
referenceLedger_Entrynvarchar (30)User defined reference for this entry.
REFERENCED_COLUMN_NAMECOMMON_Metadata_About_Foreign_Keysnvarchar (128)
REFERENCED_TABLE_NAMECOMMON_Metadata_About_Foreign_Keysnvarchar (128)
referral_source_KEYReferral_SourceintAUTO-INCREMENT: Database assigned primary key for this table.
referral_type_KEYClientintKey to a Referral Type record.
referral_type_KEYHistory_Of_Clientint
referred_by__client_KEYClientintKey to a Client record.
referred_by__client_KEYHistory_Of_Clientint
referred_by__contact_KEYClientintKey to a Contact record.
referred_by__contact_KEYHistory_Of_Clientint
referred_by__referral_source_KEYClientintKey to a Referral Source record.
referred_by__referral_source_KEYHistory_Of_Clientint
referred_by__staff_KEYClientintKey to a Staff record.
referred_by__staff_KEYHistory_Of_Clientint
registration_dateHistory_Of_Portal_Userdatetime
registration_datePortal_UserdatetimeThe time at which this Portal's registration was completed
registration_sent_dateHistory_Of_Portal_Userdatetime
registration_sent_datePortal_UserdatetimeThe time at which this Portal's registration email was sent
relieve_nonbillable_wipFirmbit
remaining_hours_adjustmentHistory_Of_Schedule_Itemdecimal (9, 2)
remaining_hours_adjustmentSchedule_Itemdecimal (9, 2)Cached value of the hours on Schedule_Item_Budget_Remaining_Entry rows associated with this row.
remaining_hours_adjustment_countHistory_Of_Schedule_Itemint
remaining_hours_adjustment_countSchedule_ItemintCached count of the Schedule_Item_Budget_Remaining_Entry rows associated with this row.
remember_logon_allowedFirmbit
reminder_date_utcHistory_Of_Schedule_Itemdatetime
reminder_date_utcSchedule_ItemdatetimeThe date the reminder is to be recorded.
reminder_date_utcSchedule_Item_Pending_ReminderdatetimeThe date the reminder is to be recorded. This value must match the value in [Schedule_Item_Reminder].
report_based_portlet_KEYReport_Based_PortletintPrimary key
report_category_KEYReport_CategoryintPrimary key for this table
report_category_KEYReport_DefinitionintKey of the Report Category that this row is assigned
report_definition_guidReport_DefinitionuniqueidentifierA database generated unique key for this table.
report_definition_guidReport_Definition_ProductuniqueidentifierThe license__report_definition_guid value from Report_Definition that depends on product_code.
report_definition_guidReport_Definition_Security_GroupuniqueidentifierForeign key to Report Definition.
report_definition_KEYInvoiceintKey to an Invoice Report Definition record.
report_definition_KEYReport_Based_PortletintKey of the report definition of the report that this report-based portlet will display.
report_definition_KEYReport_DefinitionintAUTO-INCREMENT: Database assigned primary key for this table.
report_definition_KEYReport_Definition_Update_Listint
report_definition_KEYReport_Profile_Report_DefinitionintKey to a Report Definition that belongs to this profile.
report_definition_KEYStaff_Report_DefinitionintKey to a Report Definition to which these default options belong.
report_definition_security_group_KEYReport_Definition_Security_GroupintAUTO-INCREMENT: Database assigned primary key for this table
report_definition_update_list_KEYReport_Definition_Update_Listint
report_imageReport_Imagevarbinary (-1)
report_image_KEYReport_Imageint
report_optionsReport_Profile_Report_Definitionnvarchar (-1)The report options in serialized XML format.
report_profile_KEYReport_ProfileintAUTO-INCREMENT: Database assigned primary key for this table
report_profile_KEYReport_Profile_Report_DefinitionintKey to the Report Profile that this report is used on.
report_profile_report_definition_KEYReport_Profile_Report_DefinitionintAUTO-INCREMENT: Database assigned primary key for this table
report_type_KEYReport_DefinitionintKey of the Report Type that this row is assigned
report_type_KEYReport_ProfileintKey of the Report Type that this row is assigned.
require_billing_approvalFirmbitTrue if the approval and posting process is required for Billing.
require_entry_projectFirmbit
require_receipt_approvalFirmbitTrue if the approval and posting process is required for Receipt Entry.
require_sheet_approvalFirmbitTrue if the approval and posting process is required for Time and Expense Entry.
resolved_end_date_utcChangesetdatetimeThe value to use for the ending time of this Changeset.
responseLedger_Entry_Submittal_Resultnvarchar (200)Contents of the response field in the response returned by Intercept.
responsecodeLedger_Entry_Submittal_Resultnvarchar (6)Contents of the responsecode field in the response returned by Intercept.
responsible__staff_grouping_type_KEYProject_TemplateintKey to a Staff Grouping Type that indicates how to determine which staff will be responsible for generated projects.
responsible__staff_KEYHistory_Of_Projectint
responsible__staff_KEYProjectintKey to a Staff that will be responsible for generated projects.
responsible__staff_KEYProject_TemplateintKey to a Staff that will be responsible for generated projects.
returning_utcStaff_LocatordatetimeDate and time the staff will return in UTC.
reviewer__staff_grouping_type_KEYEngagement_TemplateintKey to a Staff Grouping Type that indicates how to determine which staff will be assigned to generated engagements.
reviewer__staff_KEYEngagementintKey to a Staff record.
reviewer__staff_KEYHistory_Of_Engagementint
revise__changeset_KEYHistory_Of_Additional_Contactint
revise__changeset_KEYHistory_Of_Attachmentint
revise__changeset_KEYHistory_Of_Attachment_Contentint
revise__changeset_KEYHistory_Of_Calendar_Categoryint
revise__changeset_KEYHistory_Of_Clientint
revise__changeset_KEYHistory_Of_Client_Financial_Dataint
revise__changeset_KEYHistory_Of_Client_Financial_Data_Descriptionint
revise__changeset_KEYHistory_Of_Client_Staff_Groupingint
revise__changeset_KEYHistory_Of_Contactint
revise__changeset_KEYHistory_Of_Contact_Addressint
revise__changeset_KEYHistory_Of_Contact_Categoryint
revise__changeset_KEYHistory_Of_Contact_Contact_Categoryint
revise__changeset_KEYHistory_Of_Contact_Emailint
revise__changeset_KEYHistory_Of_Contact_Phoneint
revise__changeset_KEYHistory_Of_Custom_Chartint
revise__changeset_KEYHistory_Of_Custom_Fieldint
revise__changeset_KEYHistory_Of_Custom_Valueint
revise__changeset_KEYHistory_Of_Digita_Vat_Periodint
revise__changeset_KEYHistory_Of_Engagementint
revise__changeset_KEYHistory_Of_File_Transferint
revise__changeset_KEYHistory_Of_File_Transfer_Eventint
revise__changeset_KEYHistory_Of_File_Transfer_Fileint
revise__changeset_KEYHistory_Of_Linkint
revise__changeset_KEYHistory_Of_Link_Groupint
revise__changeset_KEYHistory_Of_Portal_Userint
revise__changeset_KEYHistory_Of_Projectint
revise__changeset_KEYHistory_Of_Project_Extensionint
revise__changeset_KEYHistory_Of_Schedule_Entryint
revise__changeset_KEYHistory_Of_Schedule_Itemint
revise__changeset_KEYHistory_Of_Schedule_Item_Assignmentint
revise__changeset_KEYHistory_Of_Schedule_Item_Budget_Remaining_Entryint
revise__changeset_KEYHistory_Of_Schedule_Item_Seriesint
revise__changeset_KEYHistory_Of_Sheet_Entryint
revise__changeset_KEYHistory_Of_Tagint
revise__changeset_KEYHistory_Of_Tagged_Itemint
revise__changeset_KEYHistory_Of_Taskint
revise__changeset_KEYHistory_Of_Time_Zoneint
revise__changeset_KEYHistory_Of_Timerint
roundService_ChargebitRound to the nearest dollar when true.
round_extensionActivitybitUsed to determine if WIP will be rounded to the nearest dollar when it is calculated
rounding_incrementHistory_Of_Timerdecimal (4, 2)
rounding_incrementTimerdecimal (4, 2)The Rounding Increment that was in place when the Timer was started.
rounding_method_KEYHistory_Of_Timerint
rounding_method_KEYTimerintThe Rounding Method that was in place when the Timer was started.
row_KEYAttachmentintWhich row in the table indicated by [table_information_KEY].
row_KEYCustom_ValueintWhich row in the table indicated by [table_information_KEY].
row_KEYHistory_Of_Attachmentint
row_KEYHistory_Of_Custom_Valueint
row_KEYHistory_Of_Link_Groupint
row_KEYHistory_Of_Tagged_Itemint
row_KEYIntegration_Custom_Valueint
row_KEYLink_GroupintThe primary key to the Practice item that this group aggregates links for.
row_KEYMonitored_Event_ActionintOptional key value that specifies entity to notify.
row_KEYTagged_ItemintWhich row in that table indicated by [table_information_KEY].
row_versionChangesettimestamp
row_versionClient_Status_Eventtimestamp
row_versionFirm_Datetimestamp
row_versionHistory_Of_Projectbinary (8)
row_versionHistory_Of_Project_Extensionbinary (8)
row_versionHistory_Of_Sheet_Entrybinary (8)
row_versionHistory_Of_Taskbinary (8)
row_versionIntegration_Applicationtimestamp
row_versionIntegration_Invoicetimestamp
row_versionIntegration_Invoice_Prior_Paymenttimestamp
row_versionIntegration_Sheet_Entrytimestamp
row_versionInvoicetimestamp
row_versionLedger_Entrytimestamp
row_versionLedger_Entry_Applicationtimestamp
row_versionLedger_Entry_Service_Chargetimestamp
row_versionLost_Reasontimestamp
row_versionLost_Totimestamp
row_versionProjecttimestamp
row_versionProject_Extensiontimestamp
row_versionProject_Templatetimestamp
row_versionProject_Template_Definitiontimestamp
row_versionProject_Template_Definition_Extensiontimestamp
row_versionProject_Template_Definition_Importedtimestamp
row_versionProject_Template_Entitytimestamp
row_versionProject_Template_Extensiontimestamp
row_versionReferral_Sourcetimestamp
row_versionSheet_Entrytimestamp
row_versionStaff_Skill_Areatimestamp
row_versionStaff_Skill_Ratingtimestamp
row_versionStatus_Eventtimestamp
row_versionStatus_Event_Typetimestamp
row_versionTasktimestamp
row_versionTask_Templatetimestamp
row_versionTracking_Descriptiontimestamp
row_versionWon_Reasontimestamp
sales_taxBilling_Decisiondecimal (9, 2)Sum of Billing_Decision_Taxing_Authority.amount for this Billing_Decision for Taxing_Authority records of sales tax.
sales_taxClient_Date_Cachedecimal (9, 2)sales_tax sum for the Client, principal Client, and entry date
sales_taxIntegration_Invoicedecimal (17, 2)Amount of sales tax on this invoice.
sales_taxInvoicedecimal (17, 2)Denormalized
sales_tax_collectedBilling_Decision_Collectiondecimal (9, 2)The amount collected for the sales tax of the Billing_Decision.
saltPractice_Usernvarchar (8)
salutationContactnvarchar (40)Salutation for opening letters.
salutationHistory_Of_Contactnvarchar (40)
scaleCustom_Fieldint
scaleHistory_Of_Custom_Fieldint
schedule_entry_durationHistory_Of_Schedule_Entryint
schedule_entry_durationSchedule_EntryintThe duration of the schedule entry on the timeline in minutes.
schedule_entry_end__time_zone_KEYHistory_Of_Schedule_Entrysmallint (5)
schedule_entry_end__time_zone_KEYSchedule_Entrysmallint (5)The time zone selected by the last person editing [schedule_entry_end_utc].
schedule_entry_end_utcHistory_Of_Schedule_Entrydatetime
schedule_entry_end_utcSchedule_EntrydatetimeCOMPUTED: The ending date and time in UTC computed from [schedule_entry_start_utc] and [schedule_entry_duration].
schedule_entry_KEYHistory_Of_Schedule_Entryint
schedule_entry_KEYSchedule_Entryint
schedule_entry_scheduledHistory_Of_Schedule_Entryint
schedule_entry_scheduledSchedule_EntryintThe 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_KEYHistory_Of_Schedule_Entrysmallint (5)
schedule_entry_start__time_zone_KEYSchedule_Entrysmallint (5)The time zone selected by the last person editing [schedule_entry_start_utc].
schedule_entry_start_utcHistory_Of_Schedule_Entrydatetime
schedule_entry_start_utcSchedule_EntrydatetimeThe starting date and time in UTC.
schedule_item_assignment_KEYHistory_Of_Schedule_Item_Assignmentint
schedule_item_assignment_KEYSchedule_Item_Assignmentint
schedule_item_assignment_rankHistory_Of_Schedule_Item_Assignmentint
schedule_item_assignment_rankSchedule_Item_AssignmentintThis 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_KEYHistory_Of_Schedule_Item_Budget_Remaining_Entryint
schedule_item_budget_remaining_entry_KEYSchedule_Item_Budget_Remaining_EntryintAssigned by COMMON_dp_Allocate_Unique_Identifiers. Primary key for this table.
schedule_item_KEYEducation_Creditint
schedule_item_KEYHistory_Of_Projectint
schedule_item_KEYHistory_Of_Schedule_Entryint
schedule_item_KEYHistory_Of_Schedule_Itemint
schedule_item_KEYHistory_Of_Schedule_Item_Assignmentint
schedule_item_KEYHistory_Of_Schedule_Item_Budget_Remaining_Entryint
schedule_item_KEYHistory_Of_Taskint
schedule_item_KEYProjectintThe [Schedule_Item] that owns this link.
schedule_item_KEYSchedule_EntryintLink to the schedule item of the assignment that is being scheduled (or at least partially scheduled) by this record.
schedule_item_KEYSchedule_ItemintAssigned by COMMON_dp_Allocate_Unique_Identifiers. Assigned primary key for this table.
schedule_item_KEYSchedule_Item_AssignmentintWhich schedule item this assignment is for.
schedule_item_KEYSchedule_Item_Assignment_List_CacheintKey to the [Schedule_Item] row that these assignments are associated with.
schedule_item_KEYSchedule_Item_Budget_Remaining_EntryintSchedule item key to which this entry belongs.
schedule_item_KEYSchedule_Item_Date_Indexint
schedule_item_KEYSchedule_Item_Last_In_SeriesintKey of the last Schedule Item in the series.
schedule_item_KEYSchedule_Item_Pending_ReminderintThe [Schedule_Item_Reminder] that owns this link.
schedule_item_KEYSchedule_Item_Reminder_Recorded_EventintThe [Schedule_Item] that the reminder is for.
schedule_item_KEYTaskint
schedule_item_noteHistory_Of_Schedule_Itemnvarchar (-1)
schedule_item_noteSchedule_Itemnvarchar (-1)Any comments or notes about the item.
schedule_item_series_KEYHistory_Of_Schedule_Itemint
schedule_item_series_KEYHistory_Of_Schedule_Item_Seriesint
schedule_item_series_KEYProject_TemplateintKey of series that goes with this project template.
schedule_item_series_KEYSchedule_ItemintThe linked [Schedule Item Series].
schedule_item_series_KEYSchedule_Item_Generation_DateintKey of the schedule item series.
schedule_item_series_KEYSchedule_Item_Last_In_SeriesintPrimary key for this table.
schedule_item_series_KEYSchedule_Item_SeriesintAssigned by COMMON_dp_Allocate_Unique_Identifiers. Assigned primary key for this table.
schedule_item_type_KEYHistory_Of_Schedule_Itemint
schedule_item_type_KEYSchedule_ItemintKey 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_KEYHistory_Of_Schedule_Itemint
scheduled_benefit_status_KEYSchedule_ItemintOnly allowed for items of type scheduled benefit.
1=Pending
2=Approved
3=Denied
scheduled_phone_call_status_KEYHistory_Of_Schedule_Itemint
scheduled_phone_call_status_KEYSchedule_ItemintOnly allowed for items of type scheduled phone call.
1=Scheduled
2=Attempted
3=Completed
search_subfoldersOutlook_Index_Folder_FirmbitSpecifies if subfolders should also be searched.
security_enabledFirmbit
security_group_KEYReport_Definition_Security_GroupintForeign key to Security Group.
security_group_KEYSecurity_GroupintAUTO-INCREMENT: Database assigned primary key for this table.
security_group_KEYStaff_Security_GroupintForeign key to Security Group.
selectedFilter_SelectintThe value of the primary key for the selected item.
separate_zero_invoice_numberingFirmbitUse separate invoice numbering sequence for zero amounts.
server_application_nameUpdate_Data_Version_Historynvarchar (200)
server_application_nameUser_Session_Patternnvarchar (200)
service_charge__ledger_entry_KEYLedger_Entry_Service_ChargeintKey to the Ledger Entry that is the Service Charge.
service_charge_KEYClientintKey to a Service Charge record.
service_charge_KEYFirmintKey to a Service Charge record.
service_charge_KEYHistory_Of_Clientint
service_charge_KEYService_ChargeintAUTO-INCREMENT: Database assigned primary key for this table
service_charge_type_KEYService_ChargeintKey from one of the Service Charge Types. 1=Invoice Date, 2=Due Date, 3=Due Date + Grace Days
service_charges_gl_accountGL_Entry_Export_Optionnvarchar (60)
service_taxBilling_Decisiondecimal (9, 2)Sum of Billing_Decision_Taxing_Authority.amount for this Billing_Decision for Taxing_Authority records of type service tax.
service_taxClient_Date_Cachedecimal (9, 2)service_tax sum for the Client, principal Client, and entry date
service_taxIntegration_Invoicedecimal (17, 2)Amount of service tax on this invoice.
service_taxInvoicedecimal (17, 2)Denormalized
service_tax_collectedBilling_Decision_Collectiondecimal (9, 2)The amount collected for the service tax of the Billing_Decision.
service_typeGofileroom_Workflownvarchar (255)GoFileRoom folder name in which this workflow exists.
service_type_idGofileroom_WorkflowintOne of four required fields that uniquely identify a workflow, not intended to be viewed by users.
sheet_dateHistory_Of_Sheet_Entrysmalldatetime
sheet_dateIntegration_Sheet_EntrysmalldatetimeDate of the Sheet, also known as control date.
sheet_dateSheet_EntrysmalldatetimeDate of the Sheet, also known as control date.
sheet_dateStaff_Benefit_EntrysmalldatetimeThe sheet date that this entry corresponds to.
sheet_entry_KEYBilling_DecisionintThe Sheet Entry this billing is for.
sheet_entry_KEYBilling_Decision_CollectionintThe combination of ledger_entry_KEY and sheet_entry_KEY identifies the billing decision this collection is for.
sheet_entry_KEYBilling_Decision_Tax_CollectionintThe combination of ledger_entry_KEY, sheet_entry_KEY and taxing_authority_KEY identifies the BDTA row this collection is for.
sheet_entry_KEYBilling_Decision_Taxing_AuthorityintThe combination of ledger_entry_KEY and sheet_entry_KEY identifies the Billing_Decision row this tax is charged for.
sheet_entry_KEYHistory_Of_Sheet_Entryint
sheet_entry_KEYHistory_Of_Timerint
sheet_entry_KEYSheet_EntryintAssigned by COMMON_dp_Allocate_Unique_Identifiers. Database assigned primary key for this table.
sheet_entry_KEYSheet_Entry_Open_Value_CacheintKey to a Sheet_Entry row.
sheet_entry_KEYTimerintThe key to the Sheet Entry row this timer is for.
sheet_entry_type_KEYHistory_Of_Sheet_Entryint
sheet_entry_type_KEYIntegration_Sheet_EntryintKey to Sheet Entry Type indicating what type of entry this is.
sheet_entry_type_KEYSheet_Entryint1=Standard
2=Progress Billing
3=Billing Adjustment
4=Timer Entry
5=Remote Standard
6=Exported Remote Standard
show_desktop_notifications_until_closedUser_Preferencebit
signature_reject_date_utcFile_Transfer_FiledatetimeThe time at which this file's signature request was rejected
signature_reject_date_utcHistory_Of_File_Transfer_Filedatetime
signature_request_date_utcFile_Transfer_FiledatetimeThe time at which this file's signature request was created
signature_request_date_utcHistory_Of_File_Transfer_Filedatetime
signature_sign_date_utcFile_Transfer_FiledatetimeThe time at which this file's signature request was signed
signature_sign_date_utcHistory_Of_File_Transfer_Filedatetime
singularTermnvarchar (50)User defined singular description.
skip_columnUser_Preference_Custom_Field_ColumnbitWhether or not this field should be skipped in Time and expense entry
social_security_numberStaffnvarchar (11)Social Security Number.
solution_type_nameHistory_Of_Projectnvarchar (50)
solution_type_nameHistory_Of_Tasknvarchar (50)
solution_type_nameProjectnvarchar (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_nameProject_Templatenvarchar (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_nameTasknvarchar (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_nameTask_Templatenvarchar (50)
sortClient_ShortcutintA 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.
sortClient_Shortcut_GroupintUser-configurable sequence number that defines the order in which the solution group will appear in the Solutions portlet.
sortCustom_FieldintSort order of this custom field when it is displayed. The fields should be sorted by position and description.
sortDepartment_Grouping_TypeintUser defined sort for this table.
sortFirm_Date_TypeintUser defined sort for this table.
sortFirm_ShortcutintA 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.
sortFirm_Shortcut_GroupintUser-configurable sequence number that defines the order in which the solution group will appear in the Solutions portlet.
sortHistory_Of_Custom_Fieldint
sortHistory_Of_Linkint
sortHistory_Of_Link_Groupint
sortLinkintA value indicating what order to sort items in
sortLink_GroupintThe order in which this group will be displayed
sortPriorityintUser defined sort for this table.
sortPrivilegeintIt is required that the privileges sort in a particular order. This is how the order is specified.
sortRecurrence_Expiration_MethodintUser defined sort for this table.
sortRecurrence_Generation_MethodintUser defined sort for this table.
sortRecurrence_MethodintUser defined sort for this table.
sortStaff_Grouping_TypeintUser defined sort for this table.
sortStaff_ShortcutintA 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.
sortStaff_Shortcut_GroupintUser-configurable sequence number that defines the order in which the solution group will appear in the Solutions portlet.
sortTarget_Date_MethodintUser defined sort for this table.
sortTracking_DescriptionintUser defined sort for this table.
sort_hierarchyPrivilegenvarchar (450)Same as Hierarchy except that the values from Sort column are used.
sort_orderReport_Categoryint
sortable_to_dateBenefit_FactorsmalldatetimeThe [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_nameFile_Transfer_Filenvarchar (50)The original machine name from which the file was uploaded
source_machine_nameHistory_Of_File_Transfer_Filenvarchar (50)
source_pathFile_Transfer_Filenvarchar (260)The original full path of this file at the time this file was uploaded as part of a File Transfer
source_pathHistory_Of_File_Transfer_Filenvarchar (260)
SPECIFIC_NAMECOMMON_Metadata_About_Sprocsnvarchar (128)
spouse_date_of_birthClientsmalldatetimeDate of birth for the spouse of the client if the client is an individual
spouse_date_of_birthHistory_Of_Clientsmalldatetime
spouse_federal_tinClientnvarchar (11)This field will hold the SSN for an individual client's spouse.
spouse_federal_tinHistory_Of_Clientnvarchar (11)
spouse_first_nameClientnvarchar (100)First name of the clients spouse if the client type is an individual.
spouse_first_nameHistory_Of_Clientnvarchar (100)
spouse_last_nameClientnvarchar (100)Last name of the clients spouse if the client type is an individual.
spouse_last_nameHistory_Of_Clientnvarchar (100)
staff__contact_KEYFile_TransferintStaff Contact associated with this File Transfer
staff__contact_KEYHistory_Of_File_Transferint
staff__portal_user_KEYFile_TransferintStaff Portal_User associated with this File Transfer
staff__portal_user_KEYHistory_Of_File_Transferint
staff_area_rating_KEYStaff_Area_RatingintAUTO-INCREMENT: Database assigned primary key for this table.
staff_assignment_method_KEYHistory_Of_Schedule_Itemint
staff_assignment_method_KEYProject_Templateint
staff_assignment_method_KEYSchedule_Itemint1=Assigned Staff
2=Work Queue
staff_assignment_method_KEYTask_Templateint
staff_benefit_entry_KEYStaff_Benefit_EntryintAssigned by COMMON_dp_Allocate_Unique_Identifiers. Primary key for this table.
staff_benefit_KEYStaff_BenefitintAssigned by COMMON_dp_Allocate_Unique_Identifiers. Primary key for this table.
staff_benefit_KEYStaff_Benefit_EntryintKey to a staff benefit.
staff_billing_rate_KEYHistory_Of_Sheet_Entryint
staff_billing_rate_KEYIntegration_Sheet_EntryintKey to the Staff Billing Rate used to calculate the amount.
staff_billing_rate_KEYSheet_EntryintKey to the Staff Billing Rate used to calculate the amount.
staff_billing_rate_KEYStaff_Billing_RateintAUTO-INCREMENT: Database assigned primary key for this table.
staff_dashboard_layoutUser_Preferencenvarchar (-1)Layout of the Staff Dashboard stored as XML
staff_grouping_type_KEYStaff_Grouping_TypeintPrimary key for this table.
staff_grouping_type_KEYTask_Templateint
staff_idStaffnvarchar (11)User defined identifier (unique).
staff_id_sortableStaffvarchar (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_KEYActive_FilterintKey to the Staff this filter is in use by.
staff_KEYClient_Staff_Groupingint
staff_KEYFeed_Channel_Item_Staff_Readint
staff_KEYHistory_Of_Client_Staff_Groupingint
staff_KEYHistory_Of_Schedule_Entryint
staff_KEYHistory_Of_Schedule_Item_Assignmentint
staff_KEYHistory_Of_Sheet_Entryint
staff_KEYIntegration_Sheet_EntryintStaff this Sheet Entry is for.
staff_KEYLogin_TicketintThe staff that can be logged in using this ticket.
staff_KEYOutlook_Contact_Synchronization_ProfileintReference to the staff that owns this filter profile.
staff_KEYPractice_Userint
staff_KEYPrint_OptionintThe staff these print option are for.
staff_KEYProject_Template_AssignmentintWhich staff is assigned.
staff_KEYRecorded_Event_NotificationintKey of staff member who should see the event record in their portal, etc. Null for non staff.
staff_KEYReport_ProfileintKey of the Staff to whom the profile belongs.
staff_KEYRestricted_Clearance_StaffintA reference to a Staff row that may access a restricted access database.
staff_KEYSchedule_EntryintLink to the staff of the assignment that is being scheduled (or at least partially scheduled) by this record.
staff_KEYSchedule_Item_AssignmentintWhich staff is assigned.
staff_KEYSheet_EntryintStaff this Sheet Entry is for.
staff_KEYStaffintAssigned by COMMON_dp_Allocate_Unique_Identifiers. Database assigned primary key for this table.
staff_KEYStaff_Area_RatingintForeign key of the staff this Rate Table belongs to.
staff_KEYStaff_BenefitintKey to a Staff.
staff_KEYStaff_LocatorintKey to a Staff record
staff_KEYStaff_Rate_TableintForeign key of the staff this Rate Table belongs to.
staff_KEYStaff_Report_DefinitionintKey to the staff to whom these default options belong.
staff_KEYStaff_Security_GroupintForeign key to Staff.
staff_KEYStaff_Shortcut_GroupintThe staff who own this solution group.
staff_KEYStaff_Target_RangeintLinks this record to a particular staff.
staff_KEYTask_Template_AssignmentintWhich staff is assigned.
staff_KEYUser_PreferenceintKey of one of the Staff records
staff_KEYUser_SessionintKey to the Staff that this session is for.
staff_level_idStaff_Levelnvarchar (11)User defined identifier (unique).
staff_level_id_sortableStaff_Levelvarchar (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_KEYAccruable_Benefit_Allowance_By_Staff_LevelintKey to a staff level.
staff_level_KEYStaffintKey from one of the already set up Staff Levels.
staff_level_KEYStaff_LevelintAUTO-INCREMENT: Database assigned primary key for this table.
staff_locator_KEYStaff_LocatorintAUTO-INCREMENT: Database assigned primary key for this table
staff_locator_status_KEYStaff_LocatorintKey to a Staff Locator Status row
staff_qualifications__filter_KEYHistory_Of_Schedule_Itemint
staff_qualifications__filter_KEYProject_Templateint
staff_qualifications__filter_KEYSchedule_ItemintAn optional Staff filter that represents Staff qualified to work on this item. Some types do not allow Staff qualifications.
staff_qualifications__filter_KEYTask_Templateint
staff_rate_table_KEYStaff_Billing_RateintForeign key to the Staff Rate Table. There can be several Staff Billing Rates per Staff Rate Table
staff_rate_table_KEYStaff_Rate_TableintAUTO-INCREMENT: Database assigned primary key for this table.
staff_report_definition_KEYStaff_Report_DefinitionintAUTO-INCREMENT: Database assigned primary key for this table.
staff_security_group_KEYStaff_Security_GroupintAUTO-INCREMENT: Database assigned primary key for this table.
staff_shortcut_group_KEYStaff_ShortcutintAssociates this solution with its solution group.
staff_shortcut_group_KEYStaff_Shortcut_GroupintAssigned by COMMON_dp_Allocate_Unique_Identifiers. Database assigned primary key for this table
staff_shortcut_KEYStaff_ShortcutintAssigned by COMMON_dp_Allocate_Unique_Identifiers. Database assigned primary key for this table
staff_skill_area_KEYStaff_Area_RatingintForeign key - Registers area of expertise for a given staff.
staff_skill_area_KEYStaff_Skill_AreaintAUTO-INCREMENT: Database assigned primary key for this table.
staff_skill_area_KEYStaff_Skill_Area_Ratingint
staff_skill_area_rating_KEYStaff_Skill_Area_Ratingint
staff_skill_rating_KEYStaff_Area_RatingintForeign key - Registers rates expertise for a staff in a particular area
staff_skill_rating_KEYStaff_Skill_Area_Ratingint
staff_skill_rating_KEYStaff_Skill_RatingintAUTO-INCREMENT: Database assigned primary key for this table.
staff_status_KEYStaffintKey from one of the already set up Staff Status.
staff_target_range_KEYStaff_Target_RangeintAssigned by COMMON_dp_Allocate_Unique_Identifiers. Manufactured primary key for this table.
standard_text_idStandard_Textnvarchar (11)User defined identifier (unique).
standard_text_id_sortableStandard_Textvarchar (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_KEYStandard_TextintAUTO-INCREMENT: Database assigned primary key for this table
standard_vat_rateDigita_Vat_Perioddecimal (4, 2)The standard vat rate to use for this period
standard_vat_rateHistory_Of_Digita_Vat_Perioddecimal (4, 2)
start__target_date_method_KEYHistory_Of_Schedule_Item_Seriesint
start__target_date_method_KEYProject_Template_Definitionint
start__target_date_method_KEYSchedule_Item_SeriesintThe method used to calculate the target start date.
start__target_date_method_KEYTask_Templateint
start_dateDigita_Vat_PerioddatetimeThe start date for the VAT period.
start_dateHistory_Of_Digita_Vat_Perioddatetime
startup_windowUser_Preferencenvarchar (100)Screen to open at startup
state_abbreviationAddressnvarchar (2)State.
state_abbreviationContact_Addressnvarchar (2)State.
state_abbreviationHistory_Of_Contact_Addressnvarchar (2)
statement__report_definition_KEYClientintKey to an Statement Report Definition record.
statement__report_definition_KEYFirmintDefault statement format for new clients
statement__report_definition_KEYHistory_Of_Clientint
statement_email_bodyFirmnvarchar (-1)
statement_email_subjectFirmnvarchar (255)
statement_exclude_current_invoice_activity_clientsUser_PreferencebitExcludes clients that have recently been invoiced.
statement_include_creditsUser_PreferencebitIncludes clients that have a credit balance.
statement_include_debitsUser_PreferencebitIncludes clients with debits if they meet over_balance or over_age
statement_include_debits_over_ageUser_PreferenceintIncludes a client if the client has a debit older than this many days.
statement_include_debits_over_balanceUser_Preferencedecimal (17, 2)Includes a client if their balance is greater than this.
statement_include_zero_balance_with_current_activityUser_PreferencebitIncludes clients that have a zero balance but had recent activity.
status_event_codeStatus_Eventnvarchar (11)
status_event_KEYClient_Status_EventintKey to the Status_Event that was recorded.
status_event_KEYStatus_EventintAUTO-INCREMENT: Database assigned primary key for this table
status_event_type_KEYStatus_EventintKey to one of the records in the Status_Event_Type table.
status_event_type_KEYStatus_Event_TypeintAUTO-INCREMENT: Database assigned primary key for this table
store_idOutlook_Storevarbinary (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_checksumOutlook_StoreintSince 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_KEYFilter_LineintIf the method is Filter, the key to the filter; otherwise null.
subfilter__filter_type_KEYFilter_Line_TypeintA key to a Filter Type if another filter can be used as a method.
subjectFile_Transfernvarchar (255)subject line of this File Transfer
subjectHistory_Of_File_Transfernvarchar (255)
subjectInteractionnvarchar (50)The subject of the interaction, currently limited to 50 characters.
submittal_status_KEYLedger_Entry_SubmittalintThe status for this ledger entry.
supervisor__staff_KEYStaffintKey of the staff that is this Staff's supervisor.
surchargeBilling_Decisiondecimal (9, 2)Surcharge applied to this item, calculated before discount (surcharge rate x bill_amount).
surchargeClient_Date_Cachedecimal (9, 2)surcharge sum for the Client, principal Client, and entry date
surchargeIntegration_Invoicedecimal (17, 2)The surcharge amount on this integration_invoice (always 0 or positive.)
surchargeInvoicedecimal (17, 2)Denormalized
surcharge_amountEngagementdecimal (9, 2)Rate to use when surcharge_type_KEY = 3
surcharge_amountHistory_Of_Engagementdecimal (9, 2)
surcharge_collectedBilling_Decision_Collectiondecimal (9, 2)The amount collected for the surcharge of the Billing_Decision.
surcharge_rateActivitydecimal (9, 4)Amount to charge if surcharge_method_KEY=1; Percent to charge if surcharge_method_KEY=2
swipeLedger_Entry_SubmittalbitIndicates the user chose to swipe the card on Secure Pay through an external browser
table_information_KEYAttachmentintWhich table is the row indicated by row_KEY in.
table_information_KEYChangeset_Modified_TableintWhich table was modified.
table_information_KEYCustom_FieldintMain table that this custom field is associated with. See Custom_Value.table_information_KEY
table_information_KEYCustom_ValueintWhich 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_KEYHistory_Of_Attachmentint
table_information_KEYHistory_Of_Custom_Fieldint
table_information_KEYHistory_Of_Custom_Valueint
table_information_KEYHistory_Of_Link_Groupint
table_information_KEYHistory_Of_Tagged_Itemint
table_information_KEYLink_GroupintDefines the type of Practice information that this group aggregates links for
table_information_KEYOption_Listint
table_information_KEYTable_Informationint
table_information_KEYTagged_ItemintWhich table is the row indicated by [row_KEY] in.
TABLE_NAMECOMMON_Metadata_About_Columnsnvarchar (128)
TABLE_NAMECOMMON_Metadata_About_Foreign_Keysnvarchar (128)
TABLE_NAMECOMMON_Metadata_About_Keysnvarchar (128)
table_nameCOMMON_Unique_Identifier_Counternvarchar (128)
table_nameDepartment_Grouping_Typenvarchar (128)Name of the table used to find the value.
table_nameStaff_Grouping_Typenvarchar (128)Name of the table used to find the value.
TABLE_TYPECOMMON_Metadata_About_Columnsvarchar (10)
tag_KEYHistory_Of_Tagint
tag_KEYHistory_Of_Tagged_Itemint
tag_KEYTagintAssigned by COMMON_dp_Allocate_Unique_Identifiers. Key that represents a tag.
tag_KEYTagged_ItemintWhich tag is associated.
tagged_item_sortHistory_Of_Tagged_Itemint
tagged_item_sortTagged_ItemintThe sort order of the tags on a particular item.
targetClient_Shortcutnvarchar (2048)Target to execute. File name or url.
targetDatasharing_Pathnvarchar (260)The file system path in which to read or write datasharing data.
targetFirm_Shortcutnvarchar (2048)Target to execute. File name or url.
targetHistory_Of_Linknvarchar (2048)
targetHistory_Of_Projectnvarchar (1000)
targetHistory_Of_Tasknvarchar (1000)
targetLinknvarchar (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.
targetProjectnvarchar (1000)Target to execute. File name or url.
targetProject_Templatenvarchar (1000)Target to execute. File name or url.
targetStaff_Shortcutnvarchar (2048)Target to execute. File name or url.
targetTasknvarchar (1000)Target to execute. File name or url.
targetTask_Templatenvarchar (1000)
target_complete__time_zone_KEYHistory_Of_Schedule_Itemsmallint (5)
target_complete__time_zone_KEYSchedule_Itemsmallint (5)
target_complete_date_exclusive_utcHistory_Of_Schedule_Itemdatetime
target_complete_date_exclusive_utcSchedule_ItemdatetimeThe end of the valid period (exclusive) for this item to be scheduled.
target_complete_dayHistory_Of_Schedule_Item_Seriesint
target_complete_dayProject_Template_Definitionint
target_complete_daySchedule_Item_SeriesintNumber of days relative to complete__target_date_method_KEY to use as the target complete date.
target_complete_dayTask_Templateint
target_complete_monthHistory_Of_Schedule_Item_Seriesint
target_complete_monthProject_Template_Definitionint
target_complete_monthSchedule_Item_SeriesintNumber of months relative to complete__target_date_method_KEY to use as the target complete date.
target_complete_monthTask_Templateint
target_date_method_KEYTarget_Date_MethodintPrimary key for this table.
target_hours_fridayStaff_Target_Rangedecimal (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_mondayStaff_Target_Rangedecimal (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_saturdayStaff_Target_Rangedecimal (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_sundayStaff_Target_Rangedecimal (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_thursdayStaff_Target_Rangedecimal (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_tuesdayStaff_Target_Rangedecimal (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_wednesdayStaff_Target_Rangedecimal (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_KEYHistory_Of_Schedule_Itemsmallint (5)
target_start__time_zone_KEYSchedule_Itemsmallint (5)
target_start_date_utcHistory_Of_Schedule_Itemdatetime
target_start_date_utcSchedule_ItemdatetimeThe start of the valid period for this item to be scheduled.
target_start_dayHistory_Of_Schedule_Item_Seriesint
target_start_dayProject_Template_Definitionint
target_start_daySchedule_Item_SeriesintNumber of days relative to start__target_date_method_KEY to use as the target start date.
target_start_dayTask_Templateint
target_start_monthHistory_Of_Schedule_Item_Seriesint
target_start_monthProject_Template_Definitionint
target_start_monthSchedule_Item_SeriesintNumber of months relative to start__target_date_method_KEY to use as the target start date.
target_start_monthTask_Templateint
task__schedule_item_KEYHistory_Of_Sheet_Entryint
task__schedule_item_KEYSheet_EntryintCached value of the schedule_item_KEY for the associated Task.
task_KEYHistory_Of_Sheet_Entryint
task_KEYHistory_Of_Taskint
task_KEYIntegration_Sheet_EntryintOptionally links this Sheet Entry to a Task.
task_KEYSheet_EntryintOptionally links this Sheet Entry to a Task.
task_KEYTaskintAUTO-INCREMENT: Database assigned primary key for this table.
task_numberHistory_Of_Taskint
task_numberTaskintEach Task will be assigned a number that is unique that the user can select.
task_template_assignment_KEYTask_Template_Assignmentint
task_template_KEYHistory_Of_Taskint
task_template_KEYTaskintThe linked [Task_Template].
task_template_KEYTask_Templateint
task_template_KEYTask_Template_AssignmentintWhich task template this assignment is for.
tax_area_KEYEngagementintKey to a Tax Area record.
tax_area_KEYHistory_Of_Engagementint
tax_area_KEYTax_AreaintAUTO-INCREMENT: Database assigned primary key for this table.
tax_area_KEYTax_Area_Taxing_AuthorityintKEY value from the Tax Area table.
tax_area_taxing_authority_KEYTax_Area_Taxing_Authorityint
tax_gl_accountGL_Entry_Export_Optionnvarchar (60)
tax_yearClient_Financial_Dataint
tax_yearHistory_Of_Client_Financial_Dataint
taxing_authority_KEYBilling_Decision_Tax_CollectionintThe combination of ledger_entry_KEY, sheet_entry_KEY and taxing_authority_KEY identifies the BDTA row this collection is for.
taxing_authority_KEYBilling_Decision_Taxing_AuthorityintKey to the Taxing Authority that this tax is charged for.
taxing_authority_KEYTax_Area_Taxing_AuthorityintKEY value from the Tax Authority table.
taxing_authority_KEYTaxing_AuthorityintAUTO-INCREMENT: Database assigned primary key for this table.
taxing_authority_type_KEYTaxing_AuthorityintThe type of tax that this authority is authorized to tax.
term_KEYTermintHardcoded primary key.
textRecorded_Eventnvarchar (-1)Summary of what happened in a format suitable for reporting, viewing in a portlet, and so on.
this_data_pathFirmnvarchar (260)
ticket_guidLogin_TicketuniqueidentifierAn identifier for the ticket, randomly generated.
time_amount_adjustedInvoicedecimal (17, 2)Denormalized
time_amount_billedIntegration_Invoicedecimal (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_billedInvoicedecimal (17, 2)Denormalized
time_expense__gl_entry_export_bill_amount_basis_KEYGL_Entry_Export_Optionint
time_expense_gl_accountGL_Entry_Export_Optionnvarchar (60)
time_zone_base_utc_offsetHistory_Of_Time_Zoneint
time_zone_base_utc_offsetTime_ZoneintGets the time difference between this time zone's standard time and Coordinated Universal Time (UTC) in minutes.
time_zone_identifierHistory_Of_Time_Zonenvarchar (200)
time_zone_identifierTime_Zonenvarchar (200)The time zone identifier from Windows (for example from the System.TimeZoneInfo.Id property).
time_zone_KEYContactsmallint (5)The preferred timezone for the contact. Use this when displaying time to the user and the time zone is not known.
time_zone_KEYHistory_Of_Contactsmallint (5)
time_zone_KEYHistory_Of_Time_Zonesmallint (5)
time_zone_KEYTime_Zonesmallint (5)
timed_outLedger_Entry_Submittal_ResultbitWhether or not we gave up waiting for a response from Intercept.
timer_KEYHistory_Of_Timerint
timer_KEYTimerintAssigned by COMMON_dp_Allocate_Unique_Identifiers. Primary key for this table.
timer_start_utcHistory_Of_Timerdatetime
timer_start_utcTimerdatetimeThe date and time this timer was started in UTC.
tinIntegration_Invoicenvarchar (11)TIN of the client the invoice is for.
titleContactnvarchar (250)Title of the contact.
titleFeed_Channelnvarchar (500)
titleFeed_Channel_Itemnvarchar (500)
titleFeed_Channel_Item_Enclosurenvarchar (500)
titleHistory_Of_Contactnvarchar (250)
to__ledger_entry_KEYLedger_Entry_ApplicationintThe Ledger Entry that amount_applied is added to.
to_dayBenefit_FactorintThe end day of this benefit factor.
to_monthAccruable_Benefit_Allowance_By_MonthintThe month to which this allowance applies.
to_monthBenefit_FactorintThe end month of this benefit factor.
to_valueFilter_Linenvarchar (100)The greater of the two values.
total_amount_billedIntegration_Invoicedecimal (17, 2)Total amount of WIP billed by the invoice.
total_file_sizeFile_Transferintsum of file sizes of files associated to this File Transfer
total_file_sizeHistory_Of_File_Transferint
tracking_description_KEYHistory_Of_Schedule_Itemint
tracking_description_KEYProject_TemplateintKey to a Tracking Description that will be used for generated projects.
tracking_description_KEYSchedule_ItemintThe linked [Tracking_Description].
tracking_description_KEYTask_Templateint
tracking_description_KEYTracking_DescriptionintAUTO-INCREMENT: Database assigned primary key for this table.
transaction_idChangeset_Activebigint (19)The SQL Server transaction_id from sys.dm_tran_current_transaction.
transactionidLedger_Entry_Submittal_Resultnvarchar (60)Contents of the transactionid field in the response returned by Intercept.
tree_levelPrivilegeintThe level in the tree.
typeFeed_Channel_Item_Enclosurenvarchar (30)
TYPE_NAMECOMMON_Metadata_About_Columnsnvarchar (128)
unapplied_receipts_gl_accountGL_Entry_Export_Optionnvarchar (60)
unit_costActivitydecimal (9, 4)Cost per unit for expense, 0.0000 for time.
unit_costHistory_Of_Sheet_Entrydecimal (9, 4)
unit_costIntegration_Sheet_Entrydecimal (9, 4)Cost per unit (or hour) at the time the amount was computed.
unit_costSheet_Entrydecimal (9, 4)Cost per unit (or hour) at the time the amount was computed.
unit_priceActivitydecimal (9, 4)Price per unit for expense, price per hour for time when rate_type_KEY=3 or 0.0000 otherwise.
unit_priceHistory_Of_Sheet_Entrydecimal (9, 4)
unit_priceIntegration_Sheet_Entrydecimal (9, 4)Price per unit (or hour) at the time the amount was computed. Storage is required because amount can be rounded.
unit_priceSheet_Entrydecimal (9, 4)Price per unit (or hour) at the time the amount was computed. Storage is required because amount can be rounded.
unitsHistory_Of_Sheet_Entrydecimal (9, 2)
unitsIntegration_Sheet_Entrydecimal (9, 2)Quantity of units (or hours).
unitsSheet_Entrydecimal (9, 2)Quantity of units (or hours).
units_closedBilling_Decisiondecimal (9, 2)Sheet Entry units closed out by this billing. wip_closed = bill_amount - adjustment.
update__changeset_KEYAdditional_Contactint
update__changeset_KEYAttachmentint
update__changeset_KEYAttachment_Contentint
update__changeset_KEYCalendar_Categoryint
update__changeset_KEYClientint
update__changeset_KEYClient_Financial_Dataint
update__changeset_KEYClient_Financial_Data_Descriptionint
update__changeset_KEYClient_Staff_Groupingint
update__changeset_KEYContactint
update__changeset_KEYContact_Addressint
update__changeset_KEYContact_Categoryint
update__changeset_KEYContact_Contact_Categoryint
update__changeset_KEYContact_Emailint
update__changeset_KEYContact_Phoneint
update__changeset_KEYCustom_Chartint
update__changeset_KEYCustom_Fieldint
update__changeset_KEYCustom_Valueint
update__changeset_KEYDigita_Vat_Periodint
update__changeset_KEYEngagementint
update__changeset_KEYFile_Transferint
update__changeset_KEYFile_Transfer_Eventint
update__changeset_KEYFile_Transfer_Fileint
update__changeset_KEYHistory_Of_Additional_Contactint
update__changeset_KEYHistory_Of_Attachmentint
update__changeset_KEYHistory_Of_Attachment_Contentint
update__changeset_KEYHistory_Of_Calendar_Categoryint
update__changeset_KEYHistory_Of_Clientint
update__changeset_KEYHistory_Of_Client_Financial_Dataint
update__changeset_KEYHistory_Of_Client_Financial_Data_Descriptionint
update__changeset_KEYHistory_Of_Client_Staff_Groupingint
update__changeset_KEYHistory_Of_Contactint
update__changeset_KEYHistory_Of_Contact_Addressint
update__changeset_KEYHistory_Of_Contact_Categoryint
update__changeset_KEYHistory_Of_Contact_Contact_Categoryint
update__changeset_KEYHistory_Of_Contact_Emailint
update__changeset_KEYHistory_Of_Contact_Phoneint
update__changeset_KEYHistory_Of_Custom_Chartint
update__changeset_KEYHistory_Of_Custom_Fieldint
update__changeset_KEYHistory_Of_Custom_Valueint
update__changeset_KEYHistory_Of_Digita_Vat_Periodint
update__changeset_KEYHistory_Of_Engagementint
update__changeset_KEYHistory_Of_File_Transferint
update__changeset_KEYHistory_Of_File_Transfer_Eventint
update__changeset_KEYHistory_Of_File_Transfer_Fileint
update__changeset_KEYHistory_Of_Linkint
update__changeset_KEYHistory_Of_Link_Groupint
update__changeset_KEYHistory_Of_Portal_Userint
update__changeset_KEYHistory_Of_Projectint
update__changeset_KEYHistory_Of_Project_Extensionint
update__changeset_KEYHistory_Of_Schedule_Entryint
update__changeset_KEYHistory_Of_Schedule_Itemint
update__changeset_KEYHistory_Of_Schedule_Item_Assignmentint
update__changeset_KEYHistory_Of_Schedule_Item_Budget_Remaining_Entryint
update__changeset_KEYHistory_Of_Schedule_Item_Seriesint
update__changeset_KEYHistory_Of_Sheet_Entryint
update__changeset_KEYHistory_Of_Tagint
update__changeset_KEYHistory_Of_Tagged_Itemint
update__changeset_KEYHistory_Of_Taskint
update__changeset_KEYHistory_Of_Time_Zoneint
update__changeset_KEYHistory_Of_Timerint
update__changeset_KEYLinkint
update__changeset_KEYLink_Groupint
update__changeset_KEYPortal_Userint
update__changeset_KEYProjectint
update__changeset_KEYProject_Extensionint
update__changeset_KEYSchedule_Entryint
update__changeset_KEYSchedule_Itemint
update__changeset_KEYSchedule_Item_Assignmentint
update__changeset_KEYSchedule_Item_Budget_Remaining_Entryint
update__changeset_KEYSchedule_Item_Seriesint
update__changeset_KEYSheet_Entryint
update__changeset_KEYTagint
update__changeset_KEYTagged_Itemint
update__changeset_KEYTaskint
update__changeset_KEYTime_Zoneint
update__changeset_KEYTimerint
update__staff_KEYAccruable_Benefitint
update__staff_KEYAccruable_Benefit_Allowance_By_Monthint
update__staff_KEYAccruable_Benefit_Allowance_By_Staff_Levelint
update__staff_KEYActive_Filterint
update__staff_KEYActivityint
update__staff_KEYActivity_Categoryint
update__staff_KEYAdditional_Contactint
update__staff_KEYAddressint
update__staff_KEYBank_Accountint
update__staff_KEYBenefitint
update__staff_KEYBenefit_Factorint
update__staff_KEYBilling_Decisionint
update__staff_KEYBilling_Decision_Collectionint
update__staff_KEYBilling_Decision_Tax_Collectionint
update__staff_KEYBilling_Decision_Taxing_Authorityint
update__staff_KEYBilling_Rate_Typeint
update__staff_KEYClientint
update__staff_KEYClient_Shortcutint
update__staff_KEYClient_Shortcut_Groupint
update__staff_KEYClient_Status_Eventint
update__staff_KEYContactint
update__staff_KEYContact_Addressint
update__staff_KEYContact_Categoryint
update__staff_KEYContact_Contact_Categoryint
update__staff_KEYContact_Emailint
update__staff_KEYContact_Phoneint
update__staff_KEYCredit_Cardint
update__staff_KEYCustom_Fieldviewint
update__staff_KEYCustom_Fieldview_Typeint
update__staff_KEYCustom_Formulaint
update__staff_KEYCustom_Groupingint
update__staff_KEYCustom_Portletint
update__staff_KEYDashboard_LayoutintKey of Staff who last modified this row. This Staff is considered to be the owner of this dashboard layout.
update__staff_KEYDatabase_Propertyint
update__staff_KEYDepartmentint
update__staff_KEYEducation_Creditint
update__staff_KEYEducation_Sponsorint
update__staff_KEYEngagementint
update__staff_KEYEngagement_Templateint
update__staff_KEYEngagement_Typeint
update__staff_KEYEntityint
update__staff_KEYFeed_Channelint
update__staff_KEYFeed_Channel_Itemint
update__staff_KEYFeed_Channel_Item_Enclosureint
update__staff_KEYFeed_Channel_Item_Staff_Readint
update__staff_KEYFeed_Portletint
update__staff_KEYFilterint
update__staff_KEYFilter_Base_Typeint
update__staff_KEYFilter_Lineint
update__staff_KEYFilter_Line_Typeint
update__staff_KEYFilter_Range_Typeint
update__staff_KEYFilter_Selectint
update__staff_KEYFilter_Typeint
update__staff_KEYFirmint
update__staff_KEYFirm_Dateint
update__staff_KEYFirm_Shortcutint
update__staff_KEYFirm_Shortcut_Groupint
update__staff_KEYGL_Entry_Export_Optionint
update__staff_KEYHistory_Of_Projectint
update__staff_KEYHistory_Of_Project_Extensionint
update__staff_KEYHistory_Of_Schedule_Itemint
update__staff_KEYHistory_Of_Schedule_Item_Assignmentint
update__staff_KEYHistory_Of_Schedule_Item_Budget_Remaining_Entryint
update__staff_KEYHistory_Of_Schedule_Item_Seriesint
update__staff_KEYHistory_Of_Taskint
update__staff_KEYIntegration_Applicationint
update__staff_KEYIntegration_Custom_Valueint
update__staff_KEYIntegration_Invoiceint
update__staff_KEYIntegration_Invoice_Prior_Paymentint
update__staff_KEYIntegration_Sheet_Entryint
update__staff_KEYInteraction_Linkint
update__staff_KEYInvoiceint
update__staff_KEYLedger_Entryint
update__staff_KEYLedger_Entry_Applicationint
update__staff_KEYLedger_Entry_Service_Chargeint
update__staff_KEYLedger_Entry_Submittalint
update__staff_KEYLinkint
update__staff_KEYLink_Groupint
update__staff_KEYLost_Reasonint
update__staff_KEYLost_Toint
update__staff_KEYMonitored_Eventint
update__staff_KEYMonitored_Event_Actionint
update__staff_KEYObserved_Holidayint
update__staff_KEYOfficeint
update__staff_KEYOnline_Invoiceint
update__staff_KEYOnline_Paymentint
update__staff_KEYOutlook_Contact_Synchronization_Folderint
update__staff_KEYOutlook_Contact_Synchronization_Profileint
update__staff_KEYPractice_Userint
update__staff_KEYPrint_Optionint
update__staff_KEYProjectint
update__staff_KEYProject_Extensionint
update__staff_KEYProject_Templateint
update__staff_KEYProject_Template_Assignmentint
update__staff_KEYProject_Template_Definitionint
update__staff_KEYProject_Template_Definition_Extensionint
update__staff_KEYProject_Template_Definition_Importedint
update__staff_KEYProject_Template_Entityint
update__staff_KEYProject_Template_Extensionint
update__staff_KEYRecorded_Eventint
update__staff_KEYRecurring_Billint
update__staff_KEYReferral_Sourceint
update__staff_KEYReport_Definitionint
update__staff_KEYReport_Definition_Security_Groupint
update__staff_KEYReport_Profileint
update__staff_KEYReport_Profile_Report_Definitionint
update__staff_KEYSchedule_Itemint
update__staff_KEYSchedule_Item_Assignmentint
update__staff_KEYSchedule_Item_Budget_Remaining_EntryintKey of Staff who last modified this row.
update__staff_KEYSchedule_Item_SeriesintKey of Staff who last modified this row.
update__staff_KEYSecurity_Groupint
update__staff_KEYService_Chargeint
update__staff_KEYSheet_Entryint
update__staff_KEYStaffint
update__staff_KEYStaff_Area_Ratingint
update__staff_KEYStaff_Benefitint
update__staff_KEYStaff_Benefit_Entryint
update__staff_KEYStaff_Billing_Rateint
update__staff_KEYStaff_Levelint
update__staff_KEYStaff_Locatorint
update__staff_KEYStaff_Rate_Tableint
update__staff_KEYStaff_Report_Definitionint
update__staff_KEYStaff_Security_Groupint
update__staff_KEYStaff_Shortcutint
update__staff_KEYStaff_Shortcut_Groupint
update__staff_KEYStaff_Skill_Areaint
update__staff_KEYStaff_Skill_Ratingint
update__staff_KEYStandard_Textint
update__staff_KEYStatus_Eventint
update__staff_KEYStatus_Event_Typeint
update__staff_KEYTaskint
update__staff_KEYTask_Templateint
update__staff_KEYTask_Template_Assignmentint
update__staff_KEYTax_Areaint
update__staff_KEYTax_Area_Taxing_Authorityint
update__staff_KEYTaxing_Authorityint
update__staff_KEYTermint
update__staff_KEYTimerint
update__staff_KEYTracking_Descriptionint
update__staff_KEYUser_Preferenceint
update__staff_KEYWeb_Page_Portletint
update__staff_KEYWon_Reasonint
update_data_change_log_KEYUpdate_Data_Change_Logint
update_dateFilterdatetime
update_dateFilter_Base_Typedatetime
update_dateFilter_Linedatetime
update_dateFilter_Line_Typedatetime
update_dateFilter_Range_Typedatetime
update_dateFilter_Selectdatetime
update_dateFilter_Typedatetime
update_dateUpdate_Data_Version_Historydatetime
update_date_utcAccruable_Benefitdatetime
update_date_utcAccruable_Benefit_Allowance_By_Monthdatetime
update_date_utcAccruable_Benefit_Allowance_By_Staff_Leveldatetime
update_date_utcActive_Filterdatetime
update_date_utcActivitydatetime
update_date_utcActivity_Categorydatetime
update_date_utcAddressdatetime
update_date_utcBank_Accountdatetime
update_date_utcBenefitdatetime
update_date_utcBenefit_Factordatetime
update_date_utcBilling_Decisiondatetime
update_date_utcBilling_Decision_Collectiondatetime
update_date_utcBilling_Decision_Tax_Collectiondatetime
update_date_utcBilling_Decision_Taxing_Authoritydatetime
update_date_utcBilling_Rate_Typedatetime
update_date_utcClient_Shortcutdatetime
update_date_utcClient_Shortcut_Groupdatetime
update_date_utcClient_Status_Eventdatetime
update_date_utcContactdatetime
update_date_utcContact_Addressdatetime
update_date_utcContact_Emaildatetime
update_date_utcContact_Phonedatetime
update_date_utcCredit_Carddatetime
update_date_utcCustom_Fieldviewdatetime
update_date_utcCustom_Fieldview_Typedatetime
update_date_utcCustom_Formuladatetime
update_date_utcCustom_Groupingdatetime
update_date_utcCustom_Portletdatetime
update_date_utcDashboard_Layoutdatetime
update_date_utcDatabase_Propertydatetime
update_date_utcDepartmentdatetime
update_date_utcEducation_Creditdatetime
update_date_utcEducation_Sponsordatetime
update_date_utcEngagement_Templatedatetime
update_date_utcEngagement_Typedatetime
update_date_utcEntitydatetime
update_date_utcFeed_Channeldatetime
update_date_utcFeed_Channel_Itemdatetime
update_date_utcFeed_Channel_Item_Enclosuredatetime
update_date_utcFeed_Channel_Item_Staff_Readdatetime
update_date_utcFeed_Portletdatetime
update_date_utcFirmdatetime
update_date_utcFirm_Datedatetime
update_date_utcFirm_Shortcutdatetime
update_date_utcFirm_Shortcut_Groupdatetime
update_date_utcGL_Entry_Export_Optiondatetime
update_date_utcIntegration_Applicationdatetime
update_date_utcIntegration_Custom_Valuedatetime
update_date_utcIntegration_Invoicedatetime
update_date_utcIntegration_Invoice_Prior_Paymentdatetime
update_date_utcIntegration_Sheet_Entrydatetime
update_date_utcInteraction_Linkdatetime
update_date_utcInvoicedatetime
update_date_utcLast_Table_Modificationdatetime
update_date_utcLedger_Entrydatetime
update_date_utcLedger_Entry_Applicationdatetime
update_date_utcLedger_Entry_Service_Chargedatetime
update_date_utcLedger_Entry_Submittaldatetime
update_date_utcLost_Reasondatetime
update_date_utcLost_Todatetime
update_date_utcMonitored_Eventdatetime
update_date_utcMonitored_Event_Actiondatetime
update_date_utcObserved_Holidaydatetime
update_date_utcOfficedatetime
update_date_utcOnline_Invoicedatetime
update_date_utcOnline_Paymentdatetime
update_date_utcOutlook_Contact_Synchronization_Folderdatetime
update_date_utcOutlook_Contact_Synchronization_Profiledatetime
update_date_utcPractice_Userdatetime
update_date_utcPrint_Optiondatetime
update_date_utcProject_Templatedatetime
update_date_utcProject_Template_Assignmentdatetime
update_date_utcProject_Template_Definitiondatetime
update_date_utcProject_Template_Definition_Extensiondatetime
update_date_utcProject_Template_Definition_Importeddatetime
update_date_utcProject_Template_Entitydatetime
update_date_utcProject_Template_Extensiondatetime
update_date_utcRecorded_Event_Notificationdatetime
update_date_utcRecurring_Billdatetime
update_date_utcReferral_Sourcedatetime
update_date_utcReport_Definitiondatetime
update_date_utcReport_Definition_Security_Groupdatetime
update_date_utcReport_Profiledatetime
update_date_utcReport_Profile_Report_Definitiondatetime
update_date_utcSchedule_Itemdatetime
update_date_utcSecurity_Groupdatetime
update_date_utcService_Chargedatetime
update_date_utcStaffdatetime
update_date_utcStaff_Area_Ratingdatetime
update_date_utcStaff_Benefitdatetime
update_date_utcStaff_Benefit_Entrydatetime
update_date_utcStaff_Billing_Ratedatetime
update_date_utcStaff_Leveldatetime
update_date_utcStaff_LocatordatetimeDate and time this record was last updated in UTC.
update_date_utcStaff_Rate_Tabledatetime
update_date_utcStaff_Report_Definitiondatetime
update_date_utcStaff_Security_Groupdatetime
update_date_utcStaff_Shortcutdatetime
update_date_utcStaff_Shortcut_Groupdatetime
update_date_utcStaff_Skill_Areadatetime
update_date_utcStaff_Skill_Ratingdatetime
update_date_utcStandard_Textdatetime
update_date_utcStatus_Eventdatetime
update_date_utcStatus_Event_Typedatetime
update_date_utcTask_Templatedatetime
update_date_utcTask_Template_Assignmentdatetime
update_date_utcTax_Areadatetime
update_date_utcTax_Area_Taxing_Authoritydatetime
update_date_utcTaxing_Authoritydatetime
update_date_utcTermdatetime
update_date_utcTracking_Descriptiondatetime
update_date_utcUpdate_Data_Change_Logdatetime
update_date_utcUser_Preferencedatetime
update_date_utcUser_Session_Patterndatetime
update_date_utcWeb_Page_Portletdatetime
update_date_utcWon_Reasondatetime
upper_date_exclusiveStaff_Target_RangesmalldatetimeThis is the important date - this is the date that the next range begins and therefore where this ends.
upper_date_utcSchedule_Item_Date_Indexdatetime
urgent__filter_KEYUser_PreferenceintKEY of the filter used to narrow the schedule items to be displayed in the urgent tab
urgent_due_within_unassignedUser_PreferencebitWhen 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_daysUser_PreferenceintWhen 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_unscheduledUser_PreferencebitWhen 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_daysUser_PreferenceintWhen 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_unassignedUser_PreferencebitWhen true the urgent tab includes high priority schedule items with no schedule item assignments
urgent_high_priority_unscheduledUser_PreferencebitWhen true the urgent tab includes high priority schedule items with no schedule entries
urgent_overscheduledUser_PreferencebitWhen 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_dueUser_PreferencebitWhen true the urgent tab includes schedule items that are past due
urgent_tab_enabledUser_PreferencebitWhen true the urgent tab will be displayed in scheduling screens
urgent_target_start_past_unassignedUser_PreferencebitWhen 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_unscheduledUser_PreferencebitWhen true the urgent tab includes schedule items where the target start date has past and does not have any schedule entries
urlContactnvarchar (2048)Website address.
urlFeed_Channelnvarchar (2048)
urlFeed_Channel_Itemnvarchar (2048)
urlFeed_Channel_Item_Enclosurenvarchar (2048)
urlHistory_Of_Contactnvarchar (2048)
urlWeb_Page_Portletnvarchar (2048)
use_accounts_receivable_limitClientbitDetermines whether the accounts receivable limit is enforced.
use_accounts_receivable_limitHistory_Of_Clientbit
use_maximum_carryoverBenefitbitDetermines whether the maximum carryover amount is enforced.
use_maximum_chargeService_ChargebitDetermines whether the maximum charge is enforced.
use_wip_limitClientbitDetermines whether the WIP limit is enforced.
use_wip_limitHistory_Of_Clientbit
user_nameChangesetnvarchar (128)The application user name if known.
user_nameClient_Status_Eventnvarchar (30)The name of the user that recorded the event.
user_nameHistory_Of_Timernvarchar (50)
user_nameIntegration_Invoicenvarchar (30)User name of the person who triggered the export.
user_nameStaffnvarchar (30)The name used on the login screen.
user_nameTimernvarchar (50)The name of the user that started the timer.
user_nameUpdate_Data_Version_Historynvarchar (11)
user_nameUser_Session_Patternnvarchar (11)
user_preference_KEYUser_PreferenceintAUTO-INCREMENT: Database assigned primary key for this table.
user_preference_KEYUser_Preference_Custom_Field_ColumnintKey of the User Preference that this entry is for
user_session_guidUser_SessionuniqueidentifierA database generated unique key for this table.
user_session_pattern_guidChangesetuniqueidentifierReference to other information known about a user session.
user_session_pattern_guidUser_SessionuniqueidentifierKey to the User_Session_Pattern table.
user_session_pattern_guidUser_Session_Patternuniqueidentifier
user_session_status_KEYUser_SessionintThe status of this session (1=Open, 2=Closed, 3=Expired, 4=Killed)
user_visibleUpdate_Data_Change_Logvarchar (1)
valid_dateValid_DatesmalldatetimeHolds a date without a time set (stored as midnight.)
valid_date_KEYValid_DateintKey for backwards compatibility. Should be the number of days since 1989-12-31.
versionCustom_Chartnvarchar (19)The version of the custom chart.
versionCustom_Formulanvarchar (19)The version of the custom formula.
versionHistory_Of_Custom_Chartnvarchar (19)
versionUpdate_Data_Change_Lognvarchar (19)
versionUpdate_Data_Version_Historynvarchar (19)
web_page_portlet_KEYWeb_Page_Portletint
windows_user_nameChangesetnvarchar (128)The operating system user name if known.
windows_user_nameUpdate_Data_Version_Historynvarchar (50)
windows_user_nameUser_Session_Patternnvarchar (50)
wip_limitClientdecimal (17, 2)WIP limit.
wip_limitHistory_Of_Clientdecimal (17, 2)
with__contact_KEYHistory_Of_Schedule_Itemint
with__contact_KEYSchedule_ItemintFor scheduled phone calls, the contact that is to be called.
won_dateClientsmalldatetimeThe date this client was won.
won_dateHistory_Of_Clientsmalldatetime
won_reason_KEYClientintKey to a Won Reason record.
won_reason_KEYHistory_Of_Clientint
won_reason_KEYWon_ReasonintAUTO-INCREMENT: Database assigned primary key for this table.
workflowGofileroom_Workflownvarchar (255)GoFileRoom workflow template description of this workflow.
workflow_descriptionGofileroom_Workflownvarchar (255)GoFileRoom workflow description of this workflow.
workflow_idGofileroom_WorkflowintOne of four required fields that uniquely identify a workflow, not intended to be viewed by users.
workflow_template_idGofileroom_WorkflowintOne of four required fields that uniquely identify a workflow, not intended to be viewed by users.
workflow_yearGofileroom_Workflownvarchar (255)GoFileRoom year of this workflow.
write_off_gl_accountGL_Entry_Export_Optionnvarchar (60)
year_begin_dateFirmsmalldatetime
year_end_dateFirmsmalldatetime