xxxxxtable

create table t_PriceSetting
(
 f_RowId int identity(1,1),
 f_ClientId int ,
 f_ProductId int,
 f_Price,
 f_Desc
)

create table t_InCome
(
 f_RowId int identity(1,1),
 f_ClientId int,
 f_Type int,
 f_Money float,
 f_Date datetime,
 f_Oprator int
 f_Desc varchar(100)
)

create table t_InComeType --支付，预付
(
 f_RowId int identity(1,1),
 f_TypeName varchar(50)
 f_Desc varchar(50)
)

create table t_CashActiveHistory
(
 f_RowId int identity(1,1),
 f_Type int ,
 f_Money float,
 f_Proposer int,
 f_InvoiceNo varchar(100),
 f_Desc varchar(200),
 f_Operator int,
 f_Status int,
 f_ApplyDate datetime,
 f_CheckDate datetime
)

create table t_CashActiveType--油费,汽车修理费,餐费,
(
 f_RowId int identity(1,1),
 f_TypeName varchar(50),
 f_Desc varchar(100)
)

create table t_StaffJCHistory
(
 f_RowId int identity(1,1),
 f_JCType int ,
 f_Staff int,
 f_Desc varchar(200),
 f_Status int,
 f_RecoDate datetime,
 f_CheckTime datetime,
 f_Operator int
)

create table t_JC --奖励，惩罚
(
 f_RowId int identity(1,1),
 f_TypeName int,
 f_Desc varchar(100)
)

create table t_StaffLeave
(
  f_RowId int identity(1,1),
  f_Staff int ,
  f_DateStart datetime,
  f_DateEnd datetime,
  f_Money float,
  f_Status float,
  f_CheckDate datetime,
  f_Operator int,
  f_OperatDate datetime
)

create table t_CheckStatus --审批中，审批通过，不通过
(
 f_RowId int identity(1,1),
 f_Type varchar(20),
 f_Desc varchar(100)
)

create table t_KuCun
(
  f_RowId int identity(1,1),
  f_Date datetime,
  f_ProductId int,
  f_Total float,
  f_Provide varchar(100),
  f_TotalMoney float,
  f_Pay float,
  f_Operator int,
  f_Desc varchar(200)
)

--定价表
--交易明细
客户名称,片区,地址,所定产品,数量,交易金额,
--派送汇总
派送员,各种产品派送量,超过5楼的.