Package Per Person Field Behaviors
This topic describes the behaviors and internal calculations that Siebel Hospitality performs for selected fields in a Package Per Person and its child items. These behaviors are typical of the Package Per Person package type.
Quantity Field
For the parent package, set to the # Guaranteed or Expected, in that order, when either of these fields is changed. If Guaranteed is null, Expected is used. For child items, the default value is set up by the administrator.
Extended Quantity Field
For the parent package and static child items, displays the same value as Quantity. For each child line item that is a per person item (that is, where UoM is equal to Person), Extended Quantity is calculated as parent Quantity multiplied by child item Quantity, where parent Quantity is equal to Best Attendance. For the parent package and static child line items, this calculation is not done and the Extended Quantity is the same as Quantity.
The Quantity of the parent item and of the child items can also be manually modified. If the parent is a package per person, the parent Quantity behaves as if the UoM is equal to Per Person even if this is not explicitly specified on the parent record.
Using example values from the table in Example of a Package Per Person, the Extended Quantity is calculated as shown in the following table.
| Parent | Child | UOM | Quantity | Calculation | Extended Quantity |
|---|---|---|---|---|---|
|
Package |
N/A |
Per Person |
50 |
50 |
50 |
|
Package |
Menu |
Per Person |
1 |
1 multiplied by 50 |
50 |
|
Package |
Audiovisual |
Each |
1 |
1 multiplied by 1 |
1 |
|
Package |
Ice Sculpture |
Each |
2 |
2 multiplied by 1 |
2 |
Best Attendance Field
If Actual is not null, Best Attendance is equal to Actual. If Actual is null and Guaranteed is not null, Best Attendance is equal to Guaranteed. If Actual and Guaranteed are both null and Projected is not null, Best Attendance is equal to Projected. If Actual, Guaranteed, and Projected are all null, Best Attendance is equal to Expected.
Unit Net Price Field
Unit Net Price is calculated as follows:
If Negotiated Price is null, the calculation is one of the following:
List Price minus (List Price multiplied by Discount %)
List Price minus Discount Amount
If Negotiated Price is not null, the calculation is one of the following:
Negotiated Price minus (Negotiated Price multiplied by Discount %)
Negotiated Price minus Discount Amount
Extended Net Price Field
Extended Net Price is calculated as Extended Quantity multiplied by Unit Net Price for both the parent package and the child line items.
Using example values from the table in Example of a Package Per Person, the Extended Price is calculated as shown in the following table.
| Parent | Child | Extended Quantity | Unit Net Price | Calculation | Extended Price |
|---|---|---|---|---|---|
|
Package |
N/A |
50 |
60.00 |
50 multiplied by 60 |
$3000.00 |
|
Package |
Menu |
50 |
50.00 |
50 multiplied by 50 |
$2500.00 |
|
Package |
Audiovisual |
1 |
400.00 |
1 multiplied by 400 |
$400.00 |
|
Package |
Ice Sculpture |
2 |
100.00 |
2 multiplied by 100 |
$200.00 |
Discount % Field
Percent of the discount to be applied to a line item price. You can specify a Discount % or a Discount Amount, but not both for the same item. If Discount % is specified, Discount Amount is null.
Discount Amount Field
Amount of the discount to be applied to a line item price. You can specify a Discount % or a Discount Amount, but not both for the same item. If Discount Amount is specified, Discount % is null.
Non Discounted Extended Price Field
If Negotiated Price is null, the value is calculated as List Price multiplied by Extended Qty. If Negotiated Price is not null, the value is calculated as Negotiated Price multiplied by Extended Qty.
Net Discount Field
The value is calculated as Non Discounted Extended Price minus Extended Net Price.
Per Person Allocation Field
For the parent package, this field is read-only and null, because allocations are normally calculated for the child records. For a per person child item, holds the allocated value of the revenue from that item. For child items, the default value is the allocations value defined by the administrator. For the package, the value equals the Net Price. Users can update the Per Person Allocation fields of the child items.
Function Total Field
The Function Total field is located in the function record, and shows total value of the function. The value in this field includes the extended net prices of the parent package and does not include the extended net prices of the child package items.