/*
================================================================================
档案代号:faz_file
档案名称:固定资产改良单据单身档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table faz_file
(
faz01       varchar2(16) NOT NULL,   /*改良单号                               */
faz02       number(5) NOT NULL,      /*项次                                   */
faz03       varchar2(10),            /*财产编号                               */
faz031      varchar2(4),             /*附号                                   */
faz04       number(20,6),            /*未折减余额                             */
faz05       number(5),               /*未用年限                               */
faz06       number(20,6),            /*预估残值                               */
faz07       number(15,2),            /*No Use                                 */
faz08       number(20,6),            /*改良成本                               */
faz09       number(5),               /*异动后未用年限                         */
faz10       number(20,6),            /*异动后预估残值                         */
faz11       number(15,2),            /*No Use                                 */
faz12       varchar2(4),             /*原因                                   */
faz13       number(20,6),            /*税签未折减余额                         */
faz14       number(5),               /*税签未用年限                           */
faz15       number(20,6),            /*税签预估残值                           */
faz16       number(15,2),            /*No Use                                 */
faz17       number(20,6),            /*税签改良成本                           */
faz18       number(5),               /*税签异动后未用年限                     */
faz19       number(20,6),            /*税签异动后预估残值                     */
faz20       number(15,2),            /*No Use                                 */
fazud01     varchar2(255),           /*自订栏位-Textedit                      */
fazud02     varchar2(40),            /*自订栏位-文字                          */
fazud03     varchar2(40),            /*自订栏位-文字                          */
fazud04     varchar2(40),            /*自订栏位-文字                          */
fazud05     varchar2(40),            /*自订栏位-文字                          */
fazud06     varchar2(40),            /*自订栏位-文字                          */
fazud07     number(15,3),            /*自订栏位-数值                          */
fazud08     number(15,3),            /*自订栏位-数值                          */
fazud09     number(15,3),            /*自订栏位-数值                          */
fazud10     number(10),              /*自订栏位-整数                          */
fazud11     number(10),              /*自订栏位-整数                          */
fazud12     number(10),              /*自订栏位-整数                          */
fazud13     date,                    /*自订栏位-日期                          */
fazud14     date,                    /*自订栏位-日期                          */
fazud15     date                     /*自订栏位-日期                          */
);

create unique index faz_02 on faz_file (faz01,faz03,faz031);
create unique index faz_pk on faz_file (faz01,faz02);
alter table faz_file add  constraint faz_pk primary key  (faz01,faz02) enable validate;
grant select on faz_file to public;
grant index on faz_file to public;
grant update on faz_file to public;
grant delete on faz_file to public;
grant insert on faz_file to public;