| main_params | 主参数 | | |
| main_params.bill_no | 单据编号 | {{goodsdocNo}} | |
| main_params.status | 状态 | 1 | |
| main_params.stock_org_id | 库存组织 | findCollection find textField_l2ib4q9s from 2bcf5aa6-6c81-39a8-b8a2-b97d6432bff9 where textField_l2ib4q9p={{warehouseCode}} | |
| main_params.date | 日期 | _function FROM_UNIXTIME( ( {{inOutDate}} / 1000 ) ,'%Y-%m-%d %T' ) | |
| main_params.bill_type_id | 单据类型 | QTCKD01_SYS | |
| main_params.owner_type_id_head | 货主类型 | BD_OwnerOrg | |
| main_params.owner_id_head | 货主 | {{companyCode}} | |
| main_params.stock_direction | 库存方向 | GENERAL | |
| main_params.dept_id | 领料部门 | {{departCode}} | |
| main_params.picker_id | 领料人 | {{userName}} | |
| main_params.stocker_id | 仓管员 | {{userName}} | |
| main_params.remark | 备注 | {{comment}} | |
| main_params.create_time | 创建时间 | function FROM_UNIXTIME( ( {{gmtCreate}} / 1000 ) ,'%Y-%m-%d %T' ) | |
| main_params.created_by | 创建者 | {{userName}} | |
| main_params.update_time | 更新时间 | _function from_unixtime(({{gmtModified}}),'%Y-%m-%d %h:%i:%s') | |
| main_params.updated_by | 更新者 | {{userName}} | |
| main_params.inOutReason | 出库原因 | {{inOutReason}} | |
| main_params.extend_params_1 | 1:1扩展参数 | goodsDocDetailList | |
| main_params.extend_params_1.lastInsertId | order_id | :lastInsertId | |
| main_params.extend_params_1.material_id | 物料编码 | {{goodsDocDetailList.goodsNo}} | |
| main_params.extend_params_1.stock_id | 仓库 | {{warehouseCode}} | |
| main_params.extend_params_1.stock_status_id | 库存状态 | 1 | |
| main_params.extend_params_1.owner_type_id | 货主类型 | BD_OwnerOrg | |
| main_params.extend_params_1.owner_id | 货主 | {{companyCode}} | |
| main_params.extend_params_1.qty | 数量 | {{goodsDocDetailList.quantity}} | |
| main_params.extend_params_1.price | 价格 | _function case when'{{goodsDocDetailList.cuPrice}}' ='' then '0' else '{{goodsDocDetailList.cuPrice}}' end | |
| main_params.extend_params_1.unit_id | 单位id | Pcs | |
| main_params.extend_params_1.base_unit_id | 基础单位 | {{goodsDocDetailList.assistUnit}} | |
| main_params.extend_params_1.total_amount | 总成本 | | |
| main_params.extend_params_1.source_id | 源单id?? | | |
| main_params.extend_params_1.source_detail_id | 源单明细行id?? | | |
| main_params.extend_params_1.source_code | 源单单号?? | {{sourceBillNo}} | |
| main_params.extend_params_1.source_type | 源单类型?? | | |
| main_params.extend_params_1.main_sql | 主语句 | INSERT INTO lehua.wh_other_out ( bill_no, status, stock_org_id, date, bill_type_id, owner_type_id_head, owner_id_head, stock_direction, dept_id, picker_id, stocker_id, remark, create_time, created_by, update_time, updated_by, inOutReason) VALUES ( <{bill_no: }>, <{status: }>, <{stock_org_id: }>, <{date: CURRENT_TIMESTAMP}>, <{bill_type_id: }>, <{owner_type_id_head: }>, <{owner_id_head: }>, <{stock_direction: }>, <{dept_id: }>, <{picker_id: }>, <{stocker_id: }>, <{remark: }>, <{create_time: 0000-00-00 00:00:00}>, <{created_by: }>, <{update_time: 0000-00-00 00:00:00}>, <{updated_by: }>, <{inOutReason: }>); | |
| main_params.extend_params_1.extend_sql_1 | 1:1扩展语句 | INSERT INTO lehua.wh_other_out_detail ( order_id, material_id, stock_id, stock_status_id, owner_type_id, owner_id, qty, price, unit_id, base_unit_id, total_amount, source_id, source_detail_id, source_code, source_type) VALUES ( <{lastInsertId: }>, <{material_id: }>, <{stock_id: }>, <{stock_status_id: }>, <{owner_type_id: }>, <{owner_id: }>, <{qty: }>, <{price: }>, <{unit_id: }>, <{base_unit_id: }>, <{total_amount: }>, <{source_id: }>, <{source_detail_id: }>, <{source_code: }>, <{source_type: }>); | |
