FBillNo | 单据编号 | {{tid}} | |
FSaleOrgId | 销售组织 | 100 | |
FDate | 日期 | {{createTime_new}} | |
FCustId | 客户 | {{buyerCid}} | |
FBillTypeID | 单据类型 | function case '{{单据类型(必选)}}' when '定金单' then 'XSDD12_SYS' when '全款单' then 'XSDD13_SYS' when '礼品单' then 'XSDD14_SYS' when '未收款单' then 'XSDD15_SYS' end | |
FNote | 备注 | {{remark}} | |
FLinkMan | 收货人姓名 | _function case '{{物流订单客户姓名}}' when '' then '{{buyerNick}}' else '{{物流订单客户姓名}}' end | |
FLinkPhone | 联系电话 | function case '{{物流订单客户电话}}' when '' then '{{buyerMobile}}' else '{{物流订单客户电话}}' end | |
FReceiveAddress | 联系地址 | _function case '{{物流订单客户地址}}' when '' then '{{buyerAddress}}' else '{{物流订单客户地址}}' end | |
FSaleOrderEntry | 订单明细 | orders | |
FSaleOrderEntry.FMaterialId | 物料编码 | {{orders.outerId}} | |
FSaleOrderEntry.FQty | 销售数量 | {{orders.quantity}} | |
FSaleOrderEntry.FPrice | 单价 | function case '{{orders.payPrice}}' when '0' then '{{orders.price}}'/100 else '{{orders.payPrice}}'/100 end | |
FSaleOrderEntry.FTaxPrice | 含税单价 | _function case '{{orders.payPrice}}' when '0' then '{{orders.price}}'/100 else '{{orders.payPrice}}'/100 end | |
FSaleOrderEntry.FSettleOrgIds | 结算组织 | 100 | |
FSaleOrderEntry.FEntryNote | 回款金额 | {{PayBacks.kuaididaishou}} | |
FSaleOrderEntry.F_BCYS_Amount2 | 管易实际单价 | function case '{{PayBacks.avg_price}}' when '0' then '{{PayBacks.kuaididaishou}}' else '{{PayBacks.avg_price}}'/100 end | |
FSaleOrderEntry.FIsFree | FIsFree | _function case '{{payPrice}}' when '0' then 'true' else 'false' end | |
FSaleOrderEntry.FSalerId | 销售员 | findCollection find FStaffNumber from aca0e273-c1e3-32de-881f-e66536a69466 where FNumber={{dealer}} | |
FSaleOrderEntry.FSaleOrderFinance | 财务信息 | | |
FSaleOrderEntry.FSaleOrderFinance.FRecConditionId | 收款条件 | {{交货方式(必选)}} | |
FSaleOrderEntry.FSaleOrderFinance.FAllDisCount | 整单折扣 | | |
FSaleOrderEntry.FSaleOrderFinance.F_BCYS_BillType1 | 互客单据类型 | {{单据类型(必选)}} | |
FSaleOrderEntry.FSaleOrderFinance.F_BCYS_Logistics | 互客物流公司 | {{物流公司}} | |
FSaleOrderEntry.FSaleOrderFinance.F_BCYS_Payback | 互客回款金额 | _function '{{PayBacks.payBackAmount}}'/100 | |
FSaleOrderEntry.FSaleOrderFinance.F_UROZ_Amount3 | 已收订金金额合计 | function '{{PayBacks.payBackAmount}}'/100 | |
FSaleOrderEntry.FSaleOrderFinance.F_UROZ_Amount2 | 剩余金额 | _function case '{{单据类型(必选)}}' when '礼品单' then '0' else '{{PayBacks.kuaididaishou}}' end | |
FSaleOrderEntry.FSaleOrderFinance.F_QELC_Text4 | 物流订单客户电话 | {{buyerMobile}} | |
FSaleOrderEntry.FSaleOrderFinance.F_UROZ_Text | 存储链接 | function substring_index('{{PayBacks.0.proof}}',';',-1) | |
FSaleOrderEntry.FSaleOrderFinance.FSaleOrderPlan | FSaleOrderPlan | | |
FSaleOrderEntry.FSaleOrderFinance.FSaleOrderPlan.F_UROZ_Amount | 已收订金金额合计 | _function '{{PayBacks.payBackAmount}}'/100 | |
FSaleOrderEntry.FSaleOrderFinance.FSaleOrderPlan.F_UROZ_Amount1 | 剩余金额 | _function case '{{单据类型(必选)}}' when '礼品单' then '0' else '{{PayBacks.kuaididaishou}}' end | |
FSaleOrderEntry.FSaleOrderFinance.FSaleOrderPlan.F_hKFKFS | F_hKFKFS | {{付款方式(必选)}} | |
FSaleOrderEntry.FSaleOrderFinance.FSaleOrderPlan.FormId | 业务对象表单Id | SAL_SaleOrder | 必须填写金蝶的表单ID如😛UR_PurchaseOrder |
FSaleOrderEntry.FSaleOrderFinance.FSaleOrderPlan.Operation | 执行的操作 | BatchSave | |
FSaleOrderEntry.FSaleOrderFinance.FSaleOrderPlan.IsAutoSubmitAndAudit | 提交并审核 | false | |
FSaleOrderEntry.FSaleOrderFinance.FSaleOrderPlan.IsVerifyBaseDataField | 验证基础资料 | false | 是否验证所有的基础资料有效性,布尔类,默认false(非必录) |