库内盘点ER图

inv_relate_inventory盘点明细库存映射

id：库存映射IDwarehouse_id：仓库IDobj_id：映射IDobj_type：映射对象sku_code：商品编码sku_qty：商品数量lot_no：批次号inventory_id：库存记录ID......

id:obj_id = 1:1

inv_stocktake_batch盘点批次

id：盘点批次IDwarehouse_id：仓库IDstocktake_plan_id：盘点计划IDstocktake_plan_business_no：盘点计划编码stocktake_plan_type：盘点单类型stocktake_batch_no：盘点批次号begin_time：开始时间end_time：完成时间status：盘点批次状态is_report_generated：盘点报告是否已生成category_ids：商品大类列表......

inv_stocktake盘点单

id：盘点单IDwarehouse_id：仓库IDbusiness_no：盘点单号stocktake_plan_type：盘点计划类型stocktake_plan_id：盘点计划IDstocktake_plan_business_no：盘点计划编码source_no：来源单号must_second_count_flag：是否强制复盘stocktake_batch_no：盘点批次号......

id:stocktake_id = 1:n

stocktake_batch_no:stocktake_batch_no = 1:n

id:stocktake_detail_id = 1:n

id : stocktake_plan_id = 1:n

inv_stocktake_detail_update_log盘点明细数量修改日志

id：盘点单IDwarehouse_id：仓库IDstocktake_detail_id：盘点明细IDfield：字段update_type：操作类型value_before：更改前数值value_after：更改后数值updated_at：修改时间updated_by：修改人......

stocktake_batch_no:stocktake_batch_no = n:1

inv_stocktake_plan_msc_condition盘点计划强制复盘条件明细

id：复盘条件IDwarehouse_id：仓库IDpriority：行号(优先级)operator_type：逻辑运算符condition_key：条件列condition_value：条件值relation_type：关系类型(且/或)......

inv_stocktake_plan盘点计划

id：盘点计划IDwarehouse_id：仓库IDbusiness_no：盘点计划编码plan_type：盘点计划类型status：盘点计划状态is_sku_filter：是否通过商品筛选sku_filter_id：商品筛选器IDis_location_filter：是否通过储位筛选blind_flag：是否盲盘real_time_inventory：是否盘点实时库存include_flag：是否包含零库存timer_corn：定时器表达式must_second_count_flag：是否强制复盘......

inv_stocktake_detail盘点明细

id：盘点单IDwarehouse_id：仓库IDstocktake_id：盘点单IDstatus：盘点明细状态location_code：储位编码sku_code：商品编码lot_no：批次号first_stock_price：初盘金额first_qty_expect：账面库存first_qty_actual：盘点数量first_qty_diff：盘点差异first_stock_diff_price：盘点差异金额first_begin_time：盘点开始时间first_end_time：盘点结束时间shelf_code：货架号stocktake_batch_no：盘点批次号must_second_count_flag：是否强制复盘......