/*
================================================================================
档案代号:idi_file
档案名称:ICD发票资料转入作业单头档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table idi_file
(
idi01       varchar2(10) DEFAULT '' NOT NULL, /*厂商编号*/
idi02       varchar2(10) DEFAULT '' NOT NULL, /*厂别*/
idi03       varchar2(255),           /*档案存放位置                           */
idi04       varchar2(1),             /*no use                                 */
idi05       varchar2(1),             /*栏位分隔符号                           */
                                     /*0.TAB 1.分号                           */
idi07       varchar2(1),             /*no use                                 */
idi08       number(5),               /*序号                                   */
idi09       varchar2(1),             /*no use                                 */
idi10       varchar2(1),             /*no use                                 */
idi11       varchar2(1),             /*no use                                 */
idi12       varchar2(1),             /*no use                                 */
idi13       varchar2(1),             /*no use                                 */
idi14       varchar2(1),             /*no use                                 */
idi15       varchar2(1)              /*no use                                 */
);

create unique index idi_pk on idi_file (idi01,idi02);
alter table idi_file add  constraint idi_pk primary key  (idi01,idi02) enable validate;
grant select on idi_file to public;
grant index on idi_file to public;
grant update on idi_file to public;
grant delete on idi_file to public;
grant insert on idi_file to public;