STL_INSTR_P_VW1 (SQL View)	Index Back
Valid Payment Instructions Settlement Instructions used for Payments - Adapted for use with the Netting Contracts - Changed the SetID

STL_INSTR_P_VW1

(SQL View)

Valid Payment Instructions

Settlement Instructions used for Payments - Adapted for use with the Netting Contracts - Changed the SetID

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

Related Language Record: STL_INS_P_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