Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

POAGMTPRIC


                            POAGMTPRIC FILE

REFERENCED BY

PO229     POIH.1

UPDATED BY

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    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     PO150
PO20.1    PO21.1    PO21.2    PO21.3    PO21.4    PO21.5
PO22.1    PO23.1    PO24.1    PO25.1    PO25.2    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    RQ10.1
RQ10.2    WH20.2    WH20.7

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

PRI-PROCURE-GROUP      Alpha 4                                   AP125   AP126
Element: Procure Group This field contains the identifier for    AP131   AP20.1
                       a group of companies that share a common  AP20.2  AP20.3
                       procurement effort. They buy items and    AP20.4  AP20.5
                       services together.                        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  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
                                                                 ...

PRI-VEN-AGRMT-REF      Alpha 30                                  AP125   AP126
Element: Agreement Ref                                           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  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
                                                                 ...

PRI-EFFECTIVE-DT       Numeric 8  (yyyymmdd)                     AP125   AP126
Element: Effective Dt  The effective date is the date the        AP131   AP20.1
                       record is first valid.                    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  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
                                                                 ...

PRI-MARKUP-DISC        Alpha 1                                   AP125   AP126
Element: Markup Disc   M = Markup                                AP131   AP20.1
                       D = Discount                              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  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
                                                                 ...

PRI-BASE-PERCENT       Percent 6.3  (Percent)                    AP125   AP126
Element: Base Percent                                            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  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
                                                                 ...

PRI-BREAK-AMT-1        Numeric 13                                AP125   AP126
Element: Break Amt 1                                             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  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
                                                                 ...

PRI-BREAK-PCT-1        Percent 6.3  (Percent)                    AP125   AP126
Element: Break Pct 1                                             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  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
                                                                 ...

PRI-BREAK-AMT-2        Numeric 13                                AP125   AP126
Element: Break Amt 2                                             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  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
                                                                 ...

PRI-BREAK-PCT-2        Percent 6.3  (Percent)                    AP125   AP126
Element: Break Pct 2                                             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  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
                                                                 ...

PRI-BREAK-AMT-3        Numeric 13                                AP125   AP126
Element: Break Amt 3                                             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  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
                                                                 ...

PRI-BREAK-PCT-3        Percent 6.3  (Percent)                    AP125   AP126
Element: Break Pct 3                                             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  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
                                                                 ...

PRI-BREAK-AMT-4        Numeric 13                                AP125   AP126
Element: Break Amt 4                                             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  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
                                                                 ...

PRI-BREAK-PCT-4        Percent 6.3  (Percent)                    AP125   AP126
Element: Break Pct 4                                             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  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
                                                                 ...

PRI-BREAK-AMT-5        Numeric 13                                AP125   AP126
Element: Break Amt 5                                             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  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
                                                                 ...

PRI-BREAK-PCT-5        Percent 6.3  (Percent)                    AP125   AP126
Element: Break Pct 5                                             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  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
                                                                 ...

PRI-AMT-ORDERED        Signed 18.2                               AP125   AP126
Element: Intl Amt                                                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  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
                                                                 ...

                         POAGMTPRIC FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PRISET1   PROCURE-GROUP                                          AP125   AP126
          VEN-AGRMT-REF                                          AP131   AP20.1
          EFFECTIVE-DT*                                          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  MA180
                                                                 ...

PRISET2   PROCURE-GROUP                                          PO150   PO25.1
          VEN-AGRMT-REF                                          PO25.6  PO25.7
          EFFECTIVE-DT                                           PO300   PO36.2
                                                                 PO536