DRAFT_XFER_VW (SQL View)	Index Back
Draft Transfer Details Records details of the party to which a draft has been transferred.

DRAFT_XFER_VW

(SQL View)

Draft Transfer Details

Records details of the party to which a draft has been transferred.

SELECT %subrec(DRAFT_XFER_VW, A1) FROM PS_DRAFT_XFER_TBL A1 WHERE A1.DRAFT_XFER_TYPE IN ('C', 'E') AND A1.DTTM_CREATED = ( SELECT MAX(A2.DTTM_CREATED) FROM PS_DRAFT_XFER_TBL A2 WHERE A2.DRAFT_BU = A1.DRAFT_BU AND A2.DRAFT_ID = A1.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.

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 TRANSACTION_DT Date(10) DATE NOT NULL Transaction date (often used as trade date)

4 DRAFT_XFER_TYPE Character(1) VARCHAR2(1) NOT NULL Draft Transfer Type
A=Undo Collateral
B=Undo Endorse
C=Collateral Draft
E=Endorse Draft

5 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1

#	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	TRANSACTION_DT	Date(10)	DATE NOT NULL	Transaction date (often used as trade date)
4	DRAFT_XFER_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Draft Transfer Type A=Undo Collateral B=Undo Endorse C=Collateral Draft E=Endorse Draft
5	NAME1	Character(40)	VARCHAR2(40) NOT NULL	Name 1