Release History

Data format is : YYYY-MM-DD

Version format is : major.minor.patch

2.1.7 Released ( 2015-06-10 )

MASTER ACCESS API 버그 패치 및 요청사항

1. 업무 기준 API 사용시 잘못된 결과의 출력 버그 수정.

2. 업무 기준 API 사용시 조건에 만족한 결과가 복수의 결과를 리턴 할수 있도록 수정.

3. 업무기준의 비교 연산( <, <=, >, >=, <= BETWEEN <=, < BETWEEN <=, <= BETWEEN <, < BETWEEN < )시 입력값이 null,""에 대해서 return값을 false 처리 하도록 하였음.

4. 업무 기준의 비교 연산시 not between과 between문의 잘못된 Number 체크 및 초기화로 버그 수정.

MASTER MANGER 개선 사항

1. 업무 기준 데이터 화면에서의 예외처리 ROW에 대한 이상 결과 수정.

2. 표준항목과 표준용어 약어 column SIZE 변경 ( 10 -> 100)

패치 적용시 필수 작업

Glue master version 2.1.6 이하 버전 사용시 필요한 아래 DataBase script(oracle base)를 실행 해주세요.

    ALTER TABLE STANDARD_GLOSSARY_ITEM MODIFY( STD_ABBR VARCHAR2( 100 ));

2.1.6 Released ( 2015-05-29 )

화면 UI의 DHTMLX 4.1.3로 Upgrade(IE10 대응)

MSSQL을 사용 가능 하도록 SQL 추가 적용

GlueMaster.properties에 적용 방법

    manager.querypath=query/mssql
    access.querypath=access-query/mssql

DATABASE의 Column의 SIZE 변경

    MASTER COMMON ID(MC_ID,BR_ID,CR_ID,IF_ID) 의 사이즈 변경(20 -> 60)
    표준명칭(STD_NM)의 사이즈 변경(60 -> 100)
    다국어 명칭,동의어1,2,3(GLOBAL_NM,SYNM1,SYNM1,SYNM1)의 사이즈 변경 (30 -> 100)

패치 적용시 필수 작업

Glue master version 2.1.5 이하 버전 사용시 필요한 아래 DataBase script(oracle base)를 실행 해주세요.

    ALTER TABLE BUSINESS_RULE_DATA MODIFY( BR_ID VARCHAR2( 60 ));
    ALTER TABLE BUSINESS_RULE_LAYOUT MODIFY( BR_ID VARCHAR2( 60 ));
    ALTER TABLE BUSINESS_RULE_LAYOUT MODIFY( STD_NM VARCHAR2( 100 ));
    ALTER TABLE CALCULATION_FORMULA MODIFY( CR_ID VARCHAR2( 60 ));
    ALTER TABLE CALCULATION_FACTOR MODIFY( CR_ID VARCHAR2( 60 ));
    ALTER TABLE CALCULATION_ITEM MODIFY( CR_ID VARCHAR2( 60 ));
    ALTER TABLE CALCULATION_ITEM MODIFY( STD_NM VARCHAR2( 100 ));
    ALTER TABLE GLOBAL_GLOSSARY_ITEM MODIFY( STD_NM VARCHAR2( 100 ));
    ALTER TABLE GLOBAL_GLOSSARY_ITEM MODIFY( GLOBAL_NM VARCHAR2( 100 ));
    ALTER TABLE GLOBAL_GLOSSARY_ITEM MODIFY( SYNM1 VARCHAR2( 100 ));
    ALTER TABLE GLOBAL_GLOSSARY_ITEM MODIFY( SYNM2 VARCHAR2( 100 ));
    ALTER TABLE GLOBAL_GLOSSARY_ITEM MODIFY( SYNM3 VARCHAR2( 100 ));
    ALTER TABLE INTERFACE_TC_CHECK MODIFY( IF_ID VARCHAR2( 60 ));
    ALTER TABLE INTERFACE_TC MODIFY( IF_ID VARCHAR2( 60 ));
    ALTER TABLE INTERFACE_LAYOUT MODIFY( IF_ID VARCHAR2( 60 ));
    ALTER TABLE INTERFACE_LAYOUT MODIFY( STD_NM VARCHAR2( 100 ));
    ALTER TABLE MASTER_CODE_CATEGORY MODIFY( MC_ID VARCHAR2( 60 ));
    ALTER TABLE MASTER_CODE_ITEM MODIFY( MC_ID VARCHAR2( 60 ));
    ALTER TABLE MASTER_CODE_ITEM MODIFY( ITEM_NM VARCHAR2( 100 ));
    ALTER TABLE MASTER_COMMON MODIFY( CM_ID VARCHAR2( 60 ));
    ALTER TABLE MASTER_COMMON MODIFY( CM_NM VARCHAR2( 100 ));
    ALTER TABLE STANDARD_GLOSSARY_ITEM MODIFY( STD_NM VARCHAR2( 100 ));
    ALTER TABLE TRANSACTION_CODE MODIFY( MC_ID VARCHAR2( 60 ));
    ALTER TABLE CALCULATION_INOUT MODIFY( CR_ID VARCHAR2( 60 ));

2.1.5 Released ( 2015-01-30 )

MYSQL을 사용 가능 하도록 SQL 추가 적용

GlueMaster.properties에 적용 방법

    manager.querypath=query/mysql
    access.querypath=access-query/mysql

[Masterdata 이행]화면 PasgeSet기능 추가

2.1.4 Released ( 2014-12-31 )

측정관리 화면의 다국어 오류에 대한 대응 - 측정관리 테이블(UNIT_OF_MEASURE) 의 LANG_CD column의 PRIMARY KEY 추가

설정 (패치 적용시 필수 작업)

UNIT_OF_MEASURE 테이블 (필수 Data) - (oracle base)

  1. alter table UNIT_OF_MEASURE drop primary key;
  
  2. alter table UNIT_OF_MEASURE add CONSTRAINT UNIT_OF_MEASURE_PK primary key(UOM_NM, LANG_CD);

2.1.3 Released ( 2014-11-28 )

Glue Core version 변경

  - Glue Core 4.2.2-RELEASE -> Glue Core 4.2.3-RELEASE 변경

PPAS(Postgres Plus Advanced Server)를 위한 내부 변경

  - PPAS 관련 SQL 추가
  
  - Page Set 관련 정보 추가

IE 10 호환성 보기 대응

  - 표준용어 화면의 조회 조건의 타이틀 밑으로 내려가는 현상 수정
  
  - 표준아이템 검색 팝업 화면의 타이틀 및으로 내려가는 현상 수정
  
  - 사용자 설정 화면의 깨지는 현상 수정 
 
  - 표준용어, 표준항목, 마스터코드, 트랜잭션코드,업무기준, 계산수식, 인터페이스포맷 
     이력 관리 화면 등의 날짜 출력 부분에서의 오류 수정.

다국적언어를 위한 중국어 대응

  - GMResource_zh_CN.properties의 추가
    (Common data의 미적용)

기타 수정 및 추가 사항

  - site 문서화 자료 추가
  
  - TRANSACTION CODE의 IMPORT 할때 누락한 SQL문 추가  
  
  - Access 수정 : 계산수식 공식 미등록시 정상처리 되는 오류 수정 
  
  - Access 수정 : System.out.println() 출력 부분 삭제

2.1.2 Released ( 2014-09-15 )

표준 용어 및 표준 항목의 이름, ID의 입력, 수정 UI, SIZE 변경.

 - 표준항목관리, 표준용어관리 Popup의 [이름],[ID]의 UI Size 10 -> 60 확장(표준용어ID DB Size 확장)
 
 - 표준항목관리, 표준용어관리 Popup의 View SIZE의 확장
 
 - 표준용어의 ID의 NULL Check에서 제외
 
 - 표준용어, IMPORT(표준용어)에 대상의 표준용어 ID의 NULL 입력시 표준용어이름과 동일한 내용으로 ID입력

패치 적용시 필수 작업

Glue master version 2.1.1 이하 버전 사용시 필요한 아래 DataBase script(oracle base)를 실행 해주세요. 

  alter table STANDARD_GLOSSARY_ITEM modify STD_ID varchar2(60);

2.1.1 Released ( 2013-08-04 )

기능 추가

이력 기능 추가

업무 화면에서 DataBase에 추가(insert), 수정(update), 삭제(delete) 처리에 대해서
이력을 관리 하며 해당 관리Data를 엑셀 파일로 Export 가능하다.

화면 사용 가이드

Master 이력 사용자 가이드

설정 (패치 적용시 필수 작업)

GlueMaster.properties(선택)

    #Is Master History( true-이력 사용함, false-이력 사용 안함(Default) )
    manager.ismasterhistory=true

DataBase Table Script(필수) - (oracle base)

-- 마스터 이력 항목
CREATE TABLE MASTER_BUSINESS_HISTORY
(
    -- 업무구분
    BIZ_TYPE VARCHAR2(10) NOT NULL,
    -- 이력구분
    HIS_TYPE VARCHAR2(10) NOT NULL,
    -- SQL 쿼리 ID
    SQL_QUERY_ID VARCHAR2(100) NOT NULL,
    -- SQL 쿼리 파라메터
    SQL_QUERY_PARAMETER VARCHAR2(4000) NOT NULL,
    -- 생성자
    CREATE_ID VARCHAR2(20) NOT NULL,
    -- 생성일시
    CREATE_TSMP TIMESTAMP NOT NULL,
);

Common Data(필수 Data) - (oracle base)

Insert into COMMON_CODE (CD_NM,LANG_CD,CD_DESC,CREATE_ID,CREATE_TSMP,MODIFY_ID,MODIFY_TSMP) values ('MASTER_BUSINESS_TYPE','en_US','Business Type','gluemast',CURRENT_TIMESTAMP,'gluemast',CURRENT_TIMESTAMP);
Insert into COMMON_CODE (CD_NM,LANG_CD,CD_DESC,CREATE_ID,CREATE_TSMP,MODIFY_ID,MODIFY_TSMP) values ('MASTER_BUSINESS_TYPE','ko_KR','업무 구분','gluemast',CURRENT_TIMESTAMP,'gluemast',CURRENT_TIMESTAMP);
Insert into COMMON_CODE (CD_NM,LANG_CD,CD_DESC,CREATE_ID,CREATE_TSMP,MODIFY_ID,MODIFY_TSMP) values ('MASTER_HISTORY_TYPE','en_US','History Type','gluemast',CURRENT_TIMESTAMP,'gluemast',CURRENT_TIMESTAMP);
Insert into COMMON_CODE (CD_NM,LANG_CD,CD_DESC,CREATE_ID,CREATE_TSMP,MODIFY_ID,MODIFY_TSMP) values ('MASTER_HISTORY_TYPE','ko_KR','이력 구분','gluemast',CURRENT_TIMESTAMP,'gluemast',CURRENT_TIMESTAMP);

Common Data Detail(필수 Data) - (oracle base)

Insert into COMMON_CODE_DETAIL (CD_NM,LANG_CD,CD_VAL,VAL_DESC,SORT_SEQ,CREATE_ID,CREATE_TSMP,MODIFY_ID,MODIFY_TSMP) values ('MASTER_BUSINESS_TYPE','ko_KR','SG','표준용어',1,'gluemast',CURRENT_TIMESTAMP,'gluemast',CURRENT_TIMESTAMP);
Insert into COMMON_CODE_DETAIL (CD_NM,LANG_CD,CD_VAL,VAL_DESC,SORT_SEQ,CREATE_ID,CREATE_TSMP,MODIFY_ID,MODIFY_TSMP) values ('MASTER_BUSINESS_TYPE','ko_KR','SI','표준항목',2,'gluemast',CURRENT_TIMESTAMP,'gluemast',CURRENT_TIMESTAMP);
Insert into COMMON_CODE_DETAIL (CD_NM,LANG_CD,CD_VAL,VAL_DESC,SORT_SEQ,CREATE_ID,CREATE_TSMP,MODIFY_ID,MODIFY_TSMP) values ('MASTER_BUSINESS_TYPE','ko_KR','SM','표준메시지',3,'gluemast',CURRENT_TIMESTAMP,'gluemast',CURRENT_TIMESTAMP);
Insert into COMMON_CODE_DETAIL (CD_NM,LANG_CD,CD_VAL,VAL_DESC,SORT_SEQ,CREATE_ID,CREATE_TSMP,MODIFY_ID,MODIFY_TSMP) values ('MASTER_BUSINESS_TYPE','ko_KR','MC','마스터코드',4,'gluemast',CURRENT_TIMESTAMP,'gluemast',CURRENT_TIMESTAMP);
Insert into COMMON_CODE_DETAIL (CD_NM,LANG_CD,CD_VAL,VAL_DESC,SORT_SEQ,CREATE_ID,CREATE_TSMP,MODIFY_ID,MODIFY_TSMP) values ('MASTER_BUSINESS_TYPE','ko_KR','TC','트랜잭션코드',5,'gluemast',CURRENT_TIMESTAMP,'gluemast',CURRENT_TIMESTAMP);
Insert into COMMON_CODE_DETAIL (CD_NM,LANG_CD,CD_VAL,VAL_DESC,SORT_SEQ,CREATE_ID,CREATE_TSMP,MODIFY_ID,MODIFY_TSMP) values ('MASTER_BUSINESS_TYPE','ko_KR','BR','업무기준',6,'gluemast',CURRENT_TIMESTAMP,'gluemast',CURRENT_TIMESTAMP);
Insert into COMMON_CODE_DETAIL (CD_NM,LANG_CD,CD_VAL,VAL_DESC,SORT_SEQ,CREATE_ID,CREATE_TSMP,MODIFY_ID,MODIFY_TSMP) values ('MASTER_BUSINESS_TYPE','ko_KR','CR','계산수식',7,'gluemast',CURRENT_TIMESTAMP,'gluemast',CURRENT_TIMESTAMP);
Insert into COMMON_CODE_DETAIL (CD_NM,LANG_CD,CD_VAL,VAL_DESC,SORT_SEQ,CREATE_ID,CREATE_TSMP,MODIFY_ID,MODIFY_TSMP) values ('MASTER_BUSINESS_TYPE','ko_KR','IF','인터페이스포맷',8,'gluemast',CURRENT_TIMESTAMP,'gluemast',CURRENT_TIMESTAMP);
Insert into COMMON_CODE_DETAIL (CD_NM,LANG_CD,CD_VAL,VAL_DESC,SORT_SEQ,CREATE_ID,CREATE_TSMP,MODIFY_ID,MODIFY_TSMP) values ('MASTER_BUSINESS_TYPE','ko_KR','IT','인터페이스전문',9,'gluemast',CURRENT_TIMESTAMP,'gluemast',CURRENT_TIMESTAMP);
Insert into COMMON_CODE_DETAIL (CD_NM,LANG_CD,CD_VAL,VAL_DESC,SORT_SEQ,CREATE_ID,CREATE_TSMP,MODIFY_ID,MODIFY_TSMP) values ('MASTER_BUSINESS_TYPE','ko_KR','UM','사용자관리',10,'gluemast',CURRENT_TIMESTAMP,'gluemast',CURRENT_TIMESTAMP);
Insert into COMMON_CODE_DETAIL (CD_NM,LANG_CD,CD_VAL,VAL_DESC,SORT_SEQ,CREATE_ID,CREATE_TSMP,MODIFY_ID,MODIFY_TSMP) values ('MASTER_BUSINESS_TYPE','ko_KR','LM','언어관리',11,'gluemast',CURRENT_TIMESTAMP,'gluemast',CURRENT_TIMESTAMP);
Insert into COMMON_CODE_DETAIL (CD_NM,LANG_CD,CD_VAL,VAL_DESC,SORT_SEQ,CREATE_ID,CREATE_TSMP,MODIFY_ID,MODIFY_TSMP) values ('MASTER_BUSINESS_TYPE','ko_KR','CM','공통코드관리',12,'gluemast',CURRENT_TIMESTAMP,'gluemast',CURRENT_TIMESTAMP);
Insert into COMMON_CODE_DETAIL (CD_NM,LANG_CD,CD_VAL,VAL_DESC,SORT_SEQ,CREATE_ID,CREATE_TSMP,MODIFY_ID,MODIFY_TSMP) values ('MASTER_BUSINESS_TYPE','ko_KR','MM','측정단위관리',13,'gluemast',CURRENT_TIMESTAMP,'gluemast',CURRENT_TIMESTAMP);
Insert into COMMON_CODE_DETAIL (CD_NM,LANG_CD,CD_VAL,VAL_DESC,SORT_SEQ,CREATE_ID,CREATE_TSMP,MODIFY_ID,MODIFY_TSMP) values ('MASTER_BUSINESS_TYPE','ko_KR','RM','권한그룹관리',14,'gluemast',CURRENT_TIMESTAMP,'gluemast',CURRENT_TIMESTAMP);
Insert into COMMON_CODE_DETAIL (CD_NM,LANG_CD,CD_VAL,VAL_DESC,SORT_SEQ,CREATE_ID,CREATE_TSMP,MODIFY_ID,MODIFY_TSMP) values ('MASTER_BUSINESS_TYPE','ko_KR','IM','Export/Import',15,'gluemast',CURRENT_TIMESTAMP,'gluemast',CURRENT_TIMESTAMP);
Insert into COMMON_CODE_DETAIL (CD_NM,LANG_CD,CD_VAL,VAL_DESC,SORT_SEQ,CREATE_ID,CREATE_TSMP,MODIFY_ID,MODIFY_TSMP) values ('MASTER_BUSINESS_TYPE','ko_KR','AM','Access관리',16,'gluemast',CURRENT_TIMESTAMP,'gluemast',CURRENT_TIMESTAMP);
Insert into COMMON_CODE_DETAIL (CD_NM,LANG_CD,CD_VAL,VAL_DESC,SORT_SEQ,CREATE_ID,CREATE_TSMP,MODIFY_ID,MODIFY_TSMP) values ('MASTER_BUSINESS_TYPE','en_US','SG','standard glossaries',1,'gluemast',CURRENT_TIMESTAMP,'gluemast',CURRENT_TIMESTAMP);
Insert into COMMON_CODE_DETAIL (CD_NM,LANG_CD,CD_VAL,VAL_DESC,SORT_SEQ,CREATE_ID,CREATE_TSMP,MODIFY_ID,MODIFY_TSMP) values ('MASTER_BUSINESS_TYPE','en_US','SI','standard items',2,'gluemast',CURRENT_TIMESTAMP,'gluemast',CURRENT_TIMESTAMP);
Insert into COMMON_CODE_DETAIL (CD_NM,LANG_CD,CD_VAL,VAL_DESC,SORT_SEQ,CREATE_ID,CREATE_TSMP,MODIFY_ID,MODIFY_TSMP) values ('MASTER_BUSINESS_TYPE','en_US','SM','standard messages',3,'gluemast',CURRENT_TIMESTAMP,'gluemast',CURRENT_TIMESTAMP);
Insert into COMMON_CODE_DETAIL (CD_NM,LANG_CD,CD_VAL,VAL_DESC,SORT_SEQ,CREATE_ID,CREATE_TSMP,MODIFY_ID,MODIFY_TSMP) values ('MASTER_BUSINESS_TYPE','en_US','MC','master codes',4,'gluemast',CURRENT_TIMESTAMP,'gluemast',CURRENT_TIMESTAMP);
Insert into COMMON_CODE_DETAIL (CD_NM,LANG_CD,CD_VAL,VAL_DESC,SORT_SEQ,CREATE_ID,CREATE_TSMP,MODIFY_ID,MODIFY_TSMP) values ('MASTER_BUSINESS_TYPE','en_US','TC','Transaction codes',5,'gluemast',CURRENT_TIMESTAMP,'gluemast',CURRENT_TIMESTAMP);
Insert into COMMON_CODE_DETAIL (CD_NM,LANG_CD,CD_VAL,VAL_DESC,SORT_SEQ,CREATE_ID,CREATE_TSMP,MODIFY_ID,MODIFY_TSMP) values ('MASTER_BUSINESS_TYPE','en_US','BR','business rules',6,'gluemast',CURRENT_TIMESTAMP,'gluemast',CURRENT_TIMESTAMP);
Insert into COMMON_CODE_DETAIL (CD_NM,LANG_CD,CD_VAL,VAL_DESC,SORT_SEQ,CREATE_ID,CREATE_TSMP,MODIFY_ID,MODIFY_TSMP) values ('MASTER_BUSINESS_TYPE','en_US','CR','calculation rules',7,'gluemast',CURRENT_TIMESTAMP,'gluemast',CURRENT_TIMESTAMP);
Insert into COMMON_CODE_DETAIL (CD_NM,LANG_CD,CD_VAL,VAL_DESC,SORT_SEQ,CREATE_ID,CREATE_TSMP,MODIFY_ID,MODIFY_TSMP) values ('MASTER_BUSINESS_TYPE','en_US','IF','interface formats',8,'gluemast',CURRENT_TIMESTAMP,'gluemast',CURRENT_TIMESTAMP);
Insert into COMMON_CODE_DETAIL (CD_NM,LANG_CD,CD_VAL,VAL_DESC,SORT_SEQ,CREATE_ID,CREATE_TSMP,MODIFY_ID,MODIFY_TSMP) values ('MASTER_BUSINESS_TYPE','en_US','IT','interface TCs',9,'gluemast',CURRENT_TIMESTAMP,'gluemast',CURRENT_TIMESTAMP);
Insert into COMMON_CODE_DETAIL (CD_NM,LANG_CD,CD_VAL,VAL_DESC,SORT_SEQ,CREATE_ID,CREATE_TSMP,MODIFY_ID,MODIFY_TSMP) values ('MASTER_BUSINESS_TYPE','en_US','UM','master users',10,'gluemast',CURRENT_TIMESTAMP,'gluemast',CURRENT_TIMESTAMP);
Insert into COMMON_CODE_DETAIL (CD_NM,LANG_CD,CD_VAL,VAL_DESC,SORT_SEQ,CREATE_ID,CREATE_TSMP,MODIFY_ID,MODIFY_TSMP) values ('MASTER_BUSINESS_TYPE','en_US','LM','language codes',11,'gluemast',CURRENT_TIMESTAMP,'gluemast',CURRENT_TIMESTAMP);
Insert into COMMON_CODE_DETAIL (CD_NM,LANG_CD,CD_VAL,VAL_DESC,SORT_SEQ,CREATE_ID,CREATE_TSMP,MODIFY_ID,MODIFY_TSMP) values ('MASTER_BUSINESS_TYPE','en_US','CM','common codes',12,'gluemast',CURRENT_TIMESTAMP,'gluemast',CURRENT_TIMESTAMP);
Insert into COMMON_CODE_DETAIL (CD_NM,LANG_CD,CD_VAL,VAL_DESC,SORT_SEQ,CREATE_ID,CREATE_TSMP,MODIFY_ID,MODIFY_TSMP) values ('MASTER_BUSINESS_TYPE','en_US','MM','unit of measures',13,'gluemast',CURRENT_TIMESTAMP,'gluemast',CURRENT_TIMESTAMP);
Insert into COMMON_CODE_DETAIL (CD_NM,LANG_CD,CD_VAL,VAL_DESC,SORT_SEQ,CREATE_ID,CREATE_TSMP,MODIFY_ID,MODIFY_TSMP) values ('MASTER_BUSINESS_TYPE','en_US','RM','respansibilities',14,'gluemast',CURRENT_TIMESTAMP,'gluemast',CURRENT_TIMESTAMP);
Insert into COMMON_CODE_DETAIL (CD_NM,LANG_CD,CD_VAL,VAL_DESC,SORT_SEQ,CREATE_ID,CREATE_TSMP,MODIFY_ID,MODIFY_TSMP) values ('MASTER_BUSINESS_TYPE','en_US','IM','export/import',15,'gluemast',CURRENT_TIMESTAMP,'gluemast',CURRENT_TIMESTAMP);
Insert into COMMON_CODE_DETAIL (CD_NM,LANG_CD,CD_VAL,VAL_DESC,SORT_SEQ,CREATE_ID,CREATE_TSMP,MODIFY_ID,MODIFY_TSMP) values ('MASTER_BUSINESS_TYPE','en_US','AM','master access',16,'gluemast',CURRENT_TIMESTAMP,'gluemast',CURRENT_TIMESTAMP);
Insert into COMMON_CODE_DETAIL (CD_NM,LANG_CD,CD_VAL,VAL_DESC,SORT_SEQ,CREATE_ID,CREATE_TSMP,MODIFY_ID,MODIFY_TSMP) values ('MASTER_HISTORY_TYPE','ko_KR','CT','추가',1,'gluemast',CURRENT_TIMESTAMP,'gluemast',CURRENT_TIMESTAMP);
Insert into COMMON_CODE_DETAIL (CD_NM,LANG_CD,CD_VAL,VAL_DESC,SORT_SEQ,CREATE_ID,CREATE_TSMP,MODIFY_ID,MODIFY_TSMP) values ('MASTER_HISTORY_TYPE','ko_KR','UT','수정',2,'gluemast',CURRENT_TIMESTAMP,'gluemast',CURRENT_TIMESTAMP);
Insert into COMMON_CODE_DETAIL (CD_NM,LANG_CD,CD_VAL,VAL_DESC,SORT_SEQ,CREATE_ID,CREATE_TSMP,MODIFY_ID,MODIFY_TSMP) values ('MASTER_HISTORY_TYPE','ko_KR','DT','삭제',3,'gluemast',CURRENT_TIMESTAMP,'gluemast',CURRENT_TIMESTAMP);
Insert into COMMON_CODE_DETAIL (CD_NM,LANG_CD,CD_VAL,VAL_DESC,SORT_SEQ,CREATE_ID,CREATE_TSMP,MODIFY_ID,MODIFY_TSMP) values ('MASTER_HISTORY_TYPE','en_US','CT','create',1,'gluemast',CURRENT_TIMESTAMP,'gluemast',CURRENT_TIMESTAMP);
Insert into COMMON_CODE_DETAIL (CD_NM,LANG_CD,CD_VAL,VAL_DESC,SORT_SEQ,CREATE_ID,CREATE_TSMP,MODIFY_ID,MODIFY_TSMP) values ('MASTER_HISTORY_TYPE','en_US','UT','update',2,'gluemast',CURRENT_TIMESTAMP,'gluemast',CURRENT_TIMESTAMP);
Insert into COMMON_CODE_DETAIL (CD_NM,LANG_CD,CD_VAL,VAL_DESC,SORT_SEQ,CREATE_ID,CREATE_TSMP,MODIFY_ID,MODIFY_TSMP) values ('MASTER_HISTORY_TYPE','en_US','DT','delete',3,'gluemast',CURRENT_TIMESTAMP,'gluemast',CURRENT_TIMESTAMP);

사용자 설정 추가(날짜 표현 포맷 변경)

사용자의 원하는 날짜 포맷으로 화면에 출력 할수 있도록 설정 한다.

화면 사용 가이드

사용자 설정 사용자 가이드

설정 (패치 적용시 필수 작업)

Common Data(필수 Data) - (oracle base)

Insert into COMMON_CODE (CD_NM,LANG_CD,CD_DESC,CREATE_ID,CREATE_TSMP,MODIFY_ID,MODIFY_TSMP) values ('DATE_FORMAT','en_US','Date Format','gluemast',CURRENT_TIMESTAMP,'gluemast',CURRENT_TIMESTAMP);
Insert into COMMON_CODE (CD_NM,LANG_CD,CD_DESC,CREATE_ID,CREATE_TSMP,MODIFY_ID,MODIFY_TSMP) values ('DATE_FORMAT','ko_KR','날짜 포멧','gluemast',CURRENT_TIMESTAMP,'gluemast',CURRENT_TIMESTAMP);

Common Data Detail(필수 Data) - (oracle base)

Insert into COMMON_CODE_DETAIL (CD_NM,LANG_CD,CD_VAL,VAL_DESC,SORT_SEQ,CREATE_ID,CREATE_TSMP,MODIFY_ID,MODIFY_TSMP) values ('DATE_FORMAT','ko_KR','SD','yyyy/mm/dd HH:MM',1,'gluemast',CURRENT_TIMESTAMP,'gluemast',CURRENT_TIMESTAMP);
Insert into COMMON_CODE_DETAIL (CD_NM,LANG_CD,CD_VAL,VAL_DESC,SORT_SEQ,CREATE_ID,CREATE_TSMP,MODIFY_ID,MODIFY_TSMP) values ('DATE_FORMAT','ko_KR','DT','mm/dd/yyyy HH:MM',2,'gluemast',CURRENT_TIMESTAMP,'gluemast',CURRENT_TIMESTAMP);
Insert into COMMON_CODE_DETAIL (CD_NM,LANG_CD,CD_VAL,VAL_DESC,SORT_SEQ,CREATE_ID,CREATE_TSMP,MODIFY_ID,MODIFY_TSMP) values ('DATE_FORMAT','ko_KR','HD','yyyy-mm-dd HH:MM',3,'gluemast',CURRENT_TIMESTAMP,'gluemast',CURRENT_TIMESTAMP);
Insert into COMMON_CODE_DETAIL (CD_NM,LANG_CD,CD_VAL,VAL_DESC,SORT_SEQ,CREATE_ID,CREATE_TSMP,MODIFY_ID,MODIFY_TSMP) values ('DATE_FORMAT','ko_KR','HM','mm-dd-yyyy HH:MM',4,'gluemast',CURRENT_TIMESTAMP,'gluemast',CURRENT_TIMESTAMP);
Insert into COMMON_CODE_DETAIL (CD_NM,LANG_CD,CD_VAL,VAL_DESC,SORT_SEQ,CREATE_ID,CREATE_TSMP,MODIFY_ID,MODIFY_TSMP) values ('DATE_FORMAT','en_US','SD','yyyy/mm/dd HH:MM',1,'gluemast',CURRENT_TIMESTAMP,'gluemast',CURRENT_TIMESTAMP);
Insert into COMMON_CODE_DETAIL (CD_NM,LANG_CD,CD_VAL,VAL_DESC,SORT_SEQ,CREATE_ID,CREATE_TSMP,MODIFY_ID,MODIFY_TSMP) values ('DATE_FORMAT','en_US','DT','mm/dd/yyyy HH:MM',2,'gluemast',CURRENT_TIMESTAMP,'gluemast',CURRENT_TIMESTAMP);
Insert into COMMON_CODE_DETAIL (CD_NM,LANG_CD,CD_VAL,VAL_DESC,SORT_SEQ,CREATE_ID,CREATE_TSMP,MODIFY_ID,MODIFY_TSMP) values ('DATE_FORMAT','en_US','HD','yyyy-mm-dd HH:MM',3,'gluemast',CURRENT_TIMESTAMP,'gluemast',CURRENT_TIMESTAMP);
Insert into COMMON_CODE_DETAIL (CD_NM,LANG_CD,CD_VAL,VAL_DESC,SORT_SEQ,CREATE_ID,CREATE_TSMP,MODIFY_ID,MODIFY_TSMP) values ('DATE_FORMAT','en_US','HM','mm-dd-yyyy HH:MM',4,'gluemast',CURRENT_TIMESTAMP,'gluemast',CURRENT_TIMESTAMP);

2.1.0 Released ( 2014-04-28 )

  • initial version.