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


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://help.tacinsight.com/fast-weigh-knowledge-base/references/accounting-interfaces/vista-viewpoint.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.