get_inventory_shipment_data: get warehouse shipment data from BI database

In zyf19940501/ghzy: Ghzy R

Description

get warehouse shipment data from BI database

Usage

get_inventory_shipment_data(
  con,
  ...,
  start_date,
  end_date,
  brand_name,
  channel_type = NULL,
  area_name = NULL,
  boss_name = NULL,
  shop_no = NULL,
  category_name = NULL,
  WBSTK = "C"
)

Arguments

con	BI connector
...	汇总字段 可以按照 SHOP_NO,SKU_NO,年,月等
start_date	数据开始日期
end_date	数据结束日期
brand_name	事业部名称
channel_type	门店渠道
area_name	管辖区域
boss_name	加盟商客户
shop_no	the shop of Number
category_name	the category name of goods
WBSTK	发货状态 默认为已经处理完成

Details

出货数据包含 "加盟期货发货单", "加盟现货发货单", "直营调拨发货单","直发订单发货单",'加盟政策性发货单','加盟退货收货单' '加盟免费发货单'等单据

YH_NO 要货单号,WBSTK 发货状态,默认为已经处理完成 当需要添加字段时可用BILL_TYPE 字段，其余门店属性商品属性自行添加

Value

total warehouse shipment data.frame

Examples

get_inventory_shipment_data(
  con = con, BILL_TYPE, brand_name = "mujosh",
  start_date = "2020-10-10", end_date = "2020-10-31", category = c("frame", "sunglasses")
)

zyf19940501/ghzy documentation built on Dec. 23, 2021, 10:13 p.m.