Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

PRDEDDTL


                             PRDEDDTL FILE

REFERENCED BY

PR294

UPDATED BY

AC542     BN66.1    PR140     PR189     PR195     PR197
PR300     PR80.1    PR82.1    PR85.1    PR89.1    HR00.1
HR01.1    HR11.1    PA115     PBIP.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

PDE-COMPANY            Numeric 4                                 BN66.1  PR140
Element: Company       The company number represents an          PR189   PR195
                       established company and is entered on     PR80.1  PR89.1
                       all function codes.

PDE-EMPLOYEE           Numeric 9                                 BN66.1  PR140
Element: Employee      Contains the employee number. Each        PR189   PR195
                       person employed by the company is         PR80.1  PR89.1
                       assigned a unique number. The system
                       uses the employee number to correlate
                       all of the information related to that
                       person.

PDE-PYD-OBJ-ID         Numeric 12                                BN66.1  PR140
Element: Pyd Obj Id                                              PR189   PR195
                                                                 PR80.1  PR89.1

PDE-QTD-OBJ-ID         Numeric 12                                AC542   BN66.1
Element: Qtd Obj Id                                              PR140   PR189
                                                                 PR195   PR197
                                                                 PR80.1  PR82.1
                                                                 PR85.1  PR89.1

PDE-TAX-STATUS         Alpha 2                                   BN66.1  PR140
Element: Tax Status                                              PR189   PR195
                                                                 PR80.1  PR89.1

PDE-NONTAX-REMUN       Signed 13.2                               BN66.1  PR140
Element: Nontax Remun                                            PR189   PR195
                                                                 PR80.1  PR89.1

PDE-TAXABLE-MATCH      Signed 13.2                               BN66.1  PR140
Element: Taxable Match                                           PR189   PR195
                                                                 PR80.1  PR89.1

PDE-REMUN-CODE         Alpha 4
Element: Remun Code

                         PRDEDDTL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PDESET1   PYD-OBJ-ID                                             AC542   BN66.1
          TAX-STATUS                                             PR140   PR189
                                                                 PR195   PR197
                                                                 PR80.1  PR82.1
                                                                 PR85.1  PR89.1

PDESET2   QTD-OBJ-ID    KeyChange, Subset                        PR294   PR300
          TAX-STATUS    Where QTD-OBJ-ID != Zeroes
          PYD-OBJ-ID

PDESET3   COMPANY       Subset                                   HR00.1  HR01.1
          EMPLOYEE      Where TAX-STATUS != Spaces               HR11.1  PA115
          PYD-OBJ-ID                                             PBIP.1  PR197
          TAX-STATUS

PDESET4   COMPANY       Subset
          EMPLOYEE      Where REMUN-CODE != Spaces
          PYD-OBJ-ID
          REMUN-CODE

PDESET5   COMPANY       Subset
          EMPLOYEE      Where REMUN-CODE != Spaces
          REMUN-CODE
          PYD-OBJ-ID