main_params | 主表参数 | object | |
main_params.djbh | 单号编号 | string | {{number}} |
main_params.djlx | 采购入库传CGC 销售退回传XHH | string | XHH |
main_params.rq | 日期 | string | {{auditTime date}} |
main_params.ontime | 时间 | string | {{auditTime time}} |
main_params.wldwid | 单位内码 | string | {{extCusCode}} |
main_params.hsje | 含税金额 | string | {{itemList.taxlastmoney}} |
main_params.beizhu | 备注 | string | {{remark}} |
main_params.webdjbh | 原始单号 | string | {{othernumber}} |
main_params.extend_params_1 | 扩展表参数 | array | itemList |
main_params.extend_params_1.djbh | 单号 | string | {{number}} |
main_params.extend_params_1.dj_sn | 序号 | string | {{oSn}} |
main_params.extend_params_1.spid | 商品内码 | string | _findCollection find spid from d76b64f9-f0e0-3436-a2d9-14c5579faa1b where spbh2={{extMaterialNo}} |
main_params.extend_params_1.ckid | 仓库编号 | string | {{itemList.depotNo}} |
main_params.extend_params_1.pihao | 批号 | string | {{itemList.lot}} |
main_params.extend_params_1.sxrq | 效期 | string | {{itemList.exp}} |
main_params.extend_params_1.baozhiqi | 生产日期 | string | {{itemList.mfg}} |
main_params.extend_params_1.shl | 数量 数量大于0 | string | {{itemList.opernumber}} |
main_params.extend_params_1.hshj | 含税价 | string | {{itemList.taxunitprice}} |
main_params.extend_params_1.hsje | 含税金额 | string | {{itemList.taxlastmoney}} |
main_params.extend_params_1.xgdjbh | 相关单号,如果退回,采购退 等原来的单号 | string | {{othernumber}} |
main_params.extend_params_1.recnum | 相关序号 如果退回,采购退 等对应明细的那个序号 | string | {{oSn}} |
main_params.extend_params_1.hzid | 组织ID | string | {{orgId}} |
main_params.extend_params_1.ckname | 仓库名称 | string | {{tenantName}} |
main_params.extend_params_1.main_sql | 主SQL语句 | string | INSERT INTO gxkphz (djbh,djlx,rq,ontime,wldwid,hsje,beizhu,webdjbh) values ( :djbh,:djlx,:rq,:ontime,:wldwid,:hsje,:beizhu,:webdjbh) |
main_params.extend_params_1.extend_sql_1 | 扩展SQL语句1 | string | INSERT INTO gxkpmx (djbh,dj_sn,spid,ckid,pihao,sxrq,baozhiqi,shl,hshj,hsje,xgdjbh,recnum,hzid,ckname) values ( :djbh,:dj_sn,:spid,:ckid,:pihao,:sxrq,:baozhiqi,:shl,:hshj,:hsje,:xgdjbh,:recnum,:hzid,:ckname) |