/*
================================================================================
档案代号:tsa_file
档案名称:提案明细资料档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table tsa_file
(
tsa01       varchar2(16) NOT NULL,   /*提案单号                               */
tsa02       number(5) NOT NULL,      /*客户项次                               */
tsa03       number(5) NOT NULL,      /*产品项次                               */
tsa04       number(15,3),            /*目标数量                               */
tsa05       number(20,6),            /*目标未税金额                           */
tsa06       number(15,3),            /*No Use                                 */
tsa07       number(20,6),            /*No Use                                 */
tsa08       number(20,6),            /*目标含税金额                           */
tsa09       number(20,6)             /*No Use                                 */
);

create unique index tsa_pk on tsa_file (tsa01,tsa02,tsa03);
alter table tsa_file add  constraint tsa_pk primary key  (tsa01,tsa02,tsa03) enable validate;
grant select on tsa_file to public;
grant index on tsa_file to public;
grant update on tsa_file to public;
grant delete on tsa_file to public;
grant insert on tsa_file to public;