/* ================================================================================ 档案代号:apc_file 档案名称:应付系统多帐期明细档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table apc_file ( apc01 varchar2(16) NOT NULL, /*应付帐款代号 */ apc02 number(5) NOT NULL, /*项次 */ apc03 varchar2(10) NOT NULL, /*子收款条件 */ apc04 date, /*应付款日 */ apc05 date, /*容许票据到期日 */ apc06 number(20,10), /*汇率 */ apc07 number(20,10), /*重估汇率 */ apc08 number(20,6), /*原币合计 */ apc09 number(20,6), /*本币合计 */ apc10 number(20,6), /*原币已付金额 */ apc11 number(20,6), /*本币已付金额 */ apc12 varchar2(16), /*发票号码 */ apc13 number(20,6), /*本币未冲金额 */ apc14 number(20,6), /*原币直接冲帐金额 */ apc15 number(20,6), /*本币直接冲帐金额 */ apc16 number(20,6) /*原币留置金额 */ ); create unique index apc_pk on apc_file (apc01,apc02); alter table apc_file add constraint apc_pk primary key (apc01,apc02) enable validate; grant select on apc_file to public; grant index on apc_file to public; grant update on apc_file to public; grant delete on apc_file to public; grant insert on apc_file to public; |