Table: dbo.GL_Account
Columns
NameTypeConstraintsDescription
gl_account_KEYint (4)NOT NULLPrimary key for this table.
client_KEYint (4)NOT NULLKey of client that owns the account.
descriptionnvarchar (240)NOT NULLAccount description.
gl_account_numbernvarchar (120)NOT NULLThe GL account number constructed from releveant account segments and their seperators.
segment1nvarchar (120)NOT NULLAccount segment 1.
segment2nvarchar (120)NOT NULLAccount segment 2.
segment3nvarchar (120)NOT NULLAccount segment 3.
segment4nvarchar (120)NOT NULLAccount segment 4.
segment5nvarchar (120)NOT NULLAccount segment 5.
segment6nvarchar (120)NOT NULLAccount segment 6.
segment7nvarchar (120)NOT NULLAccount segment 7.
segment8nvarchar (120)NOT NULLAccount segment 8.
segment9nvarchar (120)NOT NULLAccount segment 9.
segment10nvarchar (120)NOT NULLAccount segment 10.
segment11nvarchar (120)NOT NULLAccount segment 11.
segment12nvarchar (120)NOT NULLAccount segment 12.
segment13nvarchar (120)NOT NULLAccount segment 13.
segment14nvarchar (120)NOT NULLAccount segment 14.
segment15nvarchar (120)NOT NULLAccount segment 15.
segment16nvarchar (120)NOT NULLAccount segment 16.
segment17nvarchar (120)NOT NULLAccount segment 17.
segment18nvarchar (120)NOT NULLAccount segment 18.
segment19nvarchar (120)NOT NULLAccount segment 19.
segment20nvarchar (120)NOT NULLAccount segment 20.
is_activebit (1)NOT NULL
gl_account_guiduniqueidentifier (16)NOT NULLA unique GUID key for this row.
export__quick_books_account_KEYint (4)A foreign key to the Quick_Books_Account table, this is the quickbooks side of the mapping during the Acs to Quickbooks export data mapping process. This will be used to map Accounting CS gl accounts to QuickBooks GL accounts. This key will be null if no export mapping has been done.
gl_account_number_sortablenvarchar (244)NOT NULLA padded GL account number that allows the Chart of Accounts to be ordered numerically. This computed column will be kept up-to-date with changes made to the GL account number.
restrict_from_client_accessbit (1)NOT NULLTo restrict GL Account from Client Access. By default it will not restrict.["BR"] When column restrict_from_client_access is true then the GL account will not appear["BR"] on the Chart of Accounts screen and in any GL account dropdowns for client access.
Primary key
NameColumnsDescription
PK_GL_Accountgl_account_KEY
Unique constraints
NameColumnsDescription
UK_GL_Account$client_KEY$gl_account_KEYclient_KEY, gl_account_KEY
UK_GL_Account$gl_account_guidgl_account_guid
Foreign keys
NameColumnsReferenced tableDescription
FK_GL_Account__Client__client_KEYclient_KEYClient (client_KEY)
FK_GL_Account__Quick_Books_Account__export__quick_books_account_KEYexport__quick_books_account_KEYQuick_Books_Account (quick_books_account_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Spreadsheet_Import_Account__GL_Account__gl_account_KEYgl_account_KEYSpreadsheet_Import_Account
FK_Client_AP_Setup__GL_Account__ap__gl_account_KEYap__gl_account_KEYClient_AP_Setup
FK_Client_AP_Setup__GL_Account__ap_discount__gl_account_KEYap_discount__gl_account_KEYClient_AP_Setup
FK_Receivable_Transaction_Detail__GL_Account__gl_account_KEYgl_account_KEYReceivable_Transaction_Detail
FK_Receivable_Transaction_Detail__GL_Account__receivable__gl_account_KEYreceivable__gl_account_KEYReceivable_Transaction_Detail
FK_Client_Undistributed_GL_Account__GL_Account__gl_account_KEYgl_account_KEYClient_Undistributed_GL_Account
FK_Payable_Transaction_Template_Distribution__GL_Account__gl_account_KEYgl_account_KEYPayable_Transaction_Template_Distribution
FK_GL_Account_Segment_Code_Rounding_Account__GL_Account__asset__gl_account_KEYasset__gl_account_KEYGL_Account_Segment_Code_Rounding_Account
FK_GL_Account_Segment_Code_Rounding_Account__GL_Account__liability__gl_account_KEYliability__gl_account_KEYGL_Account_Segment_Code_Rounding_Account
FK_GL_Account_Segment_Code_Rounding_Account__GL_Account__revenue_expense__gl_account_KEYrevenue_expense__gl_account_KEYGL_Account_Segment_Code_Rounding_Account
FK_GL_Account_Tickmark__GL_Account__gl_account_KEYgl_account_KEYGL_Account_Tickmark
FK_Recorded_Event_Object_N_GL_Account__GL_Account__gl_account_KEYgl_account_KEYRecorded_Event_Object_N_GL_Account
FK_GL_Account_N_GL_Account_Segment_Code__GL_Account__gl_account_KEYgl_account_KEYGL_Account_N_GL_Account_Segment_Code
FK_AR_Transaction_Template__GL_Account__gl_account_KEYgl_account_KEYAR_Transaction_Template
FK_AR_Transaction_Template__GL_Account__payment_discount__gl_account_KEYpayment_discount__gl_account_KEYAR_Transaction_Template
FK_AR_Enter_Invoice_Option__GL_Account__default__gl_account_KEYdefault__gl_account_KEYAR_Enter_Invoice_Option
FK_Client_GL_Setup__GL_Account__asset_rounding__gl_account_KEYasset_rounding__gl_account_KEYClient_GL_Setup
FK_Client_GL_Setup__GL_Account__liability_rounding__gl_account_KEYliability_rounding__gl_account_KEYClient_GL_Setup
FK_Client_GL_Setup__GL_Account__revenue_expense_rounding__gl_account_KEYrevenue_expense_rounding__gl_account_KEYClient_GL_Setup
FK_Checkbook__GL_Account__form_adjustment_write_off__gl_account_KEYform_adjustment_write_off__gl_account_KEYCheckbook
FK_Checkbook__GL_Account__gl_account_KEYgl_account_KEYCheckbook
FK_Checkbook__GL_Account__impounding__gl_account_KEYimpounding__gl_account_KEYCheckbook
FK_Checkbook__GL_Account__payroll_agent_funding_liability__gl_account_KEYpayroll_agent_funding_liability__gl_account_KEYCheckbook
FK_Checkbook__GL_Account__payroll_funding_liability__gl_account_KEYpayroll_funding_liability__gl_account_KEYCheckbook
FK_Checkbook__GL_Account__tax_agent_funding_liability__gl_account_KEYtax_agent_funding_liability__gl_account_KEYCheckbook
FK_Billing_Item__GL_Account__delivery__gl_account_KEYdelivery__gl_account_KEYBilling_Item
FK_Billing_Item__GL_Account__discount__gl_account_KEYdiscount__gl_account_KEYBilling_Item
FK_Billing_Item__GL_Account__fees__gl_account_KEYfees__gl_account_KEYBilling_Item
FK_Billing_Item__GL_Account__receivable__gl_account_KEYreceivable__gl_account_KEYBilling_Item
FK_Billing_Item__GL_Account__sales_tax__gl_account_KEYsales_tax__gl_account_KEYBilling_Item
FK_GL_Account_N_GL_Account_Grouping_Code__GL_Account__gl_account_KEYgl_account_KEYGL_Account_N_GL_Account_Grouping_Code
FK_GL_Account_Budget__GL_Account__gl_account_KEYgl_account_KEYGL_Account_Budget
FK_GL_Account_Workpaper_Reference__GL_Account__gl_account_KEYgl_account_KEYGL_Account_Workpaper_Reference
FK_Client_AR_Setup__GL_Account__ar__gl_account_KEYar__gl_account_KEYClient_AR_Setup
FK_Client_AR_Setup__GL_Account__bad_debt_expense__gl_account_KEYbad_debt_expense__gl_account_KEYClient_AR_Setup
FK_Client_AR_Setup__GL_Account__cash_back__gl_account_KEYcash_back__gl_account_KEYClient_AR_Setup
FK_Client_AR_Setup__GL_Account__discount__gl_account_KEYdiscount__gl_account_KEYClient_AR_Setup
FK_Client_AR_Setup__GL_Account__finance_charge__gl_account_KEYfinance_charge__gl_account_KEYClient_AR_Setup
FK_Client_AR_Setup__GL_Account__sales_returns_and_allowances__gl_account_KEYsales_returns_and_allowances__gl_account_KEYClient_AR_Setup
FK_Client_AR_Setup__GL_Account__undeposited_payment__gl_account_KEYundeposited_payment__gl_account_KEYClient_AR_Setup
FK_Client_AR_Setup__GL_Account__unearned_revenue__gl_account_KEYunearned_revenue__gl_account_KEYClient_AR_Setup
FK_GL_Account_Parent__GL_Account__gl_account_KEYgl_account_KEYGL_Account_Parent
FK_GL_Account_Parent__GL_Account__parent__gl_account_KEYparent__gl_account_KEYGL_Account_Parent
FK_AR_Item__GL_Account__additional_charge__gl_account_KEYadditional_charge__gl_account_KEYAR_Item
FK_AR_Item__GL_Account__cost__gl_account_KEYcost__gl_account_KEYAR_Item
FK_AR_Item__GL_Account__discount__gl_account_KEYdiscount__gl_account_KEYAR_Item
FK_AR_Item__GL_Account__inventory__gl_account_KEYinventory__gl_account_KEYAR_Item
FK_AR_Item__GL_Account__other_charge__gl_account_KEYother_charge__gl_account_KEYAR_Item
FK_AR_Item__GL_Account__sales__gl_account_KEYsales__gl_account_KEYAR_Item
FK_AR_Item__GL_Account__tax__gl_account_KEYtax__gl_account_KEYAR_Item
FK_Finance_Charge_Definition__GL_Account__client_KEY__gl_account_KEYclient_KEY, gl_account_KEYFinance_Charge_Definition
FK_Client_Billing__GL_Account__delivery__gl_account_KEYdelivery__gl_account_KEYClient_Billing
FK_Client_Billing__GL_Account__discount__gl_account_KEYdiscount__gl_account_KEYClient_Billing
FK_Client_Billing__GL_Account__fees__gl_account_KEYfees__gl_account_KEYClient_Billing
FK_Year_End_Close_Net_Income_Distribution__GL_Account__gl_account_KEYgl_account_KEYYear_End_Close_Net_Income_Distribution
FK_Quick_Books_Account_GL_Account__GL_Account__gl_account_KEYgl_account_KEYQuick_Books_Account_GL_Account
FK_Journal_Entry_Distribution__GL_Account__gl_account_KEYgl_account_KEYJournal_Entry_Distribution
FK_Year_End_Close_Balance_Sheet_Account_Distribution__GL_Account__from__gl_account_KEYfrom__gl_account_KEYYear_End_Close_Balance_Sheet_Account_Distribution
FK_Year_End_Close_Balance_Sheet_Account_Distribution__GL_Account__to__gl_account_KEYto__gl_account_KEYYear_End_Close_Balance_Sheet_Account_Distribution
FK_Tax_Code_N_GL_Account__GL_Account__gl_account_KEYgl_account_KEYTax_Code_N_GL_Account
FK_Tax_Code_M3_N_GL_Account__GL_Account__gl_account_KEYgl_account_KEYTax_Code_M3_N_GL_Account
FK_Client_Billing_Sales_Tax__GL_Account__sales_tax__gl_account_KEYsales_tax__gl_account_KEYClient_Billing_Sales_Tax
FK_AP_Enter_Transaction_List_View_Column_Option__GL_Account__default__gl_account_KEYdefault__gl_account_KEYAP_Enter_Transaction_List_View_Column_Option
FK_Quick_Books_Transaction_Distribution__GL_Account__gl_account_KEYgl_account_KEYQuick_Books_Transaction_Distribution
FK_GL_Account_Csa_Account_Number__GL_Account__gl_account_KEYgl_account_KEYGL_Account_Csa_Account_Number
FK_OnBalance_GL_Account__GL_Account__gl_account_KEYgl_account_KEYOnBalance_GL_Account
FK_Client_Payroll_Information__GL_Account__form_adjustment_write_off__gl_account_KEYform_adjustment_write_off__gl_account_KEYClient_Payroll_Information
FK_Journal_Entry_Template_Automatic_Percentage_Distribution__GL_Account__gl_account_KEYgl_account_KEYJournal_Entry_Template_Automatic_Percentage_Distribution
FK_Journal_Entry_Template_Automatic_Percentage_Source_Account__GL_Account__from__gl_account_KEYfrom__gl_account_KEYJournal_Entry_Template_Automatic_Percentage_Source_Account
FK_Journal_Entry_Template_Automatic_Percentage_Source_Account__GL_Account__to__gl_account_KEYto__gl_account_KEYJournal_Entry_Template_Automatic_Percentage_Source_Account
FK_Customer__GL_Account__ar__gl_account_KEYar__gl_account_KEYCustomer
FK_Vendor__GL_Account__ap__gl_account_KEYap__gl_account_KEYVendor
FK_Client_Payroll_Item__GL_Account__expense__gl_account_KEYexpense__gl_account_KEYClient_Payroll_Item
FK_Client_Payroll_Item__GL_Account__liability__gl_account_KEYliability__gl_account_KEYClient_Payroll_Item
FK_Worker_Compensation__GL_Account__expense__gl_account_KEYexpense__gl_account_KEYWorker_Compensation
FK_Worker_Compensation__GL_Account__liability__gl_account_KEYliability__gl_account_KEYWorker_Compensation
FK_Client_Tax_Item__GL_Account__expense__gl_account_KEYexpense__gl_account_KEYClient_Tax_Item
FK_Client_Tax_Item__GL_Account__liability__gl_account_KEYliability__gl_account_KEYClient_Tax_Item
FK_Payable_Transaction_Template__GL_Account__payable__gl_account_KEYpayable__gl_account_KEYPayable_Transaction_Template
FK_AR_Transaction__GL_Account__gl_account_KEYgl_account_KEYAR_Transaction
FK_AR_Transaction__GL_Account__payment_discount__gl_account_KEYpayment_discount__gl_account_KEYAR_Transaction
FK_Manual_Funding_Bank_Transaction__GL_Account__client_expense__gl_account_KEYclient_expense__gl_account_KEYManual_Funding_Bank_Transaction
FK_Manual_Funding_Bank_Transaction__GL_Account__firm_revenue__gl_account_KEYfirm_revenue__gl_account_KEYManual_Funding_Bank_Transaction
FK_Apply_Customer_Payment_Transaction__GL_Account__discount__gl_account_KEYdiscount__gl_account_KEYApply_Customer_Payment_Transaction
FK_AR_Payment__GL_Account__undeposited_payment__gl_account_KEYundeposited_payment__gl_account_KEYAR_Payment
FK_AR_Payment__GL_Account__unearned_revenue__gl_account_KEYunearned_revenue__gl_account_KEYAR_Payment
FK_Bank_Transaction_Distribution__GL_Account__gl_account_KEYgl_account_KEYBank_Transaction_Distribution
FK_Vendor_Distribution__GL_Account__gl_account_KEYgl_account_KEYVendor_Distribution
FK_Bank_Transaction_Template_Distribution__GL_Account__gl_account_KEYgl_account_KEYBank_Transaction_Template_Distribution
FK_Vendor_Amortization_Schedule__GL_Account__interest__gl_account_KEYinterest__gl_account_KEYVendor_Amortization_Schedule
FK_Vendor_Amortization_Schedule__GL_Account__principal__gl_account_KEYprincipal__gl_account_KEYVendor_Amortization_Schedule
FK_Bank_Feeds_Assignment_Rule_Action__GL_Account__assigned_value__gl_account_KEYassigned_value__gl_account_KEYBank_Feeds_Assignment_Rule_Action
FK_Bank_Feeds_Retrieved_Transaction_Distribution__GL_Account__gl_account_KEYgl_account_KEYBank_Feeds_Retrieved_Transaction_Distribution
FK_Bank_Reconciliation_Recurring_Adjustment_Template_Distribution__GL_Account__gl_account_KEYgl_account_KEYBank_Reconciliation_Recurring_Adjustment_Template_Distribution
FK_Employee_Payroll_Item__GL_Account__expense__gl_account_KEYexpense__gl_account_KEYEmployee_Payroll_Item
FK_Employee_Payroll_Item__GL_Account__liability__gl_account_KEYliability__gl_account_KEYEmployee_Payroll_Item
FK_Bank_Feeds_Assignment_Rule_Action_Distribution__GL_Account__assigned_value__gl_account_KEYassigned_value__gl_account_KEYBank_Feeds_Assignment_Rule_Action_Distribution
FK_Employee_Tax_Item__GL_Account__expense__gl_account_KEYexpense__gl_account_KEYEmployee_Tax_Item
FK_Employee_Tax_Item__GL_Account__liability__gl_account_KEYliability__gl_account_KEYEmployee_Tax_Item
FK_Payroll_Check_Tax_Item__GL_Account__expense__gl_account_KEYexpense__gl_account_KEYPayroll_Check_Tax_Item
FK_Payroll_Check_Tax_Item__GL_Account__liability__gl_account_KEYliability__gl_account_KEYPayroll_Check_Tax_Item
FK_Payroll_Check_Payroll_Item__GL_Account__expense__gl_account_KEYexpense__gl_account_KEYPayroll_Check_Payroll_Item
FK_Payroll_Check_Payroll_Item__GL_Account__liability__gl_account_KEYliability__gl_account_KEYPayroll_Check_Payroll_Item
FK_Employee_Worker_Compensation_Item_Distribution__GL_Account__expense__gl_account_KEYexpense__gl_account_KEYEmployee_Worker_Compensation_Item_Distribution
FK_Employee_Worker_Compensation_Item_Distribution__GL_Account__liability__gl_account_KEYliability__gl_account_KEYEmployee_Worker_Compensation_Item_Distribution
FK_Employee_Payroll_Item_Distribution__GL_Account__expense__gl_account_KEYexpense__gl_account_KEYEmployee_Payroll_Item_Distribution
FK_Employee_Payroll_Item_Distribution__GL_Account__liability__gl_account_KEYliability__gl_account_KEYEmployee_Payroll_Item_Distribution
FK_Employee_Tax_Item_Distribution__GL_Account__expense__gl_account_KEYexpense__gl_account_KEYEmployee_Tax_Item_Distribution
FK_Employee_Tax_Item_Distribution__GL_Account__liability__gl_account_KEYliability__gl_account_KEYEmployee_Tax_Item_Distribution
FK_AR_Transaction_Item_GL_Account__GL_Account__gl_account_KEYgl_account_KEYAR_Transaction_Item_GL_Account
FK_Bank_Reconciliation_Statement_Detail__GL_Account__adjustment__gl_account_KEYadjustment__gl_account_KEYBank_Reconciliation_Statement_Detail
FK_Payroll_Check_Payroll_Item_Distribution__GL_Account__expense__gl_account_KEYexpense__gl_account_KEYPayroll_Check_Payroll_Item_Distribution
FK_Payroll_Check_Payroll_Item_Distribution__GL_Account__liability__gl_account_KEYliability__gl_account_KEYPayroll_Check_Payroll_Item_Distribution
FK_Payroll_Check_Tax_Item_Distribution__GL_Account__expense__gl_account_KEYexpense__gl_account_KEYPayroll_Check_Tax_Item_Distribution
FK_Payroll_Check_Tax_Item_Distribution__GL_Account__liability__gl_account_KEYliability__gl_account_KEYPayroll_Check_Tax_Item_Distribution
FK_Payroll_Bank_Transaction_Worker_Compensation_Item_Distribution__GL_Account__expense__gl_account_KEYexpense__gl_account_KEYPayroll_Bank_Transaction_Worker_Compensation_Item_Distribution
FK_Payroll_Bank_Transaction_Worker_Compensation_Item_Distribution__GL_Account__liability__gl_account_KEYliability__gl_account_KEYPayroll_Bank_Transaction_Worker_Compensation_Item_Distribution
FK_Payable_Transaction__GL_Account__ap_discount__gl_account_KEYap_discount__gl_account_KEYPayable_Transaction
FK_Payable_Transaction__GL_Account__payable__gl_account_KEYpayable__gl_account_KEYPayable_Transaction
FK_Payable_Transaction_Distribution__GL_Account__gl_account_KEYgl_account_KEYPayable_Transaction_Distribution

Schema diagram