Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

PROCTEMP


                             PROCTEMP FILE

REFERENCED BY

PO20.1    PO215     RQ10.1    RQIG.1

UPDATED BY

PO115     PO15.1    PO15.2    PO15.3

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

POP-PROCURE-GROUP      Alpha 4                                   PO115   PO15.1
Element: Procure Group This field contains the identifier for    PO15.2  PO20.1
                       a group of companies that share a common  RQ10.1
                       procurement effort. They buy items and
                       services together.

POP-TEMPLATE-REF       Alpha 30                                  PO115   PO15.1
Element: Template Ref                                            PO15.2  PO20.1
                                                                 RQ10.1

POP-DESCRIPTION        Alpha 30  (Lower Case)                    PO115   PO15.1
Element: Description   This field displays the description.      PO15.2  PO20.1
                                                                 RQ10.1

POP-LAST-LINE-NBR      Numeric 6                                 PO115   PO15.1
Element: Line Nbr      This field contains the line number.      PO15.2  PO20.1
                                                                 RQ10.1

POP-FROM-COMPANY       Numeric 4                                 PO115   PO15.1
Element: Company       Identifies the AP company if the          PO15.2  PO20.1
                       resource type = V.  Identifies the HR     RQ10.1
                       company if the resource type = E.  It is
                       blank for type A, P or Q resources.

POP-FROM-LOCATION      Alpha 5                                   PO115   PO15.1
Element: Location      This field contains a valid stocking      PO15.2  PO20.1
                       location within the company inventory.    RQ10.1

POP-LOCK-FLAG          Numeric 1                                 PO115   PO15.1
Element: Lock Flag     0 = Not Locked                            PO15.2  PO15.3
                       1 = Locked                                PO20.1  RQ10.1

POP-PARTICIPANT        Derived
Element: Participant

                         PROCTEMP FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

POPSET1   PROCURE-GROUP                                          PO115   PO15.1
          TEMPLATE-REF                                           PO15.2  PO15.3
                                                                 PO20.1  PO215
                                                                 RQ10.1  RQIG.1

                         PROCTEMP FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Proctempl2     PROCTEMPLN   Delete Cascades

                            POP-PROCURE-GROUP    -> POE-PROCURE-GROUP
                            POP-TEMPLATE-REF     -> POE-TEMPLATE-REF
                                                    POE-ITEM
                                                    POE-LINE-NBR

Proctempln     PROCTEMPLN   Delete Cascades

                            POP-PROCURE-GROUP    -> POE-PROCURE-GROUP
                            POP-TEMPLATE-REF     -> POE-TEMPLATE-REF
                                                    POE-LINE-NBR

Proctmppar     PROCTMPPAR   Delete Cascades

                            POP-PROCURE-GROUP    -> POA-PROCURE-GROUP
                            POP-TEMPLATE-REF     -> POA-TEMPLATE-REF
                                                    POA-COMPANY
                                                    POA-REQ-LOCATION
                                                    POA-REQUESTER
                                                    POA-BUYER-GRP
                                                    POA-BUYER