Commission

The commission file should be in the below format:

• Encoding: UTF-8
• File Name:
  • context
  • sequential
  • commission
• 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

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

Multivalue field

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

Date format

---