/*
================================================================================
档案代号:bzp_file
档案名称:保税机器设备异动资料档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table bzp_file
(
bzp01       varchar2(16) NOT NULL,   /*单据单号                               */
bzp02       number(5) NOT NULL,      /*单据项次                               */
bzp03       date,                    /*异动日期                               */
bzp04       varchar2(1),             /*性质                                   */
                                     /*A.外送 B.收回 C.报废 D.除帐            */
bzp05       number(5),               /*状态                                   */
                                     /*外送:-1, 收回:1, 报废:-1, 除帐:-1      */
bzp06       varchar2(20),            /*机器设备编号                           */
bzp07       number(5),               /*序号                                   */
bzp08       number(15,3),            /*异动数量                               */
bzp09       date,                    /*确认日期                               */
bzp10       varchar2(1)              /*No Use                                 */
);

create unique index bzp_pk on bzp_file (bzp01,bzp02);
alter table bzp_file add  constraint bzp_pk primary key  (bzp01,bzp02) enable validate;
grant select on bzp_file to public;
grant index on bzp_file to public;
grant update on bzp_file to public;
grant delete on bzp_file to public;
grant insert on bzp_file to public;