|
1
|
HUKE163
|
固定值 |
shop_code
|
店铺代码 |
|
|
2
|
_findCollection find new_id from aca0e273-c1e3-32de-881f-e66536a69466 where FNumber=FSalerId_FNumber
|
关联查询函数 |
vip_code
|
会员代码 |
|
|
3
|
FBillNo
|
单据编号 |
platform_code
|
平台单号 |
|
|
4
|
_function case 'FSOStockId_Fnumber' when '' then 'CK00001' else 'FSOStockId_Fnumber'end
|
计算函数 |
warehouse_code
|
仓库代码 |
|
|
5
|
FSalerId
|
固定值 |
business_man_code
|
业务员 |
|
|
6
|
|
固定值 |
express_code
|
物流公司 |
|
|
7
|
_function DATE_FORMAT('FDate','%Y-%m-%d %h:%i:%s')
|
计算函数 |
deal_datetime
|
拍单时间 |
|
|
8
|
Sales
|
固定值 |
order_type_code
|
订单类型 |
|
|
9
|
FCustId_FName
|
客户 |
receiver_name
|
收货人 |
|
|
10
|
_function case when 'F_VYVH_Combo'='是' and 'F_VYVH_Text' !=' ' then 'F_VYVH_Text' when 'F_VYVH_Text5'= ' ' then 'FLinkPhone' else 'F_VYVH_Text5' end
|
计算函数 |
receiver_mobile
|
手机号码 |
|
|
11
|
|
固定值 |
receiver_zip
|
邮政编码 |
|
|
12
|
_function case 'receiver_province' when '' then '' else 'receiver_province'end
|
计算函数 |
receiver_province
|
省名称 |
|
|
13
|
_function case 'receiver_city' when '' then '' else 'receiver_city'end
|
计算函数 |
receiver_city
|
市名称 |
|
|
14
|
_function case 'receiver_district' when '' then '' else 'receiver_district'end
|
计算函数 |
receiver_district
|
区名称 |
|
|
15
|
receiver_provincereceiver_cityreceiver_districtFReceiveAddress，如需转播请输：F_VYVH_Text3
|
固定值 |
receiver_address
|
收货地址 |
|
|
16
|
FNote
|
备注 |
extend_memo
|
附加信息 |
|
|
17
|
_findCollection find FName from aca0e273-c1e3-32de-881f-e66536a69466 where FStaffNumber=FSalerId_FNumber
|
关联查询函数 |
seller_memo_late
|
二次备注 |
|
|
18
|
reftables
|
固定值 |
details
|
商品明细 |
|
|
19
|
reftables.FMaterialId_Fnumber
|
固定值 |
details.item_code
|
商品代码 |
|
|
20
|
reftables.FTaxPrice
|
固定值 |
details.price
|
实际单价 |
|
|
21
|
reftables.FPriceUnitQty
|
固定值 |
details.qty
|
商品数量 |
|
|
22
|
reftables.FNote
|
固定值 |
details.note
|
备注 |
|
|
23
|
FBillNoreftables.FMaterialId_Fnumber
|
固定值 |
details.oid
|
子订单 |
|
|
24
|
reftables.FTaxPrice
|
固定值 |
details.origin_price
|
标准单价 |
|
|
25
|
|
固定值 |
payments
|
支付明细 |
|
|
26
|
_function case when 'F_hKFKFS' like '%代收货款%' then 'cod' else 'onlinepay' end
|
计算函数 |
payments.pay_type_code
|
支付方式 |
|
|
27
|
_function case when 'F_UROZ_Amount2' = '' then 0 when 'F_hKFKFS' like '%代收货款%' then 'F_UROZ_Amount2' else 'F_UROZ_Amount2' end
|
计算函数 |
payments.payment
|
支付金额 |
|
|
28
|
_function case when 'F_hKFKFS' like '%代收货款%' then 'true' else 'false' end
|
计算函数 |
cod
|
是否货到付款 |
|
|
29
|
F_BCYS_Logistics
|
互客物流公司 |
seller_memo
|
卖家备注 |
|
|
30
|
_function case 'FBillTypeID_Fnumber' when 'XSDD14_SYS' then '系统对接-礼品单' else '' end
|
计算函数 |
buyer_memo
|
买家留言 |
|
