Inicio Explorar Axuda
Iniciar sesión
style24
/
style24.doc
2
0
Fork 0
Ficheiros Incidencias 0 Pull Requests 0 Wiki
Árbore: f083507d3a
Ramas Etiquetas
style24.doc
/
스타일24산출물(요청)_2021216
/
01.개발산출물
/
03.테이블정의서
/
data
/
t4180.json.js

t4180.json.js 8.8 KB
Histórico Raw

1 
  1. window.repositoryObject = {"columns_custom_fields":[],"relations_custom_fields":[],"unique_keys_custom_fields":[],"triggers_custom_fields":[],"object_id":"t4180","name":"tb_usac","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_usac"},{"field":"Type","value":"Table"}],"columns":[{"id":"column-41410","object_id":"column-41410","name":"USAC_DT","name_without_path":"USAC_DT","description":"정산일","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-41407","object_id":"column-41407","name":"SUPPLY_VENDOR_CD","name_without_path":"SUPPLY_VENDOR_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-41403","object_id":"column-41403","name":"SELL_QTY","name_without_path":"SELL_QTY","description":"판매수량","is_pk":false,"is_identity":false,"data_type":"int","data_length":"10, 0","is_nullable":false,"computed_formula":"","default_value":"0","path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-41401","object_id":"column-41401","name":"SELL_AMT","name_without_path":"SELL_AMT","description":"판매금액(=판매총액)","is_pk":false,"is_identity":false,"data_type":"int","data_length":"10, 0","is_nullable":false,"computed_formula":"","default_value":"0","path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-41396","object_id":"column-41396","name":"REAL_SELL_AMT","name_without_path":"REAL_SELL_AMT","description":"실판매금액(=상품총액)","is_pk":false,"is_identity":false,"data_type":"int","data_length":"10, 0","is_nullable":false,"computed_formula":"","default_value":"0","path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-41402","object_id":"column-41402","name":"SELL_FEE_AMT","name_without_path":"SELL_FEE_AMT","description":"판매수수료금액","is_pk":false,"is_identity":false,"data_type":"int","data_length":"10, 0","is_nullable":false,"computed_formula":"","default_value":"0","path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-41394","object_id":"column-41394","name":"CPN_DC_AMT","name_without_path":"CPN_DC_AMT","description":"쿠폰할인금액","is_pk":false,"is_identity":false,"data_type":"int","data_length":"10, 0","is_nullable":false,"computed_formula":"","default_value":"0","path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-41399","object_id":"column-41399","name":"SELF_CPN_DC_AMT","name_without_path":"SELF_CPN_DC_AMT","description":"자사쿠폰분담액","is_pk":false,"is_identity":false,"data_type":"int","data_length":"10, 0","is_nullable":false,"computed_formula":"","default_value":"0","path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-41405","object_id":"column-41405","name":"SUPPLY_COMP_CPN_DC_AMT","name_without_path":"SUPPLY_COMP_CPN_DC_AMT","description":"입점쿠폰분담액","is_pk":false,"is_identity":false,"data_type":"int","data_length":"10, 0","is_nullable":false,"computed_formula":"","default_value":"0","path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-41409","object_id":"column-41409","name":"TMTB_DC_AMT","name_without_path":"TMTB_DC_AMT","description":"다다익선할인금액","is_pk":false,"is_identity":false,"data_type":"int","data_length":"10, 0","is_nullable":false,"computed_formula":"","default_value":"0","path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-41400","object_id":"column-41400","name":"SELF_TMTB_DC_AMT","name_without_path":"SELF_TMTB_DC_AMT","description":"자사다다익선분담액","is_pk":false,"is_identity":false,"data_type":"int","data_length":"10, 0","is_nullable":false,"computed_formula":"","default_value":"0","path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-41406","object_id":"column-41406","name":"SUPPLY_COMP_TMTB_DC_AMT","name_without_path":"SUPPLY_COMP_TMTB_DC_AMT","description":"입점다다익선분담액","is_pk":false,"is_identity":false,"data_type":"int","data_length":"10, 0","is_nullable":false,"computed_formula":"","default_value":"0","path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-41393","object_id":"column-41393","name":"BILL_AMT","name_without_path":"BILL_AMT","description":"계산서발행금액(판매수수료금액 - 자사쿠폰분담액. < 0인 경우 0)","is_pk":false,"is_identity":false,"data_type":"int","data_length":"10, 0","is_nullable":false,"computed_formula":"","default_value":"0","path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-41404","object_id":"column-41404","name":"SUPPLY_AMT","name_without_path":"SUPPLY_AMT","description":"공급가액. INT(계산서발행금액 / 1.1)","is_pk":false,"is_identity":false,"data_type":"int","data_length":"10, 0","is_nullable":false,"computed_formula":"","default_value":"0","path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-41408","object_id":"column-41408","name":"TAX_AMT","name_without_path":"TAX_AMT","description":"세액(계산서발행금액 - 공급가액)","is_pk":false,"is_identity":false,"data_type":"int","data_length":"10, 0","is_nullable":false,"computed_formula":"","default_value":"0","path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-41395","object_id":"column-41395","name":"DELV_FEE","name_without_path":"DELV_FEE","description":"배송비","is_pk":false,"is_identity":false,"data_type":"int","data_length":"10, 0","is_nullable":false,"computed_formula":"","default_value":"0","path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-41398","object_id":"column-41398","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-41397","object_id":"column-41397","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":[]}],"relations":[],"unique_keys":[{"name":"PRIMARY","description":"정산일","is_pk":true,"is_user_defined":false,"columns":[{"path":null,"name_without_path":"USAC_DT","name":"USAC_DT"},{"path":null,"name_without_path":"SUPPLY_VENDOR_CD","name":"SUPPLY_VENDOR_CD"}],"custom_fields":{}}],"triggers":[],"dependencies":null,"imported_at":"2021-11-11 16:37"};
    2.