Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ACACTCOPY


                             ACACTCOPY FILE

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.

REFERENCED BY

AC10.1    AC11.1    AC500     PW110     PW510

UPDATED BY

AC01.1    AC110

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

CYY-RUN-GROUP          Alpha 15                                  AC01.1
Element: Run Group     Run Group and Seq Number are the keys
                       to the file.  They should be used to
                       group records together for interfacing.

CYY-SEQ-NUMBER         Numeric 6                                 AC01.1
Element: Seq Number    A unique number assigned to each
                       transaction to be interfaced into the
                       Lawson system.

CYY-CPY-ACT-GRP        Alpha 15                                  AC01.1
Element: Cpy Act Grp

CYY-CPY-FR-ACT         Alpha 15                                  AC01.1
Element: Cpy Fr Act

CYY-CPY-TH-ACT         Alpha 15                                  AC01.1
Element: Cpy Th Act

CYY-CPY-FR-VAR-LEV     Alpha 30                                  AC01.1
Element: Cpy Fr Var Lev

CYY-CPY-TH-VAR-LEV     Alpha 30                                  AC01.1
Element: Cpy Th Var Lev

CYY-CPY-LIST           Alpha 12                                  AC01.1
Element: Cpy List

CYY-TO-ACT-GRP         Alpha 15                                  AC01.1
Element: To Act Grp

CYY-COPY-RULE          Alpha 12                                  AC01.1
Element: Copy Rule

CYY-LEVEL-RULE         Alpha 12                                  AC01.1
Element: Level Rule

CYY-OLD-ACT-GRP        Alpha 35                                  AC01.1
Element: Old Act Grp

CYY-OLD-ACTIVITY       Alpha 35                                  AC01.1
Element: Old Activity

CYY-OLD-LEVELS         Alpha 30                                  AC01.1
Element: Old Levels    The level the Accounting Unit was
                       changed from.


CYY-OLD-DEPTH          Numeric 1                                 AC01.1
Element: Old Depth

CYY-OLD-POSTING-FL     Alpha 1                                   AC01.1
Element: Old Posting Fl

CYY-NEW-ACTIVITY       Alpha 30                                  AC01.1
Element: New Activity

CYY-NEW-LEVELS         Alpha 30                                  AC01.1
Element: New Levels    The level the Accounting Unit was
                       changed to.


CYY-NEW-DEPTH          Numeric 1                                 AC01.1
Element: New Depth

CYY-NEW-DETAIL-1       Numeric 15                                AC01.1
Element: New Detail 1

CYY-NEW-DETAIL-2       Numeric 15                                AC01.1
Element: New Detail 2

CYY-NEW-DETAIL-3       Numeric 15                                AC01.1
Element: New Detail 3

CYY-NEW-DETAIL-4       Numeric 15                                AC01.1
Element: New Detail 4

CYY-NEW-DETAIL-5       Numeric 15                                AC01.1
Element: New Detail 5

CYY-DESCRIPTION        Alpha 30  (Lower Case)                    AC01.1
Element: Description   This field displays the description.

CYY-LONG-DESC          Alpha 60  (Lower Case)                    AC01.1
Element: Long Desc     Occurs 4 Times
                       Long description.

CYY-POSTING-FLAG       Alpha 1                                   AC01.1
Element: Posting Flag

CYY-PARENT-ACTVY       Alpha 30                                  AC01.1
Element: Parent Actvy

CYY-PARENT-LEVELS      Alpha 30
Element: Parent Levels

CYY-PARENT-DEPTH       Numeric 1                                 AC01.1
Element: Parent Depth

CYY-PARENT-DETAIL      Numeric 15 Occurs 5 Times
Element: Parent Detail

CYY-FREEZE             Alpha 1                                   AC01.1
Element: Freeze

CYY-JOB-NAME           Alpha 10
Element: Job Name

CYY-UNDER-ACTIVITY     Alpha 15
Element: Under Activity

CYY-BEGIN-DATE         Numeric 8  (yyyymmdd)                     AC01.1
Element: Begin Date    Begin Date for the new activity being
                       added.

CYY-END-DATE           Numeric 8  (yyyymmdd)                     AC01.1
Element: End Date      End date for the new activity being
                       added.

                         ACACTCOPY FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

CYYSET1   RUN-GROUP                                              AC01.1  AC110
          SEQ-NUMBER

CYYSET2   RUN-GROUP     KeyChange                                AC01.1
          TO-ACT-GRP
          OLD-ACTIVITY
          NEW-ACTIVITY
          SEQ-NUMBER

CYYSET3   NEW-ACTIVITY  KeyChange                                AC01.1  AC10.1
          RUN-GROUP                                              AC11.1  AC500
          SEQ-NUMBER                                             PW110   PW510

CYYSET4   RUN-GROUP     KeyChange                                AC01.1
          PARENT-DEPTH
          PARENT-ACTVY
          SEQ-NUMBER

CYYSET5   RUN-GROUP                                              AC01.1
          SEQ-NUMBER*

CYYSET6   RUN-GROUP     KeyChange                                AC01.1  AC110
          NEW-LEVELS
          SEQ-NUMBER

CYYSET8   RUN-GROUP     KeyChange                                AC01.1
          OLD-LEVELS
          SEQ-NUMBER

                         ACACTCOPY FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Accopyrule     ACCOPYRULE   Not Required

                            CYY-COPY-RULE     -> CYR-RULE-NAME

Aclevrule      ACLEVRULE    Not Required

                            CYY-LEVEL-RULE    -> CLR-RULE-NAME