/*
================================================================================
档案代号:xmd_file
档案名称:特卖产品数量价格折扣档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table xmd_file
(
xmd01       varchar2(6) NOT NULL,    /*价格条件                               */
xmd02       varchar2(4) NOT NULL,    /*币别                                   */
xmd03       date NOT NULL,           /*生效日期                               */
xmd04       varchar2(10) NOT NULL,   /*客户编号                               */
xmd05       varchar2(6) NOT NULL,    /*收款条件                               */
xmd06       varchar2(40) NOT NULL,   /*料件编号                               */
xmd07       varchar2(4) NOT NULL,    /*单位                                   */
xmd08       number(15,6) NOT NULL,   /*最低数量                               */
xmd09       number(9,4)              /*折扣                                   */
);

create unique index xmd_pk on xmd_file (xmd01,xmd02,xmd03,xmd04,xmd05,xmd06,xmd07,xmd08);
alter table xmd_file add  constraint xmd_pk primary key  (xmd01,xmd02,xmd03,xmd04,xmd05,xmd06,xmd07,xmd08) 
enable validate;
grant select on xmd_file to public;
grant index on xmd_file to public;
grant update on xmd_file to public;
grant delete on xmd_file to public;
grant insert on xmd_file to public;