sql_structure_-_glaccount

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