采购发票.docx

1、采购发票SELECT sbalno, lineid, srcvno, srtnno, invno, pinvno, rinvno, rpinvno, um_conv, msunit, curstyle, exgrate, itemno, batchno, balqty, ranks, fc_invbalsum, invbalsum, fc_tempsum, tempsum, taxrate, hlshqty, uhlshqty, fc_uhlshsum, uhlshsum, def_num1, def_num2, def_num3, def_num4, def_str1, def_str2,

2、def_str3, def_str4, def_date1, def_date2, def_int1, def_int2, def_int3, def_int4, msunit_a, qty_a, hlshqty_a, uhlshqty_a, tr_projFROM baldetWHERE (srcvno = 1012020233)存放采购发票的表头balmst，表体baldetsrcvno是入库单通知编号update billbody set crossflg=1, balqty=10200.000000, balsum=2737.68 where transid =1012020233 a

3、nd lineid=3billbody表中crossflg对账标志balqty对账数量balsum对账金额transid流水号lineid 序号（行数，有多少条物料编码（数据）的意思）这里有三个编码对三个编码分别做了一个修改的动作不过系统只认定最后一个发票号。SELECT sbalno, lineid, srcvno, srtnno, invno, pinvno, rinvno, rpinvno, um_conv, msunit, curstyle, exgrate, itemno, batchno, balqty, ranks, fc_invbalsum, invbalsum, fc_tem

4、psum, tempsum, taxrate, hlshqty, uhlshqty, fc_uhlshsum, uhlshsum, def_num1, def_num2, def_num3, def_num4, def_str1, def_str2, def_str3, def_str4, def_date1, def_date2, def_int1, def_int2, def_int3, def_int4, msunit_a, qty_a, hlshqty_a, uhlshqty_a, tr_projFROM baldetWHERE (srcvno = 1012020233)SELECT

5、sbalno, lineid, srcvno, srtnno, invno, pinvno, rinvno, rpinvno, um_conv, msunit, curstyle, exgrate, itemno, batchno, balqty, ranks, fc_invbalsum, invbalsum, fc_tempsum, tempsum, taxrate, hlshqty, uhlshqty, fc_uhlshsum, uhlshsum, def_num1, def_num2, def_num3, def_num4, def_str1, def_str2, def_str3, d

6、ef_str4, def_date1, def_date2, def_int1, def_int2, def_int3, def_int4, msunit_a, qty_a, hlshqty_a, uhlshqty_a, tr_projFROM baldetWHERE (invno = 1012090001)这里没有记录显示可以得出：一个入库单号，只有一个发票号有效。不过却能在invdet这个表中查到SELECT invno, lineid, itemno, msunit, invqty, invprc, invsum, taxrate, taxsum, prctaxsum, remarks,

7、 curstyle, exgrate, def_int1, def_int2, def_date1, def_date2, def_str1, def_str2, def_str3, def_num1, def_num2, def_num3, def_num4, def_num5, fc_invsum, fc_taxsum, fc_prctaxsum, transum, otrsum, fc_transum, fc_otrsum, crossflg, um_conv, crossqty, fc_crosssum, crosssum, hlshqty, uhlshqty, fc_uhlshsum

8、, uhlshsum, ranks, def_int3, def_int4, def_str4, msunit_a, qty_a, crossqty_a, hlshqty_a, uhlshqty_a, tr_proj, fc_hlshsum, hlshsum, concode, conlineid, conplanno, reltype, purno, inv_feeFROM invdetWHERE (invno = M1012090001)SELECT invno, pinvno, invdt, purno, correl_no, invtype, invstatus, invcomp, v

9、ndcomp, bank, accountno, payway, taxno, deptno, empno, transum, cavsum, cavflg, paysum, otrsum, remarks, prctaxsum, taxsum, untaxsum, fillpsn, checkpsn, checkflg, vcrflg, vcrno, crossflg, iscancell, cclpsn, concflag, def_int1, def_int2, def_int3, def_int4, def_date1, def_date2, def_str1, def_str2, d

10、ef_str3, def_str4, def_num1, def_num2, def_num3, def_num4, fc_transum, fc_cavsum, fc_paysum, fc_otrsum, fc_prctaxsum, fc_taxsum, fc_untaxsum, fc_cavflg, curstyle, exgrate, transkm, otherkm, vcrtype, vcrdt, fc_discsum, discsum, exapsn, exaflg, purcharge, fc_crosssum, crosssum, fc_uhlshsum, uhlshsum,

11、invflg, taxrate, jsflflg, isdetail, taxtype, fintype, tr_proj, fc_hlshsum, hlshsum, comptemp_id, ocode, petitionflag, petition_sum, backfee_flgFROM invmstWHERE (invno = M1012090001)在invmst这张表中也能查找的到对账标志显示的是0新的入库单号SELECT crossflg, balqty, balsum, transid, lineid, billno, itemno, ranks, goodsname, whl

12、ocation, batchno, qty, useqty, simqty, prc, mony, tax, tranmony, othmony, plnmony, usemony, simmony, remarks, relrow, refbill, refrow, actiflg, def_num1, def_num2, def_num3, def_num4, def_num5, def_num6, def_num7, def_num8, def_num9, def_num10, def_str1, def_str2, def_str3, def_date1, def_date2, def

13、_int1, def_int2, msunit, um_conv, exes1, exes2, exes3, exes4, exes5, exes6, exes7, exes8, exes9, exes10, exes11, exes12, useexes1, useexes2, useexes3, useexes4, useexes5, useexes6, useexes7, useexes8, useexes9, useexes10, useexes11, useexes12, def_int3, def_int4, msunit_a, qty_a, itemcode, objectno,

14、 costbatchno, centerno, balqty AS Expr2, balsum AS Expr3, hlshsum, hlshqty, crossflg AS Expr1, tr_proj, concode, conlineid, po_cavsum, fc_po_cavsum, po_cavflg, joinbill, joinrow, waterlate, chklate, avgchklate, thisprc, ac_outid, petition_flag, srecno, srecrow, dacode, reltype, relno, relno2, relrow

15、2, um_conv_a, um_conv_am, petition_code, ina_balqty, sortid, attrvalid, relno3, petition_sumFROM billbodyWHERE (transid = 1012030073)现在开始做发票对账现在没有了找不到1012030073这张单据了继续测试对账，开发票前再次查询billbody这张表已经对账完毕找不到了这些都是发票没有开成功的，也就是只有发票号，没有成功对账的。SELECT crossflg, balqty, balsum, *FROM billbodyWHERE (crossflg = 0)ORDER BY transid总的结论没有能对上帐没有跟billbody表中的对上解决方案，如果还出现自己做过的单的流水号，则自己手动对下然后再查看让我执行下面的代码检查SELECT crossflg, balqty, balsum, transid, lineid, billno, itemnoFROM billbodyWHERE (crossflg = 0)ORDER BY transid