Начало Каталог Помощ
Вход
style24
/
style24.doc
2
0
Разклонения 0
Файлове Задачи 0 Заявки за сливане 0 Уики
ИН на ревизия: f083507d3a
Клонове Маркери
style24.doc
/
스타일24산출물(요청)_2021216
/
01.개발산출물
/
03.테이블정의서
/
data
/
t4098.json.js

t4098.json.js 12 KB
История Директен файл

1 
  1. window.repositoryObject = {"columns_custom_fields":[],"relations_custom_fields":[],"unique_keys_custom_fields":[],"triggers_custom_fields":[],"object_id":"t4098","name":"tb_order_recall_exception","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\">회수예외 (WMS에서 검수시 예외케이스 IF_TB에 생성)</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_order_recall_exception"},{"field":"Type","value":"Table"}],"columns":[{"id":"column-40389","object_id":"column-40389","name":"RECALL_EXCEPTION_NO","name_without_path":"RECALL_EXCEPTION_NO","description":"반품예외번호","is_pk":true,"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-40383","object_id":"column-40383","name":"DELIVERY_ORDER_NO","name_without_path":"DELIVERY_ORDER_NO","description":"배송번호","is_pk":false,"is_identity":false,"data_type":"unsigned int","data_length":"10, 0","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-40387","object_id":"column-40387","name":"ORDER_NO","name_without_path":"ORDER_NO","description":"주문번호","is_pk":false,"is_identity":false,"data_type":"unsigned int","data_length":"10, 0","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-40380","object_id":"column-40380","name":"CUSTOMER_NAME","name_without_path":"CUSTOMER_NAME","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-40394","object_id":"column-40394","name":"STATUS_CD","name_without_path":"STATUS_CD","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-40385","object_id":"column-40385","name":"LOGISTICS_NAME","name_without_path":"LOGISTICS_NAME","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-40384","object_id":"column-40384","name":"INVOICE_NO","name_without_path":"INVOICE_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-40390","object_id":"column-40390","name":"RECALL_STAT","name_without_path":"RECALL_STAT","description":"반품대기처리상태(P:대기 S:완료)","is_pk":false,"is_identity":false,"data_type":"char","data_length":"1","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-40391","object_id":"column-40391","name":"RECALL_STAT_DT","name_without_path":"RECALL_STAT_DT","description":"반품대기처리일시","is_pk":false,"is_identity":false,"data_type":"timestamp","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-40400","object_id":"column-40400","name":"WMS_SEND_YN","name_without_path":"WMS_SEND_YN","description":"WMS전송여부(반품대기처리완료건)Y/N","is_pk":false,"is_identity":false,"data_type":"char","data_length":"1","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-40399","object_id":"column-40399","name":"WMS_SEND_DT","name_without_path":"WMS_SEND_DT","description":"WMS전송여부일시","is_pk":false,"is_identity":false,"data_type":"timestamp","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-40376","object_id":"column-40376","name":"CHARGE_TYPE","name_without_path":"CHARGE_TYPE","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-40375","object_id":"column-40375","name":"CHARGE_AMOUNT","name_without_path":"CHARGE_AMOUNT","description":"요금총액","is_pk":false,"is_identity":false,"data_type":"int","data_length":"10, 0","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-40395","object_id":"column-40395","name":"USER_ID_CREATED","name_without_path":"USER_ID_CREATED","description":"생성자ID","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-40397","object_id":"column-40397","name":"USER_NAME_CREATED","name_without_path":"USER_NAME_CREATED","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-40381","object_id":"column-40381","name":"DATE_CREATED","name_without_path":"DATE_CREATED","description":"생성일자","is_pk":false,"is_identity":false,"data_type":"timestamp","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-40396","object_id":"column-40396","name":"USER_ID_MODIFIED","name_without_path":"USER_ID_MODIFIED","description":"수정자ID","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-40398","object_id":"column-40398","name":"USER_NAME_MODIFIED","name_without_path":"USER_NAME_MODIFIED","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-40382","object_id":"column-40382","name":"DATE_LAST_MODIFIED","name_without_path":"DATE_LAST_MODIFIED","description":"수정일자","is_pk":false,"is_identity":false,"data_type":"timestamp","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-40378","object_id":"column-40378","name":"CS_ADD_FEE","name_without_path":"CS_ADD_FEE","description":"추가비용","is_pk":false,"is_identity":false,"data_type":"int","data_length":"10, 0","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-40379","object_id":"column-40379","name":"CS_MEMO","name_without_path":"CS_MEMO","description":"C/S메모","is_pk":false,"is_identity":false,"data_type":"varchar","data_length":"2000","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-40377","object_id":"column-40377","name":"COD_FEE","name_without_path":"COD_FEE","description":"착불비","is_pk":false,"is_identity":false,"data_type":"int","data_length":"10, 0","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-40388","object_id":"column-40388","name":"PAY_GB","name_without_path":"PAY_GB","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-40386","object_id":"column-40386","name":"ORDER_EXCEPTION_NO","name_without_path":"ORDER_EXCEPTION_NO","description":"주문예외번호","is_pk":false,"is_identity":false,"data_type":"unsigned int","data_length":"10, 0","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-40374","object_id":"column-40374","name":"ADD_FEE_YN","name_without_path":"ADD_FEE_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-40393","object_id":"column-40393","name":"REG_NO","name_without_path":"REG_NO","description":"등록자NO","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-40392","object_id":"column-40392","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":null,"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":"RECALL_EXCEPTION_NO","name":"RECALL_EXCEPTION_NO"}],"custom_fields":{}}],"triggers":[],"dependencies":null,"imported_at":"2021-11-11 16:37"};
    2.