常量
12114常量总览
_constant结构
CREATE TABLE `_constant` (`id` int(11) NOT NULL AUTO_INCREMENT,`constantKey` varchar(255) DEFAULT NULL,`constantType` varchar(255) DEFAULT NULL COMMENT '常量类型; object, array',`desc` varchar(255) DEFAULT NULL COMMENT '描述',`constantValue` text COMMENT '常量内容; object, array',`operation` varchar(255) DEFAULT 'insert' COMMENT '操作; insert, update, jhInsert, jhUpdate, jhDelete jhRestore',`operationByUserId` varchar(255) DEFAULT NULL COMMENT '操作者userId',`operationByUser` varchar(255) DEFAULT NULL COMMENT '操作者用户名',`operationAt` varchar(255) DEFAULT NULL COMMENT '操作时间; E.g: 2021-05-28T10:24:54+08:00 ',PRIMARY KEY (`id`) USING BTREE) ENGINE = InnoDB AUTO_INCREMENT = 4 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '常量表; 软删除未启用;'
_constant 表数据
薪资项
constantKey：salaryOption
constantType：array
[{"optionId": "1161","code": 10,"parentCode": 0,"name": "基本工资","remarks": null,"isFixed": 0,"isPlus": 1,"isTax": 1,"isShow": 1,"isCompute": 1,"isOpen": 1},{"optionId": "1165","code": 20,"parentCode": 0,"name": "津补贴","remarks": "企业给员工提供的福利","isFixed": 0,"isPlus": 1,"isTax": 1,"isShow": 1,"isCompute": 1,"isOpen": 1},{"optionId": "1170","code": 30,"parentCode": 0,"name": "浮动工资","remarks": "浮动工资需要在每月算薪前手工录入","isFixed": 0,"isPlus": 1,"isTax": 1,"isShow": 1,"isCompute": 1,"isOpen": 1},{"optionId": "1172","code": 40,"parentCode": 0,"name": "奖金","remarks": null,"isFixed": 0,"isPlus": 1,"isTax": 1,"isShow": 1,"isCompute": 1,"isOpen": 1},{"optionId": "1176","code": 50,"parentCode": 0,"name": "提成工资","remarks": null,"isFixed": 0,"isPlus": 1,"isTax": 1,"isShow": 1,"isCompute": 1,"isOpen": 1},{"optionId": "1178","code": 60,"parentCode": 0,"name": "计件工资","remarks": null,"isFixed": 0,"isPlus": 1,"isTax": 1,"isShow": 1,"isCompute": 1,"isOpen": 1},{"optionId": "1180","code": 70,"parentCode": 0,"name": "计时工资","remarks": null,"isFixed": 0,"isPlus": 1,"isTax": 1,"isShow": 1,"isCompute": 1,"isOpen": 1},{"optionId": "1182","code": 80,"parentCode": 0,"name": "工龄/司龄工资","remarks": null,"isFixed": 0,"isPlus": 1,"isTax": 1,"isShow": 1,"isCompute": 1,"isOpen": 1},{"optionId": "1185","code": 90,"parentCode": 0,"name": "职称工资","remarks": null,"isFixed": 0,"isPlus": 1,"isTax": 1,"isShow": 1,"isCompute": 1,"isOpen": 1},{"optionId": "1189","code": 100,"parentCode": 0,"name": "代扣代缴","remarks": "公司代替个人缴纳的费用，如个人社保、个人公积金。该类别下的薪酬项，将从应纳税所得额中扣除，影响个税计算","isFixed": 0,"isPlus": 0,"isTax": 1,"isShow": 1,"isCompute": 1,"isOpen": 1},{"optionId": "1192","code": 110,"parentCode": 0,"name": "企业社保","remarks": "该类别下的薪酬项，不参与工资计算，只参与企业成本统计或社保成本分析","isFixed": 0,"isPlus": 1,"isTax": 0,"isShow": 1,"isCompute": 0,"isOpen": 1},{"optionId": "1194","code": 120,"parentCode": 0,"name": "企业公积金","remarks": "该类别下的薪酬项，不参与工资计算，只参与企业成本统计或社保成本分析","isFixed": 0,"isPlus": 1,"isTax": 0,"isShow": 1,"isCompute": 0,"isOpen": 1},{"optionId": "1196","code": 130,"parentCode": 0,"name": "税前补发","remarks": "税前补发，与该月的工资一起发放，需参与计税","isFixed": 0,"isPlus": 1,"isTax": 0,"isShow": 1,"isCompute": 1,"isOpen": 1},{"optionId": "1198","code": 140,"parentCode": 0,"name": "税前补扣","remarks": "税前从该月的工资中补扣的金额，会影响本月的应税工资总额","isFixed": 0,"isPlus": 0,"isTax": 0,"isShow": 1,"isCompute": 1,"isOpen": 1},{"optionId": "1200","code": 150,"parentCode": 0,"name": "税后补发","remarks": "税后补发，不参与该月工资计算，会影响当月的实际所得","isFixed": 0,"isPlus": 1,"isTax": 0,"isShow": 1,"isCompute": 1,"isOpen": 1},{"optionId": "1202","code": 160,"parentCode": 0,"name": "税后补扣","remarks": "从税后的工资中补扣的款项，不参与该月的工资计税","isFixed": 0,"isPlus": 0,"isTax": 0,"isShow": 1,"isCompute": 1,"isOpen": 1},{"optionId": "1206","code": 170,"parentCode": 0,"name": "特殊计税项","remarks": "其它里的科目不参与工资计算，但要计税","isFixed": 0,"isPlus": 1,"isTax": 1,"isShow": 1,"isCompute": 1,"isOpen": 1},{"optionId": "1208","code": 180,"parentCode": 0,"name": "加班工资","remarks": "公司按员工加班时长计算的加班报酬","isFixed": 1,"isPlus": 1,"isTax": 1,"isShow": 1,"isCompute": 1,"isOpen": 1},{"optionId": "1210","code": 190,"parentCode": 0,"name": "考勤扣款明细","remarks": null,"isFixed": 1,"isPlus": 0,"isTax": 1,"isShow": 1,"isCompute": 1,"isOpen": 1},{"optionId": "1217","code": 200,"parentCode": 0,"name": "考勤扣款合计","remarks": null,"isFixed": 1,"isPlus": 0,"isTax": 1,"isShow": 1,"isCompute": 0,"isOpen": 1},{"optionId": "1219","code": 210,"parentCode": 0,"name": "应发工资","remarks": null,"isFixed": 1,"isPlus": 2,"isTax": 2,"isShow": 1,"isCompute": 0,"isOpen": 1},{"optionId": "1221","code": 220,"parentCode": 0,"name": "应税工资","remarks": null,"isFixed": 1,"isPlus": 2,"isTax": 2,"isShow": 1,"isCompute": 0,"isOpen": 1},{"optionId": "1223","code": 230,"parentCode": 0,"name": "个人所得税","remarks": null,"isFixed": 1,"isPlus": 2,"isTax": 2,"isShow": 1,"isCompute": 0,"isOpen": 1},{"optionId": "1225","code": 240,"parentCode": 0,"name": "实发工资","remarks": null,"isFixed": 1,"isPlus": 2,"isTax": 2,"isShow": 1,"isCompute": 0,"isOpen": 1},{"optionId": "1227","code": 10101,"parentCode": 10,"name": "基本工资","remarks": "劳动合同中约定的标准工资。","isFixed": 0,"isPlus": 1,"isTax": 1,"isShow": 1,"isCompute": 1,"isOpen": 1},{"optionId": "1228","code": 10102,"parentCode": 10,"name": "岗位工资","remarks": "根据岗位、责任、技能要求等，不同岗位，工资不同。","isFixed": 0,"isPlus": 1,"isTax": 1,"isShow": 1,"isCompute": 1,"isOpen": 1},{"optionId": "1229","code": 10103,"parentCode": 10,"name": "职务工资","remarks": "根据职务高低、业务技术水平等因素的不同，工资不同，随职务变动而变动。","isFixed": 0,"isPlus": 1,"isTax": 1,"isShow": 1,"isCompute": 1,"isOpen": 1},{"optionId": "1230","code": 20101,"parentCode": 20,"name": "住房补贴","remarks": "为职工解决住房问题而给予的补贴资助。","isFixed": 0,"isPlus": 1,"isTax": 1,"isShow": 1,"isCompute": 1,"isOpen": 1},{"optionId": "1231","code": 20102,"parentCode": 20,"name": "高温津贴","remarks": "用人单位安排劳动者在高温天气下工作，当温度高于33℃，应支付高温补贴。","isFixed": 0,"isPlus": 1,"isTax": 1,"isShow": 1,"isCompute": 1,"isOpen": 1},{"optionId": "1232","code": 20103,"parentCode": 20,"name": "交通补贴","remarks": "企业按月按标准支付的交通补贴","isFixed": 0,"isPlus": 1,"isTax": 1,"isShow": 1,"isCompute": 1,"isOpen": 1},{"optionId": "1233","code": 20104,"parentCode": 20,"name": "餐补","remarks": "企业不统一供餐，而是按月按标准支付的午饭或晚餐补贴","isFixed": 0,"isPlus": 1,"isTax": 1,"isShow": 1,"isCompute": 1,"isOpen": 1},{"optionId": "1234","code": 30101,"parentCode": 30,"name": "绩效工资","remarks": "以员工的实际劳动成果或表现为考核标准，支付一定的奖励工资。","isFixed": 0,"isPlus": 1,"isTax": 1,"isShow": 1,"isCompute": 1,"isOpen": 1},{"optionId": "1235","code": 40101,"parentCode": 40,"name": "季度奖","remarks": "对于表现优秀的员工，按季度给予一定的奖励工资。","isFixed": 0,"isPlus": 1,"isTax": 1,"isShow": 1,"isCompute": 1,"isOpen": 1},{"optionId": "1236","code": 40102,"parentCode": 40,"name": "全勤奖","remarks": "对于按公司规定到岗工作，未出现任何迟到、早退的员工给予的奖励，一般以月度为考核期限。","isFixed": 0,"isPlus": 1,"isTax": 1,"isShow": 1,"isCompute": 1,"isOpen": 1},{"optionId": "1237","code": 40103,"parentCode": 40,"name": "推荐奖","remarks": "企业在招揽人才的过程中，对推荐人才并顺利入职的内部员工，给予的奖励工资。","isFixed": 0,"isPlus": 1,"isTax": 1,"isShow": 1,"isCompute": 1,"isOpen": 1},{"optionId": "1238","code": 50101,"parentCode": 50,"name": "销售提成","remarks": "对于销售或业务人员，通常按照一定的比例，企业和员工之间对盈利进行分成。","isFixed": 0,"isPlus": 1,"isTax": 1,"isShow": 1,"isCompute": 1,"isOpen": 1},{"optionId": "1239","code": 60101,"parentCode": 60,"name": "计件工资","remarks": "根据职工完成的劳动数量和按事先规定的计件单价计算和支付的工资。","isFixed": 0,"isPlus": 1,"isTax": 1,"isShow": 1,"isCompute": 1,"isOpen": 1},{"optionId": "1240","code": 70101,"parentCode": 70,"name": "计时工资","remarks": "根据职工的工作时间,按照工资标准、等级计算和支付的工资","isFixed": 0,"isPlus": 1,"isTax": 1,"isShow": 1,"isCompute": 1,"isOpen": 1},{"optionId": "1241","code": 80101,"parentCode": 80,"name": "工龄工资","remarks": "企业按照员工的工作年数，即员工的工作经验和劳动贡献的积累给予的经济补偿。","isFixed": 0,"isPlus": 1,"isTax": 1,"isShow": 1,"isCompute": 1,"isOpen": 1},{"optionId": "1242","code": 80102,"parentCode": 80,"name": "司龄工资","remarks": "司龄工资是按照劳动者在在公司做的时间的长短进行相应工资的计算。","isFixed": 0,"isPlus": 1,"isTax": 1,"isShow": 1,"isCompute": 1,"isOpen": 1},{"optionId": "1243","code": 90101,"parentCode": 90,"name": "职称工资","remarks": "工资高低与职称挂钩，职称越高，工资越高。","isFixed": 0,"isPlus": 1,"isTax": 1,"isShow": 1,"isCompute": 1,"isOpen": 1},{"optionId": "1244","code": 90102,"parentCode": 90,"name": "技能工资","remarks": "以员工个人所掌握的知识、技术和所具备的能力为基础来进行工资报酬的支付。","isFixed": 0,"isPlus": 1,"isTax": 1,"isShow": 1,"isCompute": 1,"isOpen": 1},{"optionId": "1245","code": 90103,"parentCode": 90,"name": "学历工资","remarks": "根据员工在教育机构取得的学历而给予适当的津贴。","isFixed": 0,"isPlus": 1,"isTax": 1,"isShow": 1,"isCompute": 1,"isOpen": 1},{"optionId": "1246","code": 100101,"parentCode": 100,"name": "个人社保","remarks": "社保中个人缴纳的部分","isFixed": 0,"isPlus": 0,"isTax": 1,"isShow": 1,"isCompute": 1,"isOpen": 1},{"optionId": "1247","code": 100102,"parentCode": 100,"name": "个人公积金","remarks": "公积金中个人缴纳的部分","isFixed": 0,"isPlus": 0,"isTax": 1,"isShow": 1,"isCompute": 1,"isOpen": 1},{"optionId": "1248","code": 110101,"parentCode": 110,"name": "企业社保","remarks": "企业承担的社保费用","isFixed": 0,"isPlus": 1,"isTax": 0,"isShow": 1,"isCompute": 0,"isOpen": 1},{"optionId": "1249","code": 120101,"parentCode": 120,"name": "企业公积金","remarks": "企业承担的公积金费用","isFixed": 0,"isPlus": 1,"isTax": 0,"isShow": 1,"isCompute": 0,"isOpen": 1},{"optionId": "1250","code": 130101,"parentCode": 130,"name": "税前补发","remarks": "如上月漏发，这月补发的工资","isFixed": 0,"isPlus": 1,"isTax": 0,"isShow": 1,"isCompute": 1,"isOpen": 1},{"optionId": "1251","code": 140101,"parentCode": 140,"name": "税前补扣","remarks": "如上月未扣，这月补扣的扣款；","isFixed": 0,"isPlus": 0,"isTax": 0,"isShow": 1,"isCompute": 1,"isOpen": 1},{"optionId": "1252","code": 150101,"parentCode": 150,"name": "税后补发","remarks": "其它税后补发","isFixed": 0,"isPlus": 1,"isTax": 0,"isShow": 1,"isCompute": 1,"isOpen": 1},{"optionId": "1253","code": 160101,"parentCode": 160,"name": "党费","remarks": "向党组织交纳的用于党的事业和党的活动的经费，由公司代收。","isFixed": 0,"isPlus": 0,"isTax": 0,"isShow": 1,"isCompute": 1,"isOpen": 1},{"optionId": "1254","code": 160102,"parentCode": 160,"name": "工会费","remarks": "员工缴纳的，工会组织开展各项活动所需要的费用","isFixed": 0,"isPlus": 0,"isTax": 0,"isShow": 1,"isCompute": 1,"isOpen": 1},{"optionId": "1255","code": 160103,"parentCode": 160,"name": "补充医疗","remarks": "企业在基本医疗保险的基础上，为员工缴纳的额外补充医疗保险。","isFixed": 0,"isPlus": 0,"isTax": 0,"isShow": 1,"isCompute": 1,"isOpen": 1},{"optionId": "1256","code": 170101,"parentCode": 170,"name": "商业保险金","remarks": "商业保险金不参与计算，但要计税","isFixed": 0,"isPlus": 1,"isTax": 1,"isShow": 1,"isCompute": 1,"isOpen": 1},{"optionId": "1257","code": 180101,"parentCode": 180,"name": "加班工资","remarks": "按一定的比例，按加班时长计算加班工资","isFixed": 1,"isPlus": 1,"isTax": 1,"isShow": 1,"isCompute": 1,"isOpen": 1},{"optionId": "1258","code": 190101,"parentCode": 190,"name": "迟到扣款","remarks": "员工无故迟到，需扣除一定的工资作为惩戒","isFixed": 1,"isPlus": 0,"isTax": 1,"isShow": 1,"isCompute": 1,"isOpen": 1},{"optionId": "1259","code": 190102,"parentCode": 190,"name": "早退扣款","remarks": "员工无故早退，需扣除一定的工资作为惩戒","isFixed": 1,"isPlus": 0,"isTax": 1,"isShow": 1,"isCompute": 1,"isOpen": 1},{"optionId": "1260","code": 190103,"parentCode": 190,"name": "旷工扣款","remarks": "员工无故旷工，需扣除一定的工资作为惩戒","isFixed": 1,"isPlus": 0,"isTax": 1,"isShow": 1,"isCompute": 1,"isOpen": 1},{"optionId": "1261","code": 190104,"parentCode": 190,"name": "假期扣款","remarks": "员工因请事假、病假等，工作日未能到岗，需扣除一定的工资","isFixed": 1,"isPlus": 0,"isTax": 1,"isShow": 1,"isCompute": 1,"isOpen": 1},{"optionId": "1262","code": 190105,"parentCode": 190,"name": "缺卡扣款","remarks": "员工无故缺卡，需扣除一定的金额作为惩戒","isFixed": 1,"isPlus": 0,"isTax": 1,"isShow": 1,"isCompute": 1,"isOpen": 1},{"optionId": "1263","code": 190106,"parentCode": 190,"name": "综合扣款","remarks": "按月累计迟到和早退时长或次数，计算的考勤扣款金额","isFixed": 1,"isPlus": 0,"isTax": 1,"isShow": 1,"isCompute": 1,"isOpen": 1},{"optionId": "1264","code": 200101,"parentCode": 200,"name": "考勤扣款合计","remarks": "迟到、早退、旷工、缺卡、请假等6中异常考勤的扣款合计","isFixed": 1,"isPlus": 0,"isTax": 1,"isShow": 1,"isCompute": 0,"isOpen": 1},{"optionId": "1265","code": 210101,"parentCode": 210,"name": "应发工资","remarks": "应发工资=员工工资总额-请假扣款-考勤扣款等","isFixed": 1,"isPlus": 2,"isTax": 2,"isShow": 1,"isCompute": 0,"isOpen": 1},{"optionId": "1266","code": 220101,"parentCode": 220,"name": "应税工资","remarks": "应税工资=应发工资-个人社保-个人公积金-每月减除费用","isFixed": 1,"isPlus": 2,"isTax": 2,"isShow": 1,"isCompute": 0,"isOpen": 1},{"optionId": "1267","code": 230101,"parentCode": 230,"name": "个人所得税","remarks": "根据个税计算规则，计算的每月应缴纳个税","isFixed": 1,"isPlus": 2,"isTax": 2,"isShow": 1,"isCompute": 0,"isOpen": 1},{"optionId": "1268","code": 240101,"parentCode": 240,"name": "实发工资","remarks": "员工每月获得的实际收入。","isFixed": 1,"isPlus": 2,"isTax": 2,"isShow": 1,"isCompute": 0,"isOpen": 1}]
薪资配置
constantKey：salaryConfig
constantType：object
{"salaryCycleStartDay": 1,"salaryCycleEndDay": 31,"payType": "当月","payDay": "发薪日期","socialSecurityMonthType": "1","salaryStartMonth": "2022-03","socialSecurityStartMonth": "2022-01"}
计算配置
constantKey：salaryComputation
constantType：object
{"weekendSubsidy": 400,"schoolAgeSubsidy": 150,"professionalTitleAllowanceGuide": {"本科": 300,"硕士": 600,"博士": 1000}}
_constant语句
INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (1, 'salaryOption', 'array', '薪资项', '[{"optionId":"1161","code":10,"parentCode":0,"name":"基本工资","remarks":null,"isFixed":0,"isPlus":1,"isTax":1,"isShow":1,"isCompute":1,"isOpen":1},{"optionId":"1165","code":20,"parentCode":0,"name":"津补贴","remarks":"企业给员工提供的福利","isFixed":0,"isPlus":1,"isTax":1,"isShow":1,"isCompute":1,"isOpen":1},{"optionId":"1170","code":30,"parentCode":0,"name":"浮动工资","remarks":"浮动工资需要在每月算薪前手工录入","isFixed":0,"isPlus":1,"isTax":1,"isShow":1,"isCompute":1,"isOpen":1},{"optionId":"1172","code":40,"parentCode":0,"name":"奖金","remarks":null,"isFixed":0,"isPlus":1,"isTax":1,"isShow":1,"isCompute":1,"isOpen":1},{"optionId":"1176","code":50,"parentCode":0,"name":"提成工资","remarks":null,"isFixed":0,"isPlus":1,"isTax":1,"isShow":1,"isCompute":1,"isOpen":1},{"optionId":"1178","code":60,"parentCode":0,"name":"计件工资","remarks":null,"isFixed":0,"isPlus":1,"isTax":1,"isShow":1,"isCompute":1,"isOpen":1},{"optionId":"1180","code":70,"parentCode":0,"name":"计时工资","remarks":null,"isFixed":0,"isPlus":1,"isTax":1,"isShow":1,"isCompute":1,"isOpen":1},{"optionId":"1182","code":80,"parentCode":0,"name":"工龄/司龄工资","remarks":null,"isFixed":0,"isPlus":1,"isTax":1,"isShow":1,"isCompute":1,"isOpen":1},{"optionId":"1185","code":90,"parentCode":0,"name":"职称工资","remarks":null,"isFixed":0,"isPlus":1,"isTax":1,"isShow":1,"isCompute":1,"isOpen":1},{"optionId":"1189","code":100,"parentCode":0,"name":"代扣代缴","remarks":"公司代替个人缴纳的费用，如个人社保、个人公积金。该类别下的薪酬项，将从应纳税所得额中扣除，影响个税计算","isFixed":0,"isPlus":0,"isTax":1,"isShow":1,"isCompute":1,"isOpen":1},{"optionId":"1192","code":110,"parentCode":0,"name":"企业社保","remarks":"该类别下的薪酬项，不参与工资计算，只参与企业成本统计或社保成本分析","isFixed":0,"isPlus":1,"isTax":0,"isShow":1,"isCompute":0,"isOpen":1},{"optionId":"1194","code":120,"parentCode":0,"name":"企业公积金","remarks":"该类别下的薪酬项，不参与工资计算，只参与企业成本统计或社保成本分析","isFixed":0,"isPlus":1,"isTax":0,"isShow":1,"isCompute":0,"isOpen":1},{"optionId":"1196","code":130,"parentCode":0,"name":"税前补发","remarks":"税前补发，与该月的工资一起发放，需参与计税","isFixed":0,"isPlus":1,"isTax":0,"isShow":1,"isCompute":1,"isOpen":1},{"optionId":"1198","code":140,"parentCode":0,"name":"税前补扣","remarks":"税前从该月的工资中补扣的金额，会影响本月的应税工资总额","isFixed":0,"isPlus":0,"isTax":0,"isShow":1,"isCompute":1,"isOpen":1},{"optionId":"1200","code":150,"parentCode":0,"name":"税后补发","remarks":"税后补发，不参与该月工资计算，会影响当月的实际所得","isFixed":0,"isPlus":1,"isTax":0,"isShow":1,"isCompute":1,"isOpen":1},{"optionId":"1202","code":160,"parentCode":0,"name":"税后补扣","remarks":"从税后的工资中补扣的款项，不参与该月的工资计税","isFixed":0,"isPlus":0,"isTax":0,"isShow":1,"isCompute":1,"isOpen":1},{"optionId":"1206","code":170,"parentCode":0,"name":"特殊计税项","remarks":"其它里的科目不参与工资计算，但要计税","isFixed":0,"isPlus":1,"isTax":1,"isShow":1,"isCompute":1,"isOpen":1},{"optionId":"1208","code":180,"parentCode":0,"name":"加班工资","remarks":"公司按员工加班时长计算的加班报酬","isFixed":1,"isPlus":1,"isTax":1,"isShow":1,"isCompute":1,"isOpen":1},{"optionId":"1210","code":190,"parentCode":0,"name":"考勤扣款明细","remarks":null,"isFixed":1,"isPlus":0,"isTax":1,"isShow":1,"isCompute":1,"isOpen":1},{"optionId":"1217","code":200,"parentCode":0,"name":"考勤扣款合计","remarks":null,"isFixed":1,"isPlus":0,"isTax":1,"isShow":1,"isCompute":0,"isOpen":1},{"optionId":"1219","code":210,"parentCode":0,"name":"应发工资","remarks":null,"isFixed":1,"isPlus":2,"isTax":2,"isShow":1,"isCompute":0,"isOpen":1},{"optionId":"1221","code":220,"parentCode":0,"name":"应税工资","remarks":null,"isFixed":1,"isPlus":2,"isTax":2,"isShow":1,"isCompute":0,"isOpen":1},{"optionId":"1223","code":230,"parentCode":0,"name":"个人所得税","remarks":null,"isFixed":1,"isPlus":2,"isTax":2,"isShow":1,"isCompute":0,"isOpen":1},{"optionId":"1225","code":240,"parentCode":0,"name":"实发工资","remarks":null,"isFixed":1,"isPlus":2,"isTax":2,"isShow":1,"isCompute":0,"isOpen":1},{"optionId":"1227","code":10101,"parentCode":10,"name":"基本工资","remarks":"劳动合同中约定的标准工资。","isFixed":0,"isPlus":1,"isTax":1,"isShow":1,"isCompute":1,"isOpen":1},{"optionId":"1228","code":10102,"parentCode":10,"name":"岗位工资","remarks":"根据岗位、责任、技能要求等，不同岗位，工资不同。","isFixed":0,"isPlus":1,"isTax":1,"isShow":1,"isCompute":1,"isOpen":1},{"optionId":"1229","code":10103,"parentCode":10,"name":"职务工资","remarks":"根据职务高低、业务技术水平等因素的不同，工资不同，随职务变动而变动。","isFixed":0,"isPlus":1,"isTax":1,"isShow":1,"isCompute":1,"isOpen":1},{"optionId":"1230","code":20101,"parentCode":20,"name":"住房补贴","remarks":"为职工解决住房问题而给予的补贴资助。","isFixed":0,"isPlus":1,"isTax":1,"isShow":1,"isCompute":1,"isOpen":1},{"optionId":"1231","code":20102,"parentCode":20,"name":"高温津贴","remarks":"用人单位安排劳动者在高温天气下工作，当温度高于33℃，应支付高温补贴。","isFixed":0,"isPlus":1,"isTax":1,"isShow":1,"isCompute":1,"isOpen":1},{"optionId":"1232","code":20103,"parentCode":20,"name":"交通补贴","remarks":"企业按月按标准支付的交通补贴","isFixed":0,"isPlus":1,"isTax":1,"isShow":1,"isCompute":1,"isOpen":1},{"optionId":"1233","code":20104,"parentCode":20,"name":"餐补","remarks":"企业不统一供餐，而是按月按标准支付的午饭或晚餐补贴","isFixed":0,"isPlus":1,"isTax":1,"isShow":1,"isCompute":1,"isOpen":1},{"optionId":"1234","code":30101,"parentCode":30,"name":"绩效工资","remarks":"以员工的实际劳动成果或表现为考核标准，支付一定的奖励工资。","isFixed":0,"isPlus":1,"isTax":1,"isShow":1,"isCompute":1,"isOpen":1},{"optionId":"1235","code":40101,"parentCode":40,"name":"季度奖","remarks":"对于表现优秀的员工，按季度给予一定的奖励工资。","isFixed":0,"isPlus":1,"isTax":1,"isShow":1,"isCompute":1,"isOpen":1},{"optionId":"1236","code":40102,"parentCode":40,"name":"全勤奖","remarks":"对于按公司规定到岗工作，未出现任何迟到、早退的员工给予的奖励，一般以月度为考核期限。","isFixed":0,"isPlus":1,"isTax":1,"isShow":1,"isCompute":1,"isOpen":1},{"optionId":"1237","code":40103,"parentCode":40,"name":"推荐奖","remarks":"企业在招揽人才的过程中，对推荐人才并顺利入职的内部员工，给予的奖励工资。","isFixed":0,"isPlus":1,"isTax":1,"isShow":1,"isCompute":1,"isOpen":1},{"optionId":"1238","code":50101,"parentCode":50,"name":"销售提成","remarks":"对于销售或业务人员，通常按照一定的比例，企业和员工之间对盈利进行分成。","isFixed":0,"isPlus":1,"isTax":1,"isShow":1,"isCompute":1,"isOpen":1},{"optionId":"1239","code":60101,"parentCode":60,"name":"计件工资","remarks":"根据职工完成的劳动数量和按事先规定的计件单价计算和支付的工资。","isFixed":0,"isPlus":1,"isTax":1,"isShow":1,"isCompute":1,"isOpen":1},{"optionId":"1240","code":70101,"parentCode":70,"name":"计时工资","remarks":"根据职工的工作时间,按照工资标准、等级计算和支付的工资","isFixed":0,"isPlus":1,"isTax":1,"isShow":1,"isCompute":1,"isOpen":1},{"optionId":"1241","code":80101,"parentCode":80,"name":"工龄工资","remarks":"企业按照员工的工作年数，即员工的工作经验和劳动贡献的积累给予的经济补偿。","isFixed":0,"isPlus":1,"isTax":1,"isShow":1,"isCompute":1,"isOpen":1},{"optionId":"1242","code":80102,"parentCode":80,"name":"司龄工资","remarks":"司龄工资是按照劳动者在在公司做的时间的长短进行相应工资的计算。","isFixed":0,"isPlus":1,"isTax":1,"isShow":1,"isCompute":1,"isOpen":1},{"optionId":"1243","code":90101,"parentCode":90,"name":"职称工资","remarks":"工资高低与职称挂钩，职称越高，工资越高。","isFixed":0,"isPlus":1,"isTax":1,"isShow":1,"isCompute":1,"isOpen":1},{"optionId":"1244","code":90102,"parentCode":90,"name":"技能工资","remarks":"以员工个人所掌握的知识、技术和所具备的能力为基础来进行工资报酬的支付。","isFixed":0,"isPlus":1,"isTax":1,"isShow":1,"isCompute":1,"isOpen":1},{"optionId":"1245","code":90103,"parentCode":90,"name":"学历工资","remarks":"根据员工在教育机构取得的学历而给予适当的津贴。","isFixed":0,"isPlus":1,"isTax":1,"isShow":1,"isCompute":1,"isOpen":1},{"optionId":"1246","code":100101,"parentCode":100,"name":"个人社保","remarks":"社保中个人缴纳的部分","isFixed":0,"isPlus":0,"isTax":1,"isShow":1,"isCompute":1,"isOpen":1},{"optionId":"1247","code":100102,"parentCode":100,"name":"个人公积金","remarks":"公积金中个人缴纳的部分","isFixed":0,"isPlus":0,"isTax":1,"isShow":1,"isCompute":1,"isOpen":1},{"optionId":"1248","code":110101,"parentCode":110,"name":"企业社保","remarks":"企业承担的社保费用","isFixed":0,"isPlus":1,"isTax":0,"isShow":1,"isCompute":0,"isOpen":1},{"optionId":"1249","code":120101,"parentCode":120,"name":"企业公积金","remarks":"企业承担的公积金费用","isFixed":0,"isPlus":1,"isTax":0,"isShow":1,"isCompute":0,"isOpen":1},{"optionId":"1250","code":130101,"parentCode":130,"name":"税前补发","remarks":"如上月漏发，这月补发的工资","isFixed":0,"isPlus":1,"isTax":0,"isShow":1,"isCompute":1,"isOpen":1},{"optionId":"1251","code":140101,"parentCode":140,"name":"税前补扣","remarks":"如上月未扣，这月补扣的扣款；","isFixed":0,"isPlus":0,"isTax":0,"isShow":1,"isCompute":1,"isOpen":1},{"optionId":"1252","code":150101,"parentCode":150,"name":"税后补发","remarks":"其它税后补发","isFixed":0,"isPlus":1,"isTax":0,"isShow":1,"isCompute":1,"isOpen":1},{"optionId":"1253","code":160101,"parentCode":160,"name":"党费","remarks":"向党组织交纳的用于党的事业和党的活动的经费，由公司代收。","isFixed":0,"isPlus":0,"isTax":0,"isShow":1,"isCompute":1,"isOpen":1},{"optionId":"1254","code":160102,"parentCode":160,"name":"工会费","remarks":"员工缴纳的，工会组织开展各项活动所需要的费用","isFixed":0,"isPlus":0,"isTax":0,"isShow":1,"isCompute":1,"isOpen":1},{"optionId":"1255","code":160103,"parentCode":160,"name":"补充医疗","remarks":"企业在基本医疗保险的基础上，为员工缴纳的额外补充医疗保险。","isFixed":0,"isPlus":0,"isTax":0,"isShow":1,"isCompute":1,"isOpen":1},{"optionId":"1256","code":170101,"parentCode":170,"name":"商业保险金","remarks":"商业保险金不参与计算，但要计税","isFixed":0,"isPlus":1,"isTax":1,"isShow":1,"isCompute":1,"isOpen":1},{"optionId":"1257","code":180101,"parentCode":180,"name":"加班工资","remarks":"按一定的比例，按加班时长计算加班工资","isFixed":1,"isPlus":1,"isTax":1,"isShow":1,"isCompute":1,"isOpen":1},{"optionId":"1258","code":190101,"parentCode":190,"name":"迟到扣款","remarks":"员工无故迟到，需扣除一定的工资作为惩戒","isFixed":1,"isPlus":0,"isTax":1,"isShow":1,"isCompute":1,"isOpen":1},{"optionId":"1259","code":190102,"parentCode":190,"name":"早退扣款","remarks":"员工无故早退，需扣除一定的工资作为惩戒","isFixed":1,"isPlus":0,"isTax":1,"isShow":1,"isCompute":1,"isOpen":1},{"optionId":"1260","code":190103,"parentCode":190,"name":"旷工扣款","remarks":"员工无故旷工，需扣除一定的工资作为惩戒","isFixed":1,"isPlus":0,"isTax":1,"isShow":1,"isCompute":1,"isOpen":1},{"optionId":"1261","code":190104,"parentCode":190,"name":"假期扣款","remarks":"员工因请事假、病假等，工作日未能到岗，需扣除一定的工资","isFixed":1,"isPlus":0,"isTax":1,"isShow":1,"isCompute":1,"isOpen":1},{"optionId":"1262","code":190105,"parentCode":190,"name":"缺卡扣款","remarks":"员工无故缺卡，需扣除一定的金额作为惩戒","isFixed":1,"isPlus":0,"isTax":1,"isShow":1,"isCompute":1,"isOpen":1},{"optionId":"1263","code":190106,"parentCode":190,"name":"综合扣款","remarks":"按月累计迟到和早退时长或次数，计算的考勤扣款金额","isFixed":1,"isPlus":0,"isTax":1,"isShow":1,"isCompute":1,"isOpen":1},{"optionId":"1264","code":200101,"parentCode":200,"name":"考勤扣款合计","remarks":"迟到、早退、旷工、缺卡、请假等6中异常考勤的扣款合计","isFixed":1,"isPlus":0,"isTax":1,"isShow":1,"isCompute":0,"isOpen":1},{"optionId":"1265","code":210101,"parentCode":210,"name":"应发工资","remarks":"应发工资=员工工资总额-请假扣款-考勤扣款等","isFixed":1,"isPlus":2,"isTax":2,"isShow":1,"isCompute":0,"isOpen":1},{"optionId":"1266","code":220101,"parentCode":220,"name":"应税工资","remarks":"应税工资=应发工资-个人社保-个人公积金-每月减除费用","isFixed":1,"isPlus":2,"isTax":2,"isShow":1,"isCompute":0,"isOpen":1},{"optionId":"1267","code":230101,"parentCode":230,"name":"个人所得税","remarks":"根据个税计算规则，计算的每月应缴纳个税","isFixed":1,"isPlus":2,"isTax":2,"isShow":1,"isCompute":0,"isOpen":1},{"optionId":"1268","code":240101,"parentCode":240,"name":"实发工资","remarks":"员工每月获得的实际收入。","isFixed":1,"isPlus":2,"isTax":2,"isShow":1,"isCompute":0,"isOpen":1}]', 'update', NULL, NULL, '2023-03-07T15:17:37+08:00');INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (2, 'salaryConfig', 'object', '薪资配置', '{"salaryCycleStartDay": 1,"salaryCycleEndDay": 31,"payType": "当月","payDay": "发薪日期","socialSecurityMonthType": "1","salaryStartMonth": "2022-03","socialSecurityStartMonth": "2022-01"}', 'insert', NULL, NULL, NULL);INSERT INTO _constant (id, constantKey, constantType, desc, constantValue, operation, operationByUserId, operationByUser, operationAt) VALUES (3, 'salaryComputation', 'object', '计算配置', '{"weekendSubsidy": 400,"schoolAgeSubsidy": 150,"professionalTitleAllowanceGuide": {"本科": 300,"硕士": 600,"博士": 1000}}', 'insert', NULL, NULL, NULL);