/*
================================================================================
档案代号:xme_file
档案名称:产品价格单头档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table xme_file
(
xme01       varchar2(6) NOT NULL,    /*价格条件编号                           */
xme02       varchar2(4) NOT NULL,    /*币别                                   */
xme03       number(5),               /*No Use                                 */
xme04       date,                    /*No Use                                 */
xme05       varchar2(10),            /*No Use                                 */
xme06       varchar2(255),           /*备注                                   */
xmeuser     varchar2(10),            /*资料所有者                             */
xmegrup     varchar2(10),            /*资料所有部门                           */
xmemodu     varchar2(10),            /*资料修改者                             */
xmedate     date                     /*最近修改日                             */
);

create unique index xme_pk on xme_file (xme01,xme02);
alter table xme_file add  constraint xme_pk primary key  (xme01,xme02) enable validate;
grant select on xme_file to public;
grant index on xme_file to public;
grant update on xme_file to public;
grant delete on xme_file to public;
grant insert on xme_file to public;