DRAFT_BUDRAFT_IDDR_ACTIVITY_VW2(SQL View) |
Index Back |
|---|---|
Draft Accepted Date View |
| SELECT D.DRAFT_BU , D.DRAFT_ID , A.EVENT_DT FROM PS_DRAFT_CONTROL D , PS_DR_ACTIVITY_VW A WHERE D.DRAFT_BU = A.DRAFT_BU AND D.DRAFT_ID = A.DRAFT_ID AND A.DRAFT_BUSN_EVENT='B0' AND A.DRAFT_POST_ACTION='A' 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.DRAFT_BUSN_EVENT='B0' AND B.DRAFT_POST_ACTION='A' AND B.ACTIVE_STATUS = 'A') |
| # | 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 | ACCEPTED_DT | Date(10) | DATE | Accepted Date |