Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

PBBLDEDRT


                             PBBLDEDRT FILE

REFERENCED BY

PR197     PR85.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

PBR-COMPANY            Numeric 4
Element: Company Hr    Identifies the AP company if the
                       resource type = V.  Identifies the HR
                       company if the resource type = E.  It is
                       blank for type A, P or Q resources.

PBR-PROCESS-LEVEL      Alpha 5
Element: Process Lev HrThis field contains the process level,
                       which is the reporting hierarchy below
                       company.

PBR-DED-CODE           Alpha 4
Element: Deduction Code

PBR-DEDUCTION-GRP      Alpha 10
Element: Deduction Grp

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

                         PBBLDEDRT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PBRSET1   COMPANY                                                PR197   PR85.1
          PROCESS-LEVEL
          DED-CODE-ORDER

PBRSET2   COMPANY       KeyChange                                PR197   PR85.1
          DED-CODE
          PROCESS-LEVEL
          DED-CODE-ORDER

                         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