/*
================================================================================
档案代号:isd_file
档案名称:销项发票汇入历史记录单身档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table isd_file
(
isd00       varchar2(1) NOT NULL,    /*0.已开发票  1.作废发票                 */
isd01       varchar2(16) NOT NULL,   /*发票号码                               */
isd02       varchar2(16) NOT NULL,   /*单据号码                               */
isd03       varchar2(80) NOT NULL,   /*货物名称                               */
isd04       varchar2(120),           /*规格                                   */
isd05       varchar2(6),             /*单位                                   */
isd06       number(16,6),            /*数量                                   */
isd07       number(20,6),            /*金额                                   */
isd08       varchar2(5),             /*商品类别                               */
isd09       varchar2(1)              /*标志位                                 */
);

create unique index isd_pk on isd_file (isd01,isd02,isd03,isd00);
alter table isd_file add  constraint isd_pk primary key  (isd01,isd02,isd03,isd00) enable validate;
grant select on isd_file to public;
grant index on isd_file to public;
grant update on isd_file to public;
grant delete on isd_file to public;
grant insert on isd_file to public;