Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ACCLGTRANS


                            ACCLGTRANS FILE

This file contains the exceeded amounts for billed transactions that are
applied to the ceilings in Activity Billing (BR00.1), Billing Detail
(BR00.2), Ceiling Levels (BR00.3) and Contract Detail (BR10.2).
The file includes the transaction obj id, activity, contract, ceiling level,
and the exceed amount and units.

REFERENCED BY

BR580     BR10.1    PW110     BR450

UPDATED BY

AC300     AC310     BR120     BR121     BR122     BR123
BR140     BR151     BR152     BR156     BR20.1    BR20.2
BR20.3    BR20.4    BR20.5    BR420     BR46.1    BR46.2
BR46.4    BR521

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

CGT-ATN-OBJ-ID         Numeric 12                                BR120   BR122
Element: Obj Id        The system-defined object id associated   BR140   BR20.1
                       with the Activity Management              BR20.2  BR20.3
                       transaction (ACTRANS).                    BR20.4  BR20.5
                                                                 BR46.1  BR46.2
                                                                 BR46.4  BR521

CGT-LEVEL              Numeric 1                                 BR120   BR122
Element: Level         The level at which the ceiling is         BR140   BR20.1
                       maintained.                               BR20.2  BR20.3
                       Posting or Summary Ceiling Levels         BR20.4  BR20.5
                       1 =  ACBILLX (BR00.2)                     BR46.1  BR46.2
                       2 =  ACCEILING (BR00.3)                   BR46.4  BR521
                       3 =  ACBILL (BR00.1)
                       4 =  Not used
                       Contract Ceiling Levels
                       5 = ACBILLX (BR00.2)
                       6 = ACCEILING (BR00.3)
                       7 = ACBILL (BR00.1)
                       8 = Not used
                       9 - Contract (BR10.2)_

CGT-ACTIVITY           Alpha 15                                  BR120   BR122
Element: Activity      The activity associated with the          BR140   BR20.1
                       activity transaction.                     BR20.2  BR20.3
                                                                 BR20.4  BR20.5
                                                                 BR46.1  BR46.2
                                                                 BR46.4  BR521

CGT-CONTRACT           Alpha 15                                  BR120   BR122
Element: Contract      The contract associated with the          BR140   BR20.1
                       activity.                                 BR20.2  BR20.3
                                                                 BR20.4  BR20.5
                                                                 BR46.1  BR46.2
                                                                 BR46.4  BR521

CGT-EXCEED-AMT         Signed 18.2                               BR120   BR122
Element: Intl Amt      The amount That is over the billing       BR140   BR20.1
                       activity ceiling maintained in Billing    BR20.2  BR20.3
                       (BR00.1) or Billing Detail (BR00.2) or    BR20.4  BR20.5
                       Ceiling Levels (BR00.3).                  BR46.1  BR46.2
                                                                 BR46.4  BR521

CGT-EXCEED-UNIT        Signed 15.2                               BR120   BR122
Element: Exceed Unit   The unit amount that is related to the    BR140   BR20.1
                       exceed amount that is over the ceiling.   BR20.2  BR20.3
                                                                 BR20.4  BR20.5
                                                                 BR46.1  BR46.2
                                                                 BR46.4  BR521

                         ACCLGTRANS FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

CGTSET1   ATN-OBJ-ID                                             AC300   AC310
          LEVEL                                                  BR120   BR122
                                                                 BR140   BR20.1
                                                                 BR20.2  BR20.3
                                                                 BR20.4  BR20.5
                                                                 BR46.1  BR46.2
                                                                 BR46.4  BR521
                                                                 BR580

CGTSET2   CONTRACT      KeyChange                                BR10.1  BR120
          ATN-OBJ-ID                                             BR121   BR122
          LEVEL                                                  BR123   BR140
                                                                 BR151   BR152
                                                                 BR156   BR20.1
                                                                 BR20.2  BR20.3
                                                                 BR20.4  BR20.5
                                                                 BR420   BR521
                                                                 PW110

CGTSET3   ACTIVITY      KeyChange                                AC310   BR450
          ATN-OBJ-ID
          LEVEL