DRAFT_CWB_VW (SQL View)	Index Back
Unique Payments

DRAFT_CWB_VW

(SQL View)

Unique Payments

SELECT DISTINCT draft_bu , draft_doc_ref FROM PS_DRAFT_CONTROL WHERE draft_status NOT IN ( 'C', 'D', 'E' )

# 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_DOC_REF Character(20) VARCHAR2(20) NOT NULL Draft Reference

#	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_DOC_REF	Character(20)	VARCHAR2(20) NOT NULL	Draft Reference