Activity Allocation Detail

This file contains detailed information about allocations, as defined in AC30.1 (Allocation) and AC30.2 (Multiple Pool Allocation).

REFERENCED BY

AC230

UPDATED BY

AC130

AC131

AC30.1

AC30.2

AC30.3

AC30.4

FIELD NAME	DESCRIPTION/VALID VALUES	UPDATED BY
AOX-ALLOC-NAME Element: Allocation	Alpha 12 Required key. This is the allocation to which this line belongs.	AC30.1 AC30.2 AC30.3
AOX-LINE-NBR Element: Line Number	Numeric 6 Required key. This field contains the line number.	AC30.1 AC30.2 AC30.3
AOX-PT-ACTIVITY Element: Post-to Activity	Alpha 15 This is the activity to which the allocation is posted.	AC130 AC30.1 AC30.2 AC30.3
AOX-PT-ACTIVITY-ND Activity Nbr of Decimals	Numeric 1 This is the number of decimals for the allocation to be posted to the activity.	AC130 AC30.1 AC30.2 AC30.3
AOX-ACTIVITY-GRP Element: Activity Group	Alpha 15 This is the activity group to which the post-to activity belongs.	AC130 AC30.1 AC30.2 AC30.3
AOX-PT-ACCT-CAT Post-to Account Category	Alpha 5 This is the account category to which the allocation is posted.	AC30.1 AC30.2 AC30.3
AOX-POOL-NAME Element: Allocation Pool	Alpha 12 This is the name of the allocation pool, the collection of amounts or units to be allocated according to the rules on the allocation line.	AC30.1 AC30.2 AC30.3
AOX-PT-POST-OPTION Post-to Posting Option	Alpha 1 The post-to posting option determines the kind of detail produced by the allocation. C = Consolidate. Create a single transaction for the allocation. P = Pool. Create a separate transaction for each account category, to be posted to the corresponding account category in the post-to activity. D = Detail. Create a separate transaction for each account category and General Ledger account, to be posted to the post-to activity and account categories.	AC30.1 AC30.2 AC30.3
AOX-TRANS-TYPE Element: Transaction Type	Alpha 1 This field identifies the type of values for the transaction. The transaction type is determined by the type of the pool assigned to the allocation line. A = Amount U = Units	AC30.1 AC30.2 AC30.3
AOX-UNIT-MEASURE Element: Unit Measure	Alpha 12	AC30.1 AC30.2 AC30.3
AOX-AUTO-REV Element: Auto Reversal	Alpha 1 When the Auto Reversal field is set to Yes (Y), AC131 (Allocation Update) creates a reversing entry for this transaction in the run following the run that creates the original entry. The default is No. Y = Yes N = No	AC30.1 AC30.2 AC30.3
AOX-LAST-PER-ALLOC Last Period Allocated	Numeric 2 This is the period most recently allocated.	AC131
AOX-REV-OBJ-ID Reversing Object Identifier	Numeric 12 This field contains identifying information for the creation of an auto-reversing entry.
AOX-PTD-ALLOCATED Period-to-Date Allocated Amt	Signed 18.2 This is the period-to-date allocated amount.	AC131
AOX-DESCRIPTION Transaction Description	Alpha 30 (Lower Case) This is the transaction description for the entries created for the allocation line.	AC30.1 AC30.2 AC30.3
AOX-PF-ACTIVITY Element: Post-from Activity	Alpha 15 Optional. This the activity to which an offsetting entry is made.	AC30.1 AC30.2 AC30.3
AOX-PF-ACCT-CAT Post-from Account Category	Alpha 5 Optional. This is the account category to which an offsetting entry is made.	AC30.1 AC30.2 AC30.3
AOX-ALLOC-PERCENT Element: Allocation Percent	Signed 7.4 This is the percent of the allocation pool to be allocated to the post-to activity.	AC131 AC30.1 AC30.2 AC30.3
AOX-WEIGHT-VAL Element: Weighted Value	Signed 18.2 This value is used to weight the activity's allocation percent relative to activities on other allocation lines.	AC130 AC30.1 AC30.2 AC30.3
AOX-WGT-ACTIVITY Element: Activity	Alpha 15 This is the activity for the weighting factor.	AC30.1
AOX-FR-ACCT-CAT From Account Category	Alpha 5 This is the beginning account category of the account category range for the allocation.	AC30.1
AOX-TH-ACCT-CAT Through Account Category	Alpha 5 This is the ending account category of the account category range for the allocation.	AC30.1
AOX-GROUP Element: Group	Alpha 15 This is the allocation group for the allocation.	AC30.1
AOX-WGT-TRANS-TYPE Weighted Transaction Type	Alpha 1 This is the transaction type for the weighting factor, identifying the type for the transaction: amount or units. A = Amount U = Units	AC30.1 AC30.2 AC30.3
AOX-WGT-BUDGET-NBR Weighted Budget Number	Numeric 3 This is the budget number for the weighting factor.	AC30.1 AC30.2 AC30.3
AOX-WGT-CUM-BASIS Weighted Cumulative Basis	Alpha 1 This field indicates the time period over which the weighting factor is accumulated: period, year-to-date, or life-to-date. P = Period to Date Y = Year to Date L = Life to Date	AC30.1 AC30.2 AC30.3
AOX-COMPUTE-NAME Compute Statement Name	Alpha 12 A compute statement is an arithmetic equation created in RW50.1 (Compute Statement). The result of the equation is used to determine the amount of the pool to allocate to the post-to activity.	AC30.1 AC30.2 AC30.3
AOX-PARAM-NAME Element: Param Name	Alpha 12	AC30.1 AC30.2 AC30.3
AOX-PT-COMPANY Element: Post-to Company	Numeric 4 Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources.	AC30.1 AC30.2 AC30.3
AOX-PT-ACCT-UNIT Post-to Accounting Unit	Alpha 15 The accounting unit is a shorthand notation representing the variable level number. When used in the General Ledger Account Master file, the accounting unit must be defined in the General Ledger Names file as a posting accounting unit.	AC30.1 AC30.2 AC30.3
AOX-PT-ACCOUNT Element: Post-to Account	Numeric 6 This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored.	AC30.1 AC30.2 AC30.3
AOX-PT-SUB-ACCT Element: Post-to Subaccount	Numeric 4 This field contains the subaccount from your general ledger chart of accounts that was charged with the amount carried on this record.	AC30.1 AC30.2 AC30.3
AOX-PT-LIST Element: Post-to List	Alpha 12 This is the post-to list of activities you are posting the allocation to.	AC30.3
AOX-PF-COMPANY Element: Post-from Company	Numeric 4 Type or select the company you are allocating from. If you select to override company information, the program overrides this field when determining the allocated amount.	AC30.1 AC30.2 AC30.3
AOX-PF-ACCT-UNIT Element: Acct Unit	Alpha 15 The accounting unit is a shorthand notation representing the variable level number. When used in the General Ledger Account Master file, the accounting unit must be defined in the General Ledger Names file as a posting accounting unit.	AC30.1 AC30.2 AC30.3
AOX-PF-ACCOUNT Element: Post-from Account	Numeric 6 This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored.	AC30.1 AC30.2 AC30.3
AOX-PF-SUB-ACCT Element: Post-from Subaccount	Numeric 4 This field contains the subaccount from your general ledger chart of accounts that was charged with the amount carried on this record.	AC30.1 AC30.2 AC30.3
AOX-POOL-LIST Element: Pool List	Alpha 1 This is the list of pools you are allocating from.	AC30.3
AOX-SUM-ACCT-CAT Element: Sum Acct Cat	Alpha 5 The name of the summary account category.	AC30.1

ACALLOCX FILE INDEX

ACALLOCX FILE RELATIONS

ONE TO ONE RELATIONS

ACALLOCX FILE RELATIONS

ONE TO MANY RELATIONS

All trademarks and registered trademarks are the property of their respective owners.