주문상세단품. 신규 주문 등록에 의한 발생
\r\n ","summary":[{"field":"Documentation","value":{"_type":"link","name":"style24@172.30.90.100","id":"d10"}},{"field":"Schema","value":""},{"field":"Name","value":"tb_order_detail_item"},{"field":"Type","value":"Table"}],"columns":[{"id":"column-40168","object_id":"column-40168","name":"ORD_DTL_ITEM_SQ","name_without_path":"ORD_DTL_ITEM_SQ","description":"주문상세단품일련번호","is_pk":true,"is_identity":true,"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-40169","object_id":"column-40169","name":"ORD_DTL_NO","name_without_path":"ORD_DTL_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-40171","object_id":"column-40171","name":"ORD_NO","name_without_path":"ORD_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-40170","object_id":"column-40170","name":"ORD_DTL_STAT","name_without_path":"ORD_DTL_STAT","description":"주문상세상태(공통코드G013)","is_pk":false,"is_identity":false,"data_type":"varchar","data_length":"20","is_nullable":false,"computed_formula":"","default_value":"G013_00","path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-40160","object_id":"column-40160","name":"ITEM_CD","name_without_path":"ITEM_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-40164","object_id":"column-40164","name":"OPT_CD","name_without_path":"OPT_CD","description":"옵션코드","is_pk":false,"is_identity":false,"data_type":"varchar","data_length":"200","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-40165","object_id":"column-40165","name":"OPT_CD1","name_without_path":"OPT_CD1","description":"옵션코드1","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-40166","object_id":"column-40166","name":"OPT_CD2","name_without_path":"OPT_CD2","description":"옵션코드2","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-40180","object_id":"column-40180","name":"SKU_MODEL_NO","name_without_path":"SKU_MODEL_NO","description":"SKUModelNo(WMS)","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-40175","object_id":"column-40175","name":"PRODUCT_NO","name_without_path":"PRODUCT_NO","description":"ProductNo(WMS)","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-40174","object_id":"column-40174","name":"PRODUCT_CODE","name_without_path":"PRODUCT_CODE","description":"ProductCode(WMS)","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-40162","object_id":"column-40162","name":"ITEM_QTY","name_without_path":"ITEM_QTY","description":"단품수량","is_pk":false,"is_identity":false,"data_type":"unsigned smallint","data_length":"5, 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-40161","object_id":"column-40161","name":"ITEM_PRICE","name_without_path":"ITEM_PRICE","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-40163","object_id":"column-40163","name":"OPT_ADD_PRICE","name_without_path":"OPT_ADD_PRICE","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-40157","object_id":"column-40157","name":"DISP_ORD","name_without_path":"DISP_ORD","description":"표시순서","is_pk":false,"is_identity":false,"data_type":"unsigned smallint","data_length":"5, 0","is_nullable":false,"computed_formula":"","default_value":"1","path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-40167","object_id":"column-40167","name":"ORD_AMT","name_without_path":"ORD_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-40155","object_id":"column-40155","name":"CNCL_RTN_AMT","name_without_path":"CNCL_RTN_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-40156","object_id":"column-40156","name":"CPN1_DC_AMT","name_without_path":"CPN1_DC_AMT","description":"단품 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-40181","object_id":"column-40181","name":"TMTB1_DC_AMT","name_without_path":"TMTB1_DC_AMT","description":"단품 다다익선 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-40182","object_id":"column-40182","name":"TMTB2_DC_AMT","name_without_path":"TMTB2_DC_AMT","description":"단품 다다익선 2차 할인금액","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-40159","object_id":"column-40159","name":"GOODS_CPN_DC_AMT","name_without_path":"GOODS_CPN_DC_AMT","description":"단품 2차쿠폰 할인금액","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-40154","object_id":"column-40154","name":"CART_CPN_DC_AMT","name_without_path":"CART_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-40172","object_id":"column-40172","name":"PNT_DC_AMT","name_without_path":"PNT_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-40173","object_id":"column-40173","name":"PRE_PNT_DC_AMT","name_without_path":"PRE_PNT_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-40179","object_id":"column-40179","name":"SAVE_PNT_AMT","name_without_path":"SAVE_PNT_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-40176","object_id":"column-40176","name":"REAL_ORD_AMT","name_without_path":"REAL_ORD_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-40158","object_id":"column-40158","name":"GFCD_USE_AMT","name_without_path":"GFCD_USE_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-40178","object_id":"column-40178","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-40177","object_id":"column-40177","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-40184","object_id":"column-40184","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-40183","object_id":"column-40183","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":"ORD_DTL_ITEM_SQ","name":"ORD_DTL_ITEM_SQ"}],"custom_fields":{}}],"triggers":[],"dependencies":null,"imported_at":"2021-11-11 16:37"};