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.