|
|
ACALLOC FILE
Activity Allocation
The Activity Allocation file stores information on new allocations from
AC30.3 (New Allocation).
REFERENCED BY
AC230 AC32.1
UPDATED BY
AC130 AC131 AC30.1 AC30.2 AC30.3 AC30.4
AC37.1 AC37.2
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
AOC-ALLOC-NAME Alpha 12 AC30.4
Element: Allocation NamThis is the allocation name. Allocation
name is defined in AC30.1 (Allocation).
AOC-DESCRIPTION Alpha 30 (Lower Case) AC30.4
Allocation This is the allocation description.
Description
AOC-POOL-NAME Alpha 12 AC30.1 AC30.2
Element: Allocation PooThis is the name assigned to the pool AC30.3
(or amount to be allocated). A pool
consists of posted monetary amounts or
statistical units found in ranges of
activities and account categories, or
ranges of companies, accounting units,
accounts, and subaccounts specified in
AC32.1 (Allocation Pool).
Pool balances can be accumulated on a
period, year-to-date, or life-to-date
(for activity pools only) basis. A pool
is attached to an allocation in AC30.1
(Allocation) or to individual allocation
lines in AC30.2 (Multiple Pool
Allocation).
AOC-ALLOC-TYPE Alpha 1 AC30.4
Element: Allocation TypThis field defines where the allocation
will take place.
A = AC Only
B = Both AC and GL
AOC-OPERATOR Alpha 10 AC30.1 AC30.2
Element: Operator This field displays the login ID of the AC30.3 AC30.4
person who entered an allocation record.
AOC-AUTO-ZERO Alpha 1 AC30.4
Element: Auto Zero If you set this field to Yes (Y),
percents you enter in AC30.1
(Allocation) are zeroed out after the
allocation is processed.
Y = Yes
N = No
AOC-AUTO-REV Alpha 1 AC30.4
Element: Auto Reverse If you set this field to Yes (Y), a
reversing entry is created by AC131
(Allocation Update) in the run following
the run that creates the original entry.
Y = Yes
N = No
AOC-STATUS Numeric 1 AC130 AC131
Element: Status This is the allocation status. AC30.1 AC30.2
0 = Unreleased AC30.3 AC30.4
1 = Released AC37.1 AC37.2
2 = Calculated
AOC-DEFAULT-DESC Alpha 30 (Lower Case) AC30.4
Element: Default DescriThis description becomes the
transaction description for each
transaction whose Description field in
AC30.6 (Entry) has been left blank.
If this field is left blank in AC30.3
(New Allocation), the allocation
description defaults into this field.
AOC-PF-ACTIVITY Alpha 15 AC30.4
Element: Post-From ActiOptional. This field specifies the
activity to which an offsetting
transaction is posted.
AOC-PF-ACCT-CAT Alpha 5 AC30.4
Post-From Account This is the account category of the
Category post-from activity, to which an
offsetting transaction is posted.
AOC-CONTROL-GROUP Numeric 8 AC131 AC30.4
Element: Control Group This is the control group number
assigned to the transactions created by
the most recent run of AC131 (Allocation
Update).
AOC-MAINT-DATE Numeric 8 (yyyymmdd) AC30.1 AC30.2
Element: Maintenance DaThis is the date the allocation was AC30.3 AC30.4
last changed.
AOC-MAINT-TIME Numeric 6 (hhmmss) AC30.1 AC30.2
Element: Maintenance TiThis is the time the allocation was AC30.3 AC30.4
last changed.
AOC-RUN-DATE Numeric 8 (yyyymmdd) AC130
Element: Run Date This is the date of the most recent
processing run of AC131 (Allocation
Update).
AOC-RUN-TIME Numeric 6 (hhmmss) AC130
Element: Run Time This is the time of the most recent
processing run of AC131 (Allocation
Update).
AOC-ALLOCATED-DATE Numeric 8 (yyyymmdd) AC131
Element: Allocated DateThis is the date the allocation amount
was allocated.
AOC-ALLOCATED-TIME Numeric 6 (hhmmss) AC131
Element: Allocated TimeThis is the time the allocation amount
was allocated.
AOC-TOTAL-PCT Signed 11.4 AC131 AC30.1
Element: Total Percent This is the sum of the percent values AC30.2 AC30.3
entered in the detail lines of AC30.1
(Allocation).
AOC-LAST-CMT-SEQ Numeric 4
Last Comment This is the sequence number of the last
Sequence Number comment for the allocation.
AOC-LAST-LINE-NBR Numeric 6 AC30.1 AC30.3
Element: Last Line NumbThis is the number of the last line
item added to the allocation. It is used
to determine the line number when the
next line is added to the allocation.
AOC-NBR-LINES Numeric 6
Number of Detail This field indicates the number of
Lines detail lines for the allocation.
AOC-NBR-CMT-LINES Numeric 6
Number of Comment This field indicates the number of
Lines comment lines for the allocation.
AOC-PT-COMPANY Numeric 4 AC30.4
Element: Post-to CompanThis is the company to post the
allocation to.
AOC-PT-ACCT-UNIT Alpha 15 AC30.4
Post-to Accounting This is the accounting unit to post the
Unit allocation to.
AOC-PT-ACCOUNT Numeric 6 AC30.4
Element: Post-to AccounThis is the account to post the
allocation to.
AOC-PT-SUB-ACCT Numeric 4 AC30.4
Element: Post-to SubaccThis is the subaccount to post the
allocation to.
AOC-PT-LIST Alpha 12 AC30.3
Element: Post-to List This is the list to post the allocation
to.
AOC-PF-COMPANY Numeric 4 AC30.4
Element: Post-from CompThis is the company for the post-from
activity, to which an offsetting
transaction is posted.
AOC-PF-ACCT-UNIT Alpha 15 AC30.4
Post-from This is the accounting unit of the
Accounting Unit post-from activity, to which an
offsetting transaction is posted.
AOC-PF-ACCOUNT Numeric 6 AC30.4
Element: Post-from AccoThis is the account for the post-from
activity, to which an offsetting
transaction is posted.
AOC-PF-SUB-ACCT Numeric 4 AC30.4
Element: Post-from SubaThis is the subaccount for the
post-from
activity, to which an offsetting
transaction is posted.
AOC-POOL-LIST Alpha 1 AC30.3
Element: Pool List Valid values are Yes or No.
Y = Yes
N = No
AOC-OFFSET-TYPE Alpha 1
Element: Offset Type 1 = AC Only
2 = GL Only
3 = AC and GL
4 = None
ACALLOC FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
AOCSET1 ALLOC-NAME AC130 AC131
AC230 AC30.1
AC30.2 AC30.3
AC30.4 AC32.1
AC37.1 AC37.2
AOCSET2 CONTROL-GROUP*KeyChange AC131 AC30.4
ALLOC-NAME
ACALLOC FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acacctcat ACACCTCAT Not Required
AOC-PF-ACCT-CAT -> AAX-ACCT-CATEGORY
Acactivity ACACTIVITY Not Required
AOC-PF-ACTIVITY -> ACV-ACTIVITY
Acpoolhdr ACPOOLHDR Required
AOC-POOL-NAME -> POL-POOL-NAME
ACALLOC FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acallocgp ACALLOCX
AOC-ALLOC-NAME -> AOX-ALLOC-NAME
AOX-LINE-NBR
Acallocx ACALLOCX
AOC-ALLOC-NAME -> AOX-ALLOC-NAME
AOX-LINE-NBR
|
