BC_BILLTO_COUNT(SQL View) |
Index Back |
|---|---|
BC bill to countBC bill to count |
| SELECT BO_ID_1 , BO_ID_2 , MAX(CASE WHEN REL_TYPE_ID = 57 OR REL_TYPE_ID = 59 OR REL_TYPE_ID = 69 OR REL_TYPE_ID = 71 THEN 1 ELSE 0 END) FROM PS_BO_REL WHERE REL_TYPE_ID IN (57,59,69,71,56,58,68,70) AND ROLE_TYPE_ID_1 IN (42,46) AND ROLE_TYPE_ID_2 IN (43,47) AND START_DT <= %CurrentDateIn AND END_DT > %CurrentDateIn GROUP BY BO_ID_1, BO_ID_2 |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BO_ID_1 | Signed Number(32,0) | DECIMAL(31) NOT NULL | Business Object ID 1 |
| 2 | BO_ID_2 | Signed Number(32,0) | DECIMAL(31) NOT NULL | Business Object ID 2 |
| 3 | COUNT_TOTAL | Number(9,0) | DECIMAL(9) NOT NULL | Total Count |