|
|
ACALLOCX FILE
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 Alpha 12 AC30.1 AC30.2
Element: Allocation Required key. This is the allocation to AC30.3
which this line belongs.
AOX-LINE-NBR Numeric 6 AC30.1 AC30.2
Element: Line Number Required key. This field contains the AC30.3
line number.
AOX-PT-ACTIVITY Alpha 15 AC130 AC30.1
Element: Post-to ActiviThis is the activity to which the AC30.2 AC30.3
allocation is posted.
AOX-PT-ACTIVITY-ND Numeric 1 AC130 AC30.1
Activity Nbr of This is the number of decimals for the AC30.2 AC30.3
Decimals allocation to be posted to the activity.
AOX-ACTIVITY-GRP Alpha 15 AC130 AC30.1
Element: Activity GroupThis is the activity group to which the AC30.2 AC30.3
post-to activity belongs.
AOX-PT-ACCT-CAT Alpha 5 AC30.1 AC30.2
Post-to Account This is the account category to which AC30.3
Category the allocation is posted.
AOX-POOL-NAME Alpha 12 AC30.1 AC30.2
Element: Allocation PooThis is the name of the allocation AC30.3
pool, the collection of amounts or units
to be allocated according to the rules
on the allocation line.
AOX-PT-POST-OPTION Alpha 1 AC30.1 AC30.2
Post-to Posting The post-to posting option determines AC30.3
Option 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.
AOX-TRANS-TYPE Alpha 1 AC30.1 AC30.2
Element: Transaction TyThis field identifies the type of AC30.3
values for the transaction. The
transaction type is determined by the
type of the pool assigned to the
allocation line.
A = Amount
U = Units
AOX-UNIT-MEASURE Alpha 12 AC30.1 AC30.2
Element: Unit Measure AC30.3
AOX-AUTO-REV Alpha 1 AC30.1 AC30.2
Element: Auto Reversal When the Auto Reversal field is set to AC30.3
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
AOX-LAST-PER-ALLOC Numeric 2 AC131
Last Period This is the period most recently
Allocated allocated.
AOX-REV-OBJ-ID Numeric 12
Reversing Object This field contains identifying
Identifier information for the creation of an
auto-reversing entry.
AOX-PTD-ALLOCATED Signed 18.2 AC131
Period-to-Date This is the period-to-date allocated
Allocated Amt amount.
AOX-DESCRIPTION Alpha 30 (Lower Case) AC30.1 AC30.2
Transaction This is the transaction description for AC30.3
Description the entries created for the allocation
line.
AOX-PF-ACTIVITY Alpha 15 AC30.1 AC30.2
Element: Post-from ActiOptional. This the activity to which an AC30.3
offsetting entry is made.
AOX-PF-ACCT-CAT Alpha 5 AC30.1 AC30.2
Post-from Account Optional. This is the account category AC30.3
Category to which an offsetting entry is made.
AOX-ALLOC-PERCENT Signed 7.4 AC131 AC30.1
Element: Allocation PerThis is the percent of the allocation AC30.2 AC30.3
pool to be allocated to the post-to
activity.
AOX-WEIGHT-VAL Signed 18.2 AC130 AC30.1
Element: Weighted ValueThis value is used to weight the AC30.2 AC30.3
activity's allocation percent relative
to activities on other allocation lines.
AOX-WGT-ACTIVITY Alpha 15 AC30.1
Element: Activity This is the activity for the weighting
factor.
AOX-FR-ACCT-CAT Alpha 5 AC30.1
From Account This is the beginning account category
Category of the account category range for the
allocation.
AOX-TH-ACCT-CAT Alpha 5 AC30.1
Through Account This is the ending account category of
Category the account category range for the
allocation.
AOX-GROUP Alpha 15 AC30.1
Element: Group This is the allocation group for the
allocation.
AOX-WGT-TRANS-TYPE Alpha 1 AC30.1 AC30.2
Weighted This is the transaction type for the AC30.3
Transaction Type weighting factor, identifying the type
for the transaction: amount or units.
A = Amount
U = Units
AOX-WGT-BUDGET-NBR Numeric 3 AC30.1 AC30.2
Weighted Budget This is the budget number for the AC30.3
Number weighting factor.
AOX-WGT-CUM-BASIS Alpha 1 AC30.1 AC30.2
Weighted Cumulative This field indicates the time period AC30.3
Basis 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
AOX-COMPUTE-NAME Alpha 12 AC30.1 AC30.2
Compute Statement A compute statement is an arithmetic AC30.3
Name 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.
AOX-PARAM-NAME Alpha 12 AC30.1 AC30.2
Element: Param Name AC30.3
AOX-PT-COMPANY Numeric 4 AC30.1 AC30.2
Element: Post-to CompanIdentifies the AP company if the AC30.3
resource type = V. Identifies the HR
company if the resource type = E. It is
blank for type A, P or Q resources.
AOX-PT-ACCT-UNIT Alpha 15 AC30.1 AC30.2
Post-to Accounting The accounting unit is a shorthand AC30.3
Unit 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.
AOX-PT-ACCOUNT Numeric 6 AC30.1 AC30.2
Element: Post-to AccounThis field along with the accounting AC30.3
unit and subaccount make up the location
(account) where amounts and other
account information is stored.
AOX-PT-SUB-ACCT Numeric 4 AC30.1 AC30.2
Element: Post-to SubaccThis field contains the subaccount from AC30.3
your general ledger chart of accounts
that was charged with the amount carried
on this record.
AOX-PT-LIST Alpha 12 AC30.3
Element: Post-to List This is the post-to list of activities
you are posting the allocation to.
AOX-PF-COMPANY Numeric 4 AC30.1 AC30.2
Element: Post-from CompType or select the company you are AC30.3
allocating from.
If you select to override company
information, the program overrides this
field when determining the allocated
amount.
AOX-PF-ACCT-UNIT Alpha 15 AC30.1 AC30.2
Element: Acct Unit The accounting unit is a shorthand AC30.3
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.
AOX-PF-ACCOUNT Numeric 6 AC30.1 AC30.2
Element: Post-from AccoThis field along with the accounting AC30.3
unit and subaccount make up the location
(account) where amounts and other
account information is stored.
AOX-PF-SUB-ACCT Numeric 4 AC30.1 AC30.2
Element: Post-from SubaThis field contains the subaccount from AC30.3
your general ledger chart of accounts
that was charged with the amount carried
on this record.
AOX-POOL-LIST Alpha 1 AC30.3
Element: Pool List This is the list of pools you are
allocating from.
AOX-SUM-ACCT-CAT Alpha 5 AC30.1
Element: Sum Acct Cat The name of the summary account
category.
ACALLOCX FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
AOXSET1 ALLOC-NAME AC130 AC131
LINE-NBR AC230 AC30.1
AC30.2 AC30.3
AC30.4
ACALLOCX FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME 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
|
