Configuring the STHeader Calculated Field

STHeader is a calculated text field in the Banquet Event Order Report. STHeader combines the Service Start Time, Function Type, and Function Space or Location field values from your Siebel application. In STHeader, by default, StartTimeRep is the Function Time field in 24-hour format (00:00 to 23:59). You can replace StartTimeRep with SSTimeCalc, which is the Function Time field in 12-hour format (00:00 AM to 11:59 PM). SSTimeCalc identifies pre-noon times as AM and post-noon times as PM in all languages.

To replace the 24-hour time value display in STHeader with a 12-hour time display, follow this procedure.

This task is a step in Process of Converting the Banquet Event Order Report to a 12-Hour Format.

To configure the STHeader calculated field

1. Open Siebel Tools.

2. In the Object Explorer, select Business Component and query for TNT SHM Order Item.

3. In the TNT SHM Order Item business component, query for the STHeader field.

   The calculated value field appears as follows:

   '[Start Time Rep] + IIf ([Function Type] IS  NOT  NULL, '  '+[Function Type],'') + 
   IIf ([RFS] IS     NOT  NULL , '  '+[RFS], '')'
   

4. In the calculated value field, replace [Start Time Rep] with [SSTimeCalc].

   The value now appears as follows:

   '[SSTimeCalc] + IIf ([Function Type] IS  NOT  NULL, '  '+[Function Type],'') + IIf 
   ([RFS] IS     NOT  NULL , '  '+[RFS], '')'
   

5. Compile the TNT SHM Order Item business component to the SRF file.