ACACTCOPY – This file contains parameters used to mass copy activities from existing activity structures.

System
Activity Management (AC)
Prefix
CYY
Primary key
RUN-GROUP, SEQ-NUMBER
Fields
36
Updated by
2 programs
Referenced by
3 programs

ACACTCOPY is the This file contains parameters used to mass copy activities from existing activity structures. table in Lawson Activity Management (prefix CYY). It is indexed by RUN-GROUP, SEQ-NUMBER (CYYSET1); alternate indexes: CYYSET2, CYYSET3, CYYSET4, CYYSET5, CYYSET6 and CYYSET8. It is related 1:1 to ACCOPYRULE and ACLEVRULE. It is updated by AC01.1 and AC110 and referenced by AC10.1, AC11.1 and AC500. The table has 36 fields, 7 indexes and 2 documented relations.

About ACACTCOPY

This file contains parameters used to mass copy activities from existing activity structures. AC01 (Mass Activity Copy) to establish parameters used by AC110 (Activity Copy) to create new activities from existing similiar activities.

Fields (36)

Column = COBOL field name without the CYY- 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
#CYY-RUN-GROUP PK
RUN_GROUP		Alpha 15Run Group and Seq Number are the keys to the file. They should be used to group records together for interfacing.AC01.1
#CYY-SEQ-NUMBER PK
SEQ_NUMBER		Numeric 6A unique number assigned to each transaction to be interfaced into the Lawson system.AC01.1
#CYY-CPY-ACT-GRP
CPY_ACT_GRP		Alpha 15—AC01.1
#CYY-CPY-FR-ACT
CPY_FR_ACT		Alpha 15—AC01.1
#CYY-CPY-TH-ACT
CPY_TH_ACT		Alpha 15—AC01.1
#CYY-CPY-FR-VAR-LEV
CPY_FR_VAR_LEV		Alpha 30—AC01.1
#CYY-CPY-TH-VAR-LEV
CPY_TH_VAR_LEV		Alpha 30—AC01.1
#CYY-CPY-LIST
CPY_LIST		Alpha 12—AC01.1
#CYY-TO-ACT-GRP SET2
TO_ACT_GRP		Alpha 15—AC01.1
#CYY-COPY-RULE
COPY_RULE		Alpha 12—AC01.1
#CYY-LEVEL-RULE
LEVEL_RULE		Alpha 12—AC01.1
#CYY-OLD-ACT-GRP
OLD_ACT_GRP		Alpha 35—AC01.1
#CYY-OLD-ACTIVITY SET2
OLD_ACTIVITY		Alpha 35—AC01.1
#CYY-OLD-LEVELS SET8
OLD_LEVELS		Alpha 30The level the Accounting Unit was changed from.AC01.1
#CYY-OLD-DEPTH
OLD_DEPTH		Numeric 1—AC01.1
#CYY-OLD-POSTING-FL
OLD_POSTING_FL		Alpha 1—AC01.1
#CYY-NEW-ACTIVITY SET2 SET3
NEW_ACTIVITY		Alpha 30—AC01.1
#CYY-NEW-LEVELS SET6
NEW_LEVELS		Alpha 30The level the Accounting Unit was changed to.AC01.1
#CYY-NEW-DEPTH
NEW_DEPTH		Numeric 1—AC01.1
#CYY-NEW-DETAIL-1
NEW_DETAIL_1		Numeric 15—AC01.1
#CYY-NEW-DETAIL-2
NEW_DETAIL_2		Numeric 15—AC01.1
#CYY-NEW-DETAIL-3
NEW_DETAIL_3		Numeric 15—AC01.1
#CYY-NEW-DETAIL-4
NEW_DETAIL_4		Numeric 15—AC01.1
#CYY-NEW-DETAIL-5
NEW_DETAIL_5		Numeric 15—AC01.1
#CYY-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)This field displays the description.AC01.1
#CYY-LONG-DESC
LONG_DESC		Alpha 60 (Lower Case)Occurs 4 Times Long description.AC01.1
#CYY-POSTING-FLAG
POSTING_FLAG		Alpha 1—AC01.1
#CYY-PARENT-ACTVY SET4
PARENT_ACTVY		Alpha 30—AC01.1
#CYY-PARENT-LEVELS
PARENT_LEVELS		Alpha 30——
#CYY-PARENT-DEPTH SET4
PARENT_DEPTH		Numeric 1—AC01.1
#CYY-PARENT-DETAIL
PARENT_DETAIL		Numeric 15 Occurs 5 Times ×5——
#CYY-FREEZE
FREEZE		Alpha 1—AC01.1
#CYY-JOB-NAME
JOB_NAME		Alpha 10——
#CYY-UNDER-ACTIVITY
UNDER_ACTIVITY		Alpha 15——
#CYY-BEGIN-DATE
BEGIN_DATE		Numeric 8 (yyyymmdd)Begin Date for the new activity being added.AC01.1
#CYY-END-DATE
END_DATE		Numeric 8 (yyyymmdd)End date for the new activity being added.AC01.1

Indexes (7)

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
CYYSET1
  1. RUN-GROUP
  2. SEQ-NUMBER
PrimaryAC01.1, AC110
CYYSET2
  1. RUN-GROUP
  2. TO-ACT-GRP
  3. OLD-ACTIVITY
  4. NEW-ACTIVITY
  5. SEQ-NUMBER
KeyChangeAC01.1
CYYSET3
  1. NEW-ACTIVITY
  2. RUN-GROUP
  3. SEQ-NUMBER
KeyChangeAC01.1, AC10.1, AC11.1, AC500
CYYSET4
  1. RUN-GROUP
  2. PARENT-DEPTH
  3. PARENT-ACTVY
  4. SEQ-NUMBER
KeyChangeAC01.1
CYYSET5
  1. RUN-GROUP
  2. SEQ-NUMBER ↓
AC01.1
CYYSET6
  1. RUN-GROUP
  2. NEW-LEVELS
  3. SEQ-NUMBER
KeyChangeAC01.1, AC110
CYYSET8
  1. RUN-GROUP
  2. OLD-LEVELS
  3. SEQ-NUMBER
KeyChangeAC01.1

Relations

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

One to one (2) — lookups and parents

RelationTableRulesConditionField map
AccopyruleACCOPYRULENot Required
CYY-COPY-RULE→CYR-RULE-NAME
AclevruleACLEVRULENot Required
CYY-LEVEL-RULE→CLR-RULE-NAME

Programs

Updated by (2)

Referenced by (3)