Bookshelf Home | Contents | Index | PDF     

Configuring Siebel Business Applications > Configuring Special-Purpose Applets > Customizing a File Attachment Applet >

Customizing an Attachment Table

An attachment table is a type of table that provides the underlying data storage for the attachment business component. Unlike the attachment business component, which can support purposes 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 drag and drop functionality or the browser dialog box in the corresponding file attachment applet to bring data into the empty table one file at a time.

Table 52 describes required file columns in an attachment table.

Table 52. 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

For the Name property, you must use the value described in Table 52. For the User Name property, you are not required to use the value described in Table 52.

Various system columns that are not related to the file engine are also 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.

    
Configuring Siebel Business Applications Copyright © 2011, Oracle and/or its affiliates. All rights reserved. Legal Notices.