Strona główna Odkrywaj Pomoc
Zaloguj się
style24
/
style24.doc
2
0
Forkuj 0
Pliki Problemy 0 Oczekujące zmiany 0 Wiki
Drzewo: f083507d3a
Gałęzie Tagi
style24.doc
/
스타일24산출물(요청)_2021216
/
01.개발산출물
/
03.테이블정의서
/
data
/
t3778.json.js

t3778.json.js 12 KB
Historia Czysty

1 
  1. window.repositoryObject = {"columns_custom_fields":[],"relations_custom_fields":[],"unique_keys_custom_fields":[],"triggers_custom_fields":[],"object_id":"t3778","name":"mig_tb_delivery_loc","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":"mig_tb_delivery_loc"},{"field":"Type","value":"Table"}],"columns":[{"id":"column-35083","object_id":"column-35083","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-35067","object_id":"column-35067","name":"DELV_LOC_CD","name_without_path":"DELV_LOC_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-35070","object_id":"column-35070","name":"DELV_LOC_NM","name_without_path":"DELV_LOC_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-35068","object_id":"column-35068","name":"DELV_LOC_CLSF","name_without_path":"DELV_LOC_CLSF","description":"출고처분류(공통코드G024)","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-35064","object_id":"column-35064","name":"DELV_ASSIGN_ORD","name_without_path":"DELV_ASSIGN_ORD","description":"출고지정순서(출고처분류가 \"21:직송매장\"일 때만 사용)","is_pk":false,"is_identity":false,"data_type":"unsigned smallint","data_length":"5, 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-35063","object_id":"column-35063","name":"DELV_ASSIGN_GRADE","name_without_path":"DELV_ASSIGN_GRADE","description":"출고지정등급(출고처분류가 \"21:직송매장\"일 때만 사용)","is_pk":false,"is_identity":false,"data_type":"varchar","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-35082","object_id":"column-35082","name":"STOCK_APPL_RATE","name_without_path":"STOCK_APPL_RATE","description":"재고적용율(기간계로부터 수신된 재고를 가용재고로 적용하는 율. 출고처분류가 \"10:물류창고\", \"21:직송매장\"일 때만 사용)","is_pk":false,"is_identity":false,"data_type":"unsigned float","data_length":"5, 2","is_nullable":true,"computed_formula":"","default_value":"100.00","path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-35065","object_id":"column-35065","name":"DELV_FEE_RATE","name_without_path":"DELV_FEE_RATE","description":"출고수수료율","is_pk":false,"is_identity":false,"data_type":"unsigned float","data_length":"5, 2","is_nullable":true,"computed_formula":"","default_value":"0.00","path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-35071","object_id":"column-35071","name":"DELV_LOC_ZIPCODE","name_without_path":"DELV_LOC_ZIPCODE","description":"출고처우편번호","is_pk":false,"is_identity":false,"data_type":"varchar","data_length":"6","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-35066","object_id":"column-35066","name":"DELV_LOC_BASE_ADDR","name_without_path":"DELV_LOC_BASE_ADDR","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-35069","object_id":"column-35069","name":"DELV_LOC_DTL_ADDR","name_without_path":"DELV_LOC_DTL_ADDR","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-35080","object_id":"column-35080","name":"RTN_LOC_ZIPCODE","name_without_path":"RTN_LOC_ZIPCODE","description":"반품처우편번호","is_pk":false,"is_identity":false,"data_type":"varchar","data_length":"6","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-35076","object_id":"column-35076","name":"RTN_LOC_BASE_ADDR","name_without_path":"RTN_LOC_BASE_ADDR","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-35077","object_id":"column-35077","name":"RTN_LOC_DTL_ADDR","name_without_path":"RTN_LOC_DTL_ADDR","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-35079","object_id":"column-35079","name":"RTN_LOC_TELNO","name_without_path":"RTN_LOC_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-35078","object_id":"column-35078","name":"RTN_LOC_NM","name_without_path":"RTN_LOC_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-35072","object_id":"column-35072","name":"INVOICE_PRINT_TYPE","name_without_path":"INVOICE_PRINT_TYPE","description":"송장출력형태(공통코드G025)","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-35081","object_id":"column-35081","name":"SHIP_COMP_CD","name_without_path":"SHIP_COMP_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-35086","object_id":"column-35086","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-35075","object_id":"column-35075","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-35074","object_id":"column-35074","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-35085","object_id":"column-35085","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-35084","object_id":"column-35084","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":[]},{"id":"column-35062","object_id":"column-35062","name":"DELIVERY_UNIT_NO","name_without_path":"DELIVERY_UNIT_NO","description":"AS-IS 물류단위번호","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-35073","object_id":"column-35073","name":"OLD_DELV_LOC_CD","name_without_path":"OLD_DELV_LOC_CD","description":null,"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":[]}],"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"},{"path":null,"name_without_path":"DELV_LOC_CD","name":"DELV_LOC_CD"}],"custom_fields":{}}],"triggers":[],"dependencies":null,"imported_at":"2021-11-11 16:37"};
    2.