Export/Import Account Rates

The formats of the files that are exported and imported using the Export/Import Account Rates option are given below. Note that, for the import, the first line of each file is ignored (because it is expected to be the column header for the fields). The export option exports the column header as the first line of data for each file.

Note: The files are tab-delimited.

Export/Import Account Rates Utility

File	Field	Format
Rate Code	RateCodeID	x(20)
	StartDate	99/99/9999
	EndDate	99/99/9999
	Description	x(30)
	CarrierRateType	x(8)
	WholesaleAmount	9(8.2-)
	WholesaleUnitRate	9(6.6-)
	RetailAmount	9(8.2-)
	RetailUnitRate	9(6.6-)
Account Rate Class	CarrierRateClassID	x(8)
	Description	x(30)
Route Rate Class	DistribPointRateClassID	x(8)
	Description	x(30)
Rule Rate Link	RuleDeliverableID	x(12)
	RuleDeliveryID	x(12)
	RuleDistribPointID	x(12)
	RuleCarrierID	x(12)
	StartDate	99/99/9999
	EndDate	99/99/9999
	Carrier Rate Type	x(8)
	*DrawRateCodeID	x(20)
	*DrawChargeCodeID	x(8)
	*CreditRateCodeID	x(20)
	*CreditChargeCodeID	x(8)
	*ReturnRateCodeID	x(20)
	*ReturnChargeCodeID	x(8)
	*WeightBonusRateID	x(8)
	*PieceBonusRateID	x(8)
	* In the Rule Rate Link table, these fields are defined as arrays and have array elements 1 – 7 that correspond to each day of the week: Sun – Sat (1-7). For example: DrawRateCodeID[1], DrawRateCodeID[2], DrawRateCodeID[3], DrawRateCodeID[4], DrawRateCodeID[5], DrawRateCodeID[6], DrawRateCodeID[7].
Product Rule	RuleDeliverableID	x(12)
	ProductID	x(8)
Delivery Rule	RuleDeliveryID	x(12)
	RateCodeID	x(20)
	DeliveryScheduleID	x(8)
	DistribMethod	x(8)
	BonusDayDelivery	x(1)
Route Rule	RuleDistribPointID	x(12)
	RouteID	x(8)
	DistrictID	x(8)
	DistribPointRateClassID	x(8)
	AAMZoneID	x(6)
	DrawTypeClass	x(15)
	PaperCount	9(7)
Account Rule	RuleCarrierID	x(12)
	CarrierTypeID	x(8)
	CarrierRateClassID	x(8)
	AgeGroup	x(5)
	ContractLength	9(5)