Siebel Hospitality Guide > User Properties Reference for Siebel Hospitality > User Properties for Pivot Applets >
Business Component User Properties for Pivot Applets
This topic describes the following business component user properties:
BC Name Field
This user property is used to store the name of a field defined in the business component.
Value |
BC Name |
Parent Object Type |
TNT SHM SR Inventory Dync |
Usage |
This user property is used to store the name of a field defined in the business component. For example, if a business component contains multiple data business components, BC Name is stored as multiple values that are derived from the respective data business components. For example, if this VBC contains multiple data business components, the respective data BC Names are stored in the BC Name field. |
BO Name Field
This user property is used to store the name of a field defined in the business component.
Value |
BO Name |
Parent Object Type |
TNT SHM SR Inventory Dync |
Usage |
This user property is used to store the name of a field defined in the business component. For example, if this VBC contains multiple data business objects, the respective data BO Names are stored in the BO Name field. |
Column Name Field
This user property is used to store the name of a field defined in the business component.
Value |
Column Name |
Parent Object Type |
TNT SHM SR Inventory Dync TNT SHM FSI Category Valid Authorization VBC |
Usage |
This user property is used to store the name of a field defined in the business component. In the specified business components, multiple columns are displayed in dynamic rows. For example, the corresponding Group Forecast, Group Authorized, and Capacity LOV values are displayed in the user interface. Consequently, this user property is used in code to temporarily read those values. |
Dyn Field Name Field
This user property is used to store the name of the dynamic field in the specified data business component.
Value |
Dyn Field Name |
Parent Object Type |
TNT SHM SR Inventory Dync |
Usage |
This user property is used to store the name of the dynamic field in the specified data business component. For example, in this business component, the dynamic field name is Start Date for all the data business components. |
Enable Single Button Toggle
This user property is used to enable or disable the functionality to switch the With Tentative/Without Tentative button between the two labels.
Value |
Y |
Parent Object Type |
TNT SHM SR Inventory Dync |
Usage |
When set to Y, this user property enables the functionality to switch the With Tentative/Without Tentative button between the two labels. When set to N, this user property disables the functionality to switch the With Tentative/Without Tentative button between the two labels. |
Method Name 1
This user property determines the value of the With Tentative/Without Tentative button label. This user property is a continuation of the Enable Single Button Toggle user property.
Value |
WithoutTentative |
Parent Object Type |
TNT SHM SR Inventory Dync |
Usage |
The With Tentative/Without Tentative button label is determined by the value of this user property. By default, the button label is the WithoutTentative LOV value, which displays the Without Tentative label on the button. You can configure more such buttons in the user interface and add more user properties such as Method Name 2 and so on. |
Undo Method Name 1
This user property changes the label of the With Tentative/Without Tentative button from Without Tentative to With Tentative. This user property is a continuation of the Method Name 1 user property.
Value |
WithTentative |
Parent Object Type |
TNT SHM SR Inventory Dync |
Usage |
When a user clicks the Without Tentative button, this user property calls the WithTentative method, which changes the button label to With Tentative. |
WithTentative:Undo Method Name
This user property changes the label of the With Tentative/Without Tentative button from With Tentative to Without Tentative. This user property is a continuation of the Undo Method Name 1 user property.
Value |
WithoutTentative |
Parent Object Type |
TNT SHM SR Inventory Dync |
Usage |
When a user clicks the With Tentative button, this user property calls the WithoutTentative method, which changes the button label to Without Tentative. |
WithoutTentative:Field Name
This user property runs the data business component specified by the value of the Tentative Flag field in the TNT SHM Quote Room Block Line Items Aggr business component.
Value |
Tentative Flag |
Parent Object Type |
TNT SHM SR Inventory Dync |
Usage |
The Tentative Flag field in the TNT SHM Quote Room Block Line Items Aggr business component has a value of Y for With Tentative and a value of N for Without Tentative. According to the Tentative Flag field value, this user property runs the appropriate data business component. |
WithoutTentative:Status
When the With Tentative/Without Tentative button is in Without Tentative display mode, this user property excludes records with a Status values of T1 and T2.
Value |
T1;T2; |
Parent Object Type |
TNT SHM SR Inventory Dync |
Usage |
When the With Tentative/Without Tentative button is in Without Tentative display mode, this user property excludes records with a Status values of T1 and T2 (that is, tentative records) from the display. |
WithoutTentative:Undo Method Name
When a user clicks the Without Tentative button, this user property changes the button label to With Tentative. This user property is a continuation of the WithTentative:Undo Method Name user property.
Value |
WithTentative; |
Parent Object Type |
TNT SHM SR Inventory Dync |
Usage |
When a user clicks the Without Tentative button, this user property changes the button label to With Tentative. The WithTentative method is called when a user clicks the button. |
Pivot 0 Aggregate Type
This user property is used to aggregate the Total values horizontally.
Value |
0 |
Parent Object Type |
TNT SHM SR Inventory Dync TNT SHM SR Total Avail Dync TNT SHM SR Total Avail Room Specific Dync TNT SHM SR Total Group Avail Dync TNT SHM SR Total Transient Avail Dync TNT SHM SR Type Dync - Group By Type TNT SHM FSI Category Valid Authorization VBC |
Usage |
This user property is used to aggregate the Total values horizontally. If the value of this user property is 1, it creates a row with the label Total and displays the total of all the attribute values in two separate rows. |
Pivot 0 BC Name
This user property contains the name of the business component in which the displayed data is stored.
Value |
TNT SHM FSI Auth Lvl |
Parent Object Type |
TNT SHM SR Inventory Dync TNT SHM SR Total Avail Dync TNT SHM SR Total Avail Room Specific Dync TNT SHM SR Total Group Avail Dync TNT SHM SR Total Transient Avail Dync TNT SHM SR Type Dync - Group By Type TNT SHM FSI Category Valid Authorization VBC |
Usage |
This user property contains the name of the business component in which the displayed data is stored. |
Pivot 0 BC Search Spec
This user property contains the search specification to apply to the business component in which the displayed data is stored.
Value |
([Room Type] = LookupValue(PRODUCT_TYPE, 'Sleeping Room') OR [Room Type] = LookupValue(PRODUCT_TYPE, 'ROH Sleeping Room')) |
Parent Object Type |
TNT SHM SR Inventory Dync The same user property is also available with different values in the following business components: TNT SHM SR Total Avail Dync TNT SHM SR Total Avail Room Specific Dync TNT SHM SR Total Group Avail Dync TNT SHM SR Total Transient Avail Dync TNT SHM SR Type Dync - Group By Type TNT SHM FSI Category Valid Authorization VBC |
Usage |
This user property contains the search specification to apply to the business component in which the displayed data is stored. |
Pivot 0 BC Sort Spec
This user property contains the sort specification to apply to the business component in which the displayed data is stored.
Value |
Start Date, Room Type (DESCENDING), Room Name |
Parent Object Type |
TNT SHM SR Inventory Dync |
Usage |
This user property contains the sort specification to apply to the business component in which the displayed data is stored. |
Pivot 0 BO Name
This user property contains the name of the business object that contains the business component in which the displayed data is stored.
Value |
SHM Site |
Parent Object Type |
TNT SHM SR Inventory Dync TNT SHM SR Total Avail Dync TNT SHM SR Total Avail Room Specific Dync TNT SHM SR Total Group Avail Dync TNT SHM SR Total Transient Avail Dync TNT SHM SR Type Dync - Group By Type TNT SHM FSI Category Valid Authorization VBC |
Usage |
This user property contains the name of the business object that contains the business component in which the displayed data is stored. |
Pivot 0 Can Update
This user property sets the various column values in dynamic rows.
Value |
Y |
Parent Object Type |
TNT SHM SR Inventory Dync |
Usage |
This user property sets the various column values in dynamic rows. |
Pivot 0 Dynamic Field
This user property specifies a field, the value of which is displayed as dynamic columns.
Value |
StartDate |
Parent Object Type |
TNT SHM SR Inventory Dync TNT SHM SR Total Avail Dync TNT SHM SR Total Avail Room Specific Dync TNT SHM SR Total Group Avail Dync TNT SHM SR Total Transient Avail Dync TNT SHM SR Type Dync - Group By Type TNT SHM FSI Category Valid Authorization VBC |
Usage |
This user property specifies a field, the value of which is displayed as dynamic columns. This field is present in the data business component. |
Pivot 0 Group Field
This user property specifies the data business component field, the value of which is used to group the data in the applet.
Value |
Room Name |
Parent Object Type |
TNT SHM SR Inventory Dync TNT SHM SR Total Avail Dync TNT SHM SR Total Avail Room Specific Dync TNT SHM SR Total Group Avail Dync TNT SHM SR Total Transient Avail Dync TNT SHM SR Type Dync - Group By Type TNT SHM FSI Category Valid Authorization VBC |
Usage |
This user property specifies the data business component field, the value of which is used to group the data in the applet. |
Pivot 0 Parent Filter Field 0
This user property is used to apply the parent search specification to the data business component.
Value |
Date;Search Sleeping Room Date |
Parent Object Type |
TNT SHM SR Inventory Dync TNT SHM SR Total Avail Dync TNT SHM SR Total Avail Room Specific Dync TNT SHM SR Total Group Avail Dync TNT SHM SR Total Transient Avail Dync TNT SHM SR Type Dync - Group By Type |
Usage |
This user property is used to apply the parent search specification to the data business component. The value of the Search Sleeping Room Date field in the SHM Site business component is used to apply the search specification. |
Pivot 0 Parent Filter Field 1
This user property is used to apply the parent search specification to the data business component.
Value |
Day Of Week;Search Day Of Week |
Parent Object Type |
TNT SHM SR Inventory Dync The same user property is also available with different values in the following business components: TNT SHM SR Total Avail Room Specific Dync TNT SHM SR Type Dync - Group By Type |
Usage |
This user property is used to apply the parent search specification to the data business component. For example, the value of the Search Day Of Week field in the SHM Site business component is used to apply the search specification. |
Pivot 0 Type 0
This user property specifies the attributes that are displayed in the applet.
Value |
Total Group Available;1;Total Group Available;1 |
Parent Object Type |
TNT SHM SR Inventory Dync The same user property is also available with different values in the following business components: TNT SHM SR Total Avail Dync TNT SHM SR Total Avail Room Specific Dync TNT SHM SR Total Group Avail Dync TNT SHM SR Total Transient Avail Dync TNT SHM SR Type Dync - Group By Type TNT SHM FSI Category Valid Authorization VBC |
Usage |
This user property specifies the attributes that are displayed in the applet. The first argument indicates the LOV value to be displayed in the user interface as an attribute. The second argument identifies the data business component field name. |
Pivot 0 Type 1
This user property specifies the attributes that are displayed in the applet.
Value |
Group Optimal;1;Optimal Level;1 |
Parent Object Type |
TNT SHM SR Inventory Dync The same user property is also available with different values in the following business components: TNT SHM SR Total Avail Dync TNT SHM SR Total Avail Room Specific Dync TNT SHM SR Total Group Avail Dync TNT SHM SR Total Transient Avail Dync TNT SHM SR Type Dync - Group By Type TNT SHM FSI Category Valid Authorization VBC |
Usage |
This user property specifies the attributes that are displayed in the applet. The first argument indicates the LOV value to be displayed in the user interface as an attribute. The second argument identifies the data business component field name. |
Pivot 0 Type 2
This user property specifies the attributes that are displayed in the applet.
Value |
Capacity;0;Room Capacity;0 |
Parent Object Type |
TNT SHM SR Inventory Dync The same user property is also available with different values in the following business components: TNT SHM SR Total Avail Dync TNT SHM SR Total Avail Room Specific Dync TNT SHM SR Total Group Avail Dync TNT SHM SR Total Transient Avail Dync TNT SHM SR Type Dync - Group By Type |
Usage |
This user property specifies the attributes that are displayed in the applet. The first argument indicates the LOV value to be displayed in the user interface as an attribute. The second argument identifies the data business component field name. |
Pivot 0 Type 3
This user property specifies the attributes that are displayed in the applet.
Value |
Transient Booked;0;Transient Booked;0 |
Parent Object Type |
TNT SHM SR Inventory Dync The same user property is also available with different values in the following business components: TNT SHM SR Total Avail Dync TNT SHM SR Total Avail Room Specific Dync TNT SHM SR Total Group Avail Dync TNT SHM SR Total Transient Avail Dync TNT SHM SR Type Dync - Group By Type |
Usage |
This user property specifies the attributes that are displayed in the applet. The first argument indicates the LOV value to be displayed in the user interface as an attribute. The second argument identifies the data business component field name. |
Pivot 0 Type 4
This user property specifies the attributes that are displayed in the applet.
Value |
Total Group Available;1;Total Group Available;1 |
Parent Object Type |
TNT SHM SR Inventory Dync The same user property is also available with different values in the following business components: TNT SHM SR Total Avail Dync TNT SHM SR Total Avail Room Specific Dync TNT SHM SR Total Group Avail Dync TNT SHM SR Total Transient Avail Dync TNT SHM SR Type Dync - Group By Type |
Usage |
This user property specifies the attributes that are displayed in the applet. The first argument indicates the LOV value to be displayed in the user interface as an attribute. The second argument identifies the data business component field name. |
Pivot 1 Aggregate Type
This user property is used to aggregate the Total horizontally.
Value |
0 |
Parent Object Type |
TNT SHM SR Inventory Dync TNT SHM SR Total Avail Dync TNT SHM SR Total Avail Room Specific Dync TNT SHM SR Total Group Avail Dync TNT SHM SR Total Transient Avail Dync |
Usage |
This user property is used to aggregate the Total values horizontally. If the value of this user property is 1, it creates a row with the label Total and displays the total of all the attribute values in two separate rows. |
Pivot 1 BC Name
This user property contains the name of the business component in which the displayed data is stored.
Value |
TNT SHM Quote Room Block Line Items Aggr |
Parent Object Type |
TNT SHM SR Inventory Dync TNT SHM SR Total Avail Dync TNT SHM SR Total Avail Room Specific Dync TNT SHM SR Total Group Avail Dync TNT SHM SR Total Transient Avail DyncUsage |
Usage |
This user property contains the name of the business component in which the displayed data is stored. |
Pivot 1 BC Search Spec
This user property contains the search specification to apply to the business component in which the displayed data is stored.
Value |
([Room Type] = LookupValue(PRODUCT_TYPE, 'Sleeping Room') OR [Room Type] = LookupValue(PRODUCT_TYPE, 'ROH Sleeping Room')) |
Parent Object Type |
TNT SHM SR Inventory Dync The same user property is also available with different values in the following business components: TNT SHM SR Total Avail Dync TNT SHM SR Total Avail Room Specific Dync TNT SHM SR Total Group Avail Dync TNT SHM SR Total Transient Avail Dync |
Usage |
This user property contains the search specification to apply to the business component in which the displayed data is stored. |
Pivot 1 BO Name
This user property contains the name of the business object that contains the business component in which the displayed data is stored.
Value |
Quote |
Parent Object Type |
TNT SHM SR Inventory Dync TNT SHM SR Total Avail Dync TNT SHM SR Total Avail Room Specific Dync TNT SHM SR Total Group Avail Dync TNT SHM SR Total Transient Avail Dync |
Usage |
This user property contains the name of the business object that contains the business component in which the displayed data is stored. |
Pivot 1 Dynamic Field
This user property specifies a field, the value of which is displayed as dynamic columns.
Value |
Start Date |
Parent Object Type |
TNT SHM SR Inventory Dync TNT SHM SR Total Avail Dync TNT SHM SR Total Avail Room Specific Dync TNT SHM SR Total Group Avail Dync TNT SHM SR Total Transient Avail Dync |
Usage |
This user property specifies a field, the value of which is displayed as dynamic columns. This field is present in the data business component. |
Pivot 1 Group Field
This user property is used to specify a data business component field, the value of which is used to group the data in the applet.
Value |
Status |
Parent Object Type |
TNT SHM SR Inventory Dync TNT SHM SR Total Avail Dync TNT SHM SR Total Avail Room Specific Dync TNT SHM SR Total Transient Avail Dync |
Usage |
This user property is used to specify a data business component field, the value of which is used to group the data in the applet. |
Pivot 1 Parent Filter Field 0
This user property is used to apply the parent search specification to the data business component.
Value |
Date;Search Sleeping Room Date |
Parent Object Type |
TNT SHM SR Inventory Dync TNT SHM SR Total Avail Dync TNT SHM SR Total Avail Room Specific Dync TNT SHM SR Total Group Avail Dync TNT SHM SR Total Transient Avail Dync |
Usage |
This user property is used to apply the parent search specification to the data business component. The value of the Search Sleeping Room Date field in the SHM Site business component is used to apply the search specification to the data business component. |
Pivot 1 Parent Filter Field 1
This user property is used to apply the parent search specification to the data business component.
Value |
Day Of Week;Search Day Of Week |
Parent Object Type |
TNT SHM SR Inventory Dync The same user property is also available with different values in the TNT SHM SR Total Avail Room Specific Dync business component. |
Usage |
This user property is used to apply the parent search specification to the data business component. For example, the value of the Search Day Of Week field in the SHM Site business component is used to apply search specification to the data business component. |
Pivot 1 Type 0
This user property specifies the attributes that are displayed in the applet.
Value |
Group Blocked;1;Exact Blocked;1 |
Parent Object Type |
TNT SHM SR Inventory Dync The same user property is also available with different values in the following business components: TNT SHM SR Total Avail Dync TNT SHM SR Total Avail Room Specific Dync TNT SHM SR Total Group Avail Dync TNT SHM SR Total Transient Avail Dync |
Usage |
This user property specifies the attributes that are displayed in the applet. The first argument indicates the LOV value to be displayed in the user interface as an attribute. The second argument identifies the data business component field name. |
Pivot 1 Type 0 Sub Group 0
This user property is used to create subgroups.
Value |
Definite/Hold;[Status]=LookupValue("TNT_FUNC_STATUS","Definite") OR [Status]=LookupValue("TNT_FUNC_STATUS","Hold") |
Parent Object Type |
TNT SHM SR Inventory Dync |
Usage |
This user property is used for sub-grouping. This user property is used in conjunction with the Pivot 1 Type 0 user property to create subgroups of the dynamic records. |
Pivot 1 Type 1
This user property specifies the attributes that are displayed in the applet.
Value |
Group Picked Up;0;Picked Up;0 |
Parent Object Type |
TNT SHM SR Inventory Dync The same user property is also available with different values in the following business components: TNT SHM SR Total Avail Dync TNT SHM SR Total Avail Room Specific Dync TNT SHM SR Total Group Avail Dync TNT SHM SR Total Transient Avail Dync |
Usage |
This user property specifies the attributes that are displayed in the applet. The first argument indicates the LOV value to be displayed in the user interface as an attribute. The second argument identifies the data business component field name. |
Pivot 1 Type 2
This user property specifies the attributes that are displayed in the applet.
Value |
Group Projected;1;Exact Projected;1 |
Parent Object Type |
TNT SHM SR Inventory Dync The same user property is also available with different values in the following business components: TNT SHM SR Total Avail Dync TNT SHM SR Total Avail Room Specific Dync TNT SHM SR Total Group Avail Dync |
Usage |
This user property specifies the attributes that are displayed in the applet. The first argument indicates the LOV value to be displayed in the user interface as an attribute. The second argument identifies the data business component field name. |
Pivot 1 Type 2 Sub Group 0
This user property is used to create subgroups.
Value |
Definite/Hold;[Status]=LookupValue("TNT_FUNC_STATUS","Definite") OR [Status]=LookupValue("TNT_FUNC_STATUS","Hold") |
Parent Object Type |
TNT SHM SR Inventory Dync |
Usage |
This user property is used for sub-grouping. This user property is used in conjunction with the Pivot 1 Type 2 user property to create subgroups of the dynamic records. |
Pivot 2 Aggregate Type
This user property is used to aggregate the Total horizontally.
Value |
0 |
Parent Object Type |
TNT SHM SR Inventory Dync |
Usage |
This user property is used to aggregate the Total values horizontally. If the value of this user property is 1, it creates a row with the label Total and displays the total of all the attribute values in two separate rows. |
Pivot 2 BC Name
This user property contains the name of the business component in which the displayed data is stored.
Value |
TNT SHM FSI Auth Lvl |
Parent Object Type |
TNT SHM SR Inventory Dync |
Usage |
This user property contains the name of the business component in which the displayed data is stored. |
Pivot 2 BC Search Spec
This user property contains the search specification to apply to the business component in which the displayed data is stored.
Value |
([Room Type] = LookupValue(PRODUCT_TYPE, 'Sleeping Room') OR [Room Type] = LookupValue(PRODUCT_TYPE, 'ROH Sleeping Room')) |
Parent Object Type |
TNT SHM SR Inventory Dync |
Usage |
This user property contains the search specification to apply to the business component in which the displayed data is stored. |
Pivot 2 BO Name
This user property contains the name of the business object that contains the business component in which the displayed data is stored.
Value |
SHM Site |
Parent Object Type |
TNT SHM SR Inventory Dync |
Usage |
This user property contains the name of the business object that contains the business component in which the displayed data is stored. |
Pivot 2 Dynamic Field
This user property specifies a field, the value of which is displayed as dynamic columns.
Value |
Start Date |
Parent Object Type |
TNT SHM SR Inventory Dync |
Usage |
This user property specifies a field, the value of which is displayed as dynamic columns. This field is present in the data business component. |
Pivot 2 Group Field
This user property is used to specify a data business component field, the value of which is used to group the data in the applet.
Value |
Room Name |
Parent Object Type |
TNT SHM SR Inventory Dync |
Usage |
This user property is used to specify a data business component field, the value of which is used to group the data in the applet. |
Pivot 2 Parent Filter Field 0
This user property is used to apply the parent search specification to the data business component.
Value |
Date;Search Sleeping Room Date |
Parent Object Type |
TNT SHM SR Inventory Dync |
Usage |
This user property is used to apply the parent search specification to the data business component. The value of the Search Sleeping Room Date field in the SHM Site business component is used to apply the search specification to the data business component. |
Pivot 2 Parent Filter Field 1
This user property is used to apply the parent search specification to the data business component.
Value |
Day Of Week;Search Day Of Week |
Parent Object Type |
TNT SHM SR Inventory Dync |
Usage |
This user property is used to apply the parent search specification to the data business component. For example, the value of the Search Day Of Week field in the SHM Site business component is used to apply the search specification to the data business component. |
Pivot 2 Type 0
This user property specifies the attributes that are displayed in the applet.
Value |
Group Authorized;1;Authorization Level;1 |
Parent Object Type |
TNT SHM SR Inventory Dync |
Usage |
This user property specifies the attributes that are displayed in the applet. The first argument indicates the LOV value to be displayed in the user interface as an attribute. The second argument identifies the data business component field name. |
Pivot 2 Type 1
This user property specifies the attributes that are displayed in the applet.
Value |
Group Optimal;1;Optimal Level;1 |
Parent Object Type |
TNT SHM SR Inventory Dync |
Usage |
This user property specifies the attributes that are displayed in the applet. The first argument indicates the LOV value to be displayed in the user interface as an attribute. The second argument identifies the data business component field name. |
Pivot 2 Type 2
This user property specifies the attributes that are displayed in the applet.
Value |
Capacity;0;Room Capacity;0 |
Parent Object Type |
TNT SHM SR Inventory Dync |
Usage |
This user property specifies the attributes that are displayed in the applet. The first argument indicates the LOV value to be displayed in the user interface as an attribute. The second argument identifies the data business component field name. |
Pivot 2 Type 3
This user property specifies the attributes that are displayed in the applet.
Value |
Transient Booked;0;Transient Booked;0 |
Parent Object Type |
TNT SHM SR Inventory Dync |
Usage |
This user property specifies the attributes that are displayed in the applet. The first argument indicates the LOV value to be displayed in the user interface as an attribute. The second argument identifies the data business component field name. |
Pivot Calc Type 0
This user property is used to create records for specialized calculated row types from an already-aggregated value.
Value |
Total Group Available |
Parent Object Type |
TNT SHM SR Inventory Dync The same user property is also available with different values in the following business components: TNT SHM SR Total Avail Dync TNT SHM SR Total Avail Room Specific Dync TNT SHM SR Total Group Avail Dync TNT SHM SR Total Transient Avail Dync |
Usage |
This user property is used to create records for specialized calculated row types from an already-aggregated value. The calculated expression can be given as a value, or as the calculated business component field name from the data business component. |
Pivot Date Range
This user property is used to specify the date range.
Value |
7 |
Parent Object Type |
TNT SHM SR Inventory Dync TNT SHM SR Total Avail Dync TNT SHM SR Total Avail Room Specific Dync TNT SHM SR Total Group Avail Dync TNT SHM SR Total Transient Avail Dync TNT SHM SR Type Dync - Group By Type TNT SHM FSI Category Valid Authorization VBC |
Usage |
This user property is used to specify the date range. The value 7 means that the pivot applet displays the dynamic date columns for the next seven dates. In other words, the display shows the current date plus the next seven dates. |
Pivot Dynamic Field Format
This user property specifies the display format of the dynamic field.
Value |
%a %d %b, %y |
Parent Object Type |
TNT SHM SR Inventory Dync TNT SHM SR Type Dync - Group By Type |
Usage |
This user property specifies the display format of the dynamic field. The dynamic field is Start Date, which is displayed in the format {Sun 21 Nov, 10}. If the value of this user property is [%a %m/%d/%y], the Start Date field value is displayed in the format {Sun 11/21/10}. |
Pivot LOV Type
This user property specifies the LOV Type used for various attributes that are displayed in the pivot applet.
Value |
TNT_SHM_SR_AVAIL_PIVOT |
Parent Object Type |
TNT SHM SR Inventory Dync The same user property is also available with different values in the following business components: TNT SHM FSI Category Valid Authorization VBC TNT SHM SR Inventory Dync TNT SHM SR Total Avail Dync TNT SHM SR Total Avail Room Specific Dync TNT SHM SR Total Group Avail Dync TNT SHM SR Total Transient Avail Dync TNT SHM SR Type Dync - Group By Type |
Usage |
This user property specifies the LOV Type used for various attributes that are displayed in the pivot applet. |
Pivot Static Field 0
This user property specifies the fields in the pivot business component that are mapped with applet list columns.
Value |
Type |
Parent Object Type |
TNT SHM SR Inventory Dync TNT SHM SR Total Avail Dync TNT SHM SR Total Avail Room Specific Dync TNT SHM SR Total Group Avail Dync TNT SHM SR Total Transient Avail Dync TNT SHM SR Type Dync - Group By Type TNT SHM FSI Category Valid Authorization VBC |
Usage |
This user property specifies the fields in the pivot business component that are mapped with applet list columns. |
Pivot Static Field 1
This user property specifies the fields in the pivot business component that are mapped with applet list columns.
Value |
Property ID |
Parent Object Type |
TNT SHM SR Inventory Dync TNT SHM SR Total Avail Dync TNT SHM SR Total Avail Room Specific Dync TNT SHM SR Total Group Avail Dync TNT SHM SR Total Transient Avail Dync TNT SHM SR Type Dync - Group By Type TNT SHM FSI Category Valid Authorization VBC |
Usage |
This user property specifies the fields in the pivot business component that are mapped with applet list columns. |
Pivot Static Field 2
This user property specifies the fields in the pivot business component that are mapped with applet list columns.
Value |
Date |
Parent Object Type |
TNT SHM SR Inventory Dync TNT SHM SR Total Avail Dync TNT SHM SR Total Avail Room Specific Dync TNT SHM SR Total Group Avail Dync TNT SHM SR Total Transient Avail Dync TNT SHM SR Type Dync - Group By Type TNT SHM FSI Category Valid Authorization VBC |
Usage |
This user property specifies the fields in the pivot business component that are mapped with applet list columns. |
Room Name Field
This user property is used to store the name of a field defined in the business component.
Value |
Room Name |
Parent Object Type |
TNT SHM SR Inventory Dync TNT SHM FSI Category Valid Authorization VBC |
Usage |
This user property is used to store the name of a field defined in the business component. While displaying records in the pivot applet, this variable is used to store room block names. |
Total Availability Applet Name
This user property specifies the name of the applet that displays the pivot records.
Value |
TNT SHM SR Inventory Display Dync List Applet - Total Availability |
Parent Object Type |
TNT SHM SR Inventory Dync |
Usage |
This user property specifies the name of the applet that displays the pivot records. |
Pivot Calc Type 1
This user property is used to create records for specialized calculated row types from an already-aggregated value.
Value |
Total Booked |
Parent Object Type |
TNT SHM SR Total Avail Dync |
Usage |
This user property is used to create records for specialized calculated row types from an already-aggregated value. The calculated expression can be given as a value, or as the calculated business component field name from the data business component. |
Pivot Calc Type 2
This user property is used to create records for specialized calculated row types from an already-aggregated value.
Value |
Total Available |
Parent Object Type |
TNT SHM SR Total Avail Dync |
Usage |
This user property is used to create records for specialized calculated row types from an already-aggregated value. The calculated expression can be given as a value, or as the calculated business component field name from the data business component. |
Pivot Calc Type 3
This user property is used to create records for specialized calculated row types from an already-aggregated value.
Value |
Occupied Percent |
Parent Object Type |
TNT SHM SR Total Avail Dync |
Usage |
This user property is used to create records for specialized calculated row types from an already-aggregated value. The calculated expression can be given as a value, or as the calculated business component field name from the data business component. |
Pivot Calc Type 4
This user property is used to create records for specialized calculated row types from an already-aggregated value.
Value |
Actual Available |
Parent Object Type |
TNT SHM SR Total Avail Dync |
Usage |
This user property is used to create records for specialized calculated row types from an already-aggregated value. The calculated expression can be given as a value, or as the calculated business component field name from the data business component. |
Pivot 0 Group by Group Field
If the value of this user property is Y, then the field specified by the Pivot 0 Group Field is used for grouping.
Value |
Y |
Parent Object Type |
TNT SHM SR Total Avail Room Specific Dync TNT SHM SR Type Dync - Group By Type |
Usage |
If the value of this user property is Y, then the field specified by the Pivot 0 Group Field is used for grouping, rather than the Pivot 0 Type 0 values. |
Pivot 0 Type 5
This user property specifies the attributes that are displayed in the applet.
Value |
Group Projected;1;Projected;1 |
Parent Object Type |
TNT SHM SR Type Dync - Group By Type |
Usage |
This user property specifies the attributes that are displayed in the applet. The first argument indicates the LOV value to be displayed in the user interface as an attribute. The second argument identifies the data business component field name. |
Pivot 0 Type 6
This user property specifies the attributes that are displayed in the applet.
Value |
Definite/T1 Projected;1;Projected D/T1;1 |
Parent Object Type |
TNT SHM SR Type Dync - Group By Type |
Usage |
This user property specifies the attributes that are displayed in the applet. The first argument indicates the LOV value to be displayed in the user interface as an attribute. The second argument identifies the data business component field name. |
Pivot 0 Type 7
This user property specifies the attributes that are displayed in the applet.
Value |
Group Picked Up;1;Picked Up;1 |
Parent Object Type |
TNT SHM SR Type Dync - Group By Type |
Usage |
This user property specifies the attributes that are displayed in the applet. The first argument indicates the LOV value to be displayed in the user interface as an attribute. The second argument identifies the data business component field name. |
Pivot 0 Type 8
This user property specifies the attributes that are displayed in the applet.
Value |
Total Group Available;1;Total Group Available;1 |
Parent Object Type |
TNT SHM SR Type Dync - Group By Type |
Usage |
This user property specifies the attributes that are displayed in the applet. The first argument indicates the LOV value to be displayed in the user interface as an attribute. The second argument identifies the data business component field name. |
Pivot Static Field 3
This user property specifies the fields in the pivot business component that are mapped with applet list columns.
Value |
Group field |
Parent Object Type |
TNT SHM SR Type Dync - Group By Type |
Usage |
This user property specifies the fields in the pivot business component that are mapped with applet list columns. |
DCPivot Attribute LOV Name
This user property specifies the LOV Type used for various attributes that are displayed in the pivot applet.
Value |
TNT_SHM_DYNC_PIVOT_ATTRIB |
Parent Object Type |
TNT SHM Function Space Inventory Dynamic Pivot The same user property is also available with different values in the following business components: 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 LOV Type used for various attributes that are displayed in the pivot applet. |
DCPivot Attribute List 0
This user property is used to specify the first attribute to be displayed in the pivot applet for all the dynamic columns.
Value |
Authorization Level |
Parent Object Type |
TNT SHM Function Space Inventory Dynamic Pivot The same user property is also available with different values in the following business components: 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 is used to specify the first attribute to be displayed in the pivot applet for all the dynamic columns. The display value from the TNT_SHM_DYNC_PIVOT_ATTRIB LOV Type for this value is used as the attribute. |
DCPivot Attribute List 1
This user property is used to specify the second attribute to be displayed in the pivot applet for all the dynamic columns.
Value |
Max Overbook Level |
Parent Object Type |
TNT SHM Function Space Inventory Dynamic Pivot The same user property is also available with different values in the following business components: 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 is used to specify the second attribute to be displayed in the pivot applet for all the dynamic columns. The display value from the TNT_SHM_DYNC_PIVOT_ATTRIB LOV Type for this value is used as the attribute. |
DCPivot Attribute List 2
This user property is used to specify the third attribute to be displayed in the pivot applet for all the dynamic columns.
Value |
Max Option Level |
Parent Object Type |
TNT SHM Function Space Inventory Dynamic Pivot The same user property is also available with different values in the following business components: TNT SHM Property Pricing - Sleeping Room Pivot VBC |
Usage |
This user property is used to specify the third attribute to be displayed in the pivot applet for all the dynamic columns. The display value from the TNT_SHM_DYNC_PIVOT_ATTRIB LOV Type for this value is used as the attribute. |
DCPivot DC Field Format
This user property is used to specify the display format of the dynamic field.
Value |
%a %d %b, %y |
Parent Object Type |
TNT SHM Function Space Inventory Dynamic Pivot 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 is used to specify the display format of the dynamic field. The dynamic field is Start Date, which is displayed in the format {Sun 21 Nov, 10}. If the value of this user property is [%a %m/%d/%y], the Start Date field value is displayed in the format {Sun 11/21/10}. |
DCPivot DC Set Size
This user property is used to control the number of date columns that are displayed.
Value |
8 |
Parent Object Type |
TNT SHM Function Space Inventory Dynamic Pivot 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 is used to control the number of date columns that are displayed. This user property displays columns from the current date plus this value. When the value of this user property is 8, the view displays nine columns, one for the current date and one for each of the eight subsequent dates. |
DCPivot DC Totals Field
This user property is used in conjunction with the DCPivot DC Vertical Totals user property.
Value |
Rooms |
Parent Object Type |
TNT SHM Function Space Inventory Dynamic Pivot The same user property is also available with different values in the following business components: 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 is used with conjunction of the DCPivot DC Vertical Totals user property. If this user property and the DCPivot DC Vertical Totals user property are both set to Y, a vertical row is created for Total with the label Total in one of the cells. |
DCPivot DC Unit Size
This user property is used to calculate the date range.
Value |
1 |
Parent Object Type |
TNT SHM Function Space Inventory Dynamic Pivot 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 is used to calculate the date range. The value of this user property indicates what the next dynamic column will be. If the value of this user property is 1, the difference between the date columns is one day. |
DCPivot Data BusComp
This user property contains the name of the business component in which the displayed data is stored.
Value |
TNT SHM FSI Auth Lvl |
Parent Object Type |
TNT SHM Function Space Inventory Dynamic Pivot The same user property is also available with different values in the following business components: 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 contains the name of the business component in which the displayed data is stored. |
DCPivot Data Search Spec
This user property contains the search specification to apply to the business component in which the displayed data is stored.
Value |
[Room Type] <> LookupValue('PRODUCT_TYPE', 'Sleeping Room') |
Parent Object Type |
TNT SHM Function Space Inventory Dynamic Pivot The same user property is also available in the following business components that have the following value: ([Inventory Status] = LookupValue("TNT_SHM_INV_STATUS", "Actualized") OR [Inventory Status] = LookupValue("TNT_SHM_INV_STATUS", "Reserved")) 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 contains the search specification to apply to the business component in which the displayed data is stored. |
DCPivot Default DC DataType
This user property specifies the default data type for dynamic columns.
Value |
10 |
Parent Object Type |
TNT SHM Function Space Inventory Dynamic Pivot 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 default data type for dynamic columns. |
DCPivot Default DC FieldName
This user property specifies the default dynamic field name for dynamic columns.
Value |
Start Date |
Parent Object Type |
TNT SHM Function Space Inventory Dynamic Pivot The same user property is also available with different values in the following business components: 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 default dynamic field name for dynamic columns. |
DCPivot Group Key List 0
This user property is used to specify a data business component field, the value of which is used to group the data in the applet.
Value |
Room Name |
Parent Object Type |
TNT SHM Function Space Inventory Dynamic Pivot The same user property is also available with different values in the following business components: 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 is used to specify a data business component field, the value of which is used to group the data in the applet. |
DCPivot Update Primary BC
If this user property is set to Y, it goes through each column of the current virtual record, reads the value of each cell, and updates the value that corresponds to the data business component.
Value |
Y |
Parent Object Type |
TNT SHM Function Space Inventory Dynamic Pivot The same user property is also available with different values in the following business components: 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 |
Usage |
If this user property is set to Y, it goes through each column of the current virtual record, reads the value of each cell, and updates the value that corresponds to the data business component. |
TNT AvoidBookmark
This user property is related to printing functionality.
Value |
Y |
Parent Object Type |
TNT SHM Function Space Inventory Dynamic Pivot TNT SHM Property Projected / Blocked |
Usage |
This user property is related to printing functionality. In the case of dynamic data, this user property is used to avoid the re-execution of the business component and to maintain the context of the dynamic data. |
|