Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

PROCTEMPLN


                            PROCTEMPLN FILE

REFERENCED BY

PO20.1    PO21.1    PO21.2    PO21.3    PO21.4    PO21.5
PO215     RQ10.1    RQ10.3    RQ10.2    RQ11.1    RQ35.1
RQIC.1    RQIG.1    AP125     AP126     AP131     AP20.1
AP20.2    AP20.3    AP20.4    AP20.5    AP20.7    AP23.1
AP25.1    AP25.2    AP26.1    AP27.1    AP30.4    API1.1
CXCP.1    DR100     IC141     IC142     IC21.1    IC21.2
IC28.1    IC500     IC83.1    MA180     MA41.2    MA41.7
MA43.1    MA43.2    MA43.3    MA43.9    MA530     MA531
MA60.2    MA60.3    MA60.5    MA61.1    MA66.2    MA66.3
MA67.1    MA67.2    MA70.1    MA75.1    MA80.1    MAI1.1
PO100     PO101     PO122     PO131     PO22.1    PO23.1
PO25.1    PO25.5    PO25.6    PO25.7    PO27.2    PO29.1
PO30.1    PO30.2    PO30.3    PO300     PO31.1    PO31.2
PO32.2    PO33.1    PO34.1    PO35.1    PO36.1    PO36.2
PO38.1    PO39.1    PO39.2    PO44.1    PO50.1    PO52.1
PO520     PO536     POI3.1    POII.1    POIJ.1    RQ500
RQID.1    RQIE.1    RQIF.1    RQIJ.1    WH130     WH132
WH190     WH20.2    WH20.7    WH222     WH30.1    WH30.2
WH30.3    WH30.4    WH31.1    WH31.2    WH31.3    WH31.4
WH32.1    WH32.2    WH32.3    WH32.4    WH33.1    WH33.2
WH33.3    WH33.4    WH33.5    WH33.6    WH33.8    WH33.9
WH34.1    WH34.2    WH34.3    WH34.4    WH40.1    WH40.2
WH520     WH830     WO132     WO140     IC11.1    PO45.1

UPDATED BY

PO115     PO15.1    PO15.2    RQ780

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

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

POE-TEMPLATE-REF       Alpha 30                                  PO115   PO15.1
Element: Template Ref                                            PO15.2  PO21.1
                                                                 RQ10.3  RQ780

POE-LINE-NBR           Numeric 6                                 PO115   PO15.1
Element: Line Number   This field contains the line number.      PO15.2  PO21.1
                                                                 RQ10.3  RQ780

POE-ITEM               Alpha 32                                  PO115   PO15.1
Element: Item Number   This field contains the item              PO15.2  PO21.1
                       identifier.                               RQ10.3  RQ780

POE-SERVICE-DESC       Alpha 30  (Lower Case)                    PO115   PO15.1
Element: Service Desc                                            PO15.2  PO21.1
                                                                 RQ10.3  RQ780

POE-SERVICE-CODE       Alpha 1                                   PO115   PO15.1
Element: Service Code  Q = Quantity                              PO15.2  PO21.1
                       A = Amount                                RQ10.3  RQ780
                       " " = Not Service Item

POE-UOM                Alpha 4                                   PO115   PO15.1
Element: Unit of MeasurThis field contains the valid stock       PO15.2  PO21.1
                       unit of measure for this item.            RQ10.3  RQ780


POE-QUANTITY           Signed 13.4                               PO115   PO15.1
Element: Quantity      This field contains the desired           PO15.2  PO21.1
                       quantity.                                 RQ10.3  RQ780

POE-ACCT-UNIT-FL       Numeric 1                                 PO115   PO15.1
Element: Acct Unit Fl  This flag will be used allow the          PO15.2  PO21.1
                       requesting location accounting unit to    RQ10.3
                       override the IC02 flag to use the GL
                       category accounting unit.
                       0 = No
                       1 = Yes

POE-DIST-COMPANY       Numeric 4                                 PO115   PO15.1
Element: Company                                                 PO15.2  PO21.1
                                                                 RQ10.3  RQ780

POE-ACCT-UNIT          Alpha 15                                  PO115   PO15.1
Element: Accounting UniThe accounting unit is a shorthand        PO15.2  PO21.1
                       notation representing the variable level  RQ10.3  RQ780
                       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.


POE-ACCOUNT            Numeric 6                                 PO115   PO15.1
Element: Account       This field along with the accounting      PO15.2  PO21.1
                       unit and subaccount make up the location  RQ10.3  RQ780
                       (account) where amounts and other
                       account information is stored.

POE-SUB-ACCT           Numeric 4                                 PO115   PO15.1
Element: Subaccount    This field contains the subaccount from   PO15.2  PO21.1
                       your general ledger chart of accounts     RQ10.3  RQ780
                       that was charged with the amount carried
                       on this record.

POE-ACTIVITY           Alpha 15                                  PO115   PO15.1
Element: Activity      Activities are the processes or           PO15.2  PO21.1
                       procedures that produce work. Cost        RQ10.3  RQ780
                       objects (products, services, customers,
                       and so on) are the reasons for
                       performing the activity.


POE-ACCT-CATEGORY      Alpha 5                                   PO115   PO15.1
Element: Account CategoAccount categories are groupings of       PO15.2  PO21.1
                       costs, revenues, or a combination of      RQ10.3  RQ780
                       both used for reporting and inquiries
                       for activities in the Activity
                       Management system. All transactions are
                       posted to an account category within an
                       activity. You can assign a specific
                       General Ledger account or range of
                       accounts (company, accounting unit,
                       account, and subaccount) that make up
                       the transactions posted to an account
                       category using AC07.1 (Account
                       Assignment).

                       Period-to-date, year-to-date, and
                       life-to-date balances are maintained by
                       account category for activities. Account
                       categories must be assigned to
                       activities before you do any budgeting
                       or transaction processing.

POE-FROM-COMPANY       Numeric 4                                 PO115   PO15.1
Element: Company                                                 PO15.2  PO21.1
                                                                 RQ10.3  RQ780

POE-FROM-LOCATION      Alpha 5                                   PO115   PO15.1
Element: Location Code                                           PO15.2  PO21.1
                                                                 RQ10.3  RQ780

                         PROCTEMPLN FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

POESET1   PROCURE-GROUP                                          PO115   PO15.1
          TEMPLATE-REF                                           PO15.2  PO20.1
          LINE-NBR                                               PO21.1  PO215
                                                                 RQ10.1  RQ10.3
                                                                 RQ11.1  RQ35.1
                                                                 RQ780   RQIC.1
                                                                 RQIG.1

POESET2   PROCURE-GROUP KeyChange                                AP125   AP126
          TEMPLATE-REF                                           AP131   AP20.1
          ITEM                                                   AP20.2  AP20.3
          LINE-NBR                                               AP20.4  AP20.5
                                                                 AP20.7  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP30.4  API1.1
                                                                 CXCP.1  DR100
                                                                 IC141   IC142
                                                                 IC21.1  IC21.2
                                                                 IC28.1  IC500
                                                                 IC83.1  MA180
                                                                 MA41.2  MA41.7
                                                                 MA43.1  MA43.2
                                                                 ...

POESET3   PROCURE-GROUP KeyChange                                IC11.1  PO115
          ITEM                                                   PO45.1  RQID.1
          TEMPLATE-REF                                           RQIF.1  RQIJ.1
          LINE-NBR

                         PROCTEMPLN FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Itemmast       ITEMMAST     Not Required
                            Valid When (POE-SERVICE-CODE = Spaces )

                            PCG-ITEM-GROUP       -> ITE-ITEM-GROUP
                            POE-ITEM             -> ITE-ITEM

Procuregroup   PROCUREGRP   Not Required

                            POE-PROCURE-GROUP    -> PCG-PROCURE-GROUP