Files
alawn-accounting/db/mysql/DML_ACCOUNT_CRL_DEF.sql
2023-03-30 14:23:24 +08:00

6 lines
1.3 KiB
SQL

INSERT INTO t_account_crl_def VALUES ('2001001001', '2', '301', 'CNY', '2', '0', '客户资金-企业-待结算银行账户', null, STR_TO_DATE(' 2017-12-14 11:03:11:000000', '%Y-%m-%d %H:%i:%s:%f'), null, STR_TO_DATE(' 2017-12-14 11:03:11:000000', '%Y-%m-%d %H:%i:%s:%f'));
INSERT INTO t_account_crl_def VALUES ('2001001002', '2', '302', 'CNY', '2', '0', '客户资金-企业-待结算扫码账户', null, STR_TO_DATE(' 2017-12-14 11:03:11:000000', '%Y-%m-%d %H:%i:%s:%f'), null, STR_TO_DATE(' 2017-12-14 11:03:11:000000', '%Y-%m-%d %H:%i:%s:%f'));
INSERT INTO t_account_crl_def VALUES ('2001001003', '2', '401', 'CNY', '2', '0', '客户资金-企业-现金账户', null, STR_TO_DATE(' 2017-12-14 11:03:11:000000', '%Y-%m-%d %H:%i:%s:%f'), null, STR_TO_DATE(' 2017-12-14 11:03:11:000000', '%Y-%m-%d %H:%i:%s:%f'));
INSERT INTO t_account_crl_def VALUES ('2001001004', '2', '140', 'CNY', '2', '0', '客户资金-企业-理财过渡账户', null, STR_TO_DATE(' 2017-12-14 11:03:12:000000', '%Y-%m-%d %H:%i:%s:%f'), null, STR_TO_DATE(' 2017-12-14 11:03:12:000000', '%Y-%m-%d %H:%i:%s:%f'));
INSERT INTO t_account_crl_def VALUES ('2002001001', '2', '130', 'CNY', '2', '0', '客户份额-企业-理财账户', null, STR_TO_DATE(' 2017-12-14 11:03:12:000000', '%Y-%m-%d %H:%i:%s:%f'), null, STR_TO_DATE(' 2017-12-14 11:03:12:000000', '%Y-%m-%d %H:%i:%s:%f'));