|
1
|
_function REPLACE('shop_codereceive_date_new1','-','')
|
计算函数 |
SheetID
|
SheetID |
|
|
2
|
receive_date_new
|
固定值 |
SheetDate
|
SheetDate |
|
|
3
|
shop_code
|
店铺代码 |
CustomerCode
|
CustomerCode |
|
|
4
|
shop_name
|
店铺名称 |
CustomerName
|
CustomerName |
|
|
5
|
true
|
固定值 |
RedBlue
|
RedBlue |
|
|
6
|
|
固定值 |
Qua
|
Qua |
|
|
7
|
|
固定值 |
Amo
|
Amo |
|
|
8
|
|
固定值 |
Remark
|
Remark |
|
|
9
|
details
|
固定值 |
Items
|
Items |
|
|
10
|
details.details_qty
|
固定值 |
Items.Qua
|
Qua |
|
|
11
|
details.details_item_code
|
固定值 |
Items.GoodsID
|
GoodsID |
|
|
12
|
_function round(details.details_amount_after/details.details_qty,6)
|
计算函数 |
Items.Price
|
Price |
|
|
13
|
details.details_amount_after
|
固定值 |
Items.Amo
|
Amo |
|
|
14
|
|
固定值 |
Items.Remark
|
Remark |
|
