STL_INSTR_R_VW1 (SQL View)	Index Back
Valid Receive Instructions Settlement Instructions used for Receipts / into our account - Altered to support the Netting contracts key requirements.

STL_INSTR_R_VW1

(SQL View)

Valid Receive Instructions

Settlement Instructions used for Receipts / into our account - Altered to support the Netting contracts key requirements.

SELECT setid , settlement_id , descr FROM PS_STL_INSTRUCT_H WHERE settlement_type = 'R'

Related Language Record: STL_INS_R_LG_V1

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 STL_INSTRUCT_SETID Character(5) VARCHAR2(5) NOT NULL SetID for Settlement Instructions used on other objects that don't contain setid as part of their key.

2 SETTLEMENT_ID Character(5) VARCHAR2(5) NOT NULL A unique key identifier that represents the settlement instructions for a given bank/counterparty and acc
Prompt Table: STL_INSTRUCTION

3 DESCR Character(30) VARCHAR2(30) NOT NULL Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	STL_INSTRUCT_SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID for Settlement Instructions used on other objects that don't contain setid as part of their key.
2	SETTLEMENT_ID	Character(5)	VARCHAR2(5) NOT NULL	A unique key identifier that represents the settlement instructions for a given bank/counterparty and acc Prompt Table: STL_INSTRUCTION
3	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description