ACALLOC – Activity Allocation

System: Activity Management (AC)
Prefix: AOC
Primary key: ALLOC-NAME
Fields: 34
Updated by: 8 programs
Referenced by: 2 programs

ACALLOC is the Activity Allocation table in Lawson Activity Management (prefix AOC). It is indexed by ALLOC-NAME (AOCSET1); alternate indexes: AOCSET2. It is related 1:1 to ACACCTCAT, ACACTIVITY and ACPOOLHDR and 1:M to ACALLOCX and ACCATRANS. It is updated by AC130, AC131, AC30.1, AC30.2, AC30.3, AC30.4, AC37.1 and AC37.2 and referenced by AC230 and AC32.1. The table has 34 fields, 2 indexes and 6 documented relations.

About ACALLOC

The Activity Allocation file stores information on new allocations from AC30.3 (New Allocation).

Fields (34)

Column = COBOL field name without the AOC- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / column	Type	Description & values	Updated by
`AOC-ALLOC-NAME` PK ALLOC_NAME	Alpha 12	This is the allocation name. Allocation name is defined in AC30.1 (Allocation).	AC30.4
`AOC-DESCRIPTION` DESCRIPTION	Alpha 30 (Lower Case)	This is the allocation description.	AC30.4
`AOC-POOL-NAME` POOL_NAME	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` 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` 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` 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` AUTO_REV	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` 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` DEFAULT_DESC	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` PF_ACTIVITY	Alpha 15	Optional. This field specifies the activity to which an offsetting transaction is posted.	AC30.4
`AOC-PF-ACCT-CAT` PF_ACCT_CAT	Alpha 5	This is the account category of the post-from activity, to which an offsetting transaction is posted.	AC30.4
`AOC-CONTROL-GROUP` 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` MAINT_DATE	Numeric 8 (yyyymmdd)	This is the date the allocation was last changed.	AC30.1, AC30.2, AC30.3, AC30.4
`AOC-MAINT-TIME` MAINT_TIME	Numeric 6 (hhmmss)	This is the time the allocation was last changed.	AC30.1, AC30.2, AC30.3, AC30.4
`AOC-RUN-DATE` RUN_DATE	Numeric 8 (yyyymmdd)	This is the date of the most recent processing run of AC131 (Allocation Update).	AC130
`AOC-RUN-TIME` RUN_TIME	Numeric 6 (hhmmss)	This is the time of the most recent processing run of AC131 (Allocation Update).	AC130
`AOC-ALLOCATED-DATE` ALLOCATED_DATE	Numeric 8 (yyyymmdd)	This is the date the allocation amount was allocated.	AC131
`AOC-ALLOCATED-TIME` ALLOCATED_TIME	Numeric 6 (hhmmss)	This is the time the allocation amount was allocated.	AC131
`AOC-TOTAL-PCT` TOTAL_PCT	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_CMT_SEQ	Numeric 4	This is the sequence number of the last comment for the allocation.	—
`AOC-LAST-LINE-NBR` LAST_LINE_NBR	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` NBR_LINES	Numeric 6	This field indicates the number of detail lines for the allocation.	—
`AOC-NBR-CMT-LINES` NBR_CMT_LINES	Numeric 6	This field indicates the number of comment lines for the allocation.	—
`AOC-PT-COMPANY` PT_COMPANY	Numeric 4	This is the company to post the allocation to.	AC30.4
`AOC-PT-ACCT-UNIT` PT_ACCT_UNIT	Alpha 15	This is the accounting unit to post the allocation to.	AC30.4
`AOC-PT-ACCOUNT` PT_ACCOUNT	Numeric 6	This is the account to post the allocation to.	AC30.4
`AOC-PT-SUB-ACCT` PT_SUB_ACCT	Numeric 4	This is the subaccount to post the allocation to.	AC30.4
`AOC-PT-LIST` PT_LIST	Alpha 12	This is the list to post the allocation to.	AC30.3
`AOC-PF-COMPANY` PF_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` PF_ACCT_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` PF_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` PF_SUB_ACCT	Numeric 4	This is the subaccount for the post-from activity, to which an offsetting transaction is posted.	AC30.4
`AOC-POOL-LIST` POOL_LIST	Alpha 1	Valid values are Yes or No. `Y` Yes `N` No	AC30.3
`AOC-OFFSET-TYPE` OFFSET_TYPE	Alpha 1	— `1` AC Only `2` GL Only `3` AC and GL `4` None	—

Indexes (2)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Condition	Used in
`AOCSET1`	`ALLOC-NAME`	Primary		AC130, AC131, AC230, AC30.1, AC30.2, AC30.3, AC30.4, AC32.1 +2 more
`AOCSET2`	`CONTROL-GROUP*`, `ALLOC-NAME`	KeyChange		AC131, AC30.4

Relations

One to one (3) — lookups and parents

Relation	Table	Rules	Field map
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`

One to many (3) — child tables

Relation	Table	Field map
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`

Programs

Updated by (8)

AC130 Allocation Calculation
AC131 Allocation Update
AC30.1 Allocation
AC30.2 Multiple Pool Allocation
AC30.3 List Allocation
AC30.4 New Allocation
AC37.1 Allocation Group
AC37.2 Allocation Group by Step

Referenced by (2)

AC230 Allocation Listing
AC32.1 Allocation Pool