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

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
                       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 Number   This field contains the number of the     PO15.2  PO20.1
                       last line item added to the document. It  RQ10.1
                       is used to determine what the next line
                       number is when you add another
                       item.

POP-FROM-COMPANY       Numeric 4                                 PO115   PO15.1
Element: Company       This is the company that is the source    PO15.2  PO20.1
                       of the items.                             RQ10.1

POP-FROM-LOCATION      Alpha 5                                   PO115   PO15.1
Element: Location Code This is the inventory location that       PO15.2  PO20.1
                       supplies the items or it is the purchase  RQ10.1
                       order ship to location that receives the
                       items.

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
                                                                 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