The Vendor Agreement Audit table is created as a result of choosing the audit
option in PO00.1 (Procurement Group). When this option is selected, entries to
this table are added whenever changes are made to a vendor agreement.
UPDATED BY
| FIELD NAME |
DESCRIPTION/VALID VALUES |
UPDATED BY |
PVB-AUDIT-TYPE
Element: Audit Type | Alpha 2
01 = Vendor Agreement Header
02 = Vendor Agreement Line
03 = Vendor Agreement Pricing
04 = Vendor Agreement Participants
05 = Agreement Line Add-On Cost
06 = Agreement Line Distribution
07 = Vendor Agreement Spread Amount |
|
PVB-AUDIT-ACTION
Element: Audit Action | Alpha 1
A = Add
C = Change
D = Delete
E = Close Commitments
H = Hold
R = Remove Hold
L = Release Agreement
S = Close Agreement
B = Add/Create Item |
|
PVB-PROCURE-GROUP
Element: Procure Group | Alpha 4
|
|
PVB-VEN-AGRMT-REF
Element: Agreement Ref | Alpha 30
|
|
PVB-COMPANY
Element: Company | Numeric 4
|
|
PVB-LOCATION
Element: Location | Alpha 5
|
|
PVB-REQ-LOCATION
Element: Req Location | Alpha 5
|
|
PVB-EFFECTIVE-DT
Element: Effective Dt | Numeric 8 (yyyymmdd)
|
|
PVB-LINE-NBR
Element: Line Nbr | Numeric 6
|
|
PVB-LINE-SEQ
Element: Seq | Numeric 3
This is the sequence number of the
agreement line distribution, or it has a
zero value for agreement header spread
commitments.
|
|
PVB-SYSTEM
Element: System | Alpha 2
|
|
PVB-COMMIT-DATE
Element: Date | Numeric 8 (yyyymmdd)
The date for the spread commitment
amount. It will fall into a particular
year and period. For non-commitment
spread amounts this is the period
beginning date.
|
|
PVB-FLD-NBR
Element: Fld Nbr | Numeric 4
|
|
PVB-AOC-CODE
Element: Aoc Code | Alpha 2
|
|
PVB-UPDATE-DATE
Element: Update Date | Numeric 8 (yyyymmdd)
|
|
PVB-UPDATE-TIME
Element: Time | Numeric 8
|
|
PVB-BEFORE-IMAGE
Element: Field Val | Alpha 35
|
|
PVB-AFTER-IMAGE
Element: Field Val | Alpha 35
This field contains the field image
before the change.
|
|
PVB-USER-ID
Element: User | Alpha 10 (Lower Case)
|
|
PVB-DESC
Element: Description | Alpha 30 (Lower Case)
The description of the field that has
changed.
|
|
RELATION
NAME |
RELATED FILE |
INTEGRITY RULES / FIELD MATCH |
| Poagmtpart |
POAGMTPART |
Not Required
| PVB-PROCURE-GROUP | -> | PRK-PROCURE-GROUP |
| PVB-VEN-AGRMT-REF | -> | PRK-VEN-AGRMT-REF |
| PVB-COMPANY | -> | PRK-COMPANY |
| PVB-LOCATION | -> | PRK-LOCATION |
| PVB-REQ-LOCATION | -> | PRK-REQ-LOCATION |
|
| Poagmtpric |
POAGMTPRIC |
Not Required
| PVB-PROCURE-GROUP | -> | PRI-PROCURE-GROUP |
| PVB-VEN-AGRMT-REF | -> | PRI-VEN-AGRMT-REF |
| PVB-EFFECTIVE-DT | -> | PRI-EFFECTIVE-DT |
|
| Poaocdtl |
POAOCDTL |
Not Required
| PVB-PROCURE-GROUP | -> | PAO-PROCURE-GROUP |
| PVB-VEN-AGRMT-REF | -> | PAO-VEN-AGRMT-REF |
| PVB-LINE-NBR | -> | PAO-LINE-NBR |
| PVB-AOC-CODE | -> | PAO-AOC-CODE |
|
| Povacommit |
POVACOMMIT |
Not Required
| PVB-PROCURE-GROUP | -> | PVC-PROCURE-GROUP |
| PVB-VEN-AGRMT-REF | -> | PVC-VEN-AGRMT-REF |
| PVB-LINE-NBR | -> | PVC-LINE-NBR |
| PVB-SYSTEM | -> | PVC-SYSTEM |
| PVB-LINE-SEQ | -> | PVC-LINE-SEQ |
| PVB-COMMIT-DATE | -> | PVC-COMMIT-DATE |
|
| Povadist |
POVADIST |
Not Required
| PVB-PROCURE-GROUP | -> | PVD-PROCURE-GROUP |
| PVB-VEN-AGRMT-REF | -> | PVD-VEN-AGRMT-REF |
| PVB-LINE-NBR | -> | PVD-LINE-NBR |
| PVB-LINE-SEQ | -> | PVD-LINE-SEQ |
|
| Povagrmthd |
POVAGRMTHD |
Required
| PVB-PROCURE-GROUP | -> | PVH-PROCURE-GROUP |
| PVB-VEN-AGRMT-REF | -> | PVH-VEN-AGRMT-REF |
|
| Povagrmtln |
POVAGRMTLN |
Not Required
| PVB-PROCURE-GROUP | -> | PVN-PROCURE-GROUP |
| PVB-VEN-AGRMT-REF | -> | PVN-VEN-AGRMT-REF |
| PVB-LINE-NBR | -> | PVN-LINE-NBR |
|
| Procuregrp |
PROCUREGRP |
Required
| PVB-PROCURE-GROUP | -> | PCG-PROCURE-GROUP |
|
