eBusiness数据字典

百胜 ERP3_系统数据字典

目录

百胜 ERP3_系统数据字典................................................................................................................1

1 引言..................................................................................................................................................8

1.1 编写目的...................................................................................................................................8

1.2 范围...........................................................................................................................................8

1.3 定义...........................................................................................................................................8

2.5 管理员操作日志表.................................................................................................................11

3 权限................................................................................................................................................12

3.1 功能模块列表.........................................................................................................................12

3.2 角色.........................................................................................................................................12

3.3 角色功能分配表.....................................................................................................................13

3.4 用户角色分配表.....................................................................................................................13

4 SESSION 管理..............................................................................................................................13

4.1 SESSION 记录表...................................................................................................................13

4.2 SESSION 数据.......................................................................................................................14

5 系统设置........................................................................................................................................15

5.7 配送地区的快递价格的地区分布.........................................................................................19

5.8 配送方式中的不可到达地区设定.........................................................................................19

5.9 系统参数配置.........................................................................................................................20

6 商品属性........................................................................................................................................21

6.1 颜色.........................................................................................................................................21

6.2 商品颜色表.............................................................................................................................21

6.3 尺码.........................................................................................................................................22

6.4 商品尺码表.............................................................................................................................22

6.5 商品分类.................................................................................................................................23

6.6 品牌.........................................................................................................................................24

7.2 商品外部网店 ID 关联表.......................................................................................................30

7.3 商品店铺类目关联表.............................................................................................................31

7.4 商品条码标签信息维护表.....................................................................................................31

7.5 商品条码表.............................................................................................................................32

7.6 商品套餐.................................................................................................................................32

7.7 商品套餐颜色.........................................................................................................................32

7.8 商品套餐尺码.........................................................................................................................33

7.9 商品套餐详细.........................................................................................................................33

7.10 商品套餐详细颜色匹对.......................................................................................................33

7.11 商品套餐详细尺码匹对.......................................................................................................34

7.12 店铺类目表...........................................................................................................................34

8.5 客户.........................................................................................................................................37

8.6 商店.........................................................................................................................................38

8.7 商店 API 接口参数设定........................................................................................................40

8.8 快递公司.................................................................................................................................41

9 商品库存........................................................................................................................................43

9.1 商品库存表.............................................................................................................................43

9.2 商品库存明细位置表.............................................................................................................44

10.5 商品进货单...........................................................................................................................51

10.6 商品进货规格明细...............................................................................................................53

11 批发管理......................................................................................................................................54

11.1 批发销货订单.......................................................................................................................54

11.2 批发销货订单规格明细.......................................................................................................56

11.3 批发销货单...........................................................................................................................57

11.4 批发销货规格明细...............................................................................................................58

11.5 批发退货单 (同批发)...........................................................................................................59

11.6 批发退货单规格明细 (同批发)...........................................................................................59

12 销售订单管理..............................................................................................................................60

12.1 销售订单主信息...................................................................................................................60

12.8 退单的商品信息...................................................................................................................74

12.9 退单的换货商品...................................................................................................................75

12.10 销售退单操作日志表.........................................................................................................76

12.11 单据日志.............................................................................................................................77

12.15 销售业绩设置.....................................................................................................................80

12.16 客服业绩设置.....................................................................................................................80

13 发货管理......................................................................................................................................81

13.5 零售发货单...........................................................................................................................85

14 拍拍交易......................................................................................................................................90

14.1 拍拍交易记录订单详情.......................................................................................................90

14.2 拍拍交易记录订单商品详情...............................................................................................94

14.3 拍拍库存中间表...................................................................................................................95

15 淘宝交易......................................................................................................................................95

16 OS 交易......................................................................................................................................106

16.1 OS 交易记录订单详情.......................................................................................................106

16.2 OS 交易记录订单商品详情..............................................................................................107

17 会员资料....................................................................................................................................108

17.1 用户等级.............................................................................................................................108

17.2 用户资料.............................................................................................................................108

17.3 会员店铺表.........................................................................................................................111

17.4 调查问卷.............................................................................................................................111

17.5 用户调查.............................................................................................................................112

17.6 用户资金表.........................................................................................................................113

18.4 仓库调整单规格明细.........................................................................................................119

18.5 仓库盘点单.........................................................................................................................120

18.6 仓库盘点单规格明细.........................................................................................................121

18.7 库存盈亏单.........................................................................................................................122

18.8 库存盈亏单规格明细.........................................................................................................123

18.9 商店库存分配单.................................................................................................................124

18.10 商店库存分配单明细.......................................................................................................125