Source Allocation Relation (tfcat4620m000)
Use this session to view and maintain the range of source and destination dimensions based on which the allocation relations are generated by LN in the Allocation Relations (tfcat4500m000) session. For each range of source dimension you can define multiple destination dimensions. You can also define range of periods for which allocation relation can be generated.
Field Information
- Relation
-
The type of allocation relation.
Allowed values
- Budget Year
-
These relations are used for allocations within Single Dimension Budgets per Year.
- Budget Period
-
These relations are used for allocations within Single Dimension Budgets per Period.
- Actual
-
These relations are used for allocations within Actual Costs.
- Period From
-
The From and To fields define a range of: years for which the allocation relation are applicable.
Note: You must specify this value if the Relation field is set to Actual. - Period From
-
The From and To fields define a range of: periods for which the allocation relation are applicable.
Note: You must specify this value if the Relation field is set to Actual. - Budget
-
The budget to which the allocation relation is applicable.
- Description
-
The description or name of the code.
- Processed
-
Indicates that the actual allocation relations are verified by the budget figures.
- Source Dimension Type
-
The dimension type to be credited for the allocation.
- Dimension Description
-
The description or name of the code.
- Source Dimension From
-
The first dimension to be credited from the range of dimensions for generating individual allocation relation.
Note:- The dimensions, must be of the Source Dimension Type.
- This dimension range must be specified in the alphabetically ascending order.
- Dimension Description
-
The description or name of the code.
- Source Reference Unit From
-
The first reference unit to be credited from the range of reference units. If the source dimension use a reference unit, the amount of this reference unit represents the actual cost value of the dimension used by the allocation process.
- Description
-
The description or name of the code.
- Source Dimension To
-
The last dimension to be credited from the range of dimensions, for generating individual allocation relation.
- Source Reference Unit To
-
The last reference unit to be credited from the range of reference units. If the source dimension use a reference unit, the amount of this reference unit represents the actual cost value of the dimension used by the allocation process.
- Source Ledger Account
-
The source ledger account to be credited.
Note: This account is a Profit & Loss account with sublevel zero (0). - Ledger Account Description
-
The description or name of the code.
- Destination Dimension Type
-
The dimension type to be debited for allocation.
- Base Dimension Type
-
The dimension type for the base dimension. When using the base dimension type, the allocation process is always based on the actual costs. The allocation across the various destinations is based on the distribution of actual costs on the relevant base dimensions. The actual costs that are already available in the destination dimensions are not relevant for the allocation process.
- Destination Allocation Type
-
The allocation type that depends on the parameters of the destination reference unit. You must use a uniform allocation type within the combination of relation, year, budget, period, and destination reference unit.
Allowed values
- Performance
- Cost
- Equal
- Distribution
-
The code that defines how the actual costs are distributed over the reference units that are linked to the dimension.
- Description
-
The description or name of the code.
- Allocation Type
-
The allocation type that is based on the parameters of the source reference unit. You must use a uniform allocation type for a combination of relation, year, budget, period and source reference unit.
Reference Unit Type Quantity Based Amount Based Planning type Retrograde Progressive Retrograde Progressive Quantity yes yes no no Amount no yes no yes Percentage no yes no yes Allowed values
- Quantity
-
Indicates that the allocation relations are based on performance values. The quantity-based allocation method assumes that the source dimension must contain at least one relevant reference unit. The reference unit must also be quantity-based and progressive.
- Amount
-
Indicates that a fixed amount is reallocated, independent of the imported actual costs. As a result, both amounts laser or greater than 100% of the imported costs can be re-allocated.
- Percentage
-
Indicates the fraction of costs to be written down on the dimension. When reference units with activated percentage-based periodic allocation is used, a percentage by period indicates a portion of the allocated costs.
- Quantity
-
The quantity specified for quantity-based allocation.
- Unit
-
The unit in which the quantity is measured.
- Amount
-
The amount specified for the amount-based allocation. This fixed amount is debited to the destination dimension.
Note: This field is enabled only if the Allocation Type field is set to Amount. - Currency
-
The currency in which the amount is specified.
- Percentage
-
The percentage specified for a percentage-based allocation. This percentage of the budget or actual costs must be debited from the destination dimension.
Note: This field is enabled only if the Allocation Type field is set to Percentage. - Percentage Sign
-
The percentage sign.
- Equal Periodic Distribution
-
If this check box is selected, the distribution across periods for Destination Allocation Type set to Cost or Performance (Actual Allocations) is applicable independent of the Actual Costs or Actual Allocations (Performance) occurred in that period. The redistribution is performed equally across the destination dimensions. If this check box is cleared, the redistribution is performed proportional to the Actual Costs incurred in the respective periods.
- Periodic Distribution Percentage
-
The relationship between the period and year percentage or quantity for the Budget Period relation and the Actual relation.
Period / year x 100
for example:
20% / 80% x 100 = 25%
- Valuation
-
Indicates if the valuation is performed based on actual or budget figures. Budget relations and actual Actual relations are respectively based on budget or actual figures, either from the Financial Budgeting System module or the Cost Accounting module.
Allowed values
- Budget Figures
-
LN derives the amounts for calculating the allocation costs from the single dimension budget per year/period. For a budget year/period relation, the budget of the relation is used. For an actual relation, LN uses the actual budget as defined in the Finance Company Parameters (tfgld0503m000) session.
- Actual Figures
-
LN derives the amounts for calculating the allocation costs from the actual costs by reference unit. Budget allocation relations are only allowed to be valuated with budget figures. Actual allocation relations may be valuated either by budget figures or by actual figures.
- Valuated Portion
-
The part of the budget or costs that is allocated to the destination dimension.
- Cost Category
-
The cost category to be credited for allocation. This is used to limit the primary cost amounts. For quantity or percentage based allocation (ie. allocation types which use imported costs) only the cost types related to the indicated category are reallocated.
Note: This field is applicable only if the Allocation Type field is set to Percentage.