create table SYNC.ACC009_SYNC
(
  COM_CODE varchar(6) COLLATE utf8mb4_unicode_ci NOT NULL  COMMENT ,
  CODE_CLASS char(3) COLLATE utf8mb4_unicode_ci NOT NULL  COMMENT ,
  CODE_NO varchar(5) COLLATE utf8mb4_unicode_ci NOT NULL  COMMENT ,
  CODE_DES varchar(50) COLLATE utf8mb4_unicode_ci  DEFAULT NULL COMMENT ,
  USE_GUBUN char(1) COLLATE utf8mb4_unicode_ci  DEFAULT 'Y' COMMENT ,
  WID varchar(60) COLLATE utf8mb4_unicode_ci  DEFAULT NULL COMMENT ,
  WDATE varchar(30) COLLATE utf8mb4_unicode_ci  DEFAULT NULL COMMENT ,
  EXCHANGE_RATE decimal(18,4)    DEFAULT 0.0000 COMMENT ,
  AMTDIGIT_LEN tinyint(3) unsigned    DEFAULT NULL COMMENT ,
  SORT tinyint(3) unsigned    DEFAULT NULL COMMENT 
  EDITOR_ID varchar(30) COLLATE utf8mb4_unicode_ci  DEFAULT NULL COMMENT 'EDITOR ID',
  EDIT_DT datetime    DEFAULT NULL COMMENT 'UPDATE DATE',   
  PRIMARY KEY (COM_CODE, CODE_CLASS, CODE_NO)
) ENGINE=CONNECT DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci CONNECTION='DSN=pg_bc' `table_type`=ODBC `tabname`='ACC009';

