ITEM_AUDIT (SQL Table)	Index Back
Item Audits The Item Audit Table stores history of changes to items.

ITEM_AUDIT

(SQL Table)

Item Audits

The Item Audit Table stores history of changes to items.

Parent record: ITEM

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

2 CUST_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.

3 ITEM Character(30) VARCHAR2(30) NOT NULL Uniquely identifies an invoice credit memo or debit memo. The item ID is also called the invoice number.

4 ITEM_LINE Number(6,0) INTEGER NOT NULL Item Line

5 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

6 LAST_UPDATE_DTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

7 LAST_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Last Maintained By Operator ID

8 SOURCE_AUDIT Character(1) VARCHAR2(1) NOT NULL This field is used to contain the source activity that caused the change in data to occur. It is used for audit purposes by AR.
1=Item Maintenance
2=Multi-item Update
3=Batch Mass Change
4=Payment Worksheet
A=Action Add
B=Send Back to A/R
C=Action Maintenance
D=Deduction Maintenance
M=Mass Change
R=Manual Resolution
V=Auto Resolution

9 OLD_VAL Character(50) VARCHAR2(50) NOT NULL OLD VALUE

10 NEW_VAL Character(50) VARCHAR2(50) NOT NULL NEW VALUE

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
2	CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
3	ITEM	Character(30)	VARCHAR2(30) NOT NULL	Uniquely identifies an invoice credit memo or debit memo. The item ID is also called the invoice number.
4	ITEM_LINE	Number(6,0)	INTEGER NOT NULL	Item Line
5	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD).
6	LAST_UPDATE_DTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
7	LAST_MAINT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Last Maintained By Operator ID
8	SOURCE_AUDIT	Character(1)	VARCHAR2(1) NOT NULL	This field is used to contain the source activity that caused the change in data to occur. It is used for audit purposes by AR. 1=Item Maintenance 2=Multi-item Update 3=Batch Mass Change 4=Payment Worksheet A=Action Add B=Send Back to A/R C=Action Maintenance D=Deduction Maintenance M=Mass Change R=Manual Resolution V=Auto Resolution
9	OLD_VAL	Character(50)	VARCHAR2(50) NOT NULL	OLD VALUE
10	NEW_VAL	Character(50)	VARCHAR2(50) NOT NULL	NEW VALUE