添加报表单一客户对账单2号模板,导出Excel有备注。
字段库更新
REPLACE INTO
t_affair_system_column(
column_id,
column_pid,
group_id,
column_order,
column_title,
column_name,
column_unit,
column_type,
column_control,
column_rule,
column_is_virtual,
column_unit_symbiosis,
column_detachable,
column_branch_calculation,
status) VALUES (447, 0, 9, 19, '说明', 'public_explain', '[]', '{\"key\":\"string\",\"value\":\"500\"}', 1, '', 0, '', 0, NULL, NULL);
REPLACE INTO
t_affair_system_column(
column_id,
column_pid,
group_id,
column_order,
column_title,
column_name,
column_unit,
column_type,
column_control,
column_rule,
column_is_virtual,
column_unit_symbiosis,
column_detachable,
column_branch_calculation,
status) VALUES (448, 0, 9, 20, '描述', 'public_describe', '[]', '{\"key\":\"string\",\"value\":\"500\"}', 1, '', 0, '', 0, NULL, NULL);
REPLACE INTO
t_affair_system_column(
column_id,
column_pid,
group_id,
column_order,
column_title,
column_name,
column_unit,
column_type,
column_control,
column_rule,
column_is_virtual,
column_unit_symbiosis,
column_detachable,
column_branch_calculation,
status) VALUES (449, 0, 9, 21, '其他', 'public_other', '[]', '{\"key\":\"string\",\"value\":\"500\"}', 1, '', 0, '', 0, NULL, NULL);
同步代码
如需要单一客户对账单2号模板,需报表授权salesStatement2
,然后初始化报表。