get_purchase_data: get purchase stock data from BI database

In zyf19940501/ghzy: Ghzy R

Description

采购入库数据

Usage

get_purchase_data(
  con,
  ...,
  start_date,
  end_date,
  brand_name,
  channel_type = NULL,
  area_name = NULL,
  boss_name = NULL,
  shop_no = NULL,
  category_name = NULL
)

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

Value

a data.frame

Examples

get_inventory_shipment_data(con = con,SKU_NO,brand_name = c('mujosh','aj'),
start_date = '2020-10-10',end_date = '2020-10-31',category = c("frame","sunglasses"))
get_purchase_data(con,SHOP_NO,brand_name = 'brand',start_date = '2021-01-01',end_date = '2021-01-10',category_name = 'frame')

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