$PBExportHeader$d_wave_task11.srd
release 9;
datawindow(units=1 timer_interval=0 color=67108864 processing=1 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 grid.lines=0 )
header(height=22 color="536870912" )
summary(height=0 color="536870912" )
footer(height=0 color="536870912" )
detail(height=22 color="536870912" )
table(column=(type=char(12) update=yes updatewhereclause=yes key=yes name=wave_id dbname="wave_task.wave_id" )
 column=(type=datetime update=yes updatewhereclause=yes name=tran_date dbname="wave_task.tran_date" )
 column=(type=char(10) update=yes updatewhereclause=yes name=sale_order__from dbname="wave_task.sale_order__from" )
 column=(type=char(10) update=yes updatewhereclause=yes name=sale_order__to dbname="wave_task.sale_order__to" )
 column=(type=char(10) update=yes updatewhereclause=yes name=cust_code__from dbname="wave_task.cust_code__from" )
 column=(type=char(10) update=yes updatewhereclause=yes name=cust_code__to dbname="wave_task.cust_code__to" )
 column=(type=datetime update=yes updatewhereclause=yes name=due_date__from dbname="wave_task.due_date__from" )
 column=(type=datetime update=yes updatewhereclause=yes name=due_date__to dbname="wave_task.due_date__to" )
 column=(type=char(10) update=yes updatewhereclause=yes name=chg_user dbname="wave_task.chg_user" )
 column=(type=char(15) update=yes updatewhereclause=yes name=chg_term dbname="wave_task.chg_term" )
 column=(type=datetime update=yes updatewhereclause=yes name=chg_date dbname="wave_task.chg_date" )
 column=(type=char(1) update=yes updatewhereclause=yes name=hold_status dbname="wave_task.hold_status" initial="N" )
 column=(type=char(1) update=yes updatewhereclause=yes name=cancel dbname="wave_task.cancel" )
 column=(type=char(9) updatewhereclause=yes name=status dbname="status" )
 retrieve="PBSELECT( VERSION(400) TABLE(NAME=~"wave_task~" ) COLUMN(NAME=~"wave_task.wave_id~") COLUMN(NAME=~"wave_task.tran_date~") COLUMN(NAME=~"wave_task.sale_order__from~") COLUMN(NAME=~"wave_task.sale_order__to~") COLUMN(NAME=~"wave_task.cust_code__from~") COLUMN(NAME=~"wave_task.cust_code__to~") COLUMN(NAME=~"wave_task.due_date__from~") COLUMN(NAME=~"wave_task.due_date__to~") COLUMN(NAME=~"wave_task.chg_user~") COLUMN(NAME=~"wave_task.chg_term~") COLUMN(NAME=~"wave_task.chg_date~") COLUMN(NAME=~"wave_task.hold_status~") COLUMN(NAME=~"wave_task.cancel~") COMPUTE(NAME=~"CASE WHEN WAVE_TASK.CANCEL = 'Y' then 'CANCEL' WHEN ( SELECT FN_WAVE_STATUS(WAVE_ID) AS STATUS FROM  DUAL)    = 'Y' THEN 'COMPLETED' ELSE 'PENDING' END STATUS~")WHERE(    EXP1 =~"~~~"WAVE_TASK~~~".~~~"TRAN_DATE~~~"~"   OP =~">=~"    EXP2 =~":from_date~"    LOGIC =~"and~" ) WHERE(    EXP1 =~"~~~"WAVE_TASK~~~".~~~"TRAN_DATE~~~"~"   OP =~"<=~"    EXP2 =~":to_date~" ) ) ARG(NAME = ~"from_date~" TYPE = datetime)  ARG(NAME = ~"to_date~" TYPE = datetime) " update="WAVE_TASK" updatewhere=1 updatekeyinplace=no arguments=(("from_date", datetime),("to_date", datetime)) )
text(band=header alignment="2" text="Wave ID" border="6" color="0" x="2" y="2" height="16" width="75" html.valueishtml="0"  name=wave_id_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="67108864" )
text(band=header alignment="2" text="Transaction Date" border="6" color="0" x="79" y="2" height="16" width="101" html.valueishtml="0"  name=tran_date_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="67108864" )
text(band=header alignment="2" text="Sale Order from" border="6" color="0" x="182" y="2" height="16" width="89" html.valueishtml="0"  name=sale_order__from_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="67108864" )
text(band=header alignment="2" text="Sale Order To" border="6" color="0" x="273" y="2" height="16" width="84" html.valueishtml="0"  name=sale_order__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="67108864" )
text(band=header alignment="2" text="Cust Code From" border="6" color="0" x="359" y="2" height="16" width="95" html.valueishtml="0"  name=cust_code__from_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="67108864" )
text(band=header alignment="2" text="Cust Code To" border="6" color="0" x="456" y="2" height="16" width="80" html.valueishtml="0"  name=cust_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="67108864" )
text(band=header alignment="2" text="Due Date from" border="6" color="0" x="538" y="2" height="16" width="89" html.valueishtml="0"  name=due_date__from_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="67108864" )
text(band=header alignment="2" text="Due Date to " border="6" color="0" x="629" y="2" height="16" width="73" html.valueishtml="0"  name=due_date__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="67108864" )
text(band=header alignment="2" text="Hold Status" border="6" color="0" x="704" y="3" height="16" width="76" html.valueishtml="0"  name=hold_status_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="67108864" )
text(band=header alignment="2" text="Cancel Status" border="6" color="0" x="782" y="2" height="16" width="79" html.valueishtml="0"  name=cancel_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="67108864" )
text(band=header alignment="2" text="Status" border="6" color="0" x="863" y="2" height="16" width="82" html.valueishtml="0"  name=status_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="67108864" )
text(band=header alignment="2" text="Changed User" border="6" color="0" x="947" y="2" height="16" width="59" html.valueishtml="0"  name=chg_user_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="67108864" )
text(band=header alignment="2" text="Changed Term" border="6" color="0" x="1008" y="2" height="16" width="62" html.valueishtml="0"  name=chg_term_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="67108864" )
text(band=header alignment="2" text="Change Date" border="6" color="0" x="1072" y="2" height="16" width="80" html.valueishtml="0"  name=chg_date_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="67108864" )
column(band=detail id=1 alignment="2" tabsequence=32766 border="5" color="33554432" x="2" y="0" height="19" width="75" format="[general]" html.valueishtml="0"  name=wave_id  tag="Ttransaction ID of wave task" visible="1" edit.limit=12 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="2" font.pitch="2" font.charset="0" background.mode="2" background.color="16777215" )
column(band=detail id=2 alignment="2" tabsequence=32766 border="5" color="33554432" x="79" y="0" height="19" width="101" format="[shortdate] [time]" html.valueishtml="0"  name=tran_date  tag="Transaction Date" visible="1" edit.limit=0 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="2" font.pitch="2" font.charset="0" background.mode="2" background.color="16777215" )
column(band=detail id=3 alignment="2" tabsequence=32766 border="5" color="33554432" x="182" y="0" height="19" width="89" format="[general]" html.valueishtml="0"  name=sale_order__from  tag="Sales order from" visible="1" edit.limit=10 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="2" font.pitch="2" font.charset="0" background.mode="2" background.color="16777215" )
column(band=detail id=4 alignment="2" tabsequence=32766 border="5" color="33554432" x="273" y="0" height="19" width="84" format="[general]" html.valueishtml="0"  name=sale_order__to  tag="Sales order to" visible="1" edit.limit=10 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="2" font.pitch="2" font.charset="0" background.mode="2" background.color="16777215" )
column(band=detail id=5 alignment="2" tabsequence=32766 border="5" color="33554432" x="359" y="0" height="19" width="95" format="[general]" html.valueishtml="0"  name=cust_code__from  tag="Customer code from" visible="1" edit.limit=10 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="2" font.pitch="2" font.charset="0" background.mode="2" background.color="16777215" )
column(band=detail id=6 alignment="2" tabsequence=32766 border="5" color="33554432" x="456" y="0" height="19" width="80" format="[general]" html.valueishtml="0"  name=cust_code__to  tag="Customer code to" visible="1" edit.limit=10 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="2" font.pitch="2" font.charset="0" background.mode="2" background.color="16777215" )
column(band=detail id=7 alignment="2" tabsequence=32766 border="5" color="33554432" x="538" y="0" height="19" width="89" format="[shortdate] [time]" html.valueishtml="0"  name=due_date__from  tag="Due date from" visible="1" edit.limit=0 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="2" font.pitch="2" font.charset="0" background.mode="2" background.color="16777215" )
column(band=detail id=8 alignment="2" tabsequence=32766 border="5" color="33554432" x="629" y="0" height="19" width="73" format="[shortdate] [time]" html.valueishtml="0"  name=due_date__to  tag="due date to" visible="1" edit.limit=0 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="2" font.pitch="2" font.charset="0" background.mode="2" background.color="16777215" )
column(band=detail id=12 alignment="2" tabsequence=32766 border="5" color="33554432" x="704" y="0" height="19" width="76" format="[general]" html.valueishtml="0"  name=hold_status visible="1" edit.limit=0 edit.case=any edit.autoselect=yes edit.imemode=0  font.face="Times New Roman" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="16777215" )
column(band=detail id=13 alignment="2" tabsequence=32766 border="5" color="33554432" x="782" y="0" height="19" width="79" format="[general]" html.valueishtml="0"  name=cancel visible="1" edit.limit=0 edit.case=any edit.autoselect=yes edit.imemode=0  font.face="Times New Roman" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="16777215" )
column(band=detail id=14 alignment="2" tabsequence=32766 border="5" color="33554432" x="863" y="0" height="19" width="82" format="[general]" html.valueishtml="0"  name=status visible="1" edit.limit=15 edit.case=upper edit.autoselect=yes edit.required=yes edit.imemode=0  font.face="Times New Roman" font.height="-10" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="16777215" )
column(band=detail id=9 alignment="2" tabsequence=32766 border="5" color="33554432" x="947" y="0" height="19" width="59" format="[general]" html.valueishtml="0"  name=chg_user  tag="User who has last modified the transaction internally updated by system" visible="1" edit.limit=10 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="2" font.pitch="2" font.charset="0" background.mode="2" background.color="16777215" )
column(band=detail id=10 alignment="2" tabsequence=32766 border="5" color="33554432" x="1008" y="0" height="19" width="62" format="[general]" html.valueishtml="0"  name=chg_term  tag="Terminal from which the transaction has been last modified, internally updated by the system" visible="1" edit.limit=15 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="2" font.pitch="2" font.charset="0" background.mode="2" background.color="16777215" )
column(band=detail id=11 alignment="2" tabsequence=32766 border="5" color="33554432" x="1072" y="0" height="19" width="80" format="[shortdate] [time]" html.valueishtml="0"  name=chg_date  tag="Date when the transaction has last modified, internally updated by system" visible="1" edit.limit=0 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="2" font.pitch="2" font.charset="0" background.mode="2" background.color="16777215" )
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 )
import.xml()
export.pdf(method=0 distill.custompostscript="0" xslfop.print="0" )
 