Home Esplora Aiuto
Accedi
style24
/
style24.doc
2
0
Forka 0
File Problemi 0 Pull Requests 0 Wiki
Albero (Tree): f083507d3a
Rami (Branch) Tag
style24.doc
/
스타일24산출물(요청)_2021216
/
01.개발산출물
/
03.테이블정의서
/
data
/
t3754.json.js

t3754.json.js 11 KB
Cronologia Originale

1 
  1. window.repositoryObject = {"columns_custom_fields":[],"relations_custom_fields":[],"unique_keys_custom_fields":[],"triggers_custom_fields":[],"object_id":"t3754","name":"back1_tb_refund","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":"back1_tb_refund"},{"field":"Type","value":"Table"}],"columns":[{"id":"column-34870","object_id":"column-34870","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-34871","object_id":"column-34871","name":"PAY_SQ","name_without_path":"PAY_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-34869","object_id":"column-34869","name":"ORD_CHG_SQ","name_without_path":"ORD_CHG_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-34875","object_id":"column-34875","name":"REFUND_AMT","name_without_path":"REFUND_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-34867","object_id":"column-34867","name":"DEPOSIT_AMT","name_without_path":"DEPOSIT_AMT","description":"입금금액(PG점프)","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-34874","object_id":"column-34874","name":"RA_NO","name_without_path":"RA_NO","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-34872","object_id":"column-34872","name":"RA_BANK","name_without_path":"RA_BANK","description":"환불계좌은행(공통코드G940). 결제수단이 \"무통장입금\"일 때 사용.","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-34873","object_id":"column-34873","name":"RA_NM","name_without_path":"RA_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-34880","object_id":"column-34880","name":"RF_CPN1_AMT","name_without_path":"RF_CPN1_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-34890","object_id":"column-34890","name":"RF_TMTB1_AMT","name_without_path":"RF_TMTB1_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-34891","object_id":"column-34891","name":"RF_TMTB2_AMT","name_without_path":"RF_TMTB2_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-34885","object_id":"column-34885","name":"RF_GOODS_CPN_AMT","name_without_path":"RF_GOODS_CPN_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-34878","object_id":"column-34878","name":"RF_CART_CPN_AMT","name_without_path":"RF_CART_CPN_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-34882","object_id":"column-34882","name":"RF_DELV_CPN_AMT","name_without_path":"RF_DELV_CPN_AMT","description":"환불배송비쿠폰할인금액","is_pk":false,"is_identity":false,"data_type":"int","data_length":"10, 0","is_nullable":true,"computed_formula":"","default_value":"0","path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-34887","object_id":"column-34887","name":"RF_PNT_AMT","name_without_path":"RF_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-34888","object_id":"column-34888","name":"RF_PRE_PNT_AMT","name_without_path":"RF_PRE_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-34884","object_id":"column-34884","name":"RF_GFCD_USE_AMT","name_without_path":"RF_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-34883","object_id":"column-34883","name":"RF_DELV_GFCD_USE_AMT","name_without_path":"RF_DELV_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-34879","object_id":"column-34879","name":"RF_CNCL_AMT","name_without_path":"RF_CNCL_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-34881","object_id":"column-34881","name":"RF_DELIVERY_FEE","name_without_path":"RF_DELIVERY_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-34889","object_id":"column-34889","name":"RF_REAL_CNCL_AMT","name_without_path":"RF_REAL_CNCL_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-34866","object_id":"column-34866","name":"CUST_DELV_COST","name_without_path":"CUST_DELV_COST","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-34886","object_id":"column-34886","name":"RF_MEMO","name_without_path":"RF_MEMO","description":"환불메모(AS-IS 데이터 확인용)","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-34877","object_id":"column-34877","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-34876","object_id":"column-34876","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-34868","object_id":"column-34868","name":"ENC_UPD_YN","name_without_path":"ENC_UPD_YN","description":"계좌번호암호화여부(마이그레이션)","is_pk":false,"is_identity":false,"data_type":"char","data_length":"1","is_nullable":true,"computed_formula":"","default_value":"Y","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"};
    2.