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
Date format yyyy-mm-dd is mandatory