/*
================================================================================
档案代号:cns_file
档案名称:新贸加工合同核销单头档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table cns_file
(
cns00       varchar2(16) NOT NULL,   /*核销单号                               */
                                     /*核销单号    NO.A087                    */
cns01       varchar2(20),            /*核销手册编号                           */
                                     /* No:BUG-490398                         */
cns02       varchar2(20),            /*转入手册编号                           */
                                     /*No:BUG-490398                          */
cns03       date,                    /*核销日期                               */
cns04       varchar2(1),             /*No Use                                 */
cnsconf     varchar2(1),             /*确认码                                 */
cnsacti     varchar2(1),             /*资料有效码                             */
cnsuser     varchar2(10),            /*资料所有者                             */
cnsgrup     varchar2(10),            /*资料所有部门                           */
cnsmodu     varchar2(10),            /*资料修改者                             */
cnsdate     date                     /*最近修改日                             */
);

create unique index cns_02 on cns_file (cns01);
create unique index cns_pk on cns_file (cns00);
alter table cns_file add  constraint cns_pk primary key  (cns00) enable validate;
grant select on cns_file to public;
grant index on cns_file to public;
grant update on cns_file to public;
grant delete on cns_file to public;
grant insert on cns_file to public;