/*
================================================================================
档案代号:abl_file
档案名称:预付暨递延费用基本资料单头档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table abl_file
(
abl00       varchar2(1) NOT NULL,    /*性质                                   */
abl01       varchar2(10) NOT NULL,   /*费用编号                               */
abl02       date,                    /*发生日期                               */
abl03       varchar2(1),             /*分摊方式                               */
abl04       varchar2(1),             /*开始摊                                 */
abl04a      date,                    /*开始摊日期                             */
abl05       varchar2(1),             /*抛传票                                 */
abl06       date,                    /*摊提期间                               */
                                     /*摊提期间(起始)                         */
abl07       date,                    /*摊提期间                               */
                                     /*摊提期间(截止)                         */
abl08       number(5),               /*天数                                   */
abl09       varchar2(10),            /*处理人员                               */
abl10       number(20,6),            /*费用总额                               */
abl11       number(20,6),            /*已摊金额                               */
abl12       varchar2(10),            /*部门                                   */
ablconf     varchar2(1),             /*确认码                                 */
ablacti     varchar2(1),             /*资料有效码                             */
abluser     varchar2(10),            /*资料所有者                             */
ablgrup     varchar2(10),            /*资料所有群                             */
ablmodu     varchar2(10),            /*资料更改者                             */
abldate     date                     /*最近修改日                             */
);

create unique index abl_pk on abl_file (abl00,abl01);
alter table abl_file add  constraint abl_pk primary key  (abl00,abl01) enable validate;
grant select on abl_file to public;
grant index on abl_file to public;
grant update on abl_file to public;
grant delete on abl_file to public;
grant insert on abl_file to public;