NET_SCHC_LNG_VW(SQL View) |
Index Back |
---|---|
Contarcts per Schedule VW |
SELECT A.SETID , A.SCHEDULE , B2.LANGUAGE_CD , B.NET_CONTRACT_ID , B2.DESCR , B.NET_PARTICIPANT_ID , B.NETTING_RULE_ID , B.CONTACT_ID FROM PS_SCHEDULE_TBL A , PS_NET_CONTRACT B , PS_NET_CNTRCT_LNG B2 WHERE A.SETID = B.STL_NETSCHED_SETID AND A.SCHEDULE = B.SCHEDULE AND B.EFFDT = ( SELECT MAX(C.EFFDT) FROM PS_NET_CONTRACT C WHERE C.NET_CONTRACT_ID = B.NET_CONTRACT_ID AND C.EFFDT <= %CurrentDateIn) AND B.EFF_STATUS = 'A' AND B2.NET_CONTRACT_ID = B.NET_CONTRACT_ID AND B2.EFFDT = B.EFFDT |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | STL_NETSCHED_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 | SCHEDULE | Character(10) | VARCHAR2(10) NOT NULL | Schedule ID |
3 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
4 | NET_CONTRACT_ID | Character(10) | VARCHAR2(10) NOT NULL | Contract ID : To identify unique contract. |
5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
6 | NET_PARTICIPANT_ID | Character(12) | VARCHAR2(12) NOT NULL | Netting Participant ID, ID to define which Vendors/Customers//Business Units are available to be netted. |
7 | NETTING_RULE_ID | Character(10) | VARCHAR2(10) NOT NULL | Netting Selection Rule ID |
8 | CONTACT_ID | Character(15) | VARCHAR2(15) NOT NULL | Contact Identifier for Treasury Contacts |