Updated: 2009-09-17

Version: Control 4.4

Table Purpose, Usage, and Notes

The GL Table stores all the general ledger transactional data. All GL entries are batched under a Journal entry stored in the sql_structure_-_journal_table, though many classes of Journal records don't have GL entries.

Information on Table Data

  • ClassTypeIDs in Table:
    • 8900 - GL Entry
  • 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
  • EntryType's in Table:
    • 0
    • 1 Manually Entered by a User
    • 2

Table Structure

~ Table.FieldName ~ Data Type ~ Description ~ Links To
GL.AccountClassTypeID int
GL.AccountID int ID of the Customer Account
GL.Amount decimal(18, 4)
GL.Classification int
GL.ClassTypeID int Identifier for the Type of Object
GL.DepositJournalID int
GL.Description nvarchar(50)
GL.DivisionID int ID of the Division for this Transaction EmployeeGroup.ID
GL.EmployeeID int ID of the Employee Posting the Record Employee.ID
GL.Entry datetime
GL.EntryType int
GL.GLAccountClassTypeID int
GL.GLAccountID int
GL.GLClassificationType int
GL.GLClassTypeName varchar(50)
GL.GLDepartmentID int
GL.GoodsItemClassTypeID int
GL.GoodsItemID int
GL.GroupID int
GL.ID int Primary Key for the Table
GL.IsActive bit Not Used for This Table
GL.IsModified bit
GL.IsSystem bit Used to Mark Required Records
GL.IsTaxable bit
GL.IsUser bit
GL.JournalClassTypeID int
GL.JournalID int
GL.ModifiedByComputer nvarchar(25) HostName of computer that last modified this record
GL.ModifiedByUser nvarchar(25) Windows User who last modified this record
GL.ModifiedDate datetime DateTime this Record was last modified
GL.Notes text
GL.PartClassTypeID int
GL.PartID int
GL.PayrollClassTypeID int
GL.PayrollID int
GL.ProcessedDivisionID int
GL.Quantity float
GL.Reconciled bit
GL.Reconciliation datetime
GL.ReconciliationClassTypeID int
GL.ReconciliationID int
GL.SeqID int
GL.StationID int
GL.StoreID int Not Used.
GL.TaxClassID int
GL.TransactionClassTypeID int
GL.TransactionID int
GL.TransDetailClassTypeID int
GL.TransDetailID int
GL.TransPartClassTypeID int
GL.TransPartID int

Related Tables

You could leave a comment if you were logged in.