صفحهٔ اصلی گشت‌و‌گذار راهنما
ورود
style24
/
style24.doc
2
0
انشعاب 0
پرونده‌ها مشکلات 0 درخواست واکشی 0 ویکی
درخت: f083507d3a
شاخه‌ها تگ‌ها
style24.doc
/
스타일24산출물(요청)_2021216
/
01.개발산출물
/
03.테이블정의서
/
data
/
t4250.json.js

t4250.json.js 15 KB
تاريخچه خام

1 
  1. window.repositoryObject = {"columns_custom_fields":[],"relations_custom_fields":[],"unique_keys_custom_fields":[],"triggers_custom_fields":[],"object_id":"t4250","name":"tmp1007_tb_payment","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":"tmp1007_tb_payment"},{"field":"Type","value":"Table"}],"columns":[{"id":"column-42240","object_id":"column-42240","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":"0","path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-42235","object_id":"column-42235","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":true,"computed_formula":"","default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-42237","object_id":"column-42237","name":"PAY_DT","name_without_path":"PAY_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-42239","object_id":"column-42239","name":"PAY_MEANS","name_without_path":"PAY_MEANS","description":"결제수단(공통코드G014)","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-42236","object_id":"column-42236","name":"PAY_AMT","name_without_path":"PAY_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-42242","object_id":"column-42242","name":"PG_CPN_AMT","name_without_path":"PG_CPN_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-42233","object_id":"column-42233","name":"NPAY_PNT_AMT","name_without_path":"NPAY_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-42238","object_id":"column-42238","name":"PAY_GB","name_without_path":"PAY_GB","description":"결제구분(O:주문시결제, D:배송시결제, 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-42241","object_id":"column-42241","name":"PAY_STAT","name_without_path":"PAY_STAT","description":"결제상태(공통코드G016)","is_pk":false,"is_identity":false,"data_type":"varchar","data_length":"20","is_nullable":false,"computed_formula":"","default_value":"G016_00","path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-42243","object_id":"column-42243","name":"PG_GB","name_without_path":"PG_GB","description":"PG구분(공통코드G015) 외부몰: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":[]},{"id":"column-42246","object_id":"column-42246","name":"PG_TID","name_without_path":"PG_TID","description":"PG거래ID","is_pk":false,"is_identity":false,"data_type":"varchar","data_length":"100","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-42247","object_id":"column-42247","name":"PG_TRADE_NO","name_without_path":"PG_TRADE_NO","description":"PG거래번호(승인번호)","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-42244","object_id":"column-42244","name":"PG_SHOP_ID","name_without_path":"PG_SHOP_ID","description":"PG가맹점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-42245","object_id":"column-42245","name":"PG_SHOP_KEY","name_without_path":"PG_SHOP_KEY","description":"PG가맹점KEY","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-42227","object_id":"column-42227","name":"CARD_TYPE","name_without_path":"CARD_TYPE","description":"PG카드유형 사용안함(Y:체크카드, N:신용카드, G:기프트카드) 결제수단이 \"30:신용카드\"일 때 사용. PG사에서 받은 값","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-42223","object_id":"column-42223","name":"CARD_KIND","name_without_path":"CARD_KIND","description":"카드종류 사용안함. 결제수단이 \"30:신용카드\"일 때 사용. PG사에서 받은 값","is_pk":false,"is_identity":false,"data_type":"varchar","data_length":"5","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-42221","object_id":"column-42221","name":"CARD_BANK","name_without_path":"CARD_BANK","description":"카드발급은행 사용안함. 결제수단이 \"30:신용카드\"일 때 사용. PG사에서 받은 값","is_pk":false,"is_identity":false,"data_type":"varchar","data_length":"10","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-42222","object_id":"column-42222","name":"CARD_CD","name_without_path":"CARD_CD","description":"카드발급사코드. 결제수단이 \"30:신용카드\"일 때 사용. PG사에서 받은 값","is_pk":false,"is_identity":false,"data_type":"varchar","data_length":"10","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-42225","object_id":"column-42225","name":"CARD_NM","name_without_path":"CARD_NM","description":"카드명. 결제수단이 \"30:신용카드\"일 때 사용. PG사에서 받은 값","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-42230","object_id":"column-42230","name":"COM_CARD_CD","name_without_path":"COM_CARD_CD","description":"카드공통코드(공통코드G050)","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-42224","object_id":"column-42224","name":"CARD_MIPS","name_without_path":"CARD_MIPS","description":"카드할부개월수. 결제수단이 \"30:신용카드\"일 때 사용. PG사에서 받은 값","is_pk":false,"is_identity":false,"data_type":"varchar","data_length":"2","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-42226","object_id":"column-42226","name":"CARD_PCABLE_YN","name_without_path":"CARD_PCABLE_YN","description":"부분취소가능여부","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-42256","object_id":"column-42256","name":"VA_NO","name_without_path":"VA_NO","description":"가상계좌번호. 결제수단이 \"20:무통장입금일\" 때 사용","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-42255","object_id":"column-42255","name":"VA_NM","name_without_path":"VA_NM","description":"가상계좌예금주명. 결제수단이 \"20:무통장입금일\" 때 사용","is_pk":false,"is_identity":false,"data_type":"varchar","data_length":"100","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-42253","object_id":"column-42253","name":"VA_BANK","name_without_path":"VA_BANK","description":"가상계좌은행(공통코드G940). 결제수단이 \"20:무통장입금일\" 때 사용","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-42254","object_id":"column-42254","name":"VA_DEADLINE","name_without_path":"VA_DEADLINE","description":"무통장입금마감일시. 결제수단이 \"20:무통장입금일\" 때 사용","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-42250","object_id":"column-42250","name":"TELECOM","name_without_path":"TELECOM","description":"통신사.결제수단이 휴대폰결제인경우만 사용","is_pk":false,"is_identity":false,"data_type":"varchar","data_length":"3","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-42231","object_id":"column-42231","name":"ESCROW_YN","name_without_path":"ESCROW_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-42228","object_id":"column-42228","name":"CASH_AUTH_NO","name_without_path":"CASH_AUTH_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-42229","object_id":"column-42229","name":"CASH_TRADE_NO","name_without_path":"CASH_TRADE_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-42234","object_id":"column-42234","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":true,"computed_formula":"","default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-42249","object_id":"column-42249","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-42248","object_id":"column-42248","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-42252","object_id":"column-42252","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-42251","object_id":"column-42251","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-42232","object_id":"column-42232","name":"NPAY_DECISION_YN","name_without_path":"NPAY_DECISION_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":[]}],"relations":[],"unique_keys":[],"triggers":[],"dependencies":null,"imported_at":"2021-11-11 16:37"};
    2.