Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ACBRDNPOOL


                            ACBRDNPOOL FILE

REFERENCED BY

AC261     AC262     AC263     AC60.1    AC61.1    AC63.1
BR04.1

UPDATED BY

AC62.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

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

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

BPL-POOL-DESC          Alpha 30                                  AC62.1
Element: Pool Desc

                         ACBRDNPOOL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

BPLSET1   BURDEN-CD                                              AC261   AC262
          POOL-NBR                                               AC263   AC60.1
                                                                 AC61.1  AC62.1
                                                                 AC63.1  BR04.1

                         ACBRDNPOOL FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Acbrdnhdr      ACBRDNHDR    Required

                            BPL-BURDEN-CD    -> BRH-BURDEN-CD

                         ACBRDNPOOL FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Acbrdnplx      ACBRDNPLX

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

Acbrdnprrt     ACBRDNPRRT

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

Acbrdnprrx     ACBRDNPRRX

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