|
|
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 PO25.1 PO25.5 PO25.6 PO25.7
PO27.2 PO36.1 PO36.2 PO536 PO54.4 PO64.1
PO66.1 POI7.1
UPDATED BY
AP125 AP126 AP131 AP25.1 AP25.2 AP26.1
AP27.1 AP30.4 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
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
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 NumUsed 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 NuThe 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: Issued Date The date the purchase order revision was
issued to the vendor.
PVS-ISSUE-TIME Numeric 6 (hhmmss) POIL.1
Element: Sys Time The time the purchase order revision was
issued to the vendor.
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 Indicates the date of a transmission
(for example, a Fax transmission of a
Purchase Order).
PVS-XMIT-TIME Numeric 6 (hhmmss) POIL.1
Element: Sys Time Indicates the time of a transmission
(for example, a Fax transmission of a
Purchase Order).
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: AcknowledgemenThe 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 AP30.4
PO-REVISION 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
...
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
|
