药易通大数据的库结构

1、实用标准文案数据结构一、基本信息数据结构1、商品基本资料数据结构pricebarcodePKbarcode_idI1p_idI1barcodeunitPKunit_idnamedeletedmedtypePKmt_idmt_codemt_namedeleted说明：ProductsBarcodeUnitPriceMedTypeproductsPK,I5product_idI5,I4class_idI3,I7parent_idI7,I6child_numberchild_countserial_numberI1namealiasstandardmodalpermitcodetrademarkma

2、keareaunit1_idunit2_idunit3_idunit4_idrate2rate3rate4validmonthvaliddaycommentdeletedI2pinyinfirstcheckvalidcheckotcflaggspflagmedtypecostmethodEngNameChemNameLatinName商品信息表一品多码表商品单位表价格表剂型表PKprice_idI1p_idI1u_idretailpricerecpriceprice1price2price3price4gppriceglpricespecialpriceunittypelowprice精彩文档

3、实用标准文案2、往来单位基本信息clientsPKclient_idI4class_idparent_idchild_numberchild_countI1serial_numberI2namealiasregion_idphone_numberaddresszipcodecontact_personaltax_numberacount_numbercredit_totalI3pinyinpricemodesklimitartotalartotal_iniaptotalaptotal_inipre_artotalpre_artotal_inipre_aptotalpre_aptotal_ini

4、firstcheckcommentcsflagdeletedProtocolDate说明：ClientsRegion3、仓库基本信息RegionPKregion_idI1serial_numbernamecommentdeleted往来单位信息库片区信息精彩文档实用标准文案storagesPKstorage_idI3class_idparent_idchild_numberlocationchild_countPK loc_idnamealiass_idI1serial_numberCommentloc_codeflagloc_nameI2PinYinloc_commentdeleteddel

5、eted说明：Storages仓库信息库Location货位信息库4、职员信息库employeesPKemp_idI2class_idparent_idchild_numberchild_countnamealiasdepartmentserial_numberPK departmentIddep_idphoneserial_numberaddresscommentnameaplimitcommentarlimitdeletedaptotalartotaldiscountlimitlsthI1pinyindeletedLowPriceHighPriceSNCountGSPSNCount说明：e

6、mployees职员信息库department部门信息库5、科目信息库精彩文档accountPKaccount_idI1class_idparent_idchild_numberchild_countnamealiasI2serial_numberCommentcur_totalini_totalsysflagsysrowdeletedI3PinYintotal_01total_02total_03total_04total_05total_06total_07total_08total_09total_10total_11total_12bqtotalsumtotalcashauditdir

7、ection说明：accountAccountComment6、会员卡信息实用标准文案AccountCommentPKCommIDAccountCommentCode科目信息库科目备注信息库精彩文档实用标准文案cardtotalmembercardPKIDPKCardIDcardidtotalI1CardNoNameTelcardtypeAddressPK CTypeIdCommentCardTypeTypeNameDiscountBulidDateDiscountValidityDateCommentLoseAutoDiscountStopUsecarddiscountBuyTotalBuy

8、TotalPerDayPKcd_idAutoDiscountIDCardAutoIDIntegralbegintotalBrithdayendtotalDiscountTypediscountcomment说明：Cardtype会员卡类型表Membercard会员卡表CardDiscount会员卡折扣类型CardTotal会员卡消费金额7、门店信息表ShopPosIDPosCodePosNameS_IDC_IDRemotePathCommentdeleted二、单据类数据结构1、销售类单据精彩文档实用标准文案salemanagebillbilldraftidxPKbillidbilldateb

9、illnumberbilltypea_idc_ide_idsout_idsin_idauditmaninputmanysmoneyssmoneyquantitytaxrateperiodbillstatesorder_iddepartment_idposidregion_idauditdateskdatejsyejsflagnotesummaryinvoicetranscountlasttranstimesalemanagebilldrfPKsmb_idbill_idp_idbatchnoquantitycostpricesalepricediscountdiscountpricetotalm

10、oneytaxpricetaxtotaltaxmoneyretailpriceretailtotalmakedatevaliddatequalitystatusprice_idss_idsd_idlocation_idsupplier_idcommissionflagcommentunitidtaxrateorder_idtotaliotagbillidxPK,I1billidI1billdatebillnumberI1billtypea_idI1c_idI1e_idsout_idsin_idauditmaninputmanysmoneyssmoneyquantitytaxrateperiod

11、billstatesorder_iddepartment_idposidregion_idauditdateskdatejsyejsflagnotesummaryinvoicetranscountlasttranstimePKsmb_idbill_idp_idbatchnoquantitycostpricesalepricediscountdiscountpricetotalmoneytaxpricetaxtotaltaxmoneyretailpriceretailtotalmakedatevaliddatequalitystatusprice_idss_idsd_idlocation_ids

12、upplier_idcommissionflagcommentunitidtaxrateorder_idtotaliotag说明：billdraftidx单据草稿主表SaleManagebilldrf销售单据草稿表Billidex单据主表SaleManageBill销售单据库2、采购类单据数据结构精彩文档实用标准文案buymanagebilldrfbuymanagebillbilldraftidxPKsmb_idbillidxPKsmb_idPK billidbill_idPK,I1billidbill_idp_idp_idbilldatebatchnoI1billdatebatchnobil

13、lnumberquantitybillnumberquantitybilltypecostpriceI1billtypecostpricea_idbuypricea_idbuypricec_iddiscountI1c_iddiscounte_iddiscountpriceI1e_iddiscountpricesout_idtotalmoneysout_idtotalmoneysin_idtaxpricesin_idtaxpriceauditmantaxtotalauditmantaxtotalinputmantaxmoneyinputmantaxmoneyysmoneyretailpricey

14、smoneyretailpricessmoneyretailtotalssmoneyretailtotalquantitymakedatequantitymakedatetaxratevaliddatetaxratevaliddateperiodqualitystatusperiodqualitystatusbillstatesprice_idbillstatesprice_idorder_idss_idorder_idss_iddepartment_idsd_iddepartment_idsd_idposidlocation_idposidlocation_idregion_idsuppli

15、er_idregion_idsupplier_idauditdatecommissionflagauditdatecommissionflagskdatecommentskdatecommentjsyeunitidjsyeunitidjsflagtaxratejsflagtaxratenoteorder_idnoteorder_idsummarytotalsummarytotalinvoiceiotaginvoiceiotagtranscounttranscountlasttranstimelasttranstime说明：Billdraftidx单据草稿主表BuyManagebilldrf采购

16、单据草稿表Billidx单据主表BuyManageBilldrf采购单据表3、库存类单据数据结构精彩文档billdraftidxPKbillidbilldatebillnumberbilltypea_idc_ide_idsout_idsin_idauditmaninputmanysmoneyssmoneyquantitytaxrateperiodbillstatesorder_iddepartment_idposidregion_idauditdateskdatejsyejsflagnotesummaryinvoicetranscountlasttranstime实用标准文案storemana

17、gebilldrfPKsmb_idbill_idp_idbatchnoquantitypricetotalmoneycostpricecosttotalretailpriceretailmoneymakedatevaliddatequalitystatusprice_idss_idsd_idlocation_idsupplier_idcommissionflagcommentunitidlocation_id2iotagtotalbillidxPK,I1billidI1billdatebillnumberI1billtypea_idI1c_idI1e_idsout_idsin_idauditm

18、aninputmanysmoneyssmoneyquantitytaxrateperiodbillstatesorder_iddepartment_idposidregion_idauditdateskdatejsyejsflagnotesummaryinvoicetranscountlasttranstimestoremanagebillPKsmb_idbill_idp_idbatchnoquantitypricetotalmoneycostpricecosttotalretailpriceretailmoneymakedatevaliddatequalitystatusprice_idss

19、_idsd_idlocation_idsupplier_idcommissionflagcommentunitidlocation_id2iotagtotal说明：Billdraftidx单据草稿主表StoreManagebilldrf库存单据草稿表Billidex单据主表storeManageBilldrf库存单据表4、库存盘点单精彩文档实用标准文案GoodsCheckBillDrfbilldraftidxPKsmb_idPK billidbill_idbilldatep_idbatchnobillnumberquantitybilltypecostpricea_idbuypricec_id

20、discounte_iddiscountpricesout_idtotalmoneysin_idtaxpriceauditmantaxtotalinputmantaxmoneyysmoneyretailpricessmoneyretailtotalquantitymakedatetaxratevaliddateperiodqualitystatusbillstatesprice_idorder_idss_iddepartment_idsd_idposidlocation_idregion_idsupplier_idauditdatecommissionflagskdatecommentjsye

21、unitidjsflagtaxratenoteorder_idsummarytotalinvoicetranscountlasttranstimebillidxPK,I1billidI1billdatebillnumberI1billtypea_idI1c_idI1e_idsout_idsin_idauditmaninputmanysmoneyssmoneyquantitytaxrateperiodbillstatesorder_iddepartment_idposidregion_idauditdateskdatejsyejsflagnotesummaryinvoicetranscountl

22、asttranstimeGoodsCheckBillPKsmb_idbill_idp_idbatchnoquantitycostpricebuypricediscountdiscountpricetotalmoneytaxpricetaxtotaltaxmoneyretailpriceretailtotalmakedatevaliddatequalitystatusprice_idss_idsd_idlocation_idsupplier_idcommissionflagcommentunitidtaxrateorder_idtotal说明：Billdraftidx单据草稿主表GoodsChe

23、ckbilldrf库存盘点草稿表Billidex单据主表GoodsCheckBill库存盘点表5、零售类单据结构精彩文档retailbillidxPK,I1billidI1billdatebillnumberI1billtypea_idI1c_idI1e_idsout_idsin_idauditmaninputmanysmoneyssmoneyquantitytaxrateperiodbillstatesorder_iddepartment_idposidregion_idauditdateskdatejsyejsflagnotesummaryinvoicetranscount说明：retai

24、lbillidxretailBilljkdetail6、订单表实用标准文案RetailBillPKsmb_idbill_idp_idbatchnoquantitycostpricesalepricediscountdiscountpricetotalmoneytaxpricetaxtotaltaxmoneyretailpriceretailtotalmakedatevaliddatequalitystatusprice_idss_idsd_idlocation_idsupplier_idcommissionflagcommentunitidtaxratetotal零售单主表零售明细表交款明细j

25、kdetailPKjkidjkdatejke_idjkimputmanjkmoneycomment精彩文档orderidxPK,I1billidI1billdatebillnumberI1billtypea_idI1c_idI1e_idsout_idsin_idauditmaninputmanysmoneyssmoneyquantitytaxrateperiodbillstatesorder_iddepartment_idposidregion_idauditdateskdatejsyejsflagnotesummaryinvoice说明：orderidxorderBill7、财务表实用标准文

26、案OrderBillPKsmb_idbill_idp_idbatchnoquantitycostpricesalepricediscountdiscountpricetotalmoneytaxpricetaxtotaltaxmoneyretailpriceretailtotalmakedatevaliddatequalitystatusprice_idss_idsd_idlocation_idsupplier_idcommissionflagcommentunitidtaxrateComeDateComeQtytotal订单主表订单明细表精彩文档financebillPKsmb_idbill_

27、ida_idc_idjftotaldftotalcomment1comment2comment3financebilldrfPKsmb_idbill_ida_idc_idjftotaldftotalcomment1comment2comment3说明：FinacebilldrfFinacebilljsbDetailjspdetail三、明细帐实用标准文案jsbdetailPKjsidc_idskd_bidxsd_bidbilltypejstotalremaintotalflagjspdetailPKjsidc_idskd_bidxsd_bidbilltypequantityjstotaldet

28、ail_idyj_quantityflag财务单据草稿表财务类单据表按单结算表按行结算表精彩文档productdetailPKpd_idI2,I1billidI2,I1p_idI2,I1s_idI2,I1quantitypriceI1totalcostpriceI2,I1costtotaltaxpriceI1taxtotalbatchnomakedatevaliddatecommissionflagsupplier_idlocation_idI2storetypeprice_idorder_idunitidsmb_id说明：ProductdetailAccountDetail四、库存余量1、库

29、存余量storehousePKstorehouse_idlocation_idI3,I1s_idI3,I2,I1p_idsupplier_idI3,I2,I1quantitycostpriceI2,I1costtotalbatchnomakedateinstoretimevaliddatecommissionflagstopsaleflaginorderyhdate说明：StoreHouseStorehouseini实用标准文案accountdetailPKsmb_idI1billidI1a_idI1c_idjdmoneyjdflag库存明细帐表科目明细帐表storehouseiniPKsto

30、rehouseini_idlocation_idI3,I1s_idI3,I2,I1p_idsupplier_idI3,I2,I1quantitycostpriceI2,I1costtotalbatchnomakedateinstoretimevaliddatecommissionflagstopsaleflaginorder库存余量表期初库存余量表精彩文档实用标准文案2、代销库存余量storedxPKstoredx_idlocation_idc_idp_idsupplier_idquantitycostpricecosttotalbatchnomakedateinstoretimevalidd

31、atecommissionflagstopsaleflaginorder说明：StoreDXStoredxini五、 GSP类表GSPSNStylePKIDBillTypeStyleSNCountGspTablePKGspIDGspTypeBillCodeBillEBillDateGspTextcommentCheckStatebatchnoSignGSPVer说明：GSPSNStyleGspAuditGSPVchTypeGspFlowControlPKFlowIDSourceGspTypeDestGspTypeCommentSysFlaggspPropertGspVchTypePKGspid

32、GspTypeNameFormStyleCommentstoredxiniPKstoredxini_idlocation_idc_idp_idsupplier_idquantitycostpricecosttotalbatchnomakedateinstoretimevaliddatecommissionflagstopsaleflaginorder代销库存余量表期初代销库存余量表gspauditPKts_idGSP_AuditLimite_idenameBillToGspIDBillTypeGSPTypeGSP编号GSP签字表GSP单据类型表精彩文档BillToGspGSPTable六、其它

33、1、跟踪类表LocationTracesalepricehisPKlt_idPKc_idPKp_idU1p_idPKunit_idU1s_idU1l_idSalePricerectime说明：LocationtraceSalePriceHisBuyPriceHis2、库存上下限StoreLimitPKSLIDI1P_idI1S_idUpperLimitLowLimitAdjQty说明StoreLimit3、门店物价管理表PosPricePKprice_idpos_idp_idu_idretailpricerecpriceprice1price2price3price4gppriceglpric

34、especialpriceunittypelowprice4、权限类表实用标准文案单据至 GSP流程定义GSP报表库表buypricehisPKc_idPKp_idPKunit_idBuyPrice货位跟踪售价跟踪进价跟踪库存上下限表精彩文档实用标准文案ReplicationAuthorizeEmpMsgLimitusersPK user_idIDIDe_idGUIDEIDloginpassMemoBillTypepermissionTagMSGLIMITTag说明ReplicationAuthorize复制授权表empMsglimit职员消息权限users登录用户权限表UserAuthori

35、ze用户授权限表5、用友接口dwdzkmdzpzoutdw_idkm_idbilldatec_ida_idpzlbserialnumberserialnumberpznumbertypetypepzfjpzcommentkmcodejfmoneydfmoneygysnumberccode说明dwdz单位对照表kmdz科目对照表pzOut凭证导出表6、消息与日志SystemLogMsgHistoryPKIDPKEIDIDActionTagComputerVchIDSenderActionTypeEIDComputerActionStrActionDateTextCommentReceiveDat

36、e说明systemlog日志表MsgHistory消息历史记录表7、系统配置userauthorizePKut_ide_idtypepsc_idparentflag精彩文档实用标准文案sysconfigPKsys_idI1sysnamesysvaluecomment说明：值备注OpenAccount1启用账套标志CostMethod3默认成本核算法AccountPeriod1会计期TaxRate0默认税率BillCount80默认单据行数DBVersion2003-07-3版本号2RecpriceAsCost0使用最近进价为成本价 =0 false =1trueNegativeStock0负库存开关 =0 false =1 trueUseSameCostMethod1使用统一成本核算法 =0 false =1trueUseBuyTrace0使用进价跟踪UseSaleTrace1使用售价跟踪BillSNLex11单据编号规则 1BillSNLex20单据编号规则 2BillSNLex30单据编号规则 3BillSNCount单据编号记数GSPSNLex1GSP单据编号规则 1GSPSNLe