/*
================================================================================
档案代号:can_file
档案名称:当月销货收入金额调整资料
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table can_file
(
can01       varchar2(40) NOT NULL,   /*料号                                   */
can02       number(5) NOT NULL,      /*年度                                   */
can03       number(5) NOT NULL,      /*月份                                   */
can04       varchar2(16) NOT NULL,   /*参考单号                               */
can05       varchar2(255),           /*备注                                   */
can06       number(20,6) NOT NULL,   /*当月销货收入调整金额                   */
can07       varchar2(1),             /*No Use                                 */
can08       varchar2(1),             /*No Use                                 */
can09       varchar2(1),             /*No Use                                 */
can10       varchar2(1),             /*No Use                                 */
canacti     varchar2(1),             /*资料有效码                             */
canuser     varchar2(10),            /*资料所有者                             */
cangrup     varchar2(10),            /*资料所有部门                           */
canmodu     varchar2(10),            /*资料修改者                             */
candate     date                     /*最近修改日                             */
);

create unique index can_pk on can_file (can01,can02,can03,can04);
alter table can_file add  constraint can_pk primary key  (can01,can02,can03,can04) enable validate;
grant select on can_file to public;
grant index on can_file to public;
grant update on can_file to public;
grant delete on can_file to public;
grant insert on can_file to public;