| main_params | 主参数 | |
| main_params.serial_number | 流水号 | {{textField_kspd9fet}} |
| main_params.applicant | 申请人 | findCollection find id from d7be3d48-ac1c-3cb5-94b2-d46c097a18d7 where name={{textField_kspd9fet}} |
| main_params.applicant_dept | 申请部门 | _findCollection find id from b71beb3b-63b1-35b5-93be-05600e1f5328 where name={{textField_kspd9fet}} |
| main_params.cost_type | 费用类型 | 1 |
| main_params.amount | 金额 | {{numberField_kmspmioz}} |
| main_params.cost_undertake_org | 费用承担组织 | {{textField_krvuo78f}} |
| main_params.pay_org | 费用付款组织 | {{textField_krvuo78f}} |
| main_params.extend_params_1 | 1:1扩展参数 | tableField_ksqrp4ot |
| main_params.extend_params_1.lastInsertId | 转账单ID | :lastInsertId |
| main_params.extend_params_1.pay_account | 支付账户 | {{tableField_ksqrp4ot.selectField_ksqu3vie}} |
| main_params.extend_params_1.payway | 支付方式 | {{tableField_ksqrp4ot.selectField_ksqu3vif}} |
| main_params.extend_params_1.salary_dept | 薪金发放部门 salary_dept | {{tableField_ksqrp4ot.textField_kxfehy13}} |
| main_params.extend_params_1.accumulation_fund | 公积金 | {{tableField_ksqrp4ot.numberField_l1q3dt9p}} |
| main_params.extend_params_1.pay_account_number | 支付账号 | {{tableField_ksqrp4ot.selectField_ksqu3vid}} |
| main_params.extend_params_1.wages_payable | 应发工资 | {{tableField_ksqrp4ot.numberField_l0bqdbt3}} |
| main_params.extend_params_1.social_insurance | 个人社保 | {{tableField_ksqrp4ot.numberField_kt0ymemh}} |
| main_params.extend_params_1.advance_employee_social_security | 垫付员工社保 | {{tableField_ksqrp4ot.numberField_kt0ymemi}} |
| main_params.extend_params_1.advance_employee_salary | 垫付员工工资 | {{tableField_ksqrp4ot.numberField_kt0ymemj}} |
| main_params.extend_params_1.personal_income_tax | 个税 | {{tableField_ksqrp4ot.numberField_kt0ymemm}} |
| main_params.extend_params_1.net_salary | 实发工资 | {{tableField_ksqrp4ot.numberField_ksqu3vii}} |
| main_params.extend_params_1.wage_number | 支付工资人数 | {{numberField_krcrmkkr}} |
| main_params.extend_params_1.paytime | 支付时间 | {{dateField_kmspmipf datetime}} |
| main_params.extend_params_1.real_paytime | 实际支付时间 | {{dateField_kzdsyb61 datetime}} |
| main_params.extend_params_1.main_sql | 主语句 | INSERT INTO cc_bill_salary ( serial_number, applicant, applicant_dept, cost_type, cost_undertake_org, pay_org, amount) VALUES ( <{serial_number: }>, <{applicant: }>, <{applicant_dept: }>, <{cost_type: }>, <{cost_undertake_org: }>, <{pay_org: }>, <{amount: }>); |
| main_params.extend_params_1.extend_sql_1 | 1:1扩展语句 | INSERT INTO cc_bill_salary_detail ( salary_dept, wages_payable, social_insurance, advance_employee_social_security, advance_employee_salary, personal_income_tax, net_salary, accumulation_fund, wage_number, pay_account, pay_account_number, salary_id, payway, paytime, real_paytime) VALUES ( <{salary_dept: }>, <{wages_payable: }>, <{social_insurance: }>, <{advance_employee_social_security: }>, <{advance_employee_salary: }>, <{personal_income_tax: }>, <{net_salary: }>, <{accumulation_fund: }>, <{wage_number: }>, <{pay_account: }>, <{pay_account_number: }>, <{lastInsertId: }>, <{payway: }>, <{paytime: }>, <{real_paytime: }>); |
