/* ================================================================================ 档案代号:azi_file 档案名称:币别档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table azi_file ( azi01 varchar2(4) NOT NULL, /*币别代码 */ azi02 varchar2(80), /*币别说明 */ azi03 number(5), /*单价 */ /*单价,成本小数位数(0~5) */ azi04 number(5), /*金额小数位数 */ /*金额小数位数 (0~3) */ azi05 number(5), /*小计,总计小数位数 */ /*小计,总计小数位数(0~3) */ azi07 number(5), /*1 除汇率时所取小数位数 */ /*1 除汇率时所取小数位数(0~8) */ azi08 varchar2(24), /*采购汇兑损益会计科目 */ azi09 varchar2(24), /*销货汇兑损益会计科目 */ aziacti varchar2(1), /*资料有效码 */ aziuser varchar2(10), /*资料所有者 */ azigrup varchar2(10), /*资料所有部门 */ azimodu varchar2(10), /*资料修改者 */ azidate date, /*最近修改日 */ azi10 varchar2(1) /*计算方式 */ ); create unique index azi_pk on azi_file (azi01); alter table azi_file add constraint azi_pk primary key (azi01) enable validate; grant select on azi_file to public; grant index on azi_file to public; grant update on azi_file to public; grant delete on azi_file to public; grant insert on azi_file to public; |