/* ================================================================================ 档案代号:npm_file 档案名称:应付票据异动记录单身档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table npm_file ( npm01 varchar2(16) NOT NULL, /*单据编号 */ npm02 number(5) NOT NULL, /*单据项次 */ npm03 varchar2(16), /*开票单号 */ npm04 number(20,6), /*票面金额 */ npm05 number(20,6), /*本币开{票金额 */ npm06 number(20,6), /*本币异动金额 */ npm07 varchar2(1), /*原票况 */ npm08 date, /*原异动日期 */ npmud01 varchar2(255), /*自订栏位-Textedit */ npmud02 varchar2(40), /*自订栏位-文字 */ npmud03 varchar2(40), /*自订栏位-文字 */ npmud04 varchar2(40), /*自订栏位-文字 */ npmud05 varchar2(40), /*自订栏位-文字 */ npmud06 varchar2(40), /*自订栏位-文字 */ npmud07 number(15,3), /*自订栏位-数值 */ npmud08 number(15,3), /*自订栏位-数值 */ npmud09 number(15,3), /*自订栏位-数值 */ npmud10 number(10), /*自订栏位-整数 */ npmud11 number(10), /*自订栏位-整数 */ npmud12 number(10), /*自订栏位-整数 */ npmud13 date, /*自订栏位-日期 */ npmud14 date, /*自订栏位-日期 */ npmud15 date /*自订栏位-日期 */ ); create index npm_04 on npm_file (npm03); create unique index npm_pk on npm_file (npm01,npm02); alter table npm_file add constraint npm_pk primary key (npm01,npm02) enable validate; grant select on npm_file to public; grant index on npm_file to public; grant update on npm_file to public; grant delete on npm_file to public; grant insert on npm_file to public; |