$PBExportHeader$d_distroutedet_edit.srd
release 9;
datawindow(units=1 timer_interval=0 color=79741120 processing=0 HTMLDW=no print.printername="" print.documentname="" print.orientation = 0 print.margin.left = 24 print.margin.right = 24 print.margin.top = 24 print.margin.bottom = 24 print.paper.source = 0 print.paper.size = 0 print.canusedefaultprinter=yes print.prompt=no print.buttons=no print.preview.buttons=no print.cliptext=no print.overrideprintjob=no print.collate=yes hidegrayline=no )
header(height=2 color="536870912" )
summary(height=1 color="536870912" )
footer(height=0 color="536870912" )
detail(height=311 color="536870912" )
table(column=(type=char(5) update=yes updatewhereclause=yes key=yes name=dist_route dbname="distroutedet.dist_route" )
 column=(type=decimal(0) update=yes updatewhereclause=yes key=yes name=line_no dbname="distroutedet.line_no" )
 column=(type=char(5) update=yes updatewhereclause=yes name=stan_code__fr dbname="distroutedet.stan_code__fr" initial="00" )
 column=(type=char(40) updatewhereclause=yes name=stationa_descr dbname="station.descr" )
 column=(type=char(5) update=yes updatewhereclause=yes name=stan_code__to dbname="distroutedet.stan_code__to" initial="ZZ" )
 column=(type=char(40) updatewhereclause=yes name=station_descr_1 dbname="station.descr" )
 column=(type=char(10) update=yes updatewhereclause=yes name=tran_code dbname="distroutedet.tran_code" )
 column=(type=char(40) updatewhereclause=yes name=tran_name dbname="transporter.tran_name" )
 column=(type=decimal(3) update=yes updatewhereclause=yes name=frt_amt dbname="distroutedet.frt_amt" initial="0" )
 column=(type=char(5) update=yes updatewhereclause=yes name=curr_code dbname="distroutedet.curr_code" )
 column=(type=char(40) updatewhereclause=yes name=currency_descr dbname="currency.descr" )
 column=(type=decimal(3) update=yes updatewhereclause=yes name=tran_time dbname="distroutedet.tran_time" )
 column=(type=decimal(6) update=yes updatewhereclause=yes name=exch_rate dbname="distroutedet.exch_rate" )
 column=(type=char(5) update=yes updatewhereclause=yes name=trans_mode dbname="distroutedet.trans_mode" values="By Air	A    /By Road	R    /By Ship	S    /By Rail	L    /Direct	D    /" )
 column=(type=decimal(6) update=yes updatewhereclause=yes name=min_weight dbname="distroutedet.min_weight" initial="0" )
 column=(type=decimal(6) update=yes updatewhereclause=yes name=max_weight dbname="distroutedet.max_weight" initial="0" )
 column=(type=char(5) update=yes updatewhereclause=yes name=state_code__to dbname="distroutedet.state_code__to" initial="ZZ" )
 column=(type=char(40) updatewhereclause=yes name=descr dbname="state.descr" )
 column=(type=char(5) update=yes updatewhereclause=yes name=state_code__fr dbname="distroutedet.state_code__fr" initial="00" )
 column=(type=char(40) updatewhereclause=yes name=descr_1 dbname="state.descr" )
 column=(type=char(3) update=yes updatewhereclause=yes name=loc_type dbname="distroutedet.loc_type" )
 column=(type=char(15) update=yes updatewhereclause=yes name=pin__fr dbname="distroutedet.pin__fr" initial="00" )
 column=(type=char(15) update=yes updatewhereclause=yes name=pin__to dbname="distroutedet.pin__to" initial="ZZ" )
 retrieve="PBSELECT( VERSION(400) TABLE(NAME=~"distroutedet~" )  TABLE(NAME=~"transporter~" )  TABLE(NAME=~"currency~" )  TABLE(NAME=~"station~" ALIAS=~"station_a~" )  TABLE(NAME=~"station~" ALIAS=~"station_b~" )  TABLE(NAME=~"state~" ALIAS=~"state_a~" )  TABLE(NAME=~"state~" ALIAS=~"state_b~" ) COLUMN(NAME=~"distroutedet.dist_route~") COLUMN(NAME=~"distroutedet.line_no~") COLUMN(NAME=~"distroutedet.stan_code__fr~") COLUMN(NAME=~"station_a.descr~") COLUMN(NAME=~"distroutedet.stan_code__to~") COLUMN(NAME=~"station_b.descr~") COLUMN(NAME=~"distroutedet.tran_code~") COLUMN(NAME=~"transporter.tran_name~") COLUMN(NAME=~"distroutedet.frt_amt~") COLUMN(NAME=~"distroutedet.curr_code~") COLUMN(NAME=~"currency.descr~") COLUMN(NAME=~"distroutedet.tran_time~") COLUMN(NAME=~"distroutedet.exch_rate~") COLUMN(NAME=~"distroutedet.trans_mode~") COLUMN(NAME=~"distroutedet.min_weight~") COLUMN(NAME=~"distroutedet.max_weight~") COLUMN(NAME=~"distroutedet.state_code__to~") COLUMN(NAME=~"state_a.descr~") COLUMN(NAME=~"distroutedet.state_code__fr~") COLUMN(NAME=~"state_b.descr~") COLUMN(NAME=~"distroutedet.loc_type~") COLUMN(NAME=~"distroutedet.pin__fr~") COLUMN(NAME=~"distroutedet.pin__to~")    JOIN (LEFT=~"distroutedet.curr_code~"    OP =~"=~"RIGHT=~"currency.curr_code~"    OUTER1 =~"distroutedet.curr_code~" )    JOIN (LEFT=~"distroutedet.stan_code__fr~"    OP =~"=~"RIGHT=~"station_a.stan_code~"    OUTER1 =~"distroutedet.stan_code__fr~" )    JOIN (LEFT=~"distroutedet.stan_code__to~"    OP =~"=~"RIGHT=~"station_b.stan_code~"    OUTER1 =~"distroutedet.stan_code__to~" )    JOIN (LEFT=~"distroutedet.state_code__fr~"    OP =~"=~"RIGHT=~"state_a.state_code~"    OUTER1 =~"distroutedet.state_code__fr~" )    JOIN (LEFT=~"distroutedet.state_code__to~"    OP =~"=~"RIGHT=~"state_b.state_code~"    OUTER1 =~"distroutedet.state_code__to~" )   JOIN (LEFT=~"distroutedet.tran_code~"    OP =~"=~"RIGHT=~"transporter.tran_code~" ) WHERE(    EXP1 =~"distroutedet.dist_route~"   OP =~"=~"    EXP2 =~":mdistroute~"    LOGIC =~"and~" ) WHERE(    EXP1 =~"distroutedet.line_no~"   OP =~"=~"    EXP2 =~":mlineno~" ) ) ARG(NAME = ~"mdistroute~" TYPE = string)  ARG(NAME = ~"mlineno~" TYPE = number) " update="DISTROUTEDET" updatewhere=0 updatekeyinplace=no arguments=(("mdistroute", string),("mlineno", number)) )
groupbox(band=detail text="Basic"border="5" color="33554432" x="6" y="0" height="262" width="513"  name=gb_1 visible="1"  font.face="Times New Roman" font.height="-10" font.weight="400"  font.family="1" font.pitch="2" font.charset="0" background.mode="1" background.color="553648127" )
column(band=detail id=1 alignment="0" tabsequence=32766 border="5" color="255" x="181" y="19" height="16" width="55" format="[general]" html.valueishtml="0"  name=dist_route visible="1" edit.limit=5 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="Times New Roman" font.height="-10" font.weight="400"  font.family="1" font.pitch="2" font.charset="0" background.mode="2" background.color="79741120" )
text(band=detail alignment="1" text="Line Number:" border="0" color="33554432" x="327" y="19" height="16" width="144" html.valueishtml="0"  name=line_no_t visible="1"  font.face="Times New Roman" font.height="-10" font.weight="400"  font.family="1" font.pitch="2" font.charset="0" background.mode="2" background.color="79741120" )
column(band=detail id=3 alignment="0" tabsequence=10 border="5" color="0" x="181" y="39" height="16" width="55" format="[general]" html.valueishtml="0"  name=stan_code__fr visible="1" edit.limit=5 edit.case=upper edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="Times New Roman" font.height="-10" font.weight="400"  font.family="1" font.pitch="2" font.charset="0" background.mode="2" background.color="1090519039" )
column(band=detail id=5 alignment="0" tabsequence=20 border="5" color="0" x="181" y="59" height="16" width="55" format="[general]" html.valueishtml="0"  name=stan_code__to visible="1" edit.limit=5 edit.case=upper edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="Times New Roman" font.height="-10" font.weight="400"  font.family="1" font.pitch="2" font.charset="0" background.mode="2" background.color="1090519039" )
column(band=detail id=7 alignment="0" tabsequence=30 border="5" color="0" x="181" y="79" height="16" width="93" format="[general]" html.valueishtml="0"  name=tran_code visible="1" edit.limit=10 edit.case=upper edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="Times New Roman" font.height="-10" font.weight="400"  font.family="1" font.pitch="2" font.charset="0" background.mode="2" background.color="1073741824" )
column(band=detail id=9 alignment="1" tabsequence=40 border="5" color="0" x="181" y="99" height="16" width="57" format="#,##,##,###.####" html.valueishtml="0"  name=frt_amt visible="1" edit.limit=14 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="Times New Roman" font.height="-10" font.weight="400"  font.family="1" font.pitch="2" font.charset="0" background.mode="2" background.color="1090519039" )
column(band=detail id=10 alignment="0" tabsequence=60 border="5" color="0" x="181" y="119" height="16" width="56" format="[general]" html.valueishtml="0"  name=curr_code visible="1" edit.limit=5 edit.case=upper edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="Times New Roman" font.height="-10" font.weight="400"  font.family="1" font.pitch="2" font.charset="0" background.mode="2" background.color="1090519039" )
column(band=detail id=14 alignment="0" tabsequence=70 border="5" color="0" x="181" y="139" height="16" width="93" format="[general]" html.valueishtml="0"  name=trans_mode visible="1" ddlb.limit=5 ddlb.allowedit=no ddlb.case=any ddlb.imemode=0  font.face="Times New Roman" font.height="-10" font.weight="400"  font.family="1" font.pitch="2" font.charset="0" background.mode="2" background.color="1090519039" )
column(band=detail id=19 alignment="0" tabsequence=100 border="5" color="0" x="181" y="179" height="16" width="81" format="[general]" html.valueishtml="0"  name=state_code__fr visible="1" edit.limit=5 edit.case=upper edit.autoselect=yes edit.imemode=0  font.face="Times New Roman" font.height="-10" font.weight="400"  font.family="1" font.pitch="2" font.charset="0" background.mode="2" background.color="1090519039" )
column(band=detail id=17 alignment="0" tabsequence=110 border="5" color="0" x="181" y="199" height="16" width="81" format="[general]" html.valueishtml="0"  name=state_code__to visible="1" edit.limit=5 edit.case=upper edit.autoselect=yes edit.imemode=0  font.face="Times New Roman" font.height="-10" font.weight="400"  font.family="1" font.pitch="2" font.charset="0" background.mode="2" background.color="1090519039" )
column(band=detail id=22 alignment="0" tabsequence=120 border="5" color="0" x="181" y="219" height="16" width="81" format="[general]" html.valueishtml="0"  name=pin__fr visible="1" edit.limit=15 edit.case=upper edit.autoselect=yes edit.imemode=0  font.face="Times New Roman" font.height="-10" font.weight="400"  font.family="1" font.pitch="2" font.charset="0" background.mode="2" background.color="1090519039" )
text(band=detail alignment="1" text="Transaction Time:" border="0" color="0" x="325" y="99" height="16" width="126" html.valueishtml="0"  name=tran_time_t visible="1"  font.face="Times New Roman" font.height="-10" font.weight="400"  font.family="1" font.pitch="2" font.charset="0" background.mode="2" background.color="79741120" )
text(band=detail alignment="1" text="Pin Code To:" border="0" color="0" x="330" y="219" height="15" width="97" html.valueishtml="0"  name=pin__to_t visible="1"  font.face="Times New Roman" font.height="-10" font.weight="400"  font.family="1" font.pitch="2" font.charset="0" background.mode="2" background.color="79741120" )
column(band=detail id=2 alignment="1" tabsequence=32766 border="5" color="255" x="475" y="19" height="16" width="37" format="#,##,##,###.####" html.valueishtml="0"  name=line_no visible="1" edit.limit=3 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="Times New Roman" font.height="-10" font.weight="400"  font.family="1" font.pitch="2" font.charset="0" background.mode="2" background.color="79741120" )
column(band=detail id=4 alignment="0" tabsequence=32766 border="5" color="255" x="242" y="39" height="16" width="270" format="[general]" html.valueishtml="0"  name=stationa_descr visible="1" edit.limit=40 edit.case=any edit.autoselect=yes edit.imemode=0  font.face="Times New Roman" font.height="-10" font.weight="400"  font.family="1" font.pitch="2" font.charset="0" background.mode="2" background.color="79741120" )
column(band=detail id=6 alignment="0" tabsequence=32766 border="5" color="255" x="243" y="59" height="16" width="269" format="[general]" html.valueishtml="0"  name=station_descr_1 visible="1" edit.limit=40 edit.case=any edit.autoselect=yes edit.imemode=0  font.face="Times New Roman" font.height="-10" font.weight="400"  font.family="1" font.pitch="2" font.charset="0" background.mode="2" background.color="67108864" )
column(band=detail id=8 alignment="0" tabsequence=32766 border="5" color="255" x="278" y="79" height="16" width="234" format="[general]" html.valueishtml="0"  name=tran_name visible="1" edit.limit=40 edit.case=any edit.autoselect=yes edit.imemode=0  font.face="Times New Roman" font.height="-10" font.weight="400"  font.family="1" font.pitch="2" font.charset="0" background.mode="2" background.color="67108864" )
column(band=detail id=12 alignment="1" tabsequence=50 border="5" color="0" x="455" y="99" height="16" width="57" format="#,##,##,###.####" html.valueishtml="0"  name=tran_time visible="1" edit.limit=13 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="Times New Roman" font.height="-10" font.weight="400"  font.family="1" font.pitch="2" font.charset="0" background.mode="2" background.color="1090519039" )
column(band=detail id=13 alignment="1" tabsequence=32766 border="5" color="255" x="414" y="139" height="16" width="98" format="[general]" html.valueishtml="0"  name=exch_rate visible="1" edit.limit=15 edit.case=any edit.autoselect=yes edit.imemode=0  font.face="Times New Roman" font.height="-10" font.weight="400"  font.family="1" font.pitch="2" font.charset="0" background.mode="2" background.color="67108864" )
column(band=detail id=20 alignment="0" tabsequence=32766 border="5" color="255" x="269" y="199" height="16" width="243" format="[general]" html.valueishtml="0"  name=descr_1 visible="1" edit.limit=40 edit.case=any edit.autoselect=yes edit.imemode=0  font.face="Times New Roman" font.height="-10" font.weight="400"  font.family="1" font.pitch="2" font.charset="0" background.mode="2" background.color="67108864" )
column(band=detail id=18 alignment="0" tabsequence=32766 border="5" color="255" x="270" y="179" height="16" width="243" format="[general]" html.valueishtml="0"  name=descr visible="1" edit.limit=40 edit.case=any edit.autoselect=yes edit.imemode=0  font.face="Times New Roman" font.height="-10" font.weight="400"  font.family="1" font.pitch="2" font.charset="0" background.mode="2" background.color="67108864" )
column(band=detail id=23 alignment="0" tabsequence=130 border="5" color="0" x="431" y="219" height="16" width="81" format="[general]" html.valueishtml="0"  name=pin__to visible="1" edit.limit=15 edit.case=upper edit.autoselect=yes edit.imemode=0  font.face="Times New Roman" font.height="-10" font.weight="400"  font.family="1" font.pitch="2" font.charset="0" background.mode="2" background.color="1090519039" )
column(band=detail id=21 alignment="0" tabsequence=140 border="5" color="0" x="182" y="239" height="16" width="330" format="[general]" html.valueishtml="0"  name=loc_type visible="1" edit.limit=3 edit.case=upper edit.autoselect=yes edit.imemode=0  font.face="Times New Roman" font.height="-10" font.weight="400"  font.family="1" font.pitch="2" font.charset="0" background.mode="2" background.color="1090519039" )
column(band=detail id=11 alignment="0" tabsequence=32766 border="5" color="255" x="242" y="119" height="16" width="270" format="[general]" html.valueishtml="0"  name=currency_descr visible="1" edit.limit=40 edit.case=any edit.autoselect=yes edit.imemode=0  font.face="Times New Roman" font.height="-10" font.weight="400"  font.family="1" font.pitch="2" font.charset="0" background.mode="2" background.color="79741120" )
text(band=detail alignment="1" text="Exchange Rate:" border="0" color="0" x="302" y="139" height="16" width="108" html.valueishtml="0"  name=exch_rate_t visible="1"  font.face="Times New Roman" font.height="-10" font.weight="400"  font.family="1" font.pitch="2" font.charset="0" background.mode="2" background.color="79741120" )
text(band=detail alignment="1" text="Dist. route:" border="0" color="33554432" x="13" y="19" height="16" width="164" html.valueishtml="0"  name=dist_route_t visible="1"  font.face="Times New Roman" font.height="-10" font.weight="400"  font.family="1" font.pitch="2" font.charset="0" background.mode="2" background.color="79741120" )
text(band=detail alignment="1" text="Station From:" border="0" color="33554432" x="13" y="39" height="16" width="164" html.valueishtml="0"  name=stan_code__fr_t visible="1"  font.face="Times New Roman" font.height="-10" font.weight="400"  font.family="1" font.pitch="2" font.charset="0" background.mode="2" background.color="79741120" )
text(band=detail alignment="1" text="Station To:" border="0" color="33554432" x="13" y="59" height="16" width="164" html.valueishtml="0"  name=stan_code__to_t visible="1"  font.face="Times New Roman" font.height="-10" font.weight="400"  font.family="1" font.pitch="2" font.charset="0" background.mode="2" background.color="79741120" )
text(band=detail alignment="1" text="Transporter:" border="0" color="33554432" x="13" y="79" height="16" width="164" html.valueishtml="0"  name=tran_code_t visible="1"  font.face="Times New Roman" font.height="-10" font.weight="400"  font.family="1" font.pitch="2" font.charset="0" background.mode="2" background.color="79741120" )
text(band=detail alignment="1" text="Freight Amount:" border="0" color="33554432" x="13" y="99" height="16" width="164" html.valueishtml="0"  name=frt_amt_t visible="1"  font.face="Times New Roman" font.height="-10" font.weight="400"  font.family="1" font.pitch="2" font.charset="0" background.mode="2" background.color="79741120" )
text(band=detail alignment="1" text="Currency:" border="0" color="33554432" x="13" y="119" height="16" width="164" html.valueishtml="0"  name=curr_code_t visible="1"  font.face="Times New Roman" font.height="-10" font.weight="400"  font.family="1" font.pitch="2" font.charset="0" background.mode="2" background.color="79741120" )
text(band=detail alignment="1" text="Transporter Mode:" border="0" color="0" x="13" y="139" height="16" width="164" html.valueishtml="0"  name=trans_mode_t visible="1"  font.face="Times New Roman" font.height="-10" font.weight="400"  font.family="1" font.pitch="2" font.charset="0" background.mode="2" background.color="79741120" )
text(band=detail alignment="1" text="State Code From:" border="0" color="0" x="13" y="179" height="16" width="164" html.valueishtml="0"  name=state_code__fr_t visible="1"  font.face="Times New Roman" font.height="-10" font.weight="400"  font.family="1" font.pitch="2" font.charset="0" background.mode="2" background.color="79741120" )
text(band=detail alignment="1" text="State Code To:" border="0" color="0" x="13" y="199" height="16" width="164" html.valueishtml="0"  name=state_code__to_t visible="1"  font.face="Times New Roman" font.height="-10" font.weight="400"  font.family="1" font.pitch="2" font.charset="0" background.mode="2" background.color="79741120" )
text(band=detail alignment="1" text="Pin Code From:" border="0" color="0" x="13" y="219" height="16" width="164" html.valueishtml="0"  name=pin__fr_t visible="1"  font.face="Times New Roman" font.height="-10" font.weight="400"  font.family="1" font.pitch="2" font.charset="0" background.mode="2" background.color="79741120" )
text(band=detail alignment="1" text="Location Type:" border="0" color="0" x="14" y="239" height="16" width="164" html.valueishtml="0"  name=loc_type_t visible="1"  font.face="Times New Roman" font.height="-10" font.weight="400"  font.family="1" font.pitch="2" font.charset="0" background.mode="2" background.color="79741120" )
text(band=detail alignment="1" text="Minimum Weight:" border="0" color="0" x="14" y="159" height="16" width="164" html.valueishtml="0"  name=min_weight_t visible="1"  font.face="Times New Roman" font.height="-10" font.weight="400"  font.family="1" font.pitch="2" font.charset="0" background.mode="2" background.color="79741120" )
column(band=detail id=15 alignment="1" tabsequence=90 border="5" color="0" x="182" y="159" height="16" width="98" format="[general]" html.valueishtml="0"  name=min_weight visible="1" edit.limit=15 edit.case=any edit.autoselect=yes edit.imemode=0  font.face="Times New Roman" font.height="-10" font.weight="400"  font.family="1" font.pitch="2" font.charset="0" background.mode="2" background.color="1090519039" )
text(band=detail alignment="1" text="Maximum Weight:" border="0" color="0" x="313" y="159" height="16" width="107" html.valueishtml="0"  name=max_weight_t visible="1"  font.face="Times New Roman" font.height="-10" font.weight="400"  font.family="1" font.pitch="2" font.charset="0" background.mode="2" background.color="79741120" )
column(band=detail id=16 alignment="1" tabsequence=80 border="5" color="0" x="424" y="159" height="16" width="88" format="[general]" html.valueishtml="0"  name=max_weight visible="1" edit.limit=15 edit.case=any edit.autoselect=yes edit.imemode=0  font.face="Times New Roman" font.height="-10" font.weight="400"  font.family="1" font.pitch="2" font.charset="0" background.mode="2" background.color="1090519039" )
htmltable(border="1" )
htmlgen(clientevents="1" clientvalidation="1" clientcomputedfields="1" clientformatting="0" clientscriptable="0" generatejavascript="1" encodeselflinkargs="1" netscapelayers="0" )
export.xml(headgroups="1" includewhitespace="0" metadatatype=0 savemetadata=0  template=(comment="" encoding="UTF-8" name="d_distroute_det_edit" xml="<?xml version=~"1.0~" encoding=~"UTF-8~" standalone=~"no~"?><d_distroutedet_edit><d_distroutedet_edit_row __pbband=~"detail~"><dist_route>dist_route</dist_route><line_no>line_no</line_no><stan_code__fr>stan_code__fr</stan_code__fr><stan_code__to>stan_code__to</stan_code__to><tran_code>tran_code</tran_code><frt_amt>frt_amt</frt_amt><curr_code>curr_code</curr_code><tran_time>tran_time</tran_time><transporter_tran_name/><currency_descr>currency_descr</currency_descr><stationa_descr>stationa_descr</stationa_descr><station_descr_1/><trans_mode>trans_mode</trans_mode><max_weight>max_weight</max_weight><min_weight>min_weight</min_weight><state_code__to>state_code__to</state_code__to><state_code__fr>state_code__fr</state_code__fr><exch_rate>exch_rate</exch_rate><loc_type>loc_type</loc_type><descr>descr</descr><descr_1>descr_1</descr_1></d_distroutedet_edit_row></d_distroutedet_edit>"))
import.xml()
export.pdf(method=0 distill.custompostscript="0" xslfop.print="0" )
 