/*
================================================================================
档案代号:imkk_file
档案名称:料件单位期间/月统计档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table imkk_file
(
imkk01      varchar2(40) NOT NULL,   /*料件编号                               */
imkk02      varchar2(10) NOT NULL,   /*仓库编号                               */
imkk03      varchar2(10) NOT NULL,   /*储位编号                               */
imkk04      varchar2(24) NOT NULL,   /*批号                                   */
imkk05      number(5) NOT NULL,      /*年度yyyy                               */
imkk06      number(5) NOT NULL,      /*期别                                   */
imkk081     number(15,3),            /*本期入库统计量                         */
imkk082     number(15,3),            /*本期销货统计量                         */
imkk083     number(15,3),            /*本期领用统计量                         */
imkk084     number(15,3),            /*本期转拨统计量                         */
imkk085     number(15,3),            /*本期调整统计量                         */
imkk086     number(5),               /*No Use                                 */
imkk087     number(5),               /*No Use                                 */
imkk088     number(5),               /*No Use                                 */
imkk089     number(5),               /*No Use                                 */
imkk09      number(15,3),            /*期末数量                               */
imkk10      varchar2(4) NOT NULL     /*记录 '单位'                            */
);

create unique index imkk_pk on imkk_file (imkk01,imkk02,imkk03,imkk04,imkk05,imkk06,imkk10);
alter table imkk_file add  constraint imkk_pk primary key  (imkk01,imkk02,imkk03,imkk04,imkk05,imkk06,imkk10) 
enable validate;
grant select on imkk_file to public;
grant index on imkk_file to public;
grant update on imkk_file to public;
grant delete on imkk_file to public;
grant insert on imkk_file to public;