Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ACBRDNDTL


                             ACBRDNDTL FILE

REFERENCED BY

AC190     AC197     AC261     BR04.1    AC60.1    AC62.1


UPDATED BY

AC105     AC110     AC120     AC300     AC310     AC61.1
AC00.1    AC10.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

BRD-ACTIVITY-GRP       Alpha 15                                  AC105   AC110
Element: Activity Grp  The activity group is the overall         AC120   AC61.1
                       project.

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

                       Valid account category types are:
                       cost
                       revenue
                       accrual
                       pass thru

BRD-BURDEN-CD          Alpha 5                                   AC105   AC61.1
Element: Burden Cd

BRD-POOL-NBR           Numeric 3                                 AC105   AC61.1
Element: Pool Nbr

                         ACBRDNDTL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

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

BRDSET2   BURDEN-CD                                              AC60.1  AC62.1
          POOL-NBR
          ACTIVITY-GRP
          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