Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ACBLACTV


                             ACBLACTV FILE

This file contains billing information for the posting activities associated
with a billing activity established in Activity Billing ( BR00.1) and Billing
Detail (BR00.2). It includes a record for each posting activity. If a detail
record is established, a record exists for each account category or summary
account category for the posting activity.

The primary purpose of this file is to determine the billing activity for a
posting level activity.  This file is updated by BR00 and read by DI550
(Databasics Interface Time and Expense Entry Load).

UPDATED BY

AC10.1    AC120     AC300     AC310     AC500     BR00.1
BR00.2    PW110     PW510

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

BLA-BILL-ACTIVITY      Alpha 15                                  AC10.1  AC120
Element: Bill Activity The Billing activity maintained in        AC500   BR00.1
                       Activity Billing (BR00.1).                BR00.2  PW110
                                                                 PW510

BLA-ACTIVITY           Alpha 15                                  AC10.1  AC500
Element: Activity      The posting activities associated with    BR00.1  BR00.2
                       the activity maintained in Activity       PW110   PW510
                       Billing (BR00.1).  If a detail billing
                       exists in Billing Detail (BR00.2), a
                       separate record is created for the
                       posting activity and account category or
                       summary acct category.


BLA-ACCT-CATEGORY      Alpha 5                                   AC10.1  AC500
Element: Acct Category The account category maintained in the    BR00.1  BR00.2
                       Billing Detail (BR00.2) for the Billing   PW110   PW510
                       Activity.  A separate record will exist
                       for each account category.

BLA-LEVEL-DEPTH        Numeric 1                                 AC10.1  AC500
Element: Level Depth   The variable level depth of the billing   BR00.1  BR00.2
                       Activity. The variable level is           PW110   PW510
                       established in Activity (AC10).

BLA-BILLING-METHOD     Numeric 1                                 AC10.1  AC120
Element: Billing MethodThe method used to calculate billing.     AC500   BR00.1
                       The billing method is maintained in       BR00.2  PW110
                       Activity Billing (BR00.1) or Billing      PW510
                       Detail (BR00.2).
                       The values are:
                       1 = Time and Materials
                       2 = Cost Plus
                       3 = Units of Production
                       4 = Milestone
                       5 = Pass Thru
                       9 = User Defined

BLA-SUM-ACCT-CAT       Alpha 5                                   AC10.1  AC500
Element: Sum Acct Cat  The summary account category maintained   BR00.1  BR00.2
                       in the Billing Detail (BR00.2) for the    PW110   PW510
                       Billing Activity.  A separate record
                       will exist for each summary account
                       category.

BLA-CTR-CAT-GRP        Alpha 5                                   AC10.1  AC500
Element: Ctr Cat Grp                                             BR00.1  BR00.2
                                                                 PW110   PW510

                         ACBLACTV FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

BLASET1   BILL-ACTIVITY                                          AC10.1  AC120
          ACTIVITY                                               BR00.1  BR00.2
          ACCT-CATEGORY
          SUM-ACCT-CAT
          CTR-CAT-GRP

BLASET2   ACTIVITY                                               AC10.1  AC120
          ACCT-CATEGORY                                          AC300   AC310
          CTR-CAT-GRP                                            BR00.1  BR00.2
          SUM-ACCT-CAT
          BILL-ACTIVITY

BLASET3   BILL-ACTIVITY                                          BR00.1  BR00.2
          SUM-ACCT-CAT
          ACCT-CATEGORY
          CTR-CAT-GRP
          ACTIVITY

                         ACBLACTV FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Acactgrp       ACACTGRP     Required

                            ACV-ACTIVITY-GRP     -> AGP-ACTIVITY-GRP

Acactivity     ACACTIVITY   Required

                            BLA-ACTIVITY         -> ACV-ACTIVITY

Acbill         ACBILL       Required

                            BLA-BILL-ACTIVITY    -> ACI-ACTIVITY