數(shù)據(jù)報送標準(零售藥店)-資料下載頁
2024-07-24 02:41本頁面
【正文】 _NO指藥品的生產(chǎn)批號varchar(40)269032110有效期DRUG_DATE指藥品的有效期限至YYYYMMDD2014021511生產(chǎn)單位DRUG_PROENT經(jīng)國家食品藥品監(jiān)督管理局注冊審批生產(chǎn)藥品的廠家名稱varchar(100)哈藥集團制藥六廠二. 數(shù)據(jù)報送接口試圖測試( Tel：13214011508 ：1085494291 Email：HSSPYPJG@ ) SELECT UNIT_CODE ,UNIT_NAME ,UNIT_TYPE ,CERT_NO ,CERT_VALID ,TAX_CODE ,UNIT_RANGE , BUS_TYPE ,UNIT_ADD ,UNIT_CONT ,CONT_PHONE FROM vw_tb_cusinfo_ls select BIZ_TYPE ,BILL_NO ,BIZ_DATE ,COMP_NAME ,UNIT_CODE ,CLIENT_NAME , GOODS_CODE ,APPR_NO , GOODS_NAME ,DRUG_SPEC ,OPER_PRICE ,OPER_NUM ,DRUG_UNIT ,BATCH_NO , DRUG_DATE ,DRUG_PROENT ,TAX_ID ,TAX_NO ,TAX_DATE ,UNIT_CONT FROM vw_tb_instorage_ls SELECT BIZ_TYPE ,BILL_NO ,BIZ_DATE ,COMP_NAME , UNIT_CODE ,CLIENT_NAME , GOODS_CODE ,APPR_NO , GOODS_NAME ,DRUG_SPEC , OPER_PRICE ,OPER_NUM , DRUG_UNIT ,BATCH_NO , DRUG_DATE ,DRUG_PROENT ,TAX_ID ,TAX_NO ,TAX_DATE ,PER_NO ,PER_NAME FROM vw_tb_outstorage_ls SELECT BIZ_TYPE,BIZ_DATE,COMP_NAME, GOODS_CODE ,APPR_NO,GOODS_NAME,DRUG_SPEC, OPER_NUM ,DRUG_UNIT ,BATCH_NO ,DRUG_DATE ,DRUG_PROENT FROM vw_tb_scrap_ls SELECT BIZ_TYPE,BIZ_DATE, COMP_NAME, GOODS_CODE , APPR_NO, GOODS_NAME,DRUG_SPEC, OPER_NUM,DRUG_UNIT,BATCH_NO,DRUG_DATE,DRUG_PROENT FROM vw_tb_checkdiff_ls select BIZ_DATE,COMP_NAME, GOODS_CODE ,APPR_NO,GOODS_NAME,DRUG_SPEC, STORAGE_NUM,DRUG_UNIT,BATCH_NO,DRUG_DATE,DRUG_PROENT from vw_tb_storage_ls涉密材料，非授權不得閱讀、使用、復制等 第 8 頁 共 8 頁
環(huán)評公示相關推薦
鄂ICP備17016276號-1