-- Create table
create table SYS_VENDGROUP
(
  VENDORGROUP_ID    NUMBER not null,
  VENDORGROUP_CODE  VARCHAR2(20) not null,
  VENDORGROUPDESC   VARCHAR2(100),
  ISVALID           CHAR(1) default 'Y' not null,
  UPDATEDATE        DATE default SYSDATE not null,
  UPDATEBYUSER_CODE VARCHAR2(20) default ' ' not null
)
tablespace SYSINFO
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );