Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

POHDRPVT


                             POHDRPVT FILE

REFERENCED BY

PO223     PO254     PO54.1    PO54.2    PO54.3    PO54.4

UPDATED BY

AP125     AP126     AP131     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    IC28.1    MA180     MA530
MA531     MA60.2    MA60.3    MA60.5    MA61.1    MA66.2
MA66.3    MA67.1    MA67.2    MA70.1    MA75.1    MA80.1
MAI1.1    OE10.1    OE10.2    OE10.3    OE10.4    OE10.5
OE10.6    OE10.7    OE10.8    OE11.1    OE11.4    OE11.8
OE11.9    OE110     OE111     OE113     OE114     OE116
OE129     OE13.2    OE13.3    OE13.5    OE13.6    OE14.4
OE30.1    OE30.2    OE30.3    OE30.4    OE30.5    OE30.6
OE30.7    OE30.9    OE510     OE530     OE81.1    OE810
OE830     OE90.1    OE90.2    PO100     PO101     PO122
PO131     PO136     PO190     PO20.1    PO21.1    PO21.2
PO21.3    PO21.4    PO21.5    PO22.1    PO23.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
PO33.1    PO34.1    PO35.1    PO36.1    PO36.2    PO38.1
PO39.1    PO39.2    PO44.1    PO50.1    PO52.1    PO520
PO536     PO700     POI3.1    POI7.1    POIE.1    POII.1
POIJ.1    POIT.1    RQ10.1    RQ10.2    WH20.2    WH20.7

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

PHP-COMPANY            Numeric 4                                 AP125   AP126
Element: Company       Identifies the AP company if the          AP131   AP25.1
                       resource type = V.  Identifies the HR     AP25.2  AP26.1
                       company if the resource type = E.  It is  AP27.1  AP30.4
                       blank for type A, P or Q resources.       API1.1  BL120
                                                                 BL122   BL130
                                                                 BL20.1  BL20.3
                                                                 BL21.2  BL21.5
                                                                 BL29.1  BL29.2
                                                                 BL520   BL820
                                                                 BL92.1  IC28.1
                                                                 MA180   MA530
                                                                 MA531   MA60.2
                                                                 MA60.3  MA60.5
                                                                 MA61.1  MA66.2
                                                                 MA66.3  MA67.1
                                                                 MA67.2  MA70.1
                                                                 MA75.1  MA80.1
                                                                 MAI1.1  OE10.1
                                                                 OE10.2  OE10.3
                                                                 OE10.4  OE10.5
                                                                 OE10.6  OE10.7
                                                                 OE10.8  OE11.1
                                                                 OE11.4  OE11.8
                                                                 OE11.9  OE110
                                                                 OE111   OE113
                                                                 OE114   OE116
                                                                 OE129   OE13.2
                                                                 OE13.3  OE13.5
                                                                 OE13.6  OE14.4
                                                                 ...

PHP-PO-NUMBER          Alpha 14  (Right Justified)               AP125   AP126
Element: PO Number     This field contains the number            AP131   AP25.1
                       representing the purchase order.          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  IC28.1
                                                                 MA180   MA530
                                                                 MA531   MA60.2
                                                                 MA60.3  MA60.5
                                                                 MA61.1  MA66.2
                                                                 MA66.3  MA67.1
                                                                 MA67.2  MA70.1
                                                                 MA75.1  MA80.1
                                                                 MAI1.1  OE10.1
                                                                 OE10.2  OE10.3
                                                                 OE10.4  OE10.5
                                                                 OE10.6  OE10.7
                                                                 OE10.8  OE11.1
                                                                 OE11.4  OE11.8
                                                                 OE11.9  OE110
                                                                 OE111   OE113
                                                                 OE114   OE116
                                                                 OE129   OE13.2
                                                                 OE13.3  OE13.5
                                                                 OE13.6  OE14.4
                                                                 ...

PHP-PO-RELEASE         Numeric 4                                 AP125   AP126
Element: PO Release NumUsed to identify a purchase order         AP131   AP25.1
                       release (created from a Blanket or        AP25.2  AP26.1
                       Standing order).                          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  IC28.1
                                                                 MA180   MA530
                                                                 MA531   MA60.2
                                                                 MA60.3  MA60.5
                                                                 MA61.1  MA66.2
                                                                 MA66.3  MA67.1
                                                                 MA67.2  MA70.1
                                                                 MA75.1  MA80.1
                                                                 MAI1.1  OE10.1
                                                                 OE10.2  OE10.3
                                                                 OE10.4  OE10.5
                                                                 OE10.6  OE10.7
                                                                 OE10.8  OE11.1
                                                                 OE11.4  OE11.8
                                                                 OE11.9  OE110
                                                                 OE111   OE113
                                                                 OE114   OE116
                                                                 OE129   OE13.2
                                                                 OE13.3  OE13.5
                                                                 OE13.6  OE14.4
                                                                 ...

PHP-PO-CODE            Alpha 4                                   AP125   AP126
Element: Po Code       This is the purchase order code.          AP131   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  IC28.1
                                                                 MA180   MA530
                                                                 MA531   MA60.2
                                                                 MA60.3  MA60.5
                                                                 MA61.1  MA66.2
                                                                 MA66.3  MA67.1
                                                                 MA67.2  MA70.1
                                                                 MA75.1  MA80.1
                                                                 MAI1.1  OE10.1
                                                                 OE10.2  OE10.3
                                                                 OE10.4  OE10.5
                                                                 OE10.6  OE10.7
                                                                 OE10.8  OE11.1
                                                                 OE11.4  OE11.8
                                                                 OE11.9  OE110
                                                                 OE111   OE113
                                                                 OE114   OE116
                                                                 OE129   OE13.2
                                                                 OE13.3  OE13.5
                                                                 OE13.6  OE14.4
                                                                 ...

PHP-VENDOR             Alpha 9  (Right Justified)                AP125   AP126
Element: Vendor ID     The vendor's identification code.         AP131   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  IC28.1
                                                                 MA180   MA530
                                                                 MA531   MA60.2
                                                                 MA60.3  MA60.5
                                                                 MA61.1  MA66.2
                                                                 MA66.3  MA67.1
                                                                 MA67.2  MA70.1
                                                                 MA75.1  MA80.1
                                                                 MAI1.1  OE10.1
                                                                 OE10.2  OE10.3
                                                                 OE10.4  OE10.5
                                                                 OE10.6  OE10.7
                                                                 OE10.8  OE11.1
                                                                 OE11.4  OE11.8
                                                                 OE11.9  OE110
                                                                 OE111   OE113
                                                                 OE114   OE116
                                                                 OE129   OE13.2
                                                                 OE13.3  OE13.5
                                                                 OE13.6  OE14.4
                                                                 ...

PHP-PURCH-FR-LOC       Alpha 4                                   AP125   AP126
Purchase From          The vendor's purchase from location.      AP131   AP25.1
Location Code                                                    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  IC28.1
                                                                 MA180   MA530
                                                                 MA531   MA60.2
                                                                 MA60.3  MA60.5
                                                                 MA61.1  MA66.2
                                                                 MA66.3  MA67.1
                                                                 MA67.2  MA70.1
                                                                 MA75.1  MA80.1
                                                                 MAI1.1  OE10.1
                                                                 OE10.2  OE10.3
                                                                 OE10.4  OE10.5
                                                                 OE10.6  OE10.7
                                                                 OE10.8  OE11.1
                                                                 OE11.4  OE11.8
                                                                 OE11.9  OE110
                                                                 OE111   OE113
                                                                 OE114   OE116
                                                                 OE129   OE13.2
                                                                 OE13.3  OE13.5
                                                                 OE13.6  OE14.4
                                                                 ...

PHP-BUYER-CODE         Alpha 3                                   AP125   AP126
Element: Buyer         The user defined buyer identifier.        AP131   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  IC28.1
                                                                 MA180   MA530
                                                                 MA531   MA60.2
                                                                 MA60.3  MA60.5
                                                                 MA61.1  MA66.2
                                                                 MA66.3  MA67.1
                                                                 MA67.2  MA70.1
                                                                 MA75.1  MA80.1
                                                                 MAI1.1  OE10.1
                                                                 OE10.2  OE10.3
                                                                 OE10.4  OE10.5
                                                                 OE10.6  OE10.7
                                                                 OE10.8  OE11.1
                                                                 OE11.4  OE11.8
                                                                 OE11.9  OE110
                                                                 OE111   OE113
                                                                 OE114   OE116
                                                                 OE129   OE13.2
                                                                 OE13.3  OE13.5
                                                                 OE13.6  OE14.4
                                                                 ...

PHP-PO-DATE            Numeric 8  (yyyymmdd)                     AP125   AP126
Element: Date                                                    AP131   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  IC28.1
                                                                 MA180   MA530
                                                                 MA531   MA60.2
                                                                 MA60.3  MA60.5
                                                                 MA61.1  MA66.2
                                                                 MA66.3  MA67.1
                                                                 MA67.2  MA70.1
                                                                 MA75.1  MA80.1
                                                                 MAI1.1  OE10.1
                                                                 OE10.2  OE10.3
                                                                 OE10.4  OE10.5
                                                                 OE10.6  OE10.7
                                                                 OE10.8  OE11.1
                                                                 OE11.4  OE11.8
                                                                 OE11.9  OE110
                                                                 OE111   OE113
                                                                 OE114   OE116
                                                                 OE129   OE13.2
                                                                 OE13.3  OE13.5
                                                                 OE13.6  OE14.4
                                                                 ...

PHP-STATUS             Numeric 1                                 AP125   AP126
Element: Status        This field displays the status of the     AP131   AP25.1
                       transaction. It is a conversion of flags  AP25.2  AP26.1
                       (released, closed ...)                    AP27.1  AP30.4
                       1 = Unreleased                            API1.1  BL120
                       2 = Released                              BL122   BL130
                       3 = Issued                                BL20.1  BL20.3
                       7 = Closed                                BL21.2  BL21.5
                       9 = Cancelled                             BL29.1  BL29.2
                                                                 BL520   BL820
                                                                 BL92.1  IC28.1
                                                                 MA180   MA530
                                                                 MA531   MA60.2
                                                                 MA60.3  MA60.5
                                                                 MA61.1  MA66.2
                                                                 MA66.3  MA67.1
                                                                 MA67.2  MA70.1
                                                                 MA75.1  MA80.1
                                                                 MAI1.1  OE10.1
                                                                 OE10.2  OE10.3
                                                                 OE10.4  OE10.5
                                                                 OE10.6  OE10.7
                                                                 OE10.8  OE11.1
                                                                 OE11.4  OE11.8
                                                                 OE11.9  OE110
                                                                 OE111   OE113
                                                                 OE114   OE116
                                                                 OE129   OE13.2
                                                                 OE13.3  OE13.5
                                                                 OE13.6  OE14.4
                                                                 ...

PHP-TOT-ORDER-AMT      Signed 18.2                               AP125   AP126
Element: Intl Amt                                                AP131   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  IC28.1
                                                                 MA180   MA530
                                                                 MA531   MA60.2
                                                                 MA60.3  MA60.5
                                                                 MA61.1  MA66.2
                                                                 MA66.3  MA67.1
                                                                 MA67.2  MA70.1
                                                                 MA75.1  MA80.1
                                                                 MAI1.1  OE10.1
                                                                 OE10.2  OE10.3
                                                                 OE10.4  OE10.5
                                                                 OE10.6  OE10.7
                                                                 OE10.8  OE11.1
                                                                 OE11.4  OE11.8
                                                                 OE11.9  OE110
                                                                 OE111   OE113
                                                                 OE114   OE116
                                                                 OE129   OE13.2
                                                                 OE13.3  OE13.5
                                                                 OE13.6  OE14.4
                                                                 ...

PHP-NBR-LINES          Numeric 6                                 AP125   AP126
Element: Number of LineThis is the number of detail lines.       AP131   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  IC28.1
                                                                 MA180   MA530
                                                                 MA531   MA60.2
                                                                 MA60.3  MA60.5
                                                                 MA61.1  MA66.2
                                                                 MA66.3  MA67.1
                                                                 MA67.2  MA70.1
                                                                 MA75.1  MA80.1
                                                                 MAI1.1  OE10.1
                                                                 OE10.2  OE10.3
                                                                 OE10.4  OE10.5
                                                                 OE10.6  OE10.7
                                                                 OE10.8  OE11.1
                                                                 OE11.4  OE11.8
                                                                 OE11.9  OE110
                                                                 OE111   OE113
                                                                 OE114   OE116
                                                                 OE129   OE13.2
                                                                 OE13.3  OE13.5
                                                                 OE13.6  OE14.4
                                                                 ...

                         POHDRPVT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PHPSET1   COMPANY                                                AP125   AP126
          PO-CODE                                                AP131   AP25.1
          PO-NUMBER                                              AP25.2  AP26.1
          PO-RELEASE                                             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  IC28.1
                                                                 MA180   MA530
                                                                 MA531   MA60.2
                                                                 MA60.3  MA60.5
                                                                 MA61.1  MA66.2
                                                                 ...

PHPSET2   COMPANY       KeyChange                                AP125   AP126
          STATUS                                                 AP131   AP25.1
          VENDOR                                                 AP25.2  AP26.1
          PURCH-FR-LOC                                           AP27.1  AP30.4
          PO-DATE*                                               BL120   BL122
          PO-CODE                                                BL130   BL20.1
          PO-NUMBER                                              BL20.3  BL21.2
          PO-RELEASE                                             BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 IC28.1  MA180
                                                                 MA530   MA531
                                                                 MA60.2  MA60.3
                                                                 MA60.5  MA61.1
                                                                 MA66.2  MA66.3
                                                                 ...

PHPSET3   COMPANY       KeyChange                                AP125   AP126
          STATUS                                                 AP131   AP25.1
          BUYER-CODE                                             AP25.2  AP26.1
          PO-DATE*                                               AP27.1  AP30.4
          PO-CODE                                                BL120   BL122
          PO-NUMBER                                              BL130   BL20.1
          PO-RELEASE                                             BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 IC28.1  MA180
                                                                 MA530   MA531
                                                                 MA60.2  MA60.3
                                                                 MA60.5  MA61.1
                                                                 MA66.2  MA66.3
                                                                 ...

PHPSET4   COMPANY       KeyChange                                AP125   AP126
          STATUS                                                 AP131   AP25.1
          PO-CODE                                                AP25.2  AP26.1
          PO-DATE*                                               AP27.1  AP30.4
          PO-NUMBER                                              BL120   BL122
          PO-RELEASE                                             BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 IC28.1  MA180
                                                                 MA530   MA531
                                                                 MA60.2  MA60.3
                                                                 MA60.5  MA61.1
                                                                 MA66.2  MA66.3
                                                                 ...

PHPSET5   COMPANY       KeyChange                                AP125   AP126
          STATUS                                                 AP131   AP25.1
          PO-DATE*                                               AP25.2  AP26.1
          PO-CODE                                                AP27.1  AP30.4
          PO-NUMBER                                              BL120   BL122
          PO-RELEASE                                             BL130   BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 IC28.1  MA180
                                                                 MA530   MA531
                                                                 MA60.2  MA60.3
                                                                 MA60.5  MA61.1
                                                                 MA66.2  MA66.3
                                                                 ...