Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

PACOMPPROF


                            PACOMPPROF FILE

REFERENCED BY

HS50.3    HS50.4    PA08.1    PA20.1    PA207     PA21.1
PA22.1    PA24.1    PA27.1    PA34.1    PA35.1    PA36.1
PA38.1    PA520     TR21.1    TR22.1    TR26.1    TR500

UPDATED BY

HR04.2    HR04.3    HR04.7    HR04.8    HR80.1    HR80.2
HR80.3    HR80.4    HR80.5    HR80.6    HR80.7    HR80.8
HR80.9    HR81.1    HR81.2    HR81.3    HR81.4    HR81.5
HR81.6    HR81.7    HR81.8    HR81.9    HR82.1    HR82.2
HR82.3    HR82.4    HR82.5    HR82.6    HR82.7    HR82.8
HR82.9    HR83.1    HR83.2    HR83.3    HR83.4    HR83.5
HR83.6    HR83.7    HR83.8    HR83.9    HR84.1    HR84.2
HR84.3    HR84.4    HR84.5    HR84.6    HR84.7    HR84.8
HR84.9    HR85.1    HR85.2    HR85.3    HR85.4    HR85.5
HR85.6    HR85.7    HR85.8    HR86.1    HR86.2    HR86.3
HR86.4    HR86.5    HR86.6    HR86.7    HR86.8    HR86.9
HR87.1    HR87.2    HR87.3    HR87.4    HR87.5    HR87.6
HR87.7    HR87.8    HR87.9    HR88.1    HR88.2    HR88.3
HR88.4    HR88.5    HR88.6    HR88.7    HR89.1    HR89.2
HR89.3    HR89.4    HR89.5    HR89.6    HR89.7    PA07.1
HR00.1    HR01.1    PBIP.1    PR197

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

PCM-COMPANY            Numeric 4                                 PA07.1
Element: Company       The company number represents an
                       established company and is entered on
                       all function codes.

PCM-PROCESS-LEVEL      Alpha 5                                   PA07.1
Element: Process Level This field contains the process level,
                       which is the reporting hierarchy below
                       company.

PCM-CODE               Alpha 10                                  PA07.1
Element: Code

PCM-TYPE               Alpha 2                                   PA07.1
Element: Type          This identifies whether this record is
                       created because of a picking
                       transaction, or because of a return.
                       Valid values are:
                           "IS" = Picking transaction.
                           "RR" = Return.
                        ~$1 VENDOR
                       The vendor's identification code.

                       DF = Default
                       AB = Abilities
                       KN = Knowledge
                       OA = Other Attributes
                       SK = Skills

PCM-PROFIC-LEVEL       Alpha 10                                  PA07.1
Element: Profic Level

PCM-SEQ                Numeric 3                                 HR04.2  HR04.3
Element: Sequence NumbeThis field contains the record sequence   HR04.7  HR04.8
                       number.                                   HR80.1  HR80.2
                                                                 HR80.3  HR80.4
                                                                 HR80.5  HR80.6
                                                                 HR80.7  HR80.8
                                                                 HR80.9  HR81.1
                                                                 HR81.2  HR81.3
                                                                 HR81.4  HR81.5
                                                                 HR81.6  HR81.7
                                                                 HR81.8  HR81.9
                                                                 HR82.1  HR82.2
                                                                 HR82.3  HR82.4
                                                                 HR82.5  HR82.6
                                                                 HR82.7  HR82.8
                                                                 HR82.9  HR83.1
                                                                 HR83.2  HR83.3
                                                                 HR83.4  HR83.5
                                                                 HR83.6  HR83.7
                                                                 HR83.8  HR83.9
                                                                 HR84.1  HR84.2
                                                                 HR84.3  HR84.4
                                                                 HR84.5  HR84.6
                                                                 HR84.7  HR84.8
                                                                 HR84.9  HR85.1
                                                                 HR85.2  HR85.3
                                                                 HR85.4  HR85.5
                                                                 HR85.6  HR85.7
                                                                 HR85.8  HR86.1
                                                                 HR86.2  HR86.3
                                                                 ...

PCM-ACTIVE-FLAG        Alpha 1                                   PA07.1
Element: Status        The Active flag of the credit card
                       type.
                       A = Active
                       I = Inactive

PCM-DESCRIPTION        Alpha 30  (Lower Case)                    PA07.1
Element: Description   This field displays the description.

PCM-COMMENTS           Alpha 50  (Lower Case)                    PA07.1
Element: Comments      This field contains the text you enter
                       for the comment to be associated with an
                       asset. You can have multiple lines of
                       comments for each comment type.

PCM-DATE-STAMP         Numeric 8  (yyyymmdd)                     PA07.1
Element: Date Stamp    This field contains the server date
                       (month, date, and year) of the last
                       change to this record.

PCM-TIME-STAMP         Numeric 6  (hhmmss)                       PA07.1
Element: Time Stamp    Contains the server time (hour, minute,
                       and second) when the record was last
                       changed.

PCM-USER-ID            Alpha 10  (Lower Case)                    PA07.1
Element: User

                         PACOMPPROF FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PCMSET1   COMPANY                                                HR00.1  HR01.1
          PROCESS-LEVEL                                          HS50.3  HS50.4
          TYPE                                                   PA07.1  PA08.1
          CODE                                                   PA20.1  PA207
          PROFIC-LEVEL                                           PA21.1  PA22.1
                                                                 PA24.1  PA27.1
                                                                 PA34.1  PA35.1
                                                                 PA36.1  PA38.1
                                                                 PA520   TR21.1
                                                                 TR22.1  TR26.1
                                                                 TR500   PBIP.1
                                                                 PR197

PCMSET2   PROFIC-LEVEL                                           HR04.2  HR04.3
          COMPANY                                                HR04.7  HR04.8
          PROCESS-LEVEL                                          HR80.1  HR80.2
          TYPE                                                   HR80.3  HR80.4
          CODE                                                   HR80.5  HR80.6
                                                                 HR80.7  HR80.8
                                                                 HR80.9  HR81.1
                                                                 HR81.2  HR81.3
                                                                 HR81.4  HR81.5
                                                                 HR81.6  HR81.7
                                                                 HR81.8  HR81.9
                                                                 HR82.1  HR82.2
                                                                 HR82.3  HR82.4
                                                                 HR82.5  HR82.6
                                                                 HR82.7  HR82.8
                                                                 ...

PCMSET3   CODE          KeyChange                                HR04.2  HR04.3
          TYPE                                                   HR04.7  HR04.8
          COMPANY                                                HR80.1  HR80.2
          PROCESS-LEVEL                                          HR80.3  HR80.4
          SEQ                                                    HR80.5  HR80.6
          PROFIC-LEVEL                                           HR80.7  HR80.8
                                                                 HR80.9  HR81.1
                                                                 HR81.2  HR81.3
                                                                 HR81.4  HR81.5
                                                                 HR81.6  HR81.7
                                                                 HR81.8  HR81.9
                                                                 HR82.1  HR82.2
                                                                 HR82.3  HR82.4
                                                                 HR82.5  HR82.6
                                                                 HR82.7  HR82.8
                                                                 ...

PCMSET4   COMPANY       KeyChange                                HR04.2  HR04.3
          PROCESS-LEVEL                                          HR04.7  HR04.8
          TYPE                                                   HR80.1  HR80.2
          CODE                                                   HR80.3  HR80.4
          SEQ                                                    HR80.5  HR80.6
          PROFIC-LEVEL                                           HR80.7  HR80.8
                                                                 HR80.9  HR81.1
                                                                 HR81.2  HR81.3
                                                                 HR81.4  HR81.5
                                                                 HR81.6  HR81.7
                                                                 HR81.8  HR81.9
                                                                 HR82.1  HR82.2
                                                                 HR82.3  HR82.4
                                                                 HR82.5  HR82.6
                                                                 HR82.7  HR82.8
                                                                 ...

                         PACOMPPROF FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Company        PRSYSTEM     Required

                            PCM-COMPANY          -> PRS-COMPANY
                            Spaces               -> PRS-PROCESS-LEVEL

Hr Codes       PCODES       Required
                            When (PCM-TYPE != "DF" )

                            PCM-TYPE             -> PCO-TYPE
                            PCM-CODE             -> PCO-CODE

Process Level  PRSYSTEM     Required
                            When (PCM-PROCESS-LEVEL != Spaces )

                            PCM-COMPANY          -> PRS-COMPANY
                            PCM-PROCESS-LEVEL    -> PRS-PROCESS-LEVEL

Proficiency    PCODES       Required

                            "PF"                 -> PCO-TYPE
                            PCM-PROFIC-LEVEL     -> PCO-CODE