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 | 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 (50) | NOT NULL |
name_2 | nvarchar (50) | NOT NULL |
engagement_KEY | int | NOT NULL | Key from the engagement that will be used as a default for new clients that are entered.
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 | 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 |

Primary key
Name | Columns | Description
PK_Firm$firm_KEY | firm_KEY | CLUSTERED
Indexes
Name | Columns | Description
IX_Firm$engagement_KEY | engagement_KEY | Index supports foreign key FK_Firm__Engagement__engagement_KEY
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

Foreign keys
Name | Columns | Referenced table | Description
FK_Firm__Engagement__engagement_KEY | engagement_KEY | Engagement |
FK_Firm__Office__office_KEY | office_KEY | Office |
FK_Firm__Report_Definition__invoice__report_definition_KEY | invoice__report_definition_KEY | Report_Definition |
FK_Firm__Report_Definition__statement__report_definition_KEY | statement__report_definition_KEY | Report_Definition |
FK_Firm__Service_Charge__service_charge_KEY | service_charge_KEY | Service_Charge |

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 |