Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ACCEILINGX


                            ACCEILINGX FILE

This file contains the detailed ceiling information for a activity, account
category and attribute maintained in Ceiling Levels (BR00.3).  This file
includes the attribute value, ceiling amount, ceiling unit, tolerance amount
and tolerance unit. The file also stores the cumulative total billed amounts
and units, the total revenue amounts and units and the total applied tolerance
amounts and units for each attribute value ceiling record.

UPDATED BY

AC10.1    AC120     AC300     AC310     BR00.3    BR120
BR122     BR130     BR131     BR140     BR20.1    BR20.2
BR20.3    BR20.4    BR20.5    BR46.1    BR46.2    BR46.4
BR521     BR530     BR580

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

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

CEX-ACCT-CATEGORY      Alpha 5                                   BR00.3
Element: Account CategoThe account category associated with the
                       activity maintained on Ceiling Levels
                       (BR00.3).  The account category or the
                       summary account category are required.

CEX-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.

CEX-MATRIX-CAT         Alpha 12                                  BR00.3
Element: Attribute     The billing category (attribute)
                       associated with the activity ceiling
                       records maintained in  Ceiling Levels
                       (BR00.3).

CEX-MX-VALUE           Alpha 32                                  BR00.3
Element: Attribute ValuThe attribute value associated  with the
                       billing category (attribute).  The value
                       is maintained on the Ceiling Levels
                       (BR00.3).

CEX-CEILING-AMT        Signed 18.2                               BR00.3
Element: Intl Amt      The ceiling amount is the maximum amount
                       that can be billed against the attribute
                       value associated with the ceiling record
                       maintained on Ceiling Levels (BR00.3).

CEX-CEILING-UNIT       Signed 15.2                               BR00.3
Element: Ceiling Unit  The ceiling unit is the maximum unit
                       amount that can be billed against the
                       attribute value associated with the
                       ceiling record maintained on Ceiling
                       Levels (BR00.3).

CEX-TOT-BILLED-AMT     Signed 18.2                               AC300   BR122
Element: Intl Amt      The total billed amount for the           BR140   BR20.1
                       attribute value associated with the       BR20.2  BR20.3
                       ceiling record on Ceiling Levels          BR20.4  BR20.5
                       (BR00.3).                                 BR46.1  BR46.2
                                                                 BR46.4  BR580

CEX-TOT-BILLED-UNT     Signed 18.2                               AC300   BR122
Element: Intl Amt      The total billed unit amount for the      BR140   BR20.1
                       attribute value associated with the       BR20.2  BR20.3
                       ceiling record on Ceiling Levels          BR20.4  BR20.5
                       (BR00.3).                                 BR46.1  BR46.2
                                                                 BR46.4  BR580

CEX-TOT-REV-AMT        Signed 18.2                               AC300   BR580
Element: Intl Amt      The total revenue amount for the
                       attribute value associated with ceiling
                       record on Ceiling Levels (BR00.3).

CEX-TOT-REV-UNIT       Signed 15.2                               AC300   BR580
Element: Tot Rev Unit  The total revenue unit for the attribute
                       value associated with the ceiling
                       record on Ceiling Levels  (BR00.3).

CEX-TOLERANCE-AMT      Signed 18.2                               BR00.3
Element: Intl Amt      The tolerance amount is the maximum
                       amount above the Ceiling amount that can
                       be billed against the attribute value
                       associated with the ceiling record
                       maintained in Ceiling Levels (BR00.3).

CEX-TOLERANCE-UNIT     Signed 15.2                               BR00.3
Element: Tolerance UnitThe tolerance unit is the maximum unit
                       amount above the ceiling unit amount
                       that can be  billed against the
                       attribute value associated with the
                       ceiling record maintained in Ceiling
                       Levels (BR00.3).

CEX-APPLY-TOL-AMT      Signed 18.2                               AC300   BR130
Element: Intl Amt      The apply tolerance amount is the         BR131   BR530
                       cumulative amount that has been billed    BR580
                       against the  tolerance amount for the
                       attribute value associated with the
                       ceiling record on Ceiling Levels
                       (BR00.3).

CEX-APPLY-TOL-UNIT     Signed 15.2                               AC300   BR580
Element: Apply Tol UnitThe apply tolerance unit is the
                       cumulative unit amount that has been
                       billed against the tolerance unit amount
                       for the attribute value associated with
                       the ceiling on Ceiling Levels (BR00.3).

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

                         ACCEILINGX FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

CEXSET1   ACTIVITY                                               AC10.1  AC120
          ACCT-CATEGORY                                          AC300   AC310
          SUM-ACCT-CAT                                           BR00.3  BR120
          CTR-CAT-GRP                                            BR122   BR130
          MATRIX-CAT                                             BR131   BR140
          MX-VALUE                                               BR20.1  BR20.2
                                                                 BR20.3  BR20.4
                                                                 BR20.5  BR46.1
                                                                 BR46.2  BR46.4
                                                                 BR521   BR530
                                                                 BR580

                         ACCEILINGX FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Acacctcat      ACACCTCAT    Required

                            CEX-ACCT-CATEGORY    -> AAX-ACCT-CATEGORY

Acactivity     ACACTIVITY   Required

                            CEX-ACTIVITY         -> ACV-ACTIVITY

Mxcatdef       MXCATDEF     Required

                            CEX-MATRIX-CAT       -> MXC-MATRIX-CAT