Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ACBRDNPLX


                             ACBRDNPLX FILE

REFERENCED BY

AC190     AC262     AC541

UPDATED BY

AC62.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

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

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

BPA-FR-ACTIVITY        Alpha 15                                  AC62.1
Element: Activity

BPA-TO-ACTIVITY        Alpha 15                                  AC62.1
Element: Activity

BPA-MATRIX-LIST        Alpha 12                                  AC62.1
Element: Attribute ListAttribute 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
Element: Company       The company number represents an
                       established company and is entered on
                       all function codes.

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

BPA-TO-ACCT-UNIT       Alpha 15                                  AC62.1
Element: Accounting Unit

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

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

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

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

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

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

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

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

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

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

                         ACBRDNPLX FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

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

                         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