/* ================================================================================ 档案代号: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; |