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    PO215     RQ11.1
IC11.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    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                                                     RQ780

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

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

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

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

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


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

POE-ACCOUNT          Numeric 6                                   PO15.1  PO15.2
Account              This field along with the accounting        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     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             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         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.

                         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
                                                                 PO215   RQ11.1
                                                                 RQ780

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

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