2022年药易通数据库结构 .pdf

上传人:H****o 文档编号:40218771 上传时间:2022-09-08 格式:PDF 页数:23 大小:387.64KB
返回 下载 相关 举报
2022年药易通数据库结构 .pdf_第1页
第1页 / 共23页
2022年药易通数据库结构 .pdf_第2页
第2页 / 共23页
点击查看更多>>
资源描述

《2022年药易通数据库结构 .pdf》由会员分享,可在线阅读,更多相关《2022年药易通数据库结构 .pdf(23页珍藏版)》请在taowenge.com淘文阁网|工程机械CAD图纸|机械工程制图|CAD装配图下载|SolidWorks_CaTia_CAD_UG_PROE_设计图分享下载上搜索。

1、数据结构一、基本信息数据结构1、商品基本资料数据结构barcodePKbarcode_idI1p_idI1barcodeproductsPK,I5product_idI5,I4class_idI3,I7parent_idI7,I6child_numberchild_countserial_numberI1namealiasstandardmodalpermitcodetrademarkmakeareaunit1_idunit2_idunit3_idunit4_idrate2rate3rate4validmonthvaliddaycommentdeletedI2pinyinfirstcheckv

2、alidcheckotcflaggspflagmedtypecostmethodEngNameChemNameLatinNamemedtypePKmt_idmt_codemt_namedeletedunitPKunit_idnamedeletedpricePKprice_idI1p_idI1u_idretailpricerecpriceprice1price2price3price4gppriceglpricespecialpriceunittypelowprice说明:Products 商品信息表Barcode 一品多码表Unit 商品单位表Price 价格表MedType 剂型表名师资料总

3、结-精品资料欢迎下载-名师精心整理-第 1 页,共 23 页 -2、往来单位基本信息clientsPKclient_idI4class_idparent_idchild_numberchild_countI1serial_numberI2namealiasregion_idphone_numberaddresszipcodecontact_personaltax_numberacount_numbercredit_totalI3pinyinpricemodesklimitartotalartotal_iniaptotalaptotal_inipre_artotalpre_artotal_ini

4、pre_aptotalpre_aptotal_inifirstcheckcommentcsflagdeletedProtocolDateRegionPKregion_idI1serial_numbernamecommentdeleted说明:Clients 往来单位信息库Region 片区信息3、仓库基本信息名师资料总结-精品资料欢迎下载-名师精心整理-第 2 页,共 23 页 -storagesPKstorage_idI3class_idparent_idchild_numberchild_countnamealiasI1serial_numberCommentflagI2PinYindel

5、etedlocationPKloc_ids_idloc_codeloc_nameloc_commentdeleted说明:Storages 仓库信息库Location 货位信息库4、职员信息库employeesPKemp_idI2class_idparent_idchild_numberchild_countnamealiasserial_numberdep_idphoneaddresscommentaplimitarlimitaptotalartotaldiscountlimitlsthI1pinyindeletedLowPriceHighPriceSNCountGSPSNCountdepa

6、rtmentPKdepartmentIdserial_numbernamecommentdeleted说明:employees 职员信息库department 部门信息库5、科目信息库名师资料总结-精品资料欢迎下载-名师精心整理-第 3 页,共 23 页 -accountPKaccount_idI1class_idparent_idchild_numberchild_countnamealiasI2serial_numberCommentcur_totalini_totalsysflagsysrowdeletedI3PinYintotal_01total_02total_03total_04t

7、otal_05total_06total_07total_08total_09total_10total_11total_12bqtotalsumtotalcashauditdirectionAccountCommentPKCommIDAccountCommentCode说明:account 科目信息库AccountComment 科目备注信息库6、会员卡信息名师资料总结-精品资料欢迎下载-名师精心整理-第 4 页,共 23 页 -cardtypePKCTypeIdTypeNameDiscountCommentAutoDiscountcardtotalPKIDcardidtotalcarddi

8、scountPKcd_idAutoIDbegintotalendtotaldiscountcommentmembercardPKCardIDI1CardNoNameTelAddressCommentCardTypeDiscountBulidDateValidityDateLoseStopUseBuyTotalBuyTotalPerDayAutoDiscountIDCardIntegralBrithdayDiscountType说明:Cardtype 会员卡类型表Membercard 会员卡表CardDiscount 会员卡折扣类型CardTotal 会员卡消费金额7、门店信息表ShopPosI

9、DPosCodePosNameS_IDC_IDRemotePathCommentdeleted二、单据类数据结构1、销售类单据名师资料总结-精品资料欢迎下载-名师精心整理-第 5 页,共 23 页 -billdraftidxPKbillidbilldatebillnumberbilltypea_idc_ide_idsout_idsin_idauditmaninputmanysmoneyssmoneyquantitytaxrateperiodbillstatesorder_iddepartment_idposidregion_idauditdateskdatejsyejsflagnotesumm

10、aryinvoicetranscountlasttranstimesalemanagebilldrfPKsmb_idbill_idp_idbatchnoquantitycostpricesalepricediscountdiscountpricetotalmoneytaxpricetaxtotaltaxmoneyretailpriceretailtotalmakedatevaliddatequalitystatusprice_idss_idsd_idlocation_idsupplier_idcommissionflagcommentunitidtaxrateorder_idtotaliota

11、gbillidxPK,I1billidI1billdatebillnumberI1billtypea_idI1c_idI1e_idsout_idsin_idauditmaninputmanysmoneyssmoneyquantitytaxrateperiodbillstatesorder_iddepartment_idposidregion_idauditdateskdatejsyejsflagnotesummaryinvoicetranscountlasttranstimesalemanagebillPKsmb_idbill_idp_idbatchnoquantitycostpricesal

12、epricediscountdiscountpricetotalmoneytaxpricetaxtotaltaxmoneyretailpriceretailtotalmakedatevaliddatequalitystatusprice_idss_idsd_idlocation_idsupplier_idcommissionflagcommentunitidtaxrateorder_idtotaliotag说明:billdraftidx 单据草稿主表SaleManagebilldrf 销售单据草稿表Billidex 单据主表SaleManageBill 销售单据库2、采购类单据数据结构名师资料

13、总结-精品资料欢迎下载-名师精心整理-第 6 页,共 23 页 -billdraftidxPKbillidbilldatebillnumberbilltypea_idc_ide_idsout_idsin_idauditmaninputmanysmoneyssmoneyquantitytaxrateperiodbillstatesorder_iddepartment_idposidregion_idauditdateskdatejsyejsflagnotesummaryinvoicetranscountlasttranstimebuymanagebilldrfPKsmb_idbill_idp_i

14、dbatchnoquantitycostpricebuypricediscountdiscountpricetotalmoneytaxpricetaxtotaltaxmoneyretailpriceretailtotalmakedatevaliddatequalitystatusprice_idss_idsd_idlocation_idsupplier_idcommissionflagcommentunitidtaxrateorder_idtotaliotagbillidxPK,I1billidI1billdatebillnumberI1billtypea_idI1c_idI1e_idsout

15、_idsin_idauditmaninputmanysmoneyssmoneyquantitytaxrateperiodbillstatesorder_iddepartment_idposidregion_idauditdateskdatejsyejsflagnotesummaryinvoicetranscountlasttranstimebuymanagebillPK smb_idbill_idp_idbatchnoquantitycostpricebuypricediscountdiscountpricetotalmoneytaxpricetaxtotaltaxmoneyretailpri

16、ceretailtotalmakedatevaliddatequalitystatusprice_idss_idsd_idlocation_idsupplier_idcommissionflagcommentunitidtaxrateorder_idtotaliotag说明:Billdraftidx 单据草稿主表BuyManagebilldrf 采购单据草稿表Billidx 单据主表BuyManageBilldrf 采购单据表3、库存类单据数据结构名师资料总结-精品资料欢迎下载-名师精心整理-第 7 页,共 23 页 -billidxPK,I1billidI1billdatebillnumbe

17、rI1billtypea_idI1c_idI1e_idsout_idsin_idauditmaninputmanysmoneyssmoneyquantitytaxrateperiodbillstatesorder_iddepartment_idposidregion_idauditdateskdatejsyejsflagnotesummaryinvoicetranscountlasttranstimebilldraftidxPKbillidbilldatebillnumberbilltypea_idc_ide_idsout_idsin_idauditmaninputmanysmoneyssmo

18、neyquantitytaxrateperiodbillstatesorder_iddepartment_idposidregion_idauditdateskdatejsyejsflagnotesummaryinvoicetranscountlasttranstimestoremanagebilldrfPKsmb_idbill_idp_idbatchnoquantitypricetotalmoneycostpricecosttotalretailpriceretailmoneymakedatevaliddatequalitystatusprice_idss_idsd_idlocation_i

19、dsupplier_idcommissionflagcommentunitidlocation_id2iotagtotalstoremanagebillPKsmb_idbill_idp_idbatchnoquantitypricetotalmoneycostpricecosttotalretailpriceretailmoneymakedatevaliddatequalitystatusprice_idss_idsd_idlocation_idsupplier_idcommissionflagcommentunitidlocation_id2iotagtotal说明:Billdraftidx

20、单据草稿主表StoreManagebilldrf 库存单据草稿表Billidex 单据主表storeManageBilldrf 库存单据表4、库存盘点单名师资料总结-精品资料欢迎下载-名师精心整理-第 8 页,共 23 页 -billdraftidxPKbillidbilldatebillnumberbilltypea_idc_ide_idsout_idsin_idauditmaninputmanysmoneyssmoneyquantitytaxrateperiodbillstatesorder_iddepartment_idposidregion_idauditdateskdatejsyej

21、sflagnotesummaryinvoicetranscountlasttranstimebillidxPK,I1billidI1billdatebillnumberI1billtypea_idI1c_idI1e_idsout_idsin_idauditmaninputmanysmoneyssmoneyquantitytaxrateperiodbillstatesorder_iddepartment_idposidregion_idauditdateskdatejsyejsflagnotesummaryinvoicetranscountlasttranstimeGoodsCheckBillP

22、Ksmb_idbill_idp_idbatchnoquantitycostpricebuypricediscountdiscountpricetotalmoneytaxpricetaxtotaltaxmoneyretailpriceretailtotalmakedatevaliddatequalitystatusprice_idss_idsd_idlocation_idsupplier_idcommissionflagcommentunitidtaxrateorder_idtotalGoodsCheckBillDrfPKsmb_idbill_idp_idbatchnoquantitycostp

23、ricebuypricediscountdiscountpricetotalmoneytaxpricetaxtotaltaxmoneyretailpriceretailtotalmakedatevaliddatequalitystatusprice_idss_idsd_idlocation_idsupplier_idcommissionflagcommentunitidtaxrateorder_idtotal说明:Billdraftidx 单据草稿主表GoodsCheckbilldrf 库存盘点草稿表Billidex 单据主表GoodsCheckBill 库存盘点表5、零售类单据结构名师资料总

24、结-精品资料欢迎下载-名师精心整理-第 9 页,共 23 页 -retailbillidxPK,I1billidI1billdatebillnumberI1billtypea_idI1c_idI1e_idsout_idsin_idauditmaninputmanysmoneyssmoneyquantitytaxrateperiodbillstatesorder_iddepartment_idposidregion_idauditdateskdatejsyejsflagnotesummaryinvoicetranscountRetailBillPKsmb_idbill_idp_idbatchno

25、quantitycostpricesalepricediscountdiscountpricetotalmoneytaxpricetaxtotaltaxmoneyretailpriceretailtotalmakedatevaliddatequalitystatusprice_idss_idsd_idlocation_idsupplier_idcommissionflagcommentunitidtaxratetotaljkdetailPKjkidjkdatejke_idjkimputmanjkmoneycomment说明:retailbillidx 零售单主表retailBill 零售明细表

26、jkdetail 交款明细6、订单表名师资料总结-精品资料欢迎下载-名师精心整理-第 10 页,共 23 页 -orderidxPK,I1billidI1billdatebillnumberI1billtypea_idI1c_idI1e_idsout_idsin_idauditmaninputmanysmoneyssmoneyquantitytaxrateperiodbillstatesorder_iddepartment_idposidregion_idauditdateskdatejsyejsflagnotesummaryinvoiceOrderBillPKsmb_idbill_idp_i

27、dbatchnoquantitycostpricesalepricediscountdiscountpricetotalmoneytaxpricetaxtotaltaxmoneyretailpriceretailtotalmakedatevaliddatequalitystatusprice_idss_idsd_idlocation_idsupplier_idcommissionflagcommentunitidtaxrateComeDateComeQtytotal说明:orderidx 订单主表orderBill 订单明细表7、财务表名师资料总结-精品资料欢迎下载-名师精心整理-第 11 页

28、,共 23 页 -jsbdetailPKjsidc_idskd_bidxsd_bidbilltypejstotalremaintotalflagjspdetailPKjsidc_idskd_bidxsd_bidbilltypequantityjstotaldetail_idyj_quantityflagfinancebillPKsmb_idbill_ida_idc_idjftotaldftotalcomment1comment2comment3financebilldrfPKsmb_idbill_ida_idc_idjftotaldftotalcomment1comment2comment3说

29、明:Finacebilldrf 财务单据草稿表Finacebill 财务类单据表jsbDetail 按单结算表jspdetail 按行结算表三、明细帐名师资料总结-精品资料欢迎下载-名师精心整理-第 12 页,共 23 页 -accountdetailPKsmb_idI1billidI1a_idI1c_idjdmoneyjdflagproductdetailPKpd_idI2,I1billidI2,I1p_idI2,I1s_idI2,I1quantitypriceI1totalcostpriceI2,I1costtotaltaxpriceI1taxtotalbatchnomakedateval

30、iddatecommissionflagsupplier_idlocation_idI2storetypeprice_idorder_idunitidsmb_id说明:Productdetail 库存明细帐表AccountDetail 科目明细帐表四、库存余量1、库存余量storehousePKstorehouse_idlocation_idI3,I1s_idI3,I2,I1p_idsupplier_idI3,I2,I1quantitycostpriceI2,I1costtotalbatchnomakedateinstoretimevaliddatecommissionflagstopsale

31、flaginorderyhdatestorehouseiniPKstorehouseini_idlocation_idI3,I1s_idI3,I2,I1p_idsupplier_idI3,I2,I1quantitycostpriceI2,I1costtotalbatchnomakedateinstoretimevaliddatecommissionflagstopsaleflaginorder说明:StoreHouse 库存余量表Storehouseini 期初库存余量表名师资料总结-精品资料欢迎下载-名师精心整理-第 13 页,共 23 页 -2、代销库存余量storedxPKstoredx

32、_idlocation_idc_idp_idsupplier_idquantitycostpricecosttotalbatchnomakedateinstoretimevaliddatecommissionflagstopsaleflaginorderstoredxiniPKstoredxini_idlocation_idc_idp_idsupplier_idquantitycostpricecosttotalbatchnomakedateinstoretimevaliddatecommissionflagstopsaleflaginorder说明:StoreDX 代销库存余量表Stored

33、xini 期初代销库存余量表五、GSP类表gspauditPKts_idGSP_AuditLimite_idenameGspFlowControlPKFlowIDSourceGspTypeDestGspTypeCommentSysFlaggspPropertGSPSNStylePKIDBillTypeStyleSNCountGspTablePKGspIDGspTypeBillCodeBillEBillDateGspTextcommentCheckStatebatchnoSignGSPVerGspVchTypePKGspidGspTypeNameFormStyleCommentBillToGsp

34、IDBillTypeGSPType说明:GSPSNStyle GSP编号GspAudit GSP签字表GSPVchType GSP单据类型表名师资料总结-精品资料欢迎下载-名师精心整理-第 14 页,共 23 页 -BillToGsp 单据至 GSP流程定义GSPTable GSP报表库表六、其它1、跟踪类表buypricehisPKc_idPKp_idPKunit_idBuyPricesalepricehisPKc_idPKp_idPKunit_idSalePriceLocationTracePKlt_idU1p_idU1s_idU1l_idrectime说明:Locationtrace 货

35、位跟踪SalePriceHis 售价跟踪BuyPriceHis 进价跟踪2、库存上下限StoreLimitPKSLIDI1P_idI1S_idUpperLimitLowLimitAdjQty说明StoreLimit 库存上下限表3、门店物价管理表PosPricePKprice_idpos_idp_idu_idretailpricerecpriceprice1price2price3price4gppriceglpricespecialpriceunittypelowprice4、权限类表名师资料总结-精品资料欢迎下载-名师精心整理-第 15 页,共 23 页 -EmpMsgLimitIDEID

36、BillTypeMSGLIMITTagusersPKuser_ide_idloginpasspermissionuserauthorizePKut_ide_idtypepsc_idparentflagReplicationAuthorizeIDGUIDMemoTag说明ReplicationAuthorize 复制授权表empMsglimit 职员消息权限users 登录用户权限表UserAuthorize 用户授权限表5、用友接口dwdzdw_idc_idserialnumbertypekmdzkm_ida_idserialnumbertypepzoutbilldatepzlbpznumbe

37、rpzfjpzcommentkmcodejfmoneydfmoneygysnumberccode说明dwdz 单位对照表kmdz 科目对照表pzOut 凭证导出表6、消息与日志SystemLogPKIDPKEIDActionTagVchIDActionTypeComputerActionDateCommentMsgHistoryIDComputerSenderEIDActionStrTextReceiveDate说明systemlog 日志表MsgHistory 消息历史记录表7、系统配置名师资料总结-精品资料欢迎下载-名师精心整理-第 16 页,共 23 页 -sysconfigPKsys_

38、idI1sysnamesysvaluecomment说明:值备注OpenAccount 1 启用账套标志CostMethod 3 默认成本核算法AccountPeriod 1 会计期TaxRate 0 默认税率BillCount 80 默认单据行数DBVersion 2003-07-32 版本号RecpriceAsCost 0 使用最近进价为成本价=0 false=1 true NegativeStock 0 负库存开关=0 false=1 true UseSameCostMethod 1 使用统一成本核算法=0 false=1 true UseBuyTrace 0 使用进价跟踪UseSale

39、Trace 1 使用售价跟踪BillSNLex1 1 单据编号规则 1 BillSNLex2 0 单据编号规则 2 BillSNLex3 0 单据编号规则 3 BillSNCount 单据编号记数GSPSNLex1 GSP单据编号规则 1 GSPSNLex2 GSP单据编号规则 2 GSPSNLex3 GSP单据编号规则 3 GSPSNCount GSP单据编号记数CompanyName 公司信息GspFlowControl GSP流程控制BillFlowControl 单据流程控制ShowLastBuyPrice 显示最近进价ShowArAp 显示往来单位应收应付UseClientCredi

40、t 客户信用额度UseEmpCredit 职员信用额度AutoComment 自动备注FLOATFMT 浮点数长度TAXPRICEFMT 税后单价小数点保留位数TOTALFMT 合计小数点保留位数SLFMT 数量小数点保留位数DJFMT 单价小数点保留位数XPMenu 是否使用 XP 风格BillDialog 单据是否采用对话框名师资料总结-精品资料欢迎下载-名师精心整理-第 17 页,共 23 页 -AutoSaveTime 自动存盘时间LoginDate 最后登录日期Posid 门店 ID PosName 门店名称PosCid 门店对应单位PosSid 门店对应仓库SQLVersion 数

41、据库版本ProductType GUID 帐套 ID AutoMessage 自动短消息CountQty PrintSave 单据打印后保存BillSNLex4 单据编号规则/单据类型定义const vtSale=10;/销售单vtSaleBack=11;/销售退货单vtRetail=12;/零售单vtRetailBack=13;/零售退货单vtSaleOrder=14;/销售定单vtGathering=15;/收款单vtSaleAdjust=16;/销售结算调价vtSaleBackAdjust=17;/销售退货结算调价vtBuy=20;/采购单vtBuyBack=21;/采购退货单vtBuy

42、Order=22;/采购定单vtPayment=23;/付款单vtBuyAdjust=24;/采购结算调价vtBuyBackAdjust=25;/采购退货结算调价vtBuyPlan=26;/采购计划vtLend=30;/借出单vtLendBack=31;/借出还回单vtLendSale=32;/借出转销售单vtBorrow=33;/借进单vtBorrowBack=34;/借进还出单vtBorrowBuy=35;/借进转采购单vtProduce=40;/组装单vtLost=41;/报损单vtOverflow=42;/报溢单vtAdjustPrice=43;/成本调价单名师资料总结-精品资料欢迎下

43、载-名师精心整理-第 18 页,共 23 页 -vtTransfer=44;/调拨单vtTransfer_Price=45;/变价调拨单vtGive=46;/赠送单vtGain=47;/获赠单vtInLib=48;/入库单vtOutLib=49;/出库单vtGoodsCheck=50;/库存盘点单vtBatchAdjust=51;/库存批次调整单/vtTranGet=52;/门店请货单vtTranOut=53;/配送出库单vtTranOutBack=54;/配送出库退货单vtTranIn=55;/配送入库单vtTranInBack=56;/配送入库退货单vtTranOOS=57;/门店请货缺货

44、单Out Of Stock/vtCashExpense=60;/现金费用单vtExpense=61;/费用单vtOtherIncome=62;/其它收入单vtMoney=63;/现金转帐单vtAR_Add=64;/应收增加vtAR_Reduce=65;/应收减少vtAP_Add=66;/应付增加vtAP_Reduce=67;/应付减少vtCash_Add=68;/资金增加vtCash_Reduce=69;/资金减少vtFixedBuy=80;/固定资产购置vtFixedSale=81;/固定资产变卖vtFixedDepreciation=82;/固定资产折旧vtExpenseHappen=83

45、;/待摊费用发生vtExpenseAmortize=84;/待摊费用摊销/vtTranPayment=87;/配送付款单vtTranGathering=88;/配送收款单/vtAccount=90;/会计凭证名师资料总结-精品资料欢迎下载-名师精心整理-第 19 页,共 23 页 -vtSendGoods=100;/发货单vtSendBack=101;/发货退货单vtSendSettle=102;/发货结算单vtSendPrice=103;/发货调价单vtCommission=110;/委托代销单vtCommBack=111;/委托代销退货单vtCommSettle=112;/委托代销结算单v

46、tCommPrice=113;/委托代销调价vtReCommission=120;/受托代销单vtReCommBack=121;/受托代销退货单vtReCommSettle=122;/受托代销结算单vtReCommPrice=123;/受托代销调价vtCommRecive=130;/库外入库单vtCommPayment=131;/库外出库单vtPriceAdjust=140;/价格调整单vtIniGoodsRec=141;/期初库存录入单/GSp 单据/GSP 采购进货2200-2220 GSP_BUY_TYPE_CHECK=2200;/【GSP】进货品种审核表GSP_IMPORT_BREED

47、=2201;/【GSP】本企业经营进口品种一览表GSP_FIRST_CORP=2202;/【GSP】首营企业审批表GSP_FIRST_PROD=2203;/【GSP】首营品种审批表GSP_BUY_PLAN=2204;/【GSP】药品采购进货计划表GSP_BUY_REC=2205;/【GSP】药品购进记录GSP_YEAR_BUY_QUALITY=2206;/【GSP】药品进货情况质量评审表GSP_QUALITY_PRO=2207;/【GSP】质量保证协议/验收入库3320 GSP_GOODS_CHECK=2220;/【GSP】药品到货请验单GSP_CHECK_SAMPLE=2221;/【GSP】

48、药品验收抽样记录GSP_BUY_CHECK_REC=2222;/【GSP】购进药品验收记录GSP_BACK_CHECK_REC=2223;/【GSP】退回药品验收记录GSP_TAKEOUT_CHECK=2224;/【GSP】药品验收抽(送)验单GSP_CHECK_REP=2225;/【GSP】药品检验报告书GSP_LAB_CHECK=2226;/【GSP】化验室检品登记表GSP_CHECK_CARD=2227;/【GSP】药品检验卡GSP_TEST_SOURCE=2228;/【GSP】化验原始记录GSP_MEASURE_W ARE=2229;/【GSP】计量器具管理台帐GSP_CHECK_GA

49、GE=2235;/【GSP】强制检定工作计量器具定期检定记录卡名师资料总结-精品资料欢迎下载-名师精心整理-第 20 页,共 23 页 -GSP_CHECK_GAGE1=2236;/【GSP】非强制检定计量器具检定记录卡GSP_APPARATUS_USE_REC=2237;/【GSP】精密仪器使用记录GSP_TITRATION_CONFIG=2238;/【GSP】滴定液配制及标化记录GSP_TITRATION_LABEL=2239;/【GSP】滴定液标签GSP_BUY_BATCH=2240;/【GSP】上年度药品进货批次汇总表GSP_YEAR_CHECK_BATCH=2241;/【GSP】年度

50、药品抽验批次汇总表GSP_YEAR_CHECK_QUALITY=2242;/【GSP】年度药品抽验质量汇总表GSP_CHECK_ENTER=2243;/【GSP】验收入库通知单GSP_BUY_REFUSE=2244;/【GSP】药品到货拒收报告单GSP_ENTER_STORAG_REC=2245;/【GSP】药品入库记录GSP_BUY_BACK_REC=2246;/【GSP】购进药品退出记录GSP_LOSE=2247;/【GSP】不合格药品报废销毁审批表GSP_LOSE1=2248;/【GSP】不合格药品报表GSP_UNQUALIFIED_LOSE=2249;/【GSP】不合格药品报损审批表G

展开阅读全文
相关资源
相关搜索

当前位置:首页 > 技术资料 > 技术总结

本站为文档C TO C交易模式,本站只提供存储空间、用户上传的文档直接被用户下载,本站只是中间服务平台,本站所有文档下载所得的收益归上传人(含作者)所有。本站仅对用户上传内容的表现方式做保护处理,对上载内容本身不做任何修改或编辑。若文档所含内容侵犯了您的版权或隐私,请立即通知淘文阁网,我们立即给予删除!客服QQ:136780468 微信:18945177775 电话:18904686070

工信部备案号:黑ICP备15003705号© 2020-2023 www.taowenge.com 淘文阁