Vista Viewpoint

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 Units

12. Gross Weight

13. Tare Weight

14. Order Number

15. Phase

16. Cost Type

17. Feight 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. Not Used

26. COD Flag (H/E/N)

27. Ticket Total

28. Sale Type (C/J)

29. Not Used

30. Invoice #

31. Hauler Amount (To Pay)

32. Not Used

33. Not Used

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)

40. Deliver To (First Line)

41. Haul Zone Name

42. Ticket Note

43. Material Amount

44. Ticket UDF1

45. Ticket UDF2

46. Ticket UDF3

Fast-Weigh Spectrum Accounting Integration is an optional feature add-on. To add the Spectrum Accounting Integration to your Fast-Weigh subscription, contact us today at 865-219-2980 or [e-mail]