This data object is used to display the allocation tables specified in Fusion, along with the allocation breakdown for each by Branch/Department and the list of breakdown accounts specified in the setup form of the Allocation Table.  It also displays, for each allocation table, any GL account that it has been associated with in the setup form of the given GL account, along with the branch and/or department associated with that link.

This information comes from the Account Allocation and the Chart of Accounts programs within the Fusion business system.

URL

/frw/AccountAllocation

Field Details…

SQL Field Name Column Description
AccountDescription This field displays the account description of a GL account that the given allocation table has been associated with in Chart of Accounts.
AddDate This field displays the date on which the allocation table was added to the system.
AddUser This field displays the user name of the individual who added the allocation table.
BasedOn This field displays whether a variable allocation table is based on Year to Date, Transaction Period, or Prior Transaction Period, or for a fixed allocation table, displays Fixed Allocation.
AllocationBranch This field displays the branch that a percentage amount will be allocated to.
AllocationDepartment This field displays the department that a percentage amount will be allocated to.
AllocationName This field displays the name of the given allocation table.
AllocationType This field displays whether the allocation table describes a fixed or variable allocation type.
BreakdownAccounts This field displays the list of accounts specified in the allocation table for the allocation amount to be split between.
GLAccount This field displays the account number of a GL account that the given allocation table has been associated with in Chart of Accounts.
GLBranch This field displays the branch that has been specified in Chart of Accounts when associating an allocation table with a GL Account. (When accounting is posted to the account in GL Account and this branch, a percentage will be allocated to the branch and/or department in Allocation Branch and Allocation Department.
GLDepartment This field displays the department that has been specified in Chart of Accounts when associating an allocation table with a GL Account. (When accounting is posted to the account in GL Account and this department, a percentage will be allocated to the branch and/or department in Allocation Branch and Allocation Department.
IsDistributeEvenly This field displays whether the given allocation table distributes evenly between the branches and/or departments listed in the allocation table.
LastUpdateDate This field displays the date on which the allocation table was last updated.
UpdateUser This field displays the user name of the individual who last updated the allocation table.
PercentAllocated This field displays the percentage that has been allocated to the location specified in the Branch and/or Department fields, for allocation tables with an allocation type of fixed.