ACALLOCX

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

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
AOXSET1 ALLOC-NAME
LINE-NBR
AC130 AC131
AC230 AC30.1
AC30.2 AC30.3
AC30.4


ACALLOCX FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Acacctcat ACACCTCAT Not Required
AOX-PT-ACCT-CAT->AAX-ACCT-CATEGORY
Acacctcat Pf ACACCTCAT Not Required
AOX-PF-ACCT-CAT->AAX-ACCT-CATEGORY
Acactgrp ACACTGRP Not Required
AOX-ACTIVITY-GRP->AGP-ACTIVITY-GRP
Acactivity ACACTIVITY Required
AOX-PT-ACTIVITY->ACV-ACTIVITY
Acactivity Pf ACACTIVITY Not Required
AOX-PF-ACTIVITY->ACV-ACTIVITY
Acalloc ACALLOC Required
AOX-ALLOC-NAME->AOC-ALLOC-NAME
Accmpparam ACCMPPARAM Required
AOX-PARAM-NAME->CPM-PARAM-NAME
Acpoolhdr ACPOOLHDR Required
AOX-POOL-NAME->POL-POOL-NAME
Cmpute CMPUTE Required
AOX-COMPUTE-NAME->CMP-COMPUTE-NAME


ACALLOCX FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Accatrans ACCATRANS
AOX-ALLOC-NAME->TRN-ALLOC-NAME
  TRN-LINE-NBR
  TRN-STEP
  TRN-SEQ-NUMBER
  TRN-ALLOC-GROUP


File created: Thu Jun 09 11:03:49 2016

Home
Contact Us



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