54 lines
9.0 KiB
SQL
54 lines
9.0 KiB
SQL
/** 资产类 */
|
|
INSERT INTO t_account_title VALUES ('1001' , '1001' , '备付金' , '1' , null , 'N' , '1' , '1' , 'Y' , NOW() , NOW() , 'TEST' , '1');
|
|
INSERT INTO t_account_title VALUES ('1002' , '1002' , '资产份额' , '1' , null , 'N' , '1' , '1' , 'Y' , NOW() , NOW() , 'TEST' , '1');
|
|
INSERT INTO t_account_title VALUES ('1003' , '1003' , '银行存款' , '1' , null , 'N' , '1' , '1' , 'Y' , NOW() , NOW() , 'TEST' , '1');
|
|
INSERT INTO t_account_title VALUES ('1001001' , '1001001' , '备付金-国通' , '2' , '1001' , 'N' , '1' , '1' , 'Y' , NOW() , NOW() , 'TEST' , '1');
|
|
INSERT INTO t_account_title VALUES ('1001002' , '1001002' , '备付金-国通垫资' , '2' , '1001' , 'N' , '1' , '1' , 'Y' , NOW() , NOW() , 'TEST' , '1');
|
|
INSERT INTO t_account_title VALUES ('1001003' , '1001003' , '备付金-易联' , '2' , '1001' , 'N' , '1' , '1' , 'Y' , NOW() , NOW() , 'TEST' , '1');
|
|
INSERT INTO t_account_title VALUES ('1001004' , '1001004' , '备付金-易联垫资' , '2' , '1001' , 'N' , '1' , '1' , 'Y' , NOW() , NOW() , 'TEST' , '1');
|
|
INSERT INTO t_account_title VALUES ('1002001' , '1002001' , '资产份额-上海银行' , '2' , '1002' , 'N' , '1' , '1' , 'Y' , NOW() , NOW() , 'TEST' , '1');
|
|
INSERT INTO t_account_title VALUES ('1003001' , '1003001' , '银行存款-新大陆' , '2' , '1003' , 'N' , '1' , '1' , 'Y' , NOW() , NOW() , 'TEST' , '1');
|
|
INSERT INTO t_account_title VALUES ('1001001001' , '1001001001' , '备付金-国通-XX银行' , '3' , '1001001' , 'Y' , '1' , '1' , 'Y' , NOW() , NOW() , 'TEST' , '1');
|
|
INSERT INTO t_account_title VALUES ('1001002001' , '1001002001' , '备付金-国通垫资-XX银行' , '3' , '1001002' , 'Y' , '1' , '1' , 'Y' , NOW() , NOW() , 'TEST' , '1');
|
|
INSERT INTO t_account_title VALUES ('1001003001' , '1001003001' , '备付金-易联-XX银行' , '3' , '1001003' , 'Y' , '1' , '1' , 'Y' , NOW() , NOW() , 'TEST' , '1');
|
|
INSERT INTO t_account_title VALUES ('1001004001' , '1001004001' , '备付金-易联垫资-XX银行' , '3' , '1001004' , 'Y' , '1' , '1' , 'Y' , NOW() , NOW() , 'TEST' , '1');
|
|
INSERT INTO t_account_title VALUES ('1002001001' , '1002001001' , '资产份额-上海银行-XX银行' , '3' , '1002001' , 'Y' , '1' , '1' , 'Y' , NOW() , NOW() , 'TEST' , '1');
|
|
INSERT INTO t_account_title VALUES ('1003001001' , '1003001001' , '银行存款-新大陆-XX银行' , '3' , '1003001' , 'Y' , '1' , '1' , 'Y' , NOW() , NOW() , 'TEST' , '1');
|
|
|
|
/** 负债类 */
|
|
INSERT INTO t_account_title VALUES ('2001' , '2001' , '客户资金' , '1' , null , 'N' , '2' , '2' , 'Y' , NOW() , NOW() , 'TEST' , '2');
|
|
INSERT INTO t_account_title VALUES ('2002' , '2002' , '客户份额' , '1' , null , 'N' , '2' , '2' , 'Y' , NOW() , NOW() , 'TEST' , '2');
|
|
INSERT INTO t_account_title VALUES ('3001' , '3001' , '其他应付款' , '1' , null , 'N' , '2' , '2' , 'Y' , NOW() , NOW() , 'TEST' , '1');
|
|
INSERT INTO t_account_title VALUES ('9001' , '9001' , '主营业务收入' , '1' , null , 'N' , '2' , '2' , 'Y' , NOW() , NOW() , 'TEST' , '1');
|
|
INSERT INTO t_account_title VALUES ('2001001' , '2001001' , '客户资金-企业' , '2' , '2001' , 'N' , '2' , '2' , 'Y' , NOW() , NOW() , 'TEST' , '2');
|
|
INSERT INTO t_account_title VALUES ('2002001' , '2002001' , '客户份额-企业' , '2' , '2002' , 'N' , '2' , '2' , 'Y' , NOW() , NOW() , 'TEST' , '2');
|
|
INSERT INTO t_account_title VALUES ('3001001' , '3001001' , '其他应付款-主营业务支出' , '2' , '3001' , 'N' , '2' , '2' , 'Y' , NOW() , NOW() , 'TEST' , '1');
|
|
INSERT INTO t_account_title VALUES ('9001001' , '9001001' , '主营业务收入-手续费收入' , '2' , '9001' , 'N' , '2' , '2' , 'Y' , NOW() , NOW() , 'TEST' , '1');
|
|
INSERT INTO t_account_title VALUES ('2001001001' , '2001001001' , '客户资金-企业-待结算银行账户' , '3' , '2001001' , 'Y' , '2' , '2' , 'Y' , NOW() , NOW() , 'TEST' , '2');
|
|
INSERT INTO t_account_title VALUES ('2001001002' , '2001001002' , '客户资金-企业-待结算扫码账户' , '3' , '2001001' , 'Y' , '2' , '2' , 'Y' , NOW() , NOW() , 'TEST' , '2');
|
|
INSERT INTO t_account_title VALUES ('2001001003' , '2001001003' , '客户资金-企业-现金账户' , '3' , '2001001' , 'Y' , '2' , '2' , 'Y' , NOW() , NOW() , 'TEST' , '2');
|
|
INSERT INTO t_account_title VALUES ('2001001004' , '2001001004' , '客户资金-企业-理财过渡账户' , '3' , '2001001' , 'Y' , '2' , '2' , 'Y' , NOW() , NOW() , 'TEST' , '2');
|
|
INSERT INTO t_account_title VALUES ('2002001001' , '2002001001' , '客户份额-企业-理财账户' , '3' , '2002001' , 'Y' , '2' , '2' , 'Y' , NOW() , NOW() , 'TEST' , '2');
|
|
INSERT INTO t_account_title VALUES ('3001001001' , '3001001001' , '其他应付款-主营业务支出-银行卡手续费成本' , '3' , '3001001' , 'Y' , '2' , '2' , 'Y' , NOW() , NOW() , 'TEST' , '1');
|
|
INSERT INTO t_account_title VALUES ('3001001002' , '3001001002' , '其他应付款-主营业务支出-扫码手续费成本' , '3' , '3001001' , 'Y' , '2' , '2' , 'Y' , NOW() , NOW() , 'TEST' , '1');
|
|
INSERT INTO t_account_title VALUES ('9001001001' , '9001001001' , '主营业务收入-手续费收入-银行卡' , '3' , '9001001' , 'Y' , '2' , '2' , 'Y' , NOW() , NOW() , 'TEST' , '1');
|
|
INSERT INTO t_account_title VALUES ('9001001002' , '9001001002' , '主营业务收入-手续费收入-扫码' , '3' , '9001001' , 'Y' , '2' , '2' , 'Y' , NOW() , NOW() , 'TEST' , '1');
|
|
|
|
|
|
/** 资产负债共同类 */
|
|
INSERT INTO t_account_title VALUES ('4001' , '4001' , '待清算-入款待清算' , '1' , null , 'N' , '4' , '1' , 'Y' , NOW() , NOW() , 'TEST' , '1');
|
|
INSERT INTO t_account_title VALUES ('4002' , '4002' , '待清算-出款待清算' , '1' , null , 'N' , '4' , '2' , 'Y' , NOW() , NOW() , 'TEST' , '1');
|
|
INSERT INTO t_account_title VALUES ('4003' , '4003' , '待清算-退款待清算' , '1' , null , 'N' , '4' , '2' , 'Y' , NOW() , NOW() , 'TEST' , '1');
|
|
INSERT INTO t_account_title VALUES ('4001001' , '4001001' , '待清算-入款待清算-国通' , '2' , '4001' , 'N' , '4' , '1' , 'Y' , NOW() , NOW() , 'TEST' , '1');
|
|
INSERT INTO t_account_title VALUES ('4001002' , '4001002' , '待清算-入款待清算-易联' , '2' , '4001' , 'N' , '4' , '1' , 'Y' , NOW() , NOW() , 'TEST' , '1');
|
|
INSERT INTO t_account_title VALUES ('4002001' , '4002001' , '待清算-出款待清算-国通' , '2' , '4002' , 'N' , '4' , '2' , 'Y' , NOW() , NOW() , 'TEST' , '1');
|
|
INSERT INTO t_account_title VALUES ('4002002' , '4002002' , '待清算-出款待清算-易联' , '2' , '4002' , 'N' , '4' , '2' , 'Y' , NOW() , NOW() , 'TEST' , '1');
|
|
INSERT INTO t_account_title VALUES ('4003001' , '4003001' , '待清算-退款待清算-国通' , '2' , '4003' , 'N' , '4' , '2' , 'Y' , NOW() , NOW() , 'TEST' , '1');
|
|
INSERT INTO t_account_title VALUES ('4003002' , '4003002' , '待清算-退款待清算-易联' , '2' , '4003' , 'N' , '4' , '2' , 'Y' , NOW() , NOW() , 'TEST' , '1');
|
|
INSERT INTO t_account_title VALUES ('4001001001' , '4001001001' , '待清算-入款待清算-国通' , '3' , '4001001' , 'Y' , '4' , '1' , 'Y' , NOW() , NOW() , 'TEST' , '1');
|
|
INSERT INTO t_account_title VALUES ('4001002001' , '4001002001' , '待清算-入款待清算-易联' , '3' , '4001002' , 'Y' , '4' , '1' , 'Y' , NOW() , NOW() , 'TEST' , '1');
|
|
INSERT INTO t_account_title VALUES ('4002001001' , '4002001001' , '待清算-出款待清算-国通' , '3' , '4002001' , 'Y' , '4' , '2' , 'Y' , NOW() , NOW() , 'TEST' , '1');
|
|
INSERT INTO t_account_title VALUES ('4002002001' , '4002002001' , '待清算-出款待清算-易联' , '3' , '4002002' , 'Y' , '4' , '2' , 'Y' , NOW() , NOW() , 'TEST' , '1');
|
|
INSERT INTO t_account_title VALUES ('4003001001' , '4003001001' , '待清算-退款待清算-国通' , '3' , '4003001' , 'Y' , '4' , '2' , 'Y' , NOW() , NOW() , 'TEST' , '1');
|
|
INSERT INTO t_account_title VALUES ('4003002002' , '4003002002' , '待清算-退款待清算-易联' , '3' , '4003002' , 'Y' , '4' , '2' , 'Y' , NOW() , NOW() , 'TEST' , '1');
|
|
COMMIT; |