Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             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
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
Cpy Act Grp

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

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

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

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

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

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

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

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

CYY-OLD-ACT-GRP      Alpha 35                                    AC01.1
Old Activity Group

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

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


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

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

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

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


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

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

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

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

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

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

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

CYY-LONG-DESC        Alpha 60  (Lower Case)
Long Description     Occurs 4 Times

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

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

CYY-PARENT-LEVELS    Alpha 30
Parent Levels

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

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

CYY-FREEZE           Alpha 1                                     AC01.1
Freeze

CYY-JOB-NAME         Alpha 10
Job Name

CYY-UNDER-ACTIVITY   Alpha 15
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