DR_ACTIVITY_VW4 (SQL View)	Index Back
Draft Activity Latest This view retrieves the latest activity for a draft.

DR_ACTIVITY_VW4

(SQL View)

Draft Activity Latest

This view retrieves the latest activity for a draft.

SELECT A.DRAFT_BU , A.DRAFT_ID , A.DRAFT_BUSN_EVENT , A.DRAFT_POST_ACTION , A.UNPOST_FLG , A.GROUP_BU , A.GROUP_ID , A.DTTM_CREATED FROM PS_DRAFT_ACTIVITY A WHERE A.DTTM_CREATED = ( SELECT MAX(DTTM_CREATED) FROM PS_DRAFT_ACTIVITY A2 WHERE A.DRAFT_BU = A2.DRAFT_BU AND A.DRAFT_ID = A2.DRAFT_ID )

# 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.
Default Value: OPR_DEF_TBL_AR.DEPOSIT_BU
Prompt Table: SP_BUARDS_NONVW

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 DRAFT_BUSN_EVENT Character(2) VARCHAR2(2) NOT NULL Defines the Draft life cycle event. It represents one of the actions that the PeopleSoft system has provided for Draft processing. Examples are: Approving a Draft Remitting a Draft to the Bank Voiding the Draft.
Prompt Table: DR_BUS_EVNT_TBL

4 DRAFT_POST_ACTION Character(1) VARCHAR2(1) NOT NULL Draft Post Action
A=Actual
D=Dishonor

5 UNPOST_FLG Character(1) VARCHAR2(1) NOT NULL Unpost Flag

6 GROUP_BU Character(5) VARCHAR2(5) NOT NULL Represents the high level grouping of multiple general ledger business units.

7 GROUP_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies a collection of pending items that are to be posted to accounts receivable. The identifier is manually entered or automatically generated by the system.

8 DTTM_CREATED DateTime(26) TIMESTAMP Datetime Created

#	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. Default Value: OPR_DEF_TBL_AR.DEPOSIT_BU Prompt Table: SP_BUARDS_NONVW
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	DRAFT_BUSN_EVENT	Character(2)	VARCHAR2(2) NOT NULL	Defines the Draft life cycle event. It represents one of the actions that the PeopleSoft system has provided for Draft processing. Examples are: Approving a Draft Remitting a Draft to the Bank Voiding the Draft. Prompt Table: DR_BUS_EVNT_TBL
4	DRAFT_POST_ACTION	Character(1)	VARCHAR2(1) NOT NULL	Draft Post Action A=Actual D=Dishonor
5	UNPOST_FLG	Character(1)	VARCHAR2(1) NOT NULL	Unpost Flag
6	GROUP_BU	Character(5)	VARCHAR2(5) NOT NULL	Represents the high level grouping of multiple general ledger business units.
7	GROUP_ID	Character(15)	VARCHAR2(15) NOT NULL	Uniquely identifies a collection of pending items that are to be posted to accounts receivable. The identifier is manually entered or automatically generated by the system.
8	DTTM_CREATED	DateTime(26)	TIMESTAMP	Datetime Created