Several relationships of inventories

xiaoxiao2021-03-06  43

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 ???

转载请注明原文地址:https://www.9cbs.com/read-74824.html

New Post(0)