crm->erp,接口映射crm表头字段到erp的分录字段,erp的每一行分录显示的值都和crm表头字段值一样
1、lianjieerp新增字段界面,字段位置选择“单据分录”,crm字段选择“crm分录表关联主表ID”字段,取值方法选择“SQL查询”
2、配置SQL,写SQL查询需要映射到erp的表头字段的值,
例:销售订单接口:
SELECT
cf_1147
FROM ld_salesorder a
LEFT JOIN ld_salesordercf b on a.salesorderid=b.salesorderid
WHERE deleted = 0
AND a.salesorderid =?
3、erp字段选择需要映射的erp字段即可