DD_WS_ATT (SQL Table)	Index Back
Attachment for Direct Debit WS Attachment for Direct Debit WS

DD_WS_ATT

(SQL Table)

Attachment for Direct Debit WS

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 DD_WORKSHEET_ID Number(10,0) DECIMAL(10) NOT NULL DD Worksheet Id

2 DD_RQST_SEQUENCE Number(5,0) INTEGER NOT NULL Request Sequence Number

3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Prompt Table: SP_BUARDS_NONVW
Set Control Field: BUSINESS_UNIT

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

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

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

7 FMS_OPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the original entry.

8 FMS_LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry.

9 FMS_LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	DD_WORKSHEET_ID	Number(10,0)	DECIMAL(10) NOT NULL	DD Worksheet Id
2	DD_RQST_SEQUENCE	Number(5,0)	INTEGER NOT NULL	Request Sequence Number
3	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: SP_BUARDS_NONVW Set Control Field: BUSINESS_UNIT
4	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.
5	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.
6	FMS_DTTM_STAMP	DateTime(26)	TIMESTAMP	Specifies the date and time of the original entry.
7	FMS_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which made the original entry.
8	FMS_LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry.
9	FMS_LASTUPDOPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which made the last update to an entry.