kBookingReservation_Lines

Parentid

kBookingReservationLine

-

Sequence

tkSequence

-

LineNr

tkInteger

Line Nr

-

Location

-

ItemType

Item Type

-

Default 0

ItemRole

Item Type

-

Default 0

Imported

tkYesNo

Imported

-

ServiceType

Type

-

Service

Service

-

ServiceCode

tkDescription

Service Code

-

ServiceDescription

tkTranslatableDescription

Name

-

ServiceShortDescription

tkTranslatableDescription

Short Description

-

ServiceExtendedDescription

tkTranslatableLongDescription

Long Description

-

ServiceAdditionalRemarks

kBookingServiceAdditionalRemarksContent

Additional Remarks

List

Owned

-

ServiceNumPax

tkIntegerPositive

Number of pax involved

-

ServiceHideEndTime

tkYesNo

Hide end Time

-

ServiceGiftIncluded

tkYesNo

Gift Included

-

ServiceExcludeFromPriceStatistics

tkYesNo

Exclude From Price Statistics

-

RoomRequired

tkYesNo

Treatment room required

-

Default 0

StaffRequired

tkYesNo

Staff required

-

Default 0

NumStaffMemberRequired

tkSmallIntPositive

Number of staff members

-

ToolNecessary

tkYesNo

Tool required

-

Default 0

GenderDistinction

tkYesNo

Gender Distinction

-

Default 0

PeriodizationType

Periodization Type

-

InternalRemark

tkLongText

Internal Remark

-

VoucherCode

tkDescription

Voucher Code

-

GiftCardGroup

kGiftCardGroup

Gift Card Group

-

VoucherType

kVoucherType

Voucher Type

-

VoucherToAllocateDeallocate

tkYesNo

Voucher To Allocate/Deallocate

-

RevertVoucherAllocation

tkYesNo

Revert Voucher Allocation On Cancellation

-

VoucherToRedeem

tkYesNo

Voucher To Reddem

-

ServiceIncluded

tkYesNo

Service Included

-

ReservationLineNrAssociated

tkSmallIntPositive

Belong to Line

-

ReservationLineIdAssociated

tkDescription

Belong to Package

-

Product

kProduct

Product

-

ProductType

tkProductType

Product Type

-

ProductCode

tkDescription

Product Code

-

ProductDescription

tkTranslatableDescription

Product Description

-

Date

tkDate

Date

-

TimeFrame

tkTimeRange

Time Frame

-

TimeFrame.StartTime

tkTime

Start Time

-

TimeFrame.EndTime

tkTime

End Time

-

Status

Reservation line status

Default 0

LineModified

tkYesNo

Reservation Modified

-

CancellationOptionated

tkYesNo

Cancellation in temporary status

-

Set only for reservation modification

LineToRemove

tkYesNo

Line to remove

-

Set to true before the real line cancellation

CheckinStatus

Checkin Status

Default 0

NoShowReason

NoShow Reason

-

NoShowText

tkDescription

NoShow Text

-

CancellationDate

tkDateTime

Canc Date

-

LastStatusModificationDate

tkDateTime

Last Status Modification Date

-

LastCheckinModificationDate

tkDateTime

Last Checkin Modification Date

-

AvoidTipRecalc

tkYesNo

Avoid Tip Recalc

-

ServiceGuests

kBookingReservationCustomer

Service Guests

List

Owned

-

Quantity

Quantity

-

Quantity.Total

tkSmallIntPositive

Total Quantity

-

Quantity.Man

tkSmallIntPositive

Man

-

Quantity.Woman

tkSmallIntPositive

Woman

-

Quantity.ThirdType

tkSmallIntPositive

Third Type

-

GrossPrice

tkAmount

Price

-

GrossPrice.Value

tkValue

Amount

-

GrossPrice.Currency

kCurrency

Currency

-

mandatory(true) {TODO: Mandatory only if Value<>0}

TotalDiscount

tkAmount

Total Discount

-

TotalDiscount.Value

tkValue

Amount

-

TotalDiscount.Currency

kCurrency

Currency

-

mandatory(true) {TODO: Mandatory only if Value<>0}

GrossAmount

tkAmount

Gross Amount

-

quantity*GrossPrice

GrossAmount.Value

tkValue

Amount

-

GrossAmount.Currency

kCurrency

Currency

-

mandatory(true) {TODO: Mandatory only if Value<>0}

NetAmount

tkAmount

Net Amount

-

GrossAmount-TotalDiscount

NetAmount.Value

tkValue

Amount

-

NetAmount.Currency

kCurrency

Currency

-

mandatory(true) {TODO: Mandatory only if Value<>0}

NetAmountAfterDiscountSplit

tkAmount

Net Amount After Discount Split

-

NetAmountAfterDiscountSplit.Value

tkValue

Amount

-

NetAmountAfterDiscountSplit.Currency

kCurrency

Currency

-

mandatory(true) {TODO: Mandatory only if Value<>0}

FiscalAmount

tkAmount

Fiscal Amount

-

Net Amount received from external checkin system

FiscalAmount.Value

tkValue

Amount

-

FiscalAmount.Currency

kCurrency

Currency

-

mandatory(true) {TODO: Mandatory only if Value<>0}

TipAmount

tkAmount

Tip Amount

-

Tip Amount received from external checkin system

TipAmount.Value

tkValue

Amount

-

TipAmount.Currency

kCurrency

Currency

-

mandatory(true) {TODO: Mandatory only if Value<>0}

PriceListAmount

tkAmount

Price List Amount

-

Price List Amount in case of service included in package

PriceListAmount.Value

tkValue

Amount

-

PriceListAmount.Currency

kCurrency

Currency

-

mandatory(true) {TODO: Mandatory only if Value<>0}

PriceType

Price Type

-

DynamicPriceLog

kBookingReservationDynamicPriceLog

DynamicPriceLog

Owned

-

DynamicPriceNotFoundReason

tkDescription

No Dynamic Price Reason

-

TotalTaxAmount

tkAmount

Total Tax Amount

-

TotalTaxAmount.Value

tkValue

Amount

-

TotalTaxAmount.Currency

kCurrency

Currency

-

mandatory(true) {TODO: Mandatory only if Value<>0}

Taxes

kBookingReservationTaxLine

Taxes Split

List

Owned

-

PricesVatInclusive

tkYesNo

Vat Inclusive

-

VatPerc

tkPercentage

VAT%

-

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}

RoomsLines

kBookingReservationRoomLine

Rooms used

List

Owned

-

StaffLines

kBookingReservationStaffLine

Staff members used

List

Owned

-

ToolsLines

kBookingReservationToolLine

Tools used

List

Owned

-

StaffGenderLocked

tkGender

Staff Member Gender Lock

-

RoomLocked

tkYesNo

Room assigned

-

StaffLocked

tkYesNo

Staff members assigned

-

ChangeStaffDisabled

tkYesNo

Staff members Lock

-

BookingEngineAllocated

tkYesNo

Booking Engine allocated

-

Default 0

FiscalDocCode

tkDescription

Fiscal Document Code

-

DiscountAllocations

kBookingReservationDiscountLine

Discounts Allocation

List

Owned

-

CRMId

tkDescription

CRM Id

-

IsAddedAtCheckin

tkYesNo

Is Added At Checkin

-

Code

tkCode

Code

Description

tkTranslatableDescription

Description

-

Remark

kRemark

Remark

Owned

-

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 upon request

-

Origin

kSystem

Origin

-

LastModifiedProcess

tkGuid

Last process

-

code (I)

insert

property

ParentId.Code

fixed

|

property

Sequence

beforeinsert (I)

BookingReservation_BeforeInsertReservationLine

kBooking

beforeupdate (I)

BookingReservation_BeforeUpdateReservationLine

kBooking

StaffLocked,RoomLocked,BookingEngineAllocated,LastModifiedBy,LastModifiedDate,RevisionNumber,CRMId

beforedelete (I)

BookingReservation_BeforeDeleteReservationLine

kBooking

afterinsert (I)

BookingReservation_AfterInsertReservationLine

kBooking

afterupdate (I)

BookingReservation_AfterUpdateReservationLine

kBooking

StaffLocked,RoomLocked,BookingEngineAllocated,LastModifiedBy,LastModifiedDate,RevisionNumber,CRMId

beforeinsert (I)

OnInitWorkFlow

kCoreServices

afterinsert (I)

AutoTransition

kCoreServices

afterupdate (I)

AutoTransition

kCoreServices

workflowstatus