采购发票

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,

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_proj

FROM

baldet

WHERE

(srcvno = '1012020233')

存放采购发票的表头

balmst

，表体

baldet

srcvno

是入库单通知编号

update

billbody

set

crossflg='1',

balqty=10200.000000,

balsum=2737.68

where

transid

='1012020233' and lineid=3

billbody

表中

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_tempsum,

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_proj

FROM

baldet

WHERE

(srcvno = '1012020233')

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,

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_proj

FROM

baldet

WHERE

(invno = ' 1012090001')

这里没有记录显示

可以得出：一个入库单号，只有一个发票号有效。

invdet

这个表中查到

SELECT

invno, lineid, itemno, msunit, invqty, invprc, invsum, taxrate, taxsum, prctaxsum,

remarks, 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, 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_fee

FROM

invdet

WHERE

(invno = 'M1012090001')

SELECT

invno,

pinvno,

invdt,

purno,

correl_no,

invtype,

invstatus,

invcomp,

vndcomp,

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, def_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, invflg, taxrate, jsflflg, isdetail, taxtype, fintype,

tr_proj,

fc_hlshsum,

hlshsum,

comptemp_id,

ocode,

petitionflag,

petition_sum, backfee_flg

FROM

invmst

WHERE

(invno = 'M1012090001')

在

invmst

这张表中也能查找的到

对账标志显示的是

0

新的入库单号

SELECT

crossflg,

balqty,

balsum,

transid,

lineid,

billno,

itemno,

ranks,

goodsname,

whlocation, 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_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, 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, relrow2, um_conv_a,

um_conv_am,

petition_code,

ina_balqty,

sortid,

attrvalid,

relno3,

petition_sum

FROM

billbody

WHERE

(transid = '1012030073')

现在开始做发票对账

现在没有了找不到

10120300 73

这张单据了