Configuring an Attachment Table
An attachment table is a type of table that provides the underlying data storage for the attachment business component. The attachment business component can support uses in addition to file engine functionality. The attachment table stores only file engine data.
The user does not directly update the attachment table. Siebel CRM provides the user an empty attachment table. The user then uses the relocate functionality, using the mouse, or the browser dialog box in the corresponding file attachment applet to bring data into the empty table one file at a time.
The following table describes required file columns in an attachment table.
| Name | Default | User Name | Type | Physical Type | Length |
|---|---|---|---|---|---|
FILE_AUTO_UPD_FLG |
N |
File Auto Upd Flg |
Data (Public) |
Character |
1 |
FILE_DATE |
None |
File Date |
Data (Public) |
Date Time |
7 |
FILE_DEFER_FLG |
R |
File Defer Flg |
Data (Public) |
Character |
1 |
FILE_DOCK_REQ_FLG |
N |
File Dock Req Flg |
Data (Public) |
Character |
1 |
FILE_DOCK_STAT_FLG |
N |
File Dock Stat Flg |
Data (Public) |
Character |
1 |
FILE_EXT |
None |
File Ext |
Data (Public) |
Varchar |
10 |
FILE_NAME |
None |
File Name |
Data (Public) |
Varchar |
200 |
FILE_REV_NUM |
0 |
File Rev Num |
Data (Public) |
Varchar |
15 |
FILE_SIZE |
None |
File Size |
Data (Public) |
Number |
22 |
FILE_SRC_PATH |
None |
File Src Path |
Data (Public) |
Varchar |
255 |
FILE_SRC_TYPE |
None |
File Src Type |
Data (Public) |
Varchar |
30 |
You must use the value described in the previous table for the Name property. You are not required to use the value described in the previous table for the User Name property.
Various system columns that are not related to the file engine are present, such as CREATED, LAST_UPD_BY, and ROW_ID.
If the table includes a file engine column, then you must make sure the File property in the corresponding table is TRUE.