123456789101112131415161718192021222324 |
- $PBExportHeader$dw_priceorder_input.srd
- release 6;
- datawindow(units=0 timer_interval=0 color=80269524 processing=0 print.documentname="" print.orientation = 0 print.margin.left = 110 print.margin.right = 110 print.margin.top = 96 print.margin.bottom = 96 print.paper.source = 0 print.paper.size = 0 print.prompt=no print.buttons=no print.preview.buttons=no )
- summary(height=0 color="536870912" )
- footer(height=0 color="536870912" )
- detail(height=1488 color="536870912" )
- table(column=(type=long update=yes updatewhereclause=yes name=poid dbname="u_price_order.POID" initial="0" )
- column=(type=datetime update=yes updatewhereclause=yes name=begindate dbname="u_price_order.Begindate" initial="today()" )
- column=(type=datetime update=yes updatewhereclause=yes name=enddate dbname="u_price_order.enddate" initial="today()" )
- column=(type=long update=yes updatewhereclause=yes name=mtrlid dbname="u_price_order.Mtrlid" initial="0" )
- column=(type=long update=yes updatewhereclause=yes name=mtrlctnid dbname="u_price_order.MtrlctnID" initial="0" )
- column=(type=long update=yes updatewhereclause=yes name=cusid dbname="u_price_order.Cusid" initial="0" )
- column=(type=char(250) update=yes updatewhereclause=yes name=poexpr dbname="u_price_order.Poexpr" initial="empty" )
- column=(type=long update=yes updatewhereclause=yes name=inuse dbname="u_price_order.Inuse" initial="0" )
- column=(type=char(10) update=yes updatewhereclause=yes name=opemp dbname="u_price_order.Opemp" initial="empty" )
- column=(type=datetime update=yes updatewhereclause=yes name=opdate dbname="u_price_order.opdate" )
- column=(type=char(30) updatewhereclause=yes name=u_mtrlctndef_mtrlctnname dbname="u_mtrlctndef.MtrlctnName" )
- column=(type=char(30) updatewhereclause=yes name=u_mtrldef_mtrlcode dbname="u_mtrldef.mtrlcode" )
- column=(type=char(50) updatewhereclause=yes name=u_mtrldef_mtrlname dbname="u_mtrldef.mtrlname" )
- retrieve="PBSELECT( VERSION(400) TABLE(NAME=~"u_price_order~" ) TABLE(NAME=~"u_mtrldef~" ) TABLE(NAME=~"u_mtrlctndef~" ) COLUMN(NAME=~"u_price_order.POID~") COLUMN(NAME=~"u_price_order.Begindate~") COLUMN(NAME=~"u_price_order.enddate~") COLUMN(NAME=~"u_price_order.Mtrlid~") COLUMN(NAME=~"u_price_order.MtrlctnID~") COLUMN(NAME=~"u_price_order.Cusid~") COLUMN(NAME=~"u_price_order.Poexpr~") COLUMN(NAME=~"u_price_order.Inuse~") COLUMN(NAME=~"u_price_order.Opemp~") COLUMN(NAME=~"u_price_order.opdate~") COLUMN(NAME=~"u_mtrlctndef.MtrlctnName~") COLUMN(NAME=~"u_mtrldef.mtrlcode~") COLUMN(NAME=~"u_mtrldef.mtrlname~") JOIN (LEFT=~"u_price_order.MtrlctnID~" OP =~"=~"RIGHT=~"u_mtrlctndef.MtrlctnID~" OUTER1 =~"u_price_order.MtrlctnID~" ) JOIN (LEFT=~"u_mtrldef.mtrlid~" OP =~"=~"RIGHT=~"u_price_order.Mtrlid~" OUTER2 =~"u_price_order.Mtrlid~" )) " )
- column(band=detail id=13 alignment="0" tabsequence=32766 border="0" color="16711680" x="1714" y="104" height="56" width="613" format="[general]" name=u_mtrldef_mtrlname edit.limit=0 edit.case=any edit.autoselect=yes font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
- column(band=detail id=11 alignment="0" tabsequence=32766 border="0" color="16711680" x="887" y="108" height="56" width="809" format="[general]" name=u_mtrlctndef_mtrlctnname edit.limit=0 edit.case=any edit.autoselect=yes font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
- column(band=detail id=12 alignment="0" tabsequence=32766 border="0" color="16711680" x="64" y="104" height="56" width="809" format="[general]" name=u_mtrldef_mtrlcode edit.limit=0 edit.case=any edit.autoselect=yes font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
- htmltable(border="1" cellpadding="0" cellspacing="0" generatecss="no" nowrap="yes")
|