/*
================================================================================
档案代号:pmb_file
档案名称:多帐期付款条件关联设定档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table pmb_file
(
pmb01       varchar2(10) NOT NULL,   /*请购单号                               */
pmb02       varchar2(1),             /*项次                                   */
                                     /*1-依比率 2-自定义                      */
pmb03       number(5) NOT NULL,      /*供应厂商                               */
pmb04       varchar2(10),            /*厂牌                                   */
pmb05       number(9,4),             /*采购单位                               */
pmb06       varchar2(15),            /*币别                                   */
pmb07       varchar2(8),             /*单价                                   */
pmbacti     varchar2(1),             /*资料有效码                             */
pmbuser     varchar2(10),            /*资料业主                               */
pmbgrup     varchar2(10),            /*资料所有部门                           */
pmbmodu     varchar2(10),            /*资料修改者                             */
pmbdate     date                     /*最后修改日期                           */
);

create unique index pmb_pk on pmb_file (pmb01,pmb03);
alter table pmb_file add  constraint pmb_pk primary key  (pmb01,pmb03) enable validate;
grant select on pmb_file to public;
grant index on pmb_file to public;
grant update on pmb_file to public;
grant delete on pmb_file to public;
grant insert on pmb_file to public;