Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             ACBRDNDTL FILE

REFERENCED BY

AC190     AC261     AC541     BR04.1    AC60.1    AC62.1

UPDATED BY

AC105     AC110     AC120     AC300     AC310     AC61.1
AC10.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

BRD-ACTIVITY-GRP     Alpha 15                                    AC105   AC110
Activity Group                                                   AC120   AC61.1

BRD-ALL-ACTV-FL      Alpha 1                                     AC105   AC110
All Actv Fl                                                      AC120   AC61.1

BRD-ACTIVITY         Alpha 15                                    AC105   AC110
Activity             Activities are the processes or             AC120   AC61.1
                     procedures that produce work. Cost
                     objects (products, services, customers,
                     and so on) are the reasons for
                     performing the activity.



BRD-ALL-CAT-FL       Alpha 1                                     AC105   AC110
All Cat Fl                                                       AC120   AC61.1

BRD-ACCT-CATEGORY    Alpha 5                                     AC105   AC110
Account Category     Account categories are groupings of         AC120   AC61.1
                     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.



BRD-BURDEN-CD        Alpha 5                                     AC105   AC110
Burden Cd                                                        AC120   AC61.1

BRD-POOL-NBR         Numeric 3                                   AC105   AC110
Pool Nbr                                                         AC120   AC61.1

                         ACBRDNDTL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

BRDSET1   ACTIVITY-GRP                                           AC10.1  AC105
          ACTIVITY                                               AC110   AC120
          ACCT-CATEGORY                                          AC190   AC261
          BURDEN-CD                                              AC300   AC310
          POOL-NBR                                               AC541   AC61.1
                                                                 BR04.1

BRDSET2   BURDEN-CD                                              AC105   AC110
          POOL-NBR                                               AC120   AC60.1
          ACTIVITY-GRP                                           AC62.1
          ACTIVITY
          ACCT-CATEGORY

                         ACBRDNDTL FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Acacctcat      ACACCTCAT    Required

                            BRD-ACCT-CATEGORY    -> AAX-ACCT-CATEGORY

Acacctcatx     ACACCTCATX   Required

                            BRD-ACTIVITY-GRP     -> AXX-ACTIVITY-GRP
                            BRD-ACTIVITY         -> AXX-ACTIVITY
                            BRD-ACCT-CATEGORY    -> AXX-ACCT-CATEGORY

Acactgrp       ACACTGRP     Required

                            BRD-ACTIVITY-GRP     -> AGP-ACTIVITY-GRP

Acactivity     ACACTIVITY   Required

                            BRD-ACTIVITY         -> ACV-ACTIVITY

Acbrdnhdr      ACBRDNHDR    Required

                            BRD-BURDEN-CD        -> BRH-BURDEN-CD

Acbrdnpool     ACBRDNPOOL   Required

                            BRD-BURDEN-CD        -> BPL-BURDEN-CD
                            BRD-POOL-NBR         -> BPL-POOL-NBR