Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ACBLRATEX


                             ACBLRATEX FILE

                     Activity Billing Rates Detail

This file contains detailed billing rate information from the BR03 forms. It
includes rate schedule, attribute and attribute value, effective date, and
billing rate.  You can run a listing of billing rates by runnning 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

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


ALX-ACCT-CATEGORY      Alpha 5                                   BR03.1  BR03.2
Element: Acct Category The account category associated with the  BR03.3
                       activity 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.
                       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.

ALX-SOURCE-CODE        Alpha 2                                   BR03.1  BR03.2
Element: Source Code   The Source Code is established in Source  BR03.3
                       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.

ALX-MATRIX-CAT         Alpha 12                                  BR03.1  BR03.2
Element: Attribute     A billing rate attribute can 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.

ALX-DESCRIPTION        Alpha 30  (Lower Case)                    BR03.1  BR03.3
Element: Description   The billing category description which
                       is associated with the category
                       selected.

ALX-MX-VALUE           Alpha 32                                  BR03.1  BR03.2
Element: Attribute ValuKey field. This field is required if an   BR03.3
                       attribute is defined.

                       The value for this field is UOM if the
                       Unit Type field in the Activity Billing
                       Rate Header file is Units of Production.


ALX-EFFECTIVE-DT       Numeric 8  (yyyymmdd)                     BR03.1  BR03.2
Element: Effective DateThe 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 (B03.2).

ALX-BILL-RATE          Signed 13.4                               BR03.1  BR03.2
Element: Billing Rate  The hourly rate at which to bill this     BR03.3
                       value for the attribute.

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

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

                         ACBLRATEX FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ALXSET1   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  BR00.3
          MX-VALUE                                               BR03.1  BR03.2
                                                                 BR03.3  BR190
                                                                 BR20.6  BR203
                                                                 BR40.3  BR46.1
                                                                 BR46.2  BR46.4
                                                                 ET540

ALXSET2   ACTIVITY                                               AC190   AC40.1
          SUM-ACCT-CAT                                           AC40.4  AC41.1
          CTR-CAT-GRP                                            AC41.4  AC42.1
          ACCT-CATEGORY                                          AC54.1  AC540
          SOURCE-CODE                                            ACAC.1  BR190
          MATRIX-CAT                                             BR20.6  BR40.3
          MX-VALUE                                               BR46.1  BR46.2
          EFFECTIVE-DT*                                          BR46.4  ET540

ALXSET3   MATRIX-CAT
          ACTIVITY
          SUM-ACCT-CAT
          CTR-CAT-GRP
          ACCT-CATEGORY
          SOURCE-CODE
          EFFECTIVE-DT*
          MX-VALUE

                         ACBLRATEX FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Acactgrp       ACACTGRP     Required

                            ACV-ACTIVITY-GRP     -> AGP-ACTIVITY-GRP  (AGPSET1)

Acactivity     ACACTIVITY   Required

                            ALX-ACTIVITY         -> ACV-ACTIVITY

Acbill         ACBILL       Required

                            ALX-ACTIVITY         -> ACI-ACTIVITY

Acblrate       ACBLRATE     Required

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

Mxcatdef       MXCATDEF     Required

                            ALX-MATRIX-CAT       -> MXC-MATRIX-CAT

                         ACBLRATEX FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Glsccat Ad     GLSCCAT

                            ALX-MATRIX-CAT       -> GSC-MATRIX-CAT
                            "AD"                 -> GSC-SOURCE-CODE
                                                    GSC-SEQ-NBR