main_params | 主表参数 | | |
main_params.djbh | 单号编号 | {{number}} | |
main_params.djlx | 采购入库传CGC 销售退回传XHH | CGC | |
main_params.rq | 日期 | {{auditTime date}} | |
main_params.ontime | 时间 | {{auditTime time}} | |
main_params.wldwid | 单位内码 | WLD00002110 | |
main_params.hsje | 含税金额 | {{itemList.taxlastmoney}} | |
main_params.shouhr | 收货人 | {{recvContact}} | |
main_params.shhdz | 地址 | {{recvAddr}} | |
main_params.lxdh | 联系电话 | {{recvTel}} | |
main_params.beizhu | 备注 | 订单备注:{{remark}} | |
main_params.webdjbh | 营销云单号 | {{yxyNumber}} | |
main_params.extend_params_1 | 扩展表参数 | itemList | |
main_params.extend_params_1.djbh | 单号 | {{number}} | |
main_params.extend_params_1.dj_sn | 序号 | {{oSn}} | |
main_params.extend_params_1.spid | 商品内码 | findCollection find spid from d76b64f9-f0e0-3436-a2d9-14c5579faa1b where spbh2={{extMaterialNo}} | |
main_params.extend_params_1.ckid | 仓库编号 | {{itemList.depotNo}} | |
main_params.extend_params_1.pihao | 批号 | {{itemList.lot}} | |
main_params.extend_params_1.sxrq | 效期 | {{itemList.exp}} | |
main_params.extend_params_1.baozhiqi | 生产日期 | {{itemList.mfg}} | |
main_params.extend_params_1.shl | 数量 数量大于0 | {{itemList.opernumber}} | |
main_params.extend_params_1.hshj | 含税价 | _function {{itemList.taxlastmoney}}/{{itemList.opernumber}} | |
main_params.extend_params_1.hsje | 含税金额 | {{itemList.taxlastmoney}} | |
main_params.extend_params_1.xgdjbh | 相关单号,如果退回,采购退 等原来的单号 | {{yxyNumber}} | |
main_params.extend_params_1.recnum | 相关序号 如果退回,采购退 等对应明细的那个序号 | {{oSn}} | |
main_params.extend_params_1.hzid | 组织ID | {{orgId}} | |
main_params.extend_params_1.ckname | 仓库名称 | {{tenantName}} | |
main_params.extend_params_1.main_sql | 主SQL语句 | INSERT INTO gxkphz (djbh,djlx,rq,ontime,wldwid,hsje,shouhr,shhdz,lxdh,beizhu,webdjbh) values ( :djbh,:djlx,:rq,:ontime,:wldwid,:hsje,:shouhr,:shhdz,:lxdh,:beizhu,:webdjbh) | |
main_params.extend_params_1.extend_sql_1 | 扩展SQL语句1 | 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) | |