kBookingReservation
Reservation
Info
Inherits from kDataObject\kDataBasic
Properties
| Name | Type | Label | List | Owned | Cluster | Mandatory | Unique | Note |
|---|---|---|---|---|---|---|---|---|
| Location | kBookingLocation | Location | ||||||
| Channel | kBookingChannel | Channel | ||||||
| ReservationDate | tkDateTime | Creation Date | ||||||
| MinCheckinDateTime | tkDateTime | Min Checkin Date Time | - | |||||
| CheckoutDate | tkDate | Checkout Date | - | |||||
| ReservationOperator | kUser | Reservation Operator | - | |||||
| Status | tkBookingStatusType | Reservation Status | ||||||
| Modified | tkYesNo | Reservation Modified | - | |||||
| ModificationToConfirm | tkYesNo | Reservation Mod to confirm | - | |||||
| RollbackFromModification | tkYesNo | Rollbacl from Mod | - | |||||
| CancellationDate | tkDateTime | Canc Date | - | |||||
| CancellationReason | tkCancellationReason | Canc Reason | - | |||||
| CancellationText | tkDescription | Canc Text | - | |||||
| LastStatusModificationDate | tkDateTime | Last Modification Date | - | |||||
| Imported | tkYesNo | Imported | - | |||||
| CheckinStatus | tkBookingReservationCheckinStatusType | Checkin Status | - | Default 0 | ||||
| NrNoShowLines | tkInteger | Nr. No Shows Lines | - | |||||
| NrCheckinLines | tkInteger | Nr. Checkin Lines | - | |||||
| NrCheckinProgressLines | tkInteger | Nr. Checkin Progress Lines | - | |||||
| NrCheckoutLines | tkInteger | Nr. No Show Progress Lines | - | |||||
| SentPrePostStayDateTime | kBookingReservationPrePostStaySentDateTime | List | Owned | - | ||||
| CustomerReferent | kBookingReservationCustomer | Referent Data | Owned | - | ||||
| InvoiceRequested | tkYesNo | Invoice Requested | - | Default 0 | ||||
| InvoiceCustomer | kCustomer | Referent Data | Owned | - | ||||
| VatId | tkVATId | Vat Id | - | |||||
| TaxCode | tkTaxCode | Tax Code | - | |||||
| LegalEmailAddress | tkEmail | Legal E-mail Address | - | |||||
| SaleConditionsAgreed | tkYesNo | Agreement to Sale Conditions | - | Default 1 | ||||
| CustomerRemark | tkLongText | Customer Remark | - | |||||
| Voucher | tkYesNo | Voucher | - | Default 0 | ||||
| TotalQuantity | tkReservationQuantity | Total Quantity | - | |||||
| TotalQuantity.Total | tkSmallIntPositive | Total Quantity | - | |||||
| TotalQuantity.Man | tkSmallIntPositive | Man | - | |||||
| TotalQuantity.Woman | tkSmallIntPositive | Woman | - | |||||
| TotalQuantity.ThirdType | tkSmallIntPositive | Third Type | - | |||||
| TotalGrossAmount | tkAmount | Total Gross Amount | - | |||||
| TotalGrossAmount.Value | tkValue | Amount | - | |||||
| TotalGrossAmount.Currency | kCurrency | Currency | - | mandatory(true) {TODO: Mandatory only if Value<>0} | ||||
| TotalDiscountAmount | tkAmount | Total Discount | - | |||||
| TotalDiscountAmount.Value | tkValue | Amount | - | |||||
| TotalDiscountAmount.Currency | kCurrency | Currency | - | mandatory(true) {TODO: Mandatory only if Value<>0} | ||||
| TotalNetAmount | tkAmount | Total Net Amount | - | |||||
| TotalNetAmount.Value | tkValue | Amount | - | |||||
| TotalNetAmount.Currency | kCurrency | Currency | - | mandatory(true) {TODO: Mandatory only if Value<>0} | ||||
| TotalTaxAmount | tkAmount | Total Tax Amount | - | |||||
| TotalTaxAmount.Value | tkValue | Amount | - | |||||
| TotalTaxAmount.Currency | kCurrency | Currency | - | mandatory(true) {TODO: Mandatory only if Value<>0} | ||||
| TotalFiscalAmount | tkAmount | Total Fiscal Amount | - | Net Amount received from external checkin system | ||||
| TotalFiscalAmount.Value | tkValue | Amount | - | |||||
| TotalFiscalAmount.Currency | kCurrency | Currency | - | mandatory(true) {TODO: Mandatory only if Value<>0} | ||||
| TotalTipAmount | tkAmount | Total Tip Amount | - | Tip Amount received from external checkin system | ||||
| TotalTipAmount.Value | tkValue | Amount | - | |||||
| TotalTipAmount.Currency | kCurrency | Currency | - | mandatory(true) {TODO: Mandatory only if Value<>0} | ||||
| TotalFiscalAmountTipable | tkAmount | Total Fiscal Amount Tipable | - | Total fiscal amount of the rows tipable | ||||
| TotalFiscalAmountTipable.Value | tkValue | Amount | - | |||||
| TotalFiscalAmountTipable.Currency | kCurrency | Currency | - | mandatory(true) {TODO: Mandatory only if Value<>0} | ||||
| NrPax | tkSmallIntPositive | Nr Pax | - | |||||
| NrPaxMan | tkSmallIntPositive | Nr Man Pax | - | |||||
| NrPaxWoman | tkSmallIntPositive | Nr Woman Pax | - | |||||
| NrPaxThirdType | tkSmallIntPositive | Nr Third Type Pax | - | |||||
| Penalty | tkAmount | Penalty Amount | - | |||||
| Penalty.Value | tkValue | Amount | - | |||||
| Penalty.Currency | kCurrency | Currency | - | mandatory(true) {TODO: Mandatory only if Value<>0} | ||||
| AppliedPenalty | tkYesNo | Applied Penalty | - | |||||
| Taxes | kBookingReservationTaxLine | Taxes Split | List | Owned | - | |||
| PaymentStatus | tkBookingPaymentStatus | Payment Status | - | UnPaid, Paid, PartiallyPaid | ||||
| PaymentTransactions | kBookingReservationTransactionsLine | Payments | List | Owned | - | List of payments Transactions | ||
| PaymentMethod | kBookingPayMethod | Payment Method | - | Ex. Full Advanced Payment or Pay at checkin or Half advanced payment | ||||
| PaymentMethodStored | kBookingReservationPayMethod | Payment Method Stored | Owned | - | Local copy of payment method data | |||
| AdvancedPaymentTransactionsOptionated | kBookingReservationTransactionsLine | Optionated Advanced Payment Transactions | List | Owned | - | List of optionated advanced payment transactions | ||
| AdvancedPaymentRequired | tkAmount | Total Advanced Payment Required | - | Advanced payment rquired based on payment method and total reservation amount (Total Net Amount) | ||||
| AdvancedPaymentRequired.Value | tkValue | Amount | - | |||||
| AdvancedPaymentRequired.Currency | kCurrency | Currency | - | mandatory(true) {TODO: Mandatory only if Value<>0} | ||||
| PaidAmount | tkAmount | Total Paid amount | - | |||||
| PaidAmount.Value | tkValue | Amount | - | |||||
| PaidAmount.Currency | kCurrency | Currency | - | mandatory(true) {TODO: Mandatory only if Value<>0} | ||||
| CreditCardData | kBookingReservationCreditCardData | Credit Card Data | List | Owned | - | |||
| RefundGiftCard | kGiftCard | Gift Card as refund | List | Not Owned | - | |||
| AmountToRefund | tkAmount | Adv Payment to refund | - | |||||
| AmountToRefund.Value | tkValue | Amount | - | |||||
| AmountToRefund.Currency | kCurrency | Currency | - | mandatory(true) {TODO: Mandatory only if Value<>0} | ||||
| AmountRefunded | tkAmount | Adv Payment refunded | - | |||||
| AmountRefunded.Value | tkValue | Amount | - | |||||
| AmountRefunded.Currency | kCurrency | Currency | - | mandatory(true) {TODO: Mandatory only if Value<>0} | ||||
| PenaltyToCollect | tkAmount | Penalty to collect | - | |||||
| PenaltyToCollect.Value | tkValue | Amount | - | |||||
| PenaltyToCollect.Currency | kCurrency | Currency | - | mandatory(true) {TODO: Mandatory only if Value<>0} | ||||
| RefundStatus | tkYesNo | Refund Status | - | |||||
| PricesVatInclusive | tkYesNo | Vat Inclusive | - | tutti i prezzi e gli sconti saranno espressi con/senza iva in accordo con questo flag | ||||
| VatAmount | tkAmount | Vat Amount | - | |||||
| VatAmount.Value | tkValue | Amount | - | |||||
| VatAmount.Currency | kCurrency | Currency | - | mandatory(true) {TODO: Mandatory only if Value<>0} | ||||
| VatableAmount | tkAmount | Vat Amount | - | |||||
| VatableAmount.Value | tkValue | Amount | - | |||||
| VatableAmount.Currency | kCurrency | Currency | - | mandatory(true) {TODO: Mandatory only if Value<>0} | ||||
| Discounts | kBookingReservationDiscountLine | Discounts | List | Owned | - | |||
| DiscountCodes | kBookingReservationDiscount | Discounts Code | List | Owned | - | |||
| CancPolicy | kBookingCancPolicy | Cancellation Policy | - | |||||
| CancPolicyStored | kBookingReservationCancPolicy | Cancellation Policy Stored | Owned | - | ||||
| Lines | kBookingReservationLine | Items booked | List | Owned | - | |||
| ServiceCodesConcat | tkLongText | Service Codes Concatenation | - | |||||
| RecalcTotalDateTime | tkDateTime | Recalc Total Date Time | - | |||||
| BookingWindow | tkInteger | Booking Window | - | |||||
| CancellationWindow | tkInteger | Cancellation Window | - | |||||
| AvoidBEReservationsReload | tkYesNo | Avoid reservations reload | - | |||||
| AvoidReservationsAmountRecalc | tkYesNo | Avoid reservations amount recalc | - | |||||
| OldReservationRef | tkDescription | Old Reservation Reference | - | |||||
| PlannerColor | tkShortDescription | Planner Color | - | |||||
| SendToCRMStatus | tkSendToCRMStatus | Send to CRM | - | |||||
| SendToCRMStatusLastUpdate | tkDateTime | Send to CRM Last Update | - | |||||
| SendToCRMAttemptNr | tkIntegerPositive | Send CRM Nr Failed Attempt | - | |||||
| SendToCRMProcess | kBookingSendToCRMProcesses | Send CRM Process | - | |||||
| SendToCRMProcessingStart | tkDateTime | Send CRM Process Start | - | |||||
| SendToCRMSendingStart | tkDateTime | Send CRM Start | - | |||||
| SendToCRMSendingEnd | tkDateTime | Send CRM End | - | |||||
| CRMId | tkDescription | CRM Id | - | |||||
| CRMLineToRemove | kBookingReservationCRMLineToRemove | CRM Line to Remove | List | Owned | - | |||
| HiddenReservation | tkYesNo | Hidden Reservation | - | |||||
| Inherited from kDataBasic | ||||||||
| Code | tkCode | Code | ||||||
| Description | tkTranslatableDescription | Description | - | |||||
| Remark | kRemark | Remark | Owned | - | ||||
| Inherited from kDataObject | ||||||||
| Id | tkUnique | Id | ||||||
| ClassName | tkCode | Class Name | - | |||||
| CreatedBy | tkCode | Created BY | - | |||||
| LastModifiedBy | tkCode | Last Modified By | - | |||||
| CreatedDate | tkDateTime | Created Date | - | |||||
| LastModifiedDate | tkDateTime | Last Modified Date | - | |||||
| RevisionNumber | tkInteger | Revision Number | - | |||||
| WorkflowStatus | kWorkflowStatus | Workflow Status | - | |||||
| OwnedOnRequest | tkYesNo | Is owned on request | - | |||||
| Origin | kSystem | Origin | - | |||||
| LastModifiedProcess | tkGuid | Last process | - | |||||
(E) : Type have an event assigned to it, look at type documentation for mode details
(A) : Property have an autocoderole, look autocoderole grid for mode details
Autocoderoles
| Property | Ignore user input | When | Code part | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| Type | Value | Start | Length | Fill Char | Dir | Seq. Suf. | Prefix | Limit Len | |||
| code | insert | property | Location.Code | 3 | 0 | right | |||||
| fixed | ##date:yyyy## | ||||||||||
| random | 100000 | 0 | 5 | 0 | left | ||||||
| sequence | kBookingReservationSeq | 7 | 0 | left | Location.Code | ||||||
Events
| When | Method Name | Module | Parameters | On | Off | Asynch |
|---|---|---|---|---|---|---|
| beforeinsert | BookingReservation_BeforeInsertReservation | kBooking | ||||
| beforeupdate | BookingReservation_BeforeUpdateReservation | kBooking | BookingWindow,CancellationWindow,SentPrePostStayDateTime,LastModifiedBy,LastModifiedDate,RevisionNumber,CheckinStatus,NrNoShowLines,NrCheckinLines,NrCheckinProgressLines,NrCheckoutLines,PlannerColor,SendToCRMStatus,SendToCRMProcessingStart,SendToCRMStatusLastUpdate,SendToCRMProcess,SendToCRMAttemptNr,SendToCRMSendingStart,SendToCRMSendingEnd,CRMId | |||
| beforedelete | BookingReservation_BeforeDeleteReservation | kBooking | ||||
| afterupdate | BookingReservation_AfterUpdateReservation | kBooking | BookingWindow,CancellationWindow,SentPrePostStayDateTime,LastModifiedBy,LastModifiedDate,RevisionNumber,CheckinStatus,NrNoShowLines,NrCheckinLines,NrCheckinProgressLines,NrCheckoutLines,PlannerColor,SendToCRMStatus,SendToCRMProcessingStart,SendToCRMStatusLastUpdate,SendToCRMProcess,SendToCRMAttemptNr,SendToCRMSendingStart,SendToCRMSendingEnd,CRMId | |||
| afterinsert | BookingReservation_AfterInsertReservation | kBooking | ||||
| beforeinsert (I) | OnInitWorkFlow | kCoreServices | ||||
| afterinsert (I) | AutoTransition | kCoreServices | ||||
| afterupdate (I) | AutoTransition | kCoreServices | workflowstatus |
IncrementalSearch
- class : kBookingReservation
- searchproperty : location.Description,code
- displayproperties : code,location.Description
- displaytextproperties : code,location.Description
Used By
| Class | Property |
|---|---|
| kBookingReservationSession | ReservationAssociated |
| kBookingReservationCartLine | Reservation |