| main_params | 主参数 | |
| main_params.serial_number | 流水号 | {{textField_kspgl3w6}} |
| main_params.applicant | 申请人 | findCollection find id from d7be3d48-ac1c-3cb5-94b2-d46c097a18d7 where name={{textField_kmvroghw}} |
| main_params.applicant_dept | 申请部门 | _findCollection find id from b71beb3b-63b1-35b5-93be-05600e1f5328 where name={{selectField_kmvroghv}} |
| main_params.budget_dept | 预算部门 | {{selectField_kzfb3nrj}} |
| main_params.budget_month | 预算月份 | {{textField_kxpgmv0d}} |
| main_params.receive_name | 收款人或公司名称 | function case '{{textField_kquro2hk}}' when '' then '{{textField_kqupzsd9}}' else '{{textField_kquro2hk}}' end |
| main_params.receive_account | 收款账户 | _function case '{{selectField_kquro2hh}}' when '' then '{{textField_kqupzsdb}}' else '{{selectField_kquro2hh}}' end |
| main_params.receive_account_number | 收款账号 | function case '{{selectField_kquro2hj}}' when '' then '{{textField_kqvm6slb}}' else '{{selectField_kquro2hj}}' end |
| main_params.receive_account_bank | 开户银行 | _function case '{{selectField_kquro2hi}}' when '' then '{{textField_kqupzsd4}}' else '{{selectField_kquro2hi}}' end |
| main_params.extend_params_1 | 1:1扩展参数 | tableField_ks8a1ak1 |
| main_params.extend_params_1.lastInsertId | 借款单ID | :lastInsertId |
| main_params.extend_params_1.cost_type | 费用类型 | |
| main_params.extend_params_1.cost_class | 费用类别 | {{tableField_ks8a1ak1.selectField_ks8a1ak3}} |
| main_params.extend_params_1.cost_item_id | 费用项目 | 111 |
| main_params.extend_params_1.cost_undertake_org | 费用承担组织 | {{tableField_ks8a1ak1.textField_kr37axo2}} |
| main_params.extend_params_1.cost_undertake_dept | 费用承担部门 | {{tableField_ks8a1ak1.textField_kwjz1agw}} |
| main_params.extend_params_1.amount | 金额 | {{tableField_ks8a1ak1.numberField_ks8a1ak5}} |
| main_params.extend_params_1.replenishment_platform | 是否充值到补单平台 | |
| main_params.extend_params_1.extend_params_2 | 1:N扩展参数 | |
| main_params.extend_params_1.extend_params_2.lastInsertId | 借款单ID | :lastInsertId |
| main_params.extend_params_1.extend_params_2.pay_org | 费用支出组织 | {{textField_krvpf8fl}} |
| main_params.extend_params_1.extend_params_2.pay_account | 支付账户 | {{selectField_kq8ryql2}} |
| main_params.extend_params_1.extend_params_2.pay_account_bank | 银行名称 | {{selectField_kq97ayh4}} |
| main_params.extend_params_1.extend_params_2.pay_time | 支付日期 | {{dateField_kmo8rpow datetime}} |
| main_params.extend_params_1.extend_params_2.real_pay_time | 实际支付日期 | {{dateField_kzdsg96q datetime}} |
| main_params.extend_params_1.extend_params_2.pay_acconunt_number | 银行编码 | 11 |
| main_params.extend_params_1.extend_params_2.main_sql | 主语句 | INSERT INTO cc_bill_ioan ( serial_number, applicant, applicant_dept, budget_dept, budget_month, receive_name, receive_account, receive_account_number, receive_account_bank) VALUES ( <{serial_number: }>, <{applicant: }>, <{applicant_dept: }>, <{budget_dept: }>, <{budget_month: }>, <{receive_name: }>, <{receive_account: }>, <{receive_account_number: }>, <{receive_account_bank: }>); |
| main_params.extend_params_1.extend_params_2.extend_sql_1 | 1:1扩展语句 | INSERT INTO cc_bill_ioan_cost_detail (ioan_id, cost_type, cost_class, cost_item_id, cost_undertake_org, cost_undertake_dept, amount, replenishment_platform) VALUES (<{lastInsertId: }>, <{cost_type: }>, <{cost_class: }>, <{cost_item_id: }>, <{cost_undertake_org: }>, <{cost_undertake_dept: }>, <{amount: }>, <{replenishment_platform: }>); |
| main_params.extend_params_1.extend_params_2.extend_sql_2 | 1:N扩展语句 | INSERT INTO cc_bill_ioan_payment_detail (ioan_id, pay_org, pay_account, pay_account_bank, pay_acconunt_number, pay_time, real_pay_time) VALUES (<{lastInsertId: }>, <{pay_org: }>, <{pay_account: }>, <{pay_account_bank: }>, <{pay_acconunt_number: }>, <{pay_time: CURRENT_TIMESTAMP}>, <{real_pay_time: }>); |
