PO_ER_HDR_TMP

(SQL Table)
Index Back

PO ER Header Tmp

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
3 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
4 SHIPTO_SETID Character(5) VARCHAR2(5) NOT NULL ShipTo SetID
5 SHIPTO_ID Character(10) VARCHAR2(10) NOT NULL Ship To Location
6 BUSINESS_UNIT_IN Character(5) VARCHAR2(5) NOT NULL Inventory Unit
7 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
8 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
9 PUBLISH Character(1) VARCHAR2(1) NOT NULL Publish Data
10 AUDIT_ACTN Character(1) VARCHAR2(1) NOT NULL Audit Action Code for Application Messages. This tells the subscriber whether the row has been added, changed, or deleted.
A=Add
C=Change Old (PPR Only)
D=Delete
K=Change - Old Values
N=Change - New Values
O=Change - Original Values