/*
================================================================================
档案代号:obd_file
档案名称:集团间销售预测单身档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table obd_file
(
obd01       varchar2(40) NOT NULL,   /*料件编号                               */
obd02       varchar2(1) NOT NULL,    /*计划期别格式                           */
obd021      number(10) NOT NULL,     /*起始期别                               */
obd03       number(5) NOT NULL,      /*序号                                   */
obd04       number(10),              /*计划期别                               */
obd05       varchar2(1),             /*No Use                                 */
obd06       number(20,6),            /*单价                                   */
obd07       number(20,6),            /*金额                                   */
obd08       number(15,3),            /*本阶需求量                             */
obd09       number(15,3),            /*本阶调整量                             */
obd10       number(15,3),            /*下阶需求量                             */
obd11       number(15,3),            /*下阶调整量                             */
obd12       number(15,3),            /*小计                                   */
obd13       varchar2(1),             /*No                                     */
obd14       varchar2(1),             /*No                                     */
obdconf     varchar2(1)              /*确认                                   */
);

create unique index obd_pk on obd_file (obd01,obd02,obd021,obd03);
alter table obd_file add  constraint obd_pk primary key  (obd01,obd02,obd021,obd03) enable validate;
grant select on obd_file to public;
grant index on obd_file to public;
grant update on obd_file to public;
grant delete on obd_file to public;
grant insert on obd_file to public;