{$page} 



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_tablejournal_table|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 



See Also 
  * Backlinks [[include_pagepage_componentbacklinks]]