DRAFT_BUDRAFT_IDDR_ACTIVITY_VW5(SQL View) |
Index Back |
|---|---|
Draft Dishonored Date View |
| SELECT D.DRAFT_BU , D.DRAFT_ID , A.EVENT_DT FROM PS_DRAFT_CONTROL D , PS_DRAFT_ACTIVITY A WHERE D.DRAFT_STATUS='D' AND D.DRAFT_BU=A.DRAFT_BU AND D.DRAFT_ID=A.DRAFT_ID AND A.DRAFT_POST_ACTION='D' AND A.ACTIVE_STATUS='A' AND A.UNPOST_FLG='N' AND A.DTTM_CREATED = ( SELECT MAX(B.DTTM_CREATED) FROM PS_DRAFT_ACTIVITY B WHERE A.DRAFT_BU=B.DRAFT_BU AND A.DRAFT_ID=B.DRAFT_ID AND B.ACTIVE_STATUS='A' AND B.UNPOST_FLG='N') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | DRAFT_BU |
Character(5) | VARCHAR2(5) NOT NULL | Identifies the Receivables business unit associated with a draft. This field is maintained by the Draft Creation process. |
| 2 | DRAFT_ID |
Character(15) | VARCHAR2(15) NOT NULL | Uniquely identifies a payment draft. The Draft ID is system-generated during the Draft Creation process or manually entered. |
| 3 | DR_DISHONOR_DT | Date(10) | DATE | Dishonor Date |