| main_params | 主参数 | | |
| main_params.bill_no | 单据编号 | {{stocktakeId}} | |
| main_params.status | 状态 | 1 | |
| main_params.stock_org_id | 库存组织 | findCollection find textField_l2ib4q9s from 0ce3a160-9fb2-36e5-a2ac-57f5ad0f3c72 where textField_l2ib4q9p={{warehouseCode}} | |
| main_params.date | 日期 | _function FROM_UNIXTIME( ( {{stocktakeDate}} / 1000 ) ,'%Y-%m-%d %T' ) | |
| main_params.bill_type_id | 单据类型 | PY01_SYS | |
| main_params.owner_type_id_head | 货主类型 | BD_OwnerOrg | |
| main_params.owner_id_head | 货主？？ | findCollection find textField_l2ib4q9s from 0ce3a160-9fb2-36e5-a2ac-57f5ad0f3c72 where textField_l2ib4q9p={{warehouseCode}} | |
| main_params.dept_id | 部门 | _findCollection find textField_l747atki from 0ce3a160-9fb2-36e5-a2ac-57f5ad0f3c72 where textField_l2ib4q9p={{warehouseCode}} | |
| main_params.stocker_id | 仓管员 | {{createName}} | |
| main_params.base_curr_id | 本位币 | 1 | |
| main_params.remark | 备注 | {{text}} | |
| main_params.create_time | 创建时间 | function FROM_UNIXTIME( ( {{stocktakeDate}} / 1000 ) ,'%Y-%m-%d %T' ) | |
| main_params.created_by | 创建者 | {{createName}} | |
| main_params.update_time | 更新时间 | _function FROM_UNIXTIME( ( {{stocktakeDate}} / 1000 ) ,'%Y-%m-%d %T' ) | |
| main_params.updated_by | 更新者 | {{createName}} | |
| main_params.extend_params_1 | 1:1扩展参数 | stockCountLoss | |
| main_params.extend_params_1.lastInsertId | order_id | :lastInsertId | |
| main_params.extend_params_1.material_id | 物料编码 | {{stockCountGain.goodsNo}} | |
| main_params.extend_params_1.unit_id | 单位 | Pcs | |
| main_params.extend_params_1.acct_qty | 账存数量 | {{stockCountGain.stockQuan intval}} | |
| main_params.extend_params_1.count_qty | 盘点数量 | {{stockCountGain.takeQuan intval}} | |
| main_params.extend_params_1.loss_qty | 盘亏数量?? | {{stockCountGain.variQuan intval}} | |
| main_params.extend_params_1.stock_id | 仓库 | {{warehouseId}} | |
| 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 | 货主?? | _findCollection find textField_l2ib4q9s from 0ce3a160-9fb2-36e5-a2ac-57f5ad0f3c72 where textField_l2ib4q9p={{warehouseCode}} | |
| main_params.extend_params_1.cost | 成本价?? | null | |
| main_params.extend_params_1.total_cost | 总成本?? | null | |
| main_params.extend_params_1.price | 价格 | | |
| main_params.extend_params_1.total_amount | 总量 | | |
| main_params.extend_params_1.remark | 备注 | {{stockCountGain.rowRemark}} | |
| main_params.extend_params_1.source_id | 源单id?? | null | |
| main_params.extend_params_1.source_detail_id | 源单明细行id?? | null | |
| main_params.extend_params_1.source_code | 源单单号?? | null | |
| main_params.extend_params_1.source_type | 源单类型?? | null | |
| main_params.extend_params_1.main_sql | 主语句 | INSERT INTO lehua.stock_count_loss ( bill_no, status, stock_org_id, date, bill_type_id, owner_type_id_head, owner_id_head, dept_id, stocker_id, base_curr_id, 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: }>, <{dept_id: }>, <{stocker_id: }>, <{base_curr_id: }>, <{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扩展语句 | INSERT INTO lehua.stock_count_loss_detail ( order_id, material_id, unit_id, acct_qty, count_qty, loss_qty, stock_id, stock_status_id, owner_type_id, owner_id, cost, total_cost, price, total_amount, remark, source_id, source_detail_id, source_code, source_type) VALUES ( <{lastInsertId: }>, <{material_id: }>, <{unit_id: }>, <{acct_qty: }>, <{count_qty: }>, <{loss_qty: }>, <{stock_id: }>, <{stock_status_id: }>, <{owner_type_id: }>, <{owner_id: }>, <{cost: }>, <{total_cost: }>, <{price: }>, <{total_amount: }>, <{remark: }>, <{source_id: }>, <{source_detail_id: }>, <{source_code: }>, <{source_type: }>); | |
