Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

PBONETMDED


                            PBONETMDED FILE

UPDATED BY

PR197

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

PNE-COMPANY            Numeric 4                                 PR197
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.

PNE-EMPLOYEE           Numeric 9                                 PR197
Element: Employee      Contains the employee number. Each
                       person employed by the company is
                       assigned a unique number. The system
                       uses the employee number to correlate
                       all of the information related to that
                       person.

PNE-DED-CODE           Alpha 4                                   PR197
Element: Deduction Code

PNE-EDM-SEQ-NBR        Numeric 4                                 PR197
Emp Deduction
Sequence Number

PNE-SEQ-NBR            Numeric 4                                 PR197
Element: Sequence NumbeAn automatically assigned sequence
                       number.

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

PNE-EFFECT-DATE        Numeric 8  (yyyymmdd)                     PR197
Element: Effective Date

PNE-DED-TYPE           Alpha 1                                   PR197
Element: Deduction Type

PNE-DED-PRIORITY       Numeric 1                                 PR197
Element: Deduction Priority

PNE-RECORD-TYPE        Alpha 1                                   PR197
Element: Record Type   This field identifies the type of
                       record defined.

                       Valid values are:
                       S = Summary
                       D = Detail

PNE-STATUS             Numeric 1                                 PR197
Element: Status        This field displays the status of the
                       transaction.

                         PBONETMDED FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PNESET1   COMPANY                                                PR197
          EMPLOYEE
          DED-CODE
          EDM-SEQ-NBR
          SEQ-NBR

                         PBONETMDED FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Employee       EMPLOYEE     Required

                            PNE-COMPANY     -> EMP-COMPANY
                            PNE-EMPLOYEE    -> EMP-EMPLOYEE