| 1 |
- window.repositoryObject = {"columns_custom_fields":[],"relations_custom_fields":[],"unique_keys_custom_fields":[],"triggers_custom_fields":[],"object_id":"t4034","name":"tb_hansae_sales_211007back","subtype":"TABLE","is_user_defined":false,"description":"<!DOCTYPE html PUBLIC \"-//W3C//DTD XHTML 1.0 Transitional//EN\" \"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd\">\r\n <html xmlns=\"http://www.w3.org/1999/xhtml\">\r\n <head>\r\n <meta http-equiv=\"Content-Type\" content=\"text/html; charset=utf-8\" /><title>\r\n </title>\r\n <style type=\"text/css\">\r\n .cs2654AE3A{text-align:left;text-indent:0pt;margin:0pt 0pt 0pt 0pt}\r\n .cs82292024{color:#000000;background-color:transparent;font-family:Segoe UI;font-size:10pt;font-weight:normal;font-style:normal;}\r\n </style>\r\n </head>\r\n <body>\r\n <p class=\"cs2654AE3A\"><span class=\"cs82292024\">한세매출. 한세매출반영 데이터 등록에 의한 발생</span></p></body>\r\n </html>","summary":[{"field":"Documentation","value":{"_type":"link","name":"style24@172.30.90.100","id":"d10"}},{"field":"Schema","value":""},{"field":"Name","value":"tb_hansae_sales_211007back"},{"field":"Type","value":"Table"}],"columns":[{"id":"column-39102","object_id":"column-39102","name":"ERP_GB","name_without_path":"ERP_GB","description":"ERP구분(hsmk: 한세MK, hsdr: 한세드림)","is_pk":true,"is_identity":false,"data_type":"varchar","data_length":"20","is_nullable":false,"computed_formula":"","default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-39101","object_id":"column-39101","name":"DT_SALE","name_without_path":"DT_SALE","description":"판매일자(YYYYMMDD형식)","is_pk":true,"is_identity":false,"data_type":"varchar","data_length":"8","is_nullable":false,"computed_formula":"","default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-39106","object_id":"column-39106","name":"TP_SALE","name_without_path":"TP_SALE","description":"판매구분(1:판매, 2:환불)","is_pk":true,"is_identity":false,"data_type":"varchar","data_length":"1","is_nullable":false,"computed_formula":"","default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-39098","object_id":"column-39098","name":"CD_STYLE","name_without_path":"CD_STYLE","description":"스타일코드(SKU_MODEL_NO의 1~10)","is_pk":true,"is_identity":false,"data_type":"varchar","data_length":"20","is_nullable":false,"computed_formula":"","default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-39095","object_id":"column-39095","name":"CD_COLOR","name_without_path":"CD_COLOR","description":"색상코드(SKU_MODEL_NO의 11~12)","is_pk":true,"is_identity":false,"data_type":"varchar","data_length":"20","is_nullable":false,"computed_formula":"","default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-39097","object_id":"column-39097","name":"CD_SIZE","name_without_path":"CD_SIZE","description":"사이즈코드(SKU_MODEL_NO의 13~15)","is_pk":true,"is_identity":false,"data_type":"varchar","data_length":"20","is_nullable":false,"computed_formula":"","default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-39094","object_id":"column-39094","name":"BRAND_CD","name_without_path":"BRAND_CD","description":"브랜드코드(브랜드)","is_pk":false,"is_identity":false,"data_type":"varchar","data_length":"5","is_nullable":false,"computed_formula":"","default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-39104","object_id":"column-39104","name":"QT_SALE","name_without_path":"QT_SALE","description":"판매수량","is_pk":false,"is_identity":false,"data_type":"int","data_length":"10, 0","is_nullable":false,"computed_formula":"","default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-39093","object_id":"column-39093","name":"AM_ACSALE","name_without_path":"AM_ACSALE","description":"실판매금액(수량 * 단가)","is_pk":false,"is_identity":false,"data_type":"int","data_length":"10, 0","is_nullable":false,"computed_formula":"","default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-39100","object_id":"column-39100","name":"DS_REMARK","name_without_path":"DS_REMARK","description":"비고","is_pk":false,"is_identity":false,"data_type":"varchar","data_length":"200","is_nullable":true,"computed_formula":"","default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-39103","object_id":"column-39103","name":"NO_IF","name_without_path":"NO_IF","description":"I/F번호(YYYYMMDDHH24MISS + 일련번호4자리). ERP API 호출 시의 값","is_pk":false,"is_identity":false,"data_type":"varchar","data_length":"20","is_nullable":true,"computed_formula":"","default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-39096","object_id":"column-39096","name":"CD_SALEBILL","name_without_path":"CD_SALEBILL","description":"판매전표번호(매출반영 성공 후)","is_pk":false,"is_identity":false,"data_type":"varchar","data_length":"50","is_nullable":true,"computed_formula":"","default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-39099","object_id":"column-39099","name":"DS_ERROR","name_without_path":"DS_ERROR","description":"실패메시지(매출반영 실패 후)","is_pk":false,"is_identity":false,"data_type":"varchar","data_length":"200","is_nullable":true,"computed_formula":"","default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-39105","object_id":"column-39105","name":"REG_DT","name_without_path":"REG_DT","description":"등록일시","is_pk":false,"is_identity":false,"data_type":"timestamp","data_length":null,"is_nullable":false,"computed_formula":"","default_value":"CURRENT_TIMESTAMP","path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-39107","object_id":"column-39107","name":"UPD_DT","name_without_path":"UPD_DT","description":"수정일시","is_pk":false,"is_identity":false,"data_type":"timestamp","data_length":null,"is_nullable":false,"computed_formula":"","default_value":"CURRENT_TIMESTAMP","path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]}],"relations":[],"unique_keys":[{"name":"PRIMARY","description":"ERP구분(hsmk: 한세MK, hsdr: 한세드림)","is_pk":true,"is_user_defined":false,"columns":[{"path":null,"name_without_path":"ERP_GB","name":"ERP_GB"},{"path":null,"name_without_path":"DT_SALE","name":"DT_SALE"},{"path":null,"name_without_path":"TP_SALE","name":"TP_SALE"},{"path":null,"name_without_path":"CD_STYLE","name":"CD_STYLE"},{"path":null,"name_without_path":"CD_COLOR","name":"CD_COLOR"},{"path":null,"name_without_path":"CD_SIZE","name":"CD_SIZE"}],"custom_fields":{}}],"triggers":[],"dependencies":null,"imported_at":"2021-11-11 16:37"};
|
