original_pages:sql_structure_-_gl

{$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 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