Updated: 2009-09-16

Version: Control 4.4

Table Purpose, Usage, and Notes

This table stores all of the information about all of the GL Accounts.Formerly split tables were used for some information, but as of Control 4.0 all information was brought into the GL Account Table.

Information on Table Data

  • ClassTypeIDs Stores in Table:
    • 8000 - GL Account Group
    • 8001 - GL Account Item
  • Deprecated ClassTypeIDs - Control 4.3 and earlier only
    • 8050 - Computed Account Group
    • 8051 - Computed Cost Account
    • 8055 - Computed Cost Account
    • 9000 - Computed Account Group
    • 9001 - Computed Cost Account
  • GLClassificationType in Table:
    • Asset Classifications - 1000s
      • 1000 BankAccount
      • 1001 AccountsReceivable
      • 1002 CurrentAsset
      • 1003 Inventory
      • 1004 FixedAsset
      • 1005 OtherAsset
      • 1006 Depreciation
      • 1007 UndepositedFunds
    • Liability Classifications - 2000s
      • 2000 AccountsPayable
      • 2001 CreditCardAccount
      • 2002 CurrentLiability
      • 2003 LongTermLiability
      • 2004 OtherLiability
      • 2005 SalesTaxLiability
      • 2006 OtherTaxLiability
      • 2007 RoyaltyLiability
      • 2008 CommissionLiability
    • Equity Classifications - 3000s
      • 3000 Equity
    • Income Classifications - 4000s
      • 4000 Income
      • 4001 OtherIncome
    • Expense Classifications - 5000s
      • 5000 Wage
      • 5001 CostGoodsSold
      • 5002 Expense
      • 5003 OtherExpense
    • Category Classifications - 8000s
      • 8000 AccountGroup
      • 8001 AssignedExpenseGroup
    • Tracking Only Classifications - Control 4.3 and earlier only
      • 9001 AssignedExpense
      • 9002 CostTracking
      • 9003 CostOfBuilt

Table Structure

~ Table.FieldName ~ Data Type ~ Description ~ Links To
GLAccount.AccountGroupClassTypeID int
GLAccount.AccountGroupID int ID of Group (parent ID) GLAccount.ID
GLAccount.AccountName nvarchar(100) Name of Account
GLAccount.AccountType int
GLAccount.AddressID int
GLAccount.AllowSubGroups bit
GLAccount.AlwaysRoundUp bit
GLAccount.AssociatedGLAccountID int
GLAccount.CapAmount float
GLAccount.ClassTypeID int Indicates the Type of Object
GLAccount.ConsolidateExport bit
GLAccount.ConsolidateSubAccounts bit
GLAccount.Depth int
GLAccount.Description text
GLAccount.ExportAccountDesc text
GLAccount.ExportAccountName nvarchar(50)
GLAccount.ExportAccountNumber int
GLAccount.ExportGroupID int
GLAccount.GLClassificationType int
GLAccount.GLClassTypeName varchar(50)
GLAccount.ID int Primary Key Field
GLAccount.IsActive bit Indicates if Enabled. 1Record is Active, 0Record is Not Active
GLAccount.IsRoyaltyExempt bit
GLAccount.IsSystem bit Used to Mark Required Records
GLAccount.LastCheckNumber int
GLAccount.MasterGroup bit
GLAccount.MemberClassTypeID int
GLAccount.ModifiedByComputer nvarchar(25) HostName of computer that last modified this record
GLAccount.ModifiedByUser nvarchar(25) Windows User who last modified this record
GLAccount.ModifiedDate datetime DateTime this Record was last modified
GLAccount.NoExportToExternal bit
GLAccount.NonGLAccount bit
GLAccount.PathName1 nvarchar(150)
GLAccount.PathName2 nvarchar(150)
GLAccount.PathName3 nvarchar(150)
GLAccount.PathName4 nvarchar(150)
GLAccount.PathName5 nvarchar(150)
GLAccount.ReferenceID varchar(50)
GLAccount.RequireOneMember bit
GLAccount.RoyaltyFee1 float
GLAccount.RoyaltyFee1OV bit
GLAccount.RoyaltyFee2 float
GLAccount.RoyaltyFee2OV bit
GLAccount.SeqID int
GLAccount.SortIndex float
GLAccount.StoreID int Not Used.
GLAccount.TaxRate float
GLAccount.VendorClassTypeID int
GLAccount.VendorID int

Related Tables

You could leave a comment if you were logged in.