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.