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    RQIC.1    RQIG.1
AP125     AP126     AP131     AP20.1    AP20.2    AP20.3
AP20.4    AP20.5    AP20.7    AP21.1    AP23.1    AP25.1
AP25.2    AP26.1    AP27.1    AP30.4    API1.1    BL120
BL122     BL130     BL20.1    BL20.3    BL21.2    BL21.5
BL29.1    BL29.2    BL520     BL820     BL92.1    CXCP.1
MA180     MA41.1    MA41.2    MA41.4    MA41.7    MA43.1
MA43.2    MA43.3    MA43.7    MA530     MA531     MA60.2
MA60.3    MA60.5    MA61.1    MA66.2    MA66.3    MA67.2
MA67.3    MA68.2    MA68.3    MA68.5    MA70.1    MA75.1
MA80.1    MAI1.1    PD10.1    PD10.2    PD130     PD20.1
PD20.2    PD20.3    PO100     PO101     PO122     PO131
PO190     PO22.1    PO23.1    PO24.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    PO32.4
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    POID.1    POII.1    POIJ.1    RQ11.1
RQ35.1    RQ500     RQID.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     IC11.1    PO45.1

UPDATED BY

PO115     PO15.1    PO15.2

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

POE-PROCURE-GROUP      Alpha 4                                   PO115   PO15.1
Element: Procure Group This field contains the identifier for    PO15.2  PO21.1
                       a group of companies that share a common  RQ10.3
                       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

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

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

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

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

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


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

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       Identifies the AP company if the          PO15.2  PO21.1
                       resource type = V.  Identifies the HR     RQ10.3
                       company if the resource type = E.  It is
                       blank for type A, P or Q resources.

POE-ACCT-UNIT          Alpha 15                                  PO115   PO15.1
Element: Acct Unit     The accounting unit is a shorthand        PO15.2  PO21.1
                       notation representing the variable level  RQ10.3
                       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
                       (account) where amounts and other
                       account information is stored.

POE-SUB-ACCT           Numeric 4                                 PO115   PO15.1
Element: Sub Acct      This field contains the subaccount from   PO15.2  PO21.1
                       your general ledger chart of accounts     RQ10.3
                       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
                       objects (products, services, customers,
                       and so on) are the reasons for
                       performing the activity.


POE-ACCT-CATEGORY      Alpha 5                                   PO115   PO15.1
Element: Acct Category Account categories are groupings of       PO15.2  PO21.1
                       costs, revenues, or a combination of      RQ10.3
                       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.

                       Valid account category types are:
                       cost
                       revenue
                       accrual
                       pass thru

POE-BILL-CATEGORY      Alpha 32                                  PO115   PO15.1
Element: Bill Category                                           PO15.2  PO21.1
                                                                 RQ10.3

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

POE-FROM-LOCATION      Alpha 5                                   PO115   PO15.1
Element: Location      This field contains a valid stocking      PO15.2  PO21.1
                       location within the company inventory.    RQ10.3

POE-COMMODITY-CODE     Alpha 35                                  PO115   PO15.1
Element: Commodity Code                                          PO15.2  PO21.1
                                                                 RQ10.3

                         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
                                                                 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  AP21.1
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.4
                                                                 API1.1  BL120
                                                                 BL122   BL130
                                                                 BL20.1  BL20.3
                                                                 BL21.2  BL21.5
                                                                 BL29.1  BL29.2
                                                                 BL520   BL820
                                                                 BL92.1  CXCP.1
                                                                 ...

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