千方百計數(shù)據(jù)庫表

本文格式為Word版，下載可任意編輯——千方百計數(shù)據(jù)庫表名稱

AccountInterFaceAccountYearCfg

AdDebtBill調(diào)帳單（應(yīng)收增加、應(yīng)收減少、應(yīng)付增加、應(yīng)付減少）AdjustJobNumberBill批號修改單

AdjustPriceD商品調(diào)價單（藥品詳細(xì)調(diào)價信息）

AdjustPriceM商品調(diào)價單表頭（調(diào)價理由、操作人等信息）AdPriceBill庫存成本調(diào)價單AinterFaceAinterFaceCW

ArchivesCodeConfig基本信息編碼規(guī)則Area銷售片區(qū)

atype財務(wù)資產(chǎn)負(fù)債表、會計科目設(shè)置、各種財務(wù)接口的科目對照表、費用類型AtypeMonth歷史月份財務(wù)資產(chǎn)負(fù)債表AtypeTempbackupd

BillIndex經(jīng)營歷程BillindexBakBillPrintReason

BillPrintRecord單據(jù)打印記錄

BillType菜單與數(shù)據(jù)表等內(nèi)部指向的指針btype往來單位btype_zlDbtype_zlM

BTYPEAttorney往來單位的業(yè)務(wù)員委托書btypeotherinfo往來單位其他信息BTypePrice往來單位特別價格資料庫BtypeTemp

BuyBackBill購買退貨單BuyBill購買入庫單

BZBExportBill管家婆標(biāo)準(zhǔn)版接口數(shù)據(jù)CheckLocationAutoStatCheckLocationAutoTable

CheckLocationD貨位盤點表（明細(xì)表）CheckLocationDTemp

CheckLocationM貨位盤點表（主表）

CheckLocationStatD貨位盤點盤盈盤虧表（明細(xì)）CheckLocationStatM貨位盤點盤盈盤虧表（表頭）CheckStock

CheckStockD盤點錄入表（明細(xì)表）CheckStockM盤點錄入表（表頭）

CheckStockStatD庫存盤點盤盈盤虧表（明細(xì)）CheckStockStatM庫存盤點盤盈盤虧表（明細(xì)）CheckStockTable自動盤盈盤虧表

ColConfig

CommissionBill委托代銷入庫單、委托代銷退貨單、代銷商品發(fā)貨單COtherBillindex門店要貨計劃（表頭等信息）COtherBillindexBak

COtherMxBill門店要貨計劃（藥品詳細(xì)信息）COtherMxBillBakCreateTempTableSQL

Department企業(yè)內(nèi)部部門信息表DisassembleBill商品拆裝單dtpropertiesDtsVipCardTempdxspkc_dayDdxspkc_dayM

employee職員信息EmployeeTEMP

gatheringBill財務(wù)管理——收款單GoodsLocations

GoodsLocationsCheckGoodsLocationTempGoodsStocks商品庫存表GoodsStockstempgpPosIniRecord

GpReplicationProjectgpReplicationProjecttempGSP_BackBill

GSP_BackBillIndex

GSP_CheckOutP不合格藥品臺帳GSP_CommTableGSP_D_BuyerGSP_D_SenderGsp_F_Glass

Gsp_F_ImprotCheck

Gsp_F_Infomove質(zhì)量信息傳遞單Gsp_F_InstrumentGsp_F_OutofTownCheckGsp_F_PtypeBackGsp_F_PtypeBackNdxGsp_F_PtypeQualityGsp_FileCodeDjGsp_FileFfHsjlGsp_FileJyjlGsp_FileXdsqbGsp_FileXhspjlGsp_FileXxLxcld

GSP_G_AcceptSample藥品驗收抽樣記錄（詳細(xì)信息）GSP_G_AcceptSampleNdx藥品驗收抽樣記錄（表頭）GSP_G_ApplyCheckBill

GSP_G_BadFeedbackReport藥品不良反應(yīng)報告表（詳細(xì)藥品信息）

GSP_G_BadFeedbackReportNdx藥品不良反應(yīng)報告表（表頭）（本表與現(xiàn)行規(guī)定不符）GSP_G_BuyRecGSP_G_BuyRecNdxGSP_G_CheckBillGSP_G_CheckCard

GSP_G_DestroyAccountGSP_G_DestroyAccountNdxGSP_G_DestroyBill

GSP_G_EnterpriseCheckup首營企業(yè)審批表GSP_G_InAdviceGSP_G_InAdviceNDX

GSP_G_MaintainQlyReportGSP_G_MaintainQlyReportNdxGSP_G_PDestroyApprove

GSP_G_PMaintainInspectRec養(yǎng)護(hù)留樣觀測記錄（詳細(xì)藥品信息）GSP_G_PMaintainInspectRecNdx養(yǎng)護(hù)留樣觀測記錄（表頭信息）GSP_G_PMoveRec直調(diào)藥品質(zhì)量驗收記錄（明細(xì)）GSP_G_PMoveRecNdx直調(diào)藥品質(zhì)量驗收記錄（表頭）GSP_G_PQualityQueryGSP_G_PQualityQueryNdxGSP_G_PSaleBackAccountGSP_G_PSaleBackAccountNdx

GSP_G_QlyInfoRpt藥品季度質(zhì)量信息報表（明細(xì)）GSP_G_QlyInfoRptNdx藥品季度質(zhì)量信息報表（表頭）GSP_G_QlyQueryLetters

GSP_G_QualityAgreement質(zhì)量保證協(xié)議GSP_G_SaleAccountGSP_G_SaleAccountNdx

GSP_G_SaleReplevy銷出藥品追回記錄（明細(xì)）GSP_G_SaleReplevyNdx銷出藥品追回記錄（表頭）GSP_G_TestAdvice

GSP_G_TestOriginalRecGSP_G_UserMind

GSP_G_ZYMaintain中藥飲片在庫養(yǎng)護(hù)檢查記錄（明細(xì)）GSP_G_ZYMaintainNdx中藥飲片在庫養(yǎng)護(hù)檢查記錄（表頭）

GSP_InBillGSP的購進(jìn)驗收記錄(EligibleQty)、購進(jìn)入庫通知單(CheckTotalQty)、到貨請驗通知單(BeforeCheckQty)、銷后退貨藥品請驗單、銷后退回藥品驗收記錄、銷后退回通知單、銷后退回臺帳、銷后退回驗收入庫通知單、配送退回入庫單、配送退回藥品驗收記錄、入庫通知單

GSP_L_AfterSaleQlyTrace售后藥品質(zhì)量問題跟蹤

GSP_L_CheckServerRec合格供貨方檔案GSP_L_ChinaDrkChk中藥飲片裝斗復(fù)核記錄

GSP_L_ChinaDrkPartBreed中藥飲片分裝品種一覽表GSP_L_ChinaDrkPartRecord中藥飲片分裝記錄GSP_L_ChinaMedicaExamp中藥飲片標(biāo)本

GSP_L_ChinaMedicaExpAct中藥飲片標(biāo)本臺帳Gsp_L_FeedBackInfo

GSP_L_FireSafeFixTable消防安全設(shè)背設(shè)施管理臺帳、避光設(shè)背、堆碼設(shè)背、照明設(shè)背、驗收養(yǎng)護(hù)用儀器設(shè)背

GSP_L_ImpConserveMed重點養(yǎng)護(hù)藥品確定表GSP_L_ImportCheck

GSP_L_ImportMedica進(jìn)口藥品一覽表GSP_L_InnerMeasure溫濕度記錄（詳細(xì)）GSP_L_InnerMeasureNDX溫濕度記錄（表頭）Gsp_L_KwGradeGSP_L_LabCheck

GSP_L_MaintainList藥品養(yǎng)護(hù)檔案表（明細(xì)養(yǎng)護(hù)記錄）Gsp_L_MaintainRecord藥品養(yǎng)護(hù)檔案表（藥品信息）GSP_L_MeasureManage計量器具管理臺帳（明細(xì)）GSP_L_MeasureManageNDX計量器具管理臺帳（表頭）GSP_L_QualityAdvice藥品質(zhì)量、服務(wù)質(zhì)量征詢看法書GSP_L_ReSale

Gsp_L_SaleManCheckGSP_L_TrainRecord

GSP_Lcb_ClearlyCheckNDX

GSP_Lcb_CuiXiao近效期藥品催銷表（詳細(xì)）GSP_Lcb_CuiXiaoNDX近效期藥品催銷表（表頭）GSP_Lcb_Disqualification

GSP_Lcb_InjectionClearlyCheck注射劑澄明度檢查記錄GSP_Lcb_QualityAcceptGSP_Lcb_QualityAcceptNDX

GSP_Lcb_RejectReport藥品拒收報告表GSP_LoseApprove不合格藥品報損審批表GSP_LoseDestroy不合格藥品銷毀記錄

GSP_LoseDetail不合格藥品報損處理清單（明細(xì)）GSP_LoseIndex不合格藥品報損處理清單（表頭）GSP_M_ActualizationAutoCheck

GSP_M_CheckEquipment養(yǎng)護(hù)設(shè)背檢查維修記錄GSP_M_CMDrinkPart

GSP_M_ConserveInstr設(shè)背管理臺帳GSP_M_DCPersonCheckGSP_M_HytherInstrGSP_M_ImportProductgsp_m_mdadvice

Gsp_m_perpxjydagsp_m_perpxKhDetail

GSP_M_PersonalHealthDetail個人健康檢查表GSP_M_PersonalHealthIndexGsp_M_PxDetail員工培訓(xùn)登記表Gsp_M_PxMain員工培訓(xùn)主表GSP_M_StorageVariety

GSP_M_UseRecord養(yǎng)護(hù)設(shè)背使用記錄gsp_m_ZlPxjh質(zhì)量培訓(xùn)計劃

GSP_N_AdmitLicence往來單位的藥品經(jīng)營許可證信息GSP_N_BusinessLicence往來單位的營業(yè)執(zhí)照信息GSP_N_CorrectMeasure

GSP_N_CustomerCheckup顧客資格審核表GSP_N_NearLandJobNumber

GSP_N_NearSampleJobNumber藥品抽樣批次匯總表GSP_N_NearValiditySymbol

GSP_N_QualityAccidentDeal質(zhì)量事故處理記錄GSP_N_ReturnExAprroveGSP_N_TitLiquidConfectGSP_N_UnaccordReport

GSP_OutBillGSP的銷售記錄、進(jìn)貨退貨記錄、藥品出庫復(fù)核記錄（OutQty）、購進(jìn)藥品退出記錄、代銷商品發(fā)貨單、配送出庫單、藥品出庫復(fù)核記錄GSP_SysNumbergsp_w_hxjzlns

gsp_w_jkjc健康檢查匯總表gsp_w_spjyspb首營品種審批表gsp_w_ypzldagsp_w_zlcx

GSP_X_Professional

GSP_Y_Acuuse質(zhì)量投訴記錄表

GSP_Y_BuyerComplainCard顧客投訴記錄卡Gsp_Y_MaintainDevice

GSP_Y_MeasureHistoryDetail強(qiáng)制（非強(qiáng)制）檢定計量器具檢定記錄（明細(xì)）GSP_Y_MeasureHistoryIndex強(qiáng)制（非強(qiáng)制）檢定計量器具檢定記錄（表頭）GSP_Y_Qu