DUN_ATTCC_VW (SQL View)	Index Back
Dunning attach by crsp cust This view is used in viewing dunning attachments by corresponding customer

DUN_ATTCC_VW

(SQL View)

Dunning attach by crsp cust

This view is used in viewing dunning attachments by corresponding customer

SELECT B.CRSPD_SETID , B.CRSPD_CUST_ID , B.BUSINESS_UNIT , B.DUN_ID_NUM , B.DUN_DT , B.SCM_ATTACH_ID , B.ATT_VERSION , B.FMS_DTTM_STAMP , A.ATTACHUSERFILE FROM PS_PV_ATTACHMENTS A , PS_DUNNING_ATTACH B WHERE A.SCM_ATTACH_ID = B.SCM_ATTACH_ID AND A.ATT_VERSION = B.ATT_VERSION

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 CRSPD_SETID Character(5) VARCHAR2(5) NOT NULL SetID

2 CRSPD_CUST_ID Character(15) VARCHAR2(15) NOT NULL Correspondence Customer

3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

4 DUN_ID_NUM Number(8,0) INTEGER NOT NULL Dunning Number

5 DUN_DT Date(10) DATE Specifies the date that a dunning letter is sent. This date is generated by the Dunning SQR.

6 SCM_ATTACH_ID Character(64) VARCHAR2(64) NOT NULL The unique ID of each file whose attachment was handled by the attachment utility. Unique across all attachments, all applications.

7 ATT_VERSION Number(3,0) SMALLINT NOT NULL The version of the attached file. Currently always 1, this field will find more use once the attachment utitlity starts supporting versioning of files.

8 FMS_DTTM_STAMP DateTime(26) TIMESTAMP Specifies the date and time of the original entry.

9 ATTACHUSERFILE Character(64) VARCHAR2(64) NOT NULL Attached File

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CRSPD_SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
2	CRSPD_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Correspondence Customer
3	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
4	DUN_ID_NUM	Number(8,0)	INTEGER NOT NULL	Dunning Number
5	DUN_DT	Date(10)	DATE	Specifies the date that a dunning letter is sent. This date is generated by the Dunning SQR.
6	SCM_ATTACH_ID	Character(64)	VARCHAR2(64) NOT NULL	The unique ID of each file whose attachment was handled by the attachment utility. Unique across all attachments, all applications.
7	ATT_VERSION	Number(3,0)	SMALLINT NOT NULL	The version of the attached file. Currently always 1, this field will find more use once the attachment utitlity starts supporting versioning of files.
8	FMS_DTTM_STAMP	DateTime(26)	TIMESTAMP	Specifies the date and time of the original entry.
9	ATTACHUSERFILE	Character(64)	VARCHAR2(64) NOT NULL	Attached File