|
|
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
AP125 AP126 AP131 AP20.1 AP20.2 AP20.3
AP20.4 AP20.5 AP20.7 AP23.1 AP25.1 AP25.2
AP26.1 AP27.1 AP30.4 API1.1 IC28.1 MA180
MA41.2 MA41.7 MA43.1 MA43.2 MA43.3 MA43.9
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 PO100 PO101 PO122 PO131
PO20.1 PO21.1 PO21.2 PO21.3 PO21.4 PO21.5
PO22.1 PO23.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 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 POII.1
POIJ.1 POIL.1 RQ10.1 RQ10.2 RQ10.3 RQIE.1
WH20.2 WH20.7
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PVS-COMPANY Numeric 4 POIL.1
Element: Company The company number represents an
established company and is entered on
all function codes.
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: 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
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: 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 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
IC28.1 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
...
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
|
