Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ACIFCAT


                              ACIFCAT FILE

UPDATED BY

AC58.1    AC558

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

CIF-STRUCTURE          Alpha 15                                  AC58.1
Element: Structure     The name of the category structure.

CIF-SUM-ACCT-CAT       Alpha 5                                   AC58.1
Element: Sum Acct Cat  The name of the summary account
                       category.

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

CIF-DEPTH              Numeric 2                                 AC58.1
Element: Depth         The level depth of the summary account
                       category.

CIF-SEQ-NUMBER         Numeric 6                                 AC58.1
Record Sequence        A unique number assigned to each
Number                 transaction to be interfaced into the
                       Lawson system.

CIF-PARENT-SUM-CAT     Alpha 5                                   AC58.1
Element: Parent Sum CatIdentifies the parent summary account
                       category of summary account categories
                       at a depth > 1.  If a summary category
                       is located at level 1, there will be no
                       parent.

CIF-CATEGORY-TYPE      Alpha 1                                   AC58.1
Element: Category Type This Field is used to set up the
                       default category type for the
                       Distribution File.
                       (EEDISTRIB)
                       R = Revenue
                       C = Cost
                       P = Pass Thru
                       A = Accrual

CIF-BUD-FLAG           Alpha 1                                   AC58.1
Element: Budget        Budget edit flag for summary account
                       categories.
                       D = Detail
                       N = No Edit
                       S = Summary

                         ACIFCAT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

CIFSET1   STRUCTURE                                              AC558   AC58.1
          SUM-ACCT-CAT                                           AC58.2

CIFSET2   STRUCTURE     KeyChange                                AC558   AC58.1
          CATEGORY-TYPE
          SEQ-NUMBER
          SUM-ACCT-CAT

                         ACIFCAT FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Acifcatx       ACIFCATX

                            CIF-STRUCTURE       -> CIX-STRUCTURE
                            CIF-SUM-ACCT-CAT    -> CIX-SUM-ACCT-CAT
                                                   CIX-ACCT-CATEGORY

Acifcatxall    ACIFCATX

                            CIF-STRUCTURE       -> CIX-STRUCTURE
                                                   CIX-ACCT-CATEGORY