/* ================================================================================ 档案代号: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; |