Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                            POAGMTPART FILE

REFERENCED BY

MA66.2    PO100     PO101     PO150     PO20.1    PO21.2
PO21.4    PO21.5    PO227     PO23.1    PO27.1    PO27.2
PO27.3    PO27.4    PO520     POA3.1    POIH.1    RQ10.3

UPDATED BY

AP125     AP126     AP20.1    AP20.2    AP20.3    AP20.4
AP20.5    AP20.7    AP23.1    AP25.1    AP25.2    AP26.1
AP27.1    API1.1    MA41.2    MA43.2    MA61.1    PO25.2
PO25.4    PO25.8    PO300

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

PRK-PROCURE-GROUP    Alpha 4                                     AP125   AP126
Procure Group        This field contains the identifier for a    AP20.1  AP20.2
                     group of companies that share a common      AP20.3  AP20.4
                     procurement effort. They buy items and      AP20.5  AP20.7
                     services together.                          AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  API1.1
                                                                 MA41.2  MA43.2
                                                                 MA61.1  MA66.2
                                                                 PO100   PO23.1
                                                                 PO25.2  PO25.4
                                                                 PO25.8  PO27.1
                                                                 PO300

PRK-VEN-AGRMT-REF    Alpha 30                                    AP125   AP126
Ven Agrmt Ref                                                    AP20.1  AP20.2
                                                                 AP20.3  AP20.4
                                                                 AP20.5  AP20.7
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  API1.1
                                                                 MA41.2  MA43.2
                                                                 MA61.1  MA66.2
                                                                 PO100   PO23.1
                                                                 PO25.2  PO25.4
                                                                 PO25.8  PO27.1
                                                                 PO300

PRK-COMPANY          Numeric 4                                   AP125   AP126
Company              The company number represents an            AP20.1  AP20.2
                     established company and is entered on       AP20.3  AP20.4
                     all function codes.                         AP20.5  AP20.7
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  API1.1
                                                                 MA41.2  MA43.2
                                                                 MA61.1  MA66.2
                                                                 PO100   PO23.1
                                                                 PO25.2  PO25.4
                                                                 PO25.8  PO27.1
                                                                 PO300

PRK-LOCATION         Alpha 5                                     AP125   AP126
Location Code        This field contains a valid stocking        AP20.1  AP20.2
                     location within the company inventory.      AP20.3  AP20.4
                                                                 AP20.5  AP20.7
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  API1.1
                                                                 MA41.2  MA43.2
                                                                 MA61.1  MA66.2
                                                                 PO100   PO23.1
                                                                 PO25.2  PO25.4
                                                                 PO25.8  PO27.1
                                                                 PO300

PRK-REQ-LOCATION     Alpha 5                                     AP125   AP126
To Location          The location requisitioning items.          AP20.1  AP20.2
                     This location can be an inventory or        AP20.3  AP20.4
                     noninventory location.                      AP20.5  AP20.7
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  API1.1
                                                                 MA41.2  MA43.2
                                                                 MA61.1  MA66.2
                                                                 PO100   PO23.1
                                                                 PO25.2  PO25.4
                                                                 PO25.8  PO27.1
                                                                 PO300

PRK-ACCT-UNIT        Alpha 15                                    AP125   AP126
Accounting Unit      The accounting unit is a shorthand          AP20.1  AP20.2
                     notation representing the variable level    AP20.3  AP20.4
                     number. When used in the General Ledger     AP20.5  AP20.7
                     Account Master file, the accounting unit    AP23.1  AP25.1
                     must be defined in the General Ledger       AP25.2  AP26.1
                     Names file as a posting accounting unit.    AP27.1  API1.1
                                                                 MA41.2  MA43.2
                                                                 MA61.1  MA66.2
                                                                 PO100   PO23.1
                                                                 PO25.2  PO25.4
                                                                 PO25.8  PO27.1
                                                                 PO300

                         POAGMTPART FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PRKSET1   PROCURE-GROUP                                          AP125   AP126
          VEN-AGRMT-REF                                          AP20.1  AP20.2
          COMPANY                                                AP20.3  AP20.4
          LOCATION                                               AP20.5  AP20.7
          REQ-LOCATION                                           AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  API1.1
                                                                 MA41.2  MA43.2
                                                                 MA61.1  MA66.2
                                                                 PO100   PO101
                                                                 PO150   PO20.1
                                                                 PO21.2  PO21.4
                                                                 PO21.5  PO227
                                                                 PO23.1  PO25.1
                                                                 PO25.2  PO25.4
                                                                 ...

PRKSET2   PROCURE-GROUP This key was added to allow alternate    PO101   PO25.2
          VEN-AGRMT-REF file access for correcting DBAPIERROR    PO300
          COMPANY       problems.
          REQ-LOCATION  KeyChange
          LOCATION