get_store_inventory_data: get store inventory from BI database

Description Usage Arguments Value Examples

View source: R/get-store-inventory.R

Description

get store inventory from BI database

Usage

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
get_store_inventory_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

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

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