set feedback off


-- 初始化错误码扩展表
delete from errorcodeex;


insert into ERRORCODEEX (ERRORID, DESCRIPTIONZH_CN, DESCRIPTIONEN, DESCRIPTIONZH_TW, DESCRIPTIONTH, DESCRIPTIONVI)
values ('3810', '结算价录入不完整', 'Incomplete entry of settlement price', '結算價錄入不完整', 'การป้อนราคาปิดบัญชีไม่สมบูรณ์', 'Nhập giá quyết toán không hoàn chỉnh');
insert into ERRORCODEEX (ERRORID, DESCRIPTIONZH_CN, DESCRIPTIONEN, DESCRIPTIONZH_TW, DESCRIPTIONTH, DESCRIPTIONVI)
values ('3940', '找不到对应积分业务消息日志记录', 'Cannot find the corresponding points business message log record', '找不到對應積分業務消息日誌記錄', 'ไม่พบระเบียนบันทึกข่าวสารธุรกิจคะแนนที่สอดคล้อง', 'Không tìm thấy bản ghi nhật ký tin nhắn nghiệp vụ điểm tương ứng');
insert into ERRORCODEEX (ERRORID, DESCRIPTIONZH_CN, DESCRIPTIONEN, DESCRIPTIONZH_TW, DESCRIPTIONTH, DESCRIPTIONVI)
values ('3941', '止盈比例设置错误', 'Incorrect setting of take-profit ratio', '止盈比例設置錯誤', 'การตั้งค่าอัตราตัดกำไรผิดพลาด', 'Cài đặt tỷ lệ lấy lãi sai');
insert into ERRORCODEEX (ERRORID, DESCRIPTIONZH_CN, DESCRIPTIONEN, DESCRIPTIONZH_TW, DESCRIPTIONTH, DESCRIPTIONVI)
values ('3942', '止损比例设置错误', 'Incorrect setting of stop-loss ratio', '止損比例設置錯誤', 'การตั้งค่าอัตราตัดขาดทุนผิดพลาด', 'Cài đặt tỷ lệ cắt lỗ sai');
insert into ERRORCODEEX (ERRORID, DESCRIPTIONZH_CN, DESCRIPTIONEN, DESCRIPTIONZH_TW, DESCRIPTIONTH, DESCRIPTIONVI)
values ('3943', '计价账户和基础账户不是同一个用户的账户', 'The pricing account and the base account do not belong to the same user', '計價賬戶和基礎賬戶不是同一個用戶的賬戶', 'บัญชีตั้งราคาและบัญชีพื้นฐานไม่ได้เป็นบัญชีของผู้ใช้เดียวกัน', 'Tài khoản định giá và tài khoản cơ sở không phải là tài khoản của cùng một người dùng');
insert into ERRORCODEEX (ERRORID, DESCRIPTIONZH_CN, DESCRIPTIONEN, DESCRIPTIONZH_TW, DESCRIPTIONTH, DESCRIPTIONVI)
values ('3944', '持仓单数量错误', 'Incorrect number of position orders', '持倉單數量錯誤', 'จำนวนคำสั่งถือตำแหน่งผิดพลาด', 'Số lượng lệnh giữ vị trí sai');
insert into ERRORCODEEX (ERRORID, DESCRIPTIONZH_CN, DESCRIPTIONEN, DESCRIPTIONZH_TW, DESCRIPTIONTH, DESCRIPTIONVI)
values ('3945', '止盈价格错误', 'Incorrect take-profit price', '止盈價格錯誤', 'ราคาตัดกำไรผิดพลาด', 'Giá lấy lãi sai');
insert into ERRORCODEEX (ERRORID, DESCRIPTIONZH_CN, DESCRIPTIONEN, DESCRIPTIONZH_TW, DESCRIPTIONTH, DESCRIPTIONVI)
values ('3946', '止盈止损单状态错误', 'Incorrect status of take-profit and stop-loss orders', '止盈止損單狀態錯誤', 'สถานะคำสั่งตัดกำไรและตัดขาดทุนผิดพลาด', 'Trạng thái lệnh lấy lãi và cắt lỗ sai');
insert into ERRORCODEEX (ERRORID, DESCRIPTIONZH_CN, DESCRIPTIONEN, DESCRIPTIONZH_TW, DESCRIPTIONTH, DESCRIPTIONVI)
values ('3947', '当前持仓存在平仓委托或者交收，无法执行止盈止损操作', 'There are close position orders or settlements in the current positions, so take-profit and stop-loss operations cannot be executed', '當前持倉存在平倉委託或者交收，無法執行止盈止損操作', 'มีคำสั่งปิดตำแหน่งหรือการชำระเงินในตำแหน่งปัจจุบัน ไม่สามารถดำเนินการตัดกำไรและตัดขาดทุนได้', 'Có lệnh đóng vị trí hoặc giao nhận trong vị trí hiện tại, không thể thực hiện thao tác lấy lãi và cắt lỗ');
insert into ERRORCODEEX (ERRORID, DESCRIPTIONZH_CN, DESCRIPTIONEN, DESCRIPTIONZH_TW, DESCRIPTIONTH, DESCRIPTIONVI)
values ('40001', '目标资金账户不存在', 'The target fund account does not exist', '目標資金賬戶不存在', 'บัญชีกองทุนเป้าหมายไม่มีอยู่จริง', 'Tài khoản quỹ mục tiêu không tồn tại');
insert into ERRORCODEEX (ERRORID, DESCRIPTIONZH_CN, DESCRIPTIONEN, DESCRIPTIONZH_TW, DESCRIPTIONTH, DESCRIPTIONVI)
values ('40002', '账户服务未开市', 'Account service is not open', '賬戶服務未開市', 'บริการบัญชียังไม่เปิดการทำงาน', 'Dịch vụ tài khoản chưa mở cửa');
insert into ERRORCODEEX (ERRORID, DESCRIPTIONZH_CN, DESCRIPTIONEN, DESCRIPTIONZH_TW, DESCRIPTIONTH, DESCRIPTIONVI)
values ('40003', '数字账户余额不足', 'Insufficient balance in the digital account', '數字賬戶餘額不足', 'ยอดคงเหลือในบัญชีดิจิทัลไม่เพียงพอ', 'Số dư tài khoản số không đủ');
insert into ERRORCODEEX (ERRORID, DESCRIPTIONZH_CN, DESCRIPTIONEN, DESCRIPTIONZH_TW, DESCRIPTIONTH, DESCRIPTIONVI)
values ('40004', '资金账户动账失败', 'Failed to transfer funds in the fund account', '資金賬戶動賬失敗', 'การโอนเงินในบัญชีกองทุนล้มเหลว', 'Chuyển khoản tài khoản quỹ thất bại');
insert into ERRORCODEEX (ERRORID, DESCRIPTIONZH_CN, DESCRIPTIONEN, DESCRIPTIONZH_TW, DESCRIPTIONTH, DESCRIPTIONVI)
values ('40005', '目标数字账户不存在', 'The target digital account does not exist', '目標數字賬戶不存在', 'บัญชีดิจิทัลเป้าหมายไม่มีอยู่จริง', 'Tài khoản số mục tiêu không tồn tại');
insert into ERRORCODEEX (ERRORID, DESCRIPTIONZH_CN, DESCRIPTIONEN, DESCRIPTIONZH_TW, DESCRIPTIONTH, DESCRIPTIONVI)
values ('40006', '目标币种不存在', 'The target currency does not exist', '目標幣種不存在', 'สกุลเงินเป้าหมายไม่มีอยู่จริง', 'Loại tiền tệ mục tiêu không tồn tại');
insert into ERRORCODEEX (ERRORID, DESCRIPTIONZH_CN, DESCRIPTIONEN, DESCRIPTIONZH_TW, DESCRIPTIONTH, DESCRIPTIONVI)
values ('40007', '目标小数位异常', 'Abnormal target decimal places', '目標小數位異常', 'จุดทศนิยมเป้าหมายผิดปกติ', 'Chữ số thập phân mục tiêu bất thường');
insert into ERRORCODEEX (ERRORID, DESCRIPTIONZH_CN, DESCRIPTIONEN, DESCRIPTIONZH_TW, DESCRIPTIONTH, DESCRIPTIONVI)
values ('40008', '错误的申请金额', 'Incorrect application amount', '錯誤的申請金額', 'จำนวนเงินคำขอผิดพลาด', 'Số tiền đơn xin sai');
insert into ERRORCODEEX (ERRORID, DESCRIPTIONZH_CN, DESCRIPTIONEN, DESCRIPTIONZH_TW, DESCRIPTIONTH, DESCRIPTIONVI)
values ('40009', '子指令集合不能为空', 'The sub-instruction set cannot be empty', '子指令集合不能為空', 'ชุดคำสั่งย่อยไม่สามารถเป็นค่าว่างได้', 'Tập lệnh con không được trống');
insert into ERRORCODEEX (ERRORID, DESCRIPTIONZH_CN, DESCRIPTIONEN, DESCRIPTIONZH_TW, DESCRIPTIONTH, DESCRIPTIONVI)
values ('40010', '目标数字账户列表不能为空', 'The target digital account list cannot be empty', '目標數字賬戶列表不能為空', 'รายการบัญชีดิจิทัลเป้าหมายไม่สามารถเป็นค่าว่างได้', 'Danh sách tài khoản số mục tiêu không được trống');
insert into ERRORCODEEX (ERRORID, DESCRIPTIONZH_CN, DESCRIPTIONEN, DESCRIPTIONZH_TW, DESCRIPTIONTH, DESCRIPTIONVI)
values ('40011', '更新数字账户失败', 'Failed to update the digital account', '更新數字賬戶失敗', 'อัปเดตบัญชีดิจิทัลล้มเหลว', 'Cập nhật tài khoản số thất bại');
insert into ERRORCODEEX (ERRORID, DESCRIPTIONZH_CN, DESCRIPTIONEN, DESCRIPTIONZH_TW, DESCRIPTIONTH, DESCRIPTIONVI)
values ('40012', '记录变更流水失败', 'Failed to record the change flow', '記錄變更流水失敗', 'บันทึกการเปลี่ยนแปลงกระแสเงินล้มเหลว', 'Ghi nhận luồng thay đổi thất bại');
insert into ERRORCODEEX (ERRORID, DESCRIPTIONZH_CN, DESCRIPTIONEN, DESCRIPTIONZH_TW, DESCRIPTIONTH, DESCRIPTIONVI)
values ('40013', '错误的子指令操作码', 'Incorrect sub-instruction operation code', '錯誤的子指令操作碼', 'รหัสการดำเนินการคำสั่งย่อยผิดพลาด', 'Mã thao tác lệnh con sai');
insert into ERRORCODEEX (ERRORID, DESCRIPTIONZH_CN, DESCRIPTIONEN, DESCRIPTIONZH_TW, DESCRIPTIONTH, DESCRIPTIONVI)
values ('40014', '数字账户已存在', 'The digital account already exists', '數字賬戶已存在', 'บัญชีดิจิทัลมีอยู่แล้ว', 'Tài khoản số đã tồn tại');


-----------version----------------------------------------------
delete from UPDATEVERSION where VersionNum = '15.errorcode_ex';
insert into UPDATEVERSION values ('15.errorcode_ex','15.errorcode_ex.sql',sysdate);
----------------------------------------------------------------
commit;


prompt 15.errorcode_ex_Finished