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.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: Account CategoAccount 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: 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 IndicY = 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: Markup percentThis 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.

                         ACIFCATX FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

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

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