> For the complete documentation index, see [llms.txt](https://help.tacinsight.com/fast-weigh-knowledge-base/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://help.tacinsight.com/fast-weigh-knowledge-base/references/accounting-interfaces/vista-viewpoint.md).

# Vista Viewpoint

### Spectrum Material Management / Vista MS Ticket Import File Layout <a href="#spectrum_material_management__vista_ms_ticket_import_file_layout" id="spectrum_material_management__vista_ms_ticket_import_file_layout"></a>

* 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:<br>
  * Material Sales Company :  *(insert company number or code)*
  * Batch Transaction Type :  *A*<br>

1. Ticket #
2. Customer ID
3. Job
4. Product ID&#x20;
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<br>

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 [support@tacinsight.com](mailto:support@tacinsight.com.)