ACCHGORDX – Activity Change Order Detail

System: Activity Management (AC)
Prefix: CHX
Primary key: ACTIVITY-GRP, ACTIVITY, BUDGET-NBR, CHG-ORDER-NBR, ACCT-CATEGORY, FISCAL-YEAR, PERIOD
Fields: 23
Updated by: 17 programs
Referenced by: 5 programs

ACCHGORDX is the Activity Change Order Detail table in Lawson Activity Management (prefix CHX). It is indexed by ACTIVITY-GRP, ACTIVITY, BUDGET-NBR, CHG-ORDER-NBR, ACCT-CATEGORY, FISCAL-YEAR, PERIOD (CHXSET1); alternate indexes: CHXSET3. It is related 1:1 to ACACCTCAT, ACACTIVITY, ACBUDHDR and ACCHGORDER and 1:M to ACCHGORDX. It is updated by AC120, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5, AC20.7, AC21.1 and 9 more and referenced by AC10.1, AC10.5, AC310, AC421 and BR422. The table has 23 fields, 2 indexes and 6 documented relations.

About ACCHGORDX

This file contains budget change order detailed information from AC21.1 (Activity Group Budget Change Order) and AC21.2 (Activity Budget Change Order).

Fields (23)

Column = COBOL field name without the CHX- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / column	Type	Description & values	Updated by
#`CHX-ACTIVITY-GRP` PK ACTIVITY_GRP	Alpha 15	Required key. This is the activity group for the change order.	AC120, AC21.1, AC21.2, AC21.3, AC21.4, AC21.5, BR22.1
#`CHX-ACTIVITY` PK ACTIVITY	Alpha 15	Required key. This is the activity for the change order.	AC21.1, AC21.2, AC21.3, AC21.4, AC21.5, BR22.1
#`CHX-BUDGET-NBR` PK BUDGET_NBR	Numeric 3	Required key. This is the budget number uniquely defined in budget setup.	AC21.1, AC21.2, AC21.3, AC21.4, AC21.5
#`CHX-CHG-ORDER-NBR` PK CHG_ORDER_NBR	Alpha 5	Required key. This is the identification number for the change order.	AC21.1, AC21.2, AC21.3, AC21.4, AC21.5, BR22.1
#`CHX-ACCT-CATEGORY` PK ACCT_CATEGORY	Alpha 5	Required key. This is the account category for the change order.	AC21.1, AC21.2, AC21.3, AC21.4, AC21.5
#`CHX-FISCAL-YEAR` PK FISCAL_YEAR	Numeric 4	Required key. This is the fiscal year for the budget.	AC21.1, AC21.2, AC21.3, AC21.4, AC21.5
#`CHX-PERIOD` PK PERIOD	Numeric 2	Required key. This is the fiscal period for the budget.	AC21.1, AC21.2, AC21.3, AC21.4, AC21.5
#`CHX-BASE-ND` BASE_ND	Numeric 1	Required. This is the number of decimal positions defined for the budget currency.	AC21.1, AC21.2, AC21.3, AC21.4, AC21.5, BR22.1
#`CHX-AMOUNT` AMOUNT	Signed 18.2	Required. This is the calculated amount, including the change order, for the account category for the period.	AC21.1, AC21.2, AC21.3, AC21.4, AC21.5, BR22.1
#`CHX-ENTERED-AMT` ENTERED_AMT	Signed 18.2	This is the new amount, including the change order, as entered for the account category for the period.	AC21.1, AC21.2, AC21.3, AC21.4, AC21.5, BR22.1
#`CHX-PRIOR-AMOUNT` PRIOR_AMOUNT	Signed 18.2	This is the period amount for the account category prior to the budget change order.	AC21.1, AC21.2, AC21.3, AC21.4, AC21.5, BR22.1
#`CHX-UNIT` UNIT	Signed 15.2	This is the calculated units budget, including the change order, for the account category for the period.	AC21.1, AC21.2, AC21.3, AC21.4, AC21.5
#`CHX-ENTERED-UNIT` ENTERED_UNIT	Signed 15.2	This is the new units budget, including the change order, as entered for the account category for the period.	AC21.1, AC21.2, AC21.3, AC21.4, AC21.5
#`CHX-PRIOR-UNIT` PRIOR_UNIT	Signed 15.2	This is the period units budget for the account category prior to the budget change order.	AC21.1, AC21.2, AC21.3, AC21.4, AC21.5
#`CHX-BLANK` BLANK	Derived	This derived field is always blank. It is used in the Drill Around feature for column headings.	—
#`CHX-FACTOR` FACTOR	Alpha 15	This is the calculated factor, including the change order, for the budget.	AC21.1, AC21.2, AC21.3, AC21.4, AC21.5
#`CHX-PRIOR-FACTOR` PRIOR_FACTOR	Alpha 15	This is the prior factor for the budget.	AC21.1, AC21.2, AC21.3, AC21.4, AC21.5
#`CHX-FACTOR-RATE` FACTOR_RATE	Signed 14.7	This is the calculated factor rate, including the change order, for the budget.	AC21.1, AC21.2, AC21.3, AC21.4, AC21.5
#`CHX-ENTERED-F-RATE` ENTERED_F_RATE	Signed 14.7	This is the factor rate, including the change order, as entered for the budget.	AC21.1, AC21.2, AC21.3, AC21.4, AC21.5
#`CHX-PRIOR-F-RATE` PRIOR_F_RATE	Signed 14.7	This is the prior factor rate for the budget.	AC21.1, AC21.2, AC21.3, AC21.4, AC21.5
#`CHX-SPREAD-CODE` SPREAD_CODE	Alpha 3	A spread code is a formula for budgeting spending activity that can be set up in AC23.1 (Spread Codes) for each account category. You can use a spread code to schedule spending over the life of the activity or activity group. Spread codes can be used to represent the characteristic spending pattern of each account category.	AC21.2
#`CHX-CHANGE-AMOUNT` CHANGE_AMOUNT	Derived	This is the change amount (the change order information) for the account category for the period.	—
#`CHX-CHANGE-UNITS` CHANGE_UNITS	Derived	This is the change number of units (the change order information) for the account category for the period.	—

Indexes (2)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Condition	Used in
`CHXSET1`	`ACTIVITY-GRP` `ACTIVITY` `BUDGET-NBR` `CHG-ORDER-NBR` `ACCT-CATEGORY` `FISCAL-YEAR` `PERIOD`	Primary		AC10.1, AC10.5, AC120, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +14 more
`CHXSET3`	`ACTIVITY-GRP` `ACTIVITY` `BUDGET-NBR` `CHG-ORDER-NBR` `FISCAL-YEAR` `PERIOD` `ACCT-CATEGORY`	KeyChange		AC21.1, AC21.2, AC21.3, AC21.4, AC21.5, BR22.1, BR422

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)

One to one (5) — lookups and parents

Relation Table Rules Condition Field map

Acacctcat

ACACCTCAT

Required

CHX-ACCT-CATEGORY → AAX-ACCT-CATEGORY

Acactivity

ACACTIVITY

Not Required

CHX-ACTIVITY → ACV-ACTIVITY

Acbudhdr

ACBUDHDR

Required

`CHX-ACTIVITY-GRP`	→	`BDH-ACTIVITY-GRP`
`CHX-ACTIVITY`	→	`BDH-ACTIVITY`
`CHX-BUDGET-NBR`	→	`BDH-BUDGET-NBR`

Acchgorder

ACCHGORDER

Required

When CHX-BUDGET-NBR != Zeroes

`CHX-ACTIVITY-GRP`	→	`CHO-ACTIVITY-GRP`
`CHX-ACTIVITY`	→	`CHO-ACTIVITY`
`CHX-BUDGET-NBR`	→	`CHO-BUDGET-NBR`
`CHX-CHG-ORDER-NBR`	→	`CHO-CHG-ORDER-NBR`

Acchgorder Cnt

ACCHGORDER

Required

When ACV-POSTING-FLAG = "C"

`CHX-ACTIVITY-GRP`	→	`CHO-ACTIVITY-GRP`
`CHX-ACTIVITY`	→	`CHO-ACTIVITY`
`CHX-BUDGET-NBR`	→	`CHO-BUDGET-NBR`
`CHX-CHG-ORDER-NBR`	→	`CHO-CHG-ORDER-NBR`

One to many (1) — child tables

Relation Table Rules Condition Field map

Acchgordx Dtl

ACCHGORDX

Valid When ACV-POSTING-FLAG = "C"

`CHX-ACTIVITY-GRP`	→	`CHX-ACTIVITY-GRP`
—	→	`CHX-ACTIVITY`
—	→	`CHX-BUDGET-NBR`
—	→	`CHX-CHG-ORDER-NBR`
—	→	`CHX-ACCT-CATEGORY`
—	→	`CHX-FISCAL-YEAR`
—	→	`CHX-PERIOD`

Programs

Updated by (17)

AC120 Level Reorganization
AC20.1 Life Only Budget
AC20.2 Annual Budget
AC20.3 Period Budget
AC20.4 Activity Budgets by Activity
AC20.5 Activity Budgets by Account Category
AC20.7 Activity Budget Header
AC21.1 Life Only Budget Change Order
AC21.2 Annual Budget Change Order
AC21.3 Period Budget Change Order
AC21.4 Activity Budget Change Orders by Activity
AC21.5 Period Budget Change Order Import
AC22.1 Change Order Approval
AC300 Activity Group Purge
AC311 Purge and Archive
BR10.1 Contract Parameters
BR22.1 Contract Change Orders

Referenced by (5)

AC10.1 Activity
AC10.5 Mass Activity Move
AC310 Transaction Consolidation
AC421 Change Order History
BR422 Contract Change Order History Report

ACCHGORDX – Activity Change Order Detail

About ACCHGORDX

Fields (23) Copy as SQL

Indexes (2)

Relations

One to one (5) — lookups and parents

One to many (1) — child tables

Programs

Updated by (17)

Referenced by (5)

Fields (23)