PO_POA_SRCH_TMP

(SQL Table)
Index Back

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EIP_CTL_ID Character(25) VARCHAR2(25) NOT NULL Enterprise Components EIP (enterprise integration point) control field
2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
3 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
4 DATETIME_DISP DateTime(26) TIMESTAMP Date and Time Dispatched
5 PO_POA_STATUS Character(3) VARCHAR2(3) NOT NULL 08/07/01 RML Created for Supplier Portal Acknowledgment
BAC=Buyer Accepted
CMP=EDX compare needed
NEW=New
SRP=Supplier Responded
SRV=Supplier Review
6 PO_ACK_SOURCE Character(3) VARCHAR2(3) NOT NULL Created on 08/09/01 CN#WV840-4.0 - Purchase Order Acknowledgment source used in PO_HDR_EC
BUY=Online (Buyer)
EDI=EDX
SUP=Online (Supplier)
7 ACKNOWLEGE_DT Date(10) DATE Acknowledge Date
8 DATETIME_CREATE DateTime(26) TIMESTAMP 02/2001 cel WV-802-1.0.
9 RESPONDED_DTTM DateTime(26) TIMESTAMP Represents the date and time a designated operator reviewed and acknowledged an exposure limit vi
10 PROCESS_FLG Character(1) VARCHAR2(1) NOT NULL Processing Flag

Y/N Table Edit

Default Value: N

11 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
12 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
13 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
14 PO_STATUS Character(2) VARCHAR2(2) NOT NULL PO Status
A=Approved
C=Complete
D=Dispatched
DA=Denied
I=Initial
LD=Line Denied
O=Open
PA=Pending Approval/Approved
PX=Pending Cancel
X=Canceled
15 CHNG_ORD_BATCH Number(3,0) SMALLINT NOT NULL Change Order Number
16 BUYER_ID Character(30) VARCHAR2(30) NOT NULL Buyer
17 POA_HIST_TYPE Character(1) VARCHAR2(1) NOT NULL Submitted by
B=Buyer
S=Supplier