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