-
-
Notifications
You must be signed in to change notification settings - Fork 75
/
Copy pathTest2_UPS_EDI_210
2653 lines (2653 loc) · 155 KB
/
Test2_UPS_EDI_210
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
897
898
899
900
901
902
903
904
905
906
907
908
909
910
911
912
913
914
915
916
917
918
919
920
921
922
923
924
925
926
927
928
929
930
931
932
933
934
935
936
937
938
939
940
941
942
943
944
945
946
947
948
949
950
951
952
953
954
955
956
957
958
959
960
961
962
963
964
965
966
967
968
969
970
971
972
973
974
975
976
977
978
979
980
981
982
983
984
985
986
987
988
989
990
991
992
993
994
995
996
997
998
999
1000
[
{
"RawRecord": "{\"B3\":{\"amountDue\":\"1700\",\"invoiceDate\":\"20080726\",\"invoiceDueDate\":\"20080806\",\"invoiceNumber\":\"0000001808WW308\",\"paymentMethod\":\"PP\"},\"C3\":{\"currency\":\"USD\"},\"ITD\":{},\"L3\":{},\"N9\":{\"refId\":\"0000980205\",\"refIdQualifier\":\"18\"},\"SE\":{},\"ST\":{},\"lineItemInfo\":[{\"L0\":{\"ladingQuantity\":\"1\",\"packagingFormCode\":\"PCS\"},\"L1\":{\"charge\":\"1700\",\"chargeDesc\":\"\",\"chargeType\":\"SAC\"},\"LX\":{\"assignedNumber\":\"1\"},\"N9\":{\"date\":\"20080726\",\"product_code_C04004\":\"031\",\"refIdQualifier_N901\":\"ZZ\",\"refId_N902\":\"NA\"}},{\"L0\":{\"ladingQuantity\":\"1\",\"packagingFormCode\":\"PCS\"},\"L1\":[{\"charge\":\"12740\",\"chargeDesc\":\"\",\"chargeType\":\"400\"},{\"charge\":\"1500\",\"chargeDesc\":\"\",\"chargeType\":\"395\"},{\"charge\":\"2548\",\"chargeDesc\":\"\",\"chargeType\":\"FUE\"},{\"charge\":\"-1274\",\"chargeDesc\":\"\",\"chargeType\":\"295\"}],\"LX\":{\"assignedNumber\":\"2\"},\"N9\":[{\"date\":\"20080721\",\"product_code_C04004\":\"017\",\"refIdQualifier_N901\":\"CN\",\"refId_N902\":\"1Z1808WW0473048017\"},{\"date\":\"\",\"product_code_C04004\":\"\",\"refIdQualifier_N901\":\"D2\",\"refId_N902\":\"01\"},{\"date\":\"\",\"product_code_C04004\":\"\",\"refIdQualifier_N901\":\"LU\",\"refId_N902\":\"BT170\"}],\"consigneeInfo\":[{\"N1\":{\"entityIdentifierCode\":\"SH\"},\"N2\":{\"consigneeName\":\"US SHIPPER\"},\"N3\":{\"address1\":\"435 SOUTH ST\",\"address2\":\"\"},\"N4\":{\"city\":\"MORRISTOWN\",\"country\":\"US\",\"postal_code\":\"07960\",\"state_province\":\"NJ\"}},{\"N1\":{\"entityIdentifierCode\":\"CN\"},\"N2\":{\"consigneeName\":\"SMITH\"},\"N3\":{\"address1\":\"90 POLLUS BLVD\",\"address2\":\"\"},\"N4\":{\"city\":\"BELFEST\",\"country\":\"GB\",\"postal_code\":\"BT170\",\"state_province\":\"\"},\"N9\":{\"refIdQualifier_N901\":\"CR\",\"refId_N902\":\"7803A-0005-0001-1\"},\"cartonInfo\":{\"CD3\":{\"serviceLevel\":\"ZZ\",\"serviceStandard\":\"90\",\"weight\":\"10\",\"weightQualifier\":\"B\"}}}]},{\"L0\":{\"ladingQuantity\":\"1\",\"packagingFormCode\":\"PCS\"},\"L1\":[{\"charge\":\"-16788\",\"chargeDesc\":\"050\",\"chargeType\":\"CDF\"},{\"charge\":\"1274\",\"chargeDesc\":\"\",\"chargeType\":\"275\"}],\"LX\":{\"assignedNumber\":\"3\"},\"N9\":[{\"date\":\"20080721\",\"product_code_C04004\":\"040\",\"refIdQualifier_N901\":\"CN\",\"refId_N902\":\"1Z1808WW0473048017\"},{\"date\":\"\",\"product_code_C04004\":\"\",\"refIdQualifier_N901\":\"D2\",\"refId_N902\":\"01\"}],\"consigneeInfo\":{\"N1\":{\"entityIdentifierCode\":\"ZZ\"},\"cartonInfo\":{\"CD3\":{\"serviceLevel\":\"ZZ\",\"serviceStandard\":\"90\",\"weight\":\"10\",\"weightQualifier\":\"B\"}}}}],\"partyInfo\":[{\"N1\":{\"entityIdentifierCode\":\"BT\",\"identificationCode\":\"\",\"name\":\"JOHN 117\"},\"N2\":{},\"N3\":[{\"address1\":\"435 SOUTH ST\",\"address2\":\"SUITE 301\"},{\"address1\":\"INDUSTRIAL DISTRICT\",\"address2\":\"\"}],\"N4\":{\"city\":\"MORRISTOWN\",\"country\":\"US\",\"postal_code\":\"07960\",\"state_province\":\"NJ\"}},{\"N1\":{\"entityIdentifierCode\":\"SH\",\"identificationCode\":\"00001808WW\",\"name\":\"JOHN 117\"},\"N2\":{},\"N3\":[{\"address1\":\"435 SOUTH ST\",\"address2\":\"SUITE 301\"},{\"address1\":\"INDUSTRIAL DISTRICT\",\"address2\":\"\"}],\"N4\":{\"city\":\"MORRISTOWN\",\"country\":\"US\",\"postal_code\":\"07960\",\"state_province\":\"NJ\"}}]}",
"RawRecordHash": "199a15da-30d2-3f32-8907-f20100392379",
"TransformedRecord": {
"consolidated_bill_plan_number": "0000980205",
"invoice_date": "2008-07-26T00:00:00",
"invoice_due_date": "2008-08-06T00:00:00",
"invoice_number": "0000001808WW308",
"invoice_total_amount": 1700,
"invoice_total_amount_currency": "USD",
"line_items": [
{
"date": "2008-07-26T00:00:00",
"fees_and_charges": [
{
"charge": 1700,
"charge_type": "SAC"
}
],
"item_no": 1,
"number_of_pieces": 1,
"ups_product_code": "031"
},
{
"consignees": [
{
"address": {
"city": "BELFEST",
"country": "GB",
"line1": "90 POLLUS BLVD",
"postal_code": "BT170"
},
"customer_reference_number": "7803A-0005-0001-1",
"name": "SMITH",
"packages": [
{
"service_standard": "90",
"weight": 10,
"weight_qualifier": "B"
}
]
}
],
"date": "2008-07-21T00:00:00",
"fees_and_charges": [
{
"charge": 12740,
"charge_type": "400"
},
{
"charge": 1500,
"charge_type": "395"
},
{
"charge": 2548,
"charge_type": "FUE"
},
{
"charge": -1274,
"charge_type": "295"
}
],
"item_no": 2,
"number_of_pieces": 1,
"tracking_number": "1Z1808WW0473048017",
"ups_product_code": "017"
},
{
"date": "2008-07-21T00:00:00",
"fees_and_charges": [
{
"charge": -16788,
"charge_desc": "050",
"charge_type": "CDF"
},
{
"charge": 1274,
"charge_type": "275"
}
],
"item_no": 3,
"number_of_pieces": 1,
"tracking_number": "1Z1808WW0473048017",
"ups_product_code": "040"
}
],
"parties": [
{
"address": {
"city": "MORRISTOWN",
"country": "US",
"line1": "435 SOUTH ST",
"line2": "SUITE 301",
"line3": "INDUSTRIAL DISTRICT",
"postal_code": "07960",
"state_province": "NJ"
},
"entity_identifier": "Bill to Party",
"entity_identifier_code": "BT",
"name": "JOHN 117"
},
{
"address": {
"city": "MORRISTOWN",
"country": "US",
"line1": "435 SOUTH ST",
"line2": "SUITE 301",
"line3": "INDUSTRIAL DISTRICT",
"postal_code": "07960",
"state_province": "NJ"
},
"entity_identifier": "Shipper",
"entity_identifier_code": "SH",
"identification_code": "00001808WW",
"name": "JOHN 117"
}
],
"payment_method": "Prepaid"
}
},
{
"RawRecord": "{\"B3\":{\"amountDue\":\"9415\",\"invoiceDate\":\"20080726\",\"invoiceDueDate\":\"20080804\",\"invoiceNumber\":\"0000001502WW308\",\"paymentMethod\":\"PP\"},\"C3\":{\"currency\":\"USD\"},\"ITD\":{},\"L3\":{},\"N9\":{\"refId\":\"0000980209\",\"refIdQualifier\":\"18\"},\"SE\":{},\"ST\":{},\"lineItemInfo\":[{\"L0\":{\"ladingQuantity\":\"1\",\"packagingFormCode\":\"PCS\"},\"L1\":{\"charge\":\"800\",\"chargeDesc\":\"\",\"chargeType\":\"SAC\"},\"LX\":{\"assignedNumber\":\"1\"},\"N9\":{\"date\":\"20080726\",\"product_code_C04004\":\"031\",\"refIdQualifier_N901\":\"ZZ\",\"refId_N902\":\"NA\"}},{\"L0\":{\"ladingQuantity\":\"3\",\"packagingFormCode\":\"PCS\"},\"L1\":[{\"charge\":\"15216\",\"chargeDesc\":\"\",\"chargeType\":\"400\"},{\"charge\":\"-302\",\"chargeDesc\":\"\",\"chargeType\":\"275\"}],\"LX\":{\"assignedNumber\":\"2\"},\"N9\":{\"date\":\"20080721\",\"product_code_C04004\":\"011\",\"refIdQualifier_N901\":\"P8\",\"refId_N902\":\"0247498042\"},\"consigneeInfo\":{\"N1\":{\"entityIdentifierCode\":\"ZZ\"},\"cartonInfo\":{\"CD3\":{\"serviceLevel\":\"SG\",\"serviceStandard\":\"\",\"weight\":\"0\",\"weightQualifier\":\"Z\"}}}},{\"L0\":{\"ladingQuantity\":\"1\",\"packagingFormCode\":\"PCS\"},\"L1\":[{\"charge\":\"-1100\",\"chargeDesc\":\"014\",\"chargeType\":\"AAJ\"},{\"charge\":\"100\",\"chargeDesc\":\"\",\"chargeType\":\"275\"}],\"LX\":{\"assignedNumber\":\"3\"},\"N9\":{\"date\":\"20080719\",\"product_code_C04004\":\"028\",\"refIdQualifier_N901\":\"ZZ\",\"refId_N902\":\"NA\"},\"consigneeInfo\":{\"N1\":{\"entityIdentifierCode\":\"ZZ\"},\"cartonInfo\":{\"CD3\":{\"serviceLevel\":\"ZZ\",\"serviceStandard\":\"\",\"weight\":\"0\",\"weightQualifier\":\"Z\"}}}},{\"L0\":{\"ladingQuantity\":\"1\",\"packagingFormCode\":\"PCS\"},\"L1\":[{\"charge\":\"-1000\",\"chargeDesc\":\"014\",\"chargeType\":\"AAJ\"},{\"charge\":\"100\",\"chargeDesc\":\"\",\"chargeType\":\"275\"}],\"LX\":{\"assignedNumber\":\"4\"},\"N9\":{\"date\":\"20080726\",\"product_code_C04004\":\"028\",\"refIdQualifier_N901\":\"CN\",\"refId_N902\":\"1Z1502WW1264639290\"},\"consigneeInfo\":{\"N1\":{\"entityIdentifierCode\":\"ZZ\"},\"cartonInfo\":{\"CD3\":{\"serviceLevel\":\"ZZ\",\"serviceStandard\":\"\",\"weight\":\"0\",\"weightQualifier\":\"Z\"}}}},{\"L0\":{\"ladingQuantity\":\"1\",\"packagingFormCode\":\"PCS\"},\"L1\":[{\"charge\":\"-1000\",\"chargeDesc\":\"014\",\"chargeType\":\"AAJ\"},{\"charge\":\"100\",\"chargeDesc\":\"\",\"chargeType\":\"275\"}],\"LX\":{\"assignedNumber\":\"5\"},\"N9\":{\"date\":\"20080719\",\"product_code_C04004\":\"028\",\"refIdQualifier_N901\":\"CN\",\"refId_N902\":\"1Z1502WW1265258413\"},\"consigneeInfo\":{\"N1\":{\"entityIdentifierCode\":\"ZZ\"},\"cartonInfo\":{\"CD3\":{\"serviceLevel\":\"ZZ\",\"serviceStandard\":\"\",\"weight\":\"0\",\"weightQualifier\":\"Z\"}}}},{\"L0\":{\"ladingQuantity\":\"1\",\"packagingFormCode\":\"PCS\"},\"L1\":{\"charge\":\"-1000\",\"chargeDesc\":\"014\",\"chargeType\":\"AAJ\"},\"LX\":{\"assignedNumber\":\"6\"},\"N9\":{\"date\":\"20080719\",\"product_code_C04004\":\"028\",\"refIdQualifier_N901\":\"CN\",\"refId_N902\":\"1Z1502WW1266427827\"},\"consigneeInfo\":{\"N1\":{\"entityIdentifierCode\":\"ZZ\"},\"cartonInfo\":{\"CD3\":{\"serviceLevel\":\"ZZ\",\"serviceStandard\":\"\",\"weight\":\"0\",\"weightQualifier\":\"Z\"}}}},{\"L0\":{\"ladingQuantity\":\"1\",\"packagingFormCode\":\"PCS\"},\"L1\":[{\"charge\":\"756\",\"chargeDesc\":\"015C\",\"chargeType\":\"AAJ\"},{\"charge\":\"-680\",\"chargeDesc\":\"015O\",\"chargeType\":\"AAJ\"},{\"charge\":\"195\",\"chargeDesc\":\"\",\"chargeType\":\"REP\"},{\"charge\":\"56\",\"chargeDesc\":\"\",\"chargeType\":\"010\"},{\"charge\":\"33\",\"chargeDesc\":\"\",\"chargeType\":\"FUE\"}],\"LX\":{\"assignedNumber\":\"7\"},\"N9\":[{\"date\":\"20080721\",\"product_code_C04004\":\"028\",\"refIdQualifier_N901\":\"P8\",\"refId_N902\":\"0247498042\"},{\"date\":\"\",\"product_code_C04004\":\"\",\"refIdQualifier_N901\":\"CN\",\"refId_N902\":\"1Z1502WW0364856518\"},{\"date\":\"\",\"product_code_C04004\":\"\",\"refIdQualifier_N901\":\"D2\",\"refId_N902\":\"01\"},{\"date\":\"\",\"product_code_C04004\":\"\",\"refIdQualifier_N901\":\"LU\",\"refId_N902\":\"75228\"}],\"consigneeInfo\":{\"N1\":{\"entityIdentifierCode\":\"ZZ\"},\"N9\":{\"refIdQualifier_N901\":\"CR\",\"refId_N902\":\"7803A-0005-0011-1\"},\"cartonInfo\":{\"CD3\":{\"serviceLevel\":\"ZZ\",\"serviceStandard\":\"\",\"weight\":\"10\",\"weightQualifier\":\"B\"}}}},{\"L0\":{\"ladingQuantity\":\"1\",\"packagingFormCode\":\"PCS\"},\"L1\":[{\"charge\":\"-1876\",\"chargeDesc\":\"021\",\"chargeType\":\"RFD\"},{\"charge\":\"-610\",\"chargeDesc\":\"\",\"chargeType\":\"010\"},{\"charge\":\"-539\",\"chargeDesc\":\"\",\"chargeType\":\"FUE\"},{\"charge\":\"166\",\"chargeDesc\":\"\",\"chargeType\":\"295\"}],\"LX\":{\"assignedNumber\":\"8\"},\"N9\":[{\"date\":\"20080714\",\"product_code_C04004\":\"029\",\"refIdQualifier_N901\":\"CN\",\"refId_N902\":\"1Z1502WW1265812206\"},{\"date\":\"\",\"product_code_C04004\":\"\",\"refIdQualifier_N901\":\"D2\",\"refId_N902\":\"01\"}],\"consigneeInfo\":[{\"N1\":{\"entityIdentifierCode\":\"SH\"},\"N3\":{\"address1\":\"MAIN\",\"address2\":\"\"},\"N4\":{\"city\":\"DENVILLE\",\"country\":\"US\",\"postal_code\":\"07834\",\"state_province\":\"\"}},{\"N1\":{\"entityIdentifierCode\":\"CN\"},\"N2\":{\"consigneeName\":\"Smith\"},\"N3\":{\"address1\":\"33 SOUTH ST\",\"address2\":\"\"},\"N4\":{\"city\":\"DALLAS\",\"country\":\"US\",\"postal_code\":\"75228\",\"state_province\":\"TX\"},\"N9\":{\"refIdQualifier_N901\":\"CR\",\"refId_N902\":\"7803A-0005-0004-1\"},\"cartonInfo\":{\"CD3\":{\"serviceLevel\":\"ZZ\",\"serviceStandard\":\"3\",\"weight\":\"\",\"weightQualifier\":\"\"}}}]}],\"partyInfo\":[{\"N1\":{\"entityIdentifierCode\":\"BT\",\"identificationCode\":\"\",\"name\":\"CRM TT\"},\"N3\":{\"address1\":\"MAIN\",\"address2\":\"\"},\"N4\":{\"city\":\"DENVILLE\",\"country\":\"US\",\"postal_code\":\"07834\",\"state_province\":\"NJ\"}},{\"N1\":{\"entityIdentifierCode\":\"SH\",\"identificationCode\":\"00001502WW\",\"name\":\"CRM TT\"},\"N3\":{\"address1\":\"MAIN\",\"address2\":\"\"},\"N4\":{\"city\":\"DENVILLE\",\"country\":\"US\",\"postal_code\":\"07834\",\"state_province\":\"NJ\"}}]}",
"RawRecordHash": "f634f0de-e47a-3628-97cb-50a770fe3bf1",
"TransformedRecord": {
"consolidated_bill_plan_number": "0000980209",
"invoice_date": "2008-07-26T00:00:00",
"invoice_due_date": "2008-08-04T00:00:00",
"invoice_number": "0000001502WW308",
"invoice_total_amount": 9415,
"invoice_total_amount_currency": "USD",
"line_items": [
{
"date": "2008-07-26T00:00:00",
"fees_and_charges": [
{
"charge": 800,
"charge_type": "SAC"
}
],
"item_no": 1,
"number_of_pieces": 1,
"ups_product_code": "031"
},
{
"date": "2008-07-21T00:00:00",
"fees_and_charges": [
{
"charge": 15216,
"charge_type": "400"
},
{
"charge": -302,
"charge_type": "275"
}
],
"item_no": 2,
"number_of_pieces": 3,
"ups_product_code": "011"
},
{
"date": "2008-07-19T00:00:00",
"fees_and_charges": [
{
"charge": -1100,
"charge_desc": "014",
"charge_type": "AAJ"
},
{
"charge": 100,
"charge_type": "275"
}
],
"item_no": 3,
"number_of_pieces": 1,
"ups_product_code": "028"
},
{
"date": "2008-07-26T00:00:00",
"fees_and_charges": [
{
"charge": -1000,
"charge_desc": "014",
"charge_type": "AAJ"
},
{
"charge": 100,
"charge_type": "275"
}
],
"item_no": 4,
"number_of_pieces": 1,
"tracking_number": "1Z1502WW1264639290",
"ups_product_code": "028"
},
{
"date": "2008-07-19T00:00:00",
"fees_and_charges": [
{
"charge": -1000,
"charge_desc": "014",
"charge_type": "AAJ"
},
{
"charge": 100,
"charge_type": "275"
}
],
"item_no": 5,
"number_of_pieces": 1,
"tracking_number": "1Z1502WW1265258413",
"ups_product_code": "028"
},
{
"date": "2008-07-19T00:00:00",
"fees_and_charges": [
{
"charge": -1000,
"charge_desc": "014",
"charge_type": "AAJ"
}
],
"item_no": 6,
"number_of_pieces": 1,
"tracking_number": "1Z1502WW1266427827",
"ups_product_code": "028"
},
{
"date": "2008-07-21T00:00:00",
"fees_and_charges": [
{
"charge": 756,
"charge_desc": "015C",
"charge_type": "AAJ"
},
{
"charge": -680,
"charge_desc": "015O",
"charge_type": "AAJ"
},
{
"charge": 195,
"charge_type": "REP"
},
{
"charge": 56,
"charge_type": "010"
},
{
"charge": 33,
"charge_type": "FUE"
}
],
"item_no": 7,
"number_of_pieces": 1,
"tracking_number": "1Z1502WW0364856518",
"ups_product_code": "028"
},
{
"consignees": [
{
"address": {
"city": "DALLAS",
"country": "US",
"line1": "33 SOUTH ST",
"postal_code": "75228",
"state_province": "TX"
},
"customer_reference_number": "7803A-0005-0004-1",
"name": "Smith",
"packages": [
{
"service_standard": "3"
}
]
}
],
"date": "2008-07-14T00:00:00",
"fees_and_charges": [
{
"charge": -1876,
"charge_desc": "021",
"charge_type": "RFD"
},
{
"charge": -610,
"charge_type": "010"
},
{
"charge": -539,
"charge_type": "FUE"
},
{
"charge": 166,
"charge_type": "295"
}
],
"item_no": 8,
"number_of_pieces": 1,
"tracking_number": "1Z1502WW1265812206",
"ups_product_code": "029"
}
],
"parties": [
{
"address": {
"city": "DENVILLE",
"country": "US",
"line1": "MAIN",
"postal_code": "07834",
"state_province": "NJ"
},
"entity_identifier": "Bill to Party",
"entity_identifier_code": "BT",
"name": "CRM TT"
},
{
"address": {
"city": "DENVILLE",
"country": "US",
"line1": "MAIN",
"postal_code": "07834",
"state_province": "NJ"
},
"entity_identifier": "Shipper",
"entity_identifier_code": "SH",
"identification_code": "00001502WW",
"name": "CRM TT"
}
],
"payment_method": "Prepaid"
}
},
{
"RawRecord": "{\"B3\":{\"amountDue\":\"28555\",\"invoiceDate\":\"20080726\",\"invoiceDueDate\":\"20080806\",\"invoiceNumber\":\"0000004045WW308\",\"paymentMethod\":\"PP\"},\"C3\":{\"currency\":\"USD\"},\"ITD\":{},\"L3\":{},\"N9\":{\"refId\":\"0000980223\",\"refIdQualifier\":\"18\"},\"SE\":{},\"ST\":{},\"lineItemInfo\":[{\"L0\":{\"ladingQuantity\":\"1\",\"packagingFormCode\":\"PCS\"},\"L1\":{\"charge\":\"800\",\"chargeDesc\":\"\",\"chargeType\":\"SAC\"},\"LX\":{\"assignedNumber\":\"1\"},\"N9\":{\"date\":\"20080726\",\"product_code_C04004\":\"031\",\"refIdQualifier_N901\":\"ZZ\",\"refId_N902\":\"NA\"}},{\"L0\":{\"ladingQuantity\":\"5\",\"packagingFormCode\":\"PCS\"},\"L1\":[{\"charge\":\"32970\",\"chargeDesc\":\"\",\"chargeType\":\"400\"},{\"charge\":\"-4615\",\"chargeDesc\":\"\",\"chargeType\":\"275\"}],\"LX\":{\"assignedNumber\":\"2\"},\"N9\":{\"date\":\"20080721\",\"product_code_C04004\":\"011\",\"refIdQualifier_N901\":\"P8\",\"refId_N902\":\"0228192042\"},\"consigneeInfo\":{\"N1\":{\"entityIdentifierCode\":\"ZZ\"},\"cartonInfo\":{\"CD3\":{\"serviceLevel\":\"ND\",\"serviceStandard\":\"\",\"weight\":\"0\",\"weightQualifier\":\"Z\"}}}},{\"L0\":{\"ladingQuantity\":\"1\",\"packagingFormCode\":\"PCS\"},\"L1\":[{\"charge\":\"4396\",\"chargeDesc\":\"015C\",\"chargeType\":\"AAJ\"},{\"charge\":\"-4726\",\"chargeDesc\":\"015O\",\"chargeType\":\"AAJ\"},{\"charge\":\"230\",\"chargeDesc\":\"\",\"chargeType\":\"REP\"},{\"charge\":\"-20\",\"chargeDesc\":\"\",\"chargeType\":\"FUE\"}],\"LX\":{\"assignedNumber\":\"3\"},\"N9\":[{\"date\":\"20080721\",\"product_code_C04004\":\"028\",\"refIdQualifier_N901\":\"P8\",\"refId_N902\":\"0228192042\"},{\"date\":\"\",\"product_code_C04004\":\"\",\"refIdQualifier_N901\":\"CN\",\"refId_N902\":\"1Z4045WW0147641818\"},{\"date\":\"\",\"product_code_C04004\":\"\",\"refIdQualifier_N901\":\"D2\",\"refId_N902\":\"01\"},{\"date\":\"\",\"product_code_C04004\":\"\",\"refIdQualifier_N901\":\"LU\",\"refId_N902\":\"07753\"}],\"consigneeInfo\":{\"N1\":{\"entityIdentifierCode\":\"ZZ\"},\"N9\":{\"refIdQualifier_N901\":\"CR\",\"refId_N902\":\"7817--0001-0016-1\"},\"cartonInfo\":{\"CD3\":{\"serviceLevel\":\"ZZ\",\"serviceStandard\":\"\",\"weight\":\"40\",\"weightQualifier\":\"B\"}}}},{\"L0\":{\"ladingQuantity\":\"1\",\"packagingFormCode\":\"PCS\"},\"L1\":[{\"charge\":\"4396\",\"chargeDesc\":\"015C\",\"chargeType\":\"AAJ\"},{\"charge\":\"-4726\",\"chargeDesc\":\"015O\",\"chargeType\":\"AAJ\"},{\"charge\":\"230\",\"chargeDesc\":\"\",\"chargeType\":\"REP\"},{\"charge\":\"-20\",\"chargeDesc\":\"\",\"chargeType\":\"FUE\"}],\"LX\":{\"assignedNumber\":\"4\"},\"N9\":[{\"date\":\"20080721\",\"product_code_C04004\":\"028\",\"refIdQualifier_N901\":\"P8\",\"refId_N902\":\"0228192042\"},{\"date\":\"\",\"product_code_C04004\":\"\",\"refIdQualifier_N901\":\"CN\",\"refId_N902\":\"1Z4045WW0147988025\"},{\"date\":\"\",\"product_code_C04004\":\"\",\"refIdQualifier_N901\":\"D2\",\"refId_N902\":\"01\"},{\"date\":\"\",\"product_code_C04004\":\"\",\"refIdQualifier_N901\":\"LU\",\"refId_N902\":\"07753\"}],\"consigneeInfo\":{\"N1\":{\"entityIdentifierCode\":\"ZZ\"},\"N9\":{\"refIdQualifier_N901\":\"CR\",\"refId_N902\":\"7817--0001-0016-2\"},\"cartonInfo\":{\"CD3\":{\"serviceLevel\":\"ZZ\",\"serviceStandard\":\"\",\"weight\":\"40\",\"weightQualifier\":\"B\"}}}},{\"L0\":{\"ladingQuantity\":\"1\",\"packagingFormCode\":\"PCS\"},\"L1\":[{\"charge\":\"4396\",\"chargeDesc\":\"015C\",\"chargeType\":\"AAJ\"},{\"charge\":\"-4726\",\"chargeDesc\":\"015O\",\"chargeType\":\"AAJ\"},{\"charge\":\"230\",\"chargeDesc\":\"\",\"chargeType\":\"REP\"},{\"charge\":\"-20\",\"chargeDesc\":\"\",\"chargeType\":\"FUE\"}],\"LX\":{\"assignedNumber\":\"5\"},\"N9\":[{\"date\":\"20080721\",\"product_code_C04004\":\"028\",\"refIdQualifier_N901\":\"P8\",\"refId_N902\":\"0228192042\"},{\"date\":\"\",\"product_code_C04004\":\"\",\"refIdQualifier_N901\":\"CN\",\"refId_N902\":\"1Z4045WW0148640835\"},{\"date\":\"\",\"product_code_C04004\":\"\",\"refIdQualifier_N901\":\"D2\",\"refId_N902\":\"01\"},{\"date\":\"\",\"product_code_C04004\":\"\",\"refIdQualifier_N901\":\"LU\",\"refId_N902\":\"07753\"}],\"consigneeInfo\":{\"N1\":{\"entityIdentifierCode\":\"ZZ\"},\"N9\":{\"refIdQualifier_N901\":\"CR\",\"refId_N902\":\"7817--0001-0016-3\"},\"cartonInfo\":{\"CD3\":{\"serviceLevel\":\"ZZ\",\"serviceStandard\":\"\",\"weight\":\"40\",\"weightQualifier\":\"B\"}}}},{\"L0\":{\"ladingQuantity\":\"1\",\"packagingFormCode\":\"PCS\"},\"L1\":[{\"charge\":\"4396\",\"chargeDesc\":\"015C\",\"chargeType\":\"AAJ\"},{\"charge\":\"-4726\",\"chargeDesc\":\"015O\",\"chargeType\":\"AAJ\"},{\"charge\":\"230\",\"chargeDesc\":\"\",\"chargeType\":\"REP\"},{\"charge\":\"-20\",\"chargeDesc\":\"\",\"chargeType\":\"FUE\"}],\"LX\":{\"assignedNumber\":\"6\"},\"N9\":[{\"date\":\"20080721\",\"product_code_C04004\":\"028\",\"refIdQualifier_N901\":\"P8\",\"refId_N902\":\"0228192042\"},{\"date\":\"\",\"product_code_C04004\":\"\",\"refIdQualifier_N901\":\"CN\",\"refId_N902\":\"1Z4045WW0146636246\"},{\"date\":\"\",\"product_code_C04004\":\"\",\"refIdQualifier_N901\":\"D2\",\"refId_N902\":\"01\"},{\"date\":\"\",\"product_code_C04004\":\"\",\"refIdQualifier_N901\":\"LU\",\"refId_N902\":\"07753\"}],\"consigneeInfo\":{\"N1\":{\"entityIdentifierCode\":\"ZZ\"},\"N9\":{\"refIdQualifier_N901\":\"CR\",\"refId_N902\":\"7817--0001-0016-4\"},\"cartonInfo\":{\"CD3\":{\"serviceLevel\":\"ZZ\",\"serviceStandard\":\"\",\"weight\":\"40\",\"weightQualifier\":\"B\"}}}},{\"L0\":{\"ladingQuantity\":\"1\",\"packagingFormCode\":\"PCS\"},\"L1\":[{\"charge\":\"4396\",\"chargeDesc\":\"015C\",\"chargeType\":\"AAJ\"},{\"charge\":\"-4726\",\"chargeDesc\":\"015O\",\"chargeType\":\"AAJ\"},{\"charge\":\"230\",\"chargeDesc\":\"\",\"chargeType\":\"REP\"},{\"charge\":\"-20\",\"chargeDesc\":\"\",\"chargeType\":\"FUE\"}],\"LX\":{\"assignedNumber\":\"7\"},\"N9\":[{\"date\":\"20080721\",\"product_code_C04004\":\"028\",\"refIdQualifier_N901\":\"P8\",\"refId_N902\":\"0228192042\"},{\"date\":\"\",\"product_code_C04004\":\"\",\"refIdQualifier_N901\":\"CN\",\"refId_N902\":\"1Z4045WW0146570254\"},{\"date\":\"\",\"product_code_C04004\":\"\",\"refIdQualifier_N901\":\"D2\",\"refId_N902\":\"01\"},{\"date\":\"\",\"product_code_C04004\":\"\",\"refIdQualifier_N901\":\"LU\",\"refId_N902\":\"07753\"}],\"consigneeInfo\":{\"N1\":{\"entityIdentifierCode\":\"ZZ\"},\"N9\":{\"refIdQualifier_N901\":\"CR\",\"refId_N902\":\"7817--0001-0016-5\"},\"cartonInfo\":{\"CD3\":{\"serviceLevel\":\"ZZ\",\"serviceStandard\":\"\",\"weight\":\"40\",\"weightQualifier\":\"B\"}}}}],\"partyInfo\":[{\"N1\":{\"entityIdentifierCode\":\"BT\",\"identificationCode\":\"\",\"name\":\"RODEO\"},\"N2\":{},\"N3\":{\"address1\":\"90 MAIN ST\",\"address2\":\"\"},\"N4\":{\"city\":\"MORRISTOWN\",\"country\":\"US\",\"postal_code\":\"07960\",\"state_province\":\"NJ\"}},{\"N1\":{\"entityIdentifierCode\":\"SH\",\"identificationCode\":\"00004045WW\",\"name\":\"RODEO\"},\"N2\":{},\"N3\":{\"address1\":\"90 MAIN ST\",\"address2\":\"\"},\"N4\":{\"city\":\"MORRISTOWN\",\"country\":\"US\",\"postal_code\":\"07960\",\"state_province\":\"NJ\"}}]}",
"RawRecordHash": "00d8e856-cf02-3d0f-bfa5-4202f6d4335e",
"TransformedRecord": {
"consolidated_bill_plan_number": "0000980223",
"invoice_date": "2008-07-26T00:00:00",
"invoice_due_date": "2008-08-06T00:00:00",
"invoice_number": "0000004045WW308",
"invoice_total_amount": 28555,
"invoice_total_amount_currency": "USD",
"line_items": [
{
"date": "2008-07-26T00:00:00",
"fees_and_charges": [
{
"charge": 800,
"charge_type": "SAC"
}
],
"item_no": 1,
"number_of_pieces": 1,
"ups_product_code": "031"
},
{
"date": "2008-07-21T00:00:00",
"fees_and_charges": [
{
"charge": 32970,
"charge_type": "400"
},
{
"charge": -4615,
"charge_type": "275"
}
],
"item_no": 2,
"number_of_pieces": 5,
"ups_product_code": "011"
},
{
"date": "2008-07-21T00:00:00",
"fees_and_charges": [
{
"charge": 4396,
"charge_desc": "015C",
"charge_type": "AAJ"
},
{
"charge": -4726,
"charge_desc": "015O",
"charge_type": "AAJ"
},
{
"charge": 230,
"charge_type": "REP"
},
{
"charge": -20,
"charge_type": "FUE"
}
],
"item_no": 3,
"number_of_pieces": 1,
"tracking_number": "1Z4045WW0147641818",
"ups_product_code": "028"
},
{
"date": "2008-07-21T00:00:00",
"fees_and_charges": [
{
"charge": 4396,
"charge_desc": "015C",
"charge_type": "AAJ"
},
{
"charge": -4726,
"charge_desc": "015O",
"charge_type": "AAJ"
},
{
"charge": 230,
"charge_type": "REP"
},
{
"charge": -20,
"charge_type": "FUE"
}
],
"item_no": 4,
"number_of_pieces": 1,
"tracking_number": "1Z4045WW0147988025",
"ups_product_code": "028"
},
{
"date": "2008-07-21T00:00:00",
"fees_and_charges": [
{
"charge": 4396,
"charge_desc": "015C",
"charge_type": "AAJ"
},
{
"charge": -4726,
"charge_desc": "015O",
"charge_type": "AAJ"
},
{
"charge": 230,
"charge_type": "REP"
},
{
"charge": -20,
"charge_type": "FUE"
}
],
"item_no": 5,
"number_of_pieces": 1,
"tracking_number": "1Z4045WW0148640835",
"ups_product_code": "028"
},
{
"date": "2008-07-21T00:00:00",
"fees_and_charges": [
{
"charge": 4396,
"charge_desc": "015C",
"charge_type": "AAJ"
},
{
"charge": -4726,
"charge_desc": "015O",
"charge_type": "AAJ"
},
{
"charge": 230,
"charge_type": "REP"
},
{
"charge": -20,
"charge_type": "FUE"
}
],
"item_no": 6,
"number_of_pieces": 1,
"tracking_number": "1Z4045WW0146636246",
"ups_product_code": "028"
},
{
"date": "2008-07-21T00:00:00",
"fees_and_charges": [
{
"charge": 4396,
"charge_desc": "015C",
"charge_type": "AAJ"
},
{
"charge": -4726,
"charge_desc": "015O",
"charge_type": "AAJ"
},
{
"charge": 230,
"charge_type": "REP"
},
{
"charge": -20,
"charge_type": "FUE"
}
],
"item_no": 7,
"number_of_pieces": 1,
"tracking_number": "1Z4045WW0146570254",
"ups_product_code": "028"
}
],
"parties": [
{
"address": {
"city": "MORRISTOWN",
"country": "US",
"line1": "90 MAIN ST",
"postal_code": "07960",
"state_province": "NJ"
},
"entity_identifier": "Bill to Party",
"entity_identifier_code": "BT",
"name": "RODEO"
},
{
"address": {
"city": "MORRISTOWN",
"country": "US",
"line1": "90 MAIN ST",
"postal_code": "07960",
"state_province": "NJ"
},
"entity_identifier": "Shipper",
"entity_identifier_code": "SH",
"identification_code": "00004045WW",
"name": "RODEO"
}
],
"payment_method": "Prepaid"
}
},
{
"RawRecord": "{\"B3\":{\"amountDue\":\"105647\",\"invoiceDate\":\"20080726\",\"invoiceDueDate\":\"20080806\",\"invoiceNumber\":\"0000002063WW308\",\"paymentMethod\":\"PP\"},\"C3\":{\"currency\":\"USD\"},\"ITD\":{},\"L3\":{},\"N9\":{\"refId\":\"0000980228\",\"refIdQualifier\":\"18\"},\"SE\":{},\"ST\":{},\"lineItemInfo\":[{\"L0\":{\"ladingQuantity\":\"1\",\"packagingFormCode\":\"PCS\"},\"L1\":{\"charge\":\"800\",\"chargeDesc\":\"\",\"chargeType\":\"SAC\"},\"LX\":{\"assignedNumber\":\"1\"},\"N9\":{\"date\":\"20080726\",\"product_code_C04004\":\"031\",\"refIdQualifier_N901\":\"ZZ\",\"refId_N902\":\"NA\"}},{\"L0\":{\"ladingQuantity\":\"3\",\"packagingFormCode\":\"PCS\"},\"L1\":[{\"charge\":\"8694\",\"chargeDesc\":\"\",\"chargeType\":\"400\"},{\"charge\":\"-7434\",\"chargeDesc\":\"\",\"chargeType\":\"275\"},{\"charge\":\"1300\",\"chargeDesc\":\"\",\"chargeType\":\"690\"},{\"charge\":\"543\",\"chargeDesc\":\"\",\"chargeType\":\"FUE\"},{\"charge\":\"-465\",\"chargeDesc\":\"\",\"chargeType\":\"295\"}],\"LX\":{\"assignedNumber\":\"2\"},\"N9\":{\"date\":\"20080714\",\"product_code_C04004\":\"011\",\"refIdQualifier_N901\":\"P8\",\"refId_N902\":\"6420262435\"},\"consigneeInfo\":{\"N1\":{\"entityIdentifierCode\":\"ZZ\"},\"cartonInfo\":{\"CD3\":{\"serviceLevel\":\"SG\",\"serviceStandard\":\"\",\"weight\":\"0\",\"weightQualifier\":\"Z\"}}}},{\"L0\":{\"ladingQuantity\":\"5\",\"packagingFormCode\":\"PCS\"},\"L1\":[{\"charge\":\"10210\",\"chargeDesc\":\"\",\"chargeType\":\"400\"},{\"charge\":\"-8110\",\"chargeDesc\":\"\",\"chargeType\":\"275\"},{\"charge\":\"640\",\"chargeDesc\":\"\",\"chargeType\":\"FUE\"},{\"charge\":\"-510\",\"chargeDesc\":\"\",\"chargeType\":\"295\"}],\"LX\":{\"assignedNumber\":\"3\"},\"N9\":{\"date\":\"20080714\",\"product_code_C04004\":\"011\",\"refIdQualifier_N901\":\"P8\",\"refId_N902\":\"6420262520\"},\"consigneeInfo\":{\"N1\":{\"entityIdentifierCode\":\"ZZ\"},\"cartonInfo\":{\"CD3\":{\"serviceLevel\":\"SG\",\"serviceStandard\":\"\",\"weight\":\"0\",\"weightQualifier\":\"Z\"}}}},{\"L0\":{\"ladingQuantity\":\"3\",\"packagingFormCode\":\"PCS\"},\"L1\":[{\"charge\":\"12828\",\"chargeDesc\":\"\",\"chargeType\":\"400\"},{\"charge\":\"-11544\",\"chargeDesc\":\"\",\"chargeType\":\"275\"},{\"charge\":\"1950\",\"chargeDesc\":\"\",\"chargeType\":\"690\"},{\"charge\":\"801\",\"chargeDesc\":\"\",\"chargeType\":\"FUE\"},{\"charge\":\"-720\",\"chargeDesc\":\"\",\"chargeType\":\"295\"}],\"LX\":{\"assignedNumber\":\"4\"},\"N9\":{\"date\":\"20080721\",\"product_code_C04004\":\"011\",\"refIdQualifier_N901\":\"P8\",\"refId_N902\":\"0228168054\"},\"consigneeInfo\":{\"N1\":{\"entityIdentifierCode\":\"ZZ\"},\"cartonInfo\":{\"CD3\":{\"serviceLevel\":\"SG\",\"serviceStandard\":\"\",\"weight\":\"0\",\"weightQualifier\":\"Z\"}}}},{\"L0\":{\"ladingQuantity\":\"3\",\"packagingFormCode\":\"PCS\"},\"L1\":[{\"charge\":\"8694\",\"chargeDesc\":\"\",\"chargeType\":\"400\"},{\"charge\":\"-7434\",\"chargeDesc\":\"\",\"chargeType\":\"275\"},{\"charge\":\"1300\",\"chargeDesc\":\"\",\"chargeType\":\"690\"},{\"charge\":\"543\",\"chargeDesc\":\"\",\"chargeType\":\"FUE\"},{\"charge\":\"-465\",\"chargeDesc\":\"\",\"chargeType\":\"295\"}],\"LX\":{\"assignedNumber\":\"5\"},\"N9\":{\"date\":\"20080721\",\"product_code_C04004\":\"011\",\"refIdQualifier_N901\":\"P8\",\"refId_N902\":\"6420262634\"},\"consigneeInfo\":{\"N1\":{\"entityIdentifierCode\":\"ZZ\"},\"cartonInfo\":{\"CD3\":{\"serviceLevel\":\"SG\",\"serviceStandard\":\"\",\"weight\":\"0\",\"weightQualifier\":\"Z\"}}}},{\"L0\":{\"ladingQuantity\":\"3\",\"packagingFormCode\":\"PCS\"},\"LX\":{\"assignedNumber\":\"6\"},\"N9\":{\"date\":\"20080721\",\"product_code_C04004\":\"011\",\"refIdQualifier_N901\":\"P8\",\"refId_N902\":\"6420262645\"},\"consigneeInfo\":{\"N1\":{\"entityIdentifierCode\":\"ZZ\"},\"cartonInfo\":{\"CD3\":{\"serviceLevel\":\"SG\",\"serviceStandard\":\"\",\"weight\":\"0\",\"weightQualifier\":\"Z\"}}}},{\"L0\":{\"ladingQuantity\":\"3\",\"packagingFormCode\":\"PCS\"},\"LX\":{\"assignedNumber\":\"7\"},\"N9\":{\"date\":\"20080721\",\"product_code_C04004\":\"011\",\"refIdQualifier_N901\":\"P8\",\"refId_N902\":\"6420262656\"},\"consigneeInfo\":{\"N1\":{\"entityIdentifierCode\":\"ZZ\"},\"cartonInfo\":{\"CD3\":{\"serviceLevel\":\"SG\",\"serviceStandard\":\"\",\"weight\":\"0\",\"weightQualifier\":\"Z\"}}}},{\"L0\":{\"ladingQuantity\":\"3\",\"packagingFormCode\":\"PCS\"},\"LX\":{\"assignedNumber\":\"8\"},\"N9\":{\"date\":\"20080721\",\"product_code_C04004\":\"011\",\"refIdQualifier_N901\":\"P8\",\"refId_N902\":\"6420262660\"},\"consigneeInfo\":{\"N1\":{\"entityIdentifierCode\":\"ZZ\"},\"cartonInfo\":{\"CD3\":{\"serviceLevel\":\"SG\",\"serviceStandard\":\"\",\"weight\":\"0\",\"weightQualifier\":\"Z\"}}}},{\"L0\":{\"ladingQuantity\":\"3\",\"packagingFormCode\":\"PCS\"},\"LX\":{\"assignedNumber\":\"9\"},\"N9\":{\"date\":\"20080721\",\"product_code_C04004\":\"011\",\"refIdQualifier_N901\":\"P8\",\"refId_N902\":\"6420262671\"},\"consigneeInfo\":{\"N1\":{\"entityIdentifierCode\":\"ZZ\"},\"cartonInfo\":{\"CD3\":{\"serviceLevel\":\"SG\",\"serviceStandard\":\"\",\"weight\":\"0\",\"weightQualifier\":\"Z\"}}}},{\"L0\":{\"ladingQuantity\":\"3\",\"packagingFormCode\":\"PCS\"},\"LX\":{\"assignedNumber\":\"10\"},\"N9\":{\"date\":\"20080721\",\"product_code_C04004\":\"011\",\"refIdQualifier_N901\":\"P8\",\"refId_N902\":\"6420262682\"},\"consigneeInfo\":{\"N1\":{\"entityIdentifierCode\":\"ZZ\"},\"cartonInfo\":{\"CD3\":{\"serviceLevel\":\"SG\",\"serviceStandard\":\"\",\"weight\":\"0\",\"weightQualifier\":\"Z\"}}}},{\"L0\":{\"ladingQuantity\":\"3\",\"packagingFormCode\":\"PCS\"},\"LX\":{\"assignedNumber\":\"11\"},\"N9\":{\"date\":\"20080721\",\"product_code_C04004\":\"011\",\"refIdQualifier_N901\":\"P8\",\"refId_N902\":\"6420262693\"},\"consigneeInfo\":{\"N1\":{\"entityIdentifierCode\":\"ZZ\"},\"cartonInfo\":{\"CD3\":{\"serviceLevel\":\"SG\",\"serviceStandard\":\"\",\"weight\":\"0\",\"weightQualifier\":\"Z\"}}}},{\"L0\":{\"ladingQuantity\":\"3\",\"packagingFormCode\":\"PCS\"},\"LX\":{\"assignedNumber\":\"12\"},\"N9\":{\"date\":\"20080721\",\"product_code_C04004\":\"011\",\"refIdQualifier_N901\":\"P8\",\"refId_N902\":\"6420262704\"},\"consigneeInfo\":{\"N1\":{\"entityIdentifierCode\":\"ZZ\"},\"cartonInfo\":{\"CD3\":{\"serviceLevel\":\"SG\",\"serviceStandard\":\"\",\"weight\":\"0\",\"weightQualifier\":\"Z\"}}}},{\"L0\":{\"ladingQuantity\":\"3\",\"packagingFormCode\":\"PCS\"},\"LX\":{\"assignedNumber\":\"13\"},\"N9\":{\"date\":\"20080721\",\"product_code_C04004\":\"011\",\"refIdQualifier_N901\":\"P8\",\"refId_N902\":\"6420262715\"},\"consigneeInfo\":{\"N1\":{\"entityIdentifierCode\":\"ZZ\"},\"cartonInfo\":{\"CD3\":{\"serviceLevel\":\"SG\",\"serviceStandard\":\"\",\"weight\":\"0\",\"weightQualifier\":\"Z\"}}}},{\"L0\":{\"ladingQuantity\":\"5\",\"packagingFormCode\":\"PCS\"},\"L1\":[{\"charge\":\"10210\",\"chargeDesc\":\"\",\"chargeType\":\"400\"},{\"charge\":\"-8110\",\"chargeDesc\":\"\",\"chargeType\":\"275\"},{\"charge\":\"640\",\"chargeDesc\":\"\",\"chargeType\":\"FUE\"},{\"charge\":\"-510\",\"chargeDesc\":\"\",\"chargeType\":\"295\"}],\"LX\":{\"assignedNumber\":\"14\"},\"N9\":{\"date\":\"20080721\",\"product_code_C04004\":\"011\",\"refIdQualifier_N901\":\"P8\",\"refId_N902\":\"6420262726\"},\"consigneeInfo\":{\"N1\":{\"entityIdentifierCode\":\"ZZ\"},\"cartonInfo\":{\"CD3\":{\"serviceLevel\":\"SG\",\"serviceStandard\":\"\",\"weight\":\"0\",\"weightQualifier\":\"Z\"}}}},{\"L0\":{\"ladingQuantity\":\"1\",\"packagingFormCode\":\"PCS\"},\"L1\":[{\"charge\":\"74579\",\"chargeDesc\":\"\",\"chargeType\":\"400\"},{\"charge\":\"-51460\",\"chargeDesc\":\"\",\"chargeType\":\"275\"},{\"charge\":\"650\",\"chargeDesc\":\"\",\"chargeType\":\"690\"},{\"charge\":\"1000\",\"chargeDesc\":\"\",\"chargeType\":\"TTT\"},{\"charge\":\"4661\",\"chargeDesc\":\"\",\"chargeType\":\"FUE\"},{\"charge\":\"-3216\",\"chargeDesc\":\"\",\"chargeType\":\"295\"}],\"LX\":{\"assignedNumber\":\"15\"},\"N9\":[{\"date\":\"20080721\",\"product_code_C04004\":\"021\",\"refIdQualifier_N901\":\"CN\",\"refId_N902\":\"1Z2063WW0300053961\"},{\"date\":\"\",\"product_code_C04004\":\"\",\"refIdQualifier_N901\":\"D2\",\"refId_N902\":\"01\"},{\"date\":\"\",\"product_code_C04004\":\"\",\"refIdQualifier_N901\":\"LU\",\"refId_N902\":\"60625\"}],\"consigneeInfo\":[{\"N1\":{\"entityIdentifierCode\":\"SH\"},\"N3\":{\"address1\":\"164 US WAY\",\"address2\":\"\"},\"N4\":{\"city\":\"MORRISTOWN\",\"country\":\"US\",\"postal_code\":\"07960\",\"state_province\":\"NJ\"}},{\"N1\":{\"entityIdentifierCode\":\"CN\"},\"N2\":{\"consigneeName\":\"HFK9VKW\"},\"N3\":{\"address1\":\"145 NORTHSIDE WAY DRIVE\",\"address2\":\"\"},\"N4\":{\"city\":\"CHICAGO\",\"country\":\"US\",\"postal_code\":\"60625\",\"state_province\":\"IL\"},\"N9\":{\"refIdQualifier_N901\":\"CR\",\"refId_N902\":\"7804--0011-0009-1\"},\"cartonInfo\":{\"CD3\":{\"serviceLevel\":\"SG\",\"serviceStandard\":\"\",\"weight\":\"340\",\"weightQualifier\":\"B\"},\"N9\":[{\"refIdQualifier_N901\":\"AN\",\"refId_N902\":\"00002068WW\"},{\"refIdQualifier_N901\":\"RC\",\"refId_N902\":\" \"},{\"refIdQualifier_N901\":\"FR\",\"refId_N902\":\"14576000\"},{\"refIdQualifier_N901\":\"FR\",\"refId_N902\":\"13268002\"},{\"refIdQualifier_N901\":\"FR\",\"refId_N902\":\"17956900\"}]}}]},{\"L0\":{\"ladingQuantity\":\"3\",\"packagingFormCode\":\"PCS\"},\"L1\":[{\"charge\":\"45574\",\"chargeDesc\":\"\",\"chargeType\":\"400\"},{\"charge\":\"-30535\",\"chargeDesc\":\"\",\"chargeType\":\"275\"},{\"charge\":\"1950\",\"chargeDesc\":\"\",\"chargeType\":\"690\"},{\"charge\":\"1000\",\"chargeDesc\":\"\",\"chargeType\":\"TTT\"},{\"charge\":\"2849\",\"chargeDesc\":\"\",\"chargeType\":\"FUE\"},{\"charge\":\"-1908\",\"chargeDesc\":\"\",\"chargeType\":\"295\"}],\"LX\":{\"assignedNumber\":\"16\"},\"N9\":[{\"date\":\"20080721\",\"product_code_C04004\":\"021\",\"refIdQualifier_N901\":\"CN\",\"refId_N902\":\"1Z2063WW0300014315\"},{\"date\":\"\",\"product_code_C04004\":\"\",\"refIdQualifier_N901\":\"D2\",\"refId_N902\":\"01\"},{\"date\":\"\",\"product_code_C04004\":\"\",\"refIdQualifier_N901\":\"LU\",\"refId_N902\":\"07960\"}],\"consigneeInfo\":{\"N1\":{\"entityIdentifierCode\":\"ZZ\"},\"N9\":{\"refIdQualifier_N901\":\"CR\",\"refId_N902\":\"7804--0011-0010-1\"},\"cartonInfo\":{\"CD3\":{\"serviceLevel\":\"SG\",\"serviceStandard\":\"\",\"weight\":\"500\",\"weightQualifier\":\"B\"},\"N9\":[{\"refIdQualifier_N901\":\"AN\",\"refId_N902\":\"00002048WW\"},{\"refIdQualifier_N901\":\"RC\",\"refId_N902\":\"10\"},{\"refIdQualifier_N901\":\"FR\",\"refId_N902\":\"14576000\"},{\"refIdQualifier_N901\":\"FR\",\"refId_N902\":\"13268002\"},{\"refIdQualifier_N901\":\"FR\",\"refId_N902\":\"17956900\"}]}}},{\"L0\":{\"ladingQuantity\":\"1\",\"packagingFormCode\":\"PCS\"},\"LX\":{\"assignedNumber\":\"17\"},\"N9\":[{\"date\":\"20080721\",\"product_code_C04004\":\"021\",\"refIdQualifier_N901\":\"CN\",\"refId_N902\":\"1Z2063WW0300014315\"},{\"date\":\"\",\"product_code_C04004\":\"\",\"refIdQualifier_N901\":\"D2\",\"refId_N902\":\"01\"},{\"date\":\"\",\"product_code_C04004\":\"\",\"refIdQualifier_N901\":\"LU\",\"refId_N902\":\"07960\"}],\"consigneeInfo\":{\"N1\":{\"entityIdentifierCode\":\"ZZ\"},\"N9\":{\"refIdQualifier_N901\":\"CR\",\"refId_N902\":\"7804--0011-0010-1\"},\"cartonInfo\":{\"CD3\":{\"serviceLevel\":\"SG\",\"serviceStandard\":\"\",\"weight\":\"120\",\"weightQualifier\":\"B\"},\"N9\":[{\"refIdQualifier_N901\":\"AN\",\"refId_N902\":\"00002048WW\"},{\"refIdQualifier_N901\":\"RC\",\"refId_N902\":\"10\"},{\"refIdQualifier_N901\":\"FR\",\"refId_N902\":\"17956900\"}]}}},{\"L0\":{\"ladingQuantity\":\"1\",\"packagingFormCode\":\"PCS\"},\"LX\":{\"assignedNumber\":\"18\"},\"N9\":[{\"date\":\"20080721\",\"product_code_C04004\":\"021\",\"refIdQualifier_N901\":\"CN\",\"refId_N902\":\"1Z2063WW0300014324\"},{\"date\":\"\",\"product_code_C04004\":\"\",\"refIdQualifier_N901\":\"D2\",\"refId_N902\":\"01\"},{\"date\":\"\",\"product_code_C04004\":\"\",\"refIdQualifier_N901\":\"LU\",\"refId_N902\":\"07960\"}],\"consigneeInfo\":{\"N1\":{\"entityIdentifierCode\":\"ZZ\"},\"N9\":{\"refIdQualifier_N901\":\"CR\",\"refId_N902\":\"7804--0011-0010-2\"},\"cartonInfo\":{\"CD3\":{\"serviceLevel\":\"SG\",\"serviceStandard\":\"\",\"weight\":\"120\",\"weightQualifier\":\"B\"},\"N9\":[{\"refIdQualifier_N901\":\"AN\",\"refId_N902\":\"00002048WW\"},{\"refIdQualifier_N901\":\"RC\",\"refId_N902\":\"10\"},{\"refIdQualifier_N901\":\"FR\",\"refId_N902\":\"14576000\"}]}}},{\"L0\":{\"ladingQuantity\":\"1\",\"packagingFormCode\":\"PCS\"},\"LX\":{\"assignedNumber\":\"19\"},\"N9\":[{\"date\":\"20080721\",\"product_code_C04004\":\"021\",\"refIdQualifier_N901\":\"CN\",\"refId_N902\":\"1Z2063WW0300014333\"},{\"date\":\"\",\"product_code_C04004\":\"\",\"refIdQualifier_N901\":\"D2\",\"refId_N902\":\"01\"},{\"date\":\"\",\"product_code_C04004\":\"\",\"refIdQualifier_N901\":\"LU\",\"refId_N902\":\"07960\"}],\"consigneeInfo\":[{\"N1\":{\"entityIdentifierCode\":\"SH\"},\"N3\":{\"address1\":\"164 US WAY\",\"address2\":\"\"},\"N4\":{\"city\":\"MORRISTOWN\",\"country\":\"US\",\"postal_code\":\"07960\",\"state_province\":\"NJ\"}},{\"N1\":{\"entityIdentifierCode\":\"CN\"},\"N2\":{\"consigneeName\":\"HFK9VKW\"},\"N3\":{\"address1\":\"125 UNITED WAY DRIVE\",\"address2\":\"\"},\"N4\":{\"city\":\"MORRISTOWN\",\"country\":\"US\",\"postal_code\":\"07960\",\"state_province\":\"NJ\"},\"N9\":{\"refIdQualifier_N901\":\"CR\",\"refId_N902\":\"7804--0011-0010-3\"},\"cartonInfo\":{\"CD3\":{\"serviceLevel\":\"SG\",\"serviceStandard\":\"\",\"weight\":\"100\",\"weightQualifier\":\"B\"},\"N9\":[{\"refIdQualifier_N901\":\"AN\",\"refId_N902\":\"00002048WW\"},{\"refIdQualifier_N901\":\"RC\",\"refId_N902\":\"10\"},{\"refIdQualifier_N901\":\"FR\",\"refId_N902\":\"13268002\"}]}}]},{\"L0\":{\"ladingQuantity\":\"1\",\"packagingFormCode\":\"PCS\"},\"L1\":[{\"charge\":\"45574\",\"chargeDesc\":\"\",\"chargeType\":\"400\"},{\"charge\":\"-30535\",\"chargeDesc\":\"\",\"chargeType\":\"275\"},{\"charge\":\"650\",\"chargeDesc\":\"\",\"chargeType\":\"690\"},{\"charge\":\"1000\",\"chargeDesc\":\"\",\"chargeType\":\"TTT\"},{\"charge\":\"2848\",\"chargeDesc\":\"\",\"chargeType\":\"FUE\"},{\"charge\":\"-1908\",\"chargeDesc\":\"\",\"chargeType\":\"295\"}],\"LX\":{\"assignedNumber\":\"20\"},\"N9\":[{\"date\":\"20080721\",\"product_code_C04004\":\"021\",\"refIdQualifier_N901\":\"CN\",\"refId_N902\":\"1Z2063WW0300014557\"},{\"date\":\"\",\"product_code_C04004\":\"\",\"refIdQualifier_N901\":\"D2\",\"refId_N902\":\"01\"},{\"date\":\"\",\"product_code_C04004\":\"\",\"refIdQualifier_N901\":\"LU\",\"refId_N902\":\"07960\"}],\"consigneeInfo\":[{\"N1\":{\"entityIdentifierCode\":\"SH\"},\"N3\":{\"address1\":\"164 US WAY\",\"address2\":\"\"},\"N4\":{\"city\":\"MORRISTOWN\",\"country\":\"US\",\"postal_code\":\"07960\",\"state_province\":\"NJ\"}},{\"N1\":{\"entityIdentifierCode\":\"CN\"},\"N2\":{\"consigneeName\":\"HFK9VKW\"},\"N3\":{\"address1\":\"438 SOUTHERN STREET DRIVE\",\"address2\":\"\"},\"N4\":{\"city\":\"MORRISTOWN\",\"country\":\"US\",\"postal_code\":\"07960\",\"state_province\":\"NJ\"},\"N9\":{\"refIdQualifier_N901\":\"CR\",\"refId_N902\":\"7804--0011-0011-1\"},\"cartonInfo\":{\"CD3\":{\"serviceLevel\":\"SG\",\"serviceStandard\":\"\",\"weight\":\"500\",\"weightQualifier\":\"B\"},\"N9\":[{\"refIdQualifier_N901\":\"AN\",\"refId_N902\":\"00002047WW\"},{\"refIdQualifier_N901\":\"RC\",\"refId_N902\":\" \"},{\"refIdQualifier_N901\":\"FR\",\"refId_N902\":\"14576000\"},{\"refIdQualifier_N901\":\"FR\",\"refId_N902\":\"13268002\"},{\"refIdQualifier_N901\":\"FR\",\"refId_N902\":\"17956900\"}]}}]},{\"L0\":{\"ladingQuantity\":\"7\",\"packagingFormCode\":\"PCS\"},\"L1\":[{\"charge\":\"50994\",\"chargeDesc\":\"\",\"chargeType\":\"400\"},{\"charge\":\"-35441\",\"chargeDesc\":\"\",\"chargeType\":\"275\"},{\"charge\":\"3185\",\"chargeDesc\":\"\",\"chargeType\":\"FUE\"},{\"charge\":\"-2212\",\"chargeDesc\":\"\",\"chargeType\":\"295\"}],\"LX\":{\"assignedNumber\":\"21\"},\"N9\":[{\"date\":\"20080721\",\"product_code_C04004\":\"024\",\"refIdQualifier_N901\":\"P8\",\"refId_N902\":\"6458453750\"},{\"date\":\"\",\"product_code_C04004\":\"\",\"refIdQualifier_N901\":\"D2\",\"refId_N902\":\"12\"},{\"date\":\"\",\"product_code_C04004\":\"\",\"refIdQualifier_N901\":\"LU\",\"refId_N902\":\"07960\"}],\"consigneeInfo\":{\"N1\":{\"entityIdentifierCode\":\"ZZ\"},\"N9\":{\"refIdQualifier_N901\":\"CR\",\"refId_N902\":\"7804--0019-0015-1\"},\"cartonInfo\":{\"CD3\":{\"serviceLevel\":\"SG\",\"serviceStandard\":\"\",\"weight\":\"280\",\"weightQualifier\":\"B\"},\"N9\":[{\"refIdQualifier_N901\":\"FR\",\"refId_N902\":\"13268002\"},{\"refIdQualifier_N901\":\"FR\",\"refId_N902\":\"14576000\"}]}}},{\"L0\":{\"ladingQuantity\":\"1\",\"packagingFormCode\":\"PCS\"},\"LX\":{\"assignedNumber\":\"22\"},\"N9\":[{\"date\":\"20080721\",\"product_code_C04004\":\"024\",\"refIdQualifier_N901\":\"P8\",\"refId_N902\":\"6458453750\"},{\"date\":\"\",\"product_code_C04004\":\"\",\"refIdQualifier_N901\":\"CN\",\"refId_N902\":\"1Z2068WW0300011247\"},{\"date\":\"\",\"product_code_C04004\":\"\",\"refIdQualifier_N901\":\"D2\",\"refId_N902\":\"12\"},{\"date\":\"\",\"product_code_C04004\":\"\",\"refIdQualifier_N901\":\"LU\",\"refId_N902\":\"07960\"}],\"consigneeInfo\":{\"N1\":{\"entityIdentifierCode\":\"ZZ\"},\"N9\":{\"refIdQualifier_N901\":\"CR\",\"refId_N902\":\"7804--0019-0015-1\"},\"cartonInfo\":{\"CD3\":{\"serviceLevel\":\"SG\",\"serviceStandard\":\"\",\"weight\":\"40\",\"weightQualifier\":\"B\"},\"N9\":{\"refIdQualifier_N901\":\"FR\",\"refId_N902\":\"14576000\"}}}},{\"L0\":{\"ladingQuantity\":\"1\",\"packagingFormCode\":\"PCS\"},\"LX\":{\"assignedNumber\":\"23\"},\"N9\":[{\"date\":\"20080721\",\"product_code_C04004\":\"024\",\"refIdQualifier_N901\":\"P8\",\"refId_N902\":\"6458453750\"},{\"date\":\"\",\"product_code_C04004\":\"\",\"refIdQualifier_N901\":\"CN\",\"refId_N902\":\"1Z2068WW0300011256\"},{\"date\":\"\",\"product_code_C04004\":\"\",\"refIdQualifier_N901\":\"D2\",\"refId_N902\":\"12\"},{\"date\":\"\",\"product_code_C04004\":\"\",\"refIdQualifier_N901\":\"LU\",\"refId_N902\":\"07960\"}],\"consigneeInfo\":{\"N1\":{\"entityIdentifierCode\":\"ZZ\"},\"N9\":{\"refIdQualifier_N901\":\"CR\",\"refId_N902\":\"7804--0019-0015-2\"},\"cartonInfo\":{\"CD3\":{\"serviceLevel\":\"SG\",\"serviceStandard\":\"\",\"weight\":\"40\",\"weightQualifier\":\"B\"},\"N9\":{\"refIdQualifier_N901\":\"FR\",\"refId_N902\":\"14576000\"}}}},{\"L0\":{\"ladingQuantity\":\"1\",\"packagingFormCode\":\"PCS\"},\"LX\":{\"assignedNumber\":\"24\"},\"N9\":[{\"date\":\"20080721\",\"product_code_C04004\":\"024\",\"refIdQualifier_N901\":\"P8\",\"refId_N902\":\"6458453750\"},{\"date\":\"\",\"product_code_C04004\":\"\",\"refIdQualifier_N901\":\"CN\",\"refId_N902\":\"1Z2068WW0300011390\"},{\"date\":\"\",\"product_code_C04004\":\"\",\"refIdQualifier_N901\":\"D2\",\"refId_N902\":\"12\"},{\"date\":\"\",\"product_code_C04004\":\"\",\"refIdQualifier_N901\":\"LU\",\"refId_N902\":\"07960\"}],\"consigneeInfo\":{\"N1\":{\"entityIdentifierCode\":\"ZZ\"},\"N9\":{\"refIdQualifier_N901\":\"CR\",\"refId_N902\":\"7804--0019-0015-3\"},\"cartonInfo\":{\"CD3\":{\"serviceLevel\":\"SG\",\"serviceStandard\":\"\",\"weight\":\"40\",\"weightQualifier\":\"B\"},\"N9\":{\"refIdQualifier_N901\":\"FR\",\"refId_N902\":\"14576000\"}}}},{\"L0\":{\"ladingQuantity\":\"1\",\"packagingFormCode\":\"PCS\"},\"LX\":{\"assignedNumber\":\"25\"},\"N9\":[{\"date\":\"20080721\",\"product_code_C04004\":\"024\",\"refIdQualifier_N901\":\"P8\",\"refId_N902\":\"6458453750\"},{\"date\":\"\",\"product_code_C04004\":\"\",\"refIdQualifier_N901\":\"CN\",\"refId_N902\":\"1Z2068WW0300011407\"},{\"date\":\"\",\"product_code_C04004\":\"\",\"refIdQualifier_N901\":\"D2\",\"refId_N902\":\"12\"},{\"date\":\"\",\"product_code_C04004\":\"\",\"refIdQualifier_N901\":\"LU\",\"refId_N902\":\"07960\"}],\"consigneeInfo\":{\"N1\":{\"entityIdentifierCode\":\"ZZ\"},\"N9\":{\"refIdQualifier_N901\":\"CR\",\"refId_N902\":\"7804--0019-0015-4\"},\"cartonInfo\":{\"CD3\":{\"serviceLevel\":\"SG\",\"serviceStandard\":\"\",\"weight\":\"40\",\"weightQualifier\":\"B\"},\"N9\":{\"refIdQualifier_N901\":\"FR\",\"refId_N902\":\"14576000\"}}}},{\"L0\":{\"ladingQuantity\":\"1\",\"packagingFormCode\":\"PCS\"},\"LX\":{\"assignedNumber\":\"26\"},\"N9\":[{\"date\":\"20080721\",\"product_code_C04004\":\"024\",\"refIdQualifier_N901\":\"P8\",\"refId_N902\":\"6458453750\"},{\"date\":\"\",\"product_code_C04004\":\"\",\"refIdQualifier_N901\":\"CN\",\"refId_N902\":\"1Z2068WW0300011416\"},{\"date\":\"\",\"product_code_C04004\":\"\",\"refIdQualifier_N901\":\"D2\",\"refId_N902\":\"12\"},{\"date\":\"\",\"product_code_C04004\":\"\",\"refIdQualifier_N901\":\"LU\",\"refId_N902\":\"07960\"}],\"consigneeInfo\":{\"N1\":{\"entityIdentifierCode\":\"ZZ\"},\"N9\":{\"refIdQualifier_N901\":\"CR\",\"refId_N902\":\"7804--0019-0015-5\"},\"cartonInfo\":{\"CD3\":{\"serviceLevel\":\"SG\",\"serviceStandard\":\"\",\"weight\":\"40\",\"weightQualifier\":\"B\"},\"N9\":{\"refIdQualifier_N901\":\"FR\",\"refId_N902\":\"14576000\"}}}},{\"L0\":{\"ladingQuantity\":\"1\",\"packagingFormCode\":\"PCS\"},\"LX\":{\"assignedNumber\":\"27\"},\"N9\":[{\"date\":\"20080721\",\"product_code_C04004\":\"024\",\"refIdQualifier_N901\":\"P8\",\"refId_N902\":\"6458453750\"},{\"date\":\"\",\"product_code_C04004\":\"\",\"refIdQualifier_N901\":\"CN\",\"refId_N902\":\"1Z2068WW0300011425\"},{\"date\":\"\",\"product_code_C04004\":\"\",\"refIdQualifier_N901\":\"D2\",\"refId_N902\":\"12\"},{\"date\":\"\",\"product_code_C04004\":\"\",\"refIdQualifier_N901\":\"LU\",\"refId_N902\":\"07960\"}],\"consigneeInfo\":{\"N1\":{\"entityIdentifierCode\":\"ZZ\"},\"N9\":{\"refIdQualifier_N901\":\"CR\",\"refId_N902\":\"7804--0019-0015-6\"},\"cartonInfo\":{\"CD3\":{\"serviceLevel\":\"SG\",\"serviceStandard\":\"\",\"weight\":\"40\",\"weightQualifier\":\"B\"},\"N9\":{\"refIdQualifier_N901\":\"FR\",\"refId_N902\":\"14576000\"}}}},{\"L0\":{\"ladingQuantity\":\"1\",\"packagingFormCode\":\"PCS\"},\"LX\":{\"assignedNumber\":\"28\"},\"N9\":[{\"date\":\"20080721\",\"product_code_C04004\":\"024\",\"refIdQualifier_N901\":\"P8\",\"refId_N902\":\"6458453750\"},{\"date\":\"\",\"product_code_C04004\":\"\",\"refIdQualifier_N901\":\"CN\",\"refId_N902\":\"1Z2068WW0300011434\"},{\"date\":\"\",\"product_code_C04004\":\"\",\"refIdQualifier_N901\":\"D2\",\"refId_N902\":\"12\"},{\"date\":\"\",\"product_code_C04004\":\"\",\"refIdQualifier_N901\":\"LU\",\"refId_N902\":\"07960\"}],\"consigneeInfo\":{\"N1\":{\"entityIdentifierCode\":\"ZZ\"},\"N9\":{\"refIdQualifier_N901\":\"CR\",\"refId_N902\":\"7804--0019-0015-7\"},\"cartonInfo\":{\"CD3\":{\"serviceLevel\":\"SG\",\"serviceStandard\":\"\",\"weight\":\"40\",\"weightQualifier\":\"B\"},\"N9\":{\"refIdQualifier_N901\":\"FR\",\"refId_N902\":\"13268002\"}}}},{\"L0\":{\"ladingQuantity\":\"2\",\"packagingFormCode\":\"PCS\"},\"L1\":[{\"charge\":\"10500\",\"chargeDesc\":\"\",\"chargeType\":\"400\"},{\"charge\":\"656\",\"chargeDesc\":\"\",\"chargeType\":\"FUE\"}],\"LX\":{\"assignedNumber\":\"29\"},\"N9\":[{\"date\":\"20080721\",\"product_code_C04004\":\"024\",\"refIdQualifier_N901\":\"P8\",\"refId_N902\":\"6458453761\"},{\"date\":\"\",\"product_code_C04004\":\"\",\"refIdQualifier_N901\":\"D2\",\"refId_N902\":\"12\"},{\"date\":\"\",\"product_code_C04004\":\"\",\"refIdQualifier_N901\":\"LU\",\"refId_N902\":\"07960\"}],\"consigneeInfo\":{\"N1\":{\"entityIdentifierCode\":\"ZZ\"},\"N9\":{\"refIdQualifier_N901\":\"CR\",\"refId_N902\":\"7804--0019-0017-1\"},\"cartonInfo\":{\"CD3\":{\"serviceLevel\":\"SG\",\"serviceStandard\":\"\",\"weight\":\"100\",\"weightQualifier\":\"B\"},\"N9\":{\"refIdQualifier_N901\":\"FR\",\"refId_N902\":\"14576000\"}}}},{\"L0\":{\"ladingQuantity\":\"1\",\"packagingFormCode\":\"PCS\"},\"LX\":{\"assignedNumber\":\"30\"},\"N9\":[{\"date\":\"20080721\",\"product_code_C04004\":\"024\",\"refIdQualifier_N901\":\"P8\",\"refId_N902\":\"6458453761\"},{\"date\":\"\",\"product_code_C04004\":\"\",\"refIdQualifier_N901\":\"CN\",\"refId_N902\":\"1Z2068WW0300036506\"},{\"date\":\"\",\"product_code_C04004\":\"\",\"refIdQualifier_N901\":\"D2\",\"refId_N902\":\"12\"},{\"date\":\"\",\"product_code_C04004\":\"\",\"refIdQualifier_N901\":\"LU\",\"refId_N902\":\"07960\"}],\"consigneeInfo\":{\"N1\":{\"entityIdentifierCode\":\"ZZ\"},\"N9\":{\"refIdQualifier_N901\":\"CR\",\"refId_N902\":\"7804--0019-0017-1\"},\"cartonInfo\":{\"CD3\":{\"serviceLevel\":\"SG\",\"serviceStandard\":\"\",\"weight\":\"50\",\"weightQualifier\":\"B\"},\"N9\":{\"refIdQualifier_N901\":\"FR\",\"refId_N902\":\"14576000\"}}}},{\"L0\":{\"ladingQuantity\":\"1\",\"packagingFormCode\":\"PCS\"},\"LX\":{\"assignedNumber\":\"31\"},\"N9\":[{\"date\":\"20080721\",\"product_code_C04004\":\"024\",\"refIdQualifier_N901\":\"P8\",\"refId_N902\":\"6458453761\"},{\"date\":\"\",\"product_code_C04004\":\"\",\"refIdQualifier_N901\":\"CN\",\"refId_N902\":\"1Z2068WW0300036515\"},{\"date\":\"\",\"product_code_C04004\":\"\",\"refIdQualifier_N901\":\"D2\",\"refId_N902\":\"12\"},{\"date\":\"\",\"product_code_C04004\":\"\",\"refIdQualifier_N901\":\"LU\",\"refId_N902\":\"07960\"}],\"consigneeInfo\":{\"N1\":{\"entityIdentifierCode\":\"ZZ\"},\"N9\":{\"refIdQualifier_N901\":\"CR\",\"refId_N902\":\"7804--0019-0017-2\"},\"cartonInfo\":{\"CD3\":{\"serviceLevel\":\"SG\",\"serviceStandard\":\"\",\"weight\":\"50\",\"weightQualifier\":\"B\"}}}},{\"L0\":{\"ladingQuantity\":\"1\",\"packagingFormCode\":\"PCS\"},\"L1\":[{\"charge\":\"744\",\"chargeDesc\":\"010\",\"chargeType\":\"AAJ\"},{\"charge\":\"-324\",\"chargeDesc\":\"\",\"chargeType\":\"275\"},{\"charge\":\"47\",\"chargeDesc\":\"\",\"chargeType\":\"FUE\"},{\"charge\":\"-20\",\"chargeDesc\":\"\",\"chargeType\":\"295\"}],\"LX\":{\"assignedNumber\":\"32\"},\"N9\":[{\"date\":\"20080716\",\"product_code_C04004\":\"028\",\"refIdQualifier_N901\":\"CN\",\"refId_N902\":\"1Z2063WW0300072904\"},{\"date\":\"\",\"product_code_C04004\":\"\",\"refIdQualifier_N901\":\"D2\",\"refId_N902\":\"01\"},{\"date\":\"\",\"product_code_C04004\":\"\",\"refIdQualifier_N901\":\"LU\",\"refId_N902\":\"60625\"}],\"consigneeInfo\":[{\"N1\":{\"entityIdentifierCode\":\"CN\"},\"N3\":{\"address1\":\"145 NORTHSIDE WAY\",\"address2\":\"\"},\"N4\":{\"city\":\"CHICAGO\",\"country\":\"US\",\"postal_code\":\"60625\",\"state_province\":\"IL\"}},{\"N1\":{\"entityIdentifierCode\":\"SH\"},\"N3\":{\"address1\":\"164 US WAY\",\"address2\":\"\"},\"N4\":{\"city\":\"MORRISTOWN\",\"country\":\"US\",\"postal_code\":\"07960\",\"state_province\":\"NJ\"},\"cartonInfo\":{\"CD3\":{\"serviceLevel\":\"SG\",\"serviceStandard\":\"\",\"weight\":\"13\",\"weightQualifier\":\"B\"}}}]},{\"L0\":{\"ladingQuantity\":\"1\",\"packagingFormCode\":\"PCS\"},\"L1\":[{\"charge\":\"744\",\"chargeDesc\":\"010\",\"chargeType\":\"AAJ\"},{\"charge\":\"-324\",\"chargeDesc\":\"\",\"chargeType\":\"275\"},{\"charge\":\"47\",\"chargeDesc\":\"\",\"chargeType\":\"FUE\"},{\"charge\":\"-20\",\"chargeDesc\":\"\",\"chargeType\":\"295\"}],\"LX\":{\"assignedNumber\":\"33\"},\"N9\":[{\"date\":\"20080716\",\"product_code_C04004\":\"028\",\"refIdQualifier_N901\":\"CN\",\"refId_N902\":\"1Z2063WW0300072913\"},{\"date\":\"\",\"product_code_C04004\":\"\",\"refIdQualifier_N901\":\"D2\",\"refId_N902\":\"01\"},{\"date\":\"\",\"product_code_C04004\":\"\",\"refIdQualifier_N901\":\"LU\",\"refId_N902\":\"60625\"}],\"consigneeInfo\":[{\"N1\":{\"entityIdentifierCode\":\"CN\"},\"N3\":{\"address1\":\"145 NORTHSIDE WAY\",\"address2\":\"\"},\"N4\":{\"city\":\"CHICAGO\",\"country\":\"US\",\"postal_code\":\"60625\",\"state_province\":\"IL\"}},{\"N1\":{\"entityIdentifierCode\":\"SH\"},\"N3\":{\"address1\":\"164 US WAY\",\"address2\":\"\"},\"N4\":{\"city\":\"MORRISTOWN\",\"country\":\"US\",\"postal_code\":\"07960\",\"state_province\":\"NJ\"},\"cartonInfo\":{\"CD3\":{\"serviceLevel\":\"SG\",\"serviceStandard\":\"\",\"weight\":\"13\",\"weightQualifier\":\"B\"}}}]},{\"L0\":{\"ladingQuantity\":\"1\",\"packagingFormCode\":\"PCS\"},\"L1\":[{\"charge\":\"744\",\"chargeDesc\":\"010\",\"chargeType\":\"AAJ\"},{\"charge\":\"-324\",\"chargeDesc\":\"\",\"chargeType\":\"275\"},{\"charge\":\"47\",\"chargeDesc\":\"\",\"chargeType\":\"FUE\"},{\"charge\":\"-20\",\"chargeDesc\":\"\",\"chargeType\":\"295\"}],\"LX\":{\"assignedNumber\":\"34\"},\"N9\":[{\"date\":\"20080716\",\"product_code_C04004\":\"028\",\"refIdQualifier_N901\":\"CN\",\"refId_N902\":\"1Z2063WW0300072922\"},{\"date\":\"\",\"product_code_C04004\":\"\",\"refIdQualifier_N901\":\"D2\",\"refId_N902\":\"01\"},{\"date\":\"\",\"product_code_C04004\":\"\",\"refIdQualifier_N901\":\"LU\",\"refId_N902\":\"60625\"}],\"consigneeInfo\":[{\"N1\":{\"entityIdentifierCode\":\"CN\"},\"N3\":{\"address1\":\"145 NORTHSIDE WAY\",\"address2\":\"\"},\"N4\":{\"city\":\"CHICAGO\",\"country\":\"US\",\"postal_code\":\"60625\",\"state_province\":\"IL\"}},{\"N1\":{\"entityIdentifierCode\":\"SH\"},\"N3\":{\"address1\":\"164 US WAY\",\"address2\":\"\"},\"N4\":{\"city\":\"MORRISTOWN\",\"country\":\"US\",\"postal_code\":\"07960\",\"state_province\":\"NJ\"},\"cartonInfo\":[{\"CD3\":{\"serviceLevel\":\"SG\",\"serviceStandard\":\"\",\"weight\":\"13\",\"weightQualifier\":\"B\"}},{\"CD3\":{\"serviceLevel\":\"\",\"serviceStandard\":\"\",\"weight\":\"0\",\"weightQualifier\":\"Z\"},\"N9\":{\"refIdQualifier_N901\":\"FR\",\"refId_N902\":\"14576000\"}}]}]}],\"partyInfo\":[{\"N1\":{\"entityIdentifierCode\":\"BT\",\"identificationCode\":\"\",\"name\":\"US FRS SHIPPER\"},\"N3\":{\"address1\":\"164 US WAY\",\"address2\":\"\"},\"N4\":{\"city\":\"MORRISTOWN\",\"country\":\"US\",\"postal_code\":\"07960\",\"state_province\":\"NJ\"}},{\"N1\":{\"entityIdentifierCode\":\"SH\",\"identificationCode\":\"00002063WW\",\"name\":\"US FRS SHIPPER\"},\"N3\":{\"address1\":\"164 US WAY\",\"address2\":\"\"},\"N4\":{\"city\":\"MORRISTOWN\",\"country\":\"US\",\"postal_code\":\"07960\",\"state_province\":\"NJ\"}}]}",
"RawRecordHash": "ea063ae5-77b0-37db-af88-6ee328bdd832",
"TransformedRecord": {
"consolidated_bill_plan_number": "0000980228",
"invoice_date": "2008-07-26T00:00:00",
"invoice_due_date": "2008-08-06T00:00:00",
"invoice_number": "0000002063WW308",
"invoice_total_amount": 105647,
"invoice_total_amount_currency": "USD",
"line_items": [
{
"date": "2008-07-26T00:00:00",
"fees_and_charges": [
{
"charge": 800,
"charge_type": "SAC"
}
],
"item_no": 1,
"number_of_pieces": 1,
"ups_product_code": "031"
},
{
"date": "2008-07-14T00:00:00",
"fees_and_charges": [
{
"charge": 8694,
"charge_type": "400"
},
{
"charge": -7434,
"charge_type": "275"
},
{
"charge": 1300,
"charge_type": "690"
},
{
"charge": 543,
"charge_type": "FUE"
},
{
"charge": -465,
"charge_type": "295"
}
],
"item_no": 2,
"number_of_pieces": 3,
"ups_product_code": "011"
},
{
"date": "2008-07-14T00:00:00",
"fees_and_charges": [
{
"charge": 10210,
"charge_type": "400"
},
{
"charge": -8110,
"charge_type": "275"
},
{
"charge": 640,
"charge_type": "FUE"
},
{
"charge": -510,
"charge_type": "295"
}
],
"item_no": 3,
"number_of_pieces": 5,
"ups_product_code": "011"
},
{
"date": "2008-07-21T00:00:00",
"fees_and_charges": [
{
"charge": 12828,
"charge_type": "400"
},
{
"charge": -11544,
"charge_type": "275"
},
{
"charge": 1950,
"charge_type": "690"
},
{
"charge": 801,
"charge_type": "FUE"
},
{
"charge": -720,
"charge_type": "295"
}
],
"item_no": 4,
"number_of_pieces": 3,
"ups_product_code": "011"
},
{
"date": "2008-07-21T00:00:00",
"fees_and_charges": [
{
"charge": 8694,
"charge_type": "400"
},
{
"charge": -7434,
"charge_type": "275"
},
{
"charge": 1300,
"charge_type": "690"
},
{
"charge": 543,
"charge_type": "FUE"
},
{
"charge": -465,
"charge_type": "295"
}
],
"item_no": 5,
"number_of_pieces": 3,
"ups_product_code": "011"
},
{
"date": "2008-07-21T00:00:00",
"item_no": 6,
"number_of_pieces": 3,
"ups_product_code": "011"
},
{
"date": "2008-07-21T00:00:00",
"item_no": 7,
"number_of_pieces": 3,
"ups_product_code": "011"
},
{
"date": "2008-07-21T00:00:00",
"item_no": 8,
"number_of_pieces": 3,
"ups_product_code": "011"
},
{
"date": "2008-07-21T00:00:00",
"item_no": 9,
"number_of_pieces": 3,
"ups_product_code": "011"
},
{
"date": "2008-07-21T00:00:00",
"item_no": 10,
"number_of_pieces": 3,
"ups_product_code": "011"
},
{
"date": "2008-07-21T00:00:00",
"item_no": 11,
"number_of_pieces": 3,
"ups_product_code": "011"
},
{
"date": "2008-07-21T00:00:00",
"item_no": 12,
"number_of_pieces": 3,
"ups_product_code": "011"
},
{
"date": "2008-07-21T00:00:00",
"item_no": 13,
"number_of_pieces": 3,
"ups_product_code": "011"
},
{
"date": "2008-07-21T00:00:00",
"fees_and_charges": [
{
"charge": 10210,
"charge_type": "400"
},
{
"charge": -8110,
"charge_type": "275"
},
{
"charge": 640,
"charge_type": "FUE"
},
{
"charge": -510,
"charge_type": "295"
}
],
"item_no": 14,
"number_of_pieces": 5,
"ups_product_code": "011"
},
{
"consignees": [
{
"address": {
"city": "CHICAGO",
"country": "US",
"line1": "145 NORTHSIDE WAY DRIVE",
"postal_code": "60625",
"state_province": "IL"
},
"customer_reference_number": "7804--0011-0009-1",
"name": "HFK9VKW",
"packages": [
{
"service_level": "SG",
"weight": 340,
"weight_qualifier": "B"
}
]
}
],
"date": "2008-07-21T00:00:00",
"fees_and_charges": [
{
"charge": 74579,
"charge_type": "400"
},
{
"charge": -51460,
"charge_type": "275"
},
{
"charge": 650,
"charge_type": "690"
},
{
"charge": 1000,
"charge_type": "TTT"
},
{
"charge": 4661,
"charge_type": "FUE"
},
{
"charge": -3216,
"charge_type": "295"
}
],
"item_no": 15,
"number_of_pieces": 1,
"tracking_number": "1Z2063WW0300053961",
"ups_product_code": "021"
},
{
"date": "2008-07-21T00:00:00",
"fees_and_charges": [
{
"charge": 45574,
"charge_type": "400"
},
{
"charge": -30535,
"charge_type": "275"
},
{
"charge": 1950,
"charge_type": "690"
},
{
"charge": 1000,
"charge_type": "TTT"
},
{
"charge": 2849,
"charge_type": "FUE"
},
{
"charge": -1908,
"charge_type": "295"
}
],
"item_no": 16,
"number_of_pieces": 3,
"tracking_number": "1Z2063WW0300014315",
"ups_product_code": "021"
},
{
"date": "2008-07-21T00:00:00",
"item_no": 17,
"number_of_pieces": 1,
"tracking_number": "1Z2063WW0300014315",
"ups_product_code": "021"
},
{
"date": "2008-07-21T00:00:00",
"item_no": 18,
"number_of_pieces": 1,
"tracking_number": "1Z2063WW0300014324",
"ups_product_code": "021"
},
{
"consignees": [
{
"address": {
"city": "MORRISTOWN",
"country": "US",
"line1": "125 UNITED WAY DRIVE",
"postal_code": "07960",
"state_province": "NJ"
},
"customer_reference_number": "7804--0011-0010-3",
"name": "HFK9VKW",
"packages": [
{
"reason_code": "10",
"service_level": "SG",
"weight": 100,
"weight_qualifier": "B"
}
]
}
],
"date": "2008-07-21T00:00:00",
"item_no": 19,
"number_of_pieces": 1,
"tracking_number": "1Z2063WW0300014333",
"ups_product_code": "021"
},
{
"consignees": [
{
"address": {
"city": "MORRISTOWN",
"country": "US",
"line1": "438 SOUTHERN STREET DRIVE",
"postal_code": "07960",
"state_province": "NJ"
},
"customer_reference_number": "7804--0011-0011-1",
"name": "HFK9VKW",
"packages": [
{
"service_level": "SG",
"weight": 500,
"weight_qualifier": "B"
}
]
}
],
"date": "2008-07-21T00:00:00",
"fees_and_charges": [
{
"charge": 45574,
"charge_type": "400"
},
{
"charge": -30535,
"charge_type": "275"
},
{
"charge": 650,
"charge_type": "690"
},
{
"charge": 1000,
"charge_type": "TTT"
},
{
"charge": 2848,
"charge_type": "FUE"
},
{
"charge": -1908,
"charge_type": "295"
}
],
"item_no": 20,
"number_of_pieces": 1,
"tracking_number": "1Z2063WW0300014557",
"ups_product_code": "021"
},
{
"date": "2008-07-21T00:00:00",
"fees_and_charges": [
{
"charge": 50994,
"charge_type": "400"
},
{
"charge": -35441,
"charge_type": "275"
},
{
"charge": 3185,
"charge_type": "FUE"
},
{
"charge": -2212,
"charge_type": "295"
}
],
"item_no": 21,
"number_of_pieces": 7,
"ups_product_code": "024"
},
{
"date": "2008-07-21T00:00:00",
"item_no": 22,
"number_of_pieces": 1,
"tracking_number": "1Z2068WW0300011247",
"ups_product_code": "024"
},
{
"date": "2008-07-21T00:00:00",
"item_no": 23,
"number_of_pieces": 1,
"tracking_number": "1Z2068WW0300011256",
"ups_product_code": "024"
},
{
"date": "2008-07-21T00:00:00",
"item_no": 24,
"number_of_pieces": 1,
"tracking_number": "1Z2068WW0300011390",
"ups_product_code": "024"
},
{
"date": "2008-07-21T00:00:00",
"item_no": 25,
"number_of_pieces": 1,
"tracking_number": "1Z2068WW0300011407",
"ups_product_code": "024"
},
{
"date": "2008-07-21T00:00:00",
"item_no": 26,
"number_of_pieces": 1,
"tracking_number": "1Z2068WW0300011416",
"ups_product_code": "024"
},
{
"date": "2008-07-21T00:00:00",
"item_no": 27,
"number_of_pieces": 1,
"tracking_number": "1Z2068WW0300011425",
"ups_product_code": "024"
},
{
"date": "2008-07-21T00:00:00",
"item_no": 28,
"number_of_pieces": 1,
"tracking_number": "1Z2068WW0300011434",
"ups_product_code": "024"
},
{
"date": "2008-07-21T00:00:00",
"fees_and_charges": [
{
"charge": 10500,