| 1 |
- window.repositoryObject = {"columns_custom_fields":[],"relations_custom_fields":[],"unique_keys_custom_fields":[],"triggers_custom_fields":[],"object_id":"t4168","name":"tb_supply_company","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_supply_company"},{"field":"Type","value":"Table"}],"columns":[{"id":"column-41277","object_id":"column-41277","name":"SUPPLY_COMP_CD","name_without_path":"SUPPLY_COMP_CD","description":"공급업체코드","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-41278","object_id":"column-41278","name":"SUPPLY_COMP_NM","name_without_path":"SUPPLY_COMP_NM","description":"공급업체명","is_pk":false,"is_identity":false,"data_type":"varchar","data_length":"100","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-41280","object_id":"column-41280","name":"SUPPLY_VENDOR_CD","name_without_path":"SUPPLY_VENDOR_CD","description":"공급업체벤더코드(공급업체벤더)","is_pk":false,"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-41267","object_id":"column-41267","name":"PROVIDER_NO","name_without_path":"PROVIDER_NO","description":"ProviderNo(WMS)","is_pk":false,"is_identity":false,"data_type":"unsigned 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-41261","object_id":"column-41261","name":"CS_CHARGE_NM","name_without_path":"CS_CHARGE_NM","description":"CS담당자명","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-41262","object_id":"column-41262","name":"CS_CHARGE_TELNO","name_without_path":"CS_CHARGE_TELNO","description":"CS담당자전화번호","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-41273","object_id":"column-41273","name":"SETTLE_CHARGE_NM","name_without_path":"SETTLE_CHARGE_NM","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-41274","object_id":"column-41274","name":"SETTLE_CHARGE_TELNO","name_without_path":"SETTLE_CHARGE_TELNO","description":"정산담당자전화번호","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-41272","object_id":"column-41272","name":"SETTLE_CHARGE_EMAIL","name_without_path":"SETTLE_CHARGE_EMAIL","description":"정산담당자이메일","is_pk":false,"is_identity":false,"data_type":"varchar","data_length":"100","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-41264","object_id":"column-41264","name":"DISTRIBUTION_GB","name_without_path":"DISTRIBUTION_GB","description":"유통구분(공통코드 G065)","is_pk":false,"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-41276","object_id":"column-41276","name":"SHOT_DELV_YN","name_without_path":"SHOT_DELV_YN","description":"총알배송여부","is_pk":false,"is_identity":false,"data_type":"char","data_length":"1","is_nullable":false,"computed_formula":"","default_value":"N","path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-41279","object_id":"column-41279","name":"SUPPLY_STAT","name_without_path":"SUPPLY_STAT","description":"입점상태(공통코드G010)","is_pk":false,"is_identity":false,"data_type":"varchar","data_length":"20","is_nullable":false,"computed_formula":"","default_value":"10","path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-41271","object_id":"column-41271","name":"SELL_FEE_RATE","name_without_path":"SELL_FEE_RATE","description":"판매수수료율","is_pk":false,"is_identity":false,"data_type":"unsigned float","data_length":"5, 2","is_nullable":false,"computed_formula":"","default_value":"0.00","path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-41275","object_id":"column-41275","name":"SETTLE_DAY","name_without_path":"SETTLE_DAY","description":"정산일(공통코드G075)","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-41259","object_id":"column-41259","name":"BANK_CD","name_without_path":"BANK_CD","description":"은행코드(공통코드G940)","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-41258","object_id":"column-41258","name":"ACCOUNT_NO","name_without_path":"ACCOUNT_NO","description":"계좌번호","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-41263","object_id":"column-41263","name":"DEPOSITOR_NM","name_without_path":"DEPOSITOR_NM","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-41260","object_id":"column-41260","name":"BILL_EMAIL","name_without_path":"BILL_EMAIL","description":"계산서이메일","is_pk":false,"is_identity":false,"data_type":"varchar","data_length":"100","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-41265","object_id":"column-41265","name":"ECONTRACT_YN","name_without_path":"ECONTRACT_YN","description":"전자계약여부","is_pk":false,"is_identity":false,"data_type":"char","data_length":"1","is_nullable":false,"computed_formula":"","default_value":"N","path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-41270","object_id":"column-41270","name":"REMARKS","name_without_path":"REMARKS","description":"비고","is_pk":false,"is_identity":false,"data_type":"varchar","data_length":"4000","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-41266","object_id":"column-41266","name":"NOTE","name_without_path":"NOTE","description":"배송안내정보(상품상세FRONT노출용)","is_pk":false,"is_identity":false,"data_type":"text","data_length":null,"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-41283","object_id":"column-41283","name":"USE_YN","name_without_path":"USE_YN","description":"사용여부(Y:사용)","is_pk":false,"is_identity":false,"data_type":"char","data_length":"1","is_nullable":false,"computed_formula":"","default_value":"Y","path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-41269","object_id":"column-41269","name":"REG_NO","name_without_path":"REG_NO","description":"등록자번호","is_pk":false,"is_identity":false,"data_type":"unsigned 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-41268","object_id":"column-41268","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-41282","object_id":"column-41282","name":"UPD_NO","name_without_path":"UPD_NO","description":"수정자번호","is_pk":false,"is_identity":false,"data_type":"unsigned 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-41281","object_id":"column-41281","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":"공급업체코드","is_pk":true,"is_user_defined":false,"columns":[{"path":null,"name_without_path":"SUPPLY_COMP_CD","name":"SUPPLY_COMP_CD"}],"custom_fields":{}}],"triggers":[],"dependencies":null,"imported_at":"2021-11-11 16:37"};
|