## **U8 数据库表** zpurpoheader 采购订单 主视图 zpurpotail 采购订单子表视图 pu_ArrHead 采购到货单主表视图 PU_ArrivalVouch 采购到货单主表： > cpocode 采购订单号 > PU_ArrivalVouchs 采购到货单子表： > cordercode 采购订单号 > isourcemocode srm的送货条码 rdrecord01 采购入库单主表： > cARVCode 到货单号 > cOrderCode 采购订单号 > rdrecords01 采购入库单子表： > iPOsID 采购订单子表id ## **CPS 数据库表** INV_PO_D 采购订单子表 INV_PO_H 采购订单主表 ## **采购到货** WmsReceiptBll.cs ：采购到货管理类，JuQent.CPS.ExportU8Job U8Service.cs 中 TableName：POGenStockIn CPS Job 接口：/api/services/Jobs/edi/asnReceive （ IEdiAppService.cs 中的 AsnReceive） ~~~ u8ApiDtBody = ReceiptBll.GetU8ApiDtBody(cpsContext, submitMain,TimeZone, U8Type.Po); ComitU8(jobException, ref insertCount, ref exceptionCount, cpsContext, submitMain, dtLogin, u8ApiDtBody); ~~~ ## **到货单生成采购入库单** WmsInstockBll.cs :采购入库管理类，JuQent.CPS.ExportU8Job U8Service.cs 中 TableName：MatStockInCheck CPS Job 接口：/api/services/Jobs/edi/PurchaseReceive （ IEdiAppService.cs 中的 PurchaseReceive ） ## **SQL** 根据采购订单查到货单主表 ``` select b.isourcemocode,b.*,a.* from PU_ArrivalVouch a inner join PU_ArrivalVouchs b on a.id=b.id where b.cordercode= 'POB2010140019' order by ddate desc ``` 根据采购订单查到货单子表 ``` select * FROM [PU_ArrivalVouchs] where cordercode in ('POA2010090027') order by id desc ``` 采购订单查询 ``` select * from PO_Podetails left join po_pomain on PO_Podetails.poid = po_pomain.POID where po_pomain.cpoid = 'POB2010140019'; ``` 来料质检 ``` select top 100 * from QMCheckproject order by id desc; select top 100 * from QMCheckprojects order by id desc; ```