流程图
2023-11-09 00:30:30 4 举报
tms宽表业务关系图
作者其他创作
大纲/内容
运单任务明细transportschedulewaybilltaskdetailstswtd
1 :n
调拨明细表allocateitemsai
调拨出库
卡板表depotcardsdc
dmd.card_id=ai.card_id
分货卡板depotreplenishorderbatchstorecarddrobsc
n :1
n:1
tsw.schedule_plan_id=tsp.id
tlw.schedule_plan_id=tsp.id
pso.id=fpor.out_storage_order_id
tswds.waybill_id=tsw.id and tswds.store_id=tswtd.store_id_in
(spa.stock_out_id union all pt.out_stock_car_id)=tvr.out_stock_car_id and (ai.store_id_in union all pso.purchase_store_id)=tswtd.store_id_in
tvr.route_no=tvrd.route_no
tvrd.destination_store_id=tswtd.store_id_in
towc.id=tlw.wave_content_id
出库单明细processingoutstoragedetailspooi
商品出库
收获明细表arrivalreceivingitemari
物流波次transportlogisticwavestlw
波次门店配送时效outstockwavedeliveryagingowda
运单transportschedulewaybillstsw
1:n
调度计划transportscheduleplanstsp
配送任务表storedeliverytaskssdt
行程单明细transportlogisticplanwavedetailstvrd
出库任务单factoryproductionouttasksfpt
tswtd.waybill_task_id=tswt.id
调拨单storeproductallocationsspa
卡板日志表depotcardlogdcl
owda.content_id=towc.id and owda.store_id=tswtd.store_id_in and owda.has_delete=0 and owda.meta_type<>'DELETE'
drobs.id=drobsc.order_batch_store_id
dcl.card_id=ai.card_id
集货表depotreplenishorderbatchdrob
tswt.waybill_id=tsw.id
波次原因表transportlogisticplanwavereasontlpwr
tvr.waybill_task_id=tswt.id
1:1
drob.id=drobsc.order_batch_id
波次模版transportoutstockwavecontenttowc
fpor.out_task_id=fpt.id
tlpw.schedule_plan_id=tsp.id
分货表depotreplenishorderbatchstoredrobs
where relate_type=10 tlpwr.relate_id=tsp.idwhere relate_type=20 tlpwr.relate_id=tlpw.id
物流计划波次transportlogisticplanwavestlpw
ai.order_batch_store_id=drobsc.id
pso.id=pooi.out_storage_order_id
运单司机签到transportwaybilldriversignstswds
出库单processingoutstorageorderpso
卡板
ari.business_id=tvr.out_stock_car_id and ari.store_id=tswtd.store_id_in
内部销售单出库无卡板ID,无需关联卡板
内部销售单出库
行程单transportvehicleroutetvr
sdt.out_stock_car_id=tvr.out_stock_car_id and sdt.store_id_in=tswtd.store_id_in
出库任务与销售单关联关系表factoryproductionsellorderrelationfpor
1 :1
运单任务transportschedulewaybilltaskstswt
spa.id=ai.store_product_allocation_id
tlpw.logistics_node_id_out=tswt.logistics_node_id_out and tlpw.logistics_node_id_out<>''or (tlpw.store_id_out=tswt.store_id and tlpw.store_id_out<>''
卡板物料明细depotcardmaterialdetailsdmd
union all
物流
tlod.card_id=ai.card_id
卡板装车操作明细transportloadoperationdetailstlod
dc.id=ai.card_id
0 条评论
回复 删除
下一页