RBC_RECP_ATTACH

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CMF_ID	Character(36)	VARCHAR2(36) NOT NULL	Correspondence ID
2	CMF_TRNS_SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Correspondence Management Package Sequence Number
3	CMF_RECIP_SEQ_NUM	Number(18,0)	DECIMAL(18) NOT NULL	Correspondence Management Package Sequence Number
4	ATTACH_SEQ_NBR	Number(6,0)	INTEGER NOT NULL	Attachment Sequence Number
5	CMF_INST_FILE_ID	Character(36)	VARCHAR2(36) NOT NULL	Correspondence Instance FileID
6	CMF_ATTACH_STATUS	Character(4)	VARCHAR2(4) NOT NULL	Correspondence Request Status DLC=Delivery Complete DLF=Delivery Failed DLIP=Ready for delivery DXTC=Data extraction complete DXTF=Merge Unsuccessful - DataError MRGC=Merge complete MRGF=Merge Unsuccessful - Templ Err NMRG=Not Generated - Preview NPRT=Not Printed PROC=Processing Default Value: PROC
7	CUSTOMIZED_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Customized flag. Y/N Table Edit Default Value: N
8	TEMPLATE_SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence
9	TEMPLATE_ATT_SEQ	Number(3,0)	SMALLINT NOT NULL	Sequence
10	STATIC_ATT_SEQ	Number(3,0)	SMALLINT NOT NULL	Sequence
11	RB_PACKAGE_ID	Number(10,0)	DECIMAL(10) NOT NULL	Package
12	RB_TEMPLATE_ID	Number(10,0)	DECIMAL(10) NOT NULL	Template ID
13	ATTACHXMLFILENAME	Character(128)	VARCHAR2(128) NOT NULL	Unique XML Filename
14	ATTACHXMLFILE	Character(64)	VARCHAR2(64) NOT NULL	Attach XML File
15	ATTACHDOCFILENAME	Character(128)	VARCHAR2(128) NOT NULL	Unique Doc Filename
16	ATTACHDOCFILE	Character(64)	VARCHAR2(64) NOT NULL	Attach Doc File
17	MERGE_DATE	Date(10)	DATE	Correspondence Send Date
18	SEND_DATE	Date(10)	DATE	Correspondence Send Date
19	ROW_ADDED_DTTM	DateTime(26)	TIMESTAMP	This is a datetime field for record creation.
20	ROW_ADDED_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who added the row.
21	ROW_LASTMANT_DTTM	DateTime(26)	TIMESTAMP	The date and time that the row was last updated.
22	ROW_LASTMANT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who last modified the row.
23	SYNCID	Number(10,0)	DECIMAL(10) NOT NULL	The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
24	SYNCDTTM	DateTime(26)	TIMESTAMP	Synchronization Last Update Date Time