Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                            POREVISION FILE

                              PO Revision

POREVISION is a historical record of issues for a purchase order.  When a PO
is added or revised, a POREVISION is created.  When the PO is issued, the
POREVISION is updated to capture the issue method, date and time.

POREVISION also provides a place to capture the actual transmit date, time,
status and number of attempts for fax, email and EDI purchase orders, as well
as the vendor acknoweldgment type and date.

REFERENCED BY

API1.1    PO220     PO224     PO25.2    PO25.6    PO25.7
PO25.8    PO27.3    PO54.4    PO64.1    PO66.1    POI7.1

UPDATED BY

AP125     AP126     AP131     AP25.1    AP25.2    AP26.1
AP27.1    IC28.1    MA180     MA43.9    MA530     MA531
MA60.2    MA60.3    MA60.5    MA61.1    MA66.3    MA67.1
MA67.2    MA70.1    MAI1.1    PO100     PO101     PO122
PO131     PO20.1    PO21.2    PO21.3    PO21.4    PO21.5
PO22.1    PO23.1    PO29.1    PO30.1    PO30.2    PO30.3
PO300     PO31.1    PO31.2    PO32.2    PO33.1    PO34.1
PO35.1    PO38.1    PO39.1    PO39.2    PO44.1    PO50.1
PO52.1    PO520     POI3.1    POIE.1    POII.1    POIJ.1
POIL.1    RQ10.1    RQ10.2    WH20.2    WH20.7

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

PVS-COMPANY          Numeric 4                                   POIL.1
Company              The company number represents an
                     established company and is entered on
                     all function codes.


PVS-PO-NUMBER        Alpha 14  (Right Justified)                 POIL.1
PO Number            This field contains the number
                     representing the purchase order.

PVS-PO-RELEASE       Numeric 4                                   POIL.1
PO Release Number    Used to identify a purchase order
                     release (created from a Blanket or
                     Standing order).

PVS-PO-CODE          Alpha 4                                     POIL.1
Po Code              This is the purchase order code.

PVS-PO-REVISION      Numeric 3                                   POIL.1
PO Revision Number   The PO Revision number.  Assigned
                     sequentially by the system when the PO
                     is revised.

PVS-ISSUE-METH       Alpha 1                                     POIL.1
Issue Meth           Specifies the method that will be used
                     to issue the purchase order to the
                     vendor.
                     P = Paper
                     F = Fax
                     E = EDI
                     I = Internet Mail
                     D = Do Not Print

PVS-ISSUE-DATE       Numeric 8  (yyyymmdd)                       POIL.1
Issued Date          The date the purchase order revision was
                     issued to the vendor.

PVS-ISSUE-TIME       Numeric 6  (hhmmss)                         POIL.1
Issue Time           The time the purchase order revision was
                     issued to the vendor.

PVS-XMIT-STATUS      Numeric 1                                   POIL.1
Xmit Status          Indicates the status of a transmission
                     (for example, a Fax transmission of a
                     Purchase Order).
                     0 = Unknown
                     1 = Successful
                     2 = Failed

PVS-XMIT-DATE        Numeric 8  (yyyymmdd)                       POIL.1
Xmit Date            Indicates the date of a transmission
                     (for example, a Fax transmission of a
                     Purchase Order).

PVS-XMIT-TIME        Numeric 6  (hhmmss)                         POIL.1
Xmit Time            Indicates the time of a transmission
                     (for example, a Fax transmission of a
                     Purchase Order).

PVS-XMIT-TRIES       Numeric 3                                   POIL.1
Xmit Tries           Indicates the number of times a
                     transmission was attempted.

PVS-ACK-TYPE         Alpha 2                                     POIL.1
Ack Type             The type of acknowledgement that was
                     returned by the vendor.
                     AC = Ack W Detail & Change
                     AD = Ack W Detail No Change
                     AE = Ack W Exc Detail Only
                     AH = Ack - Hold Status
                     AK = Ack - No Detail or Change
                     AP = Ack - Product Replenishment
                     AT = Accepted
                     NA = No Acknowledgment Needed
                     RD = Reject with Detail
                     RF = Reject with Exc Detail Only
                     RJ = Rejected - No Detail
                     RN = Rejected - Not as Agreed
                     RO = Rejected With Counter Offer
                     RV = Rejected - Violetes Industry
                     ZZ = Mutually Defined

PVS-ACK-DATE         Numeric 8  (yyyymmdd)                       POIL.1
Acknowledgement Date The date the vendor acknowledgment for
                     the Purchase Order was sent back.

                         POREVISION FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PVSSET1   COMPANY                                                AP125   AP126
          PO-NUMBER                                              AP131   AP25.1
          PO-RELEASE                                             AP25.2  AP26.1
          PO-CODE                                                AP27.1  API1.1
          PO-REVISION                                            IC28.1  MA180
                                                                 MA43.9  MA530
                                                                 MA531   MA60.2
                                                                 MA60.3  MA60.5
                                                                 MA61.1  MA66.3
                                                                 MA67.1  MA67.2
                                                                 MA70.1  MAI1.1
                                                                 PO100   PO101
                                                                 PO122   PO131
                                                                 PO20.1  PO21.2
                                                                 PO21.3  PO21.4
                                                                 ...

                         POREVISION FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Purchorder     PURCHORDER   Required

                            PVS-COMPANY        -> PCR-COMPANY
                            PVS-PO-CODE        -> PCR-PO-CODE
                            PVS-PO-NUMBER      -> PCR-PO-NUMBER
                            PVS-PO-RELEASE     -> PCR-PO-RELEASE

                         POREVISION FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Poaudit        POAUDIT

                            PVS-COMPANY        -> PAU-COMPANY
                            PVS-PO-NUMBER      -> PAU-PO-NUMBER
                            PVS-PO-RELEASE     -> PAU-PO-RELEASE
                            PVS-PO-CODE        -> PAU-PO-CODE
                            PVS-PO-REVISION    -> PAU-PO-REVISION
                                                  PAU-UPDATE-DATE
                                                  PAU-UPDATE-TIME
                                                  PAU-PO-LINE-NBR
                                                  PAU-AOC-CODE
                                                  PAU-FLD-NBR
                                                  PAU-AUDIT-TYPE
                                                  PAU-AUDIT-ACTION