POREVISION

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
AM19.1 AM19.2 AP115 AP220 AP305 IC130
MA126 MA26.1 MA63.1 MA65.1 MA69.1 PO135
PO18.1 PO64.1 PO66.1 POI7.1


UPDATED BY
POIL.1 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 AP510
API1.1 API2.1 CX100 CX20.1 CX20.2 CX20.4
CX20.5 CX220 CX30.1 CX300 CX506 CXCP.1
DR100 IC12.1 IC140 IC141 IC142 IC145
IC243 IC330 IC64.1 IC64.2 IC64.3 IC64.4
IC64.5 IC64.6 IC64.7 IC64.8 IC64.9 IC66.1
IC83.1 MA180 MA278 MA41.1 MA41.2 MA41.4
MA41.7 MA42.2 MA43.2 MA43.7 MA44.1 MA44.2
MA53.1 MA530 MA531 MA60.2 MA60.3 MA60.5
MA61.1 MA66.2 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 PD570
PO04.1 PO04.2 PO10.1 PO10.2 PO100 PO101
PO115 PO120 PO122 PO131 PO132 PO136
PO15.1 PO15.2 PO15.4 PO150 PO17.1 PO190
PO20.1 PO20.6 PO20.9 PO204 PO21.1 PO21.2
PO21.3 PO21.4 PO21.5 PO22.1 PO22.3 PO22.4
PO220 PO222 PO224 PO225 PO229 PO23.1
PO230 PO234 PO24.1 PO25.1 PO25.5 PO25.6
PO25.7 PO251 PO26.3 PO26.7 PO26.9 PO27.2
PO27.3 PO27.4 PO275 PO276 PO277 PO28.2
PO280 PO29.1 PO30.1 PO30.2 PO30.3 PO30.4
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
PO54.5 POCP.1 POI3.1 POID.1 POII.1 POIJ.1
RQ01.1 RQ10.1 RQ10.2 RQ10.3 RQ10.4 RQ10.5
RQ11.1 RQ12.1 RQ13.1 RQ13.2 RQ35.1 RQ44.1
RQ500 RQ810 RQIB.1 RQIF.1 RQII.1 RQIJ.1
WH130 WH132 WH190 WH20.2 WH20.7 WH222
WH30.1 WH30.2 WH30.3 WH30.4 WH31.1 WH31.2
WH31.3 WH31.4 WH32.1 WH32.2 WH32.3 WH32.4
WH32.5 WH33.1 WH33.2 WH33.3 WH33.4 WH33.5
WH33.6 WH33.8 WH33.9 WH34.1 WH34.2 WH34.3
WH34.4 WH40.1 WH40.2 WH520 WH830

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PVS-COMPANY
Element: Company
Numeric 4
Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources.
POIL.1
PVS-PO-NUMBER
Element: Po Number
Alpha 14 (Right Justified)
This field contains the number representing the purchase order.
POIL.1
PVS-PO-RELEASE
Element: Po Release
Numeric 4
Used to identify a purchase order release (created from a Blanket or Standing order).
POIL.1
PVS-PO-CODE
Element: Po Code
Alpha 4
This is the purchase order code.
POIL.1
PVS-PO-REVISION
Element: Po Revision
Numeric 3
The PO Revision number. Assigned sequentially by the system when the PO is revised.
POIL.1
PVS-ISSUE-METH
Element: Issue Meth
Alpha 1
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
POIL.1
PVS-ISSUE-DATE
Element: Issue Date
Numeric 8 (yyyymmdd)
The date the purchase order revision was issued to the vendor.
POIL.1
PVS-ISSUE-TIME
Element: Sys Time
Numeric 6 (hhmmss)
POIL.1
PVS-XMIT-STATUS
Element: Xmit Status
Numeric 1
Indicates the status of a transmission (for example, a Fax transmission of a Purchase Order).
0 = Unknown
1 = Successful
2 = Failed
POIL.1
PVS-XMIT-DATE
Element: Date
Numeric 8 (yyyymmdd)
This field displays the system date when this was created.
POIL.1
PVS-XMIT-TIME
Element: Sys Time
Numeric 6 (hhmmss)
POIL.1
PVS-XMIT-TRIES
Element: Xmit Tries
Numeric 3
Indicates the number of times a transmission was attempted.
POIL.1
PVS-ACK-TYPE
Element: Ack Type
Alpha 2
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
ZZ = Mutually Defined
POIL.1
PVS-ACK-DATE
Element: Ack Date
Numeric 8 (yyyymmdd)
The date the vendor acknowledgment for the purchase order was sent back.
POIL.1


POREVISION FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PVSSET1 COMPANY
PO-NUMBER
PO-RELEASE
PO-CODE
PO-REVISION
...
AM19.1 AM19.2
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5


POREVISION FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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
NAME
RELATED 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-LINE-SEQ
  PAU-FLD-NBR
  PAU-AUDIT-TYPE
  PAU-AUDIT-ACTION


File created: Thu Jun 09 02:27:45 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.