Spectrum Ticket - Accounting Format

From KeystoneIntranet
Revision as of 00:02, 10 January 2017 by Intra>User (1 revision imported)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

This is the most common export for Alkon Spectrums. It is known as the Accounting, Hansco or 822 Character format.

Variations between versions affect the location of the Job, typically either pos 64 or 94. In later versions the user defined fields can vary as 2 20 character fields and a 10 charater field.

DATE                        1        C       8         MMDDYY  
TIME                        9        C       5         HH:MM  
CUSTOMER CODE              14        C      10         Your Code
ACCOUNT #                  24        C      10         
CUSTOMER NAME              34        C      30  
JOB NAME                   64        C
DELIVERY INST 1            94        C
P.O.#                     124        C      10  
S.O.#                     134        C      10  
N/A                       144        N       2  
C.O.D.                    146        C       1         Y/N  
N/A                       147        C       4  
TAX CODE                  151        C       4  
N/A                       155        N       8.2  
MIX DESIGN                163        C      10  
LOAD SIZE                 173        N       5.2  
PRICE PER UNIT            178        N       7.2  
N/A                       185        N       7.2  
DELIVERED                 192        N       7.2  
N/A                       199        N       5  
TRUCK #                   204        N       4  
DRIVER #                  208        C       5  
SLUMP                     213        N       4.1  
TKT   #                   217        N       6  
PLANT #                   223        N       2  
TAX CHARGE                225        N       8.2      
PREV TOTAL                233        N       8.2  
SUB TOTAL                 241        N       8.2  
DISCOUNT                  249        N       8.2  
TOTAL CHARGE              257        N       8.2  
GRAND TOTAL               265        N       8.2  
CALCIUM                   273        N       3.1  
TRUCK LEFT PLANT          277        C       5         HH:MM 24 HR  
TRUCK ON JOB              282        C       5         HH:MM 24 HR  
TRUCK LEFT JOB            287        C       5         HH:MM 24 HR  
TRUCK RETURN              292        C       5         HH:MM 24 HR  
USER 1                    297        C      10  
USER 2                    307        C      10  
USER 3                    317        C      10  
USER 4                    327        C      10  
USER 5                    337        C      10
PRODUCT CODE 1            347        C      10
QUANTITY ORDERED 1        357        N       7.2  
QUANTITY DELIVERED  1     364        N       7.2  
QUANTITY THIS BATCH 1     371        N       7.2  
PRICE 1                   378        N       6.2  

TOTAL PRICE 1             384        N       7.2
PRODUCT CODE 2            391        C      10  
QUANTITY ORDERED 2        401        N       7.2  
QUANTITY DELIVERED 2      408        N       7.2  
QUANTITY THIS BATCH 2     415        N       7.2  
PRICE 2                   421        N       6.2  

TOTAL PRICE 2             428        N       7.2
PRODUCT CODE 3            435        C      10
QUANTITY ORDERED 3        445        N       7.2
QUANTITY DELIVERED 3      452        N       7.2  
QUANTITY THIS BATCH 3     459        N       7.2  
PRICE 3                   466        N       6.2  
TOTAL PRICE 3             472        N       7.2

PRODUCT CODE 4            479        C      10
QUANTITY ORDERED 4        489        N       7.2  
QUANTITY DELIVERED  4     496        N       7.2  
QUANTITY THIS BATCH 4     503        N       7.2  
PRICE 4                   510        N       6.2  
TOTAL PRICE 4             516        N       7.2

PRODUCT CODE 5            523        C      10  
QUANTITY ORDERED 5        533        N       7.2  
QUANTITY DELIVERED 5      540        N       7.2  
QUANTITY THIS BATCH 5     547        N       7.2  
PRICE 5                   554        N       6.2  
TOTAL PRICE 5             560        N       7.2  

N/A                       568        C       5         Y/N  

TAXABLE 1                 573        C       1         Y/N  
TAXABLE 2                 574        C       1  
TAXABLE 3                 575        C       1  
TAXABLE 4                 576        C       1  
TAXABLE 5                 577        C       1  

CUST ADDRESS 1            578        C      30  
CUST ADDRESS 2            608        C      30  
CITY                      638        C      15  
STATE                     653        C       3  
ZIP                       656        C      10  
DESCRIPTION               667        C      30   
DESCRIPTION 2             697        C      30  
DESCRIPTION 3             727        C      30
DESCRIPTION 4             757        C      30
DESCRIPTION 5             787        C      30  
PERCENT DISCOUNT          817        N       6.2
TICKET SIZE               822