/*
================================================================================
档案代号:tqv_file
档案名称:现金折扣单折扣明细档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table tqv_file
(
tqv01       varchar2(16) DEFAULT '' NOT NULL, /*现金折扣单号*/
tqv02       number(5) DEFAULT '0' NOT NULL, /*项次*/
tqv03       number(5) DEFAULT '0' NOT NULL, /*来源合同折扣条件项次*/
tqv04       varchar2(10),            /*费用代号                               */
tqv05       number(20,6),            /*折扣金额                               */
tqv06       varchar2(1),             /*预提否,y/n                             */
tqv07       varchar2(100)            /*说明                                   */
);

create unique index tqv_pk on tqv_file (tqv01,tqv02);
alter table tqv_file add  constraint tqv_pk primary key  (tqv01,tqv02) enable validate;
grant select on tqv_file to public;
grant index on tqv_file to public;
grant update on tqv_file to public;
grant delete on tqv_file to public;
grant insert on tqv_file to public;