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.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
CYY-RUN-GROUP PKRUN_GROUP | Alpha 15 | Run 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 PKSEQ_NUMBER | Numeric 6 | A unique number assigned to each transaction to be interfaced into the Lawson system. | AC01.1 |
CYY-CPY-ACT-GRPCPY_ACT_GRP | Alpha 15 | — | AC01.1 |
CYY-CPY-FR-ACTCPY_FR_ACT | Alpha 15 | — | AC01.1 |
CYY-CPY-TH-ACTCPY_TH_ACT | Alpha 15 | — | AC01.1 |
CYY-CPY-FR-VAR-LEVCPY_FR_VAR_LEV | Alpha 30 | — | AC01.1 |
CYY-CPY-TH-VAR-LEVCPY_TH_VAR_LEV | Alpha 30 | — | AC01.1 |
CYY-CPY-LISTCPY_LIST | Alpha 12 | — | AC01.1 |
CYY-TO-ACT-GRPTO_ACT_GRP | Alpha 15 | — | AC01.1 |
CYY-COPY-RULECOPY_RULE | Alpha 12 | — | AC01.1 |
CYY-LEVEL-RULELEVEL_RULE | Alpha 12 | — | AC01.1 |
CYY-OLD-ACT-GRPOLD_ACT_GRP | Alpha 35 | — | AC01.1 |
CYY-OLD-ACTIVITYOLD_ACTIVITY | Alpha 35 | — | AC01.1 |
CYY-OLD-LEVELSOLD_LEVELS | Alpha 30 | The level the Accounting Unit was changed from. | AC01.1 |
CYY-OLD-DEPTHOLD_DEPTH | Numeric 1 | — | AC01.1 |
CYY-OLD-POSTING-FLOLD_POSTING_FL | Alpha 1 | — | AC01.1 |
CYY-NEW-ACTIVITYNEW_ACTIVITY | Alpha 30 | — | AC01.1 |
CYY-NEW-LEVELSNEW_LEVELS | Alpha 30 | The level the Accounting Unit was changed to. | AC01.1 |
CYY-NEW-DEPTHNEW_DEPTH | Numeric 1 | — | AC01.1 |
CYY-NEW-DETAIL-1NEW_DETAIL_1 | Numeric 15 | — | AC01.1 |
CYY-NEW-DETAIL-2NEW_DETAIL_2 | Numeric 15 | — | AC01.1 |
CYY-NEW-DETAIL-3NEW_DETAIL_3 | Numeric 15 | — | AC01.1 |
CYY-NEW-DETAIL-4NEW_DETAIL_4 | Numeric 15 | — | AC01.1 |
CYY-NEW-DETAIL-5NEW_DETAIL_5 | Numeric 15 | — | AC01.1 |
CYY-DESCRIPTIONDESCRIPTION | Alpha 30 (Lower Case) | This field displays the description. | AC01.1 |
CYY-LONG-DESCLONG_DESC | Alpha 60 (Lower Case) | Occurs 4 Times Long description. | AC01.1 |
CYY-POSTING-FLAGPOSTING_FLAG | Alpha 1 | — | AC01.1 |
CYY-PARENT-ACTVYPARENT_ACTVY | Alpha 30 | — | AC01.1 |
CYY-PARENT-LEVELSPARENT_LEVELS | Alpha 30 | — | — |
CYY-PARENT-DEPTHPARENT_DEPTH | Numeric 1 | — | AC01.1 |
CYY-PARENT-DETAILPARENT_DETAIL | Numeric 15 Occurs 5 Times ×5 | — | — |
CYY-FREEZEFREEZE | Alpha 1 | — | AC01.1 |
CYY-JOB-NAMEJOB_NAME | Alpha 10 | — | — |
CYY-UNDER-ACTIVITYUNDER_ACTIVITY | Alpha 15 | — | — |
CYY-BEGIN-DATEBEGIN_DATE | Numeric 8 (yyyymmdd) | Begin Date for the new activity being added. | AC01.1 |
CYY-END-DATEEND_DATE | Numeric 8 (yyyymmdd) | End date for the new activity being added. | AC01.1 |
Indexes (7)
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 |
|---|---|---|---|---|
CYYSET1 | RUN-GROUP, SEQ-NUMBER | Primary | AC01.1, AC110 | |
CYYSET2 | RUN-GROUP, TO-ACT-GRP, OLD-ACTIVITY, NEW-ACTIVITY, SEQ-NUMBER | KeyChange | AC01.1 | |
CYYSET3 | NEW-ACTIVITY, RUN-GROUP, SEQ-NUMBER | KeyChange | AC01.1, AC10.1, AC11.1, AC500 | |
CYYSET4 | RUN-GROUP, PARENT-DEPTH, PARENT-ACTVY, SEQ-NUMBER | KeyChange | AC01.1 | |
CYYSET5 | RUN-GROUP, SEQ-NUMBER* | AC01.1 | ||
CYYSET6 | RUN-GROUP, NEW-LEVELS, SEQ-NUMBER | KeyChange | AC01.1, AC110 | |
CYYSET8 | RUN-GROUP, OLD-LEVELS, SEQ-NUMBER | KeyChange | AC01.1 |
Relations
One to one (2) — lookups and parents
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Accopyrule | ACCOPYRULE | Not Required | CYY-COPY-RULE → CYR-RULE-NAME | |
| Aclevrule | ACLEVRULE | Not Required | CYY-LEVEL-RULE → CLR-RULE-NAME |