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    AC58.3    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
Element: Seq Number    A unique number assigned to each
                       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: Bud Flag      Budget edit flag for summary account
                       categories.
                       D = Detail
                       N = No Edit
                       S = Summary

CIF-MATRIX-CAT         Alpha 12 Occurs 11 Times                  AC58.3
Element: Matrix Cat    Attribute name assigned to an object
                       (like accounting unit) to track
                       additional information.  Attribute
                       values may then be used in selection and
                       sorting for report and analysis.

CIF-MX-VALUE           Alpha 32 Occurs 11 Times                  AC58.3
Element: Mx Value      The attribute value.

                         ACIFCAT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

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

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