Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             ACBLACTV FILE

REFERENCED BY

AC550     AC750

UPDATED BY

AC10.1    AC300     AC310     BR00.1    BR00.2

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

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

BLA-ACTIVITY         Alpha 15                                    AC10.1  BR00.1
Activity             Activities are the processes or             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  BR00.1
Account Category     Account categories are groupings of         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  BR00.1
Acct Cat Class                                                   BR00.2

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


BLA-BILLING-METHOD   Numeric 1                                   BR00.1  BR00.2
Billing Method

                         ACBLACTV FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

BLASET1   BILL-ACTIVITY                                          AC550   AC750
          ACTIVITY
          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