Página inicial Explorar Ajuda
Entrar
style24
/
style24.doc
2
0
Fork 0
Arquivos Issues 0 Pull Requests 0 Wiki
Tree: f083507d3a
Branches Tags
style24.doc
/
스타일24산출물(요청)_2021216
/
01.개발산출물
/
03.테이블정의서
/
data
/
t3816.json.js

t3816.json.js 20 KB
Histórico Raw

1 
  1. window.repositoryObject = {"columns_custom_fields":[],"relations_custom_fields":[],"unique_keys_custom_fields":[],"triggers_custom_fields":[],"object_id":"t3816","name":"old_ord_order","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":"old_ord_order"},{"field":"Type","value":"Table"}],"columns":[{"id":"column-35604","object_id":"column-35604","name":"OrderGUID","name_without_path":"OrderGUID","description":null,"is_pk":true,"is_identity":false,"data_type":"varchar","data_length":"36","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-35605","object_id":"column-35605","name":"OrderNo","name_without_path":"OrderNo","description":null,"is_pk":false,"is_identity":false,"data_type":"bigint","data_length":"19, 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-35585","object_id":"column-35585","name":"DateOrdered","name_without_path":"DateOrdered","description":null,"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-35607","object_id":"column-35607","name":"OrderStatusCd","name_without_path":"OrderStatusCd","description":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-35584","object_id":"column-35584","name":"CustomerTypeCd","name_without_path":"CustomerTypeCd","description":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-35583","object_id":"column-35583","name":"CustomerName","name_without_path":"CustomerName","description":null,"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-35595","object_id":"column-35595","name":"Gender","name_without_path":"Gender","description":null,"is_pk":false,"is_identity":false,"data_type":"char","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-35600","object_id":"column-35600","name":"LoginId","name_without_path":"LoginId","description":null,"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-35612","object_id":"column-35612","name":"PID","name_without_path":"PID","description":null,"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-35606","object_id":"column-35606","name":"OrderPwd","name_without_path":"OrderPwd","description":null,"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-35620","object_id":"column-35620","name":"TelNum","name_without_path":"TelNum","description":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-35575","object_id":"column-35575","name":"CellNum","name_without_path":"CellNum","description":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-35582","object_id":"column-35582","name":"CustomerEmail","name_without_path":"CustomerEmail","description":null,"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-35615","object_id":"column-35615","name":"Receiver","name_without_path":"Receiver","description":null,"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-35617","object_id":"column-35617","name":"ReceiverTelNum","name_without_path":"ReceiverTelNum","description":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-35616","object_id":"column-35616","name":"ReceiverCellNum","name_without_path":"ReceiverCellNum","description":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-35591","object_id":"column-35591","name":"DeliveryPostalCode","name_without_path":"DeliveryPostalCode","description":null,"is_pk":false,"is_identity":false,"data_type":"char","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-35586","object_id":"column-35586","name":"DeliveryAddr1","name_without_path":"DeliveryAddr1","description":null,"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-35587","object_id":"column-35587","name":"DeliveryAddr2","name_without_path":"DeliveryAddr2","description":null,"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-35590","object_id":"column-35590","name":"DeliveryMemo","name_without_path":"DeliveryMemo","description":null,"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-35610","object_id":"column-35610","name":"PaymentTypeCd","name_without_path":"PaymentTypeCd","description":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-35613","object_id":"column-35613","name":"ProductSummary","name_without_path":"ProductSummary","description":null,"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-35599","object_id":"column-35599","name":"ItemTotal","name_without_path":"ItemTotal","description":null,"is_pk":false,"is_identity":false,"data_type":"decimal","data_length":"19, 4","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-35589","object_id":"column-35589","name":"DeliveryCostTotal","name_without_path":"DeliveryCostTotal","description":null,"is_pk":false,"is_identity":false,"data_type":"decimal","data_length":"19, 4","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-35593","object_id":"column-35593","name":"DiscountTotal","name_without_path":"DiscountTotal","description":null,"is_pk":false,"is_identity":false,"data_type":"decimal","data_length":"19, 4","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-35622","object_id":"column-35622","name":"UsedMileage","name_without_path":"UsedMileage","description":null,"is_pk":false,"is_identity":false,"data_type":"decimal","data_length":"19, 4","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-35609","object_id":"column-35609","name":"PaymentTotal","name_without_path":"PaymentTotal","description":null,"is_pk":false,"is_identity":false,"data_type":"decimal","data_length":"19, 4","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-35574","object_id":"column-35574","name":"AdminMemo","name_without_path":"AdminMemo","description":null,"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-35576","object_id":"column-35576","name":"ChannelCd","name_without_path":"ChannelCd","description":null,"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-35577","object_id":"column-35577","name":"CouponDiscount","name_without_path":"CouponDiscount","description":null,"is_pk":false,"is_identity":false,"data_type":"decimal","data_length":"19, 4","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-35614","object_id":"column-35614","name":"PromotionDiscount","name_without_path":"PromotionDiscount","description":null,"is_pk":false,"is_identity":false,"data_type":"decimal","data_length":"19, 4","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-35601","object_id":"column-35601","name":"MarginTotal","name_without_path":"MarginTotal","description":null,"is_pk":false,"is_identity":false,"data_type":"decimal","data_length":"19, 4","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-35608","object_id":"column-35608","name":"OrderTypeCd","name_without_path":"OrderTypeCd","description":null,"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-35579","object_id":"column-35579","name":"CouponDiscountTypeCd","name_without_path":"CouponDiscountTypeCd","description":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-35578","object_id":"column-35578","name":"CouponDiscountDesc","name_without_path":"CouponDiscountDesc","description":null,"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-35618","object_id":"column-35618","name":"ResultCode","name_without_path":"ResultCode","description":null,"is_pk":false,"is_identity":false,"data_type":"char","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-35619","object_id":"column-35619","name":"ResultMsg","name_without_path":"ResultMsg","description":null,"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-35594","object_id":"column-35594","name":"ErrorMethod","name_without_path":"ErrorMethod","description":null,"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-35623","object_id":"column-35623","name":"UsedOCBPoint","name_without_path":"UsedOCBPoint","description":null,"is_pk":false,"is_identity":false,"data_type":"decimal","data_length":"19, 4","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-35598","object_id":"column-35598","name":"IsOCBMileage","name_without_path":"IsOCBMileage","description":null,"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-35603","object_id":"column-35603","name":"OCBMileage","name_without_path":"OCBMileage","description":null,"is_pk":false,"is_identity":false,"data_type":"decimal","data_length":"19, 4","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-35602","object_id":"column-35602","name":"MemberGUID","name_without_path":"MemberGUID","description":null,"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-35597","object_id":"column-35597","name":"IsDailyDelivery","name_without_path":"IsDailyDelivery","description":null,"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-35596","object_id":"column-35596","name":"IsBeautyDelivery","name_without_path":"IsBeautyDelivery","description":null,"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-35624","object_id":"column-35624","name":"VendorOrderNo","name_without_path":"VendorOrderNo","description":null,"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-35581","object_id":"column-35581","name":"CouponMinAmount","name_without_path":"CouponMinAmount","description":null,"is_pk":false,"is_identity":false,"data_type":"decimal","data_length":"19, 4","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-35621","object_id":"column-35621","name":"TokenAmt","name_without_path":"TokenAmt","description":null,"is_pk":false,"is_identity":false,"data_type":"decimal","data_length":"19, 4","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-35588","object_id":"column-35588","name":"DeliveryAddrNew","name_without_path":"DeliveryAddrNew","description":null,"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-35580","object_id":"column-35580","name":"CouponId","name_without_path":"CouponId","description":null,"is_pk":false,"is_identity":false,"data_type":"bigint","data_length":"19, 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-35592","object_id":"column-35592","name":"Device","name_without_path":"Device","description":null,"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-35611","object_id":"column-35611","name":"PGType","name_without_path":"PGType","description":null,"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":[]}],"relations":[],"unique_keys":[{"name":"PRIMARY","description":null,"is_pk":true,"is_user_defined":false,"columns":[{"path":null,"name_without_path":"OrderGUID","name":"OrderGUID"}],"custom_fields":{}},{"name":"UIX_ORD_ORDER_01","description":null,"is_pk":false,"is_user_defined":false,"columns":[{"path":null,"name_without_path":"OrderNo","name":"OrderNo"}],"custom_fields":{}}],"triggers":[],"dependencies":null,"imported_at":"2021-11-11 16:37"};
    2.