Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ACIFCATX


                             ACIFCATX FILE

UPDATED BY

AC58.2    AC58.4    AC58.1    AC558

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

CIX-STRUCTURE          Alpha 15                                  AC58.2
Element: Structure     The name of the category structure.

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

CIX-ACCT-CATEGORY      Alpha 5                                   AC58.2
Element: Acct Category Account categories are groupings of
                       costs, revenues, or a combination of
                       both used for reporting and inquiries
                       for activities in the Activity
                       Management system. All transactions are
                       posted to an account category within an
                       activity. You can assign a specific
                       General Ledger account or range of
                       accounts (company, accounting unit,
                       account, and subaccount) that make up
                       the transactions posted to an account
                       category using AC07.1 (Account
                       Assignment).

                       Period-to-date, year-to-date, and
                       life-to-date balances are maintained by
                       account category for activities. Account
                       categories must be assigned to
                       activities before you do any budgeting
                       or transaction processing.

                       Valid account category types are:
                       cost
                       revenue
                       accrual
                       pass thru

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

CIX-CATEGORY-TYPE      Alpha 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

CIX-ACTIVE-STATUS      Alpha 1                                   AC58.2
Element: Active Status The status of the account. If Inactive,
                       no posting can be done to the account.
                       A = Active
                       I = Inactive

CIX-BILLABLE-FLAG      Alpha 1                                   AC58.2
Element: Billable      Y = Yes
                       N = No

CIX-CAPITAL-FLAG       Alpha 1                                   AC58.2
Element: Capital Flag  This field indicates whether an
                       activity/account category is to be
                       capitalized.
                       Y = Yes
                       N = No

CIX-REVENUE-FLAG       Alpha 1                                   AC58.2
Element: Revenue Flag  This flag identifies whether an
                       activity/account category is eligible
                       for revenue recognition.
                       Y = Yes
                       N = No

CIX-TM-FLAG            Alpha 1                                   AC58.2
Element: Tm Flag       This flag indicates whether this
                       account category represents time (labor)
                       or materials for T&M processing.
                       M = Materials
                       T = Time

CIX-MARK-UP-PCT        Signed 5.2                                AC58.2
Element: Mark Up Pct   This field indicates the percentage of
                       markup for billing.  If an account
                       category is billable, a markup
                       percentage can be established.  A rate
                       scheudled is for labor transactions
                       only.  Markup percentages will increase
                       teh cost amount by the percentage
                       entered.

CIX-MATRIX-CAT         Alpha 12 Occurs 11 Times                  AC58.4
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.

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

                         ACIFCATX FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

CIXSET1   STRUCTURE                                              AC558   AC58.1
          ACCT-CATEGORY                                          AC58.2  AC58.4

CIXSET2   STRUCTURE     KeyChange                                AC558   AC58.1
          SUM-ACCT-CAT                                           AC58.2
          ACCT-CATEGORY

                         ACIFCATX FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Acacctcat      ACACCTCAT    Required

                            CIX-ACCT-CATEGORY    -> AAX-ACCT-CATEGORY

                         ACIFCATX FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Acifcat        ACIFCAT

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