/*
================================================================================
档案代号:osy_file
档案名称:销售分析系统单据性质档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table osy_file
(
osyslip     varchar2(5) NOT NULL,    /*单别                                   */
osydesc     varchar2(80),            /*单据名称                               */
osyauno     varchar2(1),             /*自动编号否                             */
                                     /*自动编号否 (Y/N)                       */
osymxno     varchar2(16),            /*已用单号                               */
osytype     varchar2(2),             /*单据性质                               */
                                     /*  1.订单                               */
                                     /*  2.出货                               */
osydmy1     varchar2(1)              /*编号方式                               */
                                     /*编号方式1.流水号 2.年月                */
);

create unique index osy_pk on osy_file (osyslip);
alter table osy_file add  constraint osy_pk primary key  (osyslip) enable validate;
grant select on osy_file to public;
grant index on osy_file to public;
grant update on osy_file to public;
grant delete on osy_file to public;
grant insert on osy_file to public;