Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
过滤实体表
账簿
账簿科目
银行
银行账户
银行类别
单据类型
交易类型
币种
组织
部门
费用项目
费用项目类型
项目
项目类型
客户分类
客户
供应商分类
供应商
用户
凭证类型
mysql> select id, displayName from md_entity where displayName in ("账簿",
-> "账簿科目",
-> "银行",
-> "银行账户",
-> "银行类别",
-> "单据类型",
-> "交易类型",
-> "币种",
-> "组织",
-> "部门",
-> "费用项目",
-> "费用项目类型",
-> "项目",
-> "项目类型",
-> "客户分类",
-> "客户",
-> "供应商分类",
-> "供应商",
-> "用户",
-> "凭证类型");
+--------------------------------------+--------------------+
| id | displayName |
+--------------------------------------+--------------------+
| G001ZM0000BASEDOCACCBOOK000000000000 | 账簿 |
| G001ZM0000BASEDOCACCSUBJECT000000000 | 账簿科目 |
| G001ZM0000BASEDOCBANK000000000000000 | 银行 |
| G001ZM0000BASEDOCBANKACCOUNT00000000 | 银行账户 |
| G001ZM0000BASEDOCBANKCLASS0000000000 | 银行类别 |
| G001ZM0000BASEDOCBILLTYPE00000000000 | 单据类型 |
| G001ZM0000BASEDOCCURRENCY00000000000 | 币种 |
| G001ZM0000BASEDOCDEPT000000000000000 | 部门 |
| G001ZM0000BASEDOCFEEITEM000000000000 | 费用项目 |
| G001ZM0000BASEDOCFEEITEMCLASS0000000 | 费用项目类型 |
| G001ZM0000BASEDOCORG0000000000000000 | 组织 |
| G001ZM0000BASEDOCPROJECT000000000000 | 项目 |
| G001ZM0000BASEDOCPROJECTCLASS0000000 | 项目类型 |
| G001ZM0000BASEDOCTRADER0001000000000 | 供应商 |
| G001ZM0000BASEDOCTRADER0040000000000 | 客户 |
| G001ZM0000BASEDOCTRADERCLASS10000000 | 客户分类 |
| G001ZM0000BASEDOCTRADERCLASS20000000 | 供应商分类 |
| G001ZM0000BASEDOCTRADETYPE0000000000 | 交易类型 |
| G001ZM0000BASEDOCUSER000000000000000 | 用户 |
| G001ZM0000BASEDOCVOUCHERTYPE00000000 | 凭证类型 |
+--------------------------------------+--------------------+
20 rows in set (0.01 sec)
sed 's/.*/"&",/' filtered_entity_list.txt
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment