Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ACACTCOPY


                             ACACTCOPY FILE

REFERENCED BY

AC10.1    AC11.1    AC500

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
Record Sequence        A unique number assigned to each
Number                 transaction to be transferred 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 Activity Group

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

CYY-OLD-LEVELS         Alpha 30                                  AC01.1
Element: New Levels

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)
Element: Long DescriptiOccurs 4 Times

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

                         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

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

CYYSET5   RUN-GROUP     KeyChange                                AC01.1
          SEQ-NUMBER*

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

CYYSET7   RUN-GROUP     KeyChange
          NEW-DETAIL-1*
          NEW-DETAIL-2*
          NEW-DETAIL-3*
          NEW-DETAIL-4*
          NEW-DETAIL-5*
          SEQ-NUMBER

CYYSET8   RUN-GROUP                                              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