StockbillBody Demand Table Billcode -> CheckbillBody -> Billcode
// id relations warehouse processes in select id, ownerid, name, flowid from partinfo - commodity information table goselect billcode, partname, flowid, onlyid, partid from orderbillbody - Material Request Form goselect * from orderbillhandgoselect billcode, partname, flowid, onlyid, partid, orderid from stockbillbody - material procurement table goselect * from stockbillhandgoselect billcode, partname, flowid, onlyid, stockid, partinid, partid from checkbillbody - supplies of goods seized table goselect billcode, partname, flowid, onlyid, partid, orderid from partsinputbody - storage show fine goselect billcode, onlyid, flowid from partsinputhand-- storage form according to goselect billcode, partname, flowid, onlyid, partid, orderid from partsoutputbody - indicates that the library fine goselect billcode, flowid from partsoutputhand-- out Library form
-OrderbillBody, StockbillBody, CHECKBILLBODY PartsNPutBody, Parts in PartsoutBody is associated with the ID in Partinfo.
--orderbillbody.billcode = stockbillbody.billcode = checkbillbody.billcode - orderbillbody.onlyid = stockbillbody.onlyid = checkbillbody.onlyid - orderbillbody.flowid = stockbillbody.flowid = checkbillbody.flowid - orderbillbody.onlyid = stockbillbody.orderid = checkbillbody .stockid
--orderbillbody.billcode = orderbillhand.billcode; orderbillbody.flowid = orderbillhand.flowid - stockbillbody.flowid = stockbillhand.flowid stockbillbody.billcode <> stockbillhand.billcode ???