SPD_BARCODE
物资账期设置信息表BASE_GOODS_ACCOUNT_PERIOD
结算周期设置表EIM_FIN_SETTLE_CYCLE_SETTING
PRODUCT_KEY
left join base_org_supplier_goods t on BASE_ORG_GOODS.goods_key = t.goods_key and b.org_id = t.org_id and t.GOODS_VERSION = b.GOODS_VERSION and t.supplier_id = b.supplier_id
DEPT_ID:ORG_ID
PICK_DETAIL_ID:ID
id:OUTBOUND_DETAIL_ID
to_yc_eim_consume_cont阳采数据汇总中间表
to_yc_purbill_info
pur_dist_barcode
采购需求明细pur_request_detail
wm_dist 推送单状态TODELIVER(\"61\
cert_id:id
CONFIRM_DETAIL_ID：id
仓库base_warehouse
check_id:id
id:busi_idbusi_type='pur_check'
物资变更申请表base_data_change
补货申请wm_replenish_apply
发票EIM_INVOICE
入库单明细WM_INBOUND_DETAIL
his_surgery_application_no
PROVINCEID：ext_json.provinceNum
验收成功，生成入库单
物资使用登记明细wm_use_registration_detail
科室自动补货定时任务流程
wh_id:id
三级库入出库纪录对象 wm_tertiary_warehouse_storage_records
主库位表drug_location_hdr
id_code：spd_barcode
cert_status00-已维护待提交00.cd-审核不通过61.sptg-审核通过11-换新证待提交12-修改待提交20-待审核30-已过期90-证照附件未维护91-停用92-作废
结算单eim_fin_settle
id:WAREHOUSE_ID
推送的入库单EIM_FIN_SETTLE_INBOUND
SPD_BARCODE:SPD_BARCODE
area_id:id
中心库-定数任务出库
ORG_ID:ORG_ID
ID:INBOUND_ID
bill_no
结算消耗物资明细eim_fin_settle_consume_detail
from base_tertiary_warehouse_inventory a left join base_goods b on a.goods_id=b.id left join base_org_goods og on a.org_goods_id=og.id left join base_product p on a.product_id = p.id
基础物资base_goods
产品信息base_product
ID:BUSI_ID
相关证照base_cert
付款明细eim_payment_detail
推送单明细wm_dist_detail
id:HIS_APPLICATION_STATUS_ID
id:dist_id
物资消耗明细辅表eim_consume_detail_prop
术间维护base_surgery_room
物资规格限额配置 base_goods_limit_money
基础数据-科室库库存设置-设置物资补货源类型（采购补货）
busi_id：id
id:outbound_id
use_registration_detail_id:id
status
物资物价码对照表base_goods_charge_relate
WM_TERTIARY_WAREHOUSE_STORAGE_RECORDS
id:detail_id
拣货单wm_picking
手术材料拣货主表wm_surgery_pick
手术排程wm_surgery_schedule
物资使用登记wm_use_registration
字典数据表SYS_DICT_DATA
科室库物资关系
补货申请明细wm_replenish_apply_detail
手术材料拣货明细表wm_surgery_pick_details
status:70-待拣货72-拣货完成
goods_key
warehouse_id:wh_id
PICK_ID:ID
\"original.qc.cloud\": \"期初入库-云仓\
移库明细wm_transfer_detail
his_application_no
关联附页表（物资证照）cert_attached_pages
id:PICKING_ID
settle_id:id
id:DIST_ID
采购订单明细pur_order_detail
仓库物资业务信息wm_goods_busi
物资移库实际明细wm_transfer_detail_real
补货任务wm_replenish_apply
入库单明细wm_inbound_detail
cat_json:id
goods_key:keyg.version_mark = 1_
机构物资UDI对照base_org_goods_idcode_di
change_id:id
机构(建设SPD)供货关系表(供应商的物资)base_org_supplier_goods
id:invoice_id
院区物资档案分为集团和其他院区
存储采物资购限制相关参数，物资新增时保存信息，手工请领时查询校验productKeygoodsKey
手术材料申请明细wm_surgery_apply_detail
移库wm_transfer
结算单发票信息EIM_FIN_SETTLE_INVOICE
status:71->待验
结算的入库单明细统计EIM_FIN_SETTLE_INBOUND_TOTAL
采购计划明细pur_plan_detail
goods_id:id
confirm_id:id
warehouse_loc_id:id
规格单位BASE_GOODS_UNIT
GOODS_ID:key_
明细中通过以下字段关联物资信息product_idgoods_idorg_goods_id
定时任务-科室自动补货
id:apply_id
物资定数包base_org_goods_pkg
id:SURGERY_APPLICATION_IDbill_no:SURGERY_APPLICATION_NO
settle_cycle_id:id
base_patient
goods_id=id
REQUEST_DETAIL_ID:id
id:DIST_RECEIVE_ID
id:busi_key
busiType='dist'id:consumeSrcBusiId物资接收确认，自动消耗
place_id:id
定时任务，处理物资是否到达补货点
base_goods_attach_file物资附件文件
采购发票pur_invoice
物资替换记录表BASE_GOODS_REPLACE_RECORD
charge_item_id:id
goods_unit_id:id
手术材料物资明细表wm_surgery_goods_details
生成采购计划
仓库物资wm_goods
source_bill_no
规格单位base_goods_unit
采购订单pur_order
org_goods_id:id
供应商供应物资价格base_org_supplier_goods_price
from base_charge_item bcileft join base_charge_item_goods bcig on bcig.charge_item_id = bci.id left join base_org_goods bog on bog.code = bci.id left join base_goods bg on bg.key_ = bog.goods_key and bg.version_ = bog.goods_version
配送单pur_dist
单位(建设SPD)物资base_org_goods
拣货车/箱
id:order_detail_id
id:DIST_DETAIL_ID
rfid对象wm_rfid_idcode
id 用的发票id
spd_barcode:spd_barcode
品牌表base_brand
物资分组base_goods_group
低值使用登记物资wm_use_registration_detail rd LEFT JOIN wm_use_registration r ON rd.registration_id = r.id LEFT JOIN base_goods g ON rd.goods_id = g.id LEFT JOIN base_product p ON rd.product_id = p.id LEFT JOIN base_brand bb ON bb.id = p.brand_id LEFT JOIN base_org_goods og ON og.id = rd.org_goods_id LEFT JOIN base_goods_unit gu ON gu.id = og.price_unit_id LEFT JOIN base_productor bpd ON bpd.id = p.producer_id LEFT JOIN base_supplier bs ON bs.id = og.supplier_id LEFT JOIN base_dept_goods bdg ON bdg.goods_key = g.key_ AND bdg.dept_id = r.dept_id AND bdg.status = '61' LEFT JOIN SYS_DICT_DATA SDD ON sdd.DICT_TYPE = 'cost_unit' AND sdd.DICT_VALUE = bdg.COST_UNIT LEFT JOIN sys_org so ON so.org_id = r.dept_id LEFT JOIN WM_SURGERY_APPLY sa ON sa.SOURCE_BILL_NO = r.SOURCE_BILL_NO WHERE rd.spd_barcode is null AND so.IS_SURGERY = 1
id:product_id
手术材料申请wm_surgery_apply
warehouse_area_id:id
id:warehouse_id
关联字段：goods_key
GOODS_ID
invoice:id
中心库和科室库库存设置
推送单接收单wm_dist_receive
BUSI_ID:id
fin_settle_detail_id:idsettle_id:settle_id
1、手工请领，会校验物资规格限额配置限额2、请领时会生成科室库采购明细，中心库库存不够则生成中心库采购明细
配送单明细pur_dist_detail
物资使用登记明细WM_USE_REGISTRATION_DETAIL
WmOutbound(BusiType)YK 移库出库 ql 请领出库 ys 验收出库 (busiId=purCheck.getId())ql.auto 自动请领 bh 上级仓补货 ly 消耗库领用出库sjxh 消耗库实际出库 pd 盘点出库 th2wh 退到仓库 th2suppier 退到供应商
部门物资调量表base_dept_goods_qty_adjust
智能仓库base_warehouse_iwhd
开始
warehouse_id:id
入库单WM_INBOUND
验收单pur_check
手术材料推送-接收确认主表wm_surgery_material_receive_confirmation
货位可存储商品base_warehouse_loc_goods
ID：to_inbound_id
id:CONSUME_DETAIL_IDCONSUME_ID：CONSUME_ID
物资使用登记 wm_use_registration
手术材料申请组wm_surgery_apply_group
base_org_goods
patient_code
扩展认证项目信息表WM_EXT_SIGN_PROJECT
结算单发票明细信息EIM_FIN_SETTLE_INVOICE_DETAIL
收费项包含物资base_charge_item_goods
供货信息变更申请base_org_supplier_goods_change
id:org_goods_pkg_id
id:busi_id
产品-产品类别关系base_product_cat_ref
warehouse_goods_id:id
att_attachment业务记录相关附件信息
code:id
id:group_id
inbound_total_id:id
采购发票明细pur_invoice_detail
BUSI_TYPE业务来源类型BUSI_ID业务来源IDback退货单，id为退货单iddist推送单，id为推送单id
producer_id:id
product_id:id
PROVINCEID：PROVINCE_ID
仓库地址base_warehouse_address
PRICE_UNIT_ID:id
id:INBOUND_ID
批量释放，生产拣货任务
物资使用登记明细WM_USE_REGISTRATION_DETAIL
OUTBOUND_ID：id
REQQUEST_ID:ID
id:check_from_busi_detail_id
id:settle_id
手术材料拣货明细表wm_surgery_picked_details
货位base_warehouse_loc
条码业务记录busiId:id
出库单实际出库明细WM_OUTBOUND_DETAIL_REAL
打印模板print_template
推送单wm_dist
id:plan_id
busi_id:idbusi_type='pur_check
status:71->代配物资
采购需求pur_request
拣货单明细wm_picking_deatail
高值使用登记物资wm_use_registration_detail rd LEFT JOIN wm_use_registration r ON rd.registration_id = r.id LEFT JOIN wm_goods wg ON wg.spd_barcode = rd.spd_barcode AND wg.org_id = r.org_id LEFT JOIN base_org_goods og ON og.id = wg.org_goods_id LEFT JOIN base_product p ON p.key_ = og.product_key AND p.version_ = og.product_version LEFT JOIN base_goods g ON g.key_ = og.goods_key AND g.version_ = og.goods_version LEFT JOIN base_goods_unit gu ON gu.id = og.price_unit_id LEFT JOIN base_supplier bs ON bs.id = og.supplier_id LEFT JOIN base_productor bpd ON bpd.id = p.producer_id LEFT JOIN base_dept_goods bdg ON bdg.goods_key = g.key_ AND bdg.dept_id = r.dept_id AND bdg.status = '61' LEFT JOIN SYS_DICT_DATA SDD ON sdd.DICT_TYPE = 'cost_unit' AND sdd.DICT_VALUE = bdg.COST_UNIT LEFT JOIN sys_org so ON so.org_id = r.dept_id LEFT JOIN WM_SURGERY_APPLY sa ON sa.SOURCE_BILL_NO = r.SOURCE_BILL_NO WHERE rd.spd_barcode IS NOT NULL AND so.IS_SURGERY = 1
busiType='dist'id:busiId物资接收确认，自动生成财务出库单
sgp.price
org_goods_id=id
to_yc_purbill_info_new_net阳采物资对照后中间表（省平台汇总数据源）
og.id = bgap.org_goods_id and bgap.busi_type = 1
to_yc_purbill_info_dtl
如果以明细为维度查询，需要查询对应的发票号，使用这个方式（一个物资关联多个发票导致金额错误的问题，使用子查询对发票进行合并span style=\"font-size:inherit;\
手术材料推送-接收物资明细表WM_SURGERY_MATERIAL_RECEIVE_CONFIRMATION_DETAIL
拣货工具base_tool
WAREHOUSE_ID:id
盘点明细对象wm_take_stock_detail
合同管理表cert_contract
收费项base_charge_item
LEFT JOIN base_org_supplier_goods_price sgp ON sgp.supplier_id = new_supplier.id AND sgp.goods_key = a.goods_key and sgp.org_id = a.org_id and sysdate between sgp.start_date and sgp.end_date
ID:detailId
wg.supplier_id = bgaps.supplier_id and bgaps.busi_type = 2
供应商端-发票管理新-新增
id:from_outbound_id
surgery_goods_details_id：id
术后材料回库登记明细对象 wm_surgery_back_review_details
存了病人姓名
库存不足自动采购定时任务流程
yc_country_code
from base_charge_item bci join base_charge_item_goods c on bci.id=c.CHARGE_ITEM_ID join base_goods g on g.key_ = c.goods_key and g.version_mark = 1 join wm_goods wg on wg.goods_id = g.id
id:busi_isbusi_type='picking'
HIS申请单状态子表wm_his_application_status_record_details
base_goods
base_use_amount_group
阳采物资（对照使用）YC_GOODS_INFO
id:plan_detail_id
CHECK_STATUS(验收状态)：qbbhg-全部不合格qbys-全部通过bfys-部分通过
复核台设置 wm_recheck_desk_user
GOODS_KEY:KEY_
group_id：id
cat_id:id
id:backReviewId
云仓物资额外增加的字段base_goods_extra
结算出库单明细EIM_FIN_SETTLE_OUTBOUND_DETAIL
his申请单号his_apply_nohis_surgery_application_nosource_bill_no
registration_id ：id
供应商base_supplier
消耗、结算出库、物资使用登记关系 EIM_FIN_SETTLE_OUTBOUND o LEFT JOIN EIM_FIN_SETTLE_OUTBOUND_DETAIL od ON o.ID = od.OUTBOUND_ID left join eim_consume_detail efd on efd.id=od.detail_id left join eim_consume_detail_prop ecdp on efd.id=ecdp.consume_detail_id left join wm_use_registration_detail wurd on efd.use_registration_detail_id=wurd.id left join wm_use_registration wur on wurd.registration_id=wur.id left join eim_fin_settle_cycle_setting ecs on o.settle_cycle_id=ecs.id left JOIN WM_GOODS g ON od.SPD_BARCODE = g.SPD_BARCODE left JOIN BASE_ORG_GOODS bog ON g.ORG_GOODS_ID = bog.ID
组内物资BASE_GOODS_GROUP_DETAIL
detail_id:id
goods_fin_type:物资财务分类fin_wh_type:财务仓库类型goods_sf_type:物资收费属性quantity_purchase_type:带量采购类型net_purchase_type:网采类型MANAGEMENT_MODE:管理模式goods_pur_type:采购类别cold_chain_type:储运环境
结算的入库单明细EIM_FIN_SETTLE_INBOUND_DETAIL
手术申请详情
验收单明细pur_check_detail
id:order_id
手术材料申请单号bill_noapply_noSURGERY_APPLICATION_ID
生成出库任务
部门物资管控base_dept_goods
ID:BUSI_IDbusiType='original.cg'
当前库存物资（二级库）wm_stock_goods
FROM pur_order_detail podLEFT JOIN pur_order po ON po.id = pod.order_idLEFT JOIN pur_dist_detail pdd ON pdd.order_detail_id = pod.id（一个订单明细可能会存在多次配送，导致明细查询数据重复）LEFT JOIN pur_check_detail pcd ON pcd.check_from_busi_detail_id = pdd.idLEFT JOIN pur_check pc ON pc.id = pcd.check_id
PICKING_BUSI_ID：idPICKING_BUSI_TYPE='outbound'
reag_apparatus
his_apply_no
wmDist业务类型(BusiType/busiId)purCheck 采购 purCheck.getId()picking 拣货单 wm_picking.id
手术材料推送-接收确认明细表WM_SURGERY_MATERIAL_RECEIVE_CONFIRMATION_DETAILS
科室设置对应仓库，仓库有仓库地址，仓库物资设置中冗余物资key
id:ORG_ID
TRANSFER_ID
id:id
cert_business_goods业务关联物资表
picking_tool:id
发票明细EIM_INVOICE_DETAIL
product_idcode_di
BACK_ID:id
采购计划pur_plan
id:check_from_busi_id
结算明细eim_fin_settle_detail
产地base_place
仓库物资定数包加工设置base_warehouse_goods_pkg
wm_stock_goods wsg on a.SPD_BARCODE = wsg.SPD_BARCODE left join EIM_CONSUME_DETAIL ecd on ecd.SPD_BARCODE = wsg.SPD_BARCODE left join wm_goods b on a.SPD_BARCODE = b.SPD_BARCODE left join BASE_ORG_GOODS bog on bog.id=b.ORG_GOODS_ID left join base_goods g on b.goods_id=g.id left join base_product p on b.product_id=p.id left join base_goods_unit gu on b.goods_unit_id = gu.id left join base_warehouse_area bwa on wsg.warehouse_area_id = bwa.id left join base_warehouse_loc bwl on wsg.warehouse_loc_id = bwl.id left join base_supplier bs on b.supplier_id = bs.id left join BASE_BRAND bb on p.brand_id = bb.id left join BASE_PRODUCTOR bp on p.PRODUCER_ID = bp.id
id：backReviewIdDetails
GOODS_KEY
sourceTypes来源类型1普通物资2组套3术式套包5智能柜领用
结算出库单EIM_FIN_SETTLE_OUTBOUND
invoice_id:id
product_id ：id
机构sys_org
采购订单催单记录表pur_order_reminde_record
old_code:code
库区base_warehouse_area
结算单EIM_FIN_SETTLE
物资组类别BASE_GOODS_GROUP_CAT
拣货复核通过：生成出库单明细、推送单和明细
退货单明细WM_BACK_DETAIL
省平台对接相关
术后材料回库登记主表wm_surgery_back_review
厂家base_productor
inventoryId：id
退货单wm_back
apply_id
云仓入库单表WM_INBOUND_CLOUD
goods_id：GOODSID
supplier_id:id
术后材料回库登记明细物资对象 wm_surgery_back_review_material_details
物资类别base_goods_cat
apply_no:source_bill_no
inboud_id:id
id：confirm_id_details_mark
busi_key:id
采验管理-采购计划提交
手术室拣货步骤：1：锁定二级库库存WM_STOCK_GOODS set status = 812：修改手术材料拣货明细3：wm_surgery_picked_details
HIS申请单状态表wm_his_application_status_reco
阳采物资对照对象 yc_goods_info_control
（中心库）仓库物资设置base_warehouse_goods
wh_area_id:id
goods_key:key_
key_:ORG_GOODS_KEY
bogp.status = '61'
key_:org_goods_key
id:goods_id
出库单wm_outbound
CONSUME_ID:id
id:cat_id
HOSPITALORDERID
术后材料回库登记主对象 wm_surgery_back_review
出库单明细wm_outbound_detail
中心库-拣货任务
拣货功能
id:surgery_room_id
supplier_id:supplier_id
business_id:busi_key
定时任务-库存不足自动采购
基础数据-科室物资目录
仓库物资定数包base_warehouse_goods_pkg
产品类别base_product_cat
推送单接收单明细wm_dist_receive_detail
物资领用消耗单eim_consume
基础数据-科室库库存设置-设置物资补货源类型（上级仓补货）
领用消耗单明细eim_consume_detail
采验管理功能
product_key:key_
入库单(中心库)wm_inbound
brand_id:id
三级库库存BASE_TERTIARY_WAREHOUSE_INVENTORY
id:recheckDeskId
REGISTRATION_ID:id
eim_fin_settle_invoice_detail_id：id
