Batch Control Ticket Interfaces
Jump to navigation
Jump to search
Alkon Spectrum
- Spectrum Ticket - Accounting Format
- Spectrum Ticket - Extended Format
- Media:Spectrum format with decoding.xls - Spreadsheet to decode tickets for both 822 and 1136 formats
CommandAlkon PSI Eagle
Jonel
The Jonel batch system exports tickets in a format that is difficult for Keystone to import as-is. Therefore Keystone has a special "pre-process" pass that changes the format into something more manageable.
Here is the format of the pre-processed CSV file:
| Field # | Keystone Field | Description |
|---|---|---|
| 1 | CUST_NO | Customer # |
| 2 | JOB_PO_LOC | Job # |
| 3 | CUSTOMER_PO | Customer PO # |
| 4 | TICKET_DATE | Ship Date |
| 5 | SHIP_TO_1 | Ship To 1 |
| 6 | SHIP_TO_2 | Ship To 2 |
| 7 | SHIP_TO_3 | Ship To 3 |
| 8 | SHIP_TO_3 | Ship To 3 |
| 9 | TICKET_NO | Ticket # |
| 10 | PLANT_NO | Plant # |
| 11 | QTY_SOLD | Quantity Sold |
| 12 | PRODUCT_CODE | Product # |
| 13 | DESCRIPTION | Product Description |
| 14 | UNIT_PRICE | Price |
| 15 | TAX_CODE | Taxable |