/*
================================================================================
档案代号:bwh_file
档案名称:年度保税原料结算资料档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table bwh_file
(
bwh01       number(5) NOT NULL,      /*年度                                   */
bwh02       varchar2(40) NOT NULL,   /*料件编号                               */
bwh03       number(15,3),            /*期初保税结存数                         */
bwh04       number(15,3),            /*期初非保税结存数                       */
bwh05       number(15,3),            /*本期保税进货数                         */
bwh06       number(15,3),            /*本期非保税进货数                       */
bwh07       number(15,3),            /*本期外销使用数                         */
bwh08       number(15,3),            /*本期内销使用数                         */
bwh09       number(15,3),            /*本期外运数                             */
bwh10       number(15,3),            /*本期报废数                             */
bwh11       number(15,3),            /*本期盘存数                             */
bwh12       number(15,3),            /*本期盘盈亏数                           */
bwh13       number(15,3),            /*盘差容许数量                           */
bwh14       number(15,3),            /*本期盘差补税数                         */
bwh15       number(15,3),            /*期末应结转下期保税数                   */
bwh16       number(15,3)             /*期末应结转下期非保税数                 */
);

create unique index bwh_pk on bwh_file (bwh01,bwh02);
alter table bwh_file add  constraint bwh_pk primary key  (bwh01,bwh02) enable validate;
grant select on bwh_file to public;
grant index on bwh_file to public;
grant update on bwh_file to public;
grant delete on bwh_file to public;
grant insert on bwh_file to public;