/*
================================================================================
档案代号:bgj_file
档案名称:收款方式档 (Payment Term Code File)
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table bgj_file
(
bgj01       varchar2(10) NOT NULL,   /*版本                                   */
bgj02       varchar2(10) NOT NULL,   /*收款条件                               */
bgj03       varchar2(80),            /*收款说明                               */
bgj04       number(9,4),             /*占百分比                               */
bgj05       varchar2(1)              /*No Use                                 */
);

create unique index bgj_pk on bgj_file (bgj01,bgj02);
alter table bgj_file add  constraint bgj_pk primary key  (bgj01,bgj02) enable validate;
grant select on bgj_file to public;
grant index on bgj_file to public;
grant update on bgj_file to public;
grant delete on bgj_file to public;
grant insert on bgj_file to public;