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.
sdny-order/mycat-config/sales_order_5.0.2.sql

1331 lines
114 KiB

SET
FOREIGN_KEY_CHECKS = 0;
DROP TABLE IF EXISTS `authentication`;
CREATE TABLE `authentication`
(
`id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '鉴权表ID',
`nsrsbh` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '纳税人识别号',
`qd` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '渠道id',
`secretId` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '标识用户身份的SecretId',
`secretKey` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'secretKey',
`qd_push` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0' COMMENT '是否按照渠道推送(0:不按照渠道推送,1:按照渠道推送)',
`auth_status` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '状态(0:有效,1:无效)',
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
`update_time` datetime(0) NULL DEFAULT NULL COMMENT '修改时间',
PRIMARY KEY (`id`) USING BTREE,
INDEX `idx_auth_nsrsbh` (`nsrsbh`) USING BTREE
) ENGINE = InnoDB
CHARACTER SET = utf8
COLLATE = utf8_general_ci COMMENT = '对外接口鉴权表'
ROW_FORMAT = Dynamic;
DROP TABLE IF EXISTS `business_type_info`;
CREATE TABLE `business_type_info`
(
`id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '业务类型表ID',
`business_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '业务类型名称',
`business_id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '业务类型ID',
`xhf_nsrsbh` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '销货方纳税人识别号',
`xhfMc` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '销货方名称',
`ly` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '数据来源:0接口采集 1页面添加',
`description` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '业务类型描述',
`status` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '0' COMMENT '状态(0:有效;1:无效)',
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
`update_time` datetime(0) NULL DEFAULT NULL COMMENT '修改时间',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `idx_uni_name` (`business_name`, `xhf_nsrsbh`) USING BTREE,
INDEX `idx_business_type_id` (`business_id`) USING BTREE,
INDEX `idx_business_name` (`business_name`) USING BTREE,
INDEX `idx_business_nsrsbh` (`xhf_nsrsbh`) USING BTREE
) ENGINE = InnoDB
CHARACTER SET = utf8
COLLATE = utf8_general_ci COMMENT = '业务类型表'
ROW_FORMAT = Dynamic;
DROP TABLE IF EXISTS `buyer_manage_info`;
CREATE TABLE `buyer_manage_info`
(
`id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '购方信息表ID',
`taxpayer_code` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '纳税人识别号',
`purchase_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '购方名称',
`address` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '购方地址',
`phone` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '购方电话',
`bank_of_deposit` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '开户银行',
`bank_number` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '银行账号',
`email` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '购方联系人邮箱',
`remarks` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
`create_user_id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建人',
`modify_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
`modify_user_id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '更新人ID',
`ghf_qylx` varchar(5) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '购买方企业类型',
`xhf_nsrsbh` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '父级税号',
`xhf_mc` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '销货方名称',
`buyer_code` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '购买方编码',
PRIMARY KEY (`id`) USING BTREE,
INDEX `idx_purchase_name` (`purchase_name`) USING BTREE,
INDEX `idx_taxpayer_code` (`taxpayer_code`) USING BTREE
) ENGINE = InnoDB
CHARACTER SET = utf8
COLLATE = utf8_general_ci COMMENT = '购方信息表'
ROW_FORMAT = Dynamic;
DROP TABLE IF EXISTS `commodity_code`;
CREATE TABLE `commodity_code`
(
`id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '商品编码ID',
`sort_id` bigint(10) NULL DEFAULT NULL COMMENT '序号',
`xhf_nsrsbh` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '纳税人识别号',
`merchandise_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '商品名称',
`encoding` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '编码',
`tax_items` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '商品税目',
`brief_code` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '简码',
`tax_rate` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '税率',
`specification_model` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '规格型号',
`metering_unit` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '计量单位',
`unit_price` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '单价',
`tax_logo` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '\' 01\',',
`hide_the_logo` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '\' 01\',',
`enjoy_preferential_policies` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '\' 01\',',
`tax_class_code` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '税收分类编码',
`tax_classification_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '税收分类名称',
`preferential_policies_type` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '优惠政策类型jh:空:非零税率,0:出口零税,1:免税,2:不征税 3:普通零税率',
`zzstsgl` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '增值税特殊管理',
`user_id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '当前登录人id ',
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '数据创建时间',
`modify_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
`modify_user_id` char(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '更新人',
`group_id` varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '分组id',
`enterprise_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '企业名称',
`data_source` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '数据来源(0-集团共享;1-手工创建;2-模板导入;3-采集下级;)',
`matching_state` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '匹配状态(0-已匹配;1-未匹配)',
`data_state` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '数据状态(0-启用;1-停用)',
`tax_class_abbreviation` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '税收分类简称',
`description` varchar(400) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`collect_ident` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '采集标识(0:已采集;)',
`bmb_bbh` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '编码表版本号',
`cpy` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '是否成品油(Y:成品油;N:非成品油)',
PRIMARY KEY (`id`) USING BTREE,
INDEX `idx_commodity_merchandise` (`merchandise_name`) USING BTREE,
INDEX `idx_commodity_nsrsbh` (`xhf_nsrsbh`) USING BTREE,
INDEX `idx_commodity_encoding` (`encoding`) USING BTREE
) ENGINE = InnoDB
CHARACTER SET = utf8
COLLATE = utf8_general_ci COMMENT = '商品编码表'
ROW_FORMAT = Dynamic;
DROP TABLE IF EXISTS `drawer_info`;
CREATE TABLE `drawer_info`
(
`id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'id',
`xhf_nsrsbh` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '纳税人识别号',
`drawer_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '开票人名称',
`re_check_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '复核人',
`name_of_payee` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '收款人',
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
`credate_user_id` varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建人',
`modify_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
`modify_user_id` varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '更新人',
PRIMARY KEY (`id`) USING BTREE,
INDEX `idx_drawer_nsrsbh` (`xhf_nsrsbh`) USING BTREE
) ENGINE = InnoDB
CHARACTER SET = utf8
COLLATE = utf8_general_ci COMMENT = '开票信息表'
ROW_FORMAT = Dynamic;
DROP TABLE IF EXISTS `ewm_config`;
CREATE TABLE `ewm_config`
(
`id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '主键',
`xhf_mc` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '销货方名称',
`xhf_nsrsbh` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '销货方税号',
`fpzldm` varchar(5) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '发票种类代码',
`invalid_time` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '二维码失效时间 天为单位',
`create_time` datetime(0) NOT NULL COMMENT '数据创建时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB
CHARACTER SET = utf8
COLLATE = utf8_general_ci COMMENT = '二维码配置表'
ROW_FORMAT = Dynamic;
DROP TABLE IF EXISTS `ewm_config_item`;
CREATE TABLE `ewm_config_item`
(
`id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '主键id',
`ewm_coinfg_id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '二维码设置主表id',
`fpzldm` varchar(5) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '发票种类代码',
`sld` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '受理点id',
`sld_mc` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '受理点名称',
`create_time` datetime(0) NOT NULL COMMENT '创建时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB
CHARACTER SET = utf8
COLLATE = utf8_general_ci COMMENT = '二维码配置明细表'
ROW_FORMAT = Dynamic;
DROP TABLE IF EXISTS `ewm_gzh_config`;
CREATE TABLE `ewm_gzh_config`
(
`id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '主键id',
`nsrsbh` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '纳税人识别号',
`appid` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '公众号appid',
`appkey` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '公众号appkey',
`gzh_subcribe_ewm` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '公众号关注二维码 此处存放url',
`home_page_logo` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '扫码开票首页的banner 图片的url',
`force_subcribe` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '是否强关 0 不强关 1 强关',
`merge` varchar(2) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '0' COMMENT '是否支持合并 0 不支持 1 支持',
`type` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '0' COMMENT '类型(0:公众号;1:直接开票)',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB
CHARACTER SET = utf8
COLLATE = utf8_general_ci COMMENT = '二维码公众号配置表'
ROW_FORMAT = Compact;
DROP TABLE IF EXISTS `fp_dy`;
CREATE TABLE `fp_dy`
(
`id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '打印id',
`xhf_nsrsbh` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '销货方纳税人识别号',
`fpzldm` varchar(4) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '发票种类:2:纸质普通发票,0:纸质专用发票',
`fpdm` varchar(12) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '发票代码',
`fphm` varchar(8) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '发票号码',
`spot_key` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '打印点标识',
`print_status` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '打印状态(0:待打印,1:打印中,2:打印成功,3:打印失败)',
`print_msg` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '打印状态描述',
`create_time` datetime(0) NULL DEFAULT NULL,
`update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
`fpdypch` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '发票打印批次号',
`dylx` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '打印类型 fp:发票,qd:清单',
`dyjmc` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '打印机名称',
`fg_status` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '0接收成功,1接收失败,2待打印',
`zpy` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '左偏移',
`spy` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '上偏移',
`fpqqlsh` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '订单请求流水号',
PRIMARY KEY (`id`) USING BTREE,
INDEX `index_fpdypch` (`fpdypch`) USING BTREE
) ENGINE = InnoDB
CHARACTER SET = utf8
COLLATE = utf8_general_ci COMMENT = '纸票打印信息表'
ROW_FORMAT = Dynamic;
DROP TABLE IF EXISTS `fp_express`;
CREATE TABLE `fp_express`
(
`id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '快递表ID',
`user_id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户ID',
`org_id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '组织ID',
`sender_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '寄件人姓名',
`sender_address` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '寄件人地址',
`sender_phone` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '寄件人电话',
`sender_mail` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '寄件人邮箱',
`sender_post_code` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '寄件人邮编',
`recipients_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '收件人姓名',
`recipients_address` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '收件人地址',
`recipients_phone` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '收件人电话',
`recipients_mail` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '收件人邮箱',
`recipients_post_code` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '收件人邮编',
`express_company_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '快递公司名称',
`express_company_code` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '快递公司编码',
`express_number` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '快递单号',
`buyer_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '购方名称',
`express_items` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '快递的物品信息:多个物品逗号分隔',
`express_state` varchar(5) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '快递状态 0-无轨迹 1-已揽收 2-在途中 3-签收 4-问题件 ',
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
PRIMARY KEY (`id`) USING BTREE,
INDEX `idx_express_user_id` (`user_id`) USING BTREE
) ENGINE = InnoDB
CHARACTER SET = utf8
COLLATE = utf8_general_ci COMMENT = '发票快递表'
ROW_FORMAT = Dynamic;
DROP TABLE IF EXISTS `fp_kdbm`;
CREATE TABLE `fp_kdbm`
(
`id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '快递编码表ID',
`express_company_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '快递公司名称',
`express_company_code` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '快递公司编码',
`api_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '快递API',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB
CHARACTER SET = utf8
COLLATE = utf8_general_ci COMMENT = '快递公司编码表'
ROW_FORMAT = Dynamic;
DROP TABLE IF EXISTS `fp_sender`;
CREATE TABLE `fp_sender`
(
`id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '发票邮寄表ID',
`user_id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户ID',
`type` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '邮寄角色 0 寄件人 1 收件人',
`sender_id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '寄件人编号',
`recipients_id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '收件人编号',
`recipients_company_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '收件人公司名称',
`name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '姓名',
`address` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '地址',
`phone` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '电话',
`mail` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '邮箱',
`post_code` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '邮编',
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB
CHARACTER SET = utf8
COLLATE = utf8_general_ci COMMENT = '邮寄角色信息表'
ROW_FORMAT = Dynamic;
DROP TABLE IF EXISTS `group_commodity`;
CREATE TABLE `group_commodity`
(
`id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '主键',
`group_code` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '分组编码',
`group_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '分组名称',
`superior_coding` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '上级分组编码',
`is_leaf` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '是否为页子节点 0 是 1 不是',
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
`user_id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建人ID',
`xhf_nsrsbh` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '纳税人识别号',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB
CHARACTER SET = utf8
COLLATE = utf8_general_ci COMMENT = '商品编码分组表'
ROW_FORMAT = Dynamic;
DROP TABLE IF EXISTS `group_tax_class_code`;
CREATE TABLE `group_tax_class_code`
(
`id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '主键',
`sort_id` bigint(10) NULL DEFAULT NULL COMMENT '序号',
`xhf_nsrsbh` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '纳税人识别号',
`merchandise_name` varchar(400) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '商品名称',
`encoding` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '编码',
`tax_items` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '商品税目',
`brief_code` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '简码',
`specification_model` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '规格型号',
`metering_unit` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '计量单位',
`unit_price` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '单价',
`tax_class_code` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '税收分类编码',
`tax_classification_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '税收分类名称',
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '数据创建时间',
`group_id` varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '分组id',
`data_source` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '数据来源(0-集团共享;1-手工创建;2-模板导入;3-采集下级;)',
`matching_state` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '匹配状态(0-已匹配;1-未匹配)',
`data_state` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '数据状态(0-启用;1-停用;2-删除;)',
`share_state` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '共享状态(0-允许共享;1-待核实;)',
`dept_id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '集团id',
`tax_class_abbreviation` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '税收分类简称',
`difference_flag` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '差异标识(0-采集下级差异标识;1-原库里的数据差异标识)',
`description` varchar(400) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '描述',
PRIMARY KEY (`id`) USING BTREE,
INDEX `idx_group_taxcode_merchandise` (`merchandise_name`) USING BTREE,
INDEX `idx_group_taxcode_nsrsbh` (`xhf_nsrsbh`) USING BTREE
) ENGINE = InnoDB
CHARACTER SET = utf8
COLLATE = utf8_general_ci COMMENT = '集团商品税编表'
ROW_FORMAT = Dynamic;
DROP TABLE IF EXISTS `invoice_batch_request`;
CREATE TABLE `invoice_batch_request`
(
`id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '批量开票请求批次表id',
`fpqqpch` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '发票请求批次号',
`xhf_nsrsbh` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '销售方纳税人识别号',
`sldid` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '受理点id',
`kpjh` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '开票机号',
`kplx` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '开票类型(1:纸,2:电)',
`fplb` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '发票类别',
`status` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '请求状态(研二返回的状态code)',
`message` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '返回信息',
`kzzd` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '扩展字段',
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
`update_time` datetime(0) NULL DEFAULT NULL COMMENT '请求时间',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `idx_batch_info_fpqqpch` (`fpqqpch`) USING BTREE
) ENGINE = InnoDB
CHARACTER SET = utf8
COLLATE = utf8_general_ci COMMENT = '批量请求开票接口主表'
ROW_FORMAT = Compact;
DROP TABLE IF EXISTS `invoice_batch_request_item`;
CREATE TABLE `invoice_batch_request_item`
(
`id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '批量开票请求明细表id',
`invoice_batch_id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '批量开票请求主表id',
`fpqqpch` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '发票请求批次号',
`fpqqlsh` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '订单请求流水号',
`kplsh` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '开票流水号对应接口中fpqqlsh',
`xhf_nsrsbh` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '销售方纳税人识别号',
`status` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '请求状态',
`message` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '返回信息',
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
`update_time` datetime(0) NULL DEFAULT NULL COMMENT '请求时间',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `idx_batch_item_kplsh` (`kplsh`) USING BTREE,
INDEX `idx_batch_item_batch_id` (`invoice_batch_id`) USING BTREE,
INDEX `idx_batch_item_fpqqlsh` (`fpqqlsh`) USING BTREE,
INDEX `idx_batch_item_fpqqpch` (`fpqqpch`) USING BTREE
) ENGINE = InnoDB
CHARACTER SET = utf8
COLLATE = utf8_general_ci COMMENT = '批量请求开票接口明细表'
ROW_FORMAT = Compact;
DROP TABLE IF EXISTS `invoice_item_request`;
CREATE TABLE `invoice_item_request`
(
`id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '主键',
`company_id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '企业id',
`report_period` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '所属期间',
`xhf_nsrsbh` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '销货方纳税人识别号',
`fpzl_dm` varchar(5) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '发票种类代码',
`hzrq` varchar(8) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '汇总时间(例如:2019-01)',
`spbm` varchar(19) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '项目编码',
`xmmc` varchar(90) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '项目名称',
`invoice_num` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '发票份数',
`xmje` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '项目金额',
`se` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '税额',
`kphjje` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '价税合计金额',
`create_time` datetime(0) NOT NULL COMMENT '创建时间',
`complete_flag` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '完成标识(1未完成,2已完成,3汇总失败)',
PRIMARY KEY (`id`) USING BTREE,
INDEX `idx_item_req_nsrsbh` (`xhf_nsrsbh`, `hzrq`) USING BTREE
) ENGINE = InnoDB
CHARACTER SET = utf8
COLLATE = utf8_general_ci COMMENT = '项目汇总统计表接口'
ROW_FORMAT = Dynamic;
DROP TABLE IF EXISTS `invoice_taxrate_request`;
CREATE TABLE `invoice_taxrate_request`
(
`id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '主键',
`company_id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '企业id',
`xhf_nsrsbh` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '销货方纳税人识别号',
`fpzl_dm` varchar(5) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '发票种类代码',
`kplx` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '开票类型',
`report_period` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '所属期间',
`hzrq` varchar(8) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '汇总日期',
`sl` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '税率',
`invoice_amount_pt` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '正数有效发票金额',
`tax_amount_pt` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '正数有效发票税额',
`total_amount_pt` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '正数有效价税合计',
`invoice_amount_nt` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '负数有效发票金额',
`tax_amount_nt` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '负数有效发票税额',
`total_amount_nt` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '负数有效价税合计',
`invoice_amount_pt_void` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '正数作废发票金额',
`tax_amount_pt_void` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '正数作废发票税额',
`total_amount_pt_void` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '正数作废价税合计',
`invoice_amount_nt_void` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '负数作废发票金额',
`tax_amount_nt_void` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '负数作废发票税额',
`total_amount_nt_void` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '负数作废价税合计',
`create_time` datetime(0) NOT NULL COMMENT '创建时间',
`complete_flag` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '完成标识(1未完成,2已完成,3汇总失败)',
PRIMARY KEY (`id`) USING BTREE,
INDEX `idx_taxrate_nsrsbh` (`xhf_nsrsbh`, `hzrq`) USING BTREE
) ENGINE = InnoDB
CHARACTER SET = utf8
COLLATE = utf8_general_ci COMMENT = '税率汇总统计表接口'
ROW_FORMAT = Dynamic;
DROP TABLE IF EXISTS `invoice_type_code_ext`;
CREATE TABLE `invoice_type_code_ext`
(
`id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '发票种类扩展表主键',
`invoice_type_code_id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '发票种类主表id',
`fpzl_dm` varchar(5) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '发票种类代码(0.增值税专票 2 增值税普通纸质发票 51 增值税普通电子发票)',
`fpzl_dm_mc` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '发票种类代码(0.增值税专票 2 增值税普通纸质发票 51 增值税普通电子发票)',
`create_time` datetime(0) NOT NULL COMMENT '创建时间',
`xhf_nsrsbh` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '销货方识别号',
PRIMARY KEY (`id`) USING BTREE,
INDEX `idx_invoice_code__id` (`invoice_type_code_id`) USING BTREE COMMENT '发票种类父级id索引'
) ENGINE = InnoDB
CHARACTER SET = utf8
COLLATE = utf8_general_ci COMMENT = '发票种类扩展表'
ROW_FORMAT = Compact;
DROP TABLE IF EXISTS `invoice_warning_info`;
CREATE TABLE `invoice_warning_info`
(
`id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '预警表ID',
`xhf_nsrsbh` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '销货方纳税人识别号',
`xhf_mc` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '销货方名称',
`sbbh` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '设备编号',
`sb_mc` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '设备名称',
`fpzl_dm` varchar(3) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '发票种类代码 ',
`yjfs` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '预警份数',
`phone` varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '手机号',
`e_mail` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '邮箱',
`user_id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户id',
`yjcs` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '0' COMMENT '发送邮件次数',
`sfyj` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '是否邮件预警,0不预警 1预警',
`dept_id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '更新人所属组织 ID',
`delete_status` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '删除状态(0:未删除;1:已删除)',
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
`update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
PRIMARY KEY (`id`) USING BTREE,
INDEX `idx_ypyj_xhf_nsrsbh` (`xhf_nsrsbh`) USING BTREE
) ENGINE = InnoDB
CHARACTER SET = utf8
COLLATE = utf8_general_ci COMMENT = '余票预警表'
ROW_FORMAT = Dynamic;
DROP TABLE IF EXISTS `order_batch_request`;
CREATE TABLE `order_batch_request`
(
`id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '批量订单请求批次表id',
`ddqqpch` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '订单请求批次号',
`xhf_nsrsbh` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '销售方纳税人识别号',
`kpfs` varchar(5) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '开票方式(0:自动开票;1:手动开票),默认为0',
`sldid` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '受理点id',
`kpjh` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '开票机号',
`fpzldm` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '发票种类代码(0:专票 2:普票41:卷票51:电子票)',
`sfcpy` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '是否是成品油(0:非成品油;1:成品油)',
`status` varchar(6) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '批次状态(0:未开票;1:开票中;2:开票成功;3:开票异常)',
`message` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '返回信息',
`kzzd` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '扩展字段',
`create_time` datetime(0) NOT NULL COMMENT '申请单创建时间',
`update_time` datetime(0) NOT NULL COMMENT '请求时间',
PRIMARY KEY (`id`) USING BTREE,
INDEX `idx_order_batch_xhfnsrsbh` (`xhf_nsrsbh`) USING BTREE,
INDEX `idx_order_batch_fqqpch` (`ddqqpch`) USING BTREE
) ENGINE = InnoDB
CHARACTER SET = utf8
COLLATE = utf8_general_ci COMMENT = '订单请求批次表'
ROW_FORMAT = Compact;
DROP TABLE IF EXISTS `order_info`;
CREATE TABLE `order_info`
(
`id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '订单唯一id',
`process_id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '处理表id',
`fpqqlsh` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '发票请求流水号',
`ddh` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '订单号',
`thdh` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '退货单号',
`ddlx` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '订单类型(0:原始订单,1:拆分后订单,2:合并后订单,3:系统冲红订单)',
`dsptbm` varchar(8) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '电商平台编码',
`nsrsbh` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '纳税人识别号',
`nsrmc` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '纳税人名称',
`nsrdzdah` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '纳税人电子档案号',
`swjg_dm` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '税务机构代码',
`dkbz` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '代开标志(0:自开,1:代开)',
`pydm` varchar(6) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '票样代码:默认000001',
`kpxm` varchar(90) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '主要开票项目',
`bbm_bbh` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '编码表版本号',
`xhf_mc` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '销货方名称',
`xhf_nsrsbh` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '销货方识别号',
`xhf_dz` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '销货方地址',
`xhf_dh` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '销货方电话',
`xhf_yh` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '销货方银行',
`xhf_zh` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '销货方账号',
`ghf_qylx` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '购货方企业类型(01企业,02机关事业单位,03个人,04其他)',
`ghf_sf` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '购货方省份',
`ghf_id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '购货方编码id',
`ghf_mc` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '购货方名称',
`ghf_nsrsbh` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '购货方识别号',
`ghf_dz` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '购货方地址',
`ghf_dh` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '购货方电话',
`ghf_yh` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '购货方银行',
`ghf_zh` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '购货方账号',
`ghf_sj` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '购货方手机',
`ghf_email` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '购货方邮箱',
`hy_dm` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '行业代码',
`hy_mc` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '行业名称',
`kpr` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '开票人',
`skr` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '收款人',
`fhr` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '复核人',
`ddrq` datetime(0) NOT NULL COMMENT '订单日期',
`kplx` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '开票类型(0:蓝票;1:红票)',
`fpzl_dm` varchar(5) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '发票种类代码(0.增值税专票 2 增值税普通纸质发票 51 增值税普通电子发票)',
`yfp_dm` varchar(12) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '原发票代码',
`yfp_hm` varchar(8) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '原发票号码',
`chyy` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '冲红原因',
`tschbz` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '特殊冲红标志0正常冲红(电子发票) 1特殊冲红(冲红纸质等)',
`czdm` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '操作代码10正票正常开具 11正票错票重开 20 退货折让红票、21 错票重开红票、22换票冲红',
`qd_bz` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '0-普通发票;1-普通发票(清单);\r\n2-收购发票;3-收购发票(清单);\r\n4-成品油发票',
`qd_xmmc` varchar(90) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '清单发票项目名称,需要打印清单时对应发票票 面项目名称 清单标识(QD_BZ)为1时必 填。为 0 不进行处理。',
`kphjje` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '价税合计金额',
`hjbhsje` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '合计不含税金额',
`hjse` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '开票税额',
`mdh` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '门店号',
`ywlx` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '处理模式 0惠民 1 团购',
`tqm` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '提取码',
`bz` varchar(300) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
`kpjh` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '开票机号',
`sld` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '受理点',
`hzxxbbh` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '红字信息表编号',
`byzd1` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备用字段1',
`byzd2` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备用字段2(1:专票冲红已抵扣冲红失败,异常重新开票校验不校验发票代码、号码)',
`byzd3` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备用字段3',
`byzd4` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备用字段4',
`byzd5` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备用字段5',
`create_time` datetime(0) NOT NULL COMMENT '创建时间',
`update_time` datetime(0) NOT NULL COMMENT '更新时间',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `idx_order_info_process_id` (`process_id`) USING BTREE,
UNIQUE INDEX `idx_order_info_fpqqlsh` (`fpqqlsh`) USING BTREE,
INDEX `idx_order_infor_ddh` (`ddh`) USING BTREE,
INDEX `idx_order_info_nsrsbh` (`nsrsbh`) USING BTREE,
INDEX `idx_order_yfpdm_hm` (`yfp_dm`, `yfp_hm`) USING BTREE,
INDEX `idx_order_xhfnsrsbh` (`xhf_nsrsbh`) USING BTREE
) ENGINE = InnoDB
CHARACTER SET = utf8
COLLATE = utf8_general_ci COMMENT = '订单信息主表'
ROW_FORMAT = Compact;
DROP TABLE IF EXISTS `order_info_esc`;
CREATE TABLE `order_info_esc`
(
`id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '二手车唯一id',
`order_id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '订单表id',
`process_id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '处理表id',
`fpqqlsh` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '发票请求流水号',
`xhf_nsrsbh` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '销货方识别号',
`kpflx` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '开票方类型(1经营 2拍卖 3市场)',
`cpzh` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '车牌照号',
`djzh` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '登记证号',
`cllx` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '车辆类型',
`clsbdm` varchar(23) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '车架号/车辆识别代码',
`cpxh` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '厂牌型号',
`zrdclglsmc` varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '转入地车辆管理所名称',
`jypmdw_mc` varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '经营、拍卖单位名称',
`jypmdw_dz` varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '经营、拍卖单位地址',
`jypmdw_sh` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '经营、拍卖单位税号',
`jypmdw_yhzh` varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '经营、拍卖单位银行账号',
`jypmdw_dh` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '经营、拍卖单位电话',
`sc_mc` varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '二手车市场名称',
`sc_sh` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '二手车市场税号',
`sc_dz` varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '二手车市场地址',
`sc_yhzh` varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '二手车市场银行账号',
`sc_dh` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '二手车市场电话',
`esc_xhfdm` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '二手车销货方代码',
`esc_xhfmc` varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '二手车销货方名称',
`esc_xhfdz` varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '二手车销货方地址',
`esc_xhfdh` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '二手车销货方电话',
`sc_cgswspzhm` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '车购税完税凭证号码',
`create_time` datetime(0) NOT NULL COMMENT '创建时间',
`update_time` datetime(0) NOT NULL COMMENT '更新时间',
`byzd1` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备用字段1',
`byzd2` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备用字段2',
`byzd3` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备用字段3',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `idx_esc_fpqqlsh` (`fpqqlsh`) USING BTREE,
INDEX `idx_esc_process_id` (`process_id`) USING BTREE,
INDEX `idx_esc_order_id` (`order_id`) USING BTREE
) ENGINE = InnoDB
CHARACTER SET = utf8
COLLATE = utf8_general_ci COMMENT = '二手车订单表'
ROW_FORMAT = Dynamic;
DROP TABLE IF EXISTS `order_info_jdc`;
CREATE TABLE `order_info_jdc`
(
`id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '二手车唯一id',
`order_id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '订单表id',
`process_id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '处理表id',
`fpqqlsh` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '发票请求流水号',
`xhf_nsrsbh` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '销货方识别号',
`cllx` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '车辆类型',
`cpxh` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '厂牌型号',
`clcd` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '产地',
`hgzh` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '合格证号',
`jkzmsh` varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '进口证明书号',
`sjdh` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '商检单号',
`fdjhm` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '发动机号码',
`clsbdh` varchar(23) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '车辆识别单号',
`wspzhm` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '完税凭证号码',
`dw` varchar(8) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '吨位',
`xcrs` varchar(23) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '限乘人数',
`cjxx` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '厂家信息',
`zzjgdm` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '身份证号码/组织机构代码',
`create_time` datetime(0) NOT NULL COMMENT '创建时间',
`update_time` datetime(0) NOT NULL COMMENT '更新时间',
`byzd1` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备用字段1',
`byzd2` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备用字段2',
`byzd3` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备用字段3',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `idx_jdc_fpqqlsh` (`fpqqlsh`) USING BTREE,
INDEX `idx_jdc_process_id` (`process_id`) USING BTREE,
INDEX `idx_jdc_order_id` (`order_id`) USING BTREE
) ENGINE = InnoDB
CHARACTER SET = utf8
COLLATE = utf8_general_ci COMMENT = '机动车订单表'
ROW_FORMAT = Dynamic;
DROP TABLE IF EXISTS `order_invoice_info`;
CREATE TABLE `order_invoice_info`
(
`id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '订单处理表主键',
`order_info_id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '订单表id',
`order_process_info_id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '订单处理表id',
`fpqqlsh` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '发票请求流水号',
`kplsh` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '开票流水号',
`ddh` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '订单号',
`mdh` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '门店编号',
`ghf_mc` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '购货方名称',
`ghf_sj` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '购货方手机',
`kphjje` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '开票合计金额',
`hjbhsje` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '合计不含税金额',
`kpse` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '开票税额',
`fply` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '订单来源(0:Excel导入;1:手工录入;2:api原始订单接口;3:自动开票录入数据;4:其他;5:静态码扫码开票;6:动态码扫码开票;7:历史数据导入;8:供应链;9:发票修复)',
`kplx` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '开票类型(0蓝,1红)',
`kpzt` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '开票状态,(0:初始化;1:开票中;2:开票成功;3:开票失败;)',
`kprq` datetime(0) NULL DEFAULT NULL COMMENT '开票日期',
`fpdm` varchar(12) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '发票代码',
`fphm` varchar(8) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '发票号码',
`fpzl_dm` varchar(5) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '发票种类代码0.增值税专票 2 增值税普通纸质发票 51 增值税普通电子发票',
`jym` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '校验码',
`kpr` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '开票人',
`fwm` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '防伪码',
`ewm` varchar(5000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '二维码',
`jqbh` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '机器编号',
`pdf_url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'pdfurl地址',
`ch_bz` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '冲红标志(0:正常;1:全部冲红成功;2:全部冲红中;3:全部冲红失败;4:部分冲红成功;5:部分冲红中;6:部分冲红失败;(特殊说明:部分冲红只记录当前最后一次操作的记录))',
`sykchje` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '剩余可冲红金额',
`sykchbhsje` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '剩余可冲红不含税金额',
`sykchse` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '剩余可充红税额',
`chsj` datetime(0) NULL DEFAULT NULL COMMENT '冲红时间',
`chyy` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '冲红原因',
`zf_bz` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '作废标志(0:正常;1:已作废;2:作废中;3:作废失败)',
`zfsj` datetime(0) NULL DEFAULT NULL COMMENT '作废时间',
`zfyy` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '作废原因',
`sbyy` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '开票失败原因',
`rz_zt` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '认证状态',
`sld_mc` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`sld` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '受理点',
`fjh` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '分机号',
`xhf_mc` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '销货方名称',
`xhf_nsrsbh` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '销货方纳税人识别号',
`qd_bz` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '0 不带清单 1 带清单',
`dyzt` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '打印状态 0 未打印 1 已打印',
`push_status` varchar(5) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0' COMMENT '推送状态,(0:未推送;1:推送成功;2:推送失败;)',
`email_push_status` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '0' COMMENT '0 初始化 1 推送中 2 推送成功 3 推送失败',
`short_msg_push_status` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '短信推送状态 (0 初始未推送 1 推送中 2.推送成功 3 推送失败)',
`hzxxbbh` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '红字信息表编号',
`sksbdm` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '000' COMMENT '税控设备代码(000:未配置;001:金税盘托管;002:金税盘A9托管;004:税控盘托管;005:百望服务器;006:本地税控盘;007:本地金税盘;008:百望服务器ActiveX;009:税控服务器;010:UKey托管;011:本地UKey;012:金税盘U180托管;013:UkeyU180托管;014:UT1000/Q30)',
`create_time` datetime(0) NOT NULL,
`update_time` datetime(0) NOT NULL,
`mongodb_id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'mongodb服务中pdf文件存储对应的id',
`dept_id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '部门编号',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `idx_order_invoice_order_id` (`order_info_id`) USING BTREE,
UNIQUE INDEX `idx_order_invoice_process_id` (`order_process_info_id`) USING BTREE,
UNIQUE INDEX `idx_order_invoice_fpqqlsh` (`fpqqlsh`) USING BTREE,
UNIQUE INDEX `idx_order_invoice_kplsh` (`kplsh`) USING BTREE,
INDEX `idx_order_invoice_kprq` (`kprq`) USING BTREE,
INDEX `idx_order_invoice_fpdmhm` (`fpdm`, `fphm`) USING BTREE,
INDEX `idx_order_invoice_xhfsbh` (`xhf_nsrsbh`) USING BTREE
) ENGINE = InnoDB
CHARACTER SET = utf8
COLLATE = utf8_general_ci COMMENT = '订单和发票关系表'
ROW_FORMAT = Compact;
DROP TABLE IF EXISTS `order_item_info`;
CREATE TABLE `order_item_info`
(
`id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '订单明细表主键',
`order_info_id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '订单主表id',
`sphxh` varchar(5) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '商品行序号',
`xmmc` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '项目名称',
`xmdw` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '项目单位',
`ggxh` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '规格型号',
`xmsl` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '项目数量',
`hsbz` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '含税标志 0 不含税 1含税',
`xmdj` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '项目单价',
`fphxz` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '发票行性质 0正常商品行 1折扣行 2被折扣行',
`spbm` varchar(19) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '商品编码',
`zxbm` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '自行编码',
`yhzcbs` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '优惠政策标识',
`lslbs` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '零税率标识',
`zzstsgl` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '增值税特殊管理',
`kce` varchar(24) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '扣除额',
`xmje` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '项目金额',
`sl` varchar(12) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '税率',
`se` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '税额',
`wcje` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '尾差金额',
`xhf_nsrsbh` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '销售方纳税人识别号',
`byzd1` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备用字段1',
`byzd2` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备用字段2',
`byzd3` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备用字段3',
`byzd4` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备用字段4',
`byzd5` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备用字段5',
`create_time` datetime(0) NOT NULL COMMENT '创建时间',
PRIMARY KEY (`id`) USING BTREE,
INDEX `idx_order_item_order_id` (`order_info_id`) USING BTREE
) ENGINE = InnoDB
CHARACTER SET = utf8
COLLATE = utf8_general_ci COMMENT = '订单信息明细表'
ROW_FORMAT = Compact;
DROP TABLE IF EXISTS `order_orgin_extend_info`;
CREATE TABLE `order_orgin_extend_info`
(
`id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '主键id',
`order_id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '订单表id',
`fpqqlsh` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '发票请求流水号',
`origin_order_id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '原始订单id',
`origin_fpqqlsh` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '原始订单发票请求流水号',
`origin_ddh` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '原始订单号',
`xhf_nsrsbh` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '销售方纳税人识别号',
`create_time` datetime(0) NOT NULL COMMENT '创建时间',
`update_time` datetime(0) NOT NULL COMMENT '更新时间',
`status` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0' COMMENT '0 有效 1 无效',
PRIMARY KEY (`id`) USING BTREE,
INDEX `idx_order_orgin_extend_info_order_id` (`order_id`) USING BTREE,
INDEX `idx_order_orgin_extend_info_origin_order_id` (`origin_order_id`) USING BTREE
) ENGINE = InnoDB
CHARACTER SET = utf8
COLLATE = utf8_general_ci COMMENT = '原始订单扩展表'
ROW_FORMAT = Dynamic;
DROP TABLE IF EXISTS `order_process_info`;
CREATE TABLE `order_process_info`
(
`id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '订单处理表主键',
`order_info_id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '订单表id',
`ddqqpch` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '订单请求批次号',
`fpqqlsh` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '发票请求流水号',
`ddh` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '订单号',
`tqm` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '提取码',
`kphjje` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '开票合计金额',
`hjbhsje` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '合计不含税金额',
`kpse` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '开票税额',
`fpzl_dm` varchar(5) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '发票种类代码:0专票 2 普票 51 电子发票',
`ghf_mc` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '购买方名称',
`ghf_nsrsbh` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '购货方识别号',
`xhf_nsrsbh` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '销货方纳税人识别号',
`xhf_mc` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '销货方名称',
`kpxm` varchar(90) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '主要开票项目',
`ddcjsj` datetime(0) NOT NULL COMMENT '订单创建时间',
`ddlx` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '订单类型(0:原始订单,1:拆分后订单,2:合并后订单,3:系统冲红订单,4:自动开票订单5:作废重开订单;6:历史数据订单;7:发票修复数据)',
`ddzt` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '订单状态(0:初始化;1:拆分后;2:合并后;3:待开具;4:开票中;5:开票成功;6.开票失败;7.冲红成功;8.冲红失败;9.冲红中;10,自动开票中,11,删除状态)',
`ddly` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '订单来源(0:Excel导入;1:手工录入;2:api原始订单接口;3:自动开票录入数据;4:其他;5:静态码扫码开票;6:动态码扫码开票;7:历史数据导入;8:供应链;9:发票修复)',
`ywlx` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '业务类型(区分企业业务线),可以企业自定义',
`ywlx_id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '业务类型Id',
`kpfs` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '企业开票方式(0:自动开票;1:手动开票;2:静态码开票;3:动态码开票),默认为0',
`sbyy` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '失败原因',
`order_status` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '订单状态(0:有效;1:无效)',
`fg_status` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '方格数据状态,空表示没有获取数据或者获取失败,1表示获取数据成功',
`edit_status` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '异常订单更新状态 (0 : 未编辑 1:已编辑)',
`check_status` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '审核状态 (0 初始状态 1 待审核状态 2 审核通过 3 审核驳回)',
`num` int(11) NULL DEFAULT NULL,
`check_time` datetime(0) NULL DEFAULT NULL COMMENT '审核时间',
`create_time` datetime(0) NOT NULL COMMENT '订单审核时间 业务中扫码(审核)开票,供应链业务使用',
`update_time` datetime(0) NOT NULL,
`dept_id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '部门编号',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `idx_order_process_order_id` (`order_info_id`) USING BTREE,
UNIQUE INDEX `idx_order_process_fpqqlsh` (`fpqqlsh`) USING BTREE,
INDEX `idx_order_process_xhf_nsrsbh` (`xhf_nsrsbh`) USING BTREE,
INDEX `idx_order_process_ddqqpch` (`ddqqpch`) USING BTREE,
INDEX `idx_order_process_ddcjsj` (`ddcjsj`) USING BTREE,
INDEX `idx_order_process_ddzt` (`ddzt`) USING BTREE,
INDEX `idx_order_process_ddh` (`ddh`) USING BTREE
) ENGINE = InnoDB
CHARACTER SET = utf8
COLLATE = utf8_general_ci COMMENT = '订单处理记录表'
ROW_FORMAT = Compact;
DROP TABLE IF EXISTS `order_process_info_ext`;
CREATE TABLE `order_process_info_ext`
(
`id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '订单处理表主键',
`order_process_info_id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '订单处理表id',
`parent_order_info_id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '父订单表id',
`parent_order_process_id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '父订单处理表id',
`xhf_nsrsbh` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '销售方纳税人识别号',
`status` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '状态(0:有效;1:无效)',
`create_time` datetime(0) NOT NULL COMMENT '创建时间',
`update_time` datetime(0) NOT NULL COMMENT '更新时间',
PRIMARY KEY (`id`) USING BTREE,
INDEX `idx_process_ext_processid` (`order_process_info_id`) USING BTREE,
INDEX `idx_process_ext_p_processid` (`parent_order_process_id`) USING BTREE,
INDEX `idx_process_ext_p_orderid` (`parent_order_info_id`) USING BTREE
) ENGINE = InnoDB
CHARACTER SET = utf8
COLLATE = utf8_general_ci COMMENT = '订单处理记录扩展表'
ROW_FORMAT = Compact;
DROP TABLE IF EXISTS `order_qrcode_extend`;
CREATE TABLE `order_qrcode_extend`
(
`id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '订单二维码扩展表主键id',
`order_info_id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '订单id 关联订单主表',
`auth_order_id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '公众号 授权订单号',
`open_id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '公众号open_id',
`union_id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '公众号 union_id',
`quick_response_code_type` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '二维码类型 (0 静态码;1 动态码)',
`fpzl_dm` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '发票种类代码',
`fpqqlsh` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '发票请求流水号',
`tqm` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '提取码',
`ddh` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '订单号',
`kphjje` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '开票合计金额',
`xhf_mc` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '销货方名称',
`xhf_nsrsbh` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '销货方纳税人识别号',
`zfzt` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '作废状态( 0 未作废 1 已作废 )',
`card_status` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '公众号插卡状态( 0 初始化状态 1 插卡成功 2 插卡失败)',
`ewmzt` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '二维码状态 ( 0 未使用 1 已使用 )',
`quick_response_code_url` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '二维码短链接',
`quick_response_code_valid_time` datetime(0) NULL DEFAULT NULL COMMENT '订单失效时间',
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
`update_time` datetime(0) NOT NULL COMMENT '更新时间',
`data_status` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '数据状态( 0 : 有效 1:无效 )',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `index_order_info_id` (`order_info_id`) USING BTREE,
UNIQUE INDEX `index_fpqqlsh` (`fpqqlsh`) USING BTREE,
UNIQUE INDEX `index_auth_order_id` (`auth_order_id`) USING BTREE,
INDEX `index_tqm` (`tqm`) USING BTREE
) ENGINE = InnoDB
CHARACTER SET = utf8
COLLATE = utf8_general_ci COMMENT = '订单二维码 扩展表'
ROW_FORMAT = Dynamic;
DROP TABLE IF EXISTS `paper_invalid_invoice_info`;
CREATE TABLE `paper_invalid_invoice_info`
(
`id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '纸票作废主键',
`zfpch` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '作废批次号',
`fpdm` varchar(12) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '发票代码',
`fphm` varchar(8) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '发票号码',
`sld` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '受理点',
`fplx` varchar(3) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '发票类型',
`zfyy` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '作废原因',
`zf_bz` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '作废标志(0:正常;1:已作废;2:作废中;3:作废失败)',
`zfsj` datetime(0) NOT NULL COMMENT '作废时间',
`dyzt` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '打印状态(0 未打印 1 已打印)',
`xhf_mc` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '销货方名称',
`xhf_nsrsbh` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '购货方纳税人识别号',
`create_time` datetime(0) NOT NULL COMMENT '创建时间',
`update_time` datetime(0) NOT NULL COMMENT '修改时间',
`fg_status` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '0接收成功,1接收失败,2待作废',
`zfr` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '作废人',
`zflx` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '作废类型(0:空白发票作废;1:正数发票作废;2:负数发票作废;)',
UNIQUE INDEX `idx_paper_invalid_fpdmfhm` (`fpdm`, `fphm`) USING BTREE,
INDEX `idx_paper_invalid_xhfnsrsbh` (`xhf_nsrsbh`) USING BTREE,
INDEX `idx_paper_invalid_zfpch` (`zfpch`) USING BTREE
) ENGINE = InnoDB
CHARACTER SET = utf8
COLLATE = utf8_general_ci COMMENT = '纸质发票作废表'
ROW_FORMAT = Compact;
DROP TABLE IF EXISTS `push_info`;
CREATE TABLE `push_info`
(
`id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '推送表ID',
`nsrsbh` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '销方税号',
`interface_type` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '接口类型(1:发票推送;2:作废状态推送;3:扫码开票;4:删除发票推送;5:待审核订单推送;6:UKey状态推送)',
`version_ident` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '版本标识,区分新旧版本(v1,v2,v3)',
`encrypt_code` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0' COMMENT '加密标识(0:base64加密;1:3des加密)',
`zip_code` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0' COMMENT '压缩标识(0:不压缩;1:压缩)',
`push_wjl` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0' COMMENT '是否推送文件流(0:推送;1:不推送)',
`push_url` varchar(400) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '推送企业的url',
`status` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0' COMMENT '0 有效 1 无效',
`byzd1` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备用字段1',
`byzd2` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备用字段2',
`create_time` datetime(0) NOT NULL COMMENT '创建时间',
`modify_time` datetime(0) NOT NULL COMMENT '更新时间',
PRIMARY KEY (`id`) USING BTREE,
INDEX `idx_push_nsrsbh` (`nsrsbh`, `interface_type`) USING BTREE
) ENGINE = InnoDB
CHARACTER SET = utf8
COLLATE = utf8_general_ci COMMENT = '发票推送表'
ROW_FORMAT = Dynamic;
DROP TABLE IF EXISTS `quick_response_code_info`;
CREATE TABLE `quick_response_code_info`
(
`id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '二维码表主键',
`quick_response_code_type` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '二维码类型(0:静态码;1:动态码)',
`xhf_mc` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '销货方名称',
`xhf_nsrsbh` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '销货方识别号',
`xhf_dz` varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '销货方地址',
`xhf_dh` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '销货方电话',
`xhf_yh` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '销货方银行',
`xhf_zh` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '销货方账号',
`ywlx` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '业务类型(区分企业业务线),可以企业自定义',
`ywlx_id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '公众号union_id',
`sld_mc` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '受理点名称',
`sld` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '受理点',
`fjh` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '分机号',
`kpr` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '开票人',
`skr` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '收款人',
`fhr` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '复核人',
`ewmzt` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '二维码状态 0 未删除 1 已删除',
`tqm` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '提取码,二维码唯一编码',
`quick_response_code_url` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '二维码短链接',
`quick_response_code_valid_time` datetime(0) NULL DEFAULT NULL COMMENT '二维码失效时间',
`create_time` datetime(0) NOT NULL COMMENT '创建时间',
`update_time` datetime(0) NOT NULL COMMENT '更新时间',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `idx_quick_response_tqm` (`tqm`) USING BTREE COMMENT '提取码唯一索引',
INDEX `idx_quick_response_nsrsbh` (`xhf_nsrsbh`) USING BTREE
) ENGINE = InnoDB
CHARACTER SET = utf8
COLLATE = utf8_general_ci COMMENT = '静态码主表'
ROW_FORMAT = Compact;
DROP TABLE IF EXISTS `quick_response_code_item_info`;
CREATE TABLE `quick_response_code_item_info`
(
`id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '二维码明细表主键',
`quick_response_code_info_id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '二维码主表id',
`sphxh` varchar(5) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '商品行序号',
`xmmc` varchar(90) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '项目名称',
`xmdw` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '项目单位',
`ggxh` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '规格型号',
`xmsl` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '项目数量',
`hsbz` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '含税标志 0 不含税 1含税',
`xmdj` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '项目单价',
`fphxz` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '发票行性质 0正常商品行 1折扣行 2被折扣行',
`spbm` varchar(19) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '商品编码',
`zxbm` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '自行编码',
`yhzcbs` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '优惠政策标识',
`lslbs` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '零税率标识',
`zzstsgl` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '增值税特殊管理',
`kce` varchar(24) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '扣除额',
`xmje` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '项目金额',
`sl` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '税率',
`se` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '税额',
`wcje` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '尾差金额',
`byzd1` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备用字段1',
`byzd2` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备用字段2',
`byzd3` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备用字段3',
`byzd4` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备用字段4',
`byzd5` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备用字段5',
`create_time` datetime(0) NOT NULL COMMENT '创建时间',
`xhf_nsrsbh` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '销货方识别号',
PRIMARY KEY (`id`) USING BTREE,
INDEX `idx_quick_response_item_infoid` (`quick_response_code_info_id`) USING BTREE COMMENT '主表id'
) ENGINE = InnoDB
CHARACTER SET = utf8
COLLATE = utf8_general_ci COMMENT = '静态码明细表'
ROW_FORMAT = Compact;
DROP TABLE IF EXISTS `registration_code`;
CREATE TABLE `registration_code`
(
`id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`xhf_nsrsbh` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`zcm` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '注册码',
`jqbh` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '机器编号',
`splx` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '0-航信;1-百旺;2-UKey',
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
`update_time` datetime(0) NULL DEFAULT NULL COMMENT '修改时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB
CHARACTER SET = utf8
COLLATE = utf8_general_ci COMMENT = '注册码表'
ROW_FORMAT = Dynamic;
DROP TABLE IF EXISTS `rule_split`;
CREATE TABLE `rule_split`
(
`id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '超限额拆分ID',
`taxpayer_code` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '纳税人识别号',
`user_id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '当前登录人id',
`dpxe` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '电票限额',
`ppxe` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '普通发票限额',
`zpxe` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '专票限额',
`hsbz` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '0 按照 不含税金额拆分 1 按照含税金额拆分',
`rule_split_type` varchar(5) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '0 : 保金额 ; 1 : 保数量 ; 2 : 保单价',
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
`update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
PRIMARY KEY (`id`) USING BTREE,
INDEX `idx_rule_split_xhfnsrsbh` (`taxpayer_code`) USING BTREE COMMENT '拆分规则表税号索引',
INDEX `idx_rule_split_userid` (`user_id`) USING BTREE COMMENT '拆分规则表用户id索引'
) ENGINE = InnoDB
CHARACTER SET = utf8
COLLATE = utf8_general_ci COMMENT = '超限额拆分表'
ROW_FORMAT = Dynamic;
DROP TABLE IF EXISTS `saler_warning`;
CREATE TABLE `saler_warning`
(
`id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '预警id',
`xhf_nsrsbh` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '销货方税号',
`waring_email` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '预警邮箱(多个邮箱以逗号分隔)',
`warning_flag` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '预警开关(0,关闭;1,开启)',
`deptId` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '预警人员的部门id',
`createId` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建id',
`createUser` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建人',
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
`update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
PRIMARY KEY (`id`) USING BTREE,
INDEX `idx_warning_xhfnsrsbh` (`xhf_nsrsbh`) USING BTREE COMMENT '预警税号索引',
INDEX `idx_warning_userid` (`createId`) USING BTREE COMMENT '预警用户索引'
) ENGINE = InnoDB
CHARACTER SET = utf8
COLLATE = utf8_general_ci COMMENT = '发票预警表'
ROW_FORMAT = Dynamic;
DROP TABLE IF EXISTS `special_invoice_reversal`;
CREATE TABLE `special_invoice_reversal`
(
`id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '专票红字申请单ID',
`type` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '申请单类型0:正常;1:成品油-销售数量变更2:成品油-销售金额变更;3成品油-其他',
`sqdscqqpch` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '申请单请求批次号',
`sqdscqqlsh` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '申请表上传请求流水号',
`sqdh` varchar(24) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '申请单号',
`sqsm` varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '申请说明: 1100000000:购方申请 已抵扣;1010000000:购方申请 未抵扣;0000000100 因发票有误购买方拒收的因开票有误等原因尚未交付的',
`yfp_dm` varchar(12) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '原蓝票发票代码',
`yfp_hm` varchar(8) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '原蓝票发票号码',
`yfp_kprq` datetime(0) NULL DEFAULT NULL COMMENT '原蓝字发票开票日期',
`invoice_type` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '发票种类',
`fpzl_dm` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '发票种类代码 0:专票;2:普票;41:卷票;51:电票',
`tksj` datetime(0) NULL DEFAULT NULL COMMENT '红字申请单填开时间',
`nsrsbh` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '申请纳税人识别号',
`xhf_mc` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '销方名称',
`xhf_nsrsbh` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '销方纳税人识别号 ',
`xhf_dz` varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '销货方地址',
`xhf_dh` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '销货方电话',
`xhf_yh` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '销货方银行',
`xhf_zh` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '销货方账号',
`ghf_mc` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '购方名称',
`ghf_nsrsbh` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '购方纳税人识别号',
`ghf_dz` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '购货方地址',
`ghf_dh` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '购货方电话',
`ghf_yh` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '购货方银行',
`ghf_zh` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '购货方账号',
`ghfqylx` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '购货方企业类型',
`hjbhsje` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '合计金额',
`hjse` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '合计税额',
`kphjje` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '含税总金额',
`dslbz` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '多税率标志',
`xxbbh` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '信息表编号',
`bmbbbh` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '编码表版本号',
`kpzt` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '开票状态 0 未开票 1 开票中 2 开票成功 3 开票异常',
`fpdm` varchar(12) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '当前红票发票号码',
`fphm` varchar(8) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '当前红票发票号码',
`sld` varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '受理点ID',
`sld_mc` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '受理点名称',
`fjh` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '分机号',
`chyy` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '冲红原因',
`kpr` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '开票人',
`fhr` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '复核人',
`skr` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '收款人',
`agent_name` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '经办人',
`status_code` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '上传状态代码 TZD0000:审核通过;TZD0500:未上传;TZD0061:重复上传;TZD0071:待查证;TZD0072:已核销,待查证;TZD0073:已核销,查证未通过,待处理;TZD0074:已核销;TZD0075:核销后激活;TZD0076:已核销,查证未通过,处理中;TZD0077:已核销,查证未通过,已处理;TZD0078:核销未通过,待处理;TZD0079:核销未通过,处理中;TZD0080:核销未通过,已处理;TZD0082:已撤销;TZD0083:已作废',
`status_message` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '上传状态描述',
`creator_id` varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '创建人ID',
`creator_name` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '创建人姓名',
`editor_id` varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '编辑人ID',
`editor_name` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '编辑人姓名',
`create_time` datetime(0) NOT NULL COMMENT '创建时间',
`update_time` datetime(0) NOT NULL COMMENT '编辑时间',
`data_status` varchar(5) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '0' COMMENT ' 0:有效;1:无效',
`scfg_status` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '上传方格数据状态,空表示没有获取数据 1表示失败数据,0表示获取数据成功 2表示待上传',
`xzfg_status` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '下载方格数据状态,空表示没有获取数据 1表示失败数据,0表示获取数据成功 2表示待下载',
`sqbscqqpch` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`yysbz` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '营业税标志',
`xxblx` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '信息表类型 (0正常;1逾期(仅销方开具))',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `idx_special_code` (`sqdh`) USING BTREE,
UNIQUE INDEX `idx_special_qqlsh` (`sqdscqqlsh`) USING BTREE,
INDEX `idx_special_submitcode` (`status_code`) USING BTREE,
INDEX `idx_special_nsrsbh` (`nsrsbh`) USING BTREE
) ENGINE = InnoDB
CHARACTER SET = utf8
COLLATE = utf8_general_ci COMMENT = '专票红字申请单主表'
ROW_FORMAT = Dynamic;
DROP TABLE IF EXISTS `special_invoice_reversal_download`;
CREATE TABLE `special_invoice_reversal_download`
(
`id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '主键id',
`sqbxzqqpch` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '申请表审核结果下载请求批次号',
`nsrsbh` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '纳税人识别号',
`sldid` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '受理点id',
`kpjh` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '开票机号',
`fpzldm` varchar(5) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '发票类型代码',
`tkrq_q` varchar(8) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '填开日期起',
`tkrq_z` varchar(8) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '填开日期止',
`gmf_nsrsbh` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '购买方税号',
`xsf_nsrsbh` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '销售方税号',
`xxbbh` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '信息表编号',
`xxbfw` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '信息表下载范围0全部;1本企业申请;2其它企业申',
`pageno` varchar(5) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '页数',
`pagesize` varchar(5) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '条数',
`down_status` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '下载状态(0:初始化;1:下载中;2:下载完成:)',
`create_time` datetime(0) NOT NULL COMMENT '创建时间',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `sqbxzqqpch` (`sqbxzqqpch`) USING BTREE
) ENGINE = InnoDB
CHARACTER SET = utf8
COLLATE = utf8_general_ci COMMENT = '红字申请单下载'
ROW_FORMAT = Dynamic;
DROP TABLE IF EXISTS `special_invoice_reversal_item`;
CREATE TABLE `special_invoice_reversal_item`
(
`id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '专票红字申请单明细ID',
`special_invoice_reversal_id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '红色申请单主表ID',
`spbm` varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '商品编码',
`zxbm` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '自行编码',
`xmmc` varchar(90) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '项目名称',
`ggxh` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '规格型号',
`xmdw` varchar(22) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '项目单位',
`xmsl` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '项目数量',
`xmdj` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '项目单价',
`kce` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '扣除额',
`xmje` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '项目金额',
`sl` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '税率',
`se` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '税额',
`hsbz` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '含税标志 0:不含税;1:含税',
`fphxz` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '\' 0 1 2\'',
`sphxh` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '序号',
`lslbs` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '零税率标识\', ',
`yhzcbs` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '
0
:
;
1:',
`zzstsgl` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '增值税特殊管理',
`wcje` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`create_time` datetime(0) NOT NULL COMMENT '创建时间',
PRIMARY KEY (`id`) USING BTREE,
INDEX `INDEX_SIR_ID` (`special_invoice_reversal_id`) USING BTREE
) ENGINE = InnoDB
CHARACTER SET = utf8
COLLATE = utf8_general_ci COMMENT = '专票红字申请单明细表'
ROW_FORMAT = Dynamic;
DROP TABLE IF EXISTS `sys_dictionary`;
CREATE TABLE `sys_dictionary`
(
`id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '字典名称',
`type` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '字典类型',
`code` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '字典码',
`value` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '字典值',
`order_num` int(11) NULL DEFAULT 0 COMMENT '排序',
`remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
`del_flag` tinyint(4) NULL DEFAULT 0 COMMENT '删除标记 -1
0
',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `idx_dictionary_type` (`type`, `code`) USING BTREE
) ENGINE = InnoDB
CHARACTER SET = utf8
COLLATE = utf8_general_ci COMMENT = '数据字典表'
ROW_FORMAT = Dynamic;
DROP TABLE IF EXISTS `sys_nsr_queue`;
CREATE TABLE `sys_nsr_queue`
(
`id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '队列信息表主键',
`nsrsbh` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '税号',
`queue_name` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '队列名称',
`status` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '队列状态(0:有效;1:无效)',
`listener_size` varchar(5) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '监听数量,必须大于0,并且为整数',
`listener_status` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '监听状态(0:有效;1:无效)',
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
`update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `idx_nsr_queue_pre_name` (`queue_name`) USING BTREE,
INDEX `idx_nsr_queue_nsrsbh` (`nsrsbh`) USING BTREE
) ENGINE = InnoDB
CHARACTER SET = utf8
COLLATE = utf8_general_ci COMMENT = '消息队列表'
ROW_FORMAT = Dynamic;
DROP TABLE IF EXISTS `tax_class_code`;
CREATE TABLE `tax_class_code`
(
`id` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '税收分类编码ID',
`spbm` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '商品编码',
`spmc` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '商品名称',
`spjc` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '商品简称',
`sm` varchar(3000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '说明',
`zzssl` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '增值税税率',
`gjz` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '关键字',
`hzx` varchar(5) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '汇总项 Y 是 N 不是',
`kyzt` varchar(5) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '可用状态 Y 可用 N不可用',
`zzstsgl` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '增值税特殊管理',
`zzszcyj` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '增值税政策依据',
`zzstsnrdm` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '增值税特殊内容代码',
`xfsgl` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '消费税管理',
`xfszcyj` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '消费税政策依据',
`xfstsnrdm` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '消费税特殊内容代码',
`tjjbm` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '统计局编码',
`hgjcksppm` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '海关进出口商品名称',
`pid` bigint(30) NULL DEFAULT NULL COMMENT 'pid',
`yhzcmc` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '优惠政策名称',
`sl` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '税率',
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
`bbh` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '编码表版本号',
`cpy` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '是否成品油(Y:成品油;N:非成品油)',
`enabling_time` datetime(0) NULL DEFAULT NULL COMMENT '税编启用时间',
`update_time` datetime(0) NULL DEFAULT NULL COMMENT '税编更新时间',
`mslx` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '免税类型
0
1-
2-
3-
',
PRIMARY KEY (`id`) USING BTREE,
INDEX `idx_tax_code_spbm` (`spbm`) USING BTREE
) ENGINE = InnoDB
CHARACTER SET = utf8
COLLATE = utf8_general_ci COMMENT = '税收分类编码表'
ROW_FORMAT = Dynamic;
DROP TABLE IF EXISTS `user_guider`;
CREATE TABLE `user_guider`
(
`id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '主键id',
`operate` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`operate_group` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '操作分组',
`operate_description` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '引导步骤',
`step` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '引导步骤',
`video_url` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户引导视频url',
`status` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '是否引导过(1 是 0 否)',
`uid` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户id',
`xhf_nsrsbh` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '销货方纳税人识别号',
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
`update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB
CHARACTER SET = utf8
COLLATE = utf8_general_ci COMMENT = '用户引导表'
ROW_FORMAT = Compact;
SET FOREIGN_KEY_CHECKS = 1;