/*
================================================================================
档案代号:ofv_file
档案名称:佣金料件明细档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table ofv_file
(
ofv01       varchar2(10) NOT NULL,   /*佣金代号                               */
ofv02       varchar2(40) NOT NULL,   /*料件编号                               */
ofv03       varchar2(1),             /*计算基准                               */
                                     /*1.销售数量                             */
                                     /*2.销售金额                             */
                                     /*3.标准售价                             */
                                     /*4.利润                                 */
ofv04       number(12,3),            /*比率                                   */
ofv05       number(15,3),            /*基准一                                 */
ofv06       number(12,3),            /*比率一                                 */
ofv07       number(15,3),            /*基准二                                 */
ofv08       number(12,3),            /*比率二                                 */
ofv09       number(15,3),            /*基准三                                 */
ofv10       number(12,3),            /*比率三                                 */
ofv11       number(15,3),            /*基准四                                 */
ofv12       number(12,3),            /*比率四                                 */
ofv13       number(15,3),            /*基准五                                 */
ofv14       number(12,3),            /*比率五                                 */
ofvuser     varchar2(10),            /*资料所有者                             */
ofvgrup     varchar2(10),            /*资料所有群                             */
ofvmodu     varchar2(10),            /*资料更改者                             */
ofvdate     date                     /*最近修改日                             */
);

create unique index ofv_pk on ofv_file (ofv01,ofv02);
alter table ofv_file add  constraint ofv_pk primary key  (ofv01,ofv02) enable validate;
grant select on ofv_file to public;
grant index on ofv_file to public;
grant update on ofv_file to public;
grant delete on ofv_file to public;
grant insert on ofv_file to public;