CSV Output Examples

CSV Output Examples

CSV Output Examples

Each example is of the same 2 mixes with the different output formats

Example of the standard output CSV

Columns in Standard CSV Output (variable columns and each row represents 1 mix)

  1. Completed at Timestamp
  2. Mixed By
  3. Work Order Number
  4. Destination
  5. Notes
  6. Report Tags
  7. Products (Repeats columns for each product in the Mix)
    1. Name
    2. Target Amount
    3. Actual Amount
    4. Units of Measure

Example of the optional CSV output

Columns in Optional CSV Output (Standardized Columns and mixes are grouped by Mix ID)

  1. Mix ID
  2. Work Order Number
  3. Completed at Timestamp
  4. Mixed By
  5. Destination
  6. Notes
  7. Estimated Coverage (Displays "-" for Work Orders using totals)
  8. Estimated Coverage Rate Units (Displays "-" for Work Orders using totals)
  9. Report Tags
  10. Product Name
  11. Target Qty
  12. Actual Qty
  13. Unit of Measurement (REC20)
  14. (Optional) Report Tag Categories (Can be multiple columns)