Siebel Hospitality Guide > Managing Property-Specific Menus and Packages > Menu and Package Types Reference >

Package Item Price Reference


In a Package Item Price, pricing occurs on a unit basis. The Total Header Price is not displayed on the Event Order Report or in the Siebel Hospitality UI. The child line item prices are displayed on the BEO Report. Discounts are applied to individual child line items, and their net results will be displayed through the Unit Net Price.

Package Item Price Example

A typical example of an item price package is a Cash Bar. As shown in Table 47, the Unit Net Price, Extended Price, Discount %, Net Discount, and Per Person Allocation fields are Null and read-only for the parent package. These fields apply only to the child line items.

Table 47. Example of Package Item Price
Parent
Child
Quantity
Extended Quantity
List Price
UOM
Unit Net Price
Extended Price
Discount %
Net Discount
Per Person Allocation

Package

N/A

1

1

N/A

Each

N/A

N/A

N/A

N/A

N/A

Beer

1

1

5

Each

5.00

5.00

0%

0

N/A

Wine

1

1

10

Each

10.00

5.00

50%

5.00

N/A

Cordials

1

1

3

Each

3.00

3.00

0%

0

N/A

Package Item Price Field Behaviors

This topic describes the behaviors and the internal calculations that Siebel Hospitality performs for selected fields in a Package Item Price and its child items. These behaviors are typical of the Package Item Price package type.

Extended Quantity

Because only static child line items exist in a Package Item Price package, the Extended Quantity for the parent package equals the Quantity. The Extended Quantity for a child line item is calculated as Parent Quantity * Child Quantity.

Using values from Table 47, the Extended Quantities are calculated as shown in Table 48.

Table 48. Extended Quantity Calculations Example 1
Parent
Child
Quantity
Extended Quantity

Cash Bar

N/A

1

1

Beer

1

1

Wine

1

1

Cordials

1

1

If the parent package quantity is 4, the Extended Quantities are calculated as shown in Table 49.

Table 49. Extended Quantity Calculations Example 2
Parent
Child
Quantity
Extended Quantity

Cash Bar

N/A

4

4

Beer

1

4

Wine

1

4

Cordials

1

4

For a child item that is a complex product with UoM = Person under the Package Item Price and # of Attendees = 30, the Extended Quantities are calculated as shown in Table 50.

Table 50. Extended Quantity Calculations Example 3
Parent
Child
Grandchild
Quantity
Extended Quantity

Cash Bar

N/A

N/A

1

1

Menu Per Person

N/A

30

30

Wine

1

30

Chicken

1

30

Unit Net Price

For Package Item Price packages, the Unit Net Price calculation occurs only at the child item level. The Unit Net Price for a child line item is calculated as Parent Quantity * Child List Price.

Using values from Table 47, the Unit Net Prices are calculated as shown in Table 51.

Table 51. Unit Net Price Calculations Example
Parent
Child
List Price
Quantity
Calculation
Unit Net Price

Cash Bar

N/A

N/A

1

N/A

$18.00

Beer

$5.00

1

5 x 1

$5.00

Wine

$10.00

1

10 x 1

$10.00

Cordials

$3.00

1

3 x 1

$3.00

Extended Net Price

For Package Item Price packages, the Extended Net Price calculation occurs only on the child level. The Extended Net Price for a child line item is calculated as Child Extended Quantity * Child Unit Net Price.

Using values from Table 47, the Unit Net Prices are calculated as shown in Table 52.

Table 52. Extended Net Price Calculations Example
Parent
Child
Extended Quantity
Unit Net Price
Calculation
Extended Net Price

Cash Bar

N/A

1

N/A

N/A

N/A

Beer

3

$5.00

3 * 5

$15.00

Wine

1

$10.00

1 * 10

$10.00

Cordials

1

$3.00

1 * 3

$3.00

Per Person Allocation

For Package Item Price packages, the Per Person Allocation calculation occurs only on the child level. A child line item's Per Person Allocation field may or may not have a value, based on its Product Type. For example, if the child item is a Menu, the Per Person Allocation field is not used. If, however, the child item is a Package Per Person, then its Per Person Allocation field follows the Package Per Person rules. That is, the total Per Person Allocation sums up to the Net Price of the Package Per Person.

Function Total

The Function Total field is located in the function record. This field shows the total value of the function. The Function Total field value includes the Extended Net Prices of the child items, but not the Extended Net Price of the parent package, which is null.

Siebel Hospitality Guide Copyright © 2009, Oracle and/or its affiliates. All rights reserved. Legal Notices.