/*
================================================================================
档案代号:ahi_file
档案名称:利润中心内部定价档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table ahi_file
(
ahi01       number(5) NOT NULL,      /*年度                                   */
ahi02       number(5) NOT NULL,      /*期别                                   */
ahi03       varchar2(40) NOT NULL,   /*料号                                   */
ahi04       number(20,6),            /*成本单价  by ima25                     */
ahi05       number(20,6)             /*内部单价  by ima25                     */
);

create unique index ahi_pk on ahi_file (ahi01,ahi02,ahi03);
alter table ahi_file add  constraint ahi_pk primary key  (ahi01,ahi02,ahi03) enable validate;
grant select on ahi_file to public;
grant index on ahi_file to public;
grant update on ahi_file to public;
grant delete on ahi_file to public;
grant insert on ahi_file to public;