The commission file should be in the below format:

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

    • ruleId → rule identifier
    • clientTokens → client token used for index the rule
    • 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
      clientTokens No - 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 without client tokens:

Simple value field


Multivalue field


Date format

Date format yyyy-mm-dd is mandatory