/*
================================================================================
档案代号:stl_file
档案名称:销售量值统计档--By 产品别
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table stl_file
(
stl01       number(5) NOT NULL,      /*年度                                   */
stl02       number(5) NOT NULL,      /*月份                                   */
stl03       varchar2(10) NOT NULL,   /*产品别                                 */
stl04       number(15,3),            /*销售数量                               */
stl05       number(20,6),            /*销售金额                               */
stl06       number(20,6),            /*销售成本                               */
stl07       number(15,3),            /*销退数量                               */
stl08       number(20,6),            /*销退金额                               */
stl09       number(20,6)             /*销退成本                               */
);

create unique index stl_pk on stl_file (stl01,stl02,stl03);
alter table stl_file add  constraint stl_pk primary key  (stl01,stl02,stl03) enable validate;
grant select on stl_file to public;
grant index on stl_file to public;
grant update on stl_file to public;
grant delete on stl_file to public;
grant insert on stl_file to public;