STMT_ATTSS_VW (SQL View)	Index Back
View Statment attachments-eBP This view is used in viewing statement attachments in eBill Payment

STMT_ATTSS_VW

(SQL View)

View Statment attachments-eBP

This view is used in viewing statement attachments in eBill Payment

SELECT B.CRSPD_SETID , B.CRSPD_CUST_ID , B.CUST_ID , B.BUSINESS_UNIT , B.ST_ID_NUM , B.ST_DT , B.ST_ID_TYPE , B.SCM_ATTACH_ID , B.ATT_VERSION , B.FMS_DTTM_STAMP , A.ATTACHUSERFILE FROM PS_PV_ATTACHMENTS A , PS_STMT_ATTACH B WHERE A.SCM_ATTACH_ID = B.SCM_ATTACH_ID AND A.ATT_VERSION = B.ATT_VERSION AND B.CUST_ID <> ' ' AND B.ST_STATUS = 'A'

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

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

5 ST_ID_NUM Number(8,0) INTEGER NOT NULL Statement Number

6 ST_DT Date(10) DATE Specifies the date a statement (Receivables) is generated. This date is maintained by the Statements SQR.

7 ST_ID_TYPE Character(1) VARCHAR2(1) NOT NULL Statement Type
B=Bal Fwd
O=Open Item

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

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

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

11 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	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.
4	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
5	ST_ID_NUM	Number(8,0)	INTEGER NOT NULL	Statement Number
6	ST_DT	Date(10)	DATE	Specifies the date a statement (Receivables) is generated. This date is maintained by the Statements SQR.
7	ST_ID_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Statement Type B=Bal Fwd O=Open Item
8	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.
9	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.
10	FMS_DTTM_STAMP	DateTime(26)	TIMESTAMP	Specifies the date and time of the original entry.
11	ATTACHUSERFILE	Character(64)	VARCHAR2(64) NOT NULL	Attached File