Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ACCEILING


                             ACCEILING FILE

This file contains ceilings or billing maximums established and maintained via
BR00.3 (Ceiling Levels).  Ceilings can be established at the contract,
activity, account category, summary account category and billing category
level.  Billing ceilings will be read up the activity level structure when
running Billing and Revenue to determine amounts to bill, recognize revenue
and apply to tolerances.

REFERENCED BY

BR03.1

UPDATED BY

AC10.1    AC120     AC300     AC310     BR00.3

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

CEH-ACTIVITY           Alpha 15                                  BR00.3
Element: Activity      The activity associated with the ceiling
                       and tolerance amounts maintained on
                       Ceiling Levels (BR00.3).

CEH-ACCT-CATEGORY      Alpha 5                                   BR00.3
Element: Acct Category The account category associated with the
                       activity maintained in Ceiling Levels
                       (BR00.3). The account category or the
                       summary account category are required.

CEH-SUM-ACCT-CAT       Alpha 5                                   BR00.3
Element: Sum Acct Cat  The summary account category associated
                       with the activity maintained in Ceiling
                       Levels (BR00.3). The account category or
                       the summary account category are
                       required.

CEH-MATRIX-CAT         Alpha 12                                  BR00.3
Element: Matrix Cat    The billing category (attribute)
                       associated with the ceiling record
                       maintained in Ceiling Levels (BR00.3).

CEH-CTR-CAT-GRP        Alpha 5                                   BR00.3
Element: Ctr Cat Grp

                         ACCEILING FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

CEHSET1   ACTIVITY                                               AC10.1  AC120
          ACCT-CATEGORY                                          AC300   AC310
          SUM-ACCT-CAT                                           BR00.3  BR03.1
          CTR-CAT-GRP
          MATRIX-CAT

                         ACCEILING FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Acacctcat      ACACCTCAT    Required

                            CEH-ACCT-CATEGORY    -> AAX-ACCT-CATEGORY

Acactivity     ACACTIVITY   Required

                            CEH-ACTIVITY         -> ACV-ACTIVITY

Mxcatdef       MXCATDEF     Required

                            CEH-MATRIX-CAT       -> MXC-MATRIX-CAT