千方百计数据库表

本文格式为Word版，下载可任意编辑——千方百计数据库表名称

AccountInterFaceAccountYearCfg

AdDebtBill调帐单（应收增加、应收减少、应付增加、应付减少）AdjustJobNumberBill批号修改单

AdjustPriceD商品调价单（药品详细调价信息）

AdjustPriceM商品调价单表头（调价理由、操作人等信息）AdPriceBill库存成本调价单AinterFaceAinterFaceCW

ArchivesCodeConfig基本信息编码规则Area销售片区

atype财务资产负债表、会计科目设置、各种财务接口的科目对照表、费用类型AtypeMonth历史月份财务资产负债表AtypeTempbackupd

BillIndex经营历程BillindexBakBillPrintReason

BillPrintRecord单据打印记录

BillType菜单与数据表等内部指向的指针btype往来单位btype_zlDbtype_zlM

BTYPEAttorney往来单位的业务员委托书btypeotherinfo往来单位其他信息BTypePrice往来单位特别价格资料库BtypeTemp

BuyBackBill购买退货单BuyBill购买入库单

BZBExportBill管家婆标准版接口数据CheckLocationAutoStatCheckLocationAutoTable

CheckLocationD货位盘点表（明细表）CheckLocationDTemp

CheckLocationM货位盘点表（主表）

CheckLocationStatD货位盘点盘盈盘亏表（明细）CheckLocationStatM货位盘点盘盈盘亏表（表头）CheckStock

CheckStockD盘点录入表（明细表）CheckStockM盘点录入表（表头）

CheckStockStatD库存盘点盘盈盘亏表（明细）CheckStockStatM库存盘点盘盈盘亏表（明细）CheckStockTable自动盘盈盘亏表

ColConfig

CommissionBill委托代销入库单、委托代销退货单、代销商品发货单COtherBillindex门店要货计划（表头等信息）COtherBillindexBak

COtherMxBill门店要货计划（药品详细信息）COtherMxBillBakCreateTempTableSQL

Department企业内部部门信息表DisassembleBill商品拆装单dtpropertiesDtsVipCardTempdxspkc_dayDdxspkc_dayM

employee职员信息EmployeeTEMP

gatheringBill财务管理——收款单GoodsLocations

GoodsLocationsCheckGoodsLocationTempGoodsStocks商品库存表GoodsStockstempgpPosIniRecord

GpReplicationProjectgpReplicationProjecttempGSP_BackBill

GSP_BackBillIndex

GSP_CheckOutP不合格药品台帐GSP_CommTableGSP_D_BuyerGSP_D_SenderGsp_F_Glass

Gsp_F_ImprotCheck

Gsp_F_Infomove质量信息传递单Gsp_F_InstrumentGsp_F_OutofTownCheckGsp_F_PtypeBackGsp_F_PtypeBackNdxGsp_F_PtypeQualityGsp_FileCodeDjGsp_FileFfHsjlGsp_FileJyjlGsp_FileXdsqbGsp_FileXhspjlGsp_FileXxLxcld

GSP_G_AcceptSample药品验收抽样记录（详细信息）GSP_G_AcceptSampleNdx药品验收抽样记录（表头）GSP_G_ApplyCheckBill

GSP_G_BadFeedbackReport药品不良反应报告表（详细药品信息）

GSP_G_BadFeedbackReportNdx药品不良反应报告表（表头）（本表与现行规定不符）GSP_G_BuyRecGSP_G_BuyRecNdxGSP_G_CheckBillGSP_G_CheckCard

GSP_G_DestroyAccountGSP_G_DestroyAccountNdxGSP_G_DestroyBill

GSP_G_EnterpriseCheckup首营企业审批表GSP_G_InAdviceGSP_G_InAdviceNDX

GSP_G_MaintainQlyReportGSP_G_MaintainQlyReportNdxGSP_G_PDestroyApprove

GSP_G_PMaintainInspectRec养护留样观测记录（详细药品信息）GSP_G_PMaintainInspectRecNdx养护留样观测记录（表头信息）GSP_G_PMoveRec直调药品质量验收记录（明细）GSP_G_PMoveRecNdx直调药品质量验收记录（表头）GSP_G_PQualityQueryGSP_G_PQualityQueryNdxGSP_G_PSaleBackAccountGSP_G_PSaleBackAccountNdx

GSP_G_QlyInfoRpt药品季度质量信息报表（明细）GSP_G_QlyInfoRptNdx药品季度质量信息报表（表头）GSP_G_QlyQueryLetters

GSP_G_QualityAgreement质量保证协议GSP_G_SaleAccountGSP_G_SaleAccountNdx

GSP_G_SaleReplevy销出药品追回记录（明细）GSP_G_SaleReplevyNdx销出药品追回记录（表头）GSP_G_TestAdvice

GSP_G_TestOriginalRecGSP_G_UserMind

GSP_G_ZYMaintain中药饮片在库养护检查记录（明细）GSP_G_ZYMaintainNdx中药饮片在库养护检查记录（表头）

GSP_InBillGSP的购进验收记录(EligibleQty)、购进入库通知单(CheckTotalQty)、到货请验通知单(BeforeCheckQty)、销后退货药品请验单、销后退回药品验收记录、销后退回通知单、销后退回台帐、销后退回验收入库通知单、配送退回入库单、配送退回药品验收记录、入库通知单

GSP_L_AfterSaleQlyTrace售后药品质量问题跟踪

GSP_L_CheckServerRec合格供货方档案GSP_L_ChinaDrkChk中药饮片装斗复核记录

GSP_L_ChinaDrkPartBreed中药饮片分装品种一览表GSP_L_ChinaDrkPartRecord中药饮片分装记录GSP_L_ChinaMedicaExamp中药饮片标本

GSP_L_ChinaMedicaExpAct中药饮片标本台帐Gsp_L_FeedBackInfo

GSP_L_FireSafeFixTable消防安全设背设施管理台帐、避光设背、堆码设背、照明设背、验收养护用仪器设背

GSP_L_ImpConserveMed重点养护药品确定表GSP_L_ImportCheck

GSP_L_ImportMedica进口药品一览表GSP_L_InnerMeasure温湿度记录（详细）GSP_L_InnerMeasureNDX温湿度记录（表头）Gsp_L_KwGradeGSP_L_LabCheck

GSP_L_MaintainList药品养护档案表（明细养护记录）Gsp_L_MaintainRecord药品养护档案表（药品信息）GSP_L_MeasureManage计量器具管理台帐（明细）GSP_L_MeasureManageNDX计量器具管理台帐（表头）GSP_L_QualityAdvice药品质量、服务质量征询看法书GSP_L_ReSale

Gsp_L_SaleManCheckGSP_L_TrainRecord

GSP_Lcb_ClearlyCheckNDX

GSP_Lcb_CuiXiao近效期药品催销表（详细）GSP_Lcb_CuiXiaoNDX近效期药品催销表（表头）GSP_Lcb_Disqualification

GSP_Lcb_InjectionClearlyCheck注射剂澄明度检查记录GSP_Lcb_QualityAcceptGSP_Lcb_QualityAcceptNDX

GSP_Lcb_RejectReport药品拒收报告表GSP_LoseApprove不合格药品报损审批表GSP_LoseDestroy不合格药品销毁记录

GSP_LoseDetail不合格药品报损处理清单（明细）GSP_LoseIndex不合格药品报损处理清单（表头）GSP_M_ActualizationAutoCheck

GSP_M_CheckEquipment养护设背检查维修记录GSP_M_CMDrinkPart

GSP_M_ConserveInstr设背管理台帐GSP_M_DCPersonCheckGSP_M_HytherInstrGSP_M_ImportProductgsp_m_mdadvice

Gsp_m_perpxjydagsp_m_perpxKhDetail

GSP_M_PersonalHealthDetail个人健康检查表GSP_M_PersonalHealthIndexGsp_M_PxDetail员工培训登记表Gsp_M_PxMain员工培训主表GSP_M_StorageVariety

GSP_M_UseRecord养护设背使用记录gsp_m_ZlPxjh质量培训计划

GSP_N_AdmitLicence往来单位的药品经营许可证信息GSP_N_BusinessLicence往来单位的营业执照信息GSP_N_CorrectMeasure

GSP_N_CustomerCheckup顾客资格审核表GSP_N_NearLandJobNumber

GSP_N_NearSampleJobNumber药品抽样批次汇总表GSP_N_NearValiditySymbol

GSP_N_QualityAccidentDeal质量事故处理记录GSP_N_ReturnExAprroveGSP_N_TitLiquidConfectGSP_N_UnaccordReport

GSP_OutBillGSP的销售记录、进货退货记录、药品出库复核记录（OutQty）、购进药品退出记录、代销商品发货单、配送出库单、药品出库复核记录GSP_SysNumbergsp_w_hxjzlns

gsp_w_jkjc健康检查汇总表gsp_w_spjyspb首营品种审批表gsp_w_ypzldagsp_w_zlcx

GSP_X_Professional

GSP_Y_Acuuse质量投诉记录表

GSP_Y_BuyerComplainCard顾客投诉记录卡Gsp_Y_MaintainDevice

GSP_Y_MeasureHistoryDetail强制（非强制）检定计量器具检定记录（明细）GSP_Y_MeasureHistoryIndex强制（非强制）检定计量器具检定记录（表头）GSP_Y_Qu