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
PO224 PO66.1 RQ20.1 RQ20.3 RQ20.4
UPDATED BY
BL92.1 IN20.1 MA300 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 OE113 OE114
OE129 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4
OE15.5 OE15.7 OE510 OE810 OE920 PO120
PO121 PO123 PO20.1 PO21.1 PO21.2 PO21.4
PO21.5 PO21.6 PO30.1 PO31.1 PO33.1 PO35.1
PO530 WH20.2 WH20.7
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PAU-COMPANY Numeric 4 BL92.1 IN20.1
Company The company number. 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 OE113
OE114 OE129
OE14.4 OE15.1
OE15.2 OE15.3
OE15.4 OE15.5
OE15.7 OE510
OE810 OE920
PO120 PO121
PO123 PO20.1
PO21.1 PO21.2
PO21.4 PO21.5
PO21.6 PO30.1
PO31.1 PO33.1
PO35.1 PO530
WH20.2 WH20.7
PAU-PO-NUMBER Alpha 7 (Right Justified) BL92.1 IN20.1
PO Number This field contains the number OE10.1 OE10.2
representing the purchase order. OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE113
OE114 OE129
OE14.4 OE15.1
OE15.2 OE15.3
OE15.4 OE15.5
OE15.7 OE510
OE810 OE920
PO120 PO121
PO123 PO20.1
PO21.1 PO21.2
PO21.4 PO21.5
PO21.6 PO30.1
PO31.1 PO33.1
PO35.1 PO530
WH20.2 WH20.7
PAU-PO-RELEASE Numeric 6 BL92.1 IN20.1
PO Release Number Used to identify a purchase order OE10.1 OE10.2
release (created from a Blanket or OE10.3 OE10.4
Standing order). OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE113
OE114 OE129
OE14.4 OE15.1
OE15.2 OE15.3
OE15.4 OE15.5
OE15.7 OE510
OE810 OE920
PO120 PO121
PO123 PO20.1
PO21.1 PO21.2
PO21.4 PO21.5
PO21.6 PO30.1
PO31.1 PO33.1
PO35.1 PO530
WH20.2 WH20.7
PAU-PO-RELEASE-3 Derived
Po Release 3 The purchase order release number
converted to a three character field for
purposes of display and printing the
shorter field.
PAU-PO-LINE-NBR Numeric 6 BL92.1 IN20.1
PO Line Number The purchase order line number this OE10.1 OE10.2
record is associated with. OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE113
OE114 OE129
OE14.4 OE15.1
OE15.2 OE15.3
OE15.4 OE15.5
OE15.7 OE510
OE810 OE920
PO120 PO121
PO123 PO20.1
PO21.1 PO21.2
PO21.4 PO21.5
PO21.6 PO30.1
PO31.1 PO33.1
PO35.1 PO530
WH20.2 WH20.7
PAU-FLD-NBR Numeric 4 BL92.1 IN20.1
Dictionary Field This field contains the purchase order OE10.1 OE10.2
Number dictionary field number. OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE113
OE114 OE129
OE14.4 OE15.1
OE15.2 OE15.3
OE15.4 OE15.5
OE15.7 OE510
OE810 OE920
PO120 PO121
PO123 PO20.1
PO21.1 PO21.2
PO21.4 PO21.5
PO21.6 PO30.1
PO31.1 PO33.1
PO35.1 PO530
WH20.2 WH20.7
PAU-AOC-CODE Alpha 2 BL92.1 IN20.1
Add On Cost Code This field contains the identifier for OE10.1 OE10.2
the add-on cost associated with this OE10.3 OE10.4
line item. OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE113
OE114 OE129
OE14.4 OE15.1
OE15.2 OE15.3
OE15.4 OE15.5
OE15.7 OE510
OE810 OE920
PO120 PO121
PO123 PO20.1
PO21.1 PO21.2
PO21.4 PO21.5
PO21.6 PO31.1
WH20.2 WH20.7
PAU-UPDATE-DATE Numeric 8 (yyyymmdd) BL92.1 IN20.1
Update Date This field contains the date the record OE10.1 OE10.2
was updated. OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE113
OE114 OE129
OE14.4 OE15.1
OE15.2 OE15.3
OE15.4 OE15.5
OE15.7 OE510
OE810 OE920
PO120 PO121
PO123 PO20.1
PO21.1 PO21.2
PO21.4 PO21.5
PO21.6 PO30.1
PO31.1 PO33.1
PO35.1 PO530
WH20.2 WH20.7
PAU-UPDATE-TIME Numeric 6 BL92.1 IN20.1
Update Time This field contains the system time OE10.1 OE10.2
when the record was updated. OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE113
OE114 OE129
OE14.4 OE15.1
OE15.2 OE15.3
OE15.4 OE15.5
OE15.7 OE510
OE810 OE920
PO120 PO121
PO123 PO20.1
PO21.1 PO21.2
PO21.4 PO21.5
PO21.6 PO30.1
PO31.1 PO33.1
PO35.1 PO530
WH20.2 WH20.7
PAU-PO-REVISION Numeric 3 BL92.1 IN20.1
PO Revision Number The purchase order revision number. OE10.1 OE10.2
Assigned sequentially by the system when OE10.3 OE10.4
the purchase order is revised. OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE113
OE114 OE129
OE14.4 OE15.1
OE15.2 OE15.3
OE15.4 OE15.5
OE15.7 OE510
OE810 OE920
PO120 PO121
PO123 PO20.1
PO21.1 PO21.2
PO21.4 PO21.5
PO21.6 PO30.1
PO31.1 PO33.1
PO35.1 PO530
WH20.2 WH20.7
PAU-BEFORE-IMAGE Alpha 32 BL92.1 IN20.1
Before Change Image This field contains the field image OE10.1 OE10.2
before the change. OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE113
OE114 OE129
OE14.4 OE15.1
OE15.2 OE15.3
OE15.4 OE15.5
OE15.7 OE510
OE810 OE920
PO120 PO121
PO123 PO20.1
PO21.1 PO21.2
PO21.4 PO21.5
PO21.6 PO30.1
PO31.1 PO33.1
PO35.1 PO530
WH20.2 WH20.7
PAU-AFTER-IMAGE Alpha 32 BL92.1 IN20.1
After Change Image This field contains the field image OE10.1 OE10.2
after the change. OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE113
OE114 OE129
OE14.4 OE15.1
OE15.2 OE15.3
OE15.4 OE15.5
OE15.7 OE510
OE810 OE920
PO120 PO121
PO123 PO20.1
PO21.1 PO21.2
PO21.4 PO21.5
PO21.6 PO30.1
PO31.1 PO33.1
PO35.1 PO530
WH20.2 WH20.7
PAU-TAX-CODE Alpha 10 BL92.1 IN20.1
Tax Code This field contains a code representing OE10.1 OE10.2
specific tax information. This must be OE10.3 OE10.4
valid Tax Code. OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE113
OE114 OE129
OE14.4 OE15.1
OE15.2 OE15.3
OE15.4 OE15.5
OE15.7 OE510
OE810 OE920
PO20.1 PO21.1
PO21.4 PO21.5
PO21.6 PO31.1
WH20.2 WH20.7
PAU-BUYER-CODE Alpha 3 BL92.1 IN20.1
Buyer Code The user-defined buyer identifier. 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 OE113
OE114 OE129
OE14.4 OE15.1
OE15.2 OE15.3
OE15.4 OE15.5
OE15.7 OE510
OE810 OE920
PO120 PO121
PO123 PO20.1
PO21.1 PO21.2
PO21.4 PO21.5
PO21.6 PO30.1
PO31.1 PO33.1
PO35.1 PO530
WH20.2 WH20.7
PAU-VENDOR Alpha 9 BL92.1 IN20.1
Vendor ID The vendor's identification code. 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 OE113
OE114 OE129
OE14.4 OE15.1
OE15.2 OE15.3
OE15.4 OE15.5
OE15.7 OE510
OE810 OE920
PO20.1 PO21.1
PO21.2 PO21.4
PO21.5 PO21.6
PO30.1 PO31.1
PO33.1 PO35.1
PO530 WH20.2
WH20.7
PAU-LOCATION Alpha 5 BL92.1 IN20.1
Location Code This field contains a valid stock OE10.1 OE10.2
location within the company inventory. OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE113
OE114 OE129
OE14.4 OE15.1
OE15.2 OE15.3
OE15.4 OE15.5
OE15.7 OE510
OE810 OE920
PO20.1 PO21.1
PO21.2 PO21.4
PO21.5 PO21.6
PO30.1 PO31.1
PO33.1 PO35.1
PO530 WH20.2
WH20.7
POAUDIT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PAUSET1 COMPANY MA300 PO21.5
PO-NUMBER PO21.6 PO224
PO-RELEASE PO66.1
PO-LINE-NBR
FLD-NBR
AOC-CODE
UPDATE-DATE
UPDATE-TIME
PAUSET2 COMPANY KeyChange BL92.1 IN20.1
PO-NUMBER OE10.1 OE10.2
PO-RELEASE OE10.3 OE10.4
PO-LINE-NBR OE10.5 OE10.6
PO-REVISION OE10.7 OE10.8
FLD-NBR OE11.1 OE11.4
AOC-CODE OE11.8 OE11.9
OE110 OE113
OE114 OE129
OE14.4 OE15.1
OE15.2 OE15.3
OE15.4 OE15.5
OE15.7 OE510
OE810 OE920
PO120 PO121
...
POAUDIT FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Apcompany APCOMPANY Required
PAU-COMPANY -> CPY-COMPANY
Buyer BUYER Required
PAU-COMPANY -> BUY-COMPANY
PCR-BUYER-CODE -> BUY-BUYER-CODE
Pocompany POCOMPANY Required
PAU-COMPANY -> PCY-COMPANY
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-LINE-NBR -> PLI-LINE-NBR
Purchorder PURCHORDER Required
When PAU-PO-LINE-NBR = Zeroes
PAU-COMPANY -> PCR-COMPANY
PAU-PO-NUMBER -> PCR-PO-NUMBER
PAU-PO-RELEASE -> PCR-PO-RELEASE
Vendor APVENMAST Required
CPY-VENDOR-GROUP -> VEN-VENDOR-GROUP
PAU-VENDOR -> VEN-VENDOR
|