NET_REF_ID_VW (SQL View)	Index Back
NET_REF_ID Prompt Table Prompt Table for NET_REF_ID

NET_REF_ID_VW

(SQL View)

NET_REF_ID Prompt Table

Prompt Table for NET_REF_ID

SELECT DISTINCT SOURCE_BUS_UNIT ,COUNTERPARTY_SETID ,COUNTERPARTY ,BUSINESS_DATE ,NET_REF_ID FROM PS_CASH_NET_INQ_VW WHERE NET_REF_ID<>' '

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

2 COUNTERPARTY_SETID Character(5) VARCHAR2(5) NOT NULL The PeopleSoft tableset ID associated with a given dealing counterparty.

3 COUNTERPARTY Character(5) VARCHAR2(5) NOT NULL Represents a treasury dealing counterpart.

4 SETTLEMENT_DT Date(10) DATE The settlement date for a given cash -based transaction, or the start date for a Treasury Deal.

5 NET_ID_INQ Character(12) VARCHAR2(12) NOT NULL A unique key identifier that represents a group of cash transactions subject to netting with a given bank/

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	COUNTERPARTY_SETID	Character(5)	VARCHAR2(5) NOT NULL	The PeopleSoft tableset ID associated with a given dealing counterparty.
3	COUNTERPARTY	Character(5)	VARCHAR2(5) NOT NULL	Represents a treasury dealing counterpart.
4	SETTLEMENT_DT	Date(10)	DATE	The settlement date for a given cash -based transaction, or the start date for a Treasury Deal.
5	NET_ID_INQ	Character(12)	VARCHAR2(12) NOT NULL	A unique key identifier that represents a group of cash transactions subject to netting with a given bank/