Skip to content

Latest commit

 

History

History
410 lines (321 loc) · 36.2 KB

README.md

File metadata and controls

410 lines (321 loc) · 36.2 KB

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.bookUserTitle enum(5) using USER_TITLE list Title
Ref. bookBookingsBookUsersId.BookUserLastname char(50) Last name
Ref. bookBookingsBookUsersId.bookUserFirstname char(50) 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.BookUserLastname char(50) Last name
Ref. bookBookingsBookUsersId.bookUserFirstname char(50) 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.bookRoomtypCode char(20) -
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.BookUserLastname char(50) Last name
Ref. bookGuestsId.bookUserFirstname char(50) 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.bookUserTitle enum(5) using USER_TITLE list Title
Ref. bookBookingsBookUsersId.BookUserLastname char(50) Last name
Ref. bookBookingsBookUsersId.bookUserFirstname char(50) 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.bookUserTitle enum(5) using USER_TITLE list Title
Ref. bookBookingsBookUsersId.BookUserLastname char(50) Last name
Ref. bookBookingsBookUsersId.bookUserFirstname char(50) 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
bookUserTitle enum(5) using USER_TITLE list yes Title
BookUserLastname char(50) yes yes Last name
bookUserFirstname char(50) yes yes First name
bookUserWorknum phone(20) yes Work phone number
bookUserHomenum phone(20) yes -
bookUserCellnum phone(20) yes Mobile/cellular phone number
bookUserAddress1 char(100) yes yes Address line 1
bookUserAddress2 char(100) yes Address line 2
bookUserZipcode char(10) yes Postal/ZIP code
bookUserCity char(50) yes yes City
bookUserState char(50) yes State
bookUserCountry 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