# 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.

{% hint style="info" %}
**Note:** *The files are tab-delimited.*
{% endhint %}

### Export/Import Account Rates Utility

<table><thead><tr><th width="150">File</th><th width="399.33333333333337">Field</th><th width="150">Format</th></tr></thead><tbody><tr><td><strong>Rate Code</strong></td><td>RateCodeID</td><td>x(20)</td></tr><tr><td> </td><td>StartDate</td><td>99/99/9999</td></tr><tr><td> </td><td>EndDate</td><td>99/99/9999</td></tr><tr><td> </td><td>Description</td><td>x(30)</td></tr><tr><td> </td><td>CarrierRateType</td><td>x(8)</td></tr><tr><td> </td><td>WholesaleAmount</td><td>9(8.2-)</td></tr><tr><td> </td><td>WholesaleUnitRate</td><td>9(6.6-)</td></tr><tr><td> </td><td>RetailAmount</td><td>9(8.2-)</td></tr><tr><td> </td><td>RetailUnitRate</td><td>9(6.6-)</td></tr><tr><td> </td><td> </td><td> </td></tr><tr><td><strong>Account Rate Class</strong></td><td>CarrierRateClassID</td><td>x(8)</td></tr><tr><td> </td><td>Description</td><td>x(30)</td></tr><tr><td> </td><td> </td><td> </td></tr><tr><td><strong>Route Rate Class</strong></td><td>DistribPointRateClassID</td><td>x(8)</td></tr><tr><td> </td><td>Description</td><td>x(30)</td></tr><tr><td> </td><td> </td><td> </td></tr><tr><td><strong>Rule Rate Link</strong></td><td>RuleDeliverableID</td><td>x(12)</td></tr><tr><td> </td><td>RuleDeliveryID</td><td>x(12)</td></tr><tr><td> </td><td>RuleDistribPointID</td><td>x(12)</td></tr><tr><td> </td><td>RuleCarrierID</td><td>x(12)</td></tr><tr><td> </td><td>StartDate</td><td>99/99/9999</td></tr><tr><td> </td><td>EndDate</td><td>99/99/9999</td></tr><tr><td> </td><td>Carrier Rate Type</td><td>x(8)</td></tr><tr><td> </td><td>*DrawRateCodeID</td><td>x(20)</td></tr><tr><td> </td><td>*DrawChargeCodeID</td><td>x(8)</td></tr><tr><td> </td><td>*CreditRateCodeID</td><td>x(20)</td></tr><tr><td> </td><td>*CreditChargeCodeID</td><td>x(8)</td></tr><tr><td> </td><td>*ReturnRateCodeID</td><td>x(20)</td></tr><tr><td> </td><td>*ReturnChargeCodeID</td><td>x(8)</td></tr><tr><td></td><td>*WeightBonusRateID</td><td>x(8)</td></tr><tr><td> </td><td>*PieceBonusRateID</td><td>x(8)</td></tr><tr><td> </td><td><p><em><strong>*</strong> 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).</em> </p><p></p><p>For example: DrawRateCodeID[1], DrawRateCodeID[2], DrawRateCodeID[3], DrawRateCodeID[4], DrawRateCodeID[5], DrawRateCodeID[6], DrawRateCodeID[7].</p></td><td> </td></tr><tr><td> </td><td> </td><td> </td></tr><tr><td><strong>Product Rule</strong></td><td>RuleDeliverableID</td><td>x(12)</td></tr><tr><td> </td><td>ProductID</td><td>x(8)</td></tr><tr><td> </td><td> </td><td> </td></tr><tr><td><strong>Delivery Rule</strong></td><td>RuleDeliveryID</td><td>x(12)</td></tr><tr><td> </td><td>RateCodeID</td><td>x(20)</td></tr><tr><td> </td><td>DeliveryScheduleID</td><td>x(8)</td></tr><tr><td> </td><td>DistribMethod</td><td>x(8)</td></tr><tr><td> </td><td>BonusDayDelivery</td><td>x(1)</td></tr><tr><td> </td><td> </td><td> </td></tr><tr><td><strong>Route Rule</strong></td><td>RuleDistribPointID</td><td>x(12)</td></tr><tr><td> </td><td>RouteID</td><td>x(8)</td></tr><tr><td> </td><td>DistrictID</td><td>x(8)</td></tr><tr><td> </td><td>DistribPointRateClassID</td><td>x(8)</td></tr><tr><td> </td><td>AAMZoneID</td><td>x(6)</td></tr><tr><td> </td><td>DrawTypeClass</td><td>x(15)</td></tr><tr><td> </td><td>PaperCount</td><td>9(7)</td></tr><tr><td> </td><td> </td><td> </td></tr><tr><td><strong>Account Rule</strong></td><td>RuleCarrierID</td><td>x(12)</td></tr><tr><td> </td><td>CarrierTypeID</td><td>x(8)</td></tr><tr><td> </td><td>CarrierRateClassID</td><td>x(8)</td></tr><tr><td> </td><td>AgeGroup</td><td>x(5)</td></tr><tr><td> </td><td>ContractLength</td><td>9(5)</td></tr></tbody></table>