Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

PROCTMPPAR


                            PROCTMPPAR FILE

REFERENCED BY

PO20.1    PO215     RQIG.1    RQ10.1

UPDATED BY

PO115     PO15.1    PO15.2

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

POA-PROCURE-GROUP      Alpha 4                                   PO115   PO15.1
Element: Procure Group This field contains the identifier for    PO15.2
                       a 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

POA-COMPANY            Numeric 4                                 PO115   PO15.1
Element: Company       Identifies the AP company if the          PO15.2
                       resource type = V.  Identifies the HR
                       company if the resource type = E.  It is
                       blank for type A, P or Q resources.

POA-REQ-LOCATION       Alpha 5                                   PO115   PO15.1
Element: Req Location  The location requisitioning items.        PO15.2
                       This location can be an inventory or
                       noninventory location.

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

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

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

POA-ACCT-UNIT          Alpha 15
Element: Acct 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                                          PO115   PO15.1
          TEMPLATE-REF                                           PO15.2  PO20.1
          COMPANY                                                PO215   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   RQ10.1
          COMPANY       Where (COMPANY      != Zeroes )          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