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
AM19.1 AM19.2 AP115 AP125 AP126 AP131
AP20.1 AP20.2 AP20.3 AP20.4 AP20.5 AP20.7
AP21.1 AP220 AP23.1 AP25.1 AP25.2 AP26.1
AP27.1 AP30.2 AP30.4 AP305 AP510 API1.1
API2.1 CX100 CX20.1 CX20.2 CX20.4 CX20.5
CX220 CX30.1 CX300 CX506 CXCP.1 DR100
IC12.1 IC130 IC140 IC141 IC142 IC145
IC243 IC330 IC64.1 IC64.2 IC64.3 IC64.4
IC64.5 IC64.6 IC64.7 IC64.8 IC64.9 IC66.1
IC83.1 MA126 MA180 MA26.1 MA278 MA41.1
MA41.2 MA41.4 MA41.7 MA42.1 MA42.2 MA43.1
MA43.2 MA43.3 MA43.4 MA43.6 MA43.7 MA44.1
MA44.2 MA53.1 MA530 MA531 MA60.2 MA60.3
MA60.5 MA61.1 MA63.1 MA65.1 MA66.2 MA67.2
MA67.3 MA68.2 MA68.3 MA68.5 MA69.1 MA70.1
MA75.1 MA80.1 MAI1.1 PD10.1 PD10.2 PD130
PD20.1 PD20.2 PD20.3 PD570 PO04.1 PO04.2
PO10.1 PO10.2 PO100 PO101 PO115 PO120
PO122 PO131 PO132 PO135 PO136 PO15.1
PO15.2 PO15.4 PO150 PO17.1 PO18.1 PO190
PO191 PO20.1 PO20.6 PO20.9 PO204 PO21.1
PO21.2 PO21.3 PO21.4 PO21.5 PO22.1 PO22.3
PO22.4 PO220 PO222 PO224 PO225 PO229
PO23.1 PO230 PO234 PO24.1 PO25.1 PO25.5
PO25.6 PO25.7 PO251 PO26.1 PO26.3 PO26.7
PO26.9 PO27.2 PO27.3 PO27.4 PO275 PO276
PO277 PO28.2 PO280 PO29.1 PO30.1 PO30.2
PO30.3 PO30.4 PO300 PO31.1 PO31.2 PO32.1
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 PO54.5 POCP.1 POD0.1
POI3.1 POI7.1 POID.1 POII.1 POIJ.1 RQ01.1
RQ10.1 RQ10.2 RQ10.3 RQ10.4 RQ10.5 RQ11.1
RQ11.3 RQ11.4 RQ11.5 RQ12.1 RQ13.1 RQ13.2
RQ35.1 RQ44.1 RQ500 RQ810 RQIB.1 RQIF.1
RQII.1 RQIJ.1 WH130 WH132 WH190 WH20.2
WH20.7 WH222 WH30.1 WH30.2 WH30.3 WH30.4
WH31.1 WH31.2 WH31.3 WH31.4 WH32.1 WH32.2
WH32.3 WH32.4 WH32.5 WH33.1 WH33.2 WH33.3
WH33.4 WH33.5 WH33.6 WH33.8 WH33.9 WH34.1
WH34.2 WH34.3 WH34.4 WH40.1 WH40.2 WH520
WH830 PO66.2

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
DS = PO Distribution
...
AM19.1 AM19.2
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC130
IC140 IC141
IC142 IC145
IC243 IC330
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC66.1
IC83.1 MA126
MA180 MA26.1
MA278 MA41.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
P = Approve
E = Reject
U = Unrelease
...
AM19.1 AM19.2
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC130
IC140 IC141
IC142 IC145
IC243 IC330
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC66.1
IC83.1 MA126
MA180 MA26.1
MA278 MA41.1
PAU-COMPANY
Element: Company
Numeric 4
The company number.
...
AM19.1 AM19.2
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC130
IC140 IC141
IC142 IC145
IC243 IC330
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC66.1
IC83.1 MA126
MA180 MA26.1
MA278 MA41.1
PAU-PO-NUMBER
Element: Po Number
Alpha 14 (Right Justified)
This field contains the number representing the purchase order.
...
AM19.1 AM19.2
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC130
IC140 IC141
IC142 IC145
IC243 IC330
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC66.1
IC83.1 MA126
MA180 MA26.1
MA278 MA41.1
PAU-PO-RELEASE
Element: Po Release
Numeric 4
Used to identify a purchase order release (created from a Blanket or Standing order).
...
AM19.1 AM19.2
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC130
IC140 IC141
IC142 IC145
IC243 IC330
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC66.1
IC83.1 MA126
MA180 MA26.1
MA278 MA41.1
PAU-PO-CODE
Element: Po Code
Alpha 4
This is the purchase order code.
...
AM19.1 AM19.2
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC130
IC140 IC141
IC142 IC145
IC243 IC330
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC66.1
IC83.1 MA126
MA180 MA26.1
MA278 MA41.1
PAU-PO-LINE-NBR
Element: Line Nbr
Numeric 6
The purchase order line number this record is associated with.
...
AM19.1 AM19.2
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC130
IC140 IC141
IC142 IC145
IC243 IC330
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC66.1
IC83.1 MA126
MA180 MA26.1
MA278 MA41.1
PAU-FLD-NBR
Element: Fld Nbr
Numeric 4
This field contains the purchase order dictionary field number.
...
AM19.1 AM19.2
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC130
IC140 IC141
IC142 IC145
IC243 IC330
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC66.1
IC83.1 MA126
MA180 MA26.1
MA278 MA41.1
PAU-AOC-CODE
Element: Aoc Code
Alpha 2
This field contains the identifier for the add-on cost associated with this line item.
...
AM19.1 AM19.2
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC130
IC140 IC141
IC142 IC145
IC243 IC330
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC66.1
IC83.1 MA126
MA180 MA26.1
MA278 MA41.1
PAU-UPDATE-DATE
Element: Update Date
Numeric 8 (yyyymmdd)
This field contains the date the record was updated.
...
AM19.1 AM19.2
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC130
IC140 IC141
IC142 IC145
IC243 IC330
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC66.1
IC83.1 MA126
MA180 MA26.1
MA278 MA41.1
PAU-UPDATE-TIME
Element: Update Time
Numeric 6
This field contains the system time when the record was updated.
...
AM19.1 AM19.2
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC130
IC140 IC141
IC142 IC145
IC243 IC330
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC66.1
IC83.1 MA126
MA180 MA26.1
MA278 MA41.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.
...
AM19.1 AM19.2
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC130
IC140 IC141
IC142 IC145
IC243 IC330
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC66.1
IC83.1 MA126
MA180 MA26.1
MA278 MA41.1
PAU-BEFORE-IMAGE
Element: Field Value
Alpha 60
This field contains the field image before the change.
...
AM19.1 AM19.2
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC130
IC140 IC141
IC142 IC145
IC243 IC330
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC66.1
IC83.1 MA126
MA180 MA26.1
MA278 MA41.1
PAU-AFTER-IMAGE
Element: Field Value
Alpha 60
This field contains the field image before the change.
...
AM19.1 AM19.2
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC130
IC140 IC141
IC142 IC145
IC243 IC330
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC66.1
IC83.1 MA126
MA180 MA26.1
MA278 MA41.1
PAU-USER-ID
Element: User
Alpha 10 (Lower Case)
Contains the user ID of the person who revised the purchase order.
...
AM19.1 AM19.2
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC130
IC140 IC141
IC142 IC145
IC243 IC330
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC66.1
IC83.1 MA126
MA180 MA26.1
MA278 MA41.1
PAU-PRINT-REV
Element: Print Heading
Alpha 1

Y = Yes
N = No
...
AM19.1 AM19.2
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC130
IC140 IC141
IC142 IC145
IC243 IC330
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC66.1
IC83.1 MA126
MA180 MA26.1
MA278 MA41.1
PAU-DESC
Element: Description
Alpha 30 (Lower Case)
The description of the field that has changed.
...
AM19.1 AM19.2
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC130
IC140 IC141
IC142 IC145
IC243 IC330
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC66.1
IC83.1 MA126
MA180 MA26.1
MA278 MA41.1
PAU-LINE-SEQ
Element: Seq
Numeric 3
...
AM19.1 AM19.2
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC12.1 IC130
IC140 IC141
IC142 IC145
IC243 IC330
IC64.1 IC64.2
IC64.3 IC64.4
IC64.5 IC64.6
IC64.7 IC64.8
IC64.9 IC66.1
IC83.1 MA126
MA180 MA26.1
MA278 MA41.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
LINE-SEQ
FLD-NBR
UPDATE-DATE
UPDATE-TIME
...
AM19.1 AM19.2
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
PAUSET2 COMPANY
PO-NUMBER
PO-RELEASE
PO-CODE
PO-REVISION*
UPDATE-DATE*
UPDATE-TIME*
PO-LINE-NBR
AOC-CODE
LINE-SEQ
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
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
PAUSET3 COMPANY
PO-NUMBER
PO-RELEASE
PO-CODE
PO-LINE-NBR
PO-REVISION*
AOC-CODE
LINE-SEQ
UPDATE-DATE*
UPDATE-TIME*
FLD-NBR
AUDIT-TYPE
AUDIT-ACTION
KeyChange
...
AM19.1 AM19.2
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
PAUSET4 COMPANY
PO-NUMBER
PO-RELEASE
PO-CODE
PO-LINE-NBR
AOC-CODE
LINE-SEQ
PO-REVISION*
UPDATE-DATE*
UPDATE-TIME*
FLD-NBR
AUDIT-TYPE
AUDIT-ACTION
KeyChange
...
AM19.1 AM19.2
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5


POAUDIT FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Mmdist MMDIST Not Required
Valid When PAU-LINE-SEQ !=Zeroes
PAU-COMPANY->MMD-COMPANY
PAU-PO-NUMBER->MMD-DOC-NUMBER
PAU-PO-RELEASE->MMD-DOC-NBR-NUM
PAU-PO-CODE->MMD-PO-CODE
PAU-LINE-SEQ->MMD-LINE-NBR
PAU-AOC-CODE->MMD-AOC-CODE
PAU-LINE-SEQ->MMD-LINE-SEQ
Poline POLINE Required
When PAU-PO-LINE-NBR !=Zeroes
AndPAU-LINE-SEQ =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
AndPAU-LINE-SEQ =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: Thu Jun 09 02:26:41 2016

Home
Contact Us



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