main_params | 主参数 | object | |
main_params.bill_no | 单据编号 | string | {{allocateNo}} |
main_params.status | 状态 | string | 1 |
main_params.stock_org_id | 调入库存组织 | string | findCollection find textField_l2ib4q9s from 2bcf5aa6-6c81-39a8-b8a2-b97d6432bff9 where textField_l2ib4q9p={{intWarehouseCode}} |
main_params.date | 日期 | string | _function FROM_UNIXTIME( ( {{auditDate}} / 1000 ) ,'%Y-%m-%d %T' ) |
main_params.bill_type_id | 单据类型 | string | ZJDB01_SYS |
main_params.owner_type_id_head | 调入货主类型 | string | BD_OwnerOrg |
main_params.owner_id_head | 调入货主?? | string | findCollection find textField_l2ib4q9s from 2bcf5aa6-6c81-39a8-b8a2-b97d6432bff9 where textField_l2ib4q9p={{intWarehouseCode}} |
main_params.transfer_type | 调拨类型 | string | InnerOrgTransfer |
main_params.stock_out_org_id | 调出库存组织 | string | _findCollection find textField_l2ib4q9s from 2bcf5aa6-6c81-39a8-b8a2-b97d6432bff9 where textField_l2ib4q9p={{outWarehouseCode}} |
main_params.owner_type_out_id_head | 调出货主类型 | string | BD_OwnerOrg |
main_params.owner_out_id_head | 调出货主?? | string | findCollection find textField_l2ib4q9s from 2bcf5aa6-6c81-39a8-b8a2-b97d6432bff9 where textField_l2ib4q9p={{outWarehouseCode}} |
main_params.transfer_direction | 调拨方向 | string | GENERAL |
main_params.remark | 备注 | string | {{memo}} |
main_params.create_time | 创建时间 | string | _function FROM_UNIXTIME( ( {{gmtCreate}} / 1000 ) ,'%Y-%m-%d %T' ) |
main_params.created_by | 创建者 | string | {{applyUserName}} |
main_params.update_time | 更新时间 | string | _function FROM_UNIXTIME( ( {{auditDate}} / 1000 ) ,'%Y-%m-%d %T' ) |
main_params.updated_by | 更新者 | string | {{auditUserName}} |
main_params.extend_params_1 | 1:1扩展参数 | array | stockAllocateDetailViews |
main_params.extend_params_1.lastInsertId | order_id | string | :lastInsertId |
main_params.extend_params_1.material_id | 物料编码 | string | {{stockAllocateDetailViews.goodsNo}} |
main_params.extend_params_1.src_stock_id | 调出仓库 | string | {{outWarehouseId}} |
main_params.extend_params_1.dest_stock_id | 调入仓库 | string | {{inWarehouseId}} |
main_params.extend_params_1.unit_id | 单位id | string | Pcs |
main_params.extend_params_1.qty | 数量 | string | {{stockAllocateDetailViews.skuCount}} |
main_params.extend_params_1.remark | 备注 | string | {{stockAllocateDetailViews.rowRemark}} |
main_params.extend_params_1.source_id | 源单id?? | string | |
main_params.extend_params_1.source_detail_id | 源单明细行id?? | string | |
main_params.extend_params_1.source_code | 源单单号?? | string | |
main_params.extend_params_1.source_type | 源单类型?? | string | |
main_params.extend_params_1.main_sql | 主语句 | string | INSERT INTO lehua .wh_transfer_direct ( bill_no , status , stock_org_id , date , bill_type_id , owner_type_id_head , owner_id_head , transfer_type , stock_out_org_id , owner_type_out_id_head , owner_out_id_head , transfer_direction , remark , create_time , created_by , update_time , updated_by ) VALUES ( <{bill_no: }>, <{status: }>, <{stock_org_id: }>, <{date: CURRENT_TIMESTAMP}>, <{bill_type_id: }>, <{owner_type_id_head: }>, <{owner_id_head: }>, <{transfer_type: }>, <{stock_out_org_id: }>, <{owner_type_out_id_head: }>, <{owner_out_id_head: }>, <{transfer_direction: }>, <{remark: }>, <{create_time: 0000-00-00 00:00:00}>, <{created_by: }>, <{update_time: 0000-00-00 00:00:00}>, <{updated_by: }>); |
main_params.extend_params_1.extend_sql_1 | 1:1扩展语句 | string | INSERT INTO lehua .wh_transfer_direct_detail ( order_id , material_id , src_stock_id , dest_stock_id , unit_id , qty , remark , source_id , source_detail_id , source_code , source_type ) VALUES ( <{lastInsertId: }>, <{material_id: }>, <{src_stock_id: }>, <{dest_stock_id: }>, <{unit_id: }>, <{qty: }>, <{remark: }>, <{source_id: }>, <{source_detail_id: }>, <{source_code: }>, <{source_type: }>); |