SETIDSUBCUST_QUAL2EFFDTCA_CUST2_PRC_VW(SQL View) |
Index Back |
|---|---|
Contract view |
| SELECT CUST1.SETID ,CUST1.SUBCUST_QUAL2 ,CUST1.EFFDT ,CUST1.DESCR ,CUST1.DESCR FROM PS_SUBCUST_Q2_TBL CUST1 WHERE CUST1.EFFDT= ( SELECT MAX(CUST2.EFFDT) FROM PS_SUBCUST_Q2_TBL CUST2 WHERE CUST1.SETID=CUST2.SETID AND CUST1.SUBCUST_QUAL2 = CUST2.SUBCUST_QUAL2 AND CUST2.EFFDT<=%CurrentDateIn) AND CUST1.EFF_STATUS = 'A' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | SUBCUST_QUAL2 |
Character(15) | VARCHAR2(15) NOT NULL | Specifies a user-defined grouping of customer receivables activity. A subcustomer qualifier provides the ability to record and report receivables activity across multiple business units and/or multiple customers. For example a subcustomer qualifier could represent a sales region or a geographic area. There are two possible subcustomer qualifiers: SUBCUST_QUAL1 and SUBCUST_QUAL2. |
| 3 | EFFDT |
Date(10) | DATE | Effective Date |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | EOEP_CHAR | Character(254) | VARCHAR2(254) NOT NULL | Long field |