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 the table in Example of a Package Item Price, the Extended Quantities are calculated as shown in the following table.
| Parent | Child | Quantity | Extended Quantity |
|---|---|---|---|
|
Cash Bar |
N/A |
1 |
1 |
|
Cash Bar |
Beer |
1 |
1 |
|
Cash Bar |
Wine |
1 |
1 |
|
Cash Bar |
Cordials |
1 |
1 |
If the parent package quantity is 4, the Extended Quantities are calculated as shown in the following table.
| Parent | Child | Quantity | Extended Quantity |
|---|---|---|---|
|
Cash Bar |
N/A |
4 |
4 |
|
Cash Bar |
Beer |
1 |
4 |
|
Cash Bar |
Wine |
1 |
4 |
|
Cash Bar |
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 the following table.
| Parent | Child | Grandchild | Quantity | Extended Quantity |
|---|---|---|---|---|
|
Cash Bar |
N/A |
N/A |
1 |
1 |
|
Cash Bar |
Menu Per Person |
N/A |
30 |
30 |
|
Cash Bar |
Menu Per Person |
Wine |
1 |
30 |
|
Cash Bar |
Menu Per Person |
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 the table in Example of a Package Item Price, the Unit Net Prices are calculated as shown in the following table.
| Parent | Child | List Price | Quantity | Calculation | Unit Net Price |
|---|---|---|---|---|---|
|
Cash Bar |
N/A |
N/A |
1 |
N/A |
$18.00 |
|
Cash Bar |
Beer |
$5.00 |
1 |
5 multiplied by 1 |
$5.00 |
|
Cash Bar |
Wine |
$10.00 |
1 |
10 multiplied by 1 |
$10.00 |
|
Cash Bar |
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 the table in Example of a Package Item Price, the Unit Net Prices are calculated as shown in the following table.
| Parent | Child | Extended Quantity | Unit Net Price | Calculation | Extended Net Price |
|---|---|---|---|---|---|
|
Cash Bar |
N/A |
1 |
N/A |
N/A |
N/A |
|
Cash Bar |
Beer |
3 |
$5.00 |
3 multiplied by 5 |
$15.00 |
|
Cash Bar |
Wine |
1 |
$10.00 |
1 multiplied by 10 |
$10.00 |
|
Cash Bar |
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.