Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ACBLACTV


                             ACBLACTV FILE

REFERENCED BY

AC550

UPDATED BY

AC10.1    AC300     AC310     AC500     BR00.1    BR00.2

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

BLA-BILL-ACTIVITY      Alpha 15                                  AC10.1  AC500
Element: Bill Activity                                           BR00.1  BR00.2

BLA-ACTIVITY           Alpha 15                                  AC10.1  AC500
Element: Activity      Activities are the processes or           BR00.1  BR00.2
                       procedures that produce work. Cost
                       objects (products, services, customers,
                       and so on) are the reasons for
                       performing the activity.


BLA-ACCT-CATEGORY      Alpha 5                                   AC10.1  AC500
Element: Account CategoAccount categories are groupings of       BR00.1  BR00.2
                       costs, revenues, or a 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.

BLA-ACCT-CAT-CLASS     Alpha 5                                   AC10.1  AC500
Element: Acct Cat Class                                          BR00.1  BR00.2

BLA-LEVEL-DEPTH        Numeric 1                                 AC10.1  AC500
Element: Level Depth   The number of variable levels             BR00.1  BR00.2
                       pertaining
                       to this record.


BLA-BILLING-METHOD     Numeric 1                                 AC10.1  AC500
Element: Billing Method                                          BR00.1  BR00.2

                         ACBLACTV FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

BLASET1   BILL-ACTIVITY                                          AC550   BR00.1
          ACTIVITY                                               BR00.2
          ACCT-CATEGORY
          ACCT-CAT-CLASS

BLASET2   ACTIVITY                                               AC10.1  AC300
          ACCT-CATEGORY                                          AC310   BR00.1
          ACCT-CAT-CLASS                                         BR00.2
          BILL-ACTIVITY

BLASET3   BILL-ACTIVITY                                          BR00.1  BR00.2
          ACCT-CAT-CLASS
          ACCT-CATEGORY
          ACTIVITY

                         ACBLACTV FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Acacctclss     ACACCTCLSS   Required

                            BLA-ACCT-CAT-CLASS    -> AXA-ACCT-CAT-CLASS

Acactgrp       ACACTGRP     Required

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

Acactivity     ACACTIVITY   Required

                            BLA-ACTIVITY          -> ACV-ACTIVITY

Acbill         ACBILL       Required

                            BLA-BILL-ACTIVITY     -> ACI-ACTIVITY

Acbillx        ACBILLX      Required

                            BLA-BILL-ACTIVITY     -> AIX-ACTIVITY
                            BLA-ACCT-CATEGORY     -> AIX-ACCT-CATEGORY
                            BLA-ACCT-CAT-CLASS    -> AIX-ACCT-CAT-CLASS

                         ACBLACTV FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Acblrate       ACBLRATE

                            BLA-BILL-ACTIVITY     -> ALR-ACTIVITY
                            BLA-ACCT-CAT-CLASS    -> ALR-ACCT-CAT-CLASS
                            BLA-ACCT-CATEGORY     -> ALR-ACCT-CATEGORY
                                                     ALR-SOURCE-CODE
                                                     ALR-MATRIX-CAT
                                                     ALR-EFFECTIVE-DT

Acblratex      ACBLRATE

                            BLA-BILL-ACTIVITY     -> ALR-ACTIVITY
                            BLA-ACCT-CAT-CLASS    -> ALR-ACCT-CAT-CLASS
                            BLA-ACCT-CATEGORY     -> ALR-ACCT-CATEGORY
                                                     ALR-SOURCE-CODE
                                                     ALR-MATRIX-CAT
                                                     ALR-EFFECTIVE-DT