Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                            PROCTMPPAR FILE

REFERENCED BY

PO215     RQIG.1    PO20.1    RQ10.1

UPDATED BY

PO15.1    PO15.2    RQ780

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

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

POA-TEMPLATE-REF     Alpha 30                                    PO15.1  PO15.2
Template Ref                                                     RQ780

POA-COMPANY          Numeric 4                                   PO15.1  PO15.2
Company              The company number represents an            RQ780
                     established company and is entered on
                     all function codes.


POA-REQ-LOCATION     Alpha 5                                     PO15.1  PO15.2
To Location          The location requisitioning items.          RQ780
                     This location can be an inventory or
                     noninventory location.

POA-REQUESTER        Alpha 10  (Lower Case)                      PO15.1  PO15.2
Requester            This is the person who requested this       RQ780
                     requisition.

POA-BUYER-GRP        Alpha 5                                     PO15.1  PO15.2
Buyer Group          The user defined buyer group.               RQ780

POA-BUYER            Alpha 3                                     PO15.1  PO15.2
Buyer                                                            RQ780

POA-ACCT-UNIT        Alpha 15                                    RQ780
Accounting Unit      The accounting unit is a shorthand
                     notation representing the variable level
                     number. When used in the General Ledger
                     Account Master file, the accounting unit
                     must be defined in the General Ledger
                     Names file as a posting accounting unit.


                         PROCTMPPAR FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

POASET1   PROCURE-GROUP                                          PO15.1  PO15.2
          TEMPLATE-REF                                           PO215   RQ780
          COMPANY                                                RQIG.1
          REQ-LOCATION
          REQUESTER
          BUYER-GRP
          BUYER

POASET2   PROCURE-GROUP KeyChange, Subset                        PO20.1
          BUYER-GRP     Where (BUYER-GRP != Spaces )
          TEMPLATE-REF

POASET3   PROCURE-GROUP KeyChange, Subset                        PO20.1
          BUYER         Where (BUYER != Spaces )
          TEMPLATE-REF

POASET4   PROCURE-GROUP KeyChange, Duplicates, Subset            PO20.1  RQ10.1
          COMPANY       Where (COMPANY      != Zeroes )          RQIG.1
          TEMPLATE-REF  And   (REQ-LOCATION =  Spaces )

POASET5   PROCURE-GROUP KeyChange, Subset                        RQ10.1  RQIG.1
          COMPANY       Where (REQ-LOCATION != Spaces )
          REQ-LOCATION  And   (COMPANY      != Zeroes )
          TEMPLATE-REF

POASET6   PROCURE-GROUP KeyChange, Subset                        RQ10.1  RQIG.1
          REQUESTER     Where (REQUESTER != Spaces )
          TEMPLATE-REF

                         PROCTMPPAR FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Proctempln     PROCTEMPLN

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