# 【财务】租客账单、收支流水
财务模块，由 xcmd-module-asset 后端模块的 org 包实现，主要有账单管理、收据发票等功能。如下图所示：
# 所有账单
所有账单，由 OrgBillController 提供接口。
# 1.表结构
省略 creator/create_time/updater/update_time/deleted/tenant_id 等通用字段
CREATE TABLE `org_bill_stream` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT '编号',
`owner_id` bigint DEFAULT NULL COMMENT '租客id',
`village_id` bigint DEFAULT NULL COMMENT '项目id',
`build_id` bigint DEFAULT NULL COMMENT '楼宇id',
`build_ids` json DEFAULT NULL COMMENT '绑定的楼宇json',
`build_bind` json DEFAULT NULL COMMENT '绑定楼宇信息json',
`room_number` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '房间号json',
`bill_id` bigint DEFAULT NULL COMMENT '账单id',
`account_id` bigint DEFAULT NULL COMMENT '收款(业主)流水账号id',
`account_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '收款流水账户名称',
`stream_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '流水号',
`stream_source` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '1' COMMENT '流水来源;1=手动创建;2=线上付款回调',
`bill_type` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '账单类型;1=收款;2=付款;',
`is_close` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '1' COMMENT '流水是否开启;0=关闭;1=开启;2=审核中;3=已驳回;默认开启',
`loan_type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '借贷类型',
`is_confirm` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '1' COMMENT '是否确认;1=待确认;2=已确认;',
`amount` decimal(19,2) DEFAULT NULL COMMENT '发生额',
`income_date` date DEFAULT NULL COMMENT '入账日期',
`cancel_match_date` date DEFAULT NULL COMMENT '取消匹配日期',
`company_id` bigint DEFAULT NULL COMMENT '对账收付款公司id',
`company_name` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '对方单位名称',
`company_type` tinyint DEFAULT NULL COMMENT '收付款公司类型',
`stream_account` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '租客开户银行名称',
`match_date` datetime DEFAULT NULL COMMENT '匹配日期',
`match_status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '匹配状态;1=完全匹配;2=未匹配;3=部分匹配;',
`match_price` decimal(19,2) DEFAULT '0.00' COMMENT '已匹配金额',
`nomatch_price` decimal(19,2) DEFAULT '0.00' COMMENT '未匹配金额',
`refund_price` decimal(19,2) DEFAULT '0.00' COMMENT '退款金额',
`currency` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '币种',
`cost_type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '费用类型',
`link_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '联系人',
`remit_type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '汇款方式',
`other_account` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '对方账号',
`son_account` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '对方子账户',
`son_account_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '对方子账户名称',
`son_account_status` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '对方子账户余额调整状态',
`voucher_no` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '凭证号',
`receipt_no` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '收据编号',
`abstractc` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '摘要',
`is_unreal_room` smallint DEFAULT '0' COMMENT '房屋虚拟标识.0=真实房屋;1=非真实房屋',
`unreal_room` json DEFAULT NULL COMMENT '虚拟房屋信息',
`remark` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '备注',
`close_reason` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '关闭流水的原因',
`extra` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '预存的额外信息，比如电表id',
`approval_status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '0' COMMENT '删除流水申请的状态0正常1删除中2已删除',
`approval_cancel` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '0' COMMENT '删除审批中是否允许撤销0不允许1允许',
`reason` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '删除流水的原因',
`single_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '专项名称',
`data_source` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '流水来源0=收款中创建数据',
`pp_stream_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '匹配流水id',
`invoice_title_id` bigint DEFAULT NULL COMMENT '转账的发票抬头ID',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=45 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='机构账单收支流水表';
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
# 2.管理后台
对应 [资产管理系统 -> 财务 -> 所有账单] 菜单，对应 xhrt-admin 项目的 @/views/bus/bill/billList 目录。
# 账单开票记录
账单开票记录，由 OrgBillInvoiceController 提供接口。
# 1.表结构
省略 creator/create_time/updater/update_time/deleted/tenant_id 等通用字段
CREATE TABLE `org_bill_invoice` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT '编号',
`village_id` bigint DEFAULT NULL COMMENT '项目id',
`build_id` bigint DEFAULT NULL COMMENT '楼宇id',
`bill_id` bigint DEFAULT NULL COMMENT '账单id',
`subbill_id` bigint DEFAULT NULL COMMENT '子账单ID',
`build_bind` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '绑定楼宇信息json',
`room_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '房号json',
`seller_id` bigint DEFAULT NULL COMMENT '售方id',
`owner_id` bigint DEFAULT NULL COMMENT '买方(租客)id',
`buyer_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '购方名称',
`buyer_account` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '购方(租客)开户行账号',
`goods_type` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '货物类型;1=停车费;2=租金;',
`cost_type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '账单费用类型',
`invoice_time` datetime DEFAULT NULL COMMENT '开票时间',
`invoice_status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '1' COMMENT '发票状态;1=待开票;2=已开票;3=已冲红;4=已作废;5=已开负数发票;6=作废审批中;7=开票失败;8=开票审核中;9=冲红失败',
`invoice_number` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '发票编号',
`record_price` decimal(19,2) DEFAULT NULL COMMENT '开票记录金额',
`invoice_price` decimal(19,2) DEFAULT NULL COMMENT '已开票金额',
`can_invoice_amount` decimal(18,2) NOT NULL DEFAULT '0.00' COMMENT '可开票金额',
`apply_invoice_amount` decimal(18,2) NOT NULL DEFAULT '0.00' COMMENT '申请开票金额',
`tax_amount` decimal(18,2) DEFAULT NULL COMMENT '税额',
`tax_rate` decimal(18,2) DEFAULT NULL COMMENT '税率',
`tax_code_id` bigint DEFAULT NULL COMMENT '税率id',
`unit_price` decimal(18,2) NOT NULL DEFAULT '0.00' COMMENT '单价',
`total` int DEFAULT NULL COMMENT '数量',
`tax_cost_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '商品或服务名称',
`specs` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '规格',
`invoice_unit` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '单位',
`buyer_bank` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '购方开户行',
`invoice_code` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '发票代码',
`buyer_tax_number` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '购方税号',
`buyer_phone` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '购方电话',
`buyer_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '购方地址',
`remark` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '备注',
`nopay_tax_price` decimal(19,2) DEFAULT NULL COMMENT '未交税金额',
`tax_price_amount` decimal(19,2) DEFAULT NULL COMMENT '价税合计',
`saler_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '售方名称',
`saler_account` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '售方开户行账号',
`saler_bank` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '售方银行',
`saler_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '售方地址',
`saler_phone` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '售方电话',
`saler_tax_number` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '售方税号(纳税人识别号)',
`extra_time` timestamp NULL DEFAULT NULL COMMENT '作废/红冲日期',
`invoice_type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '开票类型;1=增值税普通发票;2=增值税专用发票;3=增值税电子普通发票;',
`task_key` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '开票批次凭证',
`group_key` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '分组批次凭证',
`issue_type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '操作开票类型;1=提前开票;2=实收开票',
`red_invoice_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '冲红发票号码',
`red_invoice_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '冲红发票代码',
`red_invoice_time` datetime DEFAULT NULL COMMENT '冲红发票开具时间',
`can_e_invoice` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0' COMMENT '是否需要开具电子发票 1需要 0不需要',
`e_invoice_status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0' COMMENT '电子发票开具状态 0未开票 1开票成功 2开票中 3开票失败',
`e_invoice_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '电子发票订单ID',
`e_invoice_link` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '电子发票链接',
`e_invoice_error` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '开具电子发票失败原因',
`red_e_invoice_status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0' COMMENT '冲红电子发票开具状态 0未开票 1开票成功 2开票中 3开票失败',
`red_e_invoice_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '冲红电子发票订单ID',
`red_e_invoice_link` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '冲红电子发票链接',
`red_e_invoice_error` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '冲红电子发票失败原因',
`service` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'org' COMMENT '服务名称',
`invoice_check_email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '邮箱【电子发票开具成功后发送邮件到邮箱】',
`invoice_item_tax` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '0' COMMENT '是否含税(0：是，1：否)',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='机构账单开票记录表';
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
# 2.管理后台
对应 [资产管理系统 -> 财务 -> 发票记录] 菜单，对应 xhrt-admin 项目的 @/views/bus/bill/invoiceList 目录
# 账单收据
账单收据记录，由 OrgBillReceiptController 提供接口。
# 1.表结构
省略 creator/create_time/updater/update_time/deleted/tenant_id 等通用字段
CREATE TABLE `org_bill_receipt` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT '编号',
`tenant_id` bigint DEFAULT NULL COMMENT '机构ID',
`village_id` bigint DEFAULT NULL COMMENT '项目id',
`build_id` bigint DEFAULT NULL COMMENT '楼宇id',
`bill_id` bigint DEFAULT NULL COMMENT '账单id',
`subbill_id` bigint DEFAULT NULL COMMENT '子账单ID',
`rule_id` bigint DEFAULT NULL COMMENT '账单收据编号规则id',
`room_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '房号',
`payment_company_id` bigint DEFAULT NULL COMMENT '交款公司/单位id',
`payment_company` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '交款单位',
`payment_uname` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '交款人',
`payment_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '交款方地址',
`payment_phone` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '交款方电话',
`receipt_number` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '收据编号',
`receipt_int` int DEFAULT NULL COMMENT '编号数值',
`number_type` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '1' COMMENT '生成编号方式;1=规则生成;2=自定义',
`price` decimal(19,2) DEFAULT NULL COMMENT '收据金额',
`can_receipt_amount` decimal(19,2) NOT NULL DEFAULT '0.00' COMMENT '可开据金额',
`apply_receipt_amount` decimal(19,2) NOT NULL DEFAULT '0.00' COMMENT '申请开据金额',
`currency` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '币种',
`status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '收据状态;1=已发出;2=已回收;3=新建待审批;4=作废待审批;5=已作废;6=未发出;',
`payment_uid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '交款人uid',
`collection_company_id` bigint DEFAULT NULL COMMENT '收款公司/单位id',
`collection_company` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '收款单位',
`collection_uid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '收款人uid',
`collection_uname` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '收款方收款人',
`collection_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '收款方地址',
`collection_phone` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '收款方电话',
`remark` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '备注',
`remit_type` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '汇款方式',
`cost_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '费用类型',
`cost_name` varchar(155) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '费用名称',
`task_key` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '开据批次凭证',
`group_key` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '开据分组凭证',
`issuer_uid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '开据人',
`issuer_time` date DEFAULT NULL COMMENT '开据时间',
`apply_template_id` bigint DEFAULT NULL COMMENT '收据当前应用模板id',
`apply_template` json DEFAULT NULL COMMENT '收据当前应用模板生成数据',
`receopt_file_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '生成收据url',
`apply_status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0' COMMENT '发票生成状态;0=未生成 1=生成中 2=已生成',
PRIMARY KEY (`id`) USING BTREE,
KEY `idx_org_id` (`tenant_id`) USING BTREE,
KEY `idx_currency` (`currency`) USING BTREE,
KEY `idx_status` (`status`) USING BTREE,
KEY `idx_collection_company` (`collection_company`) USING BTREE,
KEY `idx_receipt_number` (`receipt_number`) USING BTREE,
KEY `idx_cost_type` (`cost_type`) USING BTREE,
KEY `idx_payment_uid` (`payment_uid`) USING BTREE,
KEY `idx_collection_uid` (`collection_uid`) USING BTREE,
KEY `idx_issuer_uid` (`issuer_uid`) USING BTREE,
KEY `idx_issuer_time` (`issuer_time`) USING BTREE,
KEY `idx_payment_company_id` (`payment_company_id`) USING BTREE,
KEY `payment_company` (`payment_company`) USING BTREE,
KEY `idx_collection_company_id` (`collection_company_id`) USING BTREE,
KEY `idx_bill_id` (`bill_id`) USING BTREE,
KEY `idx_village_id` (`village_id`) USING BTREE,
KEY `idx_build_id` (`build_id`) USING BTREE,
KEY `idx_rule_id` (`rule_id`) USING BTREE,
KEY `idx_number_type` (`number_type`) USING BTREE,
KEY `idx_task_key` (`task_key`) USING BTREE,
KEY `idx_group_key` (`group_key`) USING BTREE,
KEY `index_template_id` (`apply_template_id`) USING BTREE,
KEY `idx_apply_status` (`apply_status`) USING BTREE,
KEY `idx_subbill_id` (`subbill_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='机构账单收据表';
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
# 2.管理后台
对应 [资产管理系统 -> 财务 -> 收据] 菜单，对应 xhrt-admin 项目的 @/views/bus/bill/receipt 目录
