http://in.compucrete.com/index.php?action=history&feed=atom&title=Batch_Control_Ticket_Interfaces
Batch Control Ticket Interfaces - Revision history
2026-05-15T15:13:29Z
Revision history for this page on the wiki
MediaWiki 1.40.0
http://in.compucrete.com/index.php?title=Batch_Control_Ticket_Interfaces&diff=66&oldid=prev
WikiAdmin: 1 revision imported
2023-07-14T12:58:48Z
<p>1 revision imported</p>
<table style="background-color: #fff; color: #202122;" data-mw="interface">
<tr class="diff-title" lang="en">
<td colspan="1" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td>
<td colspan="1" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 12:58, 14 July 2023</td>
</tr><tr><td colspan="2" class="diff-notice" lang="en"><div class="mw-diff-empty">(No difference)</div>
</td></tr></table>
WikiAdmin
http://in.compucrete.com/index.php?title=Batch_Control_Ticket_Interfaces&diff=65&oldid=prev
Pmorey at 03:22, 11 January 2017
2017-01-11T03:22:52Z
<p></p>
<p><b>New page</b></p><div>==Alkon Spectrum==<br />
<br />
:[[Spectrum Ticket - Accounting Format]]<br />
:[[Spectrum Ticket - Extended Format]]<br />
:[[Media:Spectrum format with decoding.xls]] - Spreadsheet to decode tickets for both 822 and 1136 formats<br />
<br />
==CommandAlkon PSI Eagle==<br />
<br />
:[[CommandAlkon Eagle Batch Ticket Export]]<br />
<br />
==Jonel==<br />
<br />
<p>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.</p> <br />
<p>Here is the format of the <b>pre-processed</b> CSV file:</p><br />
<br />
{| border="3" cellspacing="0" cellpadding="3" <br />
! Field #<br />
! Keystone Field<br />
! Description<br />
|-<br />
| 1<br />
| CUST_NO<br />
| Customer #<br />
|-<br />
| 2<br />
| JOB_PO_LOC<br />
| Job #<br />
|-<br />
| 3<br />
| CUSTOMER_PO<br />
| Customer PO #<br />
|-<br />
| 4<br />
| TICKET_DATE<br />
| Ship Date<br />
|-<br />
| 5<br />
| SHIP_TO_1<br />
| Ship To 1<br />
|-<br />
| 6<br />
| SHIP_TO_2<br />
| Ship To 2<br />
|-<br />
| 7<br />
| SHIP_TO_3<br />
| Ship To 3<br />
|-<br />
| 8<br />
| SHIP_TO_3<br />
| Ship To 3<br />
|-<br />
| 9<br />
| TICKET_NO<br />
| Ticket #<br />
|-<br />
| 10<br />
| PLANT_NO<br />
| Plant #<br />
|-<br />
| 11<br />
| QTY_SOLD<br />
| Quantity Sold<br />
|-<br />
| 12<br />
| PRODUCT_CODE<br />
| Product #<br />
|-<br />
| 13<br />
| DESCRIPTION<br />
| Product Description<br />
|-<br />
| 14<br />
| UNIT_PRICE<br />
| Price<br />
|-<br />
| 15<br />
| TAX_CODE<br />
| Taxable<br />
|}</div>
Pmorey