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
|
