Fast-Weigh 10 Help Center | TAC Insight

Spectrum / Vista Export File Mapping

Spectrum Material Management / Vista MS Ticket Import File Layout

For Spectrum MM import, file column numbers typically match the line numbers in the import template.

Some values will need to be hard coded in the Vista import.

Two common hard codings are:

Material Sales Company: (insert company number or code)

Batch Transaction Type: A

1 Ticket #

2 Customer ID

3 Job

4 Product ID

5 Date - quirk: Vista Month Column Ex: MM/01/YYY (3 y's is correct)

6 Time

7 Yard Code / From Location

8 Truck ID

9 Hauler ID

10 Unit Price

11 Net Weight

12 Gross Weight

13 Tare Weight

14 Order Number

15 Phase

16 Cost Type

17 Freight Rate (To charge)

18 Freight Amount (To charge)

19 Surcharge Amount

20 Tax Code

21 Tax Total

22 Batch Code

23 PO #

24 Order Description

25 ?

26 COD Flag (Y/N)

27 Ticket Total

28 Sale Type (C/J)

29 ?

30 Invoice #

31 Hauler Amount (To pay)

32 ?

33 ?

34 Order UDF1

35 Order UDF2

36 Order UDF3

37 Hauler Type (H/E/N)

38 Haul Basis (If per load, 1. If per unit, net units)

39 Haul Rate (To charge)