/*
================================================================================
档案代号:ayc_file
档案名称:股东权益传票明细群组归属档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table ayc_file
(
ayc01       varchar2(10) NOT NULL,   /*公司编号                               */
ayc02       varchar2(5) NOT NULL,    /*帐别                                   */
ayc03       varchar2(4) NOT NULL,    /*币别                                   */
ayc04       number(5) NOT NULL,      /*年度                                   */
ayc05       number(5) NOT NULL,      /*期别                                   */
ayc06       date NOT NULL,           /*传票日期                               */
ayc07       varchar2(16) NOT NULL,   /*传票编号                               */
ayc08       number(10) NOT NULL,     /*项次                                   */
ayc09       varchar2(80),            /*摘要                                   */
ayc10       varchar2(24),            /*会计科目                               */
ayc11       varchar2(1),             /*借贷方                                 */
ayc12       number(20,6),            /*金额                                   */
ayc13       varchar2(10)             /*群组分类                               */
);

create unique index ayc_pk on ayc_file (ayc01,ayc02,ayc03,ayc04,ayc05,ayc06,ayc07,ayc08);
alter table ayc_file add  constraint ayc_pk primary key  (ayc01,ayc02,ayc03,ayc04,ayc05,ayc06,ayc07,ayc08) 
enable validate;
grant select on ayc_file to public;
grant index on ayc_file to public;
grant update on ayc_file to public;
grant delete on ayc_file to public;
grant insert on ayc_file to public;