ACALLOCX – Activity Allocation Detail

System: Activity Management (AC)
Prefix: AOX
Primary key: ALLOC-NAME, LINE-NBR
Fields: 39
Updated by: 6 programs
Referenced by: 1 program

ACALLOCX is the Activity Allocation Detail table in Lawson Activity Management (prefix AOX). It is indexed by ALLOC-NAME, LINE-NBR (AOXSET1). It is related 1:1 to ACACCTCAT, ACACTGRP, ACACTIVITY, ACALLOC, ACCMPPARAM, ACPOOLHDR and CMPUTE and 1:M to ACCATRANS. It is updated by AC130, AC131, AC30.1, AC30.2, AC30.3 and AC30.4 and referenced by AC230. The table has 39 fields, 1 index and 10 documented relations.

About ACALLOCX

This file contains detailed information about allocations, as defined in AC30.1 (Allocation) and AC30.2 (Multiple Pool Allocation).

Fields (39)

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

Field / column	Type	Description & values	Updated by
`AOX-ALLOC-NAME` PK ALLOC_NAME	Alpha 12	Required key. This is the allocation to which this line belongs.	AC30.1, AC30.2, AC30.3
`AOX-LINE-NBR` PK LINE_NBR	Numeric 6	Required key. This field contains the line number.	AC30.1, AC30.2, AC30.3
`AOX-PT-ACTIVITY` PT_ACTIVITY	Alpha 15	This is the activity to which the allocation is posted.	AC130, AC30.1, AC30.2, AC30.3
`AOX-PT-ACTIVITY-ND` PT_ACTIVITY_ND	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` ACTIVITY_GRP	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` PT_ACCT_CAT	Alpha 5	This is the account category to which the allocation is posted.	AC30.1, AC30.2, AC30.3
`AOX-POOL-NAME` POOL_NAME	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` PT_POST_OPTION	Alpha 1	The post-to posting option determines the kind of detail produced by the allocation. transaction for the allocation. for each account category, to be posted to the corresponding account category in the post-to activity. transaction for each account category and General Ledger account, to be posted to the post-to activity and account categories. `C` Consolidate. Create a single `P` Pool. Create a separate transaction `D` Detail. Create a separate	AC30.1, AC30.2, AC30.3
`AOX-TRANS-TYPE` TRANS_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` UNIT_MEASURE	Alpha 12	—	AC30.1, AC30.2, AC30.3
`AOX-AUTO-REV` AUTO_REV	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_PER_ALLOC	Numeric 2	This is the period most recently allocated.	AC131
`AOX-REV-OBJ-ID` REV_OBJ_ID	Numeric 12	This field contains identifying information for the creation of an auto-reversing entry.	—
`AOX-PTD-ALLOCATED` PTD_ALLOCATED	Signed 18.2	This is the period-to-date allocated amount.	AC131
`AOX-DESCRIPTION` 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` PF_ACTIVITY	Alpha 15	Optional. This the activity to which an offsetting entry is made.	AC30.1, AC30.2, AC30.3
`AOX-PF-ACCT-CAT` PF_ACCT_CAT	Alpha 5	Optional. This is the account category to which an offsetting entry is made.	AC30.1, AC30.2, AC30.3
`AOX-ALLOC-PERCENT` ALLOC_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` WEIGHT_VAL	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` WGT_ACTIVITY	Alpha 15	This is the activity for the weighting factor.	AC30.1
`AOX-FR-ACCT-CAT` FR_ACCT_CAT	Alpha 5	This is the beginning account category of the account category range for the allocation.	AC30.1
`AOX-TH-ACCT-CAT` TH_ACCT_CAT	Alpha 5	This is the ending account category of the account category range for the allocation.	AC30.1
`AOX-GROUP` GROUP	Alpha 15	This is the allocation group for the allocation.	AC30.1
`AOX-WGT-TRANS-TYPE` WGT_TRANS_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` WGT_BUDGET_NBR	Numeric 3	This is the budget number for the weighting factor.	AC30.1, AC30.2, AC30.3
`AOX-WGT-CUM-BASIS` WGT_CUM_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_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` PARAM_NAME	Alpha 12	—	AC30.1, AC30.2, AC30.3
`AOX-PT-COMPANY` PT_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` PT_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-PT-ACCOUNT` PT_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` PT_SUB_ACCT	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` PT_LIST	Alpha 12	This is the post-to list of activities you are posting the allocation to.	AC30.3
`AOX-PF-COMPANY` PF_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` PF_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` PF_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` PF_SUB_ACCT	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` POOL_LIST	Alpha 1	This is the list of pools you are allocating from.	AC30.3
`AOX-SUM-ACCT-CAT` SUM_ACCT_CAT	Alpha 5	The name of the summary account category.	AC30.1

Indexes (1)

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
`AOXSET1`	`ALLOC-NAME`, `LINE-NBR`	Primary		AC130, AC131, AC230, AC30.1, AC30.2, AC30.3, AC30.4

Relations

One to one (9) — lookups and parents

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

One to many (1) — child tables

Relation	Table	Rules	Condition	Field map
Accatrans	ACCATRANS			`AOX-ALLOC-NAME` → `TRN-ALLOC-NAME`, → `TRN-LINE-NBR`, → `TRN-STEP`, → `TRN-SEQ-NUMBER`, → `TRN-ALLOC-GROUP`

Programs

Updated by (6)

AC130 Allocation Calculation
AC131 Allocation Update
AC30.1 Allocation
AC30.2 Multiple Pool Allocation
AC30.3 List Allocation
AC30.4 New Allocation

Referenced by (1)

AC230 Allocation Listing