DR_ACTIVITY_VW3 (SQL View)	Index Back
Draft Activity no unposts This view retrieves the latest activity for a draft that is not an unpost action.

DR_ACTIVITY_VW3

(SQL View)

Draft Activity no unposts

This view retrieves the latest activity for a draft that is not an unpost action.

SELECT D.DRAFT_BU , D.DRAFT_ID , A.GROUP_BU , A.GROUP_ID , D.CUST_ID , D.DRAFT_STATUS , D.DRAFT_AMT , D.DRAFT_CURRENCY , A.DRAFT_BUSN_EVENT , A.DRAFT_POST_ACTION , A.DTTM_CREATED FROM PS_DRAFT_CONTROL D , PS_DRAFT_ACTIVITY A WHERE D.DRAFT_BU = A.DRAFT_BU AND D.DRAFT_ID = A.DRAFT_ID AND A.POST_DT IS NOT NULL AND 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 AND A2.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.
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 GROUP_BU Character(5) VARCHAR2(5) NOT NULL Represents the high level grouping of multiple general ledger business units.

4 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.

5 CUST_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
Prompt Table: CUST_SRCH_VW
Set Control Field: DRAFT_BU

6 DRAFT_STATUS Character(1) VARCHAR2(1) NOT NULL Draft Status
A=Accepted
C=Complete
D=Dishonored
E=Void
I=Identified
L=Collateral
M=Discounted
N=No Action
P=Pending
R=Remitted
T=Endorsed

7 DRAFT_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Specifies the amount of a draft payment. This field is maintained by the Draft Creation process.

8 DRAFT_CURRENCY Character(3) VARCHAR2(3) NOT NULL Specifies the currency of a draft payment. The draft currency may or may not be the same as the base currency of the business unit handling the draft.

9 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

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

11 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	GROUP_BU	Character(5)	VARCHAR2(5) NOT NULL	Represents the high level grouping of multiple general ledger business units.
4	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.
5	CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations. Prompt Table: CUST_SRCH_VW Set Control Field: DRAFT_BU
6	DRAFT_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Draft Status A=Accepted C=Complete D=Dishonored E=Void I=Identified L=Collateral M=Discounted N=No Action P=Pending R=Remitted T=Endorsed
7	DRAFT_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Specifies the amount of a draft payment. This field is maintained by the Draft Creation process.
8	DRAFT_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	Specifies the currency of a draft payment. The draft currency may or may not be the same as the base currency of the business unit handling the draft.
9	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
10	DRAFT_POST_ACTION	Character(1)	VARCHAR2(1) NOT NULL	Draft Post Action A=Actual D=Dishonor
11	DTTM_CREATED	DateTime(26)	TIMESTAMP	Datetime Created