/*
================================================================================
档案代号:abk_file
档案名称:费用分摊明细档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table abk_file
(
abk00       varchar2(1) NOT NULL,    /*性质                                   */
abk01       varchar2(10) NOT NULL,   /*费用编号                               */
abk02       number(5) NOT NULL,      /*项次                                   */
abk03       number(5) NOT NULL,      /*年度                                   */
abk04       number(5) NOT NULL,      /*月份                                   */
abk05       number(20,6),            /*金额                                   */
abk06       varchar2(16),            /*传票编号                               */
abk07       date,                    /*传票日期                               */
abk08       varchar2(16),            /*分录底稿单号                           */
abk09       varchar2(10),            /*处理人员                               */
abk10       varchar2(24)             /*科目编号                               */
);

create unique index abk_pk on abk_file (abk00,abk01,abk02,abk03,abk04);
alter table abk_file add  constraint abk_pk primary key  (abk00,abk01,abk02,abk03,abk04) enable validate;
grant select on abk_file to public;
grant index on abk_file to public;
grant update on abk_file to public;
grant delete on abk_file to public;
grant insert on abk_file to public;