/*
================================================================================
档案代号:tqe_file
档案名称:销售理由码档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table tqe_file
(
tqe01       varchar2(10) NOT NULL,   /*原因代码                               */
tqe02       varchar2(80),            /*原因描述                               */
tqe03       varchar2(1),             /*用途                                   */
tqe04       varchar2(1),             /*是否是搭赠                             */
tqe05       varchar2(1),             /*是否计算业绩                           */
tqe06       varchar2(24),            /*财务科目代号                           */
tqe07       varchar2(24),            /*管理科目代号                           */
tqe08       varchar2(1),             /*是否是拒收                             */
tqe09       varchar2(80),            /*财务科目摘要                           */
tqe10       varchar2(80),            /*管理科目摘要                           */
tqe11       varchar2(1),             /*是否影响呆滞日期                       */
tqe12       varchar2(1),             /*帮助促进对象                           */
tqeacti     varchar2(1),             /*资料有效码                             */
tqeuser     varchar2(10),            /*资料所有者                             */
tqegrup     varchar2(10),            /*资料所有部门                           */
tqemodu     varchar2(10),            /*资料修改者                             */
tqedate     date                     /*最近修改日                             */
);

create unique index tqe_pk on tqe_file (tqe01);
alter table tqe_file add  constraint tqe_pk primary key  (tqe01) enable validate;
grant select on tqe_file to public;
grant index on tqe_file to public;
grant update on tqe_file to public;
grant delete on tqe_file to public;
grant insert on tqe_file to public;