Commission

The commission file should be in the below format:

  • Encoding: UTF-8
  • File Name:
  • Extension file: csv
  • Headers:

    • ruleId → rule identifier
    • supplierCodes → supplier code
    • notSupplierCodes → supplier code
    • creationDateFrom → start creation date Date format
    • creationDateTo → end creation date Date format
    • checkInFrom → checkin date Date format
    • checkInTo → checkout date Date format
    • hotelCodes → hotel code
    • nothotelCodes → hotel code
    • chainsCodes → chain code
    • notChainCodes → chain code
    • destinationCodes → destination code
    • notDestinationCodes → destination code
    • percentage → commission value, decimal separator must be point (“.”)
    • force → (boolean value true/false)

      • false value (if the value is false, the rule will not be applied despite of matching all its conditions criteria if a commission is received from the supplier through the integration).
      • true value if the value is true, the rule will be applied if matching all its conditions criteria, regardless of a commission being received or not from the supplier through the integration).
      • Example

      commission received,forced,result from supplier
      no,no,rule applied (if matching all its criteria conditions)
      no,yes,rule applied (if matching all its criteria conditions)
      yes,no,rule NOT applied regardless of matching all its criteria conditions
      yes,yes,rule applied (if matching all its criteria conditions)
      
      • List of file fields
      Field Mandatory Excluded fields* Multi-value
      ruleId Yes - No
      supplierCodes Yes notSupplierCodes Yes
      notSupplierCodes Yes supplierCodes Yes
      creationDateFrom No - No
      creationDateTo No - No
      checkInFrom No - No
      checkInTo No - No
      hotelCodes No nothotelCodes Yes
      nothotelCodes No hotelCodes Yes
      chainsCodes No notChainCodes Yes
      notChainCodes No chainsCodes Yes
      DestinationCodes No notDestinationCodes Yes
      notDestinationCodes No DestinationCodes Yes
      percentage Yes - No
      force Yes - No

      *Excluded fields Informed fields will be ignored

  • Delimiter:  Comma (“,”)

  • Separator for multiples codes in the same row: Semicolon (“;”)

  • Directory: /F[folder code]_[unique code]/HotelX_[unique code]/

Sample File

Name: context_sequential_commission.csv

Data:

Simple value field

ruleId,supplierCodes,notSupplierCodes,creationDateFrom,creationDateTo,checkInFrom,checkInTo,hotelCodes,notHotelCodes,chainCodes,notChainCodes,destinationCodes,notDestinationCodes,percentage,force
CE1,DIN,,,,2018-04-01,2018-10-31,3846,,,,,,18.50,false
CE2,DIN,,,,,,3846,,,,,,15.00,false

Multivalue field

ruleId,supplierCodes,notSupplierCodes,creationDateFrom,creationDateTo,checkInFrom,checkInTo,hotelCodes,notHotelCodes,chainCodes,notChainCodes,destinationCodes,notDestinationCodes,percentage,force
CE1,DIN;HOB;JMB,,,,2018-04-01,2018-10-31,3846,,,,,,18.50,false
CE2,DIN,,,,,,3846,,,,,,15.00,false

Date format

Date format yyyy-mm-dd is mandatory


Comments