get_total_warehouse_data: get total warehouse inventory from BI database

In zyf19940501/ghzy: Ghzy R

Description

get total warehouse inventory from BI database

Usage

get_total_warehouse_data(
  con,
  ...,
  brand_name,
  channel_type = NULL,
  area_name = NULL,
  boss_name = NULL,
  shop_no = NULL,
  stock_date = Sys.Date() - 1,
  category_name = c("镜架", "太阳镜")
)

Arguments

con	BI con connector
...	需要添加汇总字段,默认年,月,SHOP_NO,SKU_NO
brand_name	事业部名称
channel_type	门店渠道
area_name	管辖区域
boss_name	加盟商客户
shop_no	the shop of Number
stock_date	库存日期 默认昨天
category_name	分析大类

Value

a data frame total warehouse

Examples

dt <- get_total_warehouse_data(con = con,SHOP_NO,brand_name = 'mujosh',stock_date = lubridate::today()-days(1),goods_categories = c('lens'),SHOP_NO)

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