POAUDIT

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.
UPDATED BY
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 API2.1
MA41.1 MA41.2 MA41.4 MA41.7 MA43.1 MA43.2
MA43.3 MA43.4 MA43.6 MA43.7 MAI1.1 PO136
PO190 PO300 PO520 POCP.1 POI3.1 POI7.1
POII.1 POIJ.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PAU-AUDIT-TYPE
Element: Audit Type		Alpha 2
The type of source record that is being audited.
HD = PO Header
HA = Spread AOC
LN = PO Line
LA = Misc/Line AOC
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 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POI7.1
POII.1 POIJ.1
PAU-AUDIT-ACTION
Element: Audit Action		Alpha 1
The action (add, change, etc.) that is being audited.
A = Add
C = Change
L = Cancel
B = B/O Cancel
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 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POI7.1
POII.1 POIJ.1
PAU-COMPANY
Element: Company		Numeric 4
The company number.
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 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POI7.1
POII.1 POIJ.1
PAU-PO-NUMBER
Element: Po Number		Alpha 14 (Right Justified)
This field contains the number representing the purchase order.
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 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POI7.1
POII.1 POIJ.1
PAU-PO-RELEASE
Element: Po Release		Numeric 4
Used to identify a purchase order release (created from a Blanket or Standing order).
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 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POI7.1
POII.1 POIJ.1
PAU-PO-CODE
Element: Po Code		Alpha 4
This is the purchase order code.
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 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POI7.1
POII.1 POIJ.1
PAU-PO-LINE-NBR
Element: Line Nbr		Numeric 6
The purchase order line number this record is associated with.
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 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POI7.1
POII.1 POIJ.1
PAU-FLD-NBR
Element: Fld Nbr		Numeric 4
This field contains the purchase order dictionary field number.
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 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POI7.1
POII.1 POIJ.1
PAU-AOC-CODE
Element: Aoc Code		Alpha 2
This field contains the identifier for the add-on cost associated with this line item.
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 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POI7.1
POII.1 POIJ.1
PAU-UPDATE-DATE
Element: Update Date		Numeric 8 (yyyymmdd)
This field contains the date the record was updated.
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 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POI7.1
POII.1 POIJ.1
PAU-UPDATE-TIME
Element: Update Time		Numeric 6
This field contains the system time when the record was updated.
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 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POI7.1
POII.1 POIJ.1
PAU-PO-REVISION
Element: Po Revision		Numeric 3
The purchase order revision number. Assigned sequentially by the system when the purchase order is revised.
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 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POI7.1
POII.1 POIJ.1
PAU-BEFORE-IMAGE
Element: Field Val		Alpha 35
This field contains the field image before the change.
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 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POI7.1
POII.1 POIJ.1
PAU-AFTER-IMAGE
Element: Field Val		Alpha 35
This field contains the field image before the change.
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 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POI7.1
POII.1 POIJ.1
PAU-USER-ID
Element: User		Alpha 10 (Lower Case)
Contains the user ID of the person who revised the purchase order.
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 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POI7.1
POII.1 POIJ.1
PAU-PRINT-REV
Element: Print Heading		Alpha 1

Y = Yes
N = No
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 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POI7.1
POII.1 POIJ.1
PAU-DESC
Element: Description		Alpha 30 (Lower Case)
The description of the field that has changed.
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 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POI7.1
POII.1 POIJ.1


POAUDIT FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PAUSET1 AUDIT-TYPE
AUDIT-ACTION
COMPANY
PO-NUMBER
PO-RELEASE
PO-CODE
PO-REVISION
PO-LINE-NBR
AOC-CODE
FLD-NBR
UPDATE-DATE
UPDATE-TIME
...
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 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PAUSET2 COMPANY
PO-NUMBER
PO-RELEASE
PO-CODE
PO-REVISION*
UPDATE-DATE*
UPDATE-TIME*
PO-LINE-NBR
AOC-CODE
FLD-NBR
AUDIT-TYPE
AUDIT-ACTION
KeyChange
...
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 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PAUSET3 COMPANY
PO-NUMBER
PO-RELEASE
PO-CODE
PO-LINE-NBR
PO-REVISION*
AOC-CODE
UPDATE-DATE*
UPDATE-TIME*
FLD-NBR
AUDIT-TYPE
AUDIT-ACTION
KeyChange
...
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 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PAUSET4 COMPANY
PO-NUMBER
PO-RELEASE
PO-CODE
PO-LINE-NBR
AOC-CODE
PO-REVISION*
UPDATE-DATE*
UPDATE-TIME*
FLD-NBR
AUDIT-TYPE
AUDIT-ACTION
KeyChange
...
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 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136


POAUDIT FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED 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

File created: Wed Jun 08 20:50:44 2016

Home
Contact Us



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