POAUDIT FILE
Audit Records
This file contains a record of all changes to a Purchase Order that affect
the printed purchase order. These records can optionally be printed on the
Purchase Order document.
REFERENCED BY
PO66.1 PO224
UPDATED BY
POI7.1 POIJ.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PAU-AUDIT-TYPE Alpha 2 POI7.1 POIJ.1
Audit Type The type of source record that is being
audited.
HD = PO Header
HA = Spread AOC
LN = PO Line
LA = Misc/Line AOC
PAU-AUDIT-ACTION Alpha 1 POI7.1 POIJ.1
Audit Action The action (add, change, etc.) that is
being audited.
A = Add
C = Change
L = Cancel
B = B/O Cancel
PAU-COMPANY Numeric 4 POI7.1 POIJ.1
Company The company number.
PAU-PO-NUMBER Alpha 14 (Right Justified) POI7.1 POIJ.1
PO Number This field contains the number
representing the purchase order.
PAU-PO-RELEASE Numeric 4 POI7.1 POIJ.1
PO Release Number Used to identify a purchase order
release (created from a Blanket or
Standing order).
PAU-PO-CODE Alpha 4 POI7.1 POIJ.1
Po Code This is the purchase order code.
PAU-PO-LINE-NBR Numeric 6 POI7.1 POIJ.1
PO Line Number The purchase order line number this
record is associated with.
PAU-FLD-NBR Numeric 4 POI7.1 POIJ.1
Dictionary Field This field contains the purchase order
Number dictionary field number.
PAU-AOC-CODE Alpha 2 POI7.1 POIJ.1
Add On Cost Code This field contains the identifier for
the add-on cost associated with this
line item.
PAU-UPDATE-DATE Numeric 8 (yyyymmdd) POI7.1 POIJ.1
Update Date This field contains the date the record
was updated.
PAU-UPDATE-TIME Numeric 6 POI7.1 POIJ.1
Update Time This field contains the system time
when the record was updated.
PAU-PO-REVISION Numeric 3 POI7.1 POIJ.1
PO Revision Number The purchase order revision number.
Assigned sequentially by the system when
the purchase order is revised.
PAU-BEFORE-IMAGE Alpha 32 POI7.1 POIJ.1
Before Change Image This field contains the field image
before the change.
PAU-AFTER-IMAGE Alpha 32 POI7.1 POIJ.1
After Change Image This field contains the field image
after the change.
PAU-USER-ID Alpha 10 (Lower Case) POI7.1 POIJ.1
User ID Name Contains the user ID of the person who
revised the purchase order.
PAU-PRINT-REV Alpha 1 POI7.1 POIJ.1
Print Rev Indicates whether to print a revision
message on the purchase order for the
audited action.
Y = Yes
N = No
PAU-DESC Alpha 30 (Lower Case) POI7.1 POIJ.1
Description The description of the field that has
changed.
POAUDIT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PAUSET1 AUDIT-TYPE This is the primary index for the PO66.1 POI7.1
AUDIT-ACTION POAUDIT file. The keys include all of POIJ.1
COMPANY the keys for audited PO source records
PO-NUMBER (PO header, line, add on cost code,
PO-RELEASE etc.), as well as the type of source
PO-CODE record the audit is created for, the
PO-REVISION action that is being audited, and the
PO-LINE-NBR date and time of the audit. Uniqueness
AOC-CODE is guaranteed for multiple changes to
FLD-NBR the same field by the date and time
UPDATE-DATE stamps.
UPDATE-TIME
PAUSET2 COMPANY This index allows access to audit PO224 PO66.1
PO-NUMBER records by descending date/time. It is POIJ.1
PO-RELEASE used to display, report and drill around
PO-CODE on audits from a purchase order.
PO-REVISION* KeyChange
UPDATE-DATE*
UPDATE-TIME*
PO-LINE-NBR
AOC-CODE
FLD-NBR
AUDIT-TYPE
AUDIT-ACTION
PAUSET3 COMPANY This index provides access to all audit POI7.1 POIJ.1
PO-NUMBER records relating to a POLINE by
PO-RELEASE descending date and time.
PO-CODE KeyChange
PO-LINE-NBR
PO-REVISION*
AOC-CODE
UPDATE-DATE*
UPDATE-TIME*
FLD-NBR
AUDIT-TYPE
AUDIT-ACTION
PAUSET4 COMPANY This index supports access to all audit POIJ.1
PO-NUMBER records for a POAOCDTL.
PO-RELEASE KeyChange
PO-CODE
PO-LINE-NBR
AOC-CODE
PO-REVISION*
UPDATE-DATE*
UPDATE-TIME*
FLD-NBR
AUDIT-TYPE
AUDIT-ACTION
POAUDIT FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Poline POLINE Required
When PAU-PO-LINE-NBR != Zeroes
PAU-COMPANY -> PLI-COMPANY
PAU-PO-NUMBER -> PLI-PO-NUMBER
PAU-PO-RELEASE -> PLI-PO-RELEASE
PAU-PO-CODE -> PLI-PO-CODE
PAU-PO-LINE-NBR -> PLI-LINE-NBR
Porevision POREVISION Required
PAU-COMPANY -> PVS-COMPANY
PAU-PO-NUMBER -> PVS-PO-NUMBER
PAU-PO-RELEASE -> PVS-PO-RELEASE
PAU-PO-CODE -> PVS-PO-CODE
PAU-PO-REVISION -> PVS-PO-REVISION
Purchorder PURCHORDER Required
When PAU-PO-LINE-NBR = Zeroes
PAU-COMPANY -> PCR-COMPANY
PAU-PO-CODE -> PCR-PO-CODE
PAU-PO-NUMBER -> PCR-PO-NUMBER
PAU-PO-RELEASE -> PCR-PO-RELEASE
|
