Spectrum Ticket - Extended 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 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