This data object is used to show a listing of all general ledger chart of accounts and their sub category structure down to 6 levels.

This information is found within the Chart of Accounts program within the Fusion business system.

URL

/frw/ChartofAccounts

Field Details…

SQL Field Name Column Description
AccountingType This field displays the account type of the General Ledger Number.
AccountingCategory This field displays an accounting category assigned to a given account by a user.
AddDate This field displays the date on which the given General Ledger number was added in the Business System.
AddUser This field displays the user name that added the record.
ControlType This field displays the control type method assigned to the General Ledger Account. Options are: Not validated, Entity validation, or Validation list.
Departmentalized This field displays whether or not a department is required when making postings to the General Ledger Account.
DetailLevel This field displays how many levels down the G/L number is, based on the number of categories/sub categories above the G/L.  For example, say G/L 1100 resides under a category called Accounts Receivable, and the category Accounts Receivable was under the category of Assets.  G/L 1100 would then have a detail level of 3, as it is 3 levels deep, based on the categories/sub-categories under which it resides.
Account This field displays the general ledger account number associated with the debit or credit entry.
InActive This field displays whether or not a given general ledger account number is set to inactive.
LastUpdateDate This field displays the user name of the individual who made the update.
UpdateUser This field displays the user name of the individual who made the update.
Level1Category This field displays the top-most category under which the given G/L number falls.
Level1SortOrder This field displays sort order of the level 1 category in relation to the other level 1 categories.
Level2Category This field displays the second level category assigned to the given G/L number. Note, that if the given G/L number does not have more than one parent category then the G/L number itself would be the level 2 category.
Level2SortOrder This field displays sort order of the level 2 category in relation to the other level 2 categories found.
Level3Category This field displays the third level category assigned to the given G/L number. Note, that if the given G/L number does not have 3 parent categories then the G/L number itself would be the level 3 category.
Level3SortOrder This field displays sort order of the level 3 category in relation to the other level 3 categories found.
Level4Category This field displays the fourth level category assigned to the given G/L number.  Note, that if the given G/L number does not have 4 parent categories then the G/L number itself would be the level 4 category.
Level4SortOrder This field displays sort order of the level 4 category in relation to the other level 4 categories found.
Level5Category This field displays the fifth level category assigned to the given G/L number. Note, that if the given G/L number does not have 5 parent categories then the G/L number itself would be the level 5 category.
Level5SortOrder This field displays sort order of the level 5 category in relation to the other level 5 categories found.
Level6Category This field displays the sixth level category assigned to the given G/L number. Note, that if the given G/L number does not have 5 parent categories then the G/L number itself would be the level 5 category.
Level6SortOrder This field displays sort order of the level 6 category in relation to the other level 6 categories found.
LongDescription This field displays the long description of a given General Ledger account.
ShortDescription This field displays the short description of a given General Ledger account.
StandardPresentation This field displays either Debit or Credit based on the subcategory in which the given GL account resides.