RE_EXT_PTY_NAME (SQL View)	Index Back
External Party External Party name view.

RE_EXT_PTY_NAME

(SQL View)

External Party

External Party name view.

SELECT B.LS_KEY , A.PARTY_KEY , A.NAME FROM PS_RE_LS_EXT_PARTY A , PS_RE_LS_CNTCT B WHERE A.PARTY_KEY = B.PARTY_KEY AND B.ROLE_TYP='2'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 LS_KEY Number(15,0) DECIMAL(15) NOT NULL Lease Key, Unique Key

2 PARTY_KEY Number(10,0) DECIMAL(10) NOT NULL Party Key

3 GUARANTOR Character(50) VARCHAR2(50) NOT NULL Guarantor Name

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	LS_KEY	Number(15,0)	DECIMAL(15) NOT NULL	Lease Key, Unique Key
2	PARTY_KEY	Number(10,0)	DECIMAL(10) NOT NULL	Party Key
3	GUARANTOR	Character(50)	VARCHAR2(50) NOT NULL	Guarantor Name