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    RQ780

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

POP-PROCURE-GROUP      Alpha 4                                   PO115   PO15.1
Element: Procure Group This field contains the identifier for a  PO15.2  PO20.1
                       group of companies that share a common    RQ10.1  RQ780
                       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  RQ780

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

POP-LAST-LINE-NBR      Numeric 6                                 PO115   PO15.1
Element: Line Number                                             PO15.2  PO20.1
                                                                 RQ10.1  RQ780

POP-FROM-COMPANY       Numeric 4                                 PO115   PO15.1
Element: Company                                                 PO15.2  PO20.1
                                                                 RQ10.1

POP-FROM-LOCATION      Alpha 5                                   PO115   PO15.1
Element: Location Code                                           PO15.2  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  PO20.1
                                                                 PO215   RQ10.1
                                                                 RQ780   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