|
|
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
PO220 PO224 PO54.4 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 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
PO20.1 PO21.1 PO21.2 PO21.3 PO21.4 PO21.5
PO22.1 PO23.1 PO24.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 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
PVS-COMPANY Numeric 4 POIL.1
Element: Company 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.
PVS-PO-NUMBER Alpha 14 (Right Justified) POIL.1
Element: Po Number This field contains the number
representing the purchase order.
PVS-PO-RELEASE Numeric 4 POIL.1
Element: Po Release Used to identify a purchase order
release (created from a Blanket or
Standing order).
PVS-PO-CODE Alpha 4 POIL.1
Element: Po Code This is the purchase order code.
PVS-PO-REVISION Numeric 3 POIL.1
Element: Po Revision The PO Revision number. Assigned
sequentially by the system when the PO
is revised.
PVS-ISSUE-METH Alpha 1 POIL.1
Element: 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
Element: Issue Date The date the purchase order revision
was issued to the vendor.
PVS-ISSUE-TIME Numeric 6 (hhmmss) POIL.1
Element: Sys Time
PVS-XMIT-STATUS Numeric 1 POIL.1
Element: 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
Element: Date This field displays the system date
when this was created.
PVS-XMIT-TIME Numeric 6 (hhmmss) POIL.1
Element: Sys Time
PVS-XMIT-TRIES Numeric 3 POIL.1
Element: Xmit Tries Indicates the number of times a
transmission was attempted.
PVS-ACK-TYPE Alpha 2 POIL.1
Element: 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
ZZ = Mutually Defined
PVS-ACK-DATE Numeric 8 (yyyymmdd) POIL.1
Element: Ack 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 AP20.1
PO-RELEASE AP20.2 AP20.3
PO-CODE AP20.4 AP20.5
PO-REVISION 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
...
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
|
