Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

PROCTMPPAR


                            PROCTMPPAR FILE

REFERENCED BY

PO215     RQIG.1    PO20.1    RQ10.1

UPDATED BY

PO115     PO15.1    PO15.2    RQ780

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

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

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

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

POA-REQ-LOCATION       Alpha 5                                   PO115   PO15.1
Element: Location Code                                           PO15.2  RQ780

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

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

POA-BUYER              Alpha 3                                   PO115   PO15.1
Element: Buyer                                                   PO15.2  RQ780

POA-ACCT-UNIT          Alpha 15                                  RQ780
Element: Accounting UniThe 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                                          PO115   PO15.1
          TEMPLATE-REF                                           PO15.2  PO215
          COMPANY                                                RQ780   RQIG.1
          REQ-LOCATION
          REQUESTER
          BUYER-GRP
          BUYER

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

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

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

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

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

                         PROCTMPPAR FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Proctemp       PROCTEMP     Required

                            POA-PROCURE-GROUP    -> POP-PROCURE-GROUP
                            POA-TEMPLATE-REF     -> POP-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