/*
================================================================================
档案代号:pmw_file
档案名称:采购料件询价单头档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table pmw_file
(
pmw01       varchar2(16) NOT NULL,   /*询价单号                               */
pmw03       varchar2(10),            /*供应厂商编号                           */
pmw04       varchar2(4),             /*交易币别                               */
pmw06       date,                    /*询价日期                               */
pmwacti     varchar2(1),             /*资料有效码                             */
                                     /*资料有效码(Y/N)                        */
pmwuser     varchar2(10),            /*资料所有者                             */
pmwgrup     varchar2(10),            /*资料所有部门                           */
pmwmodu     varchar2(10),            /*资料修改者                             */
pmwdate     date,                    /*最近修改日                             */
pmw05       varchar2(4),             /*税别                                   */
pmw051      number(9,4)              /*税率                                   */
);

create unique index pmw_pk on pmw_file (pmw01);
alter table pmw_file add  constraint pmw_pk primary key  (pmw01) enable validate;
grant select on pmw_file to public;
grant index on pmw_file to public;
grant update on pmw_file to public;
grant delete on pmw_file to public;
grant insert on pmw_file to public;