AR_ITEM_AUDIT_H(SQL Table) |
Index Back |
---|---|
Archive ITEM_AUDITThe Item Audit Table stores history of changes to items. |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Character(8) | VARCHAR2(8) NOT NULL | Archive ID (see PSARCHTEMPLATE). | |
2 | Number(30,0) | DECIMAL(30) NOT NULL | Archive Batch Number | |
3 | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT |
|
4 | 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. | |
5 | Character(30) | VARCHAR2(30) NOT NULL | Uniquely identifies an invoice credit memo or debit memo. The item ID is also called the invoice number. | |
6 | Number(6,0) | INTEGER NOT NULL | Item Line | |
7 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
8 | 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. |
9 | LAST_MAINT_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Last Maintained By Operator ID |
10 | 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 |
11 | OLD_VAL | Character(50) | VARCHAR2(50) NOT NULL | OLD VALUE |
12 | NEW_VAL | Character(50) | VARCHAR2(50) NOT NULL | NEW VALUE |