FORM_TYPE_ATTCH (SQL Table)	Index Back
Form Type Attachements Form Type Attachements

FORM_TYPE_ATTCH

(SQL Table)

Form Type Attachements

Related Language Record: FORM_TYPE_AT_LG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 FORM_TYPE Character(10) VARCHAR2(10) NOT NULL Form and Builder Field
ADV=Remittance Advice Only
CAV=Check with Separate Advice
CRA=Crystal Check w/Advice
CRW=Crystal Check
CSA=Check over Stub with Advice
CSO=Check over Stub with Overflow
EFA=EFT File with Advice
EFT=EFT File
SCA=Stub over Check with Advice
SCO=Stub over Check with Overflow

2 SEQ_NBR_5 Number(5,0) INTEGER NOT NULL Sequence number five digits long

3 DESCR Character(30) VARCHAR2(30) NOT NULL Description

4 ATTACHSYSFILENAME Character(128) VARCHAR2(128) NOT NULL Unique Sys Filename

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

6 CREATED_BY_USER Character(30) VARCHAR2(30) NOT NULL Created By

7 CREATED_DTTM DateTime(26) TIMESTAMP Created Date and time

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	FORM_TYPE	Character(10)	VARCHAR2(10) NOT NULL	Form and Builder Field ADV=Remittance Advice Only CAV=Check with Separate Advice CRA=Crystal Check w/Advice CRW=Crystal Check CSA=Check over Stub with Advice CSO=Check over Stub with Overflow EFA=EFT File with Advice EFT=EFT File SCA=Stub over Check with Advice SCO=Stub over Check with Overflow
2	SEQ_NBR_5	Number(5,0)	INTEGER NOT NULL	Sequence number five digits long
3	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
4	ATTACHSYSFILENAME	Character(128)	VARCHAR2(128) NOT NULL	Unique Sys Filename
5	ATTACHUSERFILE	Character(64)	VARCHAR2(64) NOT NULL	Attached File
6	CREATED_BY_USER	Character(30)	VARCHAR2(30) NOT NULL	Created By
7	CREATED_DTTM	DateTime(26)	TIMESTAMP	Created Date and time