Table: Firm | |||
Columns | |||
Name | Type | Constraints | Description |
firm_KEY | int | NOT NULL | Database assigned primary key for this table. |
update__staff_KEY | int | NOT NULL | |
update_date_utc | datetime | NOT NULL | |
CSI_firm_ID | int | NOT NULL | |
firm_alias | nvarchar (50) | NOT NULL | |
security_enabled | bit | NOT NULL | |
remember_logon_allowed | bit | NOT NULL | |
office_KEY | int | NOT NULL | Key from the main office. |
name_1 | nvarchar (250) | NOT NULL | |
name_2 | nvarchar (250) | NOT NULL | |
federal_tin | nvarchar (11) | NOT NULL | This field will hold the Fed Tax ID of the firm. |
days_to_due_date | int | NOT NULL | Number of days to use in calculating due dates. |
assess_service_charge | bit | NOT NULL | Default for new clients. |
service_charge_KEY | int | Key to a Service Charge record. | |
require_sheet_approval | bit | NOT NULL | True if the approval and posting process is required for Time and Expense Entry. |
require_billing_approval | bit | NOT NULL | True if the approval and posting process is required for Billing. |
require_receipt_approval | bit | NOT NULL | True if the approval and posting process is required for Receipt Entry. |
period_begin_date | smalldatetime | NOT NULL | |
period_end_date | smalldatetime | NOT NULL | |
year_begin_date | smalldatetime | NOT NULL | |
year_end_date | smalldatetime | NOT NULL | |
accounts_receivable_dunning_1 | nvarchar (-1) | NOT NULL | Dunning message to print when the oldest outstanding item is 1 period old. |
accounts_receivable_dunning_2 | nvarchar (-1) | NOT NULL | Dunning message to print when the oldest outstanding item is 2 periods old. |
accounts_receivable_dunning_3 | nvarchar (-1) | NOT NULL | Dunning message to print when the oldest outstanding item is 3 periods old. |
accounts_receivable_dunning_4 | nvarchar (-1) | NOT NULL | Dunning message to print when the oldest outstanding item is 4 periods old. |
accounts_receivable_dunning_5 | nvarchar (-1) | NOT NULL | Dunning message to print when the oldest outstanding item is 5 or more periods old. |
accounts_receivable_terms | nvarchar (-1) | NOT NULL | Payment terms included on invoices and statements. |
this_data_path | nvarchar (260) | NOT NULL | |
invoice__report_definition_KEY | int | NOT NULL | Default invoice format for new clients. |
statement__report_definition_KEY | int | NOT NULL | Default statement format for new clients |
create_date_utc | datetime | NOT NULL | |
enable_credit_card_processing | bit | NOT NULL | Whether or not Credit Card Processing is enabled. |
index_email | bit | NOT NULL | True to index email |
invoice_email_subject | nvarchar (255) | NOT NULL | |
statement_email_subject | nvarchar (255) | NOT NULL | |
invoice_email_body | nvarchar (-1) | NOT NULL | |
statement_email_body | nvarchar (-1) | NOT NULL | |
gofileroom_configuration | nvarchar (-1) | NOT NULL | Contains GoFileRoom integration configuration data in an xml format. |
benefit_year_begin_date | smalldatetime | NOT NULL | Begin date of the benefit year. |
benefit_year_end_date | smalldatetime | NOT NULL | End date of the benefit year. |
online_bill_pay_enabled | bit | NOT NULL | Determines whether invoices can be sent to the online bill pay service. |
enable_ach_processing | bit | NOT NULL | Whether or not Ach Processing is enabled. |
invoice_reference_number_layout | nvarchar (-1) | NOT NULL | The XML layout for an invoice reference number. |
create_portals_for_new_clients | bit | NOT NULL | Automatically create NetClient CS portals for new Clients |
create_portals_for_new_prospects | bit | NOT NULL | Automatically create NetClient CS portals for new Prospects |
create_portals_for_new_staff | bit | NOT NULL | Automatically create NetStaff CS portals for new Staff |
create_file_cabinet_folder_for_new_clients | bit | NOT NULL | Automatically create FileCabinet folder for new clients |
file_cabinet_data_location_for_new_clients | nvarchar (2048) | NOT NULL | Data path of the FileCabinet in which to create a FileCabinet folder for new clients |
require_entry_project | bit | NOT NULL | |
relieve_nonbillable_wip | bit | NOT NULL | |
phone_number_format | nvarchar (30) | NOT NULL | |
currency_symbol | nvarchar (3) | NOT NULL | Symbol to use for currency values. |
currency_decimal_digits | smallint (5) | NOT NULL | Number of digits to support on currency values. |
digita_integration_config | nvarchar (-1) | NOT NULL | The digita integration config is a block of xml (serialized object) which describes the configuration of digita integration. |
separate_zero_invoice_numbering | bit | NOT NULL | Use separate invoice numbering sequence for zero amounts. |
digita_using_continuous_supply | bit | NOT NULL | The digita using continuous supply field is a flag which specifies whether or not the user is using continuous supply of service. |
Primary key | |||
Name | Columns | Description | |
PK_Firm$firm_KEY | firm_KEY | CLUSTERED | |
Indexes | |||
Name | Columns | Description | |
IX_Firm$invoice__report_definition_KEY | invoice__report_definition_KEY | Index supports foreign key FK_Firm__Report_Definition__invoice__report_definition_KEY | |
IX_Firm$office_KEY | office_KEY | ||
IX_Firm$service_charge_KEY | service_charge_KEY | Index supports foreign key FK_Firm__Service_Charge__service_charge_KEY | |
IX_Firm$statement__report_definition_KEY | statement__report_definition_KEY | Index supports foreign key FK_Firm__Report_Definition__statement__report_definition_KEY |
Incoming foreign keys | |||
Name | Columns | Referencing table | Description |
FK_Firm_Dashboard_Layout__Firm__firm_KEY | firm_KEY | Firm_Dashboard_Layout | |
FK_GL_Entry_Export_Option__Firm__firm_KEY | firm_KEY | GL_Entry_Export_Option | |
FK_Outlook_Index_Folder_Firm__Firm__firm_KEY | firm_KEY | Outlook_Index_Folder_Firm |