CMF_IDATTACH_SEQ_NBRA=All
I=Internal
Y/N Table Edit
RBC_ATTACH_TMP(SQL Table) |
Index Back |
|---|---|
Correspondence AttachmentsCorrespondence Request File Attachments |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CMF_ID |
Character(36) | VARCHAR2(36) NOT NULL | Correspondence ID |
| 2 | ATTACH_SEQ_NBR |
Number(6,0) | INTEGER NOT NULL | Attachment Sequence Number |
| 3 | ATTACHSYSFILENAME | Character(128) | VARCHAR2(128) NOT NULL | Unique Sys Filename |
| 4 | ATTACHUSERFILE | Character(64) | VARCHAR2(64) NOT NULL | Attached File |
| 5 | DESCRIPTION | Character(35) | VARCHAR2(35) NOT NULL | Description |
| 6 | RC_VISIBILITY | Character(4) | VARCHAR2(4) NOT NULL |
Case Visibility, used for cases and case objects/attributes.
A=All I=Internal |
| 7 | SELECT_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Field is a flag for selection .
Y/N Table Edit |
| 8 | LONG_URL | Long Character | CLOB | A long field to hold complete URL or File path name. |