Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                            PROCTEMPLN FILE

REFERENCED BY

DR100     IC141     IC142     IC83.1    PO20.1    PO215
RQ10.1    RQ10.3    RQ11.1    RQ35.1    RQIC.1    RQIG.1
IC11.1    RQID.1    RQIF.1

UPDATED BY

PO15.1    PO15.2    RQ780

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

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

POE-TEMPLATE-REF     Alpha 30                                    PO15.1  PO15.2
Template Ref                                                     RQ10.3  RQ780

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

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

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

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

POE-UOM              Alpha 4                                     PO15.1  PO15.2
Unit of Measure      This field contains the valid stock         RQ10.3  RQ780
                     unit of measure for this item.


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

POE-DIST-COMPANY     Numeric 4                                   PO15.1  PO15.2
Distribution Company The company number used for posting the     RQ10.3  RQ780
                     transaction. A valid intercompany
                     relationship must be defined in the
                     Lawson General Ledger system.

POE-ACCT-UNIT        Alpha 15                                    PO15.1  PO15.2
Accounting Unit      The accounting unit is a shorthand          RQ10.3  RQ780
                     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.


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

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

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



POE-ACCT-CATEGORY    Alpha 5                                     PO15.1  PO15.2
Account Category     Account categories are groupings of         RQ10.3  RQ780
                     costs, revenues, or a combination of
                     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                                   PO15.1  PO15.2
From Company         This is the company that is the source      RQ10.3  RQ780
                     of the items.

POE-FROM-LOCATION    Alpha 5                                     PO15.1  PO15.2
From Location        This is the inventory location that         RQ10.3  RQ780
                     supplies the items or it is the purchase
                     order ship to location that receives the
                     items.

                         PROCTEMPLN FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

POESET1   PROCURE-GROUP                                          DR100   IC141
          TEMPLATE-REF                                           IC142   IC83.1
          LINE-NBR                                               PO15.1  PO15.2
                                                                 PO20.1  PO215
                                                                 RQ10.1  RQ10.3
                                                                 RQ11.1  RQ35.1
                                                                 RQ780   RQIC.1
                                                                 RQIG.1

POESET2   PROCURE-GROUP KeyChange                                PO15.1  PO15.2
          TEMPLATE-REF                                           RQ10.3
          ITEM
          LINE-NBR

POESET3   PROCURE-GROUP KeyChange                                IC11.1  RQID.1
          ITEM                                                   RQIF.1
          TEMPLATE-REF
          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