market_createnew.sql

提供商业企业进销存、成本核算、销售人员工资考核结算、地区管理报表（特别是二维报表）

    profit           numeric(15,2),
    coefficient      numeric(15,2),
    slproportion     numeric(15,2),
    remark           varchar(20),
    acct_no          varchar(10),
    constraint pk_bill_det primary key (bill_no,id));

create  table  salary_settle
(
    settle_date        datetime         not null,
    settle_no          varchar(10)      not null ,
    operator         varchar(6),
    employee_code    varchar(3),
    employee         varchar(10),
    salary           numeric(15,2),          
    remark           varchar(30),
    charge_indicator tinyint,
    constraint pk_salary_mst primary key (settle_no));

insert into resource_dict(resource_code,resource_name)  
            values('01','采购入库')    ;

insert into resource_dict(resource_code,resource_name)  
            values('02','采购退货')    ;

insert into resource_dict(resource_code,resource_name)  
            values('03','盘点入库')    ;

insert into purpose_dict(purpose_code,purpose_name)
            values('01','销售出库')    ;

insert into purpose_dict(purpose_code,purpose_name)
            values('02','销售退货')    ;

insert into purpose_dict(purpose_code,purpose_name)
            values('03','盘点出库')    ;


insert into purpose_dict(purpose_code,purpose_name)
            values('04','调拔出库')    ;



insert into operator_dict(operator_code,operator_name,operator_right,operator_pwd,depart)
            values('01','sys','1','system','系统')    ;

insert into customer_dict(customer_code,input_code,customer_name)
            values('0000000001','lxkh','零售客户')     ;


create  table  cash_record
(
    cash_date        datetime         not null,
    cash_no          varchar(11)      not null ,
    unit_code        varchar(10) ,
    unit_name        varchar(40),
    operator         varchar(6),
    employee_code    varchar(3),
    employee         varchar(10),
    pay_way          varchar(2),
    money            numeric(15,2),
    remark           varchar(30),
    charge_indicator tinyint,
    constraint pk_cash_no primary key (cash_no));

create  table  pay_record
(
    pay_date        datetime         not null,
    pay_no          varchar(11)      not null ,
    unit_code        varchar(10) ,
    unit_name        varchar(40),
    operator         varchar(6),
    employee_code    varchar(3),
    employee         varchar(10),
    pay_way          varchar(2),
    money            numeric(15,2),
    remark           varchar(30),
    charge_indicator tinyint,
    constraint pk_pay_no primary key (pay_no));

create  table  achievement_record
(   
    id               varchar(9)     not null,
    acct             tinyint    ,
    stock_code       varchar(2) ,
    goods_code       varchar(9) ,
    target           numeric(15,2),
    proportion       numeric(15,2),
    value            numeric(15,2),
    remark           varchar(30));

create  table  qxgl
(   
    id               int          identity(1,1)  not null,
    userno           varchar(6) ,
    depart           varchar(20) ,
    qxmc             varchar(20)    not null
    );


insert into qxgl(userno,depart,qxmc)  
            values('01','系统','初始与设置')    ;
insert into qxgl(userno,depart,qxmc)  
            values('01','系统','仓库设置')    ;
insert into qxgl(userno,depart,qxmc)  
            values('01','系统','入库来源')    ;
insert into qxgl(userno,depart,qxmc)  
            values('01','系统','出库用途')    ;
insert into qxgl(userno,depart,qxmc)  
            values('01','系统','会计期设置')    ;


insert into qxgl(userno,depart,qxmc)  
            values('01','系统','基础数据维护')    ;
insert into qxgl(userno,depart,qxmc)  
            values('01','系统','客户维护')    ;
insert into qxgl(userno,depart,qxmc)  
            values('01','系统','供应商维护')    ;
insert into qxgl(userno,depart,qxmc)  
            values('01','系统','商品维护')    ;
insert into qxgl(userno,depart,qxmc)  
            values('01','系统','品名维护')    ;
insert into qxgl(userno,depart,qxmc)  
            values('01','系统','品牌维护')    ;
insert into qxgl(userno,depart,qxmc)  
            values('01','系统','类别维护')    ;
insert into qxgl(userno,depart,qxmc)  
            values('01','系统','规格维护')    ;
insert into qxgl(userno,depart,qxmc)  
            values('01','系统','商品明细维护')    ;
insert into qxgl(userno,depart,qxmc)  
            values('01','系统','业务员维护')    ;
insert into qxgl(userno,depart,qxmc)  
            values('01','系统','考核指标维护')    ;

insert into qxgl(userno,depart,qxmc)  
            values('01','系统','业务管理')    ;
insert into qxgl(userno,depart,qxmc)  
            values('01','系统','入库管理')    ;
insert into qxgl(userno,depart,qxmc)  
            values('01','系统','调拔管理')    ;
insert into qxgl(userno,depart,qxmc)  
            values('01','系统','出库管理')    ;
insert into qxgl(userno,depart,qxmc)  
            values('01','系统','公用功能')    ;
insert into qxgl(userno,depart,qxmc)  
            values('01','系统','期末处理')    ;
insert into qxgl(userno,depart,qxmc)  
            values('01','系统','工资结算')    ;

insert into qxgl(userno,depart,qxmc)  
            values('01','系统','应收应付管理')    ;
insert into qxgl(userno,depart,qxmc)  
            values('01','系统','收款单管理')    ;
insert into qxgl(userno,depart,qxmc)  
            values('01','系统','付款单管理')    ;
insert into qxgl(userno,depart,qxmc)  
            values('01','系统','应收款查询')    ;
insert into qxgl(userno,depart,qxmc)  
            values('01','系统','应付款查询')    ;


insert into qxgl(userno,depart,qxmc)  
            values('01','系统','月度报表')    ;
insert into qxgl(userno,depart,qxmc)  
            values('01','系统','库存月度统计表')        ;
insert into qxgl(userno,depart,qxmc)  
            values('01','系统','业务分类月度统计表')    ;
insert into qxgl(userno,depart,qxmc)  
            values('01','系统','销售分析表')            ;
insert into qxgl(userno,depart,qxmc)  
            values('01','系统','销售指标完成情况表')    ;


insert into qxgl(userno,depart,qxmc)  
            values('01','系统','明细表')    ;
insert into qxgl(userno,depart,qxmc)  
            values('01','系统','单据明细查询')    ;
insert into qxgl(userno,depart,qxmc)  
            values('01','系统','工资查询')    ;
insert into qxgl(userno,depart,qxmc)  
            values('01','系统','库存结存日报表')    ;
insert into qxgl(userno,depart,qxmc)  
            values('01','系统','各部门销售明细汇总')    ;
insert into qxgl(userno,depart,qxmc)  
            values('01','系统','销售按日汇总分析表')    ;
insert into qxgl(userno,depart,qxmc)  
            values('01','系统','非零售地区汇总分析表')    ;
insert into qxgl(userno,depart,qxmc)  
            values('01','系统','销售单据按地区分析表')    ;
insert into qxgl(userno,depart,qxmc)  
            values('01','系统','库存总仓库结存日报表')    ;

insert into qxgl(userno,depart,qxmc)  
            values('01','系统','操作员维护')    ;
insert into qxgl(userno,depart,qxmc)  
            values('01','系统','数据备份')    ;
insert into qxgl(userno,depart,qxmc)  
            values('01','系统','员工关怀')    ;
insert into qxgl(userno,depart,qxmc)  
            values('01','系统','修改密码')    ;
insert into qxgl(userno,depart,qxmc)  
            values('01','系统','会计期结转')    ;
insert into qxgl(userno,depart,qxmc)  
            values('01','系统','退出')    ;