get_stock_data: get stock data from BI database

In zyf19940501/ghzy: Ghzy R

Description

从BI数仓中获取库存数据 按照年、月、SHOP_NO,SKU_NO汇总

Usage

get_stock_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 包含门店库存和总仓库存 可由仓位类型区分

Examples

dt <- get_stock_data(con = con,brand_name = 'mujosh',stock_date = lubridate::today()-days(1),goods_categories = c('frame','sunglasses'),鍒嗘瀽澶х被,浠撲綅绫诲瀷)

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