/*
================================================================================
档案代号:bgi_file
档案名称:付款方式档 (Payment Term Code File)
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table bgi_file
(
bgi01       varchar2(10) NOT NULL,   /*版本                                   */
bgi02       varchar2(10) NOT NULL,   /*付款条件                               */
bgi03       varchar2(80),            /*付款说明                               */
bgi04       number(9,4),             /*占百分比                               */
bgi05       varchar2(1)              /*No Use                                 */
);

create unique index bgi_pk on bgi_file (bgi01,bgi02);
alter table bgi_file add  constraint bgi_pk primary key  (bgi01,bgi02) enable validate;
grant select on bgi_file to public;
grant index on bgi_file to public;
grant update on bgi_file to public;
grant delete on bgi_file to public;
grant insert on bgi_file to public;