POPIVAUDIT

Vendor Item Audit

The Vendor Item 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 item.

REFERENCED BY
PO69.1


UPDATED BY
PO13.1 PO13.3 PO150 PO192 PO25.6 PO25.7
PO26.4 PO26.5 PO28.2 PO36.2 PO536 PO813

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PIU-PROCURE-GROUP
Element: Procure Group		Alpha 4
PO13.1 PO13.3
PO150 PO25.6
PO25.7 PO26.4
PO26.5 PO28.2
PO36.2 PO536
PO813
PIU-ITEM
Element: Item		Alpha 32
PO13.1 PO13.3
PO150 PO25.6
PO25.7 PO26.4
PO26.5 PO28.2
PO36.2 PO536
PO813
PIU-VENDOR
Element: Vendor		Alpha 9 (Right Justified)
PO13.1 PO13.3
PO150 PO25.6
PO25.7 PO26.4
PO26.5 PO28.2
PO36.2 PO536
PO813
PIU-VENDOR-ITEM
Element: Item		Alpha 32
This is the vendor's item identifier.
PO13.1 PO13.3
PO150 PO25.6
PO25.7 PO26.4
PO26.5 PO28.2
PO36.2 PO536
PO813
PIU-DATE
Element: Date		Numeric 8 (yyyymmdd)
PO13.1 PO13.3
PO150 PO25.6
PO25.7 PO26.4
PO26.5 PO28.2
PO36.2 PO536
PO813
PIU-TIME
Element: Time		Numeric 8
PO13.1 PO13.3
PO150 PO25.6
PO25.7 PO26.4
PO26.5 PO28.2
PO36.2 PO536
PO813
PIU-FLD-NBR
Element: Fld Nbr		Numeric 4
PO13.1 PO13.3
PO150 PO25.6
PO25.7 PO26.4
PO26.5 PO28.2
PO36.2 PO536
PO813
PIU-BEFORE-IMAGE
Element: Field Val		Alpha 35
PO13.1 PO13.3
PO150 PO25.6
PO25.7 PO26.4
PO26.5 PO28.2
PO36.2 PO536
PO813
PIU-AFTER-IMAGE
Element: Field Val		Alpha 35
This field contains the field image after the change.
PO13.1 PO13.3
PO150 PO25.6
PO25.7 PO26.4
PO26.5 PO28.2
PO36.2 PO536
PO813
PIU-OPERATOR-ID
Element: Operator		Alpha 10
Contains the operator ID of the person who last changed this record.
PO13.1 PO13.3
PO150 PO25.6
PO25.7 PO26.4
PO26.5 PO28.2
PO36.2 PO536
PO813
PIU-DESC
Element: Description		Alpha 30 (Lower Case)
The description of the field that has changed.
PO13.1 PO13.3
PO150 PO25.6
PO25.7 PO26.4
PO26.5 PO28.2
PO36.2 PO536
PO813
PIU-AUDIT-ACTION
Element: Audit Action		Alpha 1

A = Add
C = Change
D = Delete
M = Mark Default
V = Activate
T = Inactivate
R = Replace and Inactivate
PO13.1 PO13.3
PO150 PO25.6
PO25.7 PO26.4
PO26.5 PO28.2
PO36.2 PO536
PO813


POPIVAUDIT FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PIUSET1 PROCURE-GROUP
ITEM
VENDOR
VENDOR-ITEM
DATE*
TIME*
FLD-NBR
PO13.1 PO13.3
PO150 PO192
PO25.6 PO25.7
PO26.4 PO26.5
PO28.2 PO36.2
PO536 PO69.1
PO813


POPIVAUDIT FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Apvenmast APVENMAST Required
PCG-VENDOR-GROUP->VEN-VENDOR-GROUP
PIU-VENDOR->VEN-VENDOR
Itemmast ITEMMAST Required
PCG-ITEM-GROUP->ITE-ITEM-GROUP
PIU-ITEM->ITE-ITEM
Poitemven POITEMVEN Not Required
PIU-PROCURE-GROUP->PIV-PROCURE-GROUP
PIU-ITEM->PIV-ITEM
PIU-VENDOR->PIV-VENDOR
PIU-VENDOR-ITEM->PIV-VEN-ITEM
Procuregrp PROCUREGRP Required
PIU-PROCURE-GROUP->PCG-PROCURE-GROUP

File created: Thu Jun 09 02:27:25 2016

Home
Contact Us



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