<>93! 03JBFREIGHTRP - Freight Charge Statement By BrandE$$, JBPLAN.tpl13,JBPLAN 3!E$;$,; JBITEM.tpl1;3;,;JBITEM 3"I$>$,> JBBRANDS.tpl1>3>,>JBBRANDS ?3#W$E$$F JBDEALERSDE,EF.tpl1E3E,EF C3$V$E$$FJBPICKUPHE,EF.tpl1E3E,EF I3%Y$E$$F JBSTATENUMSJE,EF.tpl1E3E,EF K3&W$E$$F JBADDRESSE,EF.tpl1E3E,EF 3+$R1:C(7),R2:C(10),R3:C(1),R4:C(30),R5:C(30),R6:C(30),R7:C(30),R8:C(25),R9:C(2),R10:C(10),R11:C(6),R12:C(3),R13:C(7),R14:C(1),R15:C(30),R16:C(15),R17:C(3),R18:C(4),R19:C(20),r20:c(7)<@@FT#PE " 7$ $$,JBPLANnnJ$ 100100100100   sA$td class="td" <>< nowrap>z$ &  {[$@
0 BRANDFAMILY|+$@

Brand Family: @:

0$q 'TRHILITE(
$rBOL#
ShipDateStatCarrier Tracking#Dealer  Li
nesPCSWGTTotal
ChargeU $rr s$1k
$s%
Select Report Parameters
۩' REPORTINTRO @5
rI$t
 r$u%
@۩' REPORTINTRO
۩' REPORTINTRO @
 =r5$v
 uwx !$  $+$< width="۩(">8] ! $ 8]  M$L
 L)$L L8] ,$ $
8]   1$//20 8 ] $"",8]")*+#( *$*, ۩*$5$)۩* ۩+ %8&]'  (F$L  L,$L
L()8*], 6$$2$2ө0@@82E]T4 0fromdate^3test if exists^#(3on step1#(j$yd#ezf{@_Freight_Stmt_ WJBREPORT3{|#$}y~z Lys # L#t z Lzu$Q@oR@p"$ @SUMMARY$$//%$BQQQ44$BRRR 6&3IF ENDAT$=" " THEN LET ENDAT$=$FFFF$>i$ijk 45678pz$%(>

Freight Charges Statement
For Shipment Period: Q to: R

 ('1 3LOOP HEREL1lj&3IF K$(1,2)>ENDAT$(1,2) THEN GOTO 1900 3DO SELECTION! @ML @ML @GL$ @UPS@SUP2#$ @FDX@SFD2($ @CLG@SCL20L23----F1D@UCP$l@XZ. @mJ@m\K$l@n$3------ handle the display of ordersf $@$C $l@J$Z@[ LS3IF H.DROP_CARR$(1,2)<>"UP" AND BL$=FILL(11) THEN LET BL$=PAD("CBL"+H.DROP_PRO$,11)O Z LT# Z\L3already shownY$@T[ MESSENG@TL\ MIDWEST@TL^4JBBREAK1Z]^_`a`& CLUTCH@T $Ih$bo!$gh p ]rc_w^$dAө_c e`cfac|H$d ZZZd$dAZZZ |x$ ܨfܨeܨfܨe$ AE$ I$"$ܨf*c$b <$  $(#####.00$bb*$۩ !$$STAT@$$FB C1IN $5$Z J1 $ $"(۫@M۩۩@T@V [@U](@W, l @Y۩(۩(۩(^۩(]#####.00$""b Ly "$ #L#q۫ "! zLzq"$xx xwLzv$x $\\ZL U 3------ 1>A@< ?6$" @=$%%"&8l3DONEt|3column totalsv$%%
x$b
 z$gh| iciW$dicejcfkc>Ad ?$bb
Brand Subtotals
d@="۩(Өe #####.00lbs۩(Өf $######.00 $ggܨehhܨf*cl$bb'
Total۩(g #####.00lbs۩(h $######.00"$bb
  $%%b$"Ly"$ # L#" z Lz" Uy#z JBREPSUMMARY$A~Reports Menu
$%A
|#(UC$  Total۩($!! *8 9U3^1000 "create the summary pages in an invoice format <$ UPS Charges @UPS$Total CLG Charges :$'ABnameө' COMPANYAB U 0R$'JBnameө' COMPANYAB ө' COMPANYJB U j$'PWnameө' COMPANYAB ܨө' COMPANYJB ө' COMPANYPW U  @UPS > !$ Outbound LTL$ "$ Air/Expedited$ "$ International$ >8 3^100 "subtotals handling $  +$ * :$'ABnameө' COMPANYAB U R$'JBnameө' COMPANYAB ө' COMPANYJB U j$'PWnameө' COMPANYAB ܨө' COMPANYJB ө' COMPANYPW U8U3^1000 " print the summary$"

Freight Charges Statement
For Shipment Period: Q to: R

 $P$"

Printed: ۩ %Mz/%Dz/%Y$$) ? ?1> ?S$"q۩ @=۩( ######.00$$^*hq$"
Total  for ۩( $#,###,###.00$$"
$8$3^100 "dump a line out.Ly"$8 # L#"B z Lz"~8$U 3-------- get all brand info hereT$' COMPANYAB۩' COMPANYJB۩' COMPANYPW۩AZZZ  '  %$۩ *D$QRQ0fromdateR0thrudate3$>Freight Charge Detail Statement
Period: Q thru RAbsolutJim Beam Brands Co.Peak WinesUnautd 88|U $b =$  $( ######.00$bb6 ө' COMPANYAB $R Өө' COMPANYAB Өө' COMPANYJB $$*"$"Ly "$ # L#q"! zLzq"$xx"$"bLy "$ # L#q"! zLzq"$xx$"7Freight Charge StatementAbsolutJim Beam Brands Co.Peak WinesUnauthLy "$ # L#q"! zLzq"$xx$"%Totals۩( $###,###.00۩( $###,###.00۩( $###,###.00Ly "$ # L#q"! zLzq"$xx:8p 3FIX DATESr$$,JBLHHs1tz 1 @Mz @M2004z @SRAPDz"/@ @M @S @T1@[ zFT 04?$@M20L/ z@3T=$ERROR ۩(Ө AT LINE ۩(Ө" IN ۩#^E2#( 3OUTTA HERE#2&N N*E ө/$//N48N>]$N reportparamD$%
 $%%16 POPUPINPUTNfromdateO 3 POPUPINPUTNthrudateP*5$%%q Ship Dates:O Thru P4$%%qCarrier: CLG
UPS
FEDEX>$%%qReport: Detailed
SummaryE$%% &$%%' - Q$%%q1
$%%~83 STEP 2 SELECT BRANDSO$%Brand Family: @: 
 #$%%1JBSELECTOPTIONSJBBRANDSBRANDSCATDESC*FILTERMASK(R.FAMILY$,"@:%")*MULTIPLE*NOTOPVALUE*SELECTALL*AUTH9 $%%9E$%% &N$%% /$%%' - I$%%1
$%%f8TPLHHJBPLANSTARTATENDATUSEKNUMJBITEMTTTQCCCQIQCOUNTTRTDDTROCDATETEXT1 ERRMESSAGECW1CW2CW3CW4YYY1YYY2YYY TDELEMENTTDPLAIN TDNOWRAPTDDRDQTYIDENT1DCOUNTRQTYLCSVCHANCSVLINKTEXTTDDH DFORM1HEADERBRYYCYYSYYZWFCGIWFWFPGMSELECT1CGI DFORM1LOOKUPYYYVTPLTATCTBTSTVRESULT1 CGI.BRANDFAMILYJBITEM JBITEM.RICBRAND JBBRANDS.DESC JBBRANDS JBBRANDSH2BFSUBMENU BRACKET1 JBDEALERS JBDEALERSCF H.QTY JBPICKUP JBPICKUP JBSTATENUMS JBSTATENUMSYYY H.SHIPDATE FORMNAME RESULTFROM RESULTTHRU FROMDATE THRUDATE H.DROP_CARR H.DROP_PRO H.DEALER JBDEALERS.DEALER_ADD1 JBDEALERS.DEALER_CITY JBDEALERS.DEALER_STATE JBDEALERS.DEALER_ZIPBL H.BOLKEYBLLISTTOTCHGTOTWGTRATES0RATES1RATES2DETAILPBRANDWGTCHG1SWGTSCHG1TOTS0TOTS1TOTS2DEALERSTATECODE JBDEALERS.STATENUM JBSTATENUMS.STATE CGI.FROMDATE CGI.THRUDATETRPLAIN COLHEADTR REPHEADHTML REPHEADXL REPHEADPDF REPBREAKPDFPDFLEN PDFCOUNTOUTCHANPDFCHANSDESCENDMENUCSVFILEOUTLINKOUTFILEPDFLINKPDFFILEOCOUNTBRANDSBRANDSCHGTCHGI BRANDSCOL COLHEADTR0CHGWGTBRANDTWGTTOTPCSCHGPPP H.ORDERIDA2B2C2D2E2F2G2H2I2J2K2L2M2N2O2P2Q2R2S2T2U2JBLHH CGI.CARRABCHGJBCHGPWCHG SUMMARYONLY CGI.REPORTTYPE COMPANYDESC TOTCHARGE SBRANDS1 SBRANDS2 CHARGETYPE SHIPTYPEOTHER1 CHARGEGROUPSCHG SUBCHARGEBLSHOW TOTLINES OTHERSHOW CARRSHOW JBADDRESS JBADDRESS OVERRIDE JBADDRESS.DEALER_STATECW1BREMPTYD1 DEALERTOTALSXLCSZCGIVALDD1 BRANDHEADEROABR GETBRANDS BRANDSTOTALSNOBR DOSUMMARY PRINTSUMMARYV