业务需求
CreatedBy158
需求描述
根据一下sql代码,传参,输出数据接口
SELECT DISTINCT
a.OrderSourceId as 店铺id,
a.Sku,
a.sellersku,
a.Inventoryid as fnsku,
a.SiteProductId,
b.LogisticType as 业务类型,
a.Quantity as 官方库存
FROM
m_mercadolibre_listing_sub_fulfillment AS a
LEFT JOIN ( SELECT DISTINCT OrderSourceId, Sku, SiteProductId, LogisticType FROM m_mercadolibre_listing_site_fulfillment ) AS b
ON a.OrderSourceId = b.OrderSourceId
AND a.SiteProductId = b.SiteProductId
where b.LogisticType = fulfillment
and (a.Inventoryid is not null and a.Inventoryid != )
验收标准
158Create
价值描述
预计节约:3 人1天节省1小时,一月节省24小时+, 价值量:600*3*1/8*24=5400RMB/月
满意度:非常满意
价值验收:完全达成
原因备注:无