Class 类别编码
[class_code] [char] (3) 类别代码 (PRIMARY)
[class_name] [char] (10) 类别名称
customer 客户表
[cus_code] [char] (6) 客户代码( PRIMARY)
[cus_name] [char] (20) 客户名称
[cus_add] [char] (60) 客户地址
[cus_post] [char] (6) 邮编
[cus_manager] [char] (10) 联系人
[cus_phone_a] [char] (13) 联系电话 1
[cus_phone_b] [char] (13) 联系电话 2
detail_account 明细表
[plu_no] [char] (8) 流水号(PRIMARY)
[bill_code] [char] (8) 单据号
[bill_type] [char] (1) 单据类型
[plu_code] [char] (8) 商品代码
[plu_name] [char] (20) 商品名称
[plu_qty] [float] 发生数量
[plu_amt] [decimal](18, 2) 发生金额
[book_date] [datetime] 发生日期,
[stock_qty] [float] 库存数量
[stock_amt] [decimal](18, 2) 库存金额
employee 用户表
[empl_code] [char] (4) 用户工号(PRIMARY)
[empl_name] [char] (10) 用户名称
[empl_pass] [char] (6) 用户密码
[empl_level] [char] (1) 用户级别
[note] [char] (20) 备注
income_det 入库明细表
[bill_code] [char] (8) 单据号(PRIMARY)
[plu_code] [char] (8) 商品代码
[plu_name] [char] (20) 商品名称
[price] [decimal](18, 2) 价格
[sup_code] [char] (6) 供应商代码
[income_qty] [float] 进货数量
[income_amt] [decimal](18, 2) 进货金额
[spare_qty] [float] 剩余数量
[spare_amt] [decimal](18, 2)剩余金额
income_mst 入库总表
评论3