Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ACBLRATE


                             ACBLRATE FILE

                     Activity Billing Rates Header

This file contains billing rate information from the Billing Category Rates
(BR03.1) or the Units of Production Rates (BR03.2). Rates are stored by
attributes or units of prodction.  The file maintains the rate schedule name
and description, the billing rate attribute, unit type, and currency code for
an activity. You can print a billing rate listing by running BR203 (Billing
Rate Listing).

REFERENCED BY

AC190     AC40.1    AC40.4    AC41.1    AC41.4    AC42.1
AC54.1    AC540     ACAC.1    BR190     BR20.6    BR203
BR40.3    BR46.1    BR46.2    BR46.4    ET540

UPDATED BY

AC300     AC310     BR03.1    BR03.2    BR03.3    BR00.1
BR00.2

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

ALR-ACTIVITY           Alpha 15                                  BR03.1  BR03.2
Element: Activity      The activity established in Billing       BR03.3
                       Category Rates (BR03.1) or Units of
                       Production Rates (BR03.2).

ALR-ACCT-CATEGORY      Alpha 5                                   BR03.1  BR03.2
Element: Acct Category The account category associated with      BR03.3
                       the activity and maintained in Billing
                       Category  Rates (BR03.1) or the Units of
                       Production Rates(BR03.2) .  A blank
                       value in the account category  or
                       summary account category indicates that
                       the rates are valid for all account
                       categories associated with the activity.

ALR-SOURCE-CODE        Alpha 2                                   BR03.1  BR03.2
Element: Source Code   The Source Code is established in the     BR03.3
                       Source Code (GL05) and maintained in
                       Billing Category Rates (BR03.1) or
                       Units of Production Rates (BR03.2). A
                       blank value in this field indicates that
                       the rates are valid for all source
                       codes related to Activity Management.

ALR-MATRIX-CAT         Alpha 12                                  BR03.1  BR03.2
Element: Attribute     A billing rate attribute must be defined  BR03.3
                       as part of the key for Activity
                       Management billing transactions.  The
                       attribute is established in MX00.1.  The
                       attribute must have an object type of
                       ACTRN established.

                       The attribute must be assigned to the
                       object type ACTRANS in GL05.1 (Source
                       Code).

ALR-EFFECTIVE-DT       Numeric 8  (yyyymmdd)                     BR03.1  BR03.2
Element: Effective Dt  The effective date is the date the        BR03.3
                       record is first valid. The date is
                       maintained on the Billing Category Rates
                       (BR03.1) or Units of Production
                       (BR03.2).

ALR-UNIT-TYPE          Alpha 1                                   BR03.1  BR03.2
Element: Unit Type     This field indicates whether the rate     BR03.3
                       schedule is for hours (time and
                       materials) or units (units of
                       production). If the rates are set up in
                       Billing Category Rates (BR00.1), the
                       value = H(ours).  If the rates are set
                       up in Units of Production Rates (BR03.2)
                       the value = U(nits).
                       U = Units
                       H = Hours

ALR-CURRENCY-CODE      Alpha 5                                   BR03.1  BR03.2
Element: Currency Code This code represents the currency         BR03.3
                       defined for the activity which is
                       established in Activity (AC10.1).

ALR-SUM-ACCT-CAT       Alpha 5                                   BR03.1  BR03.2
Element: Sum Acct Cat  The summary account category associated   BR03.3
                       with the activity and maintained in
                       Billing  Category  Rates (BR03.1) or
                       Units of  Production  (BR03.2). A blank
                       value in  the  summary  account category
                       or the  account category indicates that
                       the  rates are valid for  all account
                       categories associated with  the
                       activity.

ALR-CTR-CAT-GRP        Alpha 5                                   BR03.1  BR03.2
Element: Ctr Cat Grp                                             BR03.3

                         ACBLRATE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ALRSET1   ACTIVITY                                               AC190   AC300
          SUM-ACCT-CAT                                           AC310   AC40.1
          CTR-CAT-GRP                                            AC40.4  AC41.1
          ACCT-CATEGORY                                          AC41.4  AC42.1
          SOURCE-CODE                                            AC54.1  AC540
          MATRIX-CAT                                             ACAC.1  BR00.1
          EFFECTIVE-DT*                                          BR00.2  BR03.1
                                                                 BR03.2  BR03.3
                                                                 BR190   BR20.6
                                                                 BR203   BR40.3
                                                                 BR46.1  BR46.2
                                                                 BR46.4  ET540

                         ACBLRATE FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Acbill         ACBILL       Required

                            ALR-ACTIVITY         -> ACI-ACTIVITY

Mxcatdef       MXCATDEF     Required

                            ALR-MATRIX-CAT       -> MXC-MATRIX-CAT

                         ACBLRATE FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Acblratex      ACBLRATEX

                            ALR-ACTIVITY         -> ALX-ACTIVITY
                            ALR-SUM-ACCT-CAT     -> ALX-SUM-ACCT-CAT
                            ALR-CTR-CAT-GRP      -> ALX-CTR-CAT-GRP
                            ALR-ACCT-CATEGORY    -> ALX-ACCT-CATEGORY
                            ALR-SOURCE-CODE      -> ALX-SOURCE-CODE
                            ALR-MATRIX-CAT       -> ALX-MATRIX-CAT
                            ALR-EFFECTIVE-DT     -> ALX-EFFECTIVE-DT
                                                    ALX-MX-VALUE