Import Templates

Interactive field reference, validation rules, and row builder for CLI FACTS import files. Use these to understand exactly what each column means and build valid import rows.

Field Reference

GroupRequiredMax 5 chars

A short code that names this geographic group. Lane exceptions reference this code to define where pricing rules apply. Every group used by a lane exception must exist here first.

BEDAZACCT1ANAFL1

DescriptionRequiredMax 30 chars

A human-readable label for the group, shown in the CLI interface when selecting lane geographies. Should describe the area covered.

AZ REGIONPHX AREA APPENTAIR FLORIDAANA MAPTITUDE 1.26.26

Zip/CityConditional

The ZIP code, wildcard pattern, or city name that belongs to this group. Leave blank if using St/Prov instead. Wildcards match any ZIP starting with the prefix (e.g. 94* matches 94000–94999). Leading zeros are preserved.

921738506*94*Toronto

St/ProvConditionalMax 2 chars

The state or province this row covers. Leave blank if using Zip/City instead. A state row means "this group includes the entire state." Cannot be combined with Zip/City on the same row.

AZCATXON

Import Rules

Each row uses either Zip/City or St/Prov — never both.
ZIP wildcards use a prefix followed by * (e.g. 94* matches 94000–94999).
Every group code referenced by a lane exception must exist in the rate area import first.
Group codes max 5 alphanumeric characters. Preserve leading zeros on ZIP codes.
State rows (blank Zip/City, filled St/Prov) match the entire state.

Example Rows

Type	Group	Description	Zip/City	St/Prov
STATE	BEDAZ	AZ REGION		AZ
STATE	BEDRZ	BEDROSIANS AZ ORIGIN		AZ
STATE	FL1	PENTAIR FLORIDA		FL
STATE	HBR04	TX OK		OK
ZIP	ANA	ANA MAPTITUDE 1.26.26	90086
ZIP	ANA	ANA MAPTITUDE 1.26.26	90087
ZIP	ANA	ANA MAPTITUDE 1.26.26	90088
ZIP	ANA	ANA MAPTITUDE 1.26.26	90089
WILDCARD	ANA	ANA MAPTITUDE 1.26.26	9135*
WILDCARD	ANA	ANA MAPTITUDE 1.26.26	9265*
WILDCARD	ANA	ANA MAPTITUDE 1.26.26	9286*
WILDCARD	BEDNA	BEDROSIANS NORCAL	94*

Row Builder

Fill in the fields below to build a rate area group row. Validation runs as you type.

Group (max 5, alphanumeric)

Description (max 30)

Zip/City (blank if using St/Prov)

St/Prov (blank if using Zip/City)

Exception Type

Each row has exactly one exception type. The active type determines which fields are required and which must be blank.

Discount rows: Discount percentage is required. RTC, Minimum, and Maximum must be blank. Example: Discount = 85 means an 85% discount off tariff rates for the specified lane.

Field Reference (29 columns)

Customer#Col 1Required

The bill-to customer code this exception applies to. Use * to apply to all customers.

BEDRO019AMERI010*

Company CodeCol 2Default: *

Company division code. Default * applies to all.

*

OriginCol 7RequiredDefault: *

Origin location — a ZIP code, state abbreviation, rate area group name, or * for any origin. Group names must match an imported rate area group exactly.

BEDNA*90210CA

DestinationCol 8RequiredDefault: *

Destination location — same format as Origin. Can use comma-separated values for multiple destinations (no spaces).

BEDAZ*TX

ReversibleCol 9RequiredDefault: NO

YES = this exception applies in both directions (Origin↔Destination). NO = one-way only.

YESNO

Origin TerminalCol 30Default: *

Origin terminal override. Default * applies to all terminals.

*

Destination TerminalCol 31Default: *

Destination terminal override. Default * applies to all terminals.

*

Exception TypeCol 11Required

The type of pricing exception. DISC = discount percentage. RTC = rate table code override. MIN/MAX = minimum or maximum charge. Only one type per row.

DISCRTCMIN/MAX

RTCCol 10

Rate table code — only used for RTC exception type. References a tariff loaded in CLI FACTS. Must be blank for DISC and MIN/MAX rows.

AMERIPALCZLI2013

DiscountCol 12

Discount percentage — only used for DISC exception type. Example: 85 means an 85% discount. Must be blank for RTC and MIN/MAX rows.

8590

MinimumCol 21

Minimum charge in dollars — only used for MIN/MAX exception type. At least one of Minimum or Maximum is required for MIN/MAX rows. Must be blank for DISC and RTC rows.

9570

MaximumCol 22

Maximum charge in dollars — only used for MIN/MAX exception type. Must be blank for DISC and RTC rows.

500

Effective DateCol 23RequiredDefault: 9/1/2020

When this exception becomes active. Format: MM/DD/YYYY. Leading zeros optional.

9/1/202001/01/2027

Expiry DateCol 24RequiredDefault: 12/31/2049

When this exception expires. Must be on or after the Effective Date. 12/31/2049 is used for "no expiration."

12/31/2049

Review DateCol 25RequiredDefault: 1/1/2027

Reminder date for manual review. Common value: 1/1/2027.

1/1/20271/1/2028

Example Rows(DISC type, 4 rows)

Type	Customer	Origin	Dest	Rev	Disc
DISC	BEDRO019	BEDNA	BEDAZ	NO	85
DISC	BEDRO019	BEDNA	BEDNA	NO	90
DISC	BEDRO019	BEDNA	BEDSA	NO	85
DISC	BEDRO019	BEDRZ	BEDAZ	NO	90

Row Builder

Build a lane exception row. Disabled fields are controlled by the selected exception type above.

Identity

Customer#

Company Code

Service Scope

Service Type

Billing Terms

Class/Commodity

Carrier

Geography

Origin

Destination

Reversible

Exception Definition

RTC

Discount

Minimum

Maximum

Dates

Effective Date

Expiry Date

Review Date

✕ Customer# is required

✕ Discount is required for DISC rows

,*,*,*,*,*,*,*,NO,,DISC,,,,,,,,,,,,,9/1/2020,12/31/2049,1/1/2027,0,0,0,0,*,*

What are gap rows?

Gap rows are lane exception scenarios that could not be automatically resolved during migration. They require a business decision before they can be imported. Do not force-import gap rows — review each one and decide whether to map, defer, or discard.

Customer	Category	Description	Action Needed
BRADY01	Tiered lane format not supported in current import slice	TIERED_ROW_NOT_APPROVED	—
BRADY01	Tiered lane format not supported in current import slice	TIERED_ROW_NOT_APPROVED	—
BRADY01	Tiered lane format not supported in current import slice	TIERED_ROW_NOT_APPROVED	—
BRADY01	Tiered lane format not supported in current import slice	TIERED_ROW_NOT_APPROVED	—
BRADY01	Tiered lane format not supported in current import slice	TIERED_ROW_NOT_APPROVED	—
ESTES002	Method flag not in approved lane logic	UNAPPROVED_METHOD:W	—
ESTES002	Method flag not in approved lane logic	UNAPPROVED_METHOD:W	—
FAIRG005	Pair-aware group mapping unresolved	Pair-aware collapse required for Z2 token: FGTTEO	—
FAIRG005	Pair-aware group mapping unresolved	Pair-aware collapse required for Z2 token: FGTTEO	—
FAIRG005	Pair-aware group mapping unresolved	Pair-aware collapse required for Z2 token: FGTTEO	—
FAIRG005	Pair-aware group mapping unresolved	Pair-aware collapse required for Z2 token: FGTTEO	—
FAIRG005	Pair-aware group mapping unresolved	Pair-aware collapse required for Z2 token: FGTTEO	—
FAIRG005	Pair-aware group mapping unresolved	Pair-aware collapse required for Z2 token: FGTTEO	—
FAIRG005	Pair-aware group mapping unresolved	Pair-aware collapse required for Z2 token: FGTTEO	—
FAIRG005	Pair-aware group mapping unresolved	Pair-aware collapse required for Z2 token: FGTTEO	—
MODED003	Pair-aware group mapping unresolved	Pair-aware collapse required for Z2 token: MODED1	—
MODED003	Pair-aware group mapping unresolved	Pair-aware collapse required for Z2 token: MODED2	—
MODED003	Pair-aware group mapping unresolved	Pair-aware collapse required for Z2 token: MODED4	—
MODED003	Pair-aware group mapping unresolved	Pair-aware collapse required for Z2 token: MODED5	—
MODED003	Pair-aware group mapping unresolved	Pair-aware collapse required for Z2 token: MODED6	—