/*
================================================================================
档案代号:fbf_file
档案名称:固定资产出售单据单身档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table fbf_file
(
fbf01       varchar2(16) NOT NULL,   /*出售单号                               */
fbf02       number(5) NOT NULL,      /*项次                                   */
fbf03       varchar2(10),            /*财产编号                               */
fbf031      varchar2(4),             /*附号                                   */
fbf04       number(5),               /*数量                                   */
fbf05       varchar2(4),             /*原因                                   */
fbf06       number(20,6),            /*原币出售金额                           */
fbf07       number(20,6),            /*本币出售金额                           */
fbf08       number(20,6),            /*未折减额                               */
fbf09       number(20,6),            /*处份损益                               */
fbf10       number(20,6),            /*税签未折减额                           */
fbf11       number(20,6),            /*已提列减值准备                         */
                                     /*已提列减值准备     #No:A099            */
fbf12       number(20,6),            /*税签减值准备                           */
                                     /*税签减值准备         #No:A099          */
fbfud01     varchar2(255),           /*自订栏位-Textedit                      */
fbfud02     varchar2(40),            /*自订栏位-文字                          */
fbfud03     varchar2(40),            /*自订栏位-文字                          */
fbfud04     varchar2(40),            /*自订栏位-文字                          */
fbfud05     varchar2(40),            /*自订栏位-文字                          */
fbfud06     varchar2(40),            /*自订栏位-文字                          */
fbfud07     number(15,3),            /*自订栏位-数值                          */
fbfud08     number(15,3),            /*自订栏位-数值                          */
fbfud09     number(15,3),            /*自订栏位-数值                          */
fbfud10     number(10),              /*自订栏位-整数                          */
fbfud11     number(10),              /*自订栏位-整数                          */
fbfud12     number(10),              /*自订栏位-整数                          */
fbfud13     date,                    /*自订栏位-日期                          */
fbfud14     date,                    /*自订栏位-日期                          */
fbfud15     date                     /*自订栏位-日期                          */
);

create unique index fbf_pk on fbf_file (fbf01,fbf02);
alter table fbf_file add  constraint fbf_pk primary key  (fbf01,fbf02) enable validate;
grant select on fbf_file to public;
grant index on fbf_file to public;
grant update on fbf_file to public;
grant delete on fbf_file to public;
grant insert on fbf_file to public;