/*
================================================================================
档案代号:xmc_file
档案名称:特卖产品价格单身档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table xmc_file
(
xmc01       varchar2(6) NOT NULL,    /*价格条件                               */
xmc02       varchar2(4) NOT NULL,    /*币别                                   */
xmc03       date NOT NULL,           /*生效日期                               */
xmc04       varchar2(10) NOT NULL,   /*客户编号                               */
xmc05       varchar2(6) NOT NULL,    /*收款条件                               */
xmc06       varchar2(40) NOT NULL,   /*料件编号                               */
xmc07       varchar2(4) NOT NULL,    /*单位                                   */
xmc08       number(20,6),            /*单价                                   */
xmc09       number(9,4)              /*折扣                                   */
);

create unique index xmc_pk on xmc_file (xmc01,xmc02,xmc03,xmc04,xmc05,xmc06,xmc07);
alter table xmc_file add  constraint xmc_pk primary key  (xmc01,xmc02,xmc03,xmc04,xmc05,xmc06,xmc07) enable 
validate;
grant select on xmc_file to public;
grant index on xmc_file to public;
grant update on xmc_file to public;
grant delete on xmc_file to public;
grant insert on xmc_file to public;