t4089.json.js 30 KB

1
  1. window.repositoryObject = {"columns_custom_fields":[],"relations_custom_fields":[],"unique_keys_custom_fields":[],"triggers_custom_fields":[],"object_id":"t4089","name":"tb_order_detail_hst_2021","subtype":"TABLE","is_user_defined":false,"description":null,"summary":[{"field":"Documentation","value":{"_type":"link","name":"style24@172.30.90.100","id":"d10"}},{"field":"Schema","value":""},{"field":"Name","value":"tb_order_detail_hst_2021"},{"field":"Type","value":"Table"}],"columns":[{"id":"column-40110","object_id":"column-40110","name":"ORD_DTL_HST_SQ","name_without_path":"ORD_DTL_HST_SQ","description":"주문상세이력번호","is_pk":false,"is_identity":false,"data_type":"unsigned 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-40111","object_id":"column-40111","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-40114","object_id":"column-40114","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-40113","object_id":"column-40113","name":"ORD_EXCH_GB","name_without_path":"ORD_EXCH_GB","description":"주문교환구분(O:주문,E:교환)","is_pk":false,"is_identity":false,"data_type":"char","data_length":"1","is_nullable":false,"computed_formula":"","default_value":"O","path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-40112","object_id":"column-40112","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-40116","object_id":"column-40116","name":"ORG_ORD_DTL_NO","name_without_path":"ORG_ORD_DTL_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-40135","object_id":"column-40135","name":"SUPPLY_COMP_CD","name_without_path":"SUPPLY_COMP_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-40099","object_id":"column-40099","name":"GOODS_CD","name_without_path":"GOODS_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-40083","object_id":"column-40083","name":"DEAL_GOODS_CD","name_without_path":"DEAL_GOODS_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-40095","object_id":"column-40095","name":"FORMAL_GB","name_without_path":"FORMAL_GB","description":"정상이월구분(공통코드G009)","is_pk":false,"is_identity":false,"data_type":"varchar","data_length":"20","is_nullable":true,"computed_formula":"","default_value":"G009_10","path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-40102","object_id":"column-40102","name":"GOODS_TYPE","name_without_path":"GOODS_TYPE","description":"상품타입(공통코드G056)","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-40106","object_id":"column-40106","name":"LIST_PRICE","name_without_path":"LIST_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-40081","object_id":"column-40081","name":"CURR_PRICE","name_without_path":"CURR_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-40082","object_id":"column-40082","name":"DC_RATE","name_without_path":"DC_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-40108","object_id":"column-40108","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-40115","object_id":"column-40115","name":"ORD_QTY","name_without_path":"ORD_QTY","description":"주문수량","is_pk":false,"is_identity":false,"data_type":"unsigned smallint","data_length":"5, 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-40109","object_id":"column-40109","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-40077","object_id":"column-40077","name":"CNCL_RTN_QTY","name_without_path":"CNCL_RTN_QTY","description":"취소반품수량","is_pk":false,"is_identity":false,"data_type":"unsigned smallint","data_length":"5, 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-40076","object_id":"column-40076","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-40079","object_id":"column-40079","name":"CPN1_CPN_SQ","name_without_path":"CPN1_CPN_SQ","description":"1차쿠폰(즉시할인쿠폰)일련번호(고객보유쿠폰일련번호)","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-40080","object_id":"column-40080","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-40137","object_id":"column-40137","name":"TMTB1_SQ","name_without_path":"TMTB1_SQ","description":"다다익선1일련번호(수량)","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-40136","object_id":"column-40136","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-40139","object_id":"column-40139","name":"TMTB2_SQ","name_without_path":"TMTB2_SQ","description":"다다익선2일련번호(금액)","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-40138","object_id":"column-40138","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-40101","object_id":"column-40101","name":"GOODS_CPN_SQ","name_without_path":"GOODS_CPN_SQ","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-40100","object_id":"column-40100","name":"GOODS_CPN_DC_AMT","name_without_path":"GOODS_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-40073","object_id":"column-40073","name":"CART_CPN_SQ","name_without_path":"CART_CPN_SQ","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-40072","object_id":"column-40072","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-40071","object_id":"column-40071","name":"BURDEN_RATE","name_without_path":"BURDEN_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-40118","object_id":"column-40118","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-40119","object_id":"column-40119","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-40125","object_id":"column-40125","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-40120","object_id":"column-40120","name":"REAL_ORD_AMT","name_without_path":"REAL_ORD_AMT","description":"실주문금액(주문금액 - 취소반품금액 - 1차쿠폰 - 다다익선1 - 다다익선2 - 상품쿠폰 - 장바구니쿠폰 - 포인트할인금액 - 선포인트할인금액)","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-40096","object_id":"column-40096","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":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-40142","object_id":"column-40142","name":"VENDOR_ID","name_without_path":"VENDOR_ID","description":"외부몰벤더ID(공통코드G003)","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-40093","object_id":"column-40093","name":"EXTMALL_ID","name_without_path":"EXTMALL_ID","description":"외부몰ID(외부몰)","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-40070","object_id":"column-40070","name":"AGENT_ORDER_ID","name_without_path":"AGENT_ORDER_ID","description":"에이전트주문번호. 몰구분이 \"G011_20:외부몰\"일 때 사용","is_pk":false,"is_identity":false,"data_type":"varchar","data_length":"30","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-40094","object_id":"column-40094","name":"EXTMALL_ORDER_ID","name_without_path":"EXTMALL_ORDER_ID","description":"외부몰주문번호(=쇼핑몰주문번호). 몰구분이 \"G011_20:외부몰\"일 때 사용","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-40075","object_id":"column-40075","name":"CHANGEABLE_YN","name_without_path":"CHANGEABLE_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-40074","object_id":"column-40074","name":"CHANGE_FEE_FREE_YN","name_without_path":"CHANGE_FEE_FREE_YN","description":"교환배송비무료여부(Y:교환배송비무료)","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-40124","object_id":"column-40124","name":"RETURNABLE_YN","name_without_path":"RETURNABLE_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-40123","object_id":"column-40123","name":"RETURN_FEE_FREE_YN","name_without_path":"RETURN_FEE_FREE_YN","description":"반품배송비무료여부(Y:반품배송비무료)","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-40134","object_id":"column-40134","name":"SOLDOUT_YN","name_without_path":"SOLDOUT_YN","description":"결품여부(Y:결품)","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-40131","object_id":"column-40131","name":"SOLDOUT_MEMO","name_without_path":"SOLDOUT_MEMO","description":"결품메모","is_pk":false,"is_identity":false,"data_type":"varchar","data_length":"500","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-40133","object_id":"column-40133","name":"SOLDOUT_REG_NO","name_without_path":"SOLDOUT_REG_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-40132","object_id":"column-40132","name":"SOLDOUT_REG_DT","name_without_path":"SOLDOUT_REG_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-40084","object_id":"column-40084","name":"DELV_ADDR_SQ","name_without_path":"DELV_ADDR_SQ","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-40088","object_id":"column-40088","name":"DELV_FEE_CD","name_without_path":"DELV_FEE_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-40129","object_id":"column-40129","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-40098","object_id":"column-40098","name":"GIFT_PACK_YN","name_without_path":"GIFT_PACK_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-40097","object_id":"column-40097","name":"GIFT_ADDR_INP_YN","name_without_path":"GIFT_ADDR_INP_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-40107","object_id":"column-40107","name":"MAKE_GOODS_YN","name_without_path":"MAKE_GOODS_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-40092","object_id":"column-40092","name":"ENTRY_NO","name_without_path":"ENTRY_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-40089","object_id":"column-40089","name":"DELV_LOC_CD","name_without_path":"DELV_LOC_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-40085","object_id":"column-40085","name":"DELV_ASSIGN_DT","name_without_path":"DELV_ASSIGN_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-40086","object_id":"column-40086","name":"DELV_ASSIGN_STAT","name_without_path":"DELV_ASSIGN_STAT","description":"출고지정상태(P:대기,Y:수락,N:거부). 입점은 DEFAULT 'Y'","is_pk":false,"is_identity":false,"data_type":"char","data_length":"1","is_nullable":false,"computed_formula":"","default_value":"P","path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-40091","object_id":"column-40091","name":"DSTRBT_NOTE","name_without_path":"DSTRBT_NOTE","description":"물류비고(물류담당자에게 공지)","is_pk":false,"is_identity":false,"data_type":"varchar","data_length":"1000","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-40090","object_id":"column-40090","name":"DELV_STDT","name_without_path":"DELV_STDT","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-40087","object_id":"column-40087","name":"DELV_EDDT","name_without_path":"DELV_EDDT","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-40128","object_id":"column-40128","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-40103","object_id":"column-40103","name":"INVOICE_NO","name_without_path":"INVOICE_NO","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-40104","object_id":"column-40104","name":"INVOICE_SEND_YN","name_without_path":"INVOICE_SEND_YN","description":"송장전송여부(Y:전송완료, N:전송미완료, X:전송할필요없음)","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-40127","object_id":"column-40127","name":"SELL_STORE_CD","name_without_path":"SELL_STORE_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-40126","object_id":"column-40126","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-40069","object_id":"column-40069","name":"AF_LINK_CD","name_without_path":"AF_LINK_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-40105","object_id":"column-40105","name":"ITHR_CD","name_without_path":"ITHR_CD","description":"유입경로(공통코드G027)","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-40078","object_id":"column-40078","name":"CONTENTS_LOC","name_without_path":"CONTENTS_LOC","description":"컨텐츠위치(공통코드G028)","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-40117","object_id":"column-40117","name":"PLAN_DTL_SQ","name_without_path":"PLAN_DTL_SQ","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-40130","object_id":"column-40130","name":"SOCIAL_SQ","name_without_path":"SOCIAL_SQ","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-40122","object_id":"column-40122","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-40121","object_id":"column-40121","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-40141","object_id":"column-40141","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-40140","object_id":"column-40140","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":[],"triggers":[],"dependencies":null,"imported_at":"2021-11-11 16:37"};