PO_SE_CNTCT1_VW (SQL View)	Index Back
PO Supplier Contact PTSF View

PO_SE_CNTCT1_VW

(SQL View)

PO Supplier Contact PTSF View

SELECT A.SETID , A.VENDOR_ID , A.ADDRESS_SEQ_NUM , A.CONTACT_NAME FROM PS_VENDOR_CNTCT A WHERE A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_VENDOR_CNTCT B WHERE A.SETID = B.SETID AND A.VENDOR_ID = B.VENDOR_ID AND A.ADDRESS_SEQ_NUM = B.ADDRESS_SEQ_NUM AND B.EFFDT <= %CurrentDateIn) AND A.EFF_STATUS = 'A' AND A.CONTACT_TYPE = 'G'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

3 ADDRESS_SEQ_NUM Number(5,0) INTEGER NOT NULL Address Sequence Number

4 CONTACT_NAME Character(50) VARCHAR2(50) NOT NULL The individual contact name associated with a given bank/counterparty.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
2	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
3	ADDRESS_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Address Sequence Number
4	CONTACT_NAME	Character(50)	VARCHAR2(50) NOT NULL	The individual contact name associated with a given bank/counterparty.