luminghui
/
sdny-jxpt
1
0
Fork 0
Code Issues Pull Requests Packages Projects Releases Wiki Activity
You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
1663 Commits
1 Branch
0 Tags
6.0 MiB
 
Tag: Branch: Tree: release
Branches Tags
${ item.name }
Create tag ${ searchTerm }
Create branch ${ searchTerm }
from 'release'
${ noResults }
sdny-jxpt/db/v5.0.3.1/5.0.3.1.sql

24 lines
7.6 KiB
Raw Permalink Blame History

INSERT INTO `sys_dicttype` (`dicttypeid`, `dicttypename`, `dicttypedesc`, `dicttypecode`, `create_time`, `create_by`, `last_modify_time`, `last_modify_by`, `sys_code`) VALUES ('1531524941278855170', '认证失败原因', '发票认证获取失败原因', 'failureReason', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_dictdeta` (`dictid`, `dicttype`, `dictname`, `sortno`, `status`, `dictcode`, `create_time`, `create_by`, `last_modify_time`, `last_modify_by`, `_mycat_op_time`, `dicttypecode`) VALUES ('1531525050079100929', '1531524941278855170', '成功', '1', NULL, '1', NULL, NULL, NULL, NULL, NULL, 'failureReason');
INSERT INTO `sys_dictdeta` (`dictid`, `dicttype`, `dictname`, `sortno`, `status`, `dictcode`, `create_time`, `create_by`, `last_modify_time`, `last_modify_by`, `_mycat_op_time`, `dicttypecode`) VALUES ('1531525255654522881', '1531524941278855170', '无此票', '2', NULL, '2', NULL, NULL, NULL, NULL, NULL, 'failureReason');
INSERT INTO `sys_dictdeta` (`dictid`, `dicttype`, `dictname`, `sortno`, `status`, `dictcode`, `create_time`, `create_by`, `last_modify_time`, `last_modify_by`, `_mycat_op_time`, `dicttypecode`) VALUES ('1531525334708764674', '1531524941278855170', '该票异常无法认证', '3', NULL, '3', NULL, NULL, NULL, NULL, NULL, 'failureReason');
INSERT INTO `sys_dictdeta` (`dictid`, `dicttype`, `dictname`, `sortno`, `status`, `dictcode`, `create_time`, `create_by`, `last_modify_time`, `last_modify_by`, `_mycat_op_time`, `dicttypecode`) VALUES ('1531525468196683778', '1531524941278855170', '该票已认证', '4', NULL, '4', NULL, NULL, NULL, NULL, NULL, 'failureReason');
INSERT INTO `sys_dictdeta` (`dictid`, `dicttype`, `dictname`, `sortno`, `status`, `dictcode`, `create_time`, `create_by`, `last_modify_time`, `last_modify_by`, `_mycat_op_time`, `dicttypecode`) VALUES ('1531525539130753025', '1531524941278855170', '该票已经逾期无法认证', '5', NULL, '5', NULL, NULL, NULL, NULL, NULL, 'failureReason');
INSERT INTO `sys_dictdeta` (`dictid`, `dicttype`, `dictname`, `sortno`, `status`, `dictcode`, `create_time`, `create_by`, `last_modify_time`, `last_modify_by`, `_mycat_op_time`, `dicttypecode`) VALUES ('1531525675500158977', '1531524941278855170', '该票已经申请认证', '6', NULL, '6', NULL, NULL, NULL, NULL, NULL, 'failureReason');
INSERT INTO `sys_dictdeta` (`dictid`, `dicttype`, `dictname`, `sortno`, `status`, `dictcode`, `create_time`, `create_by`, `last_modify_time`, `last_modify_by`, `_mycat_op_time`, `dicttypecode`) VALUES ('1531525730059665409', '1531524941278855170', '申请认证月份不匹配', '7', NULL, '7', NULL, NULL, NULL, NULL, NULL, 'failureReason');
INSERT INTO `sys_dictdeta` (`dictid`, `dicttype`, `dictname`, `sortno`, `status`, `dictcode`, `create_time`, `create_by`, `last_modify_time`, `last_modify_by`, `_mycat_op_time`, `dicttypecode`) VALUES ('1531525781662187522', '1531524941278855170', '其他异常', '8', NULL, '8', NULL, NULL, NULL, NULL, NULL, 'failureReason');
INSERT INTO `sys_dictdeta` (`dictid`, `dicttype`, `dictname`, `sortno`, `status`, `dictcode`, `create_time`, `create_by`, `last_modify_time`, `last_modify_by`, `_mycat_op_time`, `dicttypecode`) VALUES ('1531525837152829442', '1531524941278855170', '该票未到期', '9', NULL, '9', NULL, NULL, NULL, NULL, NULL, 'failureReason');
INSERT INTO `sys_dictdeta` (`dictid`, `dicttype`, `dictname`, `sortno`, `status`, `dictcode`, `create_time`, `create_by`, `last_modify_time`, `last_modify_by`, `_mycat_op_time`, `dicttypecode`) VALUES ('1531525925061246977', '1531524941278855170', '红票无法认证', '10', NULL, '10', NULL, NULL, NULL, NULL, NULL, 'failureReason');
INSERT INTO `sys_dictdeta` (`dictid`, `dicttype`, `dictname`, `sortno`, `status`, `dictcode`, `create_time`, `create_by`, `last_modify_time`, `last_modify_by`, `_mycat_op_time`, `dicttypecode`) VALUES ('1531525978446348289', '1531524941278855170', '认证类型不匹配', '11', NULL, '11', NULL, NULL, NULL, NULL, NULL, 'failureReason');
INSERT INTO `sys_dictdeta` (`dictid`, `dicttype`, `dictname`, `sortno`, `status`, `dictcode`, `create_time`, `create_by`, `last_modify_time`, `last_modify_by`, `_mycat_op_time`, `dicttypecode`) VALUES ('1531526058180067330', '1531524941278855170', '信用等级异常', '12', NULL, '12', NULL, NULL, NULL, NULL, NULL, 'failureReason');
INSERT INTO `sys_dictdeta` (`dictid`, `dicttype`, `dictname`, `sortno`, `status`, `dictcode`, `create_time`, `create_by`, `last_modify_time`, `last_modify_by`, `_mycat_op_time`, `dicttypecode`) VALUES ('1531526125490257922', '1531524941278855170', 'token超过五天未获取', '13', NULL, '13', NULL, NULL, NULL, NULL, NULL, 'failureReason');
INSERT INTO `sys_dictdeta` (`dictid`, `dicttype`, `dictname`, `sortno`, `status`, `dictcode`, `create_time`, `create_by`, `last_modify_time`, `last_modify_by`, `_mycat_op_time`, `dicttypecode`) VALUES ('1531526175918374913', '1531524941278855170', '该票不可勾选为逾期', '14', NULL, '14', NULL, NULL, NULL, NULL, NULL, 'failureReason');
INSERT INTO `sys_dictdeta` (`dictid`, `dicttype`, `dictname`, `sortno`, `status`, `dictcode`, `create_time`, `create_by`, `last_modify_time`, `last_modify_by`, `_mycat_op_time`, `dicttypecode`) VALUES ('1531526307841818625', '1531524941278855170', '有效税额异常（有效税额大于实际税额）', '15', NULL, '15', NULL, NULL, NULL, NULL, NULL, 'failureReason');
INSERT INTO `sys_dictdeta` (`dictid`, `dicttype`, `dictname`, `sortno`, `status`, `dictcode`, `create_time`, `create_by`, `last_modify_time`, `last_modify_by`, `_mycat_op_time`, `dicttypecode`) VALUES ('1531526372396351489', '1531524941278855170', '当期已锁定', '16', NULL, '16', NULL, NULL, NULL, NULL, NULL, 'failureReason');
INSERT INTO `sys_dictdeta` (`dictid`, `dicttype`, `dictname`, `sortno`, `status`, `dictcode`, `create_time`, `create_by`, `last_modify_time`, `last_modify_by`, `_mycat_op_time`, `dicttypecode`) VALUES ('1531526481779605505', '1531524941278855170', '逾期不可勾选', '17', NULL, '17', NULL, NULL, NULL, NULL, NULL, 'failureReason');
INSERT INTO `sys_dictdeta` (`dictid`, `dicttype`, `dictname`, `sortno`, `status`, `dictcode`, `create_time`, `create_by`, `last_modify_time`, `last_modify_by`, `_mycat_op_time`, `dicttypecode`) VALUES ('1531526532329357314', '1531524941278855170', '发票未勾选（确认）', '18', NULL, '18', NULL, NULL, NULL, NULL, NULL, 'failureReason');
INSERT INTO `sys_dictdeta` (`dictid`, `dicttype`, `dictname`, `sortno`, `status`, `dictcode`, `create_time`, `create_by`, `last_modify_time`, `last_modify_by`, `_mycat_op_time`, `dicttypecode`) VALUES ('1531526581583069186', '1531524941278855170', '取消操作不匹配', '19', NULL, '19', NULL, NULL, NULL, NULL, NULL, 'failureReason');
INSERT INTO `sys_dictdeta` (`dictid`, `dicttype`, `dictname`, `sortno`, `status`, `dictcode`, `create_time`, `create_by`, `last_modify_time`, `last_modify_by`, `_mycat_op_time`, `dicttypecode`) VALUES ('1531526692333666305', '1531524941278855170', '管理状态异常', '20', NULL, '98', NULL, NULL, NULL, NULL, NULL, 'failureReason');
INSERT INTO `sys_dictdeta` (`dictid`, `dicttype`, `dictname`, `sortno`, `status`, `dictcode`, `create_time`, `create_by`, `last_modify_time`, `last_modify_by`, `_mycat_op_time`, `dicttypecode`) VALUES ('1531528945958371330', '1531524941278855170', '不抵扣原因为空或者异常', '21', NULL, '23', NULL, NULL, NULL, NULL, NULL, 'failureReason');
INSERT INTO `sys_dictdeta` (`dictid`, `dicttype`, `dictname`, `sortno`, `status`, `dictcode`, `create_time`, `create_by`, `last_modify_time`, `last_modify_by`, `_mycat_op_time`, `dicttypecode`) VALUES ('1531528991030362114', '1531524941278855170', '税额为0不能抵扣', '22', NULL, '24', NULL, NULL, NULL, NULL, NULL, 'failureReason');