Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

                             ACACTCOPY FILE

REFERENCED BY

AC10.1    AC11.1    AC500

UPDATED BY

AC110     AC79.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

CYY-RUN-GROUP        Alpha 12                                    AC79.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                                   AC79.1
Record Sequence      A unique number assigned to each
Number               transaction to be transferred into the
                     Lawson system.

CYY-CPY-ACT-GRP      Alpha 15                                    AC79.1
Cpy Act Grp

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

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

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

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

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

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

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

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

CYY-OLD-ACT-GRP      Alpha 35                                    AC79.1
Old Account Group

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

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


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

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

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

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


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

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

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

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

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

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

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

CYY-LONG-DESC        Alpha 60 Occurs 4 Times
Long Description

CYY-POSTING-FLAG     Alpha 1                                     AC79.1
Posting Flag         P = Posting
                     S = Summary

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

CYY-PARENT-LEVELS    Alpha 30                                    AC79.1
Parent Levels

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

CYY-PARENT-DETAIL    Numeric 15 Occurs 5 Times                   AC79.1
Parent Detail

CYY-FREEZE           Alpha 1                                     AC79.1
Freeze               Y = Yes
                     N = No

CYY-JOB-NAME         Alpha 10
Job Name

                         ACACTCOPY FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

CYYSET1   RUN-GROUP                                              AC110   AC79.1
          SEQ-NUMBER

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

CYYSET3   NEW-ACTIVITY  KeyChange                                AC10.1  AC11.1
          RUN-GROUP                                              AC500   AC79.1
          SEQ-NUMBER

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

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

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

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

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