Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             ACBRDNPLX FILE

REFERENCED BY

AC190     AC262     AC541     AC741     GR741

UPDATED BY

AC62.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

BPA-BURDEN-CD        Alpha 5                                     AC62.1
Burden Cd

BPA-POOL-NBR         Numeric 3                                   AC62.1
Pool Nbr

BPA-FR-ACTIVITY      Alpha 15                                    AC62.1
From Activity

BPA-TO-ACTIVITY      Alpha 15                                    AC62.1
To Activity

BPA-MATRIX-LIST      Alpha 12                                    AC62.1
Attribute List       Attribute categories are selection
                     parameters used to build a list of
                     objects (accounting units). Attribute
                     categories and values are the basis of
                     the selection and sorting. A attribute
                     list can then be used for reporting on
                     and processing objects.


BPA-COMPANY          Numeric 4                                   AC62.1
Company              The company number represents an
                     established company and is entered on
                     all function codes.

BPA-FR-ACCT-UNIT     Alpha 15                                    AC62.1
From Accounting Unit

BPA-TO-ACCT-UNIT     Alpha 15                                    AC62.1
To Accounting Unit   The "to" accounting unit is a shorthand
                     notation representing the variable level
                     number. The accounting unit must be
                     defined in the General Ledger Names file
                     as a posting accounting unit.

BPA-ACCOUNT-LIST     Alpha 12                                    AC62.1
Account List

BPA-FR-ACCT-CAT      Alpha 5                                     AC62.1
From Account
Category

BPA-TO-ACCT-CAT      Alpha 5                                     AC62.1
To Account Category

BPA-CAT-GROUP        Alpha 15                                    AC62.1
Cat Group

BPA-FR-JOB-CODE      Alpha 9                                     AC62.1
Fr Job Code

BPA-TO-JOB-CODE      Alpha 9                                     AC62.1
To Job Code

BPA-FR-EMPLOYEE      Numeric 9                                   AC62.1
Fr Employee

BPA-TO-EMPLOYEE      Numeric 9                                   AC62.1
To Employee

BPA-GROUP-NAME       Alpha 10                                    AC62.1
Group Name

BPA-SALARY-CLASS     Alpha 1                                     AC62.1
Salary Class

                         ACBRDNPLX FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

BPASET1   BURDEN-CD                                              AC190   AC262
          POOL-NBR                                               AC541   AC62.1
                                                                 AC741   GR741

                         ACBRDNPLX FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Acbrdnhdr      ACBRDNHDR    Required

                            BPA-BURDEN-CD    -> BRH-BURDEN-CD

Acbrdnpool     ACBRDNPOOL   Required

                            BPA-BURDEN-CD    -> BPL-BURDEN-CD
                            BPA-POOL-NBR     -> BPL-POOL-NBR

                         ACBRDNPLX FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Acbrdnprrx     ACBRDNPRRX

                            BPA-BURDEN-CD    -> BPX-BURDEN-CD
                            BPA-POOL-NBR     -> BPX-POOL-NBR
                                                BPX-BURDEN-TYPE
                                                BPX-EFFECTIVE-DATE
                                                BPX-DATE-ENTERED