Spectrum Ticket - Extended Format
Jump to navigation
Jump to search
This is the much less common extneded format:
| FIELD | LENGTH | POS | TYPE | FORMAT |
| DATE | 8 | 1 | C | MM/DD/YY |
| TIME | 5 | 9 | C | HH:MM |
| CUSTOMER CODE | 10 | 14 | C | |
| ACCOUNT # | 10 | 24 | C | |
| CUSTOMER NAME | 30 | 34 | C | |
| ADDRESS_1 | 30 | 64 | C | |
| ADDRESS_2 | 30 | 94 | C | |
| CITY | 15 | 124 | C | |
| STATE | 3 | 139 | C | |
| ZIP | 10 | 142 | C | |
| NOTES | 30 | 152 | C | |
| DELV1 | 30 | 182 | C | |
| DELV2 | 30 | 212 | C | |
| DELV3 | 30 | 242 | C | |
| DELV4 | 30 | 272 | C | |
| DELV5 | 30 | 302 | C | |
| DELV6 | 30 | 332 | C | |
| P.O.# | 10 | 362 | C | |
| S.O.# | 10 | 372 | C | |
| JOB # | 2 | 382 | C | |
| C.O.D. | 1 | 384 | C | |
| CREDIT CODE | 4 | 385 | C | |
| TAX CODE | 4 | 389 | C | |
| ProjectCode | 9 | 393 | C | |
| BATCH COST | 8.2 | 402 | C | |
| FORMULA | 10 | 410 | C | |
| form_desc | 40 | 420 | C | |
| LOAD SIZE | 5.2 | 460 | ||
| delv_add_1_ext | 19 | 465 | ||
| PRICE PER UNIT | 7.2 | 484 | ||
| ORDERED | 7.2 | 491 | ||
| DELIVERED | 7.2 | 498 | ||
| LOADS | 5 | 505 | ||
| TRUCK # | 4 | 510 | ||
| DRIVER # | 5 | 514 | ||
| DRIVERNAME | 15 | 519 | ||
| SLUMP | 4.1 | 534 | ||
| BATCH # | 6 | 538 | ||
| REMOTE_TKT_NO | 7 | 544 | ||
| PLANT # | 2 | 551 | ||
| TAX CHARGE | 8.2 | 553 | ||
| PREV TOTAL | 8.2 | 561 | ||
| SUB TOTAL | 8.2 | 569 | ||
| DISCOUNT | 8.2 | 577 | ||
| TOTAL CHARGE | 8.2 | 585 | ||
| GRAND TOTAL | 8.2 | 593 | ||
| PCT_DISC | 6 | 601 | ||
| CALCIUM | 4 | 607 | ||
| MEMO1 | 19 | 611 | ||
| MEMO2 | 19 | 630 | ||
| TRUCK LEFT PLANT | 5 | 649 | HH:MM 24 HR | |
| TRUCK ON JOB | 5 | 654 | HH:MM 24 HR | |
| TRUCK LEFT JOB | 5 | 659 | HH:MM 24 HR | |
| TRUCK RETURN | 5 | 664 | HH:MM 24 HR | |
| DELV_ADD_2_EXT | 19 | 669 | ||
| DELV_ADD_3_EXT | 19 | 688 | ||
| USER 1 | 10 | 707 | ||
| USER 2 | 10 | 717 | ||
| USER 3 | 10 | 727 | ||
| USER 4 | 10 | 737 | ||
| USER 5 | 10 | 747 | ||
| PRODUCT CODE 1 | 10 | 757 | ||
| PRDESC1 | 30 | 767 | ||
| QUANTITY ORDERED 1 | 7.2 | 797 | ||
| QUANTITY DELIVERED 1 | 7.2 | 804 | ||
| QUANTITY THIS BATCH 1 | 7.2 | 811 | ||
| TXBL1 | 1 | 818 | ||
| DISC1 | 1 | 819 | ||
| PRICE 1 | 6.2 | 820 | ||
| TOTAL PRICE 1 | 7.2 | 826 | ||
| PRODUCT CODE 2 | 10 | 833 | ||
| PRDESC2 | 30 | 843 | ||
| QUANTITY ORDERED 2 | 7.2 | 873 | ||
| QUANTITY DELIVERED 2 | 7.2 | 880 | ||
| QUANTITY THIS BATCH 2 | 7.2 | 887 | ||
| TXBL2 | 1 | 894 | ||
| DISC2 | 1 | 895 | ||
| PRICE 2 | 6.2 | 896 | ||
| TOTAL PRICE 2 | 7.2 | 902 | ||
| PRODUCT CODE 3 | 10 | 909 | ||
| PRDESC3 | 30 | 919 | ||
| QUANTITY ORDERED 3 | 7.2 | 949 | Y/N | |
| QUANTITY DELIVERED 3 | 7.2 | 956 | ||
| QUANTITY THIS BATCH 3 | 7.2 | 963 | ||
| TXBL3 | 1 | 970 | ||
| DISC3 | 1 | 971 | ||
| PRICE 3 | 6.2 | 972 | ||
| TOTAL PRICE 3 | 7.2 | 978 | ||
| PRODUCT CODE 4 | 10 | 985 | ||
| PRDESC3 | 30 | 995 | ||
| QUANTITY ORDERED 4 | 7.2 | 1025 | ||
| QUANTITY DELIVERED 4 | 7.2 | 1032 | ||
| QUANTITY THIS BATCH 4 | 7.2 | 1039 | ||
| TXBL4 | 1 | 1046 | ||
| DISC4 | 1 | 1047 | ||
| PRICE 4 | 6.2 | 1048 | ||
| TOTAL PRICE 4 | 7.2 | 1054 | ||
| PRODUCT CODE 5 | 10 | 1061 | ||
| PRDESC5 | 30 | 1071 | ||
| QUANTITY ORDERED 5 | 7.2 | 1101 | ||
| QUANTITY DELIVERED 5 | 7.2 | 1108 | ||
| QUANTITY THIS BATCH 5 | 7.2 | 1115 | ||
| TXBL5 | 1 | 1122 | ||
| DISC5 | 1 | 1123 | ||
| PRICE 5 | 6.2 | 1124 | ||
| TOTAL PRICE 5 | 7.2 | 1130 | ||