Siebel Hospitality Guide > User Properties Reference for Siebel Hospitality > User Properties for Pivot Applets >
Virtual Business Component User Properties for Pivot Applets
This topic describes the following virtual business component user properties:
DCPivot Aggregation
This user property is used to aggregate the Total horizontally.
Value |
N |
Parent Object Type |
TNT SHM Property Pricing - FS Full Day Discount Pivot VBC The same user property is also available with different values in the following business components: TNT SHM Property Pricing - Function Space Pivot VBC TNT SHM Property Pricing - Sleeping Room Government Pivot VBC TNT SHM Property Pricing - Sleeping Room Pivot VBC TNT SHM Property Projected / Blocked |
Usage |
This user property is used to aggregate the Total values horizontally. This user property creates a row with the label Total and displays the total of all the attribute values in two separate rows. |
DCPivot Attribute List 3
This user property is used to specify one of the attributes to be displayed in the pivot applet for all the dynamic columns.
Value |
Maximum |
Parent Object Type |
TNT SHM Property Pricing - Sleeping Room Pivot VBC |
Usage |
This user property is used to specify one of the attributes to be displayed in the pivot applet for all the dynamic columns. |
DCPivot Attribute List 4
This user property is used to specify one of the attributes to be displayed in the pivot applet for all the dynamic columns.
Value |
Cost |
Parent Object Type |
TNT SHM Property Pricing - Sleeping Room Pivot VBC |
Usage |
This user property is used to specify one of the attributes to be displayed in the pivot applet for all the dynamic columns. |
DCPivot Attribute Read-Only List 0
This user property is used to specify a field in the pivot applet that is read only.
Value |
Rental |
Parent Object Type |
TNT SHM Property Pricing - FS Full Day Discount Pivot VBC The same user property is also available with different values in the following business components: TNT SHM Property Pricing - Function Space Pivot VBC TNT SHM Property Pricing - Sleeping Room Government Pivot VBC TNT SHM Property Pricing - Sleeping Room Pivot VBC TNT SHM Property Projected / Blocked |
Usage |
This user property is used to specify a field in the pivot applet that is read only. |
DCPivot Attribute Read-Only List 1
This user property is used to specify a field in the pivot applet that is read only.
Value |
Threshold |
Parent Object Type |
TNT SHM Property Pricing - FS Full Day Discount Pivot VBC The same user property is also available with different values in the following business components: TNT SHM Property Pricing - Function Space Pivot VBC TNT SHM Property Pricing - Sleeping Room Government Pivot VBC TNT SHM Property Pricing - Sleeping Room Pivot VBC TNT SHM Property Projected / Blocked |
Usage |
This user property is used to specify a field in the pivot applet that is read only. |
DCPivot Data BusComp Link
This user property specifies the name of the link.
Value |
SHM Site/TNT SHM Property Pricing - FS Full Day Discount |
Parent Object Type |
TNT SHM Property Pricing - FS Full Day Discount Pivot VBC TNT SHM Property Pricing - Function Space Pivot VBC TNT SHM Property Pricing - Sleeping Room Government Pivot VBC TNT SHM Property Pricing - Sleeping Room Pivot VBC TNT SHM Property Projected / Blocked |
Usage |
This user property specifies the name of the link. |
DCPivot DC Horizontal Totals
If the value of this user property is Y, a column named Total is created and displays the total of values for that record.
Value |
N |
Parent Object Type |
TNT SHM Property Pricing - FS Full Day Discount Pivot VBC The same user property is also available with different values in the following business components: TNT SHM Property Pricing - Function Space Pivot VBC TNT SHM Property Pricing - Sleeping Room Government Pivot VBC TNT SHM Property Pricing - Sleeping Room Pivot VBC TNT SHM Property Projected / Blocked |
Usage |
If the value of this user property is Y, a column named Total is created and displays the total of values for that record. |
DCPivot DC Vertical Totals
If the value of this user property is Y, a row labeled Total is created and displays the total of values for the attributes.
Value |
N |
Parent Object Type |
TNT SHM Property Pricing - FS Full Day Discount Pivot VBC The same user property is also available with different values in the following business components: TNT SHM Property Pricing - Function Space Pivot VBC TNT SHM Property Pricing - Sleeping Room Government Pivot VBC TNT SHM Property Pricing - Sleeping Room Pivot VBC TNT SHM Property Projected / Blocked |
Usage |
If the value of this user property is Y, a row labeled Total is created and displays the total of values for the attributes. |
DCPivot Group Key List 1
This user property is used to specify the grouping field.
Value |
Day Part Name |
Parent Object Type |
TNT SHM Property Pricing - FS Full Day Discount Pivot VBC The same user property is also available with different values in the following business components: TNT SHM Property Pricing - Function Space Pivot VBC TNT SHM Property Projected / Blocked |
Usage |
This user property is used to specify the grouping field. |
DCPivot Group Key List 2
This user property is used to specify the grouping field.
Value |
Rooms |
Parent Object Type |
TNT SHM Property Projected / Blocked |
Usage |
This user property is used to specify the grouping field. |
DCPivot Parent Search Field
This user property specifies the name of the parent business component field used for the search specification.
Value |
Search Sleeping Room Date |
Parent Object Type |
TNT SHM Property Pricing - FS Full Day Discount Pivot VBC The same user property is also available with different values in the following business components: TNT SHM Property Pricing - Function Space Pivot VBC TNT SHM Property Pricing - Sleeping Room Government Pivot VBC TNT SHM Property Pricing - Sleeping Room Pivot VBC TNT SHM Property Projected / Blocked |
Usage |
This user property specifies the name of the parent business component field used for the search specification. |
Field Read Only Field: Authorization Level
This user property sets a specific field in a business component to be read only.
Value |
Read Only - Authorization Level |
Parent Object Type |
TNT SHM FSI Auth Lvl |
Usage |
This user property sets a specific field in a business component to be read only. For more information about this user property, see the chapter on user properties in Siebel Developer's Reference. |
Sum BC Name
This user property specifies the name of the business component that is used to add up the field values specified by user properties such as Sum Field 1, Sum Field 2, and so on.
Value |
TNT SHM Quote Room Block Line Items Aggr |
Parent Object Type |
TNT SHM FSI Auth Lvl |
Usage |
This user property specifies the name of the business component that is used to add up the field values specified by user properties such as Sum Field 1, Sum Field 2, and so on. |
Sum Field 1
This user property specifies the name of the field for which to calculate a sum.
Value |
Blocked;Blocked |
Parent Object Type |
TNT SHM FSI Auth Lvl |
Usage |
This user property specifies the name of the field for which to calculate a sum. The first attribute is the field name in the business component specified by the Sum BC Name user property. The second attribute is the field name in the present business component. |
Sum Field 2
This user property specifies the name of the field for which to calculate a sum.
Value |
D/T1 Blocked;Blocked D/T1 |
Parent Object Type |
TNT SHM FSI Auth Lvl |
Usage |
This user property specifies the name of the field for which to calculate a sum. The first attribute is the field name in the business component specified by the Sum BC Name user property. The second attribute is the field name in the present business component. |
Sum Field 3
This user property specifies the name of the field for which to calculate a sum.
Value |
Picked Up;Picked Up |
Parent Object Type |
TNT SHM FSI Auth Lvl |
Usage |
This user property specifies the name of the field for which to calculate a sum. The first attribute is the field name in the business component specified by the Sum BC Name user property. The second attribute is the field name in the present business component. |
Sum Field 4
This user property specifies the name of the field for which to calculate a sum.
Value |
Projected;Projected |
Parent Object Type |
TNT SHM FSI Auth Lvl |
Usage |
This user property specifies the name of the field for which to calculate a sum. The first attribute is the field name in the business component specified by the Sum BC Name user property. The second attribute is the field name in the present business component. |
Sum Field 5
This user property specifies the name of the field for which to calculate a sum.
Value |
D/T1 Projected;Projected D/T1 |
Parent Object Type |
TNT SHM FSI Auth Lvl |
Usage |
This user property specifies the name of the field for which to calculate a sum. The first attribute is the field name in the business component specified by the Sum BC Name user property. The second attribute is the field name in the present business component. |
Sum Key Field 1
This user property is used to uniquely identify the records in the business component specified by the Sum BC Name user property.
Value |
Start Date |
Parent Object Type |
TNT SHM FSI Auth Lvl |
Usage |
This user property is used to uniquely identify the records in the business component specified by the Sum BC Name user property. |
Sum Key Field 2
This user property is used to uniquely identify the records in the business component specified by the Sum BC Name user property.
Value |
Room Id |
Parent Object Type |
TNT SHM FSI Auth Lvl |
Usage |
This user property is used to uniquely identify the records in the business component specified by the Sum BC Name user property. |
|