Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

PCODESTYPE


                            PCODESTYPE FILE

REFERENCED BY

HR04.2    HR204     PA532

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

PCS-TYPE               Alpha 2
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.


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

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

PCS-SETUP-FLAG         Alpha 1
Element: Setup Flag    N = No
                       Y = Yes

PCS-DEFN-PROGRAM       Alpha 5
Element: Define ProgramThe Data Mart Setup Program field
                       contains the name of the program that
                       provides the dimensions, members, and
                       data selection parameters required by
                       the data mart.

PCS-COMMENTS           Alpha 50  (Lower Case)
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.

                         PCODESTYPE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PCSSET1   TYPE                                                   HR04.2  HR204
                                                                 PA532

PCSSET2   DESCRIPTION   KeyChange, Subset                        HR04.2
          TYPE          Where (ACTIVE-FLAG = "A" )
                        And   (SETUP-FLAG  = "Y" )

                         PCODESTYPE FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Pcodes         PCODES       Delete Cascades

                            PCS-TYPE    -> PCO-TYPE
                                           PCO-CODE

Pcodesdtl      PCODESDTL    Delete Cascades

                            PCS-TYPE    -> PDD-TYPE
                                           PDD-CODE