Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             PBBLDEDRT FILE

REFERENCED BY

BN66.1    PR140     PR189     PR195     PR197     PR80.1
PR85.1    PR89.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

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


PBR-PROCESS-LEVEL    Alpha 5
Process Level        This field contains the process level,
                     which is the reporting hierarchy below
                     company.


PBR-DED-CODE         Alpha 4
Deduction Code

PBR-DEDUCTION-GRP    Alpha 10
Deduction Grp

PBR-DED-CODE-ORDER   Numeric 3
Ded Code Order

                         PBBLDEDRT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PBRSET1   COMPANY                                                BN66.1  PR140
          PROCESS-LEVEL                                          PR189   PR195
          DED-CODE-ORDER                                         PR197   PR80.1
                                                                 PR85.1  PR89.1

PBRSET2   COMPANY       KeyChange                                BN66.1  PR140
          DED-CODE                                               PR189   PR195
          PROCESS-LEVEL                                          PR197   PR80.1
          DED-CODE-ORDER                                         PR85.1  PR89.1

                         PBBLDEDRT FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Dedcode        DEDCODE      Required

                            PBR-COMPANY           -> DDC-COMPANY
                            PBR-DED-CODE          -> DDC-DED-CODE

Pbclient       PBCLIENT     Required

                            PBR-COMPANY           -> PCC-COMPANY
                            PBR-PROCESS-LEVEL     -> PCC-PROCESS-LEVEL

Prsystem       PRSYSTEM     Required

                            PBR-COMPANY           -> PRS-COMPANY
                            PBR-PROCESS-LEVEL     -> PRS-PROCESS-LEVEL

                         PBBLDEDRT FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Pbbldedrx      PBBLDEDRX

                            PBR-COMPANY           -> PER-COMPANY
                            PBR-PROCESS-LEVEL     -> PER-PROCESS-LEVEL
                            PBR-DED-CODE-ORDER    -> PER-DED-CODE-ORDER
                                                     PER-EFFECT-DATE
                                                     PER-TAX-STATE