 |
Lawson Insight Technical Documentation |
|
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
AP125 AP126 AP131 AP25.1 AP25.2 AP26.1
AP27.1 API1.1 IC28.1 MA180 MA43.9 MA530
MA531 MA60.2 MA60.3 MA60.5 MA61.1 MA66.3
MA67.1 MA67.2 MA70.1 MAI1.1 PO100 PO101
PO122 PO131 PO20.1 PO21.2 PO21.3 PO21.4
PO21.5 PO22.1 PO23.1 PO25.2 PO25.6 PO25.7
PO25.8 PO27.3 PO29.1 PO30.1 PO30.2 PO30.3
PO300 PO31.1 PO31.2 PO32.2 PO33.1 PO34.1
PO35.1 PO38.1 PO39.1 PO39.2 PO44.1 PO50.1
PO52.1 PO520 POI3.1 POI7.1 POIE.1 POII.1
POIJ.1 RQ10.1 RQ10.2 WH20.2 WH20.7
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PAU-AUDIT-TYPE Alpha 2 AP125 AP126
Audit Type The type of source record that is being AP131 AP25.1
audited. AP25.2 AP26.1
HD = PO Header AP27.1 API1.1
HA = Spread AOC IC28.1 MA180
LN = PO Line MA43.9 MA530
LA = Misc/Line AOC MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO25.2
PO25.6 PO25.7
PO25.8 PO27.3
PO29.1 PO30.1
PO30.2 PO30.3
PO300 PO31.1
PO31.2 PO32.2
PO33.1 PO34.1
PO35.1 PO38.1
PO39.1 PO39.2
PO44.1 PO50.1
PO52.1 PO520
POI3.1 POI7.1
POIE.1 POII.1
...
PAU-AUDIT-ACTION Alpha 1 AP125 AP126
Audit Action The action (add, change, etc.) that is AP131 AP25.1
being audited. AP25.2 AP26.1
A = Add AP27.1 API1.1
C = Change IC28.1 MA180
L = Cancel MA43.9 MA530
B = B/O Cancel MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO25.2
PO25.6 PO25.7
PO25.8 PO27.3
PO29.1 PO30.1
PO30.2 PO30.3
PO300 PO31.1
PO31.2 PO32.2
PO33.1 PO34.1
PO35.1 PO38.1
PO39.1 PO39.2
PO44.1 PO50.1
PO52.1 PO520
POI3.1 POI7.1
POIE.1 POII.1
...
PAU-COMPANY Numeric 4 AP125 AP126
Company The company number. AP131 AP25.1
AP25.2 AP26.1
AP27.1 API1.1
IC28.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO25.2
PO25.6 PO25.7
PO25.8 PO27.3
PO29.1 PO30.1
PO30.2 PO30.3
PO300 PO31.1
PO31.2 PO32.2
PO33.1 PO34.1
PO35.1 PO38.1
PO39.1 PO39.2
PO44.1 PO50.1
PO52.1 PO520
POI3.1 POI7.1
POIE.1 POII.1
...
PAU-PO-NUMBER Alpha 14 (Right Justified) AP125 AP126
PO Number This field contains the number AP131 AP25.1
representing the purchase order. AP25.2 AP26.1
AP27.1 API1.1
IC28.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO25.2
PO25.6 PO25.7
PO25.8 PO27.3
PO29.1 PO30.1
PO30.2 PO30.3
PO300 PO31.1
PO31.2 PO32.2
PO33.1 PO34.1
PO35.1 PO38.1
PO39.1 PO39.2
PO44.1 PO50.1
PO52.1 PO520
POI3.1 POI7.1
POIE.1 POII.1
...
PAU-PO-RELEASE Numeric 4 AP125 AP126
PO Release Number Used to identify a purchase order AP131 AP25.1
release (created from a Blanket or AP25.2 AP26.1
Standing order). AP27.1 API1.1
IC28.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO25.2
PO25.6 PO25.7
PO25.8 PO27.3
PO29.1 PO30.1
PO30.2 PO30.3
PO300 PO31.1
PO31.2 PO32.2
PO33.1 PO34.1
PO35.1 PO38.1
PO39.1 PO39.2
PO44.1 PO50.1
PO52.1 PO520
POI3.1 POI7.1
POIE.1 POII.1
...
PAU-PO-CODE Alpha 4 AP125 AP126
Po Code This is the purchase order code. AP131 AP25.1
AP25.2 AP26.1
AP27.1 API1.1
IC28.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO25.2
PO25.6 PO25.7
PO25.8 PO27.3
PO29.1 PO30.1
PO30.2 PO30.3
PO300 PO31.1
PO31.2 PO32.2
PO33.1 PO34.1
PO35.1 PO38.1
PO39.1 PO39.2
PO44.1 PO50.1
PO52.1 PO520
POI3.1 POI7.1
POIE.1 POII.1
...
PAU-PO-LINE-NBR Numeric 6 AP125 AP126
PO Line Number The purchase order line number this AP131 AP25.1
record is associated with. AP25.2 AP26.1
AP27.1 API1.1
IC28.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO25.2
PO25.6 PO25.7
PO25.8 PO27.3
PO29.1 PO30.1
PO30.2 PO30.3
PO300 PO31.1
PO31.2 PO32.2
PO33.1 PO34.1
PO35.1 PO38.1
PO39.1 PO39.2
PO44.1 PO50.1
PO52.1 PO520
POI3.1 POI7.1
POIE.1 POII.1
...
PAU-FLD-NBR Numeric 4 AP125 AP126
Dictionary Field This field contains the purchase order AP131 AP25.1
Number dictionary field number. AP25.2 AP26.1
AP27.1 API1.1
IC28.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO25.2
PO25.6 PO25.7
PO25.8 PO27.3
PO29.1 PO30.1
PO30.2 PO30.3
PO300 PO31.1
PO31.2 PO32.2
PO33.1 PO34.1
PO35.1 PO38.1
PO39.1 PO39.2
PO44.1 PO50.1
PO52.1 PO520
POI3.1 POI7.1
POIE.1 POII.1
...
PAU-AOC-CODE Alpha 2 AP125 AP126
Add On Cost Code This field contains the identifier for AP131 AP25.1
the add-on cost associated with this AP25.2 AP26.1
line item. AP27.1 API1.1
IC28.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO25.2
PO25.6 PO25.7
PO25.8 PO27.3
PO29.1 PO30.1
PO30.2 PO30.3
PO300 PO31.1
PO31.2 PO32.2
PO33.1 PO34.1
PO35.1 PO38.1
PO39.1 PO39.2
PO44.1 PO50.1
PO52.1 PO520
POI3.1 POI7.1
POIE.1 POII.1
...
PAU-UPDATE-DATE Numeric 8 (yyyymmdd) AP125 AP126
Update Date This field contains the date the record AP131 AP25.1
was updated. AP25.2 AP26.1
AP27.1 API1.1
IC28.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO25.2
PO25.6 PO25.7
PO25.8 PO27.3
PO29.1 PO30.1
PO30.2 PO30.3
PO300 PO31.1
PO31.2 PO32.2
PO33.1 PO34.1
PO35.1 PO38.1
PO39.1 PO39.2
PO44.1 PO50.1
PO52.1 PO520
POI3.1 POI7.1
POIE.1 POII.1
...
PAU-UPDATE-TIME Numeric 6 AP125 AP126
Update Time This field contains the system time AP131 AP25.1
when the record was updated. AP25.2 AP26.1
AP27.1 API1.1
IC28.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO25.2
PO25.6 PO25.7
PO25.8 PO27.3
PO29.1 PO30.1
PO30.2 PO30.3
PO300 PO31.1
PO31.2 PO32.2
PO33.1 PO34.1
PO35.1 PO38.1
PO39.1 PO39.2
PO44.1 PO50.1
PO52.1 PO520
POI3.1 POI7.1
POIE.1 POII.1
...
PAU-PO-REVISION Numeric 3 AP125 AP126
PO Revision Number The purchase order revision number. AP131 AP25.1
Assigned sequentially by the system when AP25.2 AP26.1
the purchase order is revised. AP27.1 API1.1
IC28.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO25.2
PO25.6 PO25.7
PO25.8 PO27.3
PO29.1 PO30.1
PO30.2 PO30.3
PO300 PO31.1
PO31.2 PO32.2
PO33.1 PO34.1
PO35.1 PO38.1
PO39.1 PO39.2
PO44.1 PO50.1
PO52.1 PO520
POI3.1 POI7.1
POIE.1 POII.1
...
PAU-BEFORE-IMAGE Alpha 32 AP125 AP126
Before Change Image This field contains the field image AP131 AP25.1
before the change. AP25.2 AP26.1
AP27.1 API1.1
IC28.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO25.2
PO25.6 PO25.7
PO25.8 PO27.3
PO29.1 PO30.1
PO30.2 PO30.3
PO300 PO31.1
PO31.2 PO32.2
PO33.1 PO34.1
PO35.1 PO38.1
PO39.1 PO39.2
PO44.1 PO50.1
PO52.1 PO520
POI3.1 POI7.1
POIE.1 POII.1
...
PAU-AFTER-IMAGE Alpha 32 AP125 AP126
After Change Image This field contains the field image AP131 AP25.1
after the change. AP25.2 AP26.1
AP27.1 API1.1
IC28.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO25.2
PO25.6 PO25.7
PO25.8 PO27.3
PO29.1 PO30.1
PO30.2 PO30.3
PO300 PO31.1
PO31.2 PO32.2
PO33.1 PO34.1
PO35.1 PO38.1
PO39.1 PO39.2
PO44.1 PO50.1
PO52.1 PO520
POI3.1 POI7.1
POIE.1 POII.1
...
PAU-USER-ID Alpha 10 (Lower Case) AP125 AP126
User ID Name Contains the user ID of the person who AP131 AP25.1
revised the purchase order. AP25.2 AP26.1
AP27.1 API1.1
IC28.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO25.2
PO25.6 PO25.7
PO25.8 PO27.3
PO29.1 PO30.1
PO30.2 PO30.3
PO300 PO31.1
PO31.2 PO32.2
PO33.1 PO34.1
PO35.1 PO38.1
PO39.1 PO39.2
PO44.1 PO50.1
PO52.1 PO520
POI3.1 POI7.1
POIE.1 POII.1
...
PAU-PRINT-REV Alpha 1 AP125 AP126
Print Rev Indicates whether to print a revision AP131 AP25.1
message on the purchase order for the AP25.2 AP26.1
audited action. AP27.1 API1.1
Y = Yes IC28.1 MA180
N = No MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO25.2
PO25.6 PO25.7
PO25.8 PO27.3
PO29.1 PO30.1
PO30.2 PO30.3
PO300 PO31.1
PO31.2 PO32.2
PO33.1 PO34.1
PO35.1 PO38.1
PO39.1 PO39.2
PO44.1 PO50.1
PO52.1 PO520
POI3.1 POI7.1
POIE.1 POII.1
...
PAU-DESC Alpha 30 (Lower Case) AP125 AP126
Description The description of the field that has AP131 AP25.1
changed. AP25.2 AP26.1
AP27.1 API1.1
IC28.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO25.2
PO25.6 PO25.7
PO25.8 PO27.3
PO29.1 PO30.1
PO30.2 PO30.3
PO300 PO31.1
PO31.2 PO32.2
PO33.1 PO34.1
PO35.1 PO38.1
PO39.1 PO39.2
PO44.1 PO50.1
PO52.1 PO520
POI3.1 POI7.1
POIE.1 POII.1
...
POAUDIT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PAUSET1 AUDIT-TYPE This is the primary index for the AP125 AP126
AUDIT-ACTION POAUDIT file. The keys include all of AP131 AP25.1
COMPANY the keys for audited PO source records AP25.2 AP26.1
PO-NUMBER (PO header, line, add on cost code, AP27.1 API1.1
PO-RELEASE etc.), as well as the type of source IC28.1 MA180
PO-CODE record the audit is created for, the MA43.9 MA530
PO-REVISION action that is being audited, and the MA531 MA60.2
PO-LINE-NBR date and time of the audit. Uniqueness MA60.3 MA60.5
AOC-CODE is guaranteed for multiple changes to MA61.1 MA66.3
FLD-NBR the same field by the date and time MA67.1 MA67.2
UPDATE-DATE stamps. MA70.1 MAI1.1
UPDATE-TIME PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
...
PAUSET2 COMPANY This index allows access to audit AP125 AP126
PO-NUMBER records by descending date/time. It is AP131 AP25.1
PO-RELEASE used to display, report and drill around AP25.2 AP26.1
PO-CODE on audits from a purchase order. AP27.1 IC28.1
PO-REVISION* KeyChange MA180 MA43.9
UPDATE-DATE* MA530 MA531
UPDATE-TIME* MA60.2 MA60.3
PO-LINE-NBR MA60.5 MA61.1
AOC-CODE MA66.3 MA67.1
FLD-NBR MA67.2 MA70.1
AUDIT-TYPE MAI1.1 PO100
AUDIT-ACTION PO101 PO122
PO131 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
...
PAUSET3 COMPANY This index provides access to all audit AP125 AP126
PO-NUMBER records relating to a POLINE by AP131 AP25.1
PO-RELEASE descending date and time. AP25.2 AP26.1
PO-CODE KeyChange AP27.1 API1.1
PO-LINE-NBR IC28.1 MA180
PO-REVISION* MA43.9 MA530
AOC-CODE MA531 MA60.2
UPDATE-DATE* MA60.3 MA60.5
UPDATE-TIME* MA61.1 MA66.3
FLD-NBR MA67.1 MA67.2
AUDIT-TYPE MA70.1 MAI1.1
AUDIT-ACTION PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
...
PAUSET4 COMPANY This index supports access to all audit AP125 AP126
PO-NUMBER records for a POAOCDTL. AP131 AP25.1
PO-RELEASE KeyChange AP25.2 AP26.1
PO-CODE AP27.1 IC28.1
PO-LINE-NBR MA180 MA43.9
AOC-CODE MA530 MA531
PO-REVISION* MA60.2 MA60.3
UPDATE-DATE* MA60.5 MA61.1
UPDATE-TIME* MA66.3 MA67.1
FLD-NBR MA67.2 MA70.1
AUDIT-TYPE MAI1.1 PO100
AUDIT-ACTION PO101 PO122
PO131 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
...
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
|