CASH_NETINQ_SVW(SQL View) |
Index Back |
|---|---|
Cash Netting Inquiry Sum View |
| SELECT DISTINCT a.source_bus_unit ,c.counterparty_setid ,c.counterparty ,c.instrument_type ,a.business_date ,a.net_ref_id ,a.cpty_reference ,a.cp_nettor FROM ps_cash_flow_tr a ,ps_cash_flow_tr b ,PS_TRX_HEADER_TR c WHERE a.source_bus_unit=c.business_unit AND b.source_bus_unit=c.business_unit AND b.tr_source_id=c.treas_header_id AND a.net_ref_id= b.net_ref_id AND a.tr_source_id=b.cf_source_ref_id AND a.net_status='N' AND b.net_status='D' AND c.deal_status IN ('03','04','07') AND a.tr_source_cd='N' AND b.tr_source_cd='D' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SOURCE_BUS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Source Bus 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 | INSTRUMENT_TYPE | Character(10) | VARCHAR2(10) NOT NULL | Instrument type |
| 5 | BUSINESS_DATE | Date(10) | DATE | Represents a date upon which business is conducted within a given company in a given country. |
| 6 | NET_REF_ID | Character(12) | VARCHAR2(12) NOT NULL | A reference identifier associated with a cash transaction subject to netting with a given bank/count |
| 7 | CPTY_REFERENCE | Character(15) | VARCHAR2(15) NOT NULL | A reference identifier associated with a dealing counterparty transaction. |
| 8 | CP_NETTOR | Character(30) | VARCHAR2(30) NOT NULL | Allows the user to indicate whether a given dealing counterparty permits netting of inbound and outbou |