Siebel Tools Reference > Special-Purpose Applets and Controls > File Attachment Applets >

Configuring Attachment Business Components


The Business Component property of the attachment list applet identifies the business component that the Siebel file system uses to store the attachment list data. For the Account Attachment Applet, this business component is called Account Attachment. The attachment business component must adhere to the following requirements:

The field names of file engine-supplied fields have to adhere to a special format, and map to specific column names in the attachment table. These names consist of the prefix, as specified in the DefaultPrefix user property, followed by a required set of suffixes. These field names, corresponding columns, and data types are listed in the Table 61.

Table 61. Fields in an Attachment Business Component
Name
Column
Type
Text Length
xxxFileAutoUpdFlg
FILE_AUTO_UPD_FLG
DTYPE_BOOL
1
xxxFileDate
FILE_DATE
DTYPE_DATETIME
 
xxxFileDeferFlg
FILE_DEFER_FLG
DTYPE_TEXT
1
xxxFileDockReqFlg
FILE_DOCK_REQ_FLG
DTYPE_TEXT
1
xxxFileDockStatFlg
FILE_DOCK_STAT_FLG
DTYPE_TEXT
1
xxxFileExt
FILE_EXT
DTYPE_TEXT
10
xxxFileName
FILE_NAME
DTYPE_TEXT
220
xxxFileRev
FILE_REV_NUM
DTYPE_ID
15
xxxFileSize
FILE_SIZE
DTYPE_NUMBER
 
xxxFileSrcPath
FILE_SRC_PATH
DTYPE_TEXT
220
xxxFileSrcType
FILE_SRC_TYPE
DTYPE_TEXT
30

Table 62 lists a non-file engine field that will usually be present, although it is not required.

Table 62. Non-File Engine Field in an Attachment Business Component
Name
Column
Type
Calculation
Dock Status
(calculated)
DTYPE_BOOL
IIf ([AccntFileDockStatFlg] = "N" OR [AccntFileDockStatFlg] IS NULL,"N","Y")

Additional fields can be included as needed. For specialized uses of attachments, such as an image control, the file engine fields may be present in addition to the fields from a standard business component (often through a join). For example, a Product or Literature business component can contain file engine fields to support display of product picture or brochure picture bitmap images.

Multiple sets of file engine fields from different tables can be incorporated in the same business component. For example, literature attachments can have sub-attachments, with the subattachments derived from an intersection table or extension table. The field name prefix must be different for each table.


 Siebel Tools Reference, Version 7.5, Rev. A 
 Published: 18 April 2003