Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                            PBONETMDED FILE

UPDATED BY

PR197

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

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

PNE-EMPLOYEE         Numeric 9                                   PR197
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
Deduction Code

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

PNE-SEQ-NBR          Numeric 4                                   PR197
Sequence Number      An automatically assigned sequence
                     number.

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

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

PNE-DED-TYPE         Alpha 1                                     PR197
Deduction Type

PNE-DED-PRIORITY     Numeric 1                                   PR197
Deduction Priority

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

                     Valid values are:
                     S = Summary
                     D = Detail

PNE-STATUS           Numeric 1                                   PR197
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

PNESET2   COMPANY       Subset
          EMPLOYEE      Where STATUS = 1
          EFFECT-DATE
          DED-CODE
          EDM-SEQ-NBR
          SEQ-NBR

PNESET3   COMPANY       Subset
          EMPLOYEE      Where STATUS = 2
          EFFECT-DATE
          DED-PRIORITY
          DED-CODE
          EDM-SEQ-NBR
          SEQ-NBR