BO_IDRC_SIN_FLTR_VW(SQL View) |
Index Back |
|---|---|
SIN for a CustomerCurrently Available SIN's for a Customer. Used in BO search Setup |
| SELECT DISTINCT C.BO_ID FROM PS_RF_AG_VAL_SITES A , PS_RF_AGREEMENT B , PS_RD_SITE C WHERE A.SETID = B.SETID AND A.BO_ID_CUST = B.BO_ID_CUST AND B.AGRT_STATUS = '005' AND B.END_DT >= %CurrentDateIn AND B.START_DT <= %CurrentDateIn AND A.AGREEMENT_CODE = B.AGREEMENT_CODE AND A.AGR_RENEWAL_NUM = B.AGR_RENEWAL_NUM AND A.SETID = C.SETID AND A.SITE_ID = C.SITE_ID AND A.SIN <> ' ' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BO_ID |
Signed Number(32,0) | DECIMAL(31) NOT NULL | Business Object ID |