Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ACBRDNPRRX


                            ACBRDNPRRX FILE

REFERENCED BY

AC263     AC190     AC198     AC541

UPDATED BY

AC63.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

BPX-BURDEN-CD          Alpha 5                                   AC63.1
Element: Burden Cd

BPX-POOL-NBR           Numeric 3                                 AC63.1
Element: Pool Nbr

BPX-BURDEN-TYPE        Alpha 1                                   AC63.1
Element: Burden Type   Burden type is used to determine the
                       type of calculation that is used to
                       determine the total cost associated with
                       a specific burden.


BPX-EFFECTIVE-DATE     Numeric 8  (yyyymmdd)                     AC63.1
Element: Date

BPX-PROV-RATE          Signed 13.4                               AC63.1
Element: Prov Rate

BPX-COMPUTE-NAME       Alpha 12                                  AC63.1
Element: Name User

BPX-PARAM-NAME         Alpha 12                                  AC63.1
Element: Param Name

BPX-DATE-ENTERED       Numeric 8  (yyyymmdd)                     AC63.1
Element: Date

BPX-ACTIVE-STATUS      Alpha 1                                   AC63.1
Element: Status        The status of the account. If Inactive,
                       no posting can be done to the account.
                       A = Active
                       I = Inactive

                         ACBRDNPRRX FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

BPXSET1   BURDEN-CD                                              AC263   AC63.1
          POOL-NBR
          BURDEN-TYPE
          EFFECTIVE-DATE
          DATE-ENTERED

BPXSET2   BURDEN-CD                                              AC190   AC198
          POOL-NBR                                               AC541
          BURDEN-TYPE
          ACTIVE-STATUS
          EFFECTIVE-DATE*
          DATE-ENTERED

                         ACBRDNPRRX FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Acbrdnhdr      ACBRDNHDR    Required

                            BPX-BURDEN-CD       -> BRH-BURDEN-CD

Acbrdnplx      ACBRDNPLX    Not Required

                            BPX-BURDEN-CD       -> BPA-BURDEN-CD
                            BPX-POOL-NBR        -> BPA-POOL-NBR

Acbrdnpool     ACBRDNPOOL   Required

                            BPX-BURDEN-CD       -> BPL-BURDEN-CD
                            BPX-POOL-NBR        -> BPL-POOL-NBR

Acbrdnprrt     ACBRDNPRRT   Required

                            BPX-BURDEN-CD       -> BPR-BURDEN-CD
                            BPX-POOL-NBR        -> BPR-POOL-NBR
                            BPX-BURDEN-TYPE     -> BPR-BURDEN-TYPE

Accmpparam     ACCMPPARAM   Required

                            BPX-PARAM-NAME      -> CPM-PARAM-NAME

Cmpute         CMPUTE       Not Required

                            BPX-COMPUTE-NAME    -> CMP-COMPUTE-NAME