CST_SRCH_SHPTMP (SQL Table)	Index Back
Ship Customer audit for Search

CST_SRCH_SHPTMP

(SQL Table)

Ship Customer audit for Search

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

2 SETID Character(5) VARCHAR2(5) NOT NULL SetID

3 SOLD_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Sold To Customer

4 SHIP_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Ship To Customer

5 ADDRESS_SEQ_SHIP Number(5,0) INTEGER NOT NULL Primary Address - Ship To

6 LASTUPDDTTM 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.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
3	SOLD_TO_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Sold To Customer
4	SHIP_TO_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Ship To Customer
5	ADDRESS_SEQ_SHIP	Number(5,0)	INTEGER NOT NULL	Primary Address - Ship To
6	LASTUPDDTTM	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.