About Sell Price Upload File Details

The sell price upload file is a specially formatted .TXT file used to add sell prices in bulk. An .XLS template is provided by CHAMP Cargosystems for the creation of the upload file. This file is created by entering the details on the template, then saving the file in Text (Tab delimited) format.

The first row in the file must always contain the column names that define the data in the rest of the file. These column names can be shown in any order, except that the field minimum_price should be followed only by the relevant prices based on the price type's weight breaks. The price columns should be the last fields in each row or record. The price_type column determines how many weight breaks are represented.
Table 1. Upload File Price Details
Column Names Mandatory or Optional Data Type Notes
forCarrier Mandatory VARCHAR(3) The carrier code for which the price is applicable. For example, XS.
salesRegion Mandatory VARCHAR(3) The sales area for which the price is applicable. The sales area set in the price record matches the price used in the AWB. The prices are only visible to operators with certain duty codes. For example, ZRH.
currency Mandatory VARCHAR(3) The three-letter ISO currency code used in the AWB. For example, USD.
kgLb Optional CHAR(1) The unit of weight that is by default set to KG. For example, L.
serviceLevel Optional VARCHAR(10) The cargo product code. For example, XPS.
dealCode Optional VARCHAR(10) The prices are grouped into different deal codes.
Agent Optional VARCHAR(11) The price used in the AWB that is dedicated to a certain Agent or Forwarder. For example, 1234567 or 12345678901.
Shipper Optional VARCHAR(11) For example, 11582812.
originZone Mandatory VARCHAR(6) The origin zone allows the combination of several origins to be priced collectively. For example, CH.
origin Mandatory CHAR(3) The three-letter IATA code of the airport of departure for which the price is applicable. For example, ZRH.
destZone Mandatory VARCHAR(6) The destination zone allows the combination of several destinations to be priced collectively. For example, US.
dest Mandatory CHAR(3) The three-letter IATA code of the airport of the final destination, for which the price is applicable. For example, JFK.
premium Optional CHAR(1) The premium indicates special promotional rates (Sale) or applicable rate increase (Premium). For example, P.
status Optional CHAR(1) The status indicates the correct status of the price record. For example, C.
prepaidCollect Optional CHAR(1) By default, this field is set to PREPAID. If the price is applicable for a collect shipment, the code COLLECT is entered in this field. For example, P.
reference Optional VARCHAR(22) The carrier reference number for a certain deal. For example, 12344HB373.
transitAirport Optional CHAR(3) The transitAirport field limits a deal to a certain transit point. The transit airport needs to be part of the routing for the price to be calculated. For example, LHR.
transitCarrier Optional CHAR(3) The transitCarrier field limits a deal to a certain transit point. The transit carrier needs to be part of the routing for the price to be calculated. For example, AA.
allotPrice Optional VARCHAR(6) The allotPrice limits the price for allotment records. For example, LH.
flightGroup Optional VARCHAR(5) The flightGroup limits certain deals to different types of flights. For example, RFS.
uldType Optional VARCHAR(4) The ULD type for which the deal is applicable. For example, PMS.
weekday Optional VARCHAR(7) For example, 1234567 or 5.
shcAddon Optional VARCHAR(7) For example, DGR.
remarkslnt Optional VARCHAR(256) The internal remarks that are not printed on any external document. For example, REMARK.
remarksExt Optional VARCHAR(256) The remarks printed on the price sheet. For example, REMARK.
priceTemplate Mandatory VARCHAR(10) The template code allows the user to create a customized data entry grid for pricing. For example, BULK.
fromDate Mandatory DATE For example, 20100101.
untilDate Optional DATE For example, 20100801.
priceClass Optional VARCHAR(10) The priceClass used for various net pricing levels. For example, VAL.
minAmount Mandatory NUMBER(9, 2) The minimum amount that is applicable for a certain deal. For example, 40.
rate01 Mandatory NUMBER(9, 2) For example, 1.22.
rate02 Optional NUMBER(9, 2) For example, 0.98.
rate03 Optional NUMBER(9, 2) For example, 0.80.
rate04 Optional NUMBER(9, 2) For example, 0.60.
rate05 Optional NUMBER(9, 2) For example, 0.50.
rate06 Optional NUMBER(9, 2) For example, 0.40.
rate 07 Optional NUMBER(9, 2) For example, 0.32.