Safety margin

The safety margin file should be in the below format:

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

    • ruleId → rule identifier
    • clientTokens → client Tokens*
    • supplierCodes → supplier code
    • notSupplierCodes → supplier code
    • creationDateFrom → start creation date Date format
    • creationDateTo → end creation date Date format
    • checkInFrom → checkinfrom date Date format
    • checkInTo → checkinto 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 (“.”)

    client tokens Identifier provided by the client that serves to filter which business rules can be applied for the sent request.

    • List file fields

      Field Mandatory Excluded fileds* Multi-value
      ruleId Yes - No
      clientTokens Yes - Yes
      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

      *Excluded fileds Informed field 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_safetymargin.csv

Data:

Simple value field

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

Multivalue field

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

Date format

Date format yyyy-mm-dd is mandatory


Comments