...aseunitid,ISNULL(tv.FSECUNITID,TS.FAUXUNITID)fsecunitid,ISNULL(tv.fbaseqty,0.00)fbaseqty,CASEWHENTS.FSTOREURNUM=0.0THEN0.00ELSECAST(((ISNULL(tv.fbaseqty,0.00)*TS.FSTOREURNOM)/TS.FSTOREURNUM)ASNUMERIC(23,10))ENDfqty,ISNULL(tv.fsecqty,0.00)fsecqty,ISNULL(tv.fbaseavbqty,0.00)fbaseavbqty,SA.FSAFESTOCKfs...
时间:2024-09-07 13:33栏目:K3 Cloud
...aseunitid,ISNULL(tv.FSECUNITID,TS.FAUXUNITID)fsecunitid,ISNULL(tv.fbaseqty,0.00)fbaseqty,CASEWHENTS.FSTOREURNUM=0.0THEN0.00ELSECAST(((ISNULL(tv.fbaseqty,0.00)*TS.FSTOREURNOM)/TS.FSTOREURNUM)ASNUMERIC(23,10))ENDfqty,ISNULL(tv.fsecqty,0.00)fsecqty,ISNULL(tv.fbaseavbqty,0.00)fbaseavbqty,SA.FSAFESTOCKfs...
时间:2024-09-08 04:09栏目:K3 Cloud
...为：2009-03-01到2009-03-02，如下：SQL1:selectFB.KSBM_CLFB_KSBM_CL,0.0jfshlje,0.0jfybje,0.0jffbje,0.0jfbbje,0.0dfshlje,0.0dfybje,0.0dffbje,0.0dfbbje,sum(fb.fx*fb.shlye)qcshlye,sum(fb.fx*fb.ybye)qcybye,sum(fb.fx*fb.fbye)qcfbye,sum(fb.fx*fb.bbye)qcbbyefromarap_djzbzbinnerjoinarap_djfbfbonzb.vouc...
时间:2024-05-01 16:00栏目:NC/NCCloud
...free4,vfree5,vfree6,vfree7,vfree8,vfree9,vfree10,coalesce(sum(ninspacenum),0.0)-coalesce(sum(noutspacenum),0.0)asnspacenum,coalesce(sum(ninspaceassistnum),0.0)-coalesce(sum(noutspaceassistnum),0.0)asnspaceassistnum,sum(coalesce(ningrossnum,0.0)-coalesce(noutgrossnum,0.0))asngrossnumfrom(SELECTa.pk_c...
时间:2024-04-28 22:05栏目:NC/NCCloud
...度:0.13以请假的长度:0.13以请假的长度:0.13以请假的长度:0.0以请假的长度:0.0以请假的长度:0.0以请假的长度:0.0以请假的长度:1.0以请假的长度:1.0以请假的长度:0.0以请假的长度:0.0
时间:2024-09-09 12:08栏目:EAS Cloud
...中选择字段的别名。java.math.BigDecimalye=newjava.math.BigDecimal(0.0);ds.first();while(ds.inBounds()){java.math.BigDecimaljf=ds.getBigDecimal("AA");java.math.BigDecimaldf=ds.getBigDecimal("BB");ye=ye.add(jf).subtract(df);ds.setBigDecimal("CC",ye);ds.next();}setDataSet(ds);折行合计，根...
时间:2024-05-02 13:53栏目:NC/NCCloud
...if($bodyfk.fdatagetflag@=3,iif($bodyfk.fpricemodeflag@=5,$bodyfk.nvarymny@,0.0),0.0)销售成本：分录二公式：iif($bodyfk.vsrctype@=="32",iif($fintransitflag@==0,0,$bodyfk.nmny@),0)物料:分录三公式：iif($bodyfk.vsrctype@=="32",iif($fintransitflag@==-1,$bodyfk.nmny@,0),0)物料：分录...
时间:2024-04-28 04:54栏目:NC/NCCloud
...假的长度以请假的长度:1.0以请假的长度:1.0以请假的长度:0.0以请假的长度:0.0
时间:2024-09-08 22:18栏目:EAS Cloud
...询中选择字段的别名java.math.BigDecimalye=newjava.math.BigDecimal(0.0);ds.first();while(ds.inBounds()){java.math.BigDecimaljf=ds.getBigDecimal("AA");java.math.BigDecimaldf=ds.getBigDecimal("BB");ye=ye.add(jf).subtract(df);ds.setBigDecimal("CC",ye);ds.next();}setDataSet(ds);CC=CC+AA-BB查询...
时间:2024-05-07 13:36栏目:NC/NCCloud
...1应交增值税（进项税）的取值公式为：iif($bestimateflag@==Y,0.0,getcolvalue("po_invoice_b","ntax","pk_invoice_b",getcolvalue("po_settlebill_b","pk_invoice_b","pk_settlebill_b",$bodyfk.csrcbid@)))另外，材料采购科目贷方公式内也要加上此公式（即在原公式基础上...
时间:2024-04-26 17:30栏目:NC/NCCloud
