Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             PROCTEMP FILE

REFERENCED BY

PO20.1    PO215     RQ10.1    RQIG.1

UPDATED BY

PO15.1    PO15.2    RQ780

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

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

POP-TEMPLATE-REF     Alpha 30                                    PO15.1  PO15.2
Template Ref                                                     PO20.1  RQ10.1
                                                                 RQ780

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

POP-LAST-LINE-NBR    Numeric 6                                   PO15.1  PO15.2
Last Line Number     This field contains the number of the       PO20.1  RQ10.1
                     last line item added to the document. It    RQ780
                     is used to determine what the next line
                     number is when you add another
                     item.

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

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

POP-PARTICIPANT      Derived
Participant

                         PROCTEMP FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

POPSET1   PROCURE-GROUP                                          PO15.1  PO15.2
          TEMPLATE-REF                                           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