ACCHGORDER – Activity Change Order

System
Activity Management (AC)
Prefix
CHO
Primary key
ACTIVITY-GRP, ACTIVITY, BUDGET-NBR, CHG-ORDER-NBR
Fields
12
Updated by
23 programs
Referenced by
4 programs

ACCHGORDER is the Activity Change Order table in Lawson Activity Management (prefix CHO). It is indexed by ACTIVITY-GRP, ACTIVITY, BUDGET-NBR, CHG-ORDER-NBR (CHOSET1); alternate indexes: CHOSET2 and CHOSET3. It is related 1:1 to ACACTGRP, ACACTIVITY and ACBUDHDR and 1:M to ACCHGORDX. It is updated by AC10.1, AC10.5, AC120, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 and 15 more and referenced by AC121, AC127, AC27.1 and AC310. The table has 12 fields, 3 indexes and 5 documented relations.

About ACCHGORDER

This file contains budget change order information from AC21.1 (Budget Change Orders). It includes activity group, activity, budget number, change order number, approval information, maintenance date and time, and a released flag.

Fields (12)

Column = COBOL field name without the CHO- 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 / columnTypeDescription & valuesUpdated by
#CHO-ACTIVITY-GRP PK
ACTIVITY_GRP		Alpha 15Required key. This is the activity group for the change order..AC120, AC21.1, AC21.2, AC21.3, AC21.4, AC21.5, AC22.1, BR22.1
#CHO-ACTIVITY PK
ACTIVITY		Alpha 15Required key. This is the activity for the change order.AC21.1, AC21.2, AC21.3, AC21.4, AC21.5, AC22.1, BR22.1
#CHO-BUDGET-NBR PK
BUDGET_NBR		Numeric 3Required key. This is the budget number uniquely defined in budget setup.AC21.1, AC21.2, AC21.3, AC21.4, AC21.5, AC22.1
#CHO-CHG-ORDER-NBR PK
CHG_ORDER_NBR		Alpha 5Required key. This is the identification number for the change order.AC21.1, AC21.2, AC21.3, AC21.4, AC21.5, AC22.1, BR22.1
#CHO-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)This field displays the description.AC21.1, AC21.2, AC21.3, AC21.4, AC21.5, BR22.1
#CHO-APPROVAL-FLAG
APPROVAL_FLAG		Alpha 1This flag indicates whether the change order is approved.. Use Yes if the change order is approved. Use No if the change order is not approved.
  • Y Approved
  • N Not Approved
AC21.1, AC21.2, AC21.3, AC21.4, AC21.5, AC22.1, BR22.1
#CHO-APPROVAL
APPROVAL		Alpha 15This field is for the name of the person who approved the change order.AC21.1, AC21.2, AC21.3, AC21.4, AC21.5, AC22.1, BR22.1
#CHO-MAINT-DATE SET3
MAINT_DATE		Numeric 8 (yyyymmdd)This is the date the budget was last changed.AC21.1, AC21.2, AC21.3, AC21.4, AC21.5, AC22.1, BR22.1
#CHO-MAINT-TIME SET3
MAINT_TIME		Numeric 6 (hhmmss)This is the time the budget was last changed.AC21.1, AC21.2, AC21.3, AC21.4, AC21.5, AC22.1, BR22.1
#CHO-RELEASED
RELEASED		Alpha 1This flag indicates whether the change order has been released. Budgets are not changed until the change orders are released.
  • Y Released
  • N Unreleased
AC21.1, AC21.2, AC21.3, AC21.4, AC21.5, AC22.1, BR22.1
#CHO-EFFECTIVE-DATE
EFFECTIVE_DATE		Numeric 8 (yyyymmdd)The date a vendor's prices will be in effect.AC21.1, AC21.2, AC21.3, AC21.4, AC21.5, BR22.1
#CHO-FORMED-USED
FORMED_USED		Numeric 1This field indicates the form used to define the change order. Use 1 for AC21.1 (Activity Group Budget Change Orders) and use 2 for AC21.2 (Activity Budget Change Orders). You must maintain a change order on the same form where you defined it originally.
  • 1 AC21.1
  • 2 AC21.2
  • 3 AC21.3
  • 4 AC21.4
  • 5 BR22
AC21.1, AC21.2, AC21.3, AC21.4, AC21.5, BR22.1

Indexes (3)

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.

IndexKeysFlagsConditionUsed in
CHOSET1
  1. ACTIVITY-GRP
  2. ACTIVITY
  3. BUDGET-NBR
  4. CHG-ORDER-NBR
PrimaryAC10.1, AC10.5, AC120, AC121, AC127, AC20.1, AC20.2, AC20.3 +19 more
CHOSET2
  1. ACTIVITY-GRP
  2. ACTIVITY
  3. BUDGET-NBR
  4. CHG-ORDER-NBR
KeyChange, SubsetWhere (RELEASED = "N")AC21.1, AC21.2, AC21.3, AC21.4, BR22.1
CHOSET3
  1. ACTIVITY-GRP
  2. ACTIVITY
  3. BUDGET-NBR
  4. MAINT-DATE
  5. MAINT-TIME
  6. CHG-ORDER-NBR
KeyChangeAC21.1, AC21.2, AC21.3, AC21.4, AC421

Relations

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

One to one (3) — lookups and parents

RelationTableRulesConditionField map
AcactgrpACACTGRPRequired
CHO-ACTIVITY-GRP→AGP-ACTIVITY-GRP
AcactivityACACTIVITYRequired
CHO-ACTIVITY→ACV-ACTIVITY
AcbudhdrACBUDHDRRequired
CHO-ACTIVITY-GRP→BDH-ACTIVITY-GRP
CHO-ACTIVITY→BDH-ACTIVITY
CHO-BUDGET-NBR→BDH-BUDGET-NBR

One to many (2) — child tables

RelationTableRulesConditionField map
AcchgordxACCHGORDXValid When CHO-BUDGET-NBR != Zeroes
CHO-ACTIVITY-GRP→CHX-ACTIVITY-GRP
CHO-ACTIVITY→CHX-ACTIVITY
CHO-BUDGET-NBR→CHX-BUDGET-NBR
CHO-CHG-ORDER-NBR→CHX-CHG-ORDER-NBR
—→CHX-ACCT-CATEGORY
—→CHX-FISCAL-YEAR
—→CHX-PERIOD
Acchgordx CntACCHGORDXValid When CHO-BUDGET-NBR = Zeroes
CHO-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 (23)

Referenced by (4)