master

分支 (1)

管理

管理

master

PSI
/
doc
/
99 SQL
/
11SLN0002_CodeTable.sql

# @author PSI
# @copyright 2015 - present
# @license GPL v3

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

# SLN0002 - 财务总账 - 码表

# ------------------------------------------------------------------------------
# 码表分类
# ------------------------------------------------------------------------------
DELETE FROM t_code_table_category where id = '1BEE661C-5100-11EE-89B4-E86A641ED142';
INSERT INTO t_code_table_category(id, code, name, parent_id, is_system, sln_code)
VALUES ('1BEE661C-5100-11EE-89B4-E86A641ED142', 'SLN0002.01', '银行', NULL, 1, 'SLN0002');

# 凭证
DELETE FROM t_code_table_category where id = '86544F8D-851C-11EF-8872-E86A641ED142';
INSERT INTO t_code_table_category(id, code, name, parent_id, is_system, sln_code)
VALUES ('86544F8D-851C-11EF-8872-E86A641ED142', 'SLN0002.02', '记账凭证', NULL, 1, 'SLN0002');

# 固定资产
DELETE FROM t_code_table_category where id = '25DE3EBB-B63D-11F0-93C7-E86A641ED142';
INSERT INTO t_code_table_category(id, code, name, parent_id, is_system, sln_code)
VALUES ('25DE3EBB-B63D-11F0-93C7-E86A641ED142', 'SLN0002.03', '固定资产', NULL, 1, 'SLN0002');

# ------------------------------------------------------------------------------
# 码表：凭证字
# 元数据
# ------------------------------------------------------------------------------
DELETE FROM `t_code_table_md` where `id` = '551ED336-851F-11EF-8872-E86A641ED142';
INSERT INTO `t_code_table_md` (`id`, `code`, `name`, `table_name`, `category_id`, `memo`, `py`, `fid`, `md_version`, `is_fixed`, `enable_parent_id`, `handler_class_name`, `module_name`, `edit_col_cnt`, `view_paging`, `input_company`, `sln_code`, `module_description`)
VALUES ('551ED336-851F-11EF-8872-E86A641ED142', 'SLN0002.02.01', '凭证字', 't_sln0002_ct_voucher_word', '86544F8D-851C-11EF-8872-E86A641ED142', '', 'PZZ', 'ct20241008104509', 1, 1, 0, '', '凭证字', 1, 2, 2, 'SLN0002', '');

DELETE FROM `t_code_table_cols_md` where `table_id` = '551ED336-851F-11EF-8872-E86A641ED142';
INSERT INTO `t_code_table_cols_md` (`id`, `table_id`, `caption`, `db_field_name`, `db_field_type`, `db_field_length`, `db_field_decimal`, `show_order`, `value_from`, `value_from_table_name`, `value_from_col_name`, `value_from_col_name_display`, `must_input`, `sys_col`, `is_visible`, `width_in_view`, `note`, `show_order_in_view`, `editor_xtype`, `col_span`, `default_value`, `default_value_ext`, `label_width`) VALUES
('551EF11A-851F-11EF-8872-E86A641ED142', '551ED336-851F-11EF-8872-E86A641ED142', 'id', 'id', 'varchar', 255, 0, -1000, 99, '', '', '', 1, 1, 2, 0, '', -1000, 'textfield', 1, 100, '', 90),
('551F0370-851F-11EF-8872-E86A641ED142', '551ED336-851F-11EF-8872-E86A641ED142', '编码', 'code', 'varchar', 255, 0, 0, 1, '', '', '', 2, 1, 1, 120, '', 0, 'textfield', 1, 100, '', 40),
('551F1339-851F-11EF-8872-E86A641ED142', '551ED336-851F-11EF-8872-E86A641ED142', '名称', 'name', 'varchar', 255, 0, 1, 1, '', '', '', 2, 1, 1, 200, '', 1, 'textfield', 1, 100, '', 40),
('551F2413-851F-11EF-8872-E86A641ED142', '551ED336-851F-11EF-8872-E86A641ED142', '助记码', 'py', 'varchar', 255, 0, -900, 99, '', '', '', 1, 1, 2, 200, '', 4, 'textfield', 1, 100, '', 90),
('551F337A-851F-11EF-8872-E86A641ED142', '551ED336-851F-11EF-8872-E86A641ED142', '数据域', 'data_org', 'varchar', 255, 0, -800, 99, '', '', '', 1, 1, 2, 150, '', 3, 'textfield', 1, 100, '', 90),
('551F43D8-851F-11EF-8872-E86A641ED142', '551ED336-851F-11EF-8872-E86A641ED142', '公司', 'company_id', 'varchar', 255, 0, -700, 99, '', '', '', 1, 1, 2, 0, '', -1000, 'textfield', 1, 100, '', 90),
('551F53F7-851F-11EF-8872-E86A641ED142', '551ED336-851F-11EF-8872-E86A641ED142', '记录创建时间', 'date_created', 'datetime', 0, 0, -699, 99, '', '', '', 1, 1, 2, 0, '', -1000, 'textfield', 1, 100, '', 90),
('551F64B4-851F-11EF-8872-E86A641ED142', '551ED336-851F-11EF-8872-E86A641ED142', '记录创建人', 'create_user_id', 'varchar', 255, 0, -698, 99, '', '', '', 1, 1, 2, 0, '', -1000, 'textfield', 1, 100, '', 90),
('551F7486-851F-11EF-8872-E86A641ED142', '551ED336-851F-11EF-8872-E86A641ED142', '最后编辑时间', 'update_dt', 'datetime', 0, 0, -697, 99, '', '', '', 1, 1, 2, 0, '', -1000, 'textfield', 1, 100, '', 90),
('551F82C2-851F-11EF-8872-E86A641ED142', '551ED336-851F-11EF-8872-E86A641ED142', '最后编辑人', 'update_user_id', 'varchar', 255, 0, -696, 99, '', '', '', 1, 1, 2, 0, '', -1000, 'textfield', 1, 100, '', 90),
('551F939C-851F-11EF-8872-E86A641ED142', '551ED336-851F-11EF-8872-E86A641ED142', '状态', 'record_status', 'int', 11, 0, 2, 2, 't_sysdict_sln0000_ct_record_status', 'code_int', 'name', 2, 1, 1, 80, '', 2, 'psi_sysdictfield', 1, 200, '1000', 40);

DELETE FROM `t_code_table_buttons` where `table_id` = '551ED336-851F-11EF-8872-E86A641ED142';
INSERT INTO `t_code_table_buttons` (`id`, `table_id`, `caption`, `fid`, `on_click_frontend`, `on_click_backend`, `show_order`) VALUES
('551FD85B-851F-11EF-8872-E86A641ED142', '551ED336-851F-11EF-8872-E86A641ED142', '新建凭证字', 'ct20241008104509-add', '_onAddCodeTableRecord', '', 1),
('552011FD-851F-11EF-8872-E86A641ED142', '551ED336-851F-11EF-8872-E86A641ED142', '编辑凭证字', 'ct20241008104509-update', '_onEditCodeTableRecord', '', 2),
('55202873-851F-11EF-8872-E86A641ED142', '551ED336-851F-11EF-8872-E86A641ED142', '删除凭证字', 'ct20241008104509-delete', '_onDeleteCodeTableRecord', '', 3),
('5520408D-851F-11EF-8872-E86A641ED142', '551ED336-851F-11EF-8872-E86A641ED142', '-', 'ct20241008104509', '', '', 4),
('55204DCC-851F-11EF-8872-E86A641ED142', '551ED336-851F-11EF-8872-E86A641ED142', '导出Excel', 'ct20241008104509-excel', '_onExcelCodeTableRecord', '', 5),
('552064F9-851F-11EF-8872-E86A641ED142', '551ED336-851F-11EF-8872-E86A641ED142', '-', 'ct20241008104509', '', '', 6),
('552072BC-851F-11EF-8872-E86A641ED142', '551ED336-851F-11EF-8872-E86A641ED142', '刷新', 'ct20241008104509', '_onRefreshCodeTableRecord', '', 7);

DELETE FROM `t_fid_plus` where `fid` = 'ct20241008104509';
INSERT INTO `t_fid_plus` (`fid`, `name`, `py`, `memo`, `sln_code`) VALUES
('ct20241008104509', '凭证字', 'PZZ', '', 'SLN0002');

DELETE FROM `t_permission_plus` where fid = 'ct20241008104509' or parent_fid = 'ct20241008104509';
INSERT INTO `t_permission_plus` (`id`, `fid`, `name`, `note`, `category`, `py`, `show_order`, `parent_fid`) VALUES
('ct20241008104509', 'ct20241008104509', '凭证字 - 模块权限', '通过菜单进入凭证字模块的权限', '凭证字', 'PZZ', 100, null),
('ct20241008104509-add', 'ct20241008104509-add', '凭证字 - 按钮权限 - 新建凭证字', '凭证字模块中按钮[新建凭证字]的启用权限', '凭证字', '', 201, 'ct20241008104509'),
('ct20241008104509-update', 'ct20241008104509-update', '凭证字 - 按钮权限 - 编辑凭证字', '凭证字模块中按钮[编辑凭证字]的启用权限', '凭证字', '', 202, 'ct20241008104509'),
('ct20241008104509-delete', 'ct20241008104509-delete', '凭证字 - 按钮权限 - 删除凭证字', '凭证字模块中按钮[删除凭证字]的启用权限', '凭证字', '', 203, 'ct20241008104509'),
('ct20241008104509-excel', 'ct20241008104509-excel', '凭证字 - 按钮权限 - 导出Excel', '凭证字模块中按钮[导出Excel]的启用权限', '凭证字', '', 205, 'ct20241008104509'),
('ct20241008104509-edit-dataorg', 'ct20241008104509-edit-dataorg', '凭证字 - 按钮权限 - 修改数据域', '凭证字模块中按钮[修改数据域]的启用权限', '凭证字', '', 208, 'ct20241008104509'),
('ct20241008104509-edit-py', 'ct20241008104509-edit-py', '凭证字 - 按钮权限 - 修改助记码', '凭证字模块中按钮[修改助记码]的启用权限', '凭证字', '', 209, 'ct20241008104509'),
('ct20241008104509-dataorg', 'ct20241008104509-dataorg', '凭证字 - 数据域权限 - 凭证字在业务单据中的使用权限', '凭证字在业务单据中的使用权限', '凭证字', '', 300, 'ct20241008104509');

# 凭证字 - 菜单项
DELETE FROM t_menu_item_plus where id = '7BFE527C-851F-11EF-8872-E86A641ED142';
INSERT INTO t_menu_item_plus(id, caption, fid, parent_id, show_order, py, memo, sys_category)
VALUES ('7BFE527C-851F-11EF-8872-E86A641ED142', '凭证字', 'ct20241008104509', '1101', 1000, 'PZZ', '', 1);

# ------------------------------------------------------------------------------
# 码表：凭证字
# CREATE DDL
# ------------------------------------------------------------------------------
CREATE TABLE IF NOT EXISTS `t_sln0002_ct_voucher_word` (
  `id` varchar(255)  NOT NULL,
  `py` varchar(255)  NOT NULL,
  `data_org` varchar(255)  NOT NULL,
  `company_id` varchar(255)  NOT NULL,
  `date_created` datetime  NOT NULL,
  `create_user_id` varchar(255)  NOT NULL,
  `update_dt` datetime  DEFAULT NULL,
  `update_user_id` varchar(255)  DEFAULT NULL,
  `code` varchar(255)  NOT NULL,
  `name` varchar(255)  NOT NULL,
  `record_status` int(11)  NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

# ------------------------------------------------------------------------------
# 码表：银行账户
# 元数据
# ------------------------------------------------------------------------------
DELETE FROM `t_code_table_md` where `id` = 'C56D627F-B768-11EF-81D4-E86A641ED142';
INSERT INTO `t_code_table_md` (`id`, `code`, `name`, `table_name`, `category_id`, `memo`, `py`, `fid`, `md_version`, `is_fixed`, `enable_parent_id`, `handler_class_name`, `module_name`, `edit_col_cnt`, `view_paging`, `input_company`, `sln_code`, `module_description`)
VALUES ('C56D627F-B768-11EF-81D4-E86A641ED142', 'SLN0002.01.01', '银行账户', 't_sln0002_ct_bank', '1BEE661C-5100-11EE-89B4-E86A641ED142', '', 'YHZH', 'ct20241211103648', 3, 1, 0, '\\SLN0002\\Plugin\\Bank\\BankAccountBLL', '银行账户', 2, 2, 2, 'SLN0002', '');

DELETE FROM `t_code_table_cols_md` where `table_id` = 'C56D627F-B768-11EF-81D4-E86A641ED142';
INSERT INTO `t_code_table_cols_md` (`id`, `table_id`, `caption`, `db_field_name`, `db_field_type`, `db_field_length`, `db_field_decimal`, `show_order`, `value_from`, `value_from_table_name`, `value_from_col_name`, `value_from_col_name_display`, `must_input`, `sys_col`, `is_visible`, `width_in_view`, `note`, `show_order_in_view`, `editor_xtype`, `col_span`, `default_value`, `default_value_ext`, `label_width`) VALUES
('431FDD71-B824-11EF-B8E7-E86A641ED142', 'C56D627F-B768-11EF-81D4-E86A641ED142', '开设日期', 'input_dt', 'datetime', 0, 0, 4, 1, '', '', '', 2, 2, 1, 120, '', 5, 'datefield', 1, 100, '', 70),
('6BC72DA7-B824-11EF-B8E7-E86A641ED142', 'C56D627F-B768-11EF-81D4-E86A641ED142', '银行营业机构', 'bank_name', 'varchar', 255, 0, 1, 1, '', '', '', 2, 2, 1, 292, '', 3, 'textfield', 1, 100, '', 100),
('7CC6745E-B823-11EF-B8E7-E86A641ED142', 'C56D627F-B768-11EF-81D4-E86A641ED142', '账户类型', 'category_id', 'varchar', 255, 0, 0, 2, 't_sysdict_sln0002_bank_account_category', 'code', 'name', 2, 2, 1, 120, '', 2, 'textfield', 1, 100, '', 70),
('C56D8814-B768-11EF-81D4-E86A641ED142', 'C56D627F-B768-11EF-81D4-E86A641ED142', 'id', 'id', 'varchar', 255, 0, -1000, 99, '', '', '', 1, 1, 2, 0, '', -1000, 'textfield', 1, 100, '', 90),
('C56D9D44-B768-11EF-81D4-E86A641ED142', 'C56D627F-B768-11EF-81D4-E86A641ED142', '编码', 'code', 'varchar', 255, 0, 2, 1, '', '', '', 2, 1, 1, 120, '', 1, 'textfield', 1, 100, '', 70),
('C56DB09C-B768-11EF-81D4-E86A641ED142', 'C56D627F-B768-11EF-81D4-E86A641ED142', '账号', 'name', 'varchar', 255, 0, 3, 1, '', '', '', 2, 1, 1, 259, '', 4, 'textfield', 1, 100, '', 100),
('C56DC407-B768-11EF-81D4-E86A641ED142', 'C56D627F-B768-11EF-81D4-E86A641ED142', '助记码', 'py', 'varchar', 255, 0, -900, 99, '', '', '', 1, 1, 2, 200, '', 8, 'textfield', 1, 100, '', 90),
('C56DD758-B768-11EF-81D4-E86A641ED142', 'C56D627F-B768-11EF-81D4-E86A641ED142', '数据域', 'data_org', 'varchar', 255, 0, -800, 99, '', '', '', 1, 1, 2, 150, '', 7, 'textfield', 1, 100, '', 90),
('C56DEB00-B768-11EF-81D4-E86A641ED142', 'C56D627F-B768-11EF-81D4-E86A641ED142', '公司', 'company_id', 'varchar', 255, 0, -700, 99, '', '', '', 1, 1, 2, 0, '', -1000, 'textfield', 1, 100, '', 90),
('C56DFE56-B768-11EF-81D4-E86A641ED142', 'C56D627F-B768-11EF-81D4-E86A641ED142', '记录创建时间', 'date_created', 'datetime', 0, 0, -699, 99, '', '', '', 1, 1, 2, 0, '', -1000, 'textfield', 1, 100, '', 90),
('C56E11AF-B768-11EF-81D4-E86A641ED142', 'C56D627F-B768-11EF-81D4-E86A641ED142', '记录创建人', 'create_user_id', 'varchar', 255, 0, -698, 99, '', '', '', 1, 1, 2, 0, '', -1000, 'textfield', 1, 100, '', 90),
('C56E254E-B768-11EF-81D4-E86A641ED142', 'C56D627F-B768-11EF-81D4-E86A641ED142', '最后编辑时间', 'update_dt', 'datetime', 0, 0, -697, 99, '', '', '', 1, 1, 2, 0, '', -1000, 'textfield', 1, 100, '', 90),
('C56E37EF-B768-11EF-81D4-E86A641ED142', 'C56D627F-B768-11EF-81D4-E86A641ED142', '最后编辑人', 'update_user_id', 'varchar', 255, 0, -696, 99, '', '', '', 1, 1, 2, 0, '', -1000, 'textfield', 1, 100, '', 90),
('C56E4932-B768-11EF-81D4-E86A641ED142', 'C56D627F-B768-11EF-81D4-E86A641ED142', '状态', 'record_status', 'int', 11, 0, 5, 2, 't_sysdict_sln0000_ct_record_status', 'code_int', 'name', 2, 1, 1, 80, '', 6, 'psi_sysdictfield', 1, 200, '1000', 100);

DELETE FROM `t_code_table_buttons` where `table_id` = 'C56D627F-B768-11EF-81D4-E86A641ED142';
INSERT INTO `t_code_table_buttons` (`id`, `table_id`, `caption`, `fid`, `on_click_frontend`, `on_click_backend`, `show_order`) VALUES
('C56E692F-B768-11EF-81D4-E86A641ED142', 'C56D627F-B768-11EF-81D4-E86A641ED142', '新建银行账户', 'ct20241211103648-add', '_onAddCodeTableRecord', '', 1),
('C56EA4FD-B768-11EF-81D4-E86A641ED142', 'C56D627F-B768-11EF-81D4-E86A641ED142', '编辑银行账户', 'ct20241211103648-update', '_onEditCodeTableRecord', '', 2),
('C56EBBAB-B768-11EF-81D4-E86A641ED142', 'C56D627F-B768-11EF-81D4-E86A641ED142', '删除银行账户', 'ct20241211103648-delete', '_onDeleteCodeTableRecord', '', 3),
('C56ED26C-B768-11EF-81D4-E86A641ED142', 'C56D627F-B768-11EF-81D4-E86A641ED142', '-', 'ct20241211103648', '', '', 4),
('C56EE0EB-B768-11EF-81D4-E86A641ED142', 'C56D627F-B768-11EF-81D4-E86A641ED142', '导出Excel', 'ct20241211103648-excel', '_onExcelCodeTableRecord', '', 5),
('C56EF774-B768-11EF-81D4-E86A641ED142', 'C56D627F-B768-11EF-81D4-E86A641ED142', '-', 'ct20241211103648', '', '', 6),
('C56F07F9-B768-11EF-81D4-E86A641ED142', 'C56D627F-B768-11EF-81D4-E86A641ED142', '刷新', 'ct20241211103648', '_onRefreshCodeTableRecord', '', 7);

DELETE FROM `t_fid_plus` where `fid` = 'ct20241211103648';
INSERT INTO `t_fid_plus` (`fid`, `name`, `py`, `memo`, `sln_code`) VALUES
('ct20241211103648', '银行账户', 'YHZH', '', 'SLN0002');

DELETE FROM `t_permission_plus` where fid = 'ct20241211103648' or parent_fid = 'ct20241211103648';
INSERT INTO `t_permission_plus` (`id`, `fid`, `name`, `note`, `category`, `py`, `show_order`, `parent_fid`) VALUES
('ct20241211103648', 'ct20241211103648', '银行账户 - 模块权限', '通过菜单进入银行账户模块的权限', '银行账户', 'YHZH', 100, null),
('ct20241211103648-add', 'ct20241211103648-add', '银行账户 - 按钮权限 - 新建银行账户', '银行账户模块中按钮[新建银行账户]的启用权限', '银行账户', '', 201, 'ct20241211103648'),
('ct20241211103648-update', 'ct20241211103648-update', '银行账户 - 按钮权限 - 编辑银行账户', '银行账户模块中按钮[编辑银行账户]的启用权限', '银行账户', '', 202, 'ct20241211103648'),
('ct20241211103648-delete', 'ct20241211103648-delete', '银行账户 - 按钮权限 - 删除银行账户', '银行账户模块中按钮[删除银行账户]的启用权限', '银行账户', '', 203, 'ct20241211103648'),
('ct20241211103648-excel', 'ct20241211103648-excel', '银行账户 - 按钮权限 - 导出Excel', '银行账户模块中按钮[导出Excel]的启用权限', '银行账户', '', 205, 'ct20241211103648'),
('ct20241211103648-edit-dataorg', 'ct20241211103648-edit-dataorg', '银行账户 - 按钮权限 - 修改数据域', '银行账户模块中按钮[修改数据域]的启用权限', '银行账户', '', 208, 'ct20241211103648'),
('ct20241211103648-edit-py', 'ct20241211103648-edit-py', '银行账户 - 按钮权限 - 修改助记码', '银行账户模块中按钮[修改助记码]的启用权限', '银行账户', '', 209, 'ct20241211103648'),
('ct20241211103648-dataorg', 'ct20241211103648-dataorg', '银行账户 - 数据域权限 - 银行账户在业务单据中的使用权限', '银行账户在业务单据中的使用权限', '银行账户', '', 300, 'ct20241211103648');

# ------------------------------------------------------------------------------
# 码表：银行账户
# CREATE DDL
# ------------------------------------------------------------------------------
CREATE TABLE IF NOT EXISTS `t_sln0002_ct_bank` (
  `id` varchar(255)  NOT NULL,
  `py` varchar(255)  NOT NULL,
  `data_org` varchar(255)  NOT NULL,
  `company_id` varchar(255)  NOT NULL,
  `date_created` datetime  NOT NULL,
  `create_user_id` varchar(255)  NOT NULL,
  `update_dt` datetime  DEFAULT NULL,
  `update_user_id` varchar(255)  DEFAULT NULL,
  `category_id` varchar(255)  DEFAULT NULL,
  `code` varchar(255)  NOT NULL,
  `bank_name` varchar(255)  DEFAULT NULL,
  `name` varchar(255)  NOT NULL,
  `input_dt` datetime  DEFAULT NULL,
  `record_status` int(11)  NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

# 银行账户 - 菜单项
DELETE FROM t_menu_item_plus where id = '7D1145E4-B769-11EF-81D4-E86A641ED142';
INSERT INTO t_menu_item_plus(id, caption, fid, parent_id, show_order, py, memo, sys_category)
VALUES ('7D1145E4-B769-11EF-81D4-E86A641ED142', '银行账户', 'ct20241211103648', '1101', 2, 'YHZH', '', 1);

# ------------------------------------------------------------------------------
# 码表：销售费用项
# 元数据
# ------------------------------------------------------------------------------
DELETE FROM `t_code_table_md` where `id` = '14D43F43-B574-11F0-8959-E86A641ED142';
INSERT INTO `t_code_table_md` (`id`, `code`, `name`, `table_name`, `category_id`, `memo`, `py`, `fid`, `md_version`, `is_fixed`, `enable_parent_id`, `handler_class_name`, `module_name`, `edit_col_cnt`, `view_paging`, `input_company`, `sln_code`, `module_description`)
VALUES ('14D43F43-B574-11F0-8959-E86A641ED142', 'SLN0002.02.02', '销售费用项', 't_sln0002_ct_expenses_sales', '86544F8D-851C-11EF-8872-E86A641ED142', '', 'QJFY', 'ct20251030173741', 2, 1, 0, '', '销售费用项', 1, 2, 1, 'SLN0002', '');

DELETE FROM `t_code_table_cols_md` where `table_id` = '14D43F43-B574-11F0-8959-E86A641ED142';
INSERT INTO `t_code_table_cols_md` (`id`, `table_id`, `caption`, `db_field_name`, `db_field_type`, `db_field_length`, `db_field_decimal`, `show_order`, `value_from`, `value_from_table_name`, `value_from_col_name`, `value_from_col_name_display`, `must_input`, `sys_col`, `is_visible`, `width_in_view`, `note`, `show_order_in_view`, `editor_xtype`, `col_span`, `default_value`, `default_value_ext`, `label_width`) VALUES
('14D45F07-B574-11F0-8959-E86A641ED142', '14D43F43-B574-11F0-8959-E86A641ED142', 'id', 'id', 'varchar', 255, 0, -1000, 99, '', '', '', 1, 1, 2, 0, '', -1000, 'textfield', 1, 100, '', 90),
('14D47322-B574-11F0-8959-E86A641ED142', '14D43F43-B574-11F0-8959-E86A641ED142', '编码', 'code', 'varchar', 255, 0, 0, 1, '', '', '', 2, 1, 1, 120, '', 0, 'textfield', 1, 100, '', 40),
('14D48614-B574-11F0-8959-E86A641ED142', '14D43F43-B574-11F0-8959-E86A641ED142', '名称', 'name', 'varchar', 255, 0, 1, 1, '', '', '', 2, 1, 1, 200, '', 1, 'textfield', 1, 100, '', 40),
('14D4992A-B574-11F0-8959-E86A641ED142', '14D43F43-B574-11F0-8959-E86A641ED142', '助记码', 'py', 'varchar', 255, 0, -900, 99, '', '', '', 1, 1, 2, 200, '', 4, 'textfield', 1, 100, '', 90),
('14D4AC81-B574-11F0-8959-E86A641ED142', '14D43F43-B574-11F0-8959-E86A641ED142', '数据域', 'data_org', 'varchar', 255, 0, -800, 99, '', '', '', 1, 1, 2, 150, '', 3, 'textfield', 1, 100, '', 90),
('14D4BFD7-B574-11F0-8959-E86A641ED142', '14D43F43-B574-11F0-8959-E86A641ED142', '公司', 'company_id', 'varchar', 255, 0, -700, 99, '', '', '', 1, 1, 2, 0, '', -1000, 'textfield', 1, 100, '', 90),
('14D4D30A-B574-11F0-8959-E86A641ED142', '14D43F43-B574-11F0-8959-E86A641ED142', '记录创建时间', 'date_created', 'datetime', 0, 0, -699, 99, '', '', '', 1, 1, 2, 0, '', -1000, 'textfield', 1, 100, '', 90),
('14D4E4E5-B574-11F0-8959-E86A641ED142', '14D43F43-B574-11F0-8959-E86A641ED142', '记录创建人', 'create_user_id', 'varchar', 255, 0, -698, 99, '', '', '', 1, 1, 2, 0, '', -1000, 'textfield', 1, 100, '', 90),
('14D4F701-B574-11F0-8959-E86A641ED142', '14D43F43-B574-11F0-8959-E86A641ED142', '最后编辑时间', 'update_dt', 'datetime', 0, 0, -697, 99, '', '', '', 1, 1, 2, 0, '', -1000, 'textfield', 1, 100, '', 90),
('14D5075F-B574-11F0-8959-E86A641ED142', '14D43F43-B574-11F0-8959-E86A641ED142', '最后编辑人', 'update_user_id', 'varchar', 255, 0, -696, 99, '', '', '', 1, 1, 2, 0, '', -1000, 'textfield', 1, 100, '', 90),
('14D516D8-B574-11F0-8959-E86A641ED142', '14D43F43-B574-11F0-8959-E86A641ED142', '状态', 'record_status', 'int', 11, 0, 2, 2, 't_sysdict_sln0000_ct_record_status', 'code_int', 'name', 2, 1, 1, 80, '', 2, 'psi_sysdictfield', 1, 200, '1000', 40);

DELETE FROM `t_code_table_buttons` where `table_id` = '14D43F43-B574-11F0-8959-E86A641ED142';
INSERT INTO `t_code_table_buttons` (`id`, `table_id`, `caption`, `fid`, `on_click_frontend`, `on_click_backend`, `show_order`) VALUES
('14D53675-B574-11F0-8959-E86A641ED142', '14D43F43-B574-11F0-8959-E86A641ED142', '新建销售费用项', 'ct20251030173741-add', '_onAddCodeTableRecord', '', 1),
('14D55E06-B574-11F0-8959-E86A641ED142', '14D43F43-B574-11F0-8959-E86A641ED142', '编辑销售费用项', 'ct20251030173741-update', '_onEditCodeTableRecord', '', 2),
('14D574A3-B574-11F0-8959-E86A641ED142', '14D43F43-B574-11F0-8959-E86A641ED142', '删除销售费用项', 'ct20251030173741-delete', '_onDeleteCodeTableRecord', '', 3),
('14D58B35-B574-11F0-8959-E86A641ED142', '14D43F43-B574-11F0-8959-E86A641ED142', '-', 'ct20251030173741', '', '', 4),
('14D59A51-B574-11F0-8959-E86A641ED142', '14D43F43-B574-11F0-8959-E86A641ED142', '导出Excel ', 'ct20251030173741-excel', '_onExcelCodeTableRecord', '', 5),
('14D5B21F-B574-11F0-8959-E86A641ED142', '14D43F43-B574-11F0-8959-E86A641ED142', '-', 'ct20251030173741', '', '', 6),
('14D5C30F-B574-11F0-8959-E86A641ED142', '14D43F43-B574-11F0-8959-E86A641ED142', '刷新', 'ct20251030173741', '_onRefreshCodeTableRecord', '', 7);

DELETE FROM `t_fid_plus` where `fid` = 'ct20251030173741';
INSERT INTO `t_fid_plus` (`fid`, `name`, `py`, `memo`, `sln_code`) VALUES
('ct20251030173741', '销售费用项', 'XSFYXM', '', 'SLN0002');

DELETE FROM `t_permission_plus` where fid = 'ct20251030173741' or parent_fid = 'ct20251030173741';
INSERT INTO `t_permission_plus` (`id`, `fid`, `name`, `note`, `category`, `py`, `show_order`, `parent_fid`) VALUES
('ct20251030173741', 'ct20251030173741', '销售费用项 - 模块权限', '通过菜单进入销售费用项模块的权限', '销售费用项', 'XSFYXM', 100, null),
('ct20251030173741-add', 'ct20251030173741-add', '销售费用项 - 按钮权限 - 新建销售费用项', '销售费用项模块中按钮[新建销售费用项]的启用权限', '销售费用项', '', 201, 'ct20251030173741'),
('ct20251030173741-update', 'ct20251030173741-update', '销售费用项 - 按钮权限 - 编辑销售费用项', '销售费用项模块中按钮[编辑销售费用项]的启用权限', '销售费用项', '', 202, 'ct20251030173741'),
('ct20251030173741-delete', 'ct20251030173741-delete', '销售费用项 - 按钮权限 - 删除销售费用项', '销售费用项模块中按钮[删除销售费用项]的启用权限', '销售费用项', '', 203, 'ct20251030173741'),
('ct20251030173741-excel', 'ct20251030173741-excel', '销售费用项 - 按钮权限 - 导出Excel ', '销售费用项模块中按钮[导出Excel ]的启用权限', '销售费用项', '', 205, 'ct20251030173741'),
('ct20251030173741-edit-dataorg', 'ct20251030173741-edit-dataorg', '销售费用项 - 按钮权限 - 修改数据域', '销售费用项模块中按钮[修改数据域]的启用权限', '销售费用项', '', 208, 'ct20251030173741'),
('ct20251030173741-edit-py', 'ct20251030173741-edit-py', '销售费用项 - 按钮权限 - 修改助记码', '销售费用项模块中按钮[修改助记码]的启用权限', '销售费用项', '', 209, 'ct20251030173741'),
('ct20251030173741-dataorg', 'ct20251030173741-dataorg', '销售费用项 - 数据域权限 - 销售费用项在业务单据中的使用权限', '销售费用项在业务单据中的使用权限', '销售费用项', '', 300, 'ct20251030173741');

# ------------------------------------------------------------------------------
# 码表：销售费用项
# CREATE DDL
# ------------------------------------------------------------------------------
CREATE TABLE IF NOT EXISTS `t_sln0002_ct_expenses_sales` (
  `id` varchar(255)  NOT NULL,
  `py` varchar(255)  NOT NULL,
  `data_org` varchar(255)  NOT NULL,
  `company_id` varchar(255)  NOT NULL,
  `date_created` datetime  NOT NULL,
  `create_user_id` varchar(255)  NOT NULL,
  `update_dt` datetime  DEFAULT NULL,
  `update_user_id` varchar(255)  DEFAULT NULL,
  `code` varchar(255)  NOT NULL,
  `name` varchar(255)  NOT NULL,
  `record_status` int(11)  NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

# 销售费用项 - 菜单项
DELETE FROM t_menu_item_plus where id = '4AE57A7C-B575-11F0-8959-E86A641ED142';
INSERT INTO t_menu_item_plus(id, caption, fid, parent_id, show_order, py, memo, sys_category)
VALUES ('4AE57A7C-B575-11F0-8959-E86A641ED142', '销售费用项', 'ct20251030173741', '1101', 1001, 'XSFYXM', '', 1);

# 销售费用项 - 默认数据
TRUNCATE TABLE `t_sln0002_ct_expenses_sales`;
INSERT INTO `t_sln0002_ct_expenses_sales`(id, code, name, py, data_org, company_id, date_created, create_user_id, record_status)
VALUES
('BE5853EF-B585-11F0-B0A9-E86A641ED142', '01', '职工薪酬', 'ZGXC', '01010001', '4D74E1E4-A129-11E4-9B6A-782BCBD7746B', now(), '6C2A09CD-A129-11E4-9B6A-782BCBD7746B', 1000),
('E1392ED6-B585-11F0-B0A9-E86A641ED142', '02', '劳务费', 'LWF', '01010001', '4D74E1E4-A129-11E4-9B6A-782BCBD7746B', now(), '6C2A09CD-A129-11E4-9B6A-782BCBD7746B', 1000),
('2F9F35CE-B586-11F0-B0A9-E86A641ED142', '03', '咨询顾问费', 'ZXGWF', '01010001', '4D74E1E4-A129-11E4-9B6A-782BCBD7746B', now(), '6C2A09CD-A129-11E4-9B6A-782BCBD7746B', 1000),
('39E318AE-B586-11F0-B0A9-E86A641ED142', '04', '业务招待费', 'YWZDF', '01010001', '4D74E1E4-A129-11E4-9B6A-782BCBD7746B', now(), '6C2A09CD-A129-11E4-9B6A-782BCBD7746B', 1000),
('702170B9-B586-11F0-B0A9-E86A641ED142', '05', '广告费和业务宣传费', 'GGFHYWXCF', '01010001', '4D74E1E4-A129-11E4-9B6A-782BCBD7746B', now(), '6C2A09CD-A129-11E4-9B6A-782BCBD7746B', 1000),
('7BEF7631-B586-11F0-B0A9-E86A641ED142', '06', '佣金和手续费', 'YJHSXF', '01010001', '4D74E1E4-A129-11E4-9B6A-782BCBD7746B', now(), '6C2A09CD-A129-11E4-9B6A-782BCBD7746B', 1000),
('8693CC41-B586-11F0-B0A9-E86A641ED142', '07', '资产折旧摊销费', 'ZCZJTXF', '01010001', '4D74E1E4-A129-11E4-9B6A-782BCBD7746B', now(), '6C2A09CD-A129-11E4-9B6A-782BCBD7746B', 1000),
('B89A869A-B586-11F0-B0A9-E86A641ED142', '08', '财产损耗、盘亏及毁损损失', 'CCSHPKJHSSS', '01010001', '4D74E1E4-A129-11E4-9B6A-782BCBD7746B', now(), '6C2A09CD-A129-11E4-9B6A-782BCBD7746B', 1000),
('C2042F11-B586-11F0-B0A9-E86A641ED142', '09', '办公费', 'BGF', '01010001', '4D74E1E4-A129-11E4-9B6A-782BCBD7746B', now(), '6C2A09CD-A129-11E4-9B6A-782BCBD7746B', 1000),
('CC24E518-B586-11F0-B0A9-E86A641ED142', '10', '董事会费', 'DSHF', '01010001', '4D74E1E4-A129-11E4-9B6A-782BCBD7746B', now(), '6C2A09CD-A129-11E4-9B6A-782BCBD7746B', 1000),
('D528BE3F-B586-11F0-B0A9-E86A641ED142', '11', '租赁费', 'ZLF', '01010001', '4D74E1E4-A129-11E4-9B6A-782BCBD7746B', now(), '6C2A09CD-A129-11E4-9B6A-782BCBD7746B', 1000),
('E0F57ACA-B586-11F0-B0A9-E86A641ED142', '12', '诉讼费', 'SSF', '01010001', '4D74E1E4-A129-11E4-9B6A-782BCBD7746B', now(), '6C2A09CD-A129-11E4-9B6A-782BCBD7746B', 1000),
('EA4EDC42-B586-11F0-B0A9-E86A641ED142', '13', '差旅费', 'CLF', '01010001', '4D74E1E4-A129-11E4-9B6A-782BCBD7746B', now(), '6C2A09CD-A129-11E4-9B6A-782BCBD7746B', 1000),
('7CC1C5A7-B587-11F0-B0A9-E86A641ED142', '14', '保险费', 'BXF', '01010001', '4D74E1E4-A129-11E4-9B6A-782BCBD7746B', now(), '6C2A09CD-A129-11E4-9B6A-782BCBD7746B', 1000),
('85AD24C4-B587-11F0-B0A9-E86A641ED142', '15', '运输、仓储费', 'YSCCF', '01010001', '4D74E1E4-A129-11E4-9B6A-782BCBD7746B', now(), '6C2A09CD-A129-11E4-9B6A-782BCBD7746B', 1000),
('92823716-B587-11F0-B0A9-E86A641ED142', '16', '修理费', 'XLF', '01010001', '4D74E1E4-A129-11E4-9B6A-782BCBD7746B', now(), '6C2A09CD-A129-11E4-9B6A-782BCBD7746B', 1000),
('9AC75517-B587-11F0-B0A9-E86A641ED142', '17', '包装费', 'BZF', '01010001', '4D74E1E4-A129-11E4-9B6A-782BCBD7746B', now(), '6C2A09CD-A129-11E4-9B6A-782BCBD7746B', 1000),
('A29DB3C1-B587-11F0-B0A9-E86A641ED142', '18', '技术转让费', 'JSZRF', '01010001', '4D74E1E4-A129-11E4-9B6A-782BCBD7746B', now(), '6C2A09CD-A129-11E4-9B6A-782BCBD7746B', 1000),
('AA89C838-B587-11F0-B0A9-E86A641ED142', '19', '研究费用', 'YJFY', '01010001', '4D74E1E4-A129-11E4-9B6A-782BCBD7746B', now(), '6C2A09CD-A129-11E4-9B6A-782BCBD7746B', 1000),
('B2DADF81-B587-11F0-B0A9-E86A641ED142', '20', '各项税费', 'GXSF', '01010001', '4D74E1E4-A129-11E4-9B6A-782BCBD7746B', now(), '6C2A09CD-A129-11E4-9B6A-782BCBD7746B', 1000),
('BC3002F8-B587-11F0-B0A9-E86A641ED142', '99', '其他', 'QT', '01010001', '4D74E1E4-A129-11E4-9B6A-782BCBD7746B', now(), '6C2A09CD-A129-11E4-9B6A-782BCBD7746B', 1000)
;

# ------------------------------------------------------------------------------
# 码表：管理费用项
# 元数据
# ------------------------------------------------------------------------------
DELETE FROM `t_code_table_md` where `id` = '8C22C348-B576-11F0-8959-E86A641ED142';
INSERT INTO `t_code_table_md` (`id`, `code`, `name`, `table_name`, `category_id`, `memo`, `py`, `fid`, `md_version`, `is_fixed`, `enable_parent_id`, `handler_class_name`, `module_name`, `edit_col_cnt`, `view_paging`, `input_company`, `sln_code`, `module_description`)
VALUES ('8C22C348-B576-11F0-8959-E86A641ED142', 'SLN0002.02.03', '管理费用项', 't_sln0002_ct_expenses_mgt', '86544F8D-851C-11EF-8872-E86A641ED142', '', 'GLFYXM', 'ct20251030175521', 1, 2, 0, '', '管理费用项', 1, 2, 1, 'SLN0002', '');

DELETE FROM `t_code_table_cols_md` where `table_id` = '8C22C348-B576-11F0-8959-E86A641ED142';
INSERT INTO `t_code_table_cols_md` (`id`, `table_id`, `caption`, `db_field_name`, `db_field_type`, `db_field_length`, `db_field_decimal`, `show_order`, `value_from`, `value_from_table_name`, `value_from_col_name`, `value_from_col_name_display`, `must_input`, `sys_col`, `is_visible`, `width_in_view`, `note`, `show_order_in_view`, `editor_xtype`, `col_span`, `default_value`, `default_value_ext`, `label_width`) VALUES
('8C22E8D6-B576-11F0-8959-E86A641ED142', '8C22C348-B576-11F0-8959-E86A641ED142', 'id', 'id', 'varchar', 255, 0, -1000, 99, '', '', '', 1, 1, 2, 0, '', -1000, 'textfield', 1, 100, '', 90),
('8C230092-B576-11F0-8959-E86A641ED142', '8C22C348-B576-11F0-8959-E86A641ED142', '编码', 'code', 'varchar', 255, 0, 0, 1, '', '', '', 2, 1, 1, 120, '', 0, 'textfield', 1, 100, '', 40),
('8C23130B-B576-11F0-8959-E86A641ED142', '8C22C348-B576-11F0-8959-E86A641ED142', '名称', 'name', 'varchar', 255, 0, 1, 1, '', '', '', 2, 1, 1, 200, '', 1, 'textfield', 1, 100, '', 40),
('8C2325D0-B576-11F0-8959-E86A641ED142', '8C22C348-B576-11F0-8959-E86A641ED142', '助记码', 'py', 'varchar', 255, 0, -900, 99, '', '', '', 1, 1, 2, 200, '', 4, 'textfield', 1, 100, '', 90),
('8C23384F-B576-11F0-8959-E86A641ED142', '8C22C348-B576-11F0-8959-E86A641ED142', '数据域', 'data_org', 'varchar', 255, 0, -800, 99, '', '', '', 1, 1, 2, 150, '', 3, 'textfield', 1, 100, '', 90),
('8C234BE6-B576-11F0-8959-E86A641ED142', '8C22C348-B576-11F0-8959-E86A641ED142', '公司', 'company_id', 'varchar', 255, 0, -700, 99, '', '', '', 1, 1, 2, 0, '', -1000, 'textfield', 1, 100, '', 90),
('8C23C14B-B576-11F0-8959-E86A641ED142', '8C22C348-B576-11F0-8959-E86A641ED142', '记录创建时间', 'date_created', 'datetime', 0, 0, -699, 99, '', '', '', 1, 1, 2, 0, '', -1000, 'textfield', 1, 100, '', 90),
('8C23DA8B-B576-11F0-8959-E86A641ED142', '8C22C348-B576-11F0-8959-E86A641ED142', '记录创建人', 'create_user_id', 'varchar', 255, 0, -698, 99, '', '', '', 1, 1, 2, 0, '', -1000, 'textfield', 1, 100, '', 90),
('8C23ED66-B576-11F0-8959-E86A641ED142', '8C22C348-B576-11F0-8959-E86A641ED142', '最后编辑时间', 'update_dt', 'datetime', 0, 0, -697, 99, '', '', '', 1, 1, 2, 0, '', -1000, 'textfield', 1, 100, '', 90),
('8C23FFE1-B576-11F0-8959-E86A641ED142', '8C22C348-B576-11F0-8959-E86A641ED142', '最后编辑人', 'update_user_id', 'varchar', 255, 0, -696, 99, '', '', '', 1, 1, 2, 0, '', -1000, 'textfield', 1, 100, '', 90),
('8C2441F8-B576-11F0-8959-E86A641ED142', '8C22C348-B576-11F0-8959-E86A641ED142', '状态', 'record_status', 'int', 11, 0, 2, 2, 't_sysdict_sln0000_ct_record_status', 'code_int', 'name', 2, 1, 1, 80, '', 2, 'psi_sysdictfield', 1, 200, '1000', 40);

DELETE FROM `t_code_table_buttons` where `table_id` = '8C22C348-B576-11F0-8959-E86A641ED142';
INSERT INTO `t_code_table_buttons` (`id`, `table_id`, `caption`, `fid`, `on_click_frontend`, `on_click_backend`, `show_order`) VALUES
('8C246F93-B576-11F0-8959-E86A641ED142', '8C22C348-B576-11F0-8959-E86A641ED142', '新建管理费用项', 'ct20251030175521-add', '_onAddCodeTableRecord', '', 1),
('8C248C1C-B576-11F0-8959-E86A641ED142', '8C22C348-B576-11F0-8959-E86A641ED142', '编辑管理费用项', 'ct20251030175521-update', '_onEditCodeTableRecord', '', 2),
('8C24A792-B576-11F0-8959-E86A641ED142', '8C22C348-B576-11F0-8959-E86A641ED142', '删除管理费用项', 'ct20251030175521-delete', '_onDeleteCodeTableRecord', '', 3),
('8C24C137-B576-11F0-8959-E86A641ED142', '8C22C348-B576-11F0-8959-E86A641ED142', '-', 'ct20251030175521', '', '', 4),
('8C24D1F9-B576-11F0-8959-E86A641ED142', '8C22C348-B576-11F0-8959-E86A641ED142', '导出Excel', 'ct20251030175521-excel', '_onExcelCodeTableRecord', '', 5),
('8C24EB90-B576-11F0-8959-E86A641ED142', '8C22C348-B576-11F0-8959-E86A641ED142', '-', 'ct20251030175521', '', '', 6),
('8C24FA92-B576-11F0-8959-E86A641ED142', '8C22C348-B576-11F0-8959-E86A641ED142', '刷新', 'ct20251030175521', '_onRefreshCodeTableRecord', '', 7);

DELETE FROM `t_fid_plus` where `fid` = 'ct20251030175521';
INSERT INTO `t_fid_plus` (`fid`, `name`, `py`, `memo`, `sln_code`) VALUES
('ct20251030175521', '管理费用项', 'GLFYXM', '', 'SLN0002');

DELETE FROM `t_permission_plus` where fid = 'ct20251030175521' or parent_fid = 'ct20251030175521';
INSERT INTO `t_permission_plus` (`id`, `fid`, `name`, `note`, `category`, `py`, `show_order`, `parent_fid`) VALUES
('ct20251030175521', 'ct20251030175521', '管理费用项 - 模块权限', '通过菜单进入管理费用项模块的权限', '管理费用项', 'GLFYXM', 100, null),
('ct20251030175521-add', 'ct20251030175521-add', '管理费用项 - 按钮权限 - 新建管理费用项', '管理费用项模块中按钮[新建管理费用项]的启用权限', '管理费用项', '', 201, 'ct20251030175521'),
('ct20251030175521-update', 'ct20251030175521-update', '管理费用项 - 按钮权限 - 编辑管理费用项', '管理费用项模块中按钮[编辑管理费用项]的启用权限', '管理费用项', '', 202, 'ct20251030175521'),
('ct20251030175521-delete', 'ct20251030175521-delete', '管理费用项 - 按钮权限 - 删除管理费用项', '管理费用项模块中按钮[删除管理费用项]的启用权限', '管理费用项', '', 203, 'ct20251030175521'),
('ct20251030175521-excel', 'ct20251030175521-excel', '管理费用项 - 按钮权限 - 导出Excel', '管理费用项模块中按钮[导出Excel]的启用权限', '管理费用项', '', 205, 'ct20251030175521'),
('ct20251030175521-edit-dataorg', 'ct20251030175521-edit-dataorg', '管理费用项 - 按钮权限 - 修改数据域', '管理费用项模块中按钮[修改数据域]的启用权限', '管理费用项', '', 208, 'ct20251030175521'),
('ct20251030175521-edit-py', 'ct20251030175521-edit-py', '管理费用项 - 按钮权限 - 修改助记码', '管理费用项模块中按钮[修改助记码]的启用权限', '管理费用项', '', 209, 'ct20251030175521'),
('ct20251030175521-dataorg', 'ct20251030175521-dataorg', '管理费用项 - 数据域权限 - 管理费用项在业务单据中的使用权限', '管理费用项在业务单据中的使用权限', '管理费用项', '', 300, 'ct20251030175521');

# ------------------------------------------------------------------------------
# 码表：管理费用项
# CREATE DDL
# ------------------------------------------------------------------------------
CREATE TABLE IF NOT EXISTS `t_sln0002_ct_expenses_mgt` (
  `id` varchar(255)  NOT NULL,
  `py` varchar(255)  NOT NULL,
  `data_org` varchar(255)  NOT NULL,
  `company_id` varchar(255)  NOT NULL,
  `date_created` datetime  NOT NULL,
  `create_user_id` varchar(255)  NOT NULL,
  `update_dt` datetime  DEFAULT NULL,
  `update_user_id` varchar(255)  DEFAULT NULL,
  `code` varchar(255)  NOT NULL,
  `name` varchar(255)  NOT NULL,
  `record_status` int(11)  NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

# 管理费用项 - 菜单项
DELETE FROM t_menu_item_plus where id = '12B16A6C-B577-11F0-8959-E86A641ED142';
INSERT INTO t_menu_item_plus(id, caption, fid, parent_id, show_order, py, memo, sys_category)
VALUES ('12B16A6C-B577-11F0-8959-E86A641ED142', '管理费用项', 'ct20251030175521', '1101', 1002, 'GLFYXM', '', 1);

# 销售费用项 - 默认数据
TRUNCATE TABLE `t_sln0002_ct_expenses_mgt`;
INSERT INTO `t_sln0002_ct_expenses_mgt`(id, code, name, py, data_org, company_id, date_created, create_user_id, record_status)
VALUES
('8E7EA088-B588-11F0-B0A9-E86A641ED142', '01', '职工薪酬', 'ZGXC', '01010001', '4D74E1E4-A129-11E4-9B6A-782BCBD7746B', now(), '6C2A09CD-A129-11E4-9B6A-782BCBD7746B', 1000),
('985F3354-B588-11F0-B0A9-E86A641ED142', '02', '劳务费', 'LWF', '01010001', '4D74E1E4-A129-11E4-9B6A-782BCBD7746B', now(), '6C2A09CD-A129-11E4-9B6A-782BCBD7746B', 1000),
('A1809623-B588-11F0-B0A9-E86A641ED142', '03', '咨询顾问费', 'ZXGWF', '01010001', '4D74E1E4-A129-11E4-9B6A-782BCBD7746B', now(), '6C2A09CD-A129-11E4-9B6A-782BCBD7746B', 1000),
('AC33661D-B588-11F0-B0A9-E86A641ED142', '04', '业务招待费', 'YWZDF', '01010001', '4D74E1E4-A129-11E4-9B6A-782BCBD7746B', now(), '6C2A09CD-A129-11E4-9B6A-782BCBD7746B', 1000),
('B7E3B258-B588-11F0-B0A9-E86A641ED142', '05', '广告费和业务宣传费', 'GGFHYWXCF', '01010001', '4D74E1E4-A129-11E4-9B6A-782BCBD7746B', now(), '6C2A09CD-A129-11E4-9B6A-782BCBD7746B', 1000),
('C3CAD152-B588-11F0-B0A9-E86A641ED142', '06', '佣金和手续费', 'YJHSXF', '01010001', '4D74E1E4-A129-11E4-9B6A-782BCBD7746B', now(), '6C2A09CD-A129-11E4-9B6A-782BCBD7746B', 1000),
('CD066B51-B588-11F0-B0A9-E86A641ED142', '07', '资产折旧摊销费', 'ZCZJTXF', '01010001', '4D74E1E4-A129-11E4-9B6A-782BCBD7746B', now(), '6C2A09CD-A129-11E4-9B6A-782BCBD7746B', 1000),
('D68634B6-B588-11F0-B0A9-E86A641ED142', '08', '财产损耗、盘亏及毁损损失', 'CCSHPKJHSSS', '01010001', '4D74E1E4-A129-11E4-9B6A-782BCBD7746B', now(), '6C2A09CD-A129-11E4-9B6A-782BCBD7746B', 1000),
('DFCC5E2A-B588-11F0-B0A9-E86A641ED142', '09', '办公费', 'BGF', '01010001', '4D74E1E4-A129-11E4-9B6A-782BCBD7746B', now(), '6C2A09CD-A129-11E4-9B6A-782BCBD7746B', 1000),
('E8B02C69-B588-11F0-B0A9-E86A641ED142', '10', '董事会费', 'DSHF', '01010001', '4D74E1E4-A129-11E4-9B6A-782BCBD7746B', now(), '6C2A09CD-A129-11E4-9B6A-782BCBD7746B', 1000),
('F33FB169-B588-11F0-B0A9-E86A641ED142', '11', '租赁费', 'ZLF', '01010001', '4D74E1E4-A129-11E4-9B6A-782BCBD7746B', now(), '6C2A09CD-A129-11E4-9B6A-782BCBD7746B', 1000),
('FD1A3969-B588-11F0-B0A9-E86A641ED142', '12', '诉讼费', 'SSF', '01010001', '4D74E1E4-A129-11E4-9B6A-782BCBD7746B', now(), '6C2A09CD-A129-11E4-9B6A-782BCBD7746B', 1000),
('06EC5A2F-B589-11F0-B0A9-E86A641ED142', '13', '差旅费', 'CLF', '01010001', '4D74E1E4-A129-11E4-9B6A-782BCBD7746B', now(), '6C2A09CD-A129-11E4-9B6A-782BCBD7746B', 1000),
('101B9AA2-B589-11F0-B0A9-E86A641ED142', '14', '保险费', 'BXF', '01010001', '4D74E1E4-A129-11E4-9B6A-782BCBD7746B', now(), '6C2A09CD-A129-11E4-9B6A-782BCBD7746B', 1000),
('1A8AB382-B589-11F0-B0A9-E86A641ED142', '15', '运输、仓储费', 'YSCCF', '01010001', '4D74E1E4-A129-11E4-9B6A-782BCBD7746B', now(), '6C2A09CD-A129-11E4-9B6A-782BCBD7746B', 1000),
('23826909-B589-11F0-B0A9-E86A641ED142', '16', '修理费', 'XLF', '01010001', '4D74E1E4-A129-11E4-9B6A-782BCBD7746B', now(), '6C2A09CD-A129-11E4-9B6A-782BCBD7746B', 1000),
('2DFDF8F4-B589-11F0-B0A9-E86A641ED142', '17', '包装费', 'BZF', '01010001', '4D74E1E4-A129-11E4-9B6A-782BCBD7746B', now(), '6C2A09CD-A129-11E4-9B6A-782BCBD7746B', 1000),
('3703F297-B589-11F0-B0A9-E86A641ED142', '18', '技术转让费', 'JSZRF', '01010001', '4D74E1E4-A129-11E4-9B6A-782BCBD7746B', now(), '6C2A09CD-A129-11E4-9B6A-782BCBD7746B', 1000),
('41B9CB09-B589-11F0-B0A9-E86A641ED142', '19', '研究费用', 'YJFY', '01010001', '4D74E1E4-A129-11E4-9B6A-782BCBD7746B', now(), '6C2A09CD-A129-11E4-9B6A-782BCBD7746B', 1000),
('4BE8E728-B589-11F0-B0A9-E86A641ED142', '20', '各项税费', 'GXSF', '01010001', '4D74E1E4-A129-11E4-9B6A-782BCBD7746B', now(), '6C2A09CD-A129-11E4-9B6A-782BCBD7746B', 1000),
('56C88942-B589-11F0-B0A9-E86A641ED142', '21', '党组织工作经费', 'DZZGZJF', '01010001', '4D74E1E4-A129-11E4-9B6A-782BCBD7746B', now(), '6C2A09CD-A129-11E4-9B6A-782BCBD7746B', 1000),
('629A33C8-B589-11F0-B0A9-E86A641ED142', '99', '其他', 'QT', '01010001', '4D74E1E4-A129-11E4-9B6A-782BCBD7746B', now(), '6C2A09CD-A129-11E4-9B6A-782BCBD7746B', 1000)
;

# ------------------------------------------------------------------------------
# 码表：财务费用项
# 元数据
# ------------------------------------------------------------------------------
DELETE FROM `t_code_table_md` where `id` = 'DDDC60EC-B577-11F0-8959-E86A641ED142';
INSERT INTO `t_code_table_md` (`id`, `code`, `name`, `table_name`, `category_id`, `memo`, `py`, `fid`, `md_version`, `is_fixed`, `enable_parent_id`, `handler_class_name`, `module_name`, `edit_col_cnt`, `view_paging`, `input_company`, `sln_code`, `module_description`)
VALUES ('DDDC60EC-B577-11F0-8959-E86A641ED142', 'SLN0002.02.04', '财务费用项', 't_sln0002_ct_expenses_fi', '86544F8D-851C-11EF-8872-E86A641ED142', '', 'CWFYXM', 'ct20251030180447', 1, 2, 0, '', '财务费用项', 1, 2, 1, 'SLN0002', '');

DELETE FROM `t_code_table_cols_md` where `table_id` = 'DDDC60EC-B577-11F0-8959-E86A641ED142';
INSERT INTO `t_code_table_cols_md` (`id`, `table_id`, `caption`, `db_field_name`, `db_field_type`, `db_field_length`, `db_field_decimal`, `show_order`, `value_from`, `value_from_table_name`, `value_from_col_name`, `value_from_col_name_display`, `must_input`, `sys_col`, `is_visible`, `width_in_view`, `note`, `show_order_in_view`, `editor_xtype`, `col_span`, `default_value`, `default_value_ext`, `label_width`) VALUES
('DDDC7FC1-B577-11F0-8959-E86A641ED142', 'DDDC60EC-B577-11F0-8959-E86A641ED142', 'id', 'id', 'varchar', 255, 0, -1000, 99, '', '', '', 1, 1, 2, 0, '', -1000, 'textfield', 1, 100, '', 90),
('DDDC93E1-B577-11F0-8959-E86A641ED142', 'DDDC60EC-B577-11F0-8959-E86A641ED142', '编码', 'code', 'varchar', 255, 0, 0, 1, '', '', '', 2, 1, 1, 120, '', 0, 'textfield', 1, 100, '', 40),
('DDDCA72D-B577-11F0-8959-E86A641ED142', 'DDDC60EC-B577-11F0-8959-E86A641ED142', '名称', 'name', 'varchar', 255, 0, 1, 1, '', '', '', 2, 1, 1, 200, '', 1, 'textfield', 1, 100, '', 40),
('DDDCBA52-B577-11F0-8959-E86A641ED142', 'DDDC60EC-B577-11F0-8959-E86A641ED142', '助记码', 'py', 'varchar', 255, 0, -900, 99, '', '', '', 1, 1, 2, 200, '', 4, 'textfield', 1, 100, '', 90),
('DDDCCD7F-B577-11F0-8959-E86A641ED142', 'DDDC60EC-B577-11F0-8959-E86A641ED142', '数据域', 'data_org', 'varchar', 255, 0, -800, 99, '', '', '', 1, 1, 2, 150, '', 3, 'textfield', 1, 100, '', 90),
('DDDCE0A5-B577-11F0-8959-E86A641ED142', 'DDDC60EC-B577-11F0-8959-E86A641ED142', '公司', 'company_id', 'varchar', 255, 0, -700, 99, '', '', '', 1, 1, 2, 0, '', -1000, 'textfield', 1, 100, '', 90),
('DDDCF3D7-B577-11F0-8959-E86A641ED142', 'DDDC60EC-B577-11F0-8959-E86A641ED142', '记录创建时间', 'date_created', 'datetime', 0, 0, -699, 99, '', '', '', 1, 1, 2, 0, '', -1000, 'textfield', 1, 100, '', 90),
('DDDD0714-B577-11F0-8959-E86A641ED142', 'DDDC60EC-B577-11F0-8959-E86A641ED142', '记录创建人', 'create_user_id', 'varchar', 255, 0, -698, 99, '', '', '', 1, 1, 2, 0, '', -1000, 'textfield', 1, 100, '', 90),
('DDDD1A78-B577-11F0-8959-E86A641ED142', 'DDDC60EC-B577-11F0-8959-E86A641ED142', '最后编辑时间', 'update_dt', 'datetime', 0, 0, -697, 99, '', '', '', 1, 1, 2, 0, '', -1000, 'textfield', 1, 100, '', 90),
('DDDD2AF9-B577-11F0-8959-E86A641ED142', 'DDDC60EC-B577-11F0-8959-E86A641ED142', '最后编辑人', 'update_user_id', 'varchar', 255, 0, -696, 99, '', '', '', 1, 1, 2, 0, '', -1000, 'textfield', 1, 100, '', 90),
('DDDD3ABD-B577-11F0-8959-E86A641ED142', 'DDDC60EC-B577-11F0-8959-E86A641ED142', '状态', 'record_status', 'int', 11, 0, 2, 2, 't_sysdict_sln0000_ct_record_status', 'code_int', 'name', 2, 1, 1, 80, '', 2, 'psi_sysdictfield', 1, 200, '1000', 40);

DELETE FROM `t_code_table_buttons` where `table_id` = 'DDDC60EC-B577-11F0-8959-E86A641ED142';
INSERT INTO `t_code_table_buttons` (`id`, `table_id`, `caption`, `fid`, `on_click_frontend`, `on_click_backend`, `show_order`) VALUES
('DDDD6C23-B577-11F0-8959-E86A641ED142', 'DDDC60EC-B577-11F0-8959-E86A641ED142', '新建财务费用项', 'ct20251030180447-add', '_onAddCodeTableRecord', '', 1),
('DDDD8442-B577-11F0-8959-E86A641ED142', 'DDDC60EC-B577-11F0-8959-E86A641ED142', '编辑财务费用项', 'ct20251030180447-update', '_onEditCodeTableRecord', '', 2),
('DDDD9B95-B577-11F0-8959-E86A641ED142', 'DDDC60EC-B577-11F0-8959-E86A641ED142', '删除财务费用项', 'ct20251030180447-delete', '_onDeleteCodeTableRecord', '', 3),
('DDDDB2B5-B577-11F0-8959-E86A641ED142', 'DDDC60EC-B577-11F0-8959-E86A641ED142', '-', 'ct20251030180447', '', '', 4),
('DDDDC19D-B577-11F0-8959-E86A641ED142', 'DDDC60EC-B577-11F0-8959-E86A641ED142', '导出Excel', 'ct20251030180447-excel', '_onExcelCodeTableRecord', '', 5),
('DDDDD83C-B577-11F0-8959-E86A641ED142', 'DDDC60EC-B577-11F0-8959-E86A641ED142', '-', 'ct20251030180447', '', '', 6),
('DDDDE6FD-B577-11F0-8959-E86A641ED142', 'DDDC60EC-B577-11F0-8959-E86A641ED142', '刷新', 'ct20251030180447', '_onRefreshCodeTableRecord', '', 7);

DELETE FROM `t_fid_plus` where `fid` = 'ct20251030180447';
INSERT INTO `t_fid_plus` (`fid`, `name`, `py`, `memo`, `sln_code`) VALUES
('ct20251030180447', '财务费用项', 'CWFYXM', '', 'SLN0002');

DELETE FROM `t_permission_plus` where fid = 'ct20251030180447' or parent_fid = 'ct20251030180447';
INSERT INTO `t_permission_plus` (`id`, `fid`, `name`, `note`, `category`, `py`, `show_order`, `parent_fid`) VALUES
('ct20251030180447', 'ct20251030180447', '财务费用项 - 模块权限', '通过菜单进入财务费用项模块的权限', '财务费用项', 'CWFYXM', 100, null),
('ct20251030180447-add', 'ct20251030180447-add', '财务费用项 - 按钮权限 - 新建财务费用项', '财务费用项模块中按钮[新建财务费用项]的启用权限', '财务费用项', '', 201, 'ct20251030180447'),
('ct20251030180447-update', 'ct20251030180447-update', '财务费用项 - 按钮权限 - 编辑财务费用项', '财务费用项模块中按钮[编辑财务费用项]的启用权限', '财务费用项', '', 202, 'ct20251030180447'),
('ct20251030180447-delete', 'ct20251030180447-delete', '财务费用项 - 按钮权限 - 删除财务费用项', '财务费用项模块中按钮[删除财务费用项]的启用权限', '财务费用项', '', 203, 'ct20251030180447'),
('ct20251030180447-excel', 'ct20251030180447-excel', '财务费用项 - 按钮权限 - 导出Excel', '财务费用项模块中按钮[导出Excel]的启用权限', '财务费用项', '', 205, 'ct20251030180447'),
('ct20251030180447-edit-dataorg', 'ct20251030180447-edit-dataorg', '财务费用项 - 按钮权限 - 修改数据域', '财务费用项模块中按钮[修改数据域]的启用权限', '财务费用项', '', 208, 'ct20251030180447'),
('ct20251030180447-edit-py', 'ct20251030180447-edit-py', '财务费用项 - 按钮权限 - 修改助记码', '财务费用项模块中按钮[修改助记码]的启用权限', '财务费用项', '', 209, 'ct20251030180447'),
('ct20251030180447-dataorg', 'ct20251030180447-dataorg', '财务费用项 - 数据域权限 - 财务费用项在业务单据中的使用权限', '财务费用项在业务单据中的使用权限', '财务费用项', '', 300, 'ct20251030180447');

# ------------------------------------------------------------------------------
# 码表：财务费用项
# CREATE DDL
# ------------------------------------------------------------------------------
CREATE TABLE IF NOT EXISTS `t_sln0002_ct_expenses_fi` (
  `id` varchar(255)  NOT NULL,
  `py` varchar(255)  NOT NULL,
  `data_org` varchar(255)  NOT NULL,
  `company_id` varchar(255)  NOT NULL,
  `date_created` datetime  NOT NULL,
  `create_user_id` varchar(255)  NOT NULL,
  `update_dt` datetime  DEFAULT NULL,
  `update_user_id` varchar(255)  DEFAULT NULL,
  `code` varchar(255)  NOT NULL,
  `name` varchar(255)  NOT NULL,
  `record_status` int(11)  NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

# 财务费用项 - 菜单项
DELETE FROM t_menu_item_plus where id = '3F31B622-B579-11F0-8959-E86A641ED142';
INSERT INTO t_menu_item_plus(id, caption, fid, parent_id, show_order, py, memo, sys_category)
VALUES ('3F31B622-B579-11F0-8959-E86A641ED142', '财务费用项', 'ct20251030180447', '1101', 1003, 'CWFYXM', '', 1);

# 财务费用项 - 默认数据
TRUNCATE TABLE `t_sln0002_ct_expenses_fi`;
INSERT INTO `t_sln0002_ct_expenses_fi`(id, code, name, py, data_org, company_id, date_created, create_user_id, record_status)
VALUES
('214E18EF-B58A-11F0-B0A9-E86A641ED142', '01', '利息收支', 'LXSZ', '01010001', '4D74E1E4-A129-11E4-9B6A-782BCBD7746B', now(), '6C2A09CD-A129-11E4-9B6A-782BCBD7746B', 1000),
('28E1C4B6-B58A-11F0-B0A9-E86A641ED142', '02', '汇兑差额', 'HDCE', '01010001', '4D74E1E4-A129-11E4-9B6A-782BCBD7746B', now(), '6C2A09CD-A129-11E4-9B6A-782BCBD7746B', 1000),
('3261160F-B58A-11F0-B0A9-E86A641ED142', '03', '现金折扣', 'XJZK', '01010001', '4D74E1E4-A129-11E4-9B6A-782BCBD7746B', now(), '6C2A09CD-A129-11E4-9B6A-782BCBD7746B', 1000),
('3CD010EB-B58A-11F0-B0A9-E86A641ED142', '99', '其他', 'QT', '01010001', '4D74E1E4-A129-11E4-9B6A-782BCBD7746B', now(), '6C2A09CD-A129-11E4-9B6A-782BCBD7746B', 1000)
;

# ------------------------------------------------------------------------------
# 码表：固定资产卡片
# 元数据
# ------------------------------------------------------------------------------
DELETE FROM `t_code_table_md` where `id` = '6699A45F-B63D-11F0-93C7-E86A641ED142';
INSERT INTO `t_code_table_md` (`id`, `code`, `name`, `table_name`, `category_id`, `memo`, `py`, `fid`, `md_version`, `is_fixed`, `enable_parent_id`, `handler_class_name`, `module_name`, `edit_col_cnt`, `view_paging`, `input_company`, `sln_code`, `module_description`)
VALUES ('6699A45F-B63D-11F0-93C7-E86A641ED142', 'SLN0002.03.01', '固定资产卡片', 't_sln0002_ct_fac', '25DE3EBB-B63D-11F0-93C7-E86A641ED142', '', 'GDZCKP', 'ct20251031173847', 1, 1, 0, '', '固定资产卡片', 2, 2, 2, 'SLN0002', '');

DELETE FROM `t_code_table_cols_md` where `table_id` = '6699A45F-B63D-11F0-93C7-E86A641ED142';
INSERT INTO `t_code_table_cols_md` (`id`, `table_id`, `caption`, `db_field_name`, `db_field_type`, `db_field_length`, `db_field_decimal`, `show_order`, `value_from`, `value_from_table_name`, `value_from_col_name`, `value_from_col_name_display`, `must_input`, `sys_col`, `is_visible`, `width_in_view`, `note`, `show_order_in_view`, `editor_xtype`, `col_span`, `default_value`, `default_value_ext`, `label_width`) VALUES
('3937D57F-B63E-11F0-93C7-E86A641ED142', '6699A45F-B63D-11F0-93C7-E86A641ED142', '原值(元)', 'in_money', 'decimal', 19, 2, 3, 1, '', '', '', 2, 2, 1, 120, '', 4, 'numberfield', 1, 100, '', 70),
('6699C2F5-B63D-11F0-93C7-E86A641ED142', '6699A45F-B63D-11F0-93C7-E86A641ED142', 'id', 'id', 'varchar', 255, 0, -1000, 99, '', '', '', 1, 1, 2, 0, '', -1000, 'textfield', 1, 100, '', 90),
('6699F84E-B63D-11F0-93C7-E86A641ED142', '6699A45F-B63D-11F0-93C7-E86A641ED142', '编码', 'code', 'varchar', 255, 0, 0, 1, '', '', '', 2, 1, 1, 120, '', 1, 'textfield', 1, 100, '', 70),
('669A0F07-B63D-11F0-93C7-E86A641ED142', '6699A45F-B63D-11F0-93C7-E86A641ED142', '名称', 'name', 'varchar', 255, 0, 1, 1, '', '', '', 2, 1, 1, 200, '', 2, 'textfield', 1, 100, '', 70),
('669AAC09-B63D-11F0-93C7-E86A641ED142', '6699A45F-B63D-11F0-93C7-E86A641ED142', '助记码', 'py', 'varchar', 255, 0, -900, 99, '', '', '', 1, 1, 2, 200, '', 8, 'textfield', 1, 100, '', 90),
('669AC640-B63D-11F0-93C7-E86A641ED142', '6699A45F-B63D-11F0-93C7-E86A641ED142', '数据域', 'data_org', 'varchar', 255, 0, -800, 99, '', '', '', 1, 1, 2, 150, '', 7, 'textfield', 1, 100, '', 90),
('669AEF25-B63D-11F0-93C7-E86A641ED142', '6699A45F-B63D-11F0-93C7-E86A641ED142', '公司', 'company_id', 'varchar', 255, 0, -700, 99, '', '', '', 1, 1, 2, 0, '', -1000, 'textfield', 1, 100, '', 90),
('669B0A3E-B63D-11F0-93C7-E86A641ED142', '6699A45F-B63D-11F0-93C7-E86A641ED142', '记录创建时间', 'date_created', 'datetime', 0, 0, -699, 99, '', '', '', 1, 1, 2, 0, '', -1000, 'textfield', 1, 100, '', 90),
('669B1ECA-B63D-11F0-93C7-E86A641ED142', '6699A45F-B63D-11F0-93C7-E86A641ED142', '记录创建人', 'create_user_id', 'varchar', 255, 0, -698, 99, '', '', '', 1, 1, 2, 0, '', -1000, 'textfield', 1, 100, '', 90),
('669B2FF3-B63D-11F0-93C7-E86A641ED142', '6699A45F-B63D-11F0-93C7-E86A641ED142', '最后编辑时间', 'update_dt', 'datetime', 0, 0, -697, 99, '', '', '', 1, 1, 2, 0, '', -1000, 'textfield', 1, 100, '', 90),
('669B40ED-B63D-11F0-93C7-E86A641ED142', '6699A45F-B63D-11F0-93C7-E86A641ED142', '最后编辑人', 'update_user_id', 'varchar', 255, 0, -696, 99, '', '', '', 1, 1, 2, 0, '', -1000, 'textfield', 1, 100, '', 90),
('669B520C-B63D-11F0-93C7-E86A641ED142', '6699A45F-B63D-11F0-93C7-E86A641ED142', '状态', 'record_status', 'int', 11, 0, 5, 2, 't_sysdict_sln0000_ct_record_status', 'code_int', 'name', 2, 1, 1, 80, '', 6, 'psi_sysdictfield', 1, 200, '1000', 70),
('9D1CDB00-B63D-11F0-93C7-E86A641ED142', '6699A45F-B63D-11F0-93C7-E86A641ED142', '购入日期', 'in_dt', 'datetime', 0, 0, 2, 1, '', '', '', 2, 2, 1, 120, '', 3, 'datefield', 1, 300, '$today', 70),
('9DC8AF41-B63E-11F0-93C7-E86A641ED142', '6699A45F-B63D-11F0-93C7-E86A641ED142', '现值(元)', 'current_money', 'decimal', 19, 2, 4, 1, '', '', '', 1, 2, 1, 120, '', 5, 'numberfield', 1, 100, '', 70);

DELETE FROM `t_code_table_buttons` where `table_id` = '6699A45F-B63D-11F0-93C7-E86A641ED142';
INSERT INTO `t_code_table_buttons` (`id`, `table_id`, `caption`, `fid`, `on_click_frontend`, `on_click_backend`, `show_order`) VALUES
('669B756E-B63D-11F0-93C7-E86A641ED142', '6699A45F-B63D-11F0-93C7-E86A641ED142', '新建固定资产卡片', 'ct20251031173847-add', '_onAddCodeTableRecord', '', 1),
('669C2016-B63D-11F0-93C7-E86A641ED142', '6699A45F-B63D-11F0-93C7-E86A641ED142', '编辑固定资产卡片', 'ct20251031173847-update', '_onEditCodeTableRecord', '', 2),
('669C39C8-B63D-11F0-93C7-E86A641ED142', '6699A45F-B63D-11F0-93C7-E86A641ED142', '删除固定资产卡片', 'ct20251031173847-delete', '_onDeleteCodeTableRecord', '', 3),
('669C50B0-B63D-11F0-93C7-E86A641ED142', '6699A45F-B63D-11F0-93C7-E86A641ED142', '-', 'ct20251031173847', '', '', 4),
('669C5F12-B63D-11F0-93C7-E86A641ED142', '6699A45F-B63D-11F0-93C7-E86A641ED142', '导出Excel', 'ct20251031173847-excel', '_onExcelCodeTableRecord', '', 5),
('669C74FA-B63D-11F0-93C7-E86A641ED142', '6699A45F-B63D-11F0-93C7-E86A641ED142', '-', 'ct20251031173847', '', '', 6),
('669C8372-B63D-11F0-93C7-E86A641ED142', '6699A45F-B63D-11F0-93C7-E86A641ED142', '刷新', 'ct20251031173847', '_onRefreshCodeTableRecord', '', 7);

DELETE FROM `t_fid_plus` where `fid` = 'ct20251031173847';
INSERT INTO `t_fid_plus` (`fid`, `name`, `py`, `memo`, `sln_code`) VALUES
('ct20251031173847', '固定资产卡片', 'GDZCKP', '', 'SLN0002');

DELETE FROM `t_permission_plus` where fid = 'ct20251031173847' or parent_fid = 'ct20251031173847';
INSERT INTO `t_permission_plus` (`id`, `fid`, `name`, `note`, `category`, `py`, `show_order`, `parent_fid`) VALUES
('ct20251031173847', 'ct20251031173847', '固定资产卡片 - 模块权限', '通过菜单进入固定资产卡片模块的权限', '固定资产卡片', 'GDZCKP', 100, null),
('ct20251031173847-add', 'ct20251031173847-add', '固定资产卡片 - 按钮权限 - 新建固定资产卡片', '固定资产卡片模块中按钮[新建固定资产卡片]的启用权限', '固定资产卡片', '', 201, 'ct20251031173847'),
('ct20251031173847-update', 'ct20251031173847-update', '固定资产卡片 - 按钮权限 - 编辑固定资产卡片', '固定资产卡片模块中按钮[编辑固定资产卡片]的启用权限', '固定资产卡片', '', 202, 'ct20251031173847'),
('ct20251031173847-delete', 'ct20251031173847-delete', '固定资产卡片 - 按钮权限 - 删除固定资产卡片', '固定资产卡片模块中按钮[删除固定资产卡片]的启用权限', '固定资产卡片', '', 203, 'ct20251031173847'),
('ct20251031173847-excel', 'ct20251031173847-excel', '固定资产卡片 - 按钮权限 - 导出Excel', '固定资产卡片模块中按钮[导出Excel]的启用权限', '固定资产卡片', '', 205, 'ct20251031173847'),
('ct20251031173847-edit-dataorg', 'ct20251031173847-edit-dataorg', '固定资产卡片 - 按钮权限 - 修改数据域', '固定资产卡片模块中按钮[修改数据域]的启用权限', '固定资产卡片', '', 208, 'ct20251031173847'),
('ct20251031173847-edit-py', 'ct20251031173847-edit-py', '固定资产卡片 - 按钮权限 - 修改助记码', '固定资产卡片模块中按钮[修改助记码]的启用权限', '固定资产卡片', '', 209, 'ct20251031173847'),
('ct20251031173847-dataorg', 'ct20251031173847-dataorg', '固定资产卡片 - 数据域权限 - 固定资产卡片在业务单据中的使用权限', '固定资产卡片在业务单据中的使用权限', '固定资产卡片', '', 300, 'ct20251031173847');

# ------------------------------------------------------------------------------
# 码表：固定资产卡片
# CREATE DDL
# ------------------------------------------------------------------------------
CREATE TABLE IF NOT EXISTS `t_sln0002_ct_fac` (
  `id` varchar(255)  NOT NULL,
  `py` varchar(255)  NOT NULL,
  `data_org` varchar(255)  NOT NULL,
  `company_id` varchar(255)  NOT NULL,
  `date_created` datetime  NOT NULL,
  `create_user_id` varchar(255)  NOT NULL,
  `update_dt` datetime  DEFAULT NULL,
  `update_user_id` varchar(255)  DEFAULT NULL,
  `code` varchar(255)  NOT NULL,
  `name` varchar(255)  NOT NULL,
  `in_dt` datetime  NOT NULL,
  `in_money` decimal(19, 2)  NOT NULL,
  `current_money` decimal(19, 2)  NOT NULL,
  `record_status` int(11)  NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

# 固定资产卡片 - 菜单项
DELETE FROM t_menu_item_plus where id = 'C35F0E8D-B63D-11F0-93C7-E86A641ED142';
INSERT INTO t_menu_item_plus(id, caption, fid, parent_id, show_order, py, memo, sys_category)
VALUES ('C35F0E8D-B63D-11F0-93C7-E86A641ED142', '固定资产卡片', 'ct20251031173847', '1101', 1004, 'GDZCKP', '', 1);

# -----------------------------------------------------------
# 默认角色的权限项
# 这段SQL放在最后执行
# -----------------------------------------------------------
TRUNCATE TABLE `t_role_permission`;
INSERT INTO `t_role_permission` (`role_id`, `permission_id`)
select 'A83F617E-A153-11E4-A9B8-782BCBD7746B' as role_id, fid as permission_id
from t_permission;
INSERT INTO `t_role_permission` (`role_id`, `permission_id`)
select 'A83F617E-A153-11E4-A9B8-782BCBD7746B' as role_id, fid as permission_id
from t_permission_plus;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;