Request File
The Request File for the Batch process details all the required deployment data and support across the different types of deployment, such as Generic, Air, Hotel and Rail.
The file can contain card requests for all card pools associated to a specific consumer.
File details
| File Details | Required Information |
|---|---|
| File Name | yyyy-MM-dd-hhmmss_RQ_ConsumerFileID_v1.csv The ConsumerFileID is a unique value that should be provided by the Consumer. This section of the file name will be used to create the filename of the response file. |
| Format | CSV. |
| Header Record | No. |
| Fixed Columns | Yes—All columns in the content definition must be included. Non-mandatory data can be left blank. |
Content
| Column Name | Description | Index | Format | Quoted | Max Length | Required | Example |
|---|---|---|---|---|---|---|---|
ConsumerReference | A unique reference provided by the consumer for the card deployment. | 1 | Alphanumeric | Y | 50 | Y | ABC13245DEF |
DeploymentID | If a DeploymentID is already known by the Consumer, set the value here to ensure the record is updated, rather than a new card deployed. | 2 | Numeric | N | 20 | N | 123456789 |
ClientID | The unique account number provided by Conferma. | 3 | Numeric | N | 10 | Y | 1234 |
Type | Details the type of Card Deployment being made: 3 = Generic 4 = Air 5 = Accommodation 6 = Rail | 4 | Numeric | N | 1 | Y | 4 |
CVVRequired | Is a CVV required in the response? 1= Yes 0 = No | 5 | Numeric | N | 1 | Y | 1 |
Name | Descriptive name for deployment. | 6 | Alphanumeric | Y | 50 | Y | MAN-LHR Flight |
Amount | The amount required on the payment card. | 7 | Decimal | Y | 10 | Y | 95.00 |
Currency | ISO 3-letter currency code the amount is in relation to. | 8 | Alpha | Y | 3 | Y | GBP |
ChargeStartDate | The date the card needs to be available from. | 9 | Date (yyyy-MM-dd) | N | 10 | Y | 2021-09-01 |
ChargeEndDate | The date the card needs to be available to. | 10 | Date (yyyy-MM-dd) | N | 10 | Y | 2021-09-01 |
CustomerID | A consumer defined customer ID. | 11 | Alphanumeric | Y | 50 | N | APPINK01 |
CustomerName | A consumer defined customer name. | 12 | Alphanumeric | Y | 50 | N | Test Company |
SupplierID | The customer's unique identifier for the supplier. | 13 | Alphanumeric | Y | 50 | N | APPLE1234 |
SupplierName | The name of the supplier taking payment. | 14 | Alphanumeric | Y | 100 | N | British AIrways |
SupplierAddress1 | Supplier address line 1. | 15 | Alphanumeric | Y | 100 | N | Small road |
SupplierAddress2 | Supplier address line 2. | 16 | Alphanumeric | Y | 100 | N | Big town |
SupplierCity | Supplier city name. | 17 | Alphanumeric | Y | 100 | N | Super city |
SupplierPostalOrZipCode | Supplier postal or zip code. | 18 | Alphanumeric | Y | 30 | N | M1 2BL |
SupplierCountryCode | ISO 2-letter country code. | 19 | Alpha | Y | 2 | N | GB |
SupplierTelephone | Supplier telephone number. | 20 | Alphanumeric | Y | 30 | N | 0161 123 4567 |
SupplierFax | Supplier fax number. | 21 | Alphanumeric | Y | 30 | N | 0161 123 4567 |
SupplierEmail | Supplier email address. | 22 | Alphanumeric | Y | 100 | N | [email protected] |
SupplierReference | Supplier's payment reference or invoice number. | 23 | Alphanumeric | Y | 50 | N | ABC1234D |
Identifiers | The customer identifiers of the deployment. Key~Value~ReportKey¬ format. Key = Name of value such as "Cost Centre".Value = Value of Key, such as "12345".ReportKey = Unique key for third parties usage. | 24 | Alphanumeric | Y | 50~200~50 | N | Cost Centre~123456~ DBI_COST¬Project Code~78 9654123~DBI_PRO |
Travellers | Declare the name of the travellers. Title~Forename~Surname¬ format. | 25 | Alphanumeric | Y | 10~30~30 | Y* | Mr~Stuart~Davenport¬ Ms~Abbi~Daniels |
AirOutboundSupplierCode | Two character airline code of airline running the flight. | 26 | Alphanumeric | Y | 2 | Y* | BA |
AirOutboundJourneyID | Flight number. | 27 | Numeric | Y | 10 | Y* | 5074 |
AirOutboundStartLocation | 3 character airport code. | 28 | Alphanumeric | Y | 3 | Y* | MAN |
AirOutboundStartDateTime | Departure date and time. | 29 | DateTime (yyyy-MM-dd hh:mm) | N | 16 | Y* | 2021-09-04 09:00 |
AirOutboundEndLocation | 3 character airport code. | 30 | Alphanumeric | Y | 3 | Y* | LHR |
AirOutboundEndDateTime | Arrival date and time. | 31 | DateTime (yyyy-MM-dd hh:mm) | N | 16 | Y* | 2021-09-04 10:15 |
AirReturnSupplierCode | Two character airline code of airline running the flight. | 32 | Alphanumeric | Y | 2 | Y* | BA |
AirReturnJourneyID | Flight number. | 33 | Numeric | Y | 10 | Y* | 5073 |
AirReturnStartLocation | 3 character airport code. | 34 | Alphanumeric | Y | 3 | Y* | LHR |
AirReturnStartDateTime | Departure date and time. | 35 | DateTime (yyyy-MM-dd hh:mm) | N | 16 | Y* | 2021-09-04 17:55 |
AirReturnEndLocation | 3 character airport code. | 36 | Alphanumeric | Y | 3 | Y* | MAN |
AirReturnEndDateTime | Arrival date and time. | 37 | DateTime (yyyy-MM-dd hh:mm) | N | 16 | Y* | 2021-09-04 19:05 |
HotelStayArrivalDate | Arrival date of hotel stay. | 38 | Date (yyyy-MM-dd) | N | 10 | Y* | 2021-09-05 |
HotelStayDepartureDate | Departure date of hotel stay. | 39 | Date (yyyy-MM-dd) | N | 10 | Y* | 2021-09-06 |
HotelRoomType | Room type. | 40 | Alphanumeric | Y | 30 | N | Single |
HotelRateInformation | Description of rate booked. | 41 | Alphanumeric | Y | 200 | N | Super saver rate including breakfast |
HotelRateBookingPlatform | Name of the system the booking was made. | 42 | Alphanumeric | Y | 50 | N | Sabre GDS |
HotelCancellationPolicy | Bookings cancellation policy. | 43 | Alphanumeric | Y | 200 | N | Cancel by 12pm day of arrival. |
HotelCancellationReference | Cancellation reference. | 44 | Alphanumeric | Y | 30 | N | CNX12345 |
HotelContactName | Name of contact. | 45 | Alphanumeric | Y | 100 | N | Steve Jones |
HotelCareOfName | Name of the company staying at hotel. UK TOMS requirement. | 46 | Alphanumeric | Y | 200 | N | Demo Corp. |
HotelPaymentInstruction | Payment instructions related to the hotel stay. | 47 | Alphanumeric | Y | 200 | N | Full account |
HotelComments | Hotel special requirements. | 48 | Alphanumeric | Y | 4000 | N | Ground floor room required. |
RailOutboundStartLocation | Departure station name. | 49 | Alphanumeric | Y | 50 | Y* | Manchester Piccadilly |
RailOutboundStartDateTime | Departure date and time. | 50 | DateTime (yyyy-MM-dd hh:mm) | N | 16 | Y* | 2021-09-04 17:55 |
RailOutboundEndLocation | Arrival station name. | 51 | Alphanumeric | Y | 50 | Y* | London Euston |
RailOutboundEndDateTime | Arrival date and time. | 52 | DateTime (yyyy-MM-dd hh:mm) | N | 16 | Y* | 2021-09-04 20:10 |
RailOutboundOperatorName | Operator name. | 53 | Alphanumeric | Y | 50 | N | Avanti West Coast |
RailOutboundTicketCost | Ticket cost. Relates to Currency field. | 54 | Decimal | N | 10 | Y* | 50.00 |
RailOutboundTicketClass | Class of ticket: E = Economy P = Premium Economy B = Business F = First | 55 | Alpha | N | 1 | Y* | B |
RailOutboundTicketDescription | Description of ticket. | 56 | Alphanumeric | Y | 100 | N | Advance single Coach B Seat 2A |
RailReturnStartLocation | Departure station name. | 57 | Alphanumeric | Y | 50 | Y* | London Euston |
RailReturnStartDateTime | Departure date and time. | 58 | DateTime (yyyy-MM-dd hh:mm) | N | 16 | Y* | 2021-09-05 10:00 |
RailReturnEndLocation | Arrival station name. | 59 | Alphanumeric | Y | 50 | Y* | Manchester Piccadilly |
RailReturnEndDateTime | Arrival date and time. | 60 | DateTime (yyyy-MM-dd hh:mm) | N | 16 | Y* | 2021-09-05 12:20 |
RailReturnOperatorName | Operator name. | 61 | Alphanumeric | Y | 50 | N | Avanti West Coast |
RailReturnTicketCost | Ticket cost. Relates to Currency field. | 62 | Decimal | N | 10 | Y* | 50.00 |
RailReturnTicketClass | Class of ticket: E = Economy P = Premium Economy B = Business F = First | 63 | Alpha | N | 1 | Y* | B |
RailReturnTicketDescription | Description of ticket. | 64 | Alphanumeric | Y | 100 | N | Advance single Coach B Seat 2A |
SendPaymentEmail | User should provide 1 to issue email, 0 to not. | 65 | Numeric | N | 1 | Y | 1 |
SendPaymentFax | User should provide 1 to issue fax, 0 to not. | 66 | Numeric | N | 1 | Y | 1 |
Y* conditional fields only required when combined with the appropriate travel spend type e.g. air data must be provided when the deployment type = air(4).
Updated about 1 year ago