Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ACBLMAST


                             ACBLMAST FILE

                        Activity Billing Master

The  Activity Billing Master file contains the life to date billing  balances
for the  billing activities within an activity group.  The Billing LTD
Balances flag  must = Yes on the Activity Group to create the records.

This file is updated by BR20, BR120, BR121, BR21 and BRIP.

REFERENCED BY

AC10.1    AC50.1    AC500     BR02.3    BR120     BR121
BR122     BR123     BR151     BR152     BR156     BR20.1
BR20.2    BR20.3    BR20.4    BR20.5    BR420     BR521
PW110     PW510

UPDATED BY

AC300     AC310     BR140     BRIP.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

BMH-BILL-ACTIVITY      Alpha 15                                  BRIP.1
Element: Bill Activity The activity associated with the billed
                       activity transactions.

BMH-ACTIVITY-GRP       Alpha 15                                  BRIP.1
Element: Activity Grp  The activity group associated with the
                       bill activity.

BMH-ACTIVITY           Alpha 15                                  BRIP.1
Element: Activity      The posting activity associated with the
                       billed transactions


BMH-ACCT-CATEGORY      Alpha 5                                   BRIP.1
Element: Acct Category The life-to-date billed balances are
                       maintained by account category for the
                       posting activity.

BMH-MATRIX-CAT         Alpha 12                                  BRIP.1
Element: Matrix Cat    The attribute name assigned to the
                       activity transactions for this balance
                       record.

BMH-MX-VALUE           Alpha 32                                  BRIP.1
Element: Mx Value      The value assigned to the attribute.

BMH-AMOUNT             Signed 18.2                               BRIP.1
Element: Intl Amt      This is the life to date billed balance
                       for the specified record.

BMH-UNIT               Signed 15.2                               BRIP.1
Element: Unit          This is the life to date billed unit
                       balance for the specified record.

BMH-LINE-TYPE          Alpha 1                                   BRIP.1
Element: Line Type     The life to date balance is stored by
                       type.
                       The values are:
                       A= Transaction
                       B= Milestone
                       C= Tax
                       F= Fee
                       G= Retention on Fee
                       H= Overage on Fee
                       I= Billed Retention on Fee
                       J= Billed Overage on Fee
                       K= Overage
                       L= Billed Overage
                       M= Retention
                       N= Billed Retention
                       O= Retainer
                       P= Billed Retainer
                       A = Transaction
                       B = Milestone
                       C = Tax
                       F = Fee
                       G = Retention on Fee
                       H = Overage on Fee
                       I = Billed Retention on Fee
                       J = Billed Overage on Fee
                       K = Overage
                       L = Billed Overage
                       M = Retention
                       N = Billed Retention
                       O = Retainer
                       P = Billed Retainer

BMH-RESOURCE-TYPE      Alpha 1                                   BRIP.1
Element: Resource Type The life to date balance record is
                       stored by the type of  resource. Valid
                       values include:
                       P - AC Person
                       Q - Equipment
                       E - Employee
                       V - Vendor

BMH-RESOURCE-COMP      Numeric 4                                 BRIP.1
Element: Company       Identifies the AP company if the
                       resource type = V.  Identifies the HR
                       company if the resource type = E.  It is
                       blank for type A, P or Q resources.

BMH-RESOURCE-CODE      Alpha 10                                  BRIP.1
Element: Resource Code The code identifying the resource
                       assigned to the activity or activity
                       group associated with the balance
                       record.
                       The code is maintained on Resource
                       (AC03).

BMH-CONTRACT           Alpha 15                                  BRIP.1
Element: Contract      The contract associated with the posting
                       activity maintained in Contract
                       Parameters (BR10).

BMH-BILL-WBS-CODE      Alpha 3                                   BRIP.1
Element: Bill Wbs Code The invoice group that is maintained on
                       the activity (AC10).

BMH-RESOURCE-DESC      Alpha 30  (Lower Case)                    BRIP.1
Element: Description   The description of the resource code
                       maintained on Resource (AC03).

BMH-FEE-TAX-CODE       Alpha 10                                  BRIP.1
Element: Fee Tax Code  This field has a double use.  It will
                       either be a tax code or a fee code.

                         ACBLMAST FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

BMHSET1   BILL-ACTIVITY                                          AC300   AC310
          BILL-WBS-CODE                                          BRIP.1
          ACTIVITY-GRP
          ACTIVITY
          ACCT-CATEGORY
          MATRIX-CAT
          RESOURCE-TYPE
          RESOURCE-COMP
          RESOURCE-CODE
          MX-VALUE
          FEE-TAX-CODE
          LINE-TYPE

BMHSET2   CONTRACT      KeyChange                                AC10.1  AC50.1
          BILL-WBS-CODE                                          AC500   BR02.3
          BILL-ACTIVITY                                          BR120   BR121
          ACTIVITY-GRP                                           BR122   BR123
          ACTIVITY                                               BR140   BR151
          ACCT-CATEGORY                                          BR152   BR156
          MATRIX-CAT                                             BR20.1  BR20.2
          RESOURCE-TYPE                                          BR20.3  BR20.4
          RESOURCE-COMP                                          BR20.5  BR420
          RESOURCE-CODE                                          BR521   PW110
          MX-VALUE                                               PW510
          FEE-TAX-CODE
          LINE-TYPE