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.

Example of a Package Item Price

A typical example of an item price package is a Cash Bar. As shown in Table 72, 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 72. Example of Package Item Price
Parent
Child
Quanti-ty
Exten-ded Quanti-ty
List Price
UOM
Unit Net Price
Exten-ded Price
Dis-count %
Net Dis-count
Per Person Alloca-tion

Pack-age

Not appli-cable

1

1

Not appli-cable

Each

Not appli-cable

Not appli-cable

Not appli-cable

Not appli-cable

Not appli-cable

Beer

1

1

5

Each

5.00

5.00

0%

0

Not appli-cable

Wine

1

1

10

Each

10.00

5.00

50%

5.00

Not appli-cable

Cor-dials

1

1

3

Each

3.00

3.00

0%

0

Not appli-cable

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 Field

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 multiplied by Child Quantity.

Using values from Table 72, the Extended Quantities are calculated as shown in Table 73.

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

Cash Bar

Not applicable

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 74.

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

Cash Bar

Not applicable

4

4

Beer

1

4

Wine

1

4

Cordials

1

4

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

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

Cash Bar

Not applicable

Not applicable

1

1

Menu Per Person

Not applicable

30

30

Wine

1

30

Chicken

1

30

Unit Net Price Field

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 multiplied by Child List Price.

Using values from Table 72, the Unit Net Prices are calculated as shown in Table 76.

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

Cash Bar

Not applicable

Not applicable

1

Not applicable

$18.00

Beer

$5.00

1

5 multiplied by 1

$5.00

Wine

$10.00

1

10 multiplied by 1

$10.00

Cordials

$3.00

1

3 multiplied by 1

$3.00

Extended Net Price Field

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 multiplied by Child Unit Net Price.

Using values from Table 72, the Unit Net Prices are calculated as shown in Table 77.

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

Cash Bar

Not applicable

1

Not applicable

Not applicable

Not applicable

Beer

3

$5.00

3 multiplied by 5

$15.00

Wine

1

$10.00

1 multiplied by 10

$10.00

Cordials

1

$3.00

1 multiplied by 3

$3.00

Per Person Allocation Field

For Package Item Price packages, the Per Person Allocation calculation occurs only on the child level. A Per Person Allocation field of a child line item might or might not have a value, depending on the Product Type of the child line item.

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 the Per Person Allocation field of the child item 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 Field

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 © 2018, Oracle and/or its affiliates. All rights reserved. Legal Notices.