Skip to content

simplicitesoftware/module-booking

BranchesTags

Repository files navigation

Booking module definition

BookBookings business object definition

Bookings of a customer

Fields

Name Type Required Updatable Personal Description
bookBookingsBookUsersId link to BookUsers id yes* yes -
Ref. bookBookingsBookUsersId.usr_title enum(5) using USER_TITLE list yes Title
Ref. bookBookingsBookUsersId.usr_last_name char(50) yes Last name
Ref. bookBookingsBookUsersId.usr_first_name char(50) yes First name
Ref. bookBookingsBookUsersId.bookUserEmail email(100) -
bookBookingsDate date yes* -
bookBookingsHour time yes* -
bookBookingsStartDate datetime yes yes -
bookBookingsEndDate datetime yes yes -
bookBookingsPaymentDate date -
bookBookingsAmountDate date -
bookBookingsPaymentDone boolean yes -
bookBookingsComments html(2000) yes -
bookBookingsStatus enum(2) using BOOKBOOKINGSSTATUS list yes -
bookBookingsRoomNumber enum(100) using BOOKBOOKINGSROOMNUMBER list yes yes -
bookBookingsGuestNumber enum(2) using BOOKBOOKINGSROOMNUMBER list yes -

Lists

  • USER_TITLE
    • MR
    • MRS
    • MS
  • BOOKBOOKINGSSTATUS
    • EA En attente
    • TR Traitée
    • Cl Clôturée
  • BOOKBOOKINGSROOMNUMBER
    • 1 1
    • 2 2
    • 3 3
    • 4 4
    • 5 5
    • 6 6
    • 7 7
    • 8 8
    • 9 9
    • 10 10

BookBookingsBookGuests business object definition

Fields

Name Type Required Updatable Personal Description
bookBookingsId link to BookBookings id yes* yes -
Ref. bookBookingsId.bookBookingsBookUsersId id -
Ref. bookBookingsBookUsersId.usr_last_name char(50) yes Last name
Ref. bookBookingsBookUsersId.usr_first_name char(50) yes First name
Ref. bookBookingsBookUsersId.bookUserEmail email(100) -
Ref. bookBookingsId.bookBookingsDate date -
Ref. bookBookingsId.bookBookingsHour time -
Ref. bookBookingsId.bookBookingsStartDate datetime -
Ref. bookBookingsId.bookBookingsEndDate datetime -
Ref. bookBookingsId.bookBookingsStatus enum(2) using BOOKBOOKINGSSTATUS list -
bookBookingsGuestsBookRoomId link to BookRoom id yes -
Ref. bookBookingsGuestsBookRoomId.bookRoomCode char(20) -
Ref. bookBookingsGuestsBookRoomId.bookRoomLabel char(255) -
Ref. bookBookingsGuestsBookRoomId.bookRoomBookRoomTypeId id -
Ref. bookRoomBookRoomTypeId.bookRoomtypType char(255) -
Ref. bookBookingsGuestsBookRoomId.bookRoomSuperficie enum(10) using BOOKROOMSUPERFICIE list -
Ref. bookBookingsGuestsBookRoomId.bookRoomFloor enum(2) using BOOKROOMFLOOR list -
Ref. bookBookingsGuestsBookRoomId.bookRoomPhoto image -
Ref. bookBookingsGuestsBookRoomId.bookRoomPriceht float(11, 2) -
bookGuestsId link to BookGuests id * yes -
Ref. bookGuestsId.usr_last_name char(50) yes Last name
Ref. bookGuestsId.usr_first_name char(50) yes First name
Ref. bookGuestsId.bookUserEmail email(100) -

Lists

  • BOOKBOOKINGSSTATUS
    • EA En attente
    • TR Traitée
    • Cl Clôturée
  • BOOKROOMSUPERFICIE
    • 12 12 m2
    • 15 15 m2
    • 17 17 m2
    • 22 22m2
  • BOOKROOMFLOOR
    • 0 RDC
    • 1 1er
    • 2 2ème
    • 3 3ème
    • 4 4ème
    • 5 5ème
    • 6 6ème

BookBookingsHistoric business object definition

Fields

Name Type Required Updatable Personal Description
row_ref_id link to BookBookings id yes* Record row ID
row_idx int(11) yes* yes History record index
created_by_hist char(100) yes* Created by
created_dt_hist datetime yes* Created date
bookBookingsBookUsersId link to BookUsers id yes* yes -
Ref. bookBookingsBookUsersId.usr_title enum(5) using USER_TITLE list yes Title
Ref. bookBookingsBookUsersId.usr_last_name char(50) yes Last name
Ref. bookBookingsBookUsersId.usr_first_name char(50) yes First name
Ref. bookBookingsBookUsersId.bookUserEmail email(100) -
bookBookingsDate date yes* -
bookBookingsHour time yes* -
bookBookingsStartDate datetime yes yes -
bookBookingsEndDate datetime yes yes -
bookBookingsPaymentDate date -
bookBookingsAmountDate date -
bookBookingsPaymentDone boolean yes -
bookBookingsComments html(2000) yes -
bookBookingsStatus enum(2) using BOOKBOOKINGSSTATUS list yes -
bookBookingsRoomNumber enum(100) using BOOKBOOKINGSROOMNUMBER list yes yes -
bookBookingsGuestNumber enum(2) using BOOKBOOKINGSROOMNUMBER list yes -

Lists

  • USER_TITLE
    • MR
    • MRS
    • MS
  • BOOKBOOKINGSSTATUS
    • EA En attente
    • TR Traitée
    • Cl Clôturée
  • BOOKBOOKINGSROOMNUMBER
    • 1 1
    • 2 2
    • 3 3
    • 4 4
    • 5 5
    • 6 6
    • 7 7
    • 8 8
    • 9 9
    • 10 10

BookGuests business object definition

Fields

Name Type Required Updatable Personal Description
bookUserType enum(3) using BOOKBOOKUSERSTYPE list yes yes -

Lists

  • BOOKBOOKUSERSTYPE
    • CUS Client
    • ACC Accompagnateur

BookPayments business object definition

Bookings payments

Fields

Name Type Required Updatable Personal Description
bookPaymentsBookBookingsId link to BookBookings id yes* yes -
Ref. bookPaymentsBookBookingsId.bookBookingsBookUsersId id -
Ref. bookPaymentsBookBookingsId.bookBookingsDate date -
Ref. bookPaymentsBookBookingsId.bookBookingsHour time -
Ref. bookBookingsBookUsersId.usr_title enum(5) using USER_TITLE list yes Title
Ref. bookBookingsBookUsersId.usr_last_name char(50) yes Last name
Ref. bookBookingsBookUsersId.usr_first_name char(50) yes First name
Ref. bookBookingsBookUsersId.bookUserEmail email(100) -
Ref. bookPaymentsBookBookingsId.bookBookingsStartDate datetime -
Ref. bookPaymentsBookBookingsId.bookBookingsEndDate datetime -
bookPayPaymId link to BookPaymentMethod id yes* yes -
Ref. bookPayPaymId.bookPaymCode char(20) -
Ref. bookPayPaymId.bookPaymLibell char(100) -
bookPayAmount float(10, 2) yes yes -
bookPayComments html(1000) yes -

Lists

  • USER_TITLE
    • MR
    • MRS
    • MS

BookRoomEquipment business object definition

Room Equipements

Fields

Name Type Required Updatable Personal Description
bookEquLibell char(255) yes yes -
bookEquCode char(20) yes* yes -

BookPaymentMethod business object definition

Fields

Name Type Required Updatable Personal Description
bookPaymCode char(20) yes* -
bookPaymLibell char(100) yes yes -

BookRoomService business object definition

Services in room

Fields

Name Type Required Updatable Personal Description
bookRservCode char(20) yes* yes -
bookRservLibell char(255) yes yes -

BookRoomType business object definition

Fields

Name Type Required Updatable Personal Description
bookRoomtypCode char(20) yes* yes -
bookRoomtypType char(255) yes yes -

BookRoom business object definition

Booking rooms

Fields

Name Type Required Updatable Personal Description
bookRoomCode char(20) yes* yes -
bookRoomLabel char(255) yes yes -
bookRoomBookRoomTypeId link to BookRoomType id yes -
Ref. bookRoomBookRoomTypeId.bookRoomtypCode char(20) -
Ref. bookRoomBookRoomTypeId.bookRoomtypType char(255) -
bookRoomDesc html(200) yes -
bookRoomSuperficie enum(10) using BOOKROOMSUPERFICIE list yes -
bookRoomFloor enum(2) using BOOKROOMFLOOR list yes yes -
bookRoomPhoto image yes -
bookRoomPriceht float(11, 2) yes -

Lists

  • BOOKROOMSUPERFICIE
    • 12 12 m2
    • 15 15 m2
    • 17 17 m2
    • 22 22m2
  • BOOKROOMFLOOR
    • 0 RDC
    • 1 1er
    • 2 2ème
    • 3 3ème
    • 4 4ème
    • 5 5ème
    • 6 6ème

BookEquRoom business object definition

Fields

Name Type Required Updatable Personal Description
bookEquroomEquId link to BookRoomEquipment id yes* yes -
Ref. bookEquroomEquId.bookEquCode char(20) -
Ref. bookEquroomEquId.bookEquLibell char(255) -
bookEquroomRoomId link to BookRoom id yes* yes -
Ref. bookEquroomRoomId.bookRoomCode char(20) -
Ref. bookEquroomRoomId.bookRoomLabel char(255) -

BookRoomBookRoomService business object definition

Fields

Name Type Required Updatable Personal Description
bookroomservBookRoomId link to BookRoom id yes* yes -
Ref. bookroomservBookRoomId.bookRoomCode char(20) -
Ref. bookroomservBookRoomId.bookRoomLabel char(255) -
bookroomservBookServiceId link to BookRoomService id yes* yes -
Ref. bookroomservBookServiceId.bookRservCode char(20) -
Ref. bookroomservBookServiceId.bookRservLibell char(255) -

BookUsers business object definition

Customers

Fields

Name Type Required Updatable Personal Description
usr_title enum(5) using USER_TITLE list yes yes Title
usr_last_name char(50) yes yes Last name
usr_first_name char(50) yes yes First name
usr_work_num phone(20) yes yes Work phone number
usr_home_num phone(20) yes -
usr_cell_num phone(20) yes yes Mobile/cellular phone number
usr_address1 char(100) yes yes Address line 1
usr_address2 char(100) yes yes Address line 2
usr_zipcode char(10) yes yes Postal/ZIP code
usr_city char(50) yes yes City
usr_state char(50) yes yes State
usr_country enum(20) using COUNTRY list yes yes Country
bookUserEmail email(100) yes* yes -
bookUserType enum(3) using BOOKBOOKUSERSTYPE list yes yes -
bookUserGeoCoord geocoords yes -

Lists

  • USER_TITLE
    • MR
    • MRS
    • MS
  • COUNTRY
    • FR France
    • UK United Kingdom
    • ES Spain
    • DE Germany
    • BE Belgium
    • CH Switzerland
    • IE Ireland
    • IT Italy
    • PT Portugal
    • NL Netherlands
    • CZ Czech Republic
    • AT Austria
    • CA Canada
    • US United States of America
    • AU Australia
  • BOOKBOOKUSERSTYPE
    • CUS Client
    • ACC Accompagnateur

BookingCreation business process definition

Process to create booking

Activities

  • Begin:
  • CreateBooking:
  • End:
  • CreateGuests: Create Guests
  • Identification: Identification : Customer creation

BookBookingAgenda external object definition

BookBookingFrontEnd external object definition

About

No description, website, or topics provided.

Resources

Readme
Activity
Custom properties

Stars

0 stars

Watchers

2 watching

Forks

0 forks
Report repository

Releases

No releases published

Packages

No packages published

Languages