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