ACALLOC

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
Element: Allocation Name
Alpha 12
This is the allocation name. Allocation name is defined in AC30.1 (Allocation).
AC30.4
AOC-DESCRIPTION
Allocation
Description
Alpha 30 (Lower Case)
This is the allocation description.
AC30.4
AOC-POOL-NAME
Element: Allocation Pool
Alpha 12
This is the name assigned to the pool (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).
AC30.1 AC30.2
AC30.3
AOC-ALLOC-TYPE
Element: Alloc Type
Alpha 1
This field defines where the allocation will take place.
A = AC Only
B = Both AC and GL
AC30.4
AOC-OPERATOR
Element: Operator
Alpha 10
This field displays the login ID of the person who entered an allocation record.
AC30.1 AC30.2
AC30.3 AC30.4
AOC-AUTO-ZERO
Element: Auto Zero
Alpha 1
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
AC30.4
AOC-AUTO-REV
Element: Auto Reverse
Alpha 1
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
AC30.4
AOC-STATUS
Element: Status
Numeric 1
This is the allocation status.
0 = Unreleased
1 = Released
2 = Calculated
AC130 AC131
AC30.1 AC30.2
AC30.3 AC30.4
AC37.1 AC37.2
AOC-DEFAULT-DESC
Element: Default Description
Alpha 30 (Lower Case)
This 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.
AC30.4
AOC-PF-ACTIVITY
Element: Post-From Activity
Alpha 15
Optional. This field specifies the activity to which an offsetting transaction is posted.
AC30.4
AOC-PF-ACCT-CAT
Post-From Account
Category
Alpha 5
This is the account category of the post-from activity, to which an offsetting transaction is posted.
AC30.4
AOC-CONTROL-GROUP
Element: Control Group
Numeric 8
This is the control group number assigned to the transactions created by the most recent run of AC131 (Allocation Update).
AC131 AC30.4
AOC-MAINT-DATE
Element: Maintenance Date
Numeric 8 (yyyymmdd)
This is the date the allocation was last changed.
AC30.1 AC30.2
AC30.3 AC30.4
AOC-MAINT-TIME
Element: Maintenance Time
Numeric 6 (hhmmss)
This is the time the allocation was last changed.
AC30.1 AC30.2
AC30.3 AC30.4
AOC-RUN-DATE
Element: Run Date
Numeric 8 (yyyymmdd)
This is the date of the most recent processing run of AC131 (Allocation Update).
AC130
AOC-RUN-TIME
Element: Run Time
Numeric 6 (hhmmss)
This is the time of the most recent processing run of AC131 (Allocation Update).
AC130
AOC-ALLOCATED-DATE
Element: Allocated Date
Numeric 8 (yyyymmdd)
This is the date the allocation amount was allocated.
AC131
AOC-ALLOCATED-TIME
Element: Allocated Time
Numeric 6 (hhmmss)
This is the time the allocation amount was allocated.
AC131
AOC-TOTAL-PCT
Element: Total Percent
Signed 11.4
This is the sum of the percent values entered in the detail lines of AC30.1 (Allocation).
AC131 AC30.1
AC30.2 AC30.3
AOC-LAST-CMT-SEQ
Last Comment
Sequence Number
Numeric 4
This is the sequence number of the last comment for the allocation.
AOC-LAST-LINE-NBR
Element: Last Line Number
Numeric 6
This 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.
AC30.1 AC30.3
AOC-NBR-LINES
Number of Detail
Lines
Numeric 6
This field indicates the number of detail lines for the allocation.
AOC-NBR-CMT-LINES
Number of Comment
Lines
Numeric 6
This field indicates the number of comment lines for the allocation.
AOC-PT-COMPANY
Element: Post-to Company
Numeric 4
This is the company to post the allocation to.
AC30.4
AOC-PT-ACCT-UNIT
Post-to Accounting
Unit
Alpha 15
This is the accounting unit to post the allocation to.
AC30.4
AOC-PT-ACCOUNT
Element: Post-to Account
Numeric 6
This is the account to post the allocation to.
AC30.4
AOC-PT-SUB-ACCT
Element: Post-to Subaccount
Numeric 4
This is the subaccount to post the allocation to.
AC30.4
AOC-PT-LIST
Element: Post-to List
Alpha 12
This is the list to post the allocation to.
AC30.3
AOC-PF-COMPANY
Element: Post-from Company
Numeric 4
This is the company for the post-from activity, to which an offsetting transaction is posted.
AC30.4
AOC-PF-ACCT-UNIT
Post-from
Accounting Unit
Alpha 15
This is the accounting unit of the post-from activity, to which an offsetting transaction is posted.
AC30.4
AOC-PF-ACCOUNT
Element: Post-from Account
Numeric 6
This is the account for the post-from activity, to which an offsetting transaction is posted.
AC30.4
AOC-PF-SUB-ACCT
Element: Post-from Subaccount
Numeric 4
This is the subaccount for the post-from activity, to which an offsetting transaction is posted.
AC30.4
AOC-POOL-LIST
Element: Pool List
Alpha 1
Valid values are Yes or No.
Y = Yes
N = No
AC30.3
AOC-OFFSET-TYPE
Element: Offset Type
Alpha 1

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*
ALLOC-NAME
KeyChange
AC131 AC30.4


ACALLOC FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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
NAME
RELATED 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
Accatrans ACCATRANS
AOC-ALLOC-NAME->TRN-ALLOC-NAME
  TRN-LINE-NBR
  TRN-STEP
  TRN-SEQ-NUMBER
  TRN-ALLOC-GROUP


File created: Thu Jun 09 02:02:45 2016

Home
Contact Us



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