/*
================================================================================
档案代号:bwd_file
档案名称:保税料件期间统计资料档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table bwd_file
(
bwd01       varchar2(40) NOT NULL,   /*料件编号                               */
bwd02       date NOT NULL,           /*生效日                                 */
bwd03       number(15,3),            /*内销数量(库存单位)                     */
bwd04       number(15,3),            /*外销数量(库存单位)                     */
bwd05       number(15,3),            /*报废数量                               */
bwd06       number(15,3),            /*外运数量(库存单位)                     */
bwd011      number(5) NOT NULL       /*年度                                   */
);

create unique index bwd_pk on bwd_file (bwd01,bwd02,bwd011);
alter table bwd_file add  constraint bwd_pk primary key  (bwd01,bwd02,bwd011) enable validate;
grant select on bwd_file to public;
grant index on bwd_file to public;
grant update on bwd_file to public;
grant delete on bwd_file to public;
grant insert on bwd_file to public;