123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123 |
- $PBExportHeader$dw_rp_salebill.srd
- release 11.5;
- datawindow(units=0 timer_interval=0 color=1073741824 brushmode=0 transparency=0 gradient.angle=0 gradient.color=8421504 gradient.focus=0 gradient.repetition.count=0 gradient.repetition.length=100 gradient.repetition.mode=0 gradient.scale=100 gradient.spread=100 gradient.transparency=0 picture.blur=0 picture.clip.bottom=0 picture.clip.left=0 picture.clip.right=0 picture.clip.top=0 picture.mode=0 picture.scale.x=100 picture.scale.y=100 picture.transparency=0 processing=1 HTMLDW=no print.printername="" 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.canusedefaultprinter=yes print.prompt=no print.buttons=no print.preview.buttons=no print.cliptext=no print.overrideprintjob=no print.collate=yes print.background=no print.preview.background=no print.preview.outline=yes hidegrayline=no showbackcoloronxp=no picture.file="" grid.lines=0 selected.mouse=no )
- header(height=264 color="536870912" transparency="0" gradient.color="8421504" gradient.transparency="0" gradient.angle="0" brushmode="0" gradient.repetition.mode="0" gradient.repetition.count="0" gradient.repetition.length="100" gradient.focus="0" gradient.scale="100" gradient.spread="100" )
- summary(height=64 color="536870912" transparency="0" gradient.color="8421504" gradient.transparency="0" gradient.angle="0" brushmode="0" gradient.repetition.mode="0" gradient.repetition.count="0" gradient.repetition.length="100" gradient.focus="0" gradient.scale="100" gradient.spread="100" )
- footer(height=64 color="536870912" transparency="0" gradient.color="8421504" gradient.transparency="0" gradient.angle="0" brushmode="0" gradient.repetition.mode="0" gradient.repetition.count="0" gradient.repetition.length="100" gradient.focus="0" gradient.scale="100" gradient.spread="100" )
- detail(height=76 color="536870912" transparency="0" gradient.color="8421504" gradient.transparency="0" gradient.angle="0" brushmode="0" gradient.repetition.mode="0" gradient.repetition.count="0" gradient.repetition.length="100" gradient.focus="0" gradient.scale="100" gradient.spread="100" )
- table(column=(type=long updatewhereclause=yes name=u_salebill_salebillid dbname="u_salebill.salebillid" initial="0" )
- column=(type=char(20) updatewhereclause=yes name=u_cust_cuscode dbname="u_cust.cuscode" initial="empty" )
- column=(type=long updatewhereclause=yes name=u_salebill_billtype dbname="u_salebill.billtype" initial="1" )
- column=(type=long updatewhereclause=yes name=u_salebill_moneyid dbname="u_salebill.moneyid" )
- column=(type=long updatewhereclause=yes name=u_salebill_accountsid dbname="u_salebill.accountsid" initial="0" )
- column=(type=long updatewhereclause=yes name=u_salebill_itemid dbname="u_salebill.itemid" initial="0" )
- column=(type=datetime updatewhereclause=yes name=u_salebill_takedate dbname="u_salebill.takedate" initial="today" )
- column=(type=char(30) updatewhereclause=yes name=u_salebill_relcode dbname="u_salebill.relcode" initial="empty" )
- column=(type=char(20) updatewhereclause=yes name=u_salebill_inrep dbname="u_salebill.inrep" initial="empty" )
- column=(type=long updatewhereclause=yes name=u_salebill_banktypeid dbname="u_salebill.banktypeid" initial="0" )
- column=(type=char(255) updatewhereclause=yes name=u_salebill_dscrp dbname="u_salebill.dscrp" initial="empty" )
- column=(type=long updatewhereclause=yes name=u_salebill_cusid dbname="u_salebill.cusid" initial="0" )
- column=(type=char(20) updatewhereclause=yes name=u_salebill_salebillcode dbname="u_salebill.salebillcode" initial="empty" )
- column=(type=datetime updatewhereclause=yes name=u_salebill_opdate dbname="u_salebill.opdate" )
- column=(type=char(20) updatewhereclause=yes name=u_salebill_opemp dbname="u_salebill.opemp" )
- column=(type=datetime updatewhereclause=yes name=u_salebill_auditdate dbname="u_salebill.auditdate" )
- column=(type=char(20) updatewhereclause=yes name=u_salebill_auditrep dbname="u_salebill.auditrep" )
- column=(type=long updatewhereclause=yes name=u_salebill_flag dbname="u_salebill.flag" initial="0" values=" 1/ 0" )
- column=(type=char(50) updatewhereclause=yes name=u_cust_name dbname="u_cust.name" initial="empty" )
- column=(type=long updatewhereclause=yes name=u_salebill_ywrepid dbname="u_salebill.YwrepID" initial="0" )
- column=(type=long updatewhereclause=yes name=u_salebill_buildtype dbname="u_salebill.buildtype" )
- column=(type=char(30) updatewhereclause=yes name=cw_currency_currencyname dbname="cw_currency.currencyname" )
- column=(type=char(255) updatewhereclause=yes name=u_salebillmx_relbillcode dbname="u_salebillmx.relbillcode" )
- column=(type=decimal(5) updatewhereclause=yes name=u_salebillmx_maintakeamt dbname="u_salebillmx.maintakeamt" )
- column=(type=decimal(5) updatewhereclause=yes name=u_salebillmx_mainmsttakeamt dbname="u_salebillmx.mainmsttakeamt" )
- column=(type=char(30) updatewhereclause=yes name=u_salebillmx_billcode dbname="u_salebillmx.billcode" )
- column=(type=decimal(5) updatewhereclause=yes name=u_salebillmx_takeamt dbname="u_salebillmx.takeamt" )
- column=(type=decimal(5) updatewhereclause=yes name=u_salebillmx_msttakeamt dbname="u_salebillmx.msttakeamt" )
- column=(type=decimal(5) updatewhereclause=yes name=u_salebillmx_oriamt dbname="u_salebillmx.oriamt" )
- retrieve="SELECT u_salebill.salebillid, u_cust.cuscode, u_salebill.billtype, u_salebill.moneyid,
- u_salebill.accountsid, u_salebill.itemid, u_salebill.takedate, u_salebill.relcode,
- u_salebill.inrep, u_salebill.banktypeid, u_salebill.dscrp, u_salebill.cusid,
- u_salebill.salebillcode, u_salebill.opdate, u_salebill.opemp, u_salebill.auditdate,
- u_salebill.auditrep, u_salebill.flag, u_cust.name, u_salebill.YwrepID,
- u_salebill.buildtype, cw_currency.name AS currencyname, u_salebillmx.relbillcode,
- u_salebillmx.maintakeamt, u_salebillmx.mainmsttakeamt, u_salebillmx.billcode,
- u_salebillmx.takeamt , u_salebillmx.msttakeamt ,
- u_salebillmx.oriamt
- FROM u_cust INNER JOIN
- u_salebill ON u_cust.cusid = u_salebill.cusid INNER JOIN
- cw_currency ON u_salebill.moneyid = cw_currency.moneyid INNER JOIN
- u_salebillmx ON u_salebill.salebillid = u_salebillmx.salebillid
- where (u_salebill.takedate >= :arg_dat1) and
- (u_salebill.takedate <= :arg_dat2) and
- ( u_cust.cusareaid in (:arg_cusareaid) ) " arguments=(("arg_dat1", datetime),("arg_dat2", datetime),("arg_cusareaid", numberlist)) sort="u_salebill_salebillid A " )
- group(level=1 header.height=0 trailer.height=0 by=("u_salebill_salebillid" ) header.color="536870912" header.transparency="0" header.gradient.color="8421504" header.gradient.transparency="0" header.gradient.angle="0" header.brushmode="0" header.gradient.repetition.mode="0" header.gradient.repetition.count="0" header.gradient.repetition.length="100" header.gradient.focus="0" header.gradient.scale="100" header.gradient.spread="100" trailer.color="536870912" trailer.transparency="0" trailer.gradient.color="8421504" trailer.gradient.transparency="0" trailer.gradient.angle="0" trailer.brushmode="0" trailer.gradient.repetition.mode="0" trailer.gradient.repetition.count="0" trailer.gradient.repetition.length="100" trailer.gradient.focus="0" trailer.gradient.scale="100" trailer.gradient.spread="100" )
- text(band=header alignment="2" text="单据编号" border="2" color="0" x="9" y="204" height="60" width="352" html.valueishtml="0" name=u_salebill_salebillcode_t visible="1" font.face="宋体" font.height="-10" font.weight="700" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="1073741824" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
- text(band=header alignment="2" text="相关号码" border="2" color="0" x="370" y="204" height="60" width="411" html.valueishtml="0" name=u_salebill_relcode_t visible="1" font.face="宋体" font.height="-10" font.weight="700" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="1073741824" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
- text(band=header alignment="2" text="发生时间" border="2" color="0" x="791" y="204" height="60" width="320" html.valueishtml="0" name=u_salebill_takedate_t visible="1" font.face="宋体" font.height="-10" font.weight="700" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="1073741824" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
- text(band=header alignment="2" text="备注" border="2" color="0" x="3186" y="204" height="60" width="914" html.valueishtml="0" name=u_salebill_dscrp_t visible="1" font.face="宋体" font.height="-10" font.weight="700" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="1073741824" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
- text(band=header alignment="2" text="建立时间" border="2" color="0" x="4110" y="204" height="60" width="471" html.valueishtml="0" name=u_salebill_opdate_t visible="1" font.face="宋体" font.height="-10" font.weight="700" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="1073741824" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
- text(band=header alignment="2" text="建立人" border="2" color="0" x="4590" y="204" height="60" width="256" html.valueishtml="0" name=u_salebill_opemp_t visible="1" font.face="宋体" font.height="-10" font.weight="700" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="1073741824" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
- text(band=header alignment="2" text="审核时间" border="2" color="0" x="4997" y="204" height="60" width="457" html.valueishtml="0" name=u_salebill_auditdate_t visible="1" font.face="宋体" font.height="-10" font.weight="700" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="1073741824" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
- text(band=header alignment="2" text="审核" border="2" color="0" x="4855" y="204" height="60" width="133" html.valueishtml="0" name=u_salebill_flag_t visible="1" font.face="宋体" font.height="-10" font.weight="700" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="1073741824" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
- text(band=header alignment="2" text="客户编号" border="2" color="0" x="1120" y="204" height="60" width="334" html.valueishtml="0" name=u_cust_cuscode_t visible="1" font.face="宋体" font.height="-10" font.weight="700" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="1073741824" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
- text(band=header alignment="2" text="客户名称" border="2" color="0" x="1463" y="204" height="60" width="745" html.valueishtml="0" name=u_cust_name_t visible="1" font.face="宋体" font.height="-10" font.weight="700" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="1073741824" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
- text(band=header alignment="2" text="经手人" border="2" color="0" x="2217" y="204" height="60" width="256" html.valueishtml="0" name=u_salebill_inrep_t visible="1" font.face="宋体" font.height="-10" font.weight="700" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="1073741824" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
- text(band=header alignment="2" text="类型" border="2" color="0" x="2811" y="204" height="60" width="366" html.valueishtml="0" name=u_salebill_billtype_t visible="1" font.face="宋体" font.height="-10" font.weight="700" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="1073741824" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
- text(band=header alignment="2" text="审核人" border="2" color="0" x="5463" y="204" height="60" width="274" html.valueishtml="0" name=u_salebill_auditrep_t visible="1" font.face="宋体" font.height="-10" font.weight="700" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="1073741824" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
- text(band=header alignment="2" text="币种" border="2" color="0" x="2482" y="204" height="60" width="320" html.valueishtml="0" name=cw_currency_currencyname_t visible="1" font.face="宋体" font.height="-10" font.weight="700" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="1073741824" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
- text(band=header alignment="2" text="建立类型" border="2" color="33554432" x="5746" y="204" height="60" width="288" html.valueishtml="0" name=u_salebill_buildtype_t visible="1" font.face="宋体" font.height="-10" font.weight="700" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="1073741824" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
- text(band=header alignment="2" text="相关凭证号" border="2" color="33554432" x="6043" y="204" height="60" width="411" html.valueishtml="0" name=u_salebillmx_relbillcode_t visible="1" font.face="宋体" font.height="-10" font.weight="700" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="1073741824" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
- text(band=header alignment="2" text="已收金额" border="2" color="33554432" x="6464" y="204" height="60" width="325" html.valueishtml="0" name=u_salebillmx_maintakeamt_t visible="1" font.face="宋体" font.height="-10" font.weight="700" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="1073741824" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
- text(band=header alignment="2" text="应收金额" border="2" color="33554432" x="6798" y="204" height="60" width="357" html.valueishtml="0" name=u_salebillmx_mainmsttakeamt_t visible="1" font.face="宋体" font.height="-10" font.weight="700" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="1073741824" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
- text(band=header alignment="2" text="单据金额" border="2" color="33554432" x="7163" y="204" height="60" width="338" html.valueishtml="0" name=u_salebillmx_oriamt_t visible="1" font.face="宋体" font.height="-10" font.weight="700" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="1073741824" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
- text(band=header alignment="2" text="本次已收" border="2" color="33554432" x="7511" y="204" height="60" width="370" html.valueishtml="0" name=u_salebillmx_takeamt_t visible="1" font.face="宋体" font.height="-10" font.weight="700" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="1073741824" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
- text(band=header alignment="2" text="本次附加应收" border="2" color="33554432" x="7890" y="204" height="60" width="489" html.valueishtml="0" name=u_salebillmx_msttakeamt_t visible="1" font.face="宋体" font.height="-10" font.weight="700" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="1073741824" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
- column(band=detail id=13 alignment="0" tabsequence=32766 border="0" color="0~tif( u_salebill_flag =1,rgb(0,0,0),rgb(255,0,0))" x="9" y="4" height="68" width="352" format="[general]" html.valueishtml="0" name=u_salebill_salebillcode tag="单号" visible="1" edit.limit=20 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="1073741824" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
- column(band=detail id=8 alignment="0" tabsequence=32766 border="0" color="0~tif( u_salebill_flag =1,rgb(0,0,0),rgb(255,0,0))" x="370" y="4" height="68" width="411" format="[general]" html.valueishtml="0" name=u_salebill_relcode tag="相关号码" visible="1" edit.limit=30 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="1073741824" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
- column(band=detail id=2 alignment="0" tabsequence=32766 border="0" color="0~tif( u_salebill_flag =1,rgb(0,0,0),rgb(255,0,0))" x="1120" y="4" height="68" width="334" format="[general]" html.valueishtml="0" name=u_cust_cuscode tag="客户编号" visible="1" edit.limit=20 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="1073741824" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
- column(band=detail id=19 alignment="0" tabsequence=32766 border="0" color="0~tif( u_salebill_flag =1,rgb(0,0,0),rgb(255,0,0))" x="1463" y="4" height="68" width="745" format="[general]" html.valueishtml="0" name=u_cust_name tag="客户名称" visible="1" edit.limit=50 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="1073741824" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
- column(band=detail id=7 alignment="2" tabsequence=32766 border="0" color="0~tif( u_salebill_flag =1,rgb(0,0,0),rgb(255,0,0))" x="791" y="4" height="68" width="320" format="yyyy-mm-dd" html.valueishtml="0" name=u_salebill_takedate tag="发生时间" visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="1073741824" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
- column(band=detail id=11 alignment="0" tabsequence=32766 border="0" color="0~tif( u_salebill_flag =1,rgb(0,0,0),rgb(255,0,0))" x="3186" y="4" height="68" width="914" format="[general]" html.valueishtml="0" name=u_salebill_dscrp tag="备注" visible="1" edit.limit=250 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="1073741824" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
- column(band=detail id=14 alignment="0" tabsequence=32766 border="0" color="0~tif( u_salebill_flag =1,rgb(0,0,0),rgb(255,0,0))" x="4110" y="4" height="68" width="471" format="yyyy-mm-dd hh:Mm" html.valueishtml="0" name=u_salebill_opdate tag="建立时间" visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="1073741824" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
- column(band=detail id=15 alignment="0" tabsequence=32766 border="0" color="0~tif( u_salebill_flag =1,rgb(0,0,0),rgb(255,0,0))" x="4590" y="4" height="68" width="256" format="[general]" html.valueishtml="0" name=u_salebill_opemp tag="建立操作员" visible="1" edit.limit=20 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="1073741824" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
- column(band=detail id=18 alignment="2" tabsequence=32766 border="0" color="0~tif( u_salebill_flag =1,rgb(0,0,0),rgb(255,0,0))" x="4855" y="4" height="68" width="133" format="[general]" html.valueishtml="0" name=u_salebill_flag tag="审核标记" visible="1" checkbox.text="" checkbox.on="1" checkbox.off="0" checkbox.scale=no checkbox.threed=yes font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="1073741824" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
- column(band=detail id=16 alignment="0" tabsequence=32766 border="0" color="0~tif( u_salebill_flag =1,rgb(0,0,0),rgb(255,0,0))" x="4997" y="4" height="68" width="457" format="yyyy-mm-dd hh:Mm" html.valueishtml="0" name=u_salebill_auditdate tag="审核时间" visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="1073741824" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
- column(band=detail id=9 alignment="0" tabsequence=32766 border="0" color="0~tif( u_salebill_flag =1,rgb(0,0,0),rgb(255,0,0))" x="2217" y="4" height="68" width="256" format="[general]" html.valueishtml="0" name=u_salebill_inrep tag="经手人" visible="1" edit.limit=20 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="1073741824" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
- column(band=detail id=3 alignment="0" tabsequence=32766 border="0" color="0" x="2811" y="4" height="68" width="366" format="[general]" html.valueishtml="0" name=u_salebill_billtype visible="1" dddw.name=dddw_salebilltype dddw.displaycolumn=billtype_display dddw.datacolumn=billtype dddw.percentwidth=0 dddw.lines=0 dddw.limit=0 dddw.allowedit=no dddw.useasborder=no dddw.case=any font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="1073741824" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
- column(band=detail id=17 alignment="0" tabsequence=32766 border="0" color="0~tif( u_salebill_flag =1,rgb(0,0,0),rgb(255,0,0))" x="5463" y="4" height="68" width="274" format="[general]" html.valueishtml="0" name=u_salebill_auditrep tag="审核人" visible="1" edit.limit=20 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="1073741824" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
- column(band=detail id=22 alignment="2" tabsequence=32766 border="0" color="0" x="2482" y="4" height="68" width="320" format="[general]" html.valueishtml="0" name=cw_currency_currencyname visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=no font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="1073741824" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
- column(band=detail id=21 alignment="2" tabsequence=32766 border="0" color="0" x="5746" y="4" height="68" width="288" format="[general]" html.valueishtml="0" name=u_salebill_buildtype visible="1" dddw.name=ddd_buildtype dddw.displaycolumn=buildtype_display dddw.datacolumn=buildtype dddw.percentwidth=0 dddw.lines=0 dddw.limit=0 dddw.allowedit=no dddw.useasborder=no dddw.case=any font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="1073741824" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
- column(band=detail id=23 alignment="0" tabsequence=32766 border="0" color="0" x="6043" y="4" height="68" width="411" format="[general]" html.valueishtml="0" name=u_salebillmx_relbillcode visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=no font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="1073741824" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
- column(band=detail id=24 alignment="1" tabsequence=32766 border="0" color="0" x="6464" y="4" height="68" width="325" format="#,##0.##" html.valueishtml="0" name=u_salebillmx_maintakeamt visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=no font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="1073741824" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
- column(band=detail id=25 alignment="1" tabsequence=32766 border="0" color="0" x="6798" y="4" height="68" width="357" format="#,##0.##" html.valueishtml="0" name=u_salebillmx_mainmsttakeamt visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=no font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="1073741824" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
- column(band=detail id=29 alignment="1" tabsequence=32766 border="0" color="0" x="7163" y="4" height="68" width="338" format="#,##0.##" html.valueishtml="0" name=u_salebillmx_oriamt visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=no font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="1073741824" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
- column(band=detail id=27 alignment="1" tabsequence=32766 border="0" color="0" x="7511" y="4" height="68" width="370" format="#,##0.##" html.valueishtml="0" name=u_salebillmx_takeamt visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=no font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="1073741824" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
- column(band=detail id=28 alignment="1" tabsequence=32766 border="0" color="0" x="7890" y="4" height="68" width="489" format="#,##0.##" html.valueishtml="0" name=u_salebillmx_msttakeamt visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=no font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="1073741824" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
- text(band=summary alignment="2" text="小计:" border="0" color="16711680" x="791" y="8" height="56" width="320" html.valueishtml="0" name=t_1 visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="1073741824" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
- compute(band=summary alignment="1" expression="sum( u_salebillmx_maintakeamt for group 1)"border="0" color="16711680" x="6464" y="4" height="56" width="325" format="#,##0.##" html.valueishtml="0" name=compute_2 visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="1073741824" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
- compute(band=summary alignment="1" expression="sum( u_salebillmx_mainmsttakeamt for group 1)"border="0" color="16711680" x="6798" y="4" height="56" width="357" format="#,##0.##" html.valueishtml="0" name=compute_3 visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="1073741824" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
- compute(band=summary alignment="1" expression="sum( u_salebillmx_oriamt for group 1)"border="0" color="16711680" x="7163" y="4" height="56" width="338" format="#,##0.##" html.valueishtml="0" name=compute_4 visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="1073741824" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
- compute(band=summary alignment="1" expression="sum( u_salebillmx_takeamt for group 1)"border="0" color="16711680" x="7511" y="4" height="56" width="370" format="#,##0.##" html.valueishtml="0" name=compute_5 visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="1073741824" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
- compute(band=summary alignment="1" expression="sum( u_salebillmx_msttakeamt for group 1)"border="0" color="16711680" x="7890" y="4" height="56" width="489" format="#,##0.##" html.valueishtml="0" name=compute_6 visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="1073741824" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
- compute(band=footer alignment="2" expression="count(u_salebill_salebillcode for all)"border="0" color="16711680" x="9" y="4" height="56" width="352" format="[general]" html.valueishtml="0" name=compute_1 visible="1" font.face="宋体" font.height="-9" font.weight="700" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="1073741824" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
- text(band=footer alignment="2" text="合计:" border="0" color="16711680" x="791" y="4" height="56" width="320" html.valueishtml="0" name=t_2 visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="1073741824" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
- compute(band=footer alignment="1" expression="sum( u_salebillmx_maintakeamt for all)"border="0" color="16711680" x="6464" y="4" height="56" width="325" format="#,##0.##" html.valueishtml="0" name=compute_7 visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="1073741824" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
- compute(band=footer alignment="1" expression="sum( u_salebillmx_mainmsttakeamt for all)"border="0" color="16711680" x="6798" y="4" height="56" width="357" format="#,##0.##" html.valueishtml="0" name=compute_8 visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="1073741824" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
- compute(band=footer alignment="1" expression="sum( u_salebillmx_oriamt for all)"border="0" color="16711680" x="7163" y="4" height="56" width="338" format="#,##0.##" html.valueishtml="0" name=compute_9 visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="1073741824" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
- compute(band=footer alignment="1" expression="sum( u_salebillmx_takeamt for all)"border="0" color="16711680" x="7511" y="4" height="56" width="370" format="#,##0.##" html.valueishtml="0" name=compute_10 visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="1073741824" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
- compute(band=footer alignment="1" expression="sum( u_salebillmx_msttakeamt for all)"border="0" color="16711680" x="7890" y="4" height="56" width="489" format="#,##0.##" html.valueishtml="0" name=compute_11 visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="1073741824" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
- text(band=foreground alignment="0" text="" border="0" color="33554432" x="0" y="0" height="196" width="9042" html.valueishtml="0" name=t_3 visible="1" font.face="Arial" font.height="-12" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="1073741824" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
- text(band=foreground alignment="0" text="销售对数单明细表" border="0" color="33554432" x="5" y="8" height="124" width="1728" html.valueishtml="0" name=t_4 visible="1" font.face="宋体" font.height="-20" font.weight="700" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="1073741824" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
- compute(band=foreground alignment="0" expression="'打印日期: '+string(today(),'yyyy-mm-dd')+' 共 '+string(pageCount())+' 页 第 ' + string(page()) + ' 页'"border="0" color="33554432" x="14" y="132" height="48" width="2450" format="[GENERAL]" html.valueishtml="0" name=compute_12 visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="1073741824" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" )
- sparse(names="u_salebill_salebillcode u_salebill_relcode u_cust_cuscode u_cust_name u_salebill_takedate u_salebill_dscrp u_salebill_opdate u_salebill_opemp u_salebill_flag u_salebill_auditdate u_salebill_inrep u_salebill_billtype u_salebill_auditrep u_salebill_buildtype cw_currency_currencyname")htmltable(border="1" )
- htmlgen(clientevents="1" clientvalidation="1" clientcomputedfields="1" clientformatting="0" clientscriptable="0" generatejavascript="1" encodeselflinkargs="1" netscapelayers="0" pagingmethod=0 generatedddwframes="1" )
- xhtmlgen() cssgen(sessionspecific="0" )
- xmlgen(inline="0" )
- xsltgen()
- jsgen()
- export.xml(headgroups="1" includewhitespace="0" metadatatype=0 savemetadata=0 template=(comment="" encoding="gb2312" name="1" xml="<?xml version=~"1.0~" encoding=~"gb2312~" standalone=~"no~"?><dw_rp_salebill><dw_rp_salebill_row __pbband=~"detail~"><u_salebill_salebillid>u_salebill_salebillid</u_salebill_salebillid><u_cust_cuscode>u_cust_cuscode</u_cust_cuscode><u_salebill_billtype>u_salebill_billtype</u_salebill_billtype><u_salebill_moneyid>u_salebill_moneyid</u_salebill_moneyid><u_salebill_accountsid>u_salebill_accountsid</u_salebill_accountsid><u_salebill_itemid>u_salebill_itemid</u_salebill_itemid><u_salebill_takedate>u_salebill_takedate</u_salebill_takedate><u_salebill_relcode>u_salebill_relcode</u_salebill_relcode><u_salebill_inrep>u_salebill_inrep</u_salebill_inrep><u_salebill_banktypeid>u_salebill_banktypeid</u_salebill_banktypeid><u_salebill_msttakeamt/><u_salebill_takeamt/><u_salebill_dscrp>u_salebill_dscrp</u_salebill_dscrp><u_salebill_cusid>u_salebill_cusid</u_salebill_cusid><u_salebill_salebillcode>u_salebill_salebillcode</u_salebill_salebillcode><u_salebill_opdate>u_salebill_opdate</u_salebill_opdate><u_salebill_opemp>u_salebill_opemp</u_salebill_opemp><u_salebill_auditdate>u_salebill_auditdate</u_salebill_auditdate><u_salebill_auditrep>u_salebill_auditrep</u_salebill_auditrep><u_salebill_flag>u_salebill_flag</u_salebill_flag><u_cust_name>u_cust_name</u_cust_name><u_salebill_ywrepid>u_salebill_ywrepid</u_salebill_ywrepid><u_salebill_buildtype>u_salebill_buildtype</u_salebill_buildtype><cw_currency_currencyname>cw_currency_currencyname</cw_currency_currencyname></dw_rp_salebill_row></dw_rp_salebill>"))
- import.xml()
- export.pdf(method=0 distill.custompostscript="0" xslfop.print="0" )
- export.xhtml()
-
|