Bookshelf Home | Contents | Index | PDF     

Configuring Siebel eBusiness Applications > Configuring Special Purpose Applets >

Configuring Attachment Tables

Attachment tables provide the underlying data storage for the attachment business components. Unlike the attachment business component, which can support purposes in addition to file engine functionality, the attachment table stores file engine data only.

Users will not populate the attachment table directly. Rather, users are provided with an initially empty attachment table, and populate it one file at a time using drag and drop or the browser dialog box in the corresponding file attachment applet.

Table 65 lists the columns that appear in an attachment table. Note that the columns whose names begin with FILE_ are required columns, and must be named as specified in the table. The User Name values can be the same as or different from those listed.

Table 65.  File Columns in an Attachment Table
Name
Default
User Name
Type
Physical Type
Length

FILE_AUTO_UPD_FLG

 

File Auto Upd Flg

Data (Public)

Character

1

FILE_DATE

 

File Date

Data (Public)

Date Time

 

FILE_DEFER_FLG

 

File Defer Flg

Data (Public)

Character

1

FILE_DOCK_REQ_FLG

 

File Dock Req Flg

Data (Public)

Character

1

FILE_DOCK_STAT_FLG

 

File Dock Stat Flg

Data (Public)

Character

1

FILE_EXT

 

File Ext

Data (Public)

Varchar

10

FILE_NAME

 

File Name

Data (Public)

Varchar

255

FILE_REV_NUM

0

File Rev Num

Data (Public)

Varchar

15

FILE_SIZE

 

File Size

Data (Public)

Number

22

FILE_SRC_PATH

 

File Src Path

Data (Public)

Varchar

255

FILE_SRC_TYPE

 

File Src Type

Data (Public)

Varchar

30

Various system columns not related to the file engine will also be present, such as CREATED, LAST_UPD_BY, and ROW_ID.

A table that has file engine columns must be flagged as such with a TRUE value in the File property of the corresponding table object definition.

    
Configuring Siebel eBusiness Applications