number | 商品编码 | string | {{product_no}} |
name | 商品名称 | string | {{name}} |
baseunitid_id | 计量单位id | string | findCollection find id from 73a0290e-d0a1-3986-ad70-e310c13fd0e8 where number={{unit}} |
checktype | 商品类型 | string | _function case '{{product_type}}' when '2' then '1' when '1' then '1' when '3' then '2' else '3' end |
parent_id | 商品类别id | string | findCollection find id from 258d3d84-637b-30c7-b585-1e1dad9f2337 where name={{group_id}} |
model | 规格型号 | string | {{model}} |
priceentity | 商品价格 | array | |
priceentity.price_unitid_id | 单位 | string | _findCollection find id from 73a0290e-d0a1-3986-ad70-e310c13fd0e8 where number={{unit}} |
priceentity.price_minsalesprice | 最低销售价 | string | {{fob.price_min}} |
priceentity.gross_weight | 毛重 | string | {{package_gross_weight}} |
priceentity.volume | 体积 | string | {{package_volume}} |
priceentity.remark | 备注 | string | {{product_remark}} |
priceentity.issubpart | 可为子件 | string | true |
priceentity.isasstattr | 是否启用辅助属性 | string | function case when '{{product_type}}'='2' then 'true' else 'false' end |
priceentity.bomentity | 套装属性 | array | sub_product_sku_items |
priceentity.bomentity.materialid_number | 物料编码 | string | {{sub_product_sku_items.product_no}} |
priceentity.bomentity.price | 价格 | string | {{sub_product_sku_items.cost_with_tax.cost}} |
priceentity.bomentity.bomaux_number | SKU编码 | string | _function case '{{sub_product_sku_items.product_type}}' when '1' then '' else '{{sub_product_sku_items.sku_code}}' end |
priceentity.bomentity.qty | 数量 | string | {{sub_product_sku_items.count}} |
priceentity.bomentity.bomaux_id | 单位id | string | findCollection find id from 73a0290e-d0a1-3986-ad70-e310c13fd0e8 where number={{sub_product_sku_items.unit}} |
priceentity.bomentity.rate | 税率 | string | |
priceentity.bomentity.amount | 金额 | string | _function {{sub_product_sku_items.cost_with_tax.cost}}*{{sub_product_sku_items.count}} |
priceentity.bomentity.unitid_id | 单位1id | string | findCollection find id from 73a0290e-d0a1-3986-ad70-e310c13fd0e8 where number={{sub_product_sku_items.unit}} |
priceentity.bomentity.costamount | costamount | string | |
priceentity.bomentity.materialid_baseunitid_id | materialid_baseunitid_id | string | |
priceentity.bomentity.isfree | isfree | string | _function case '{{sub_product_sku_items.cost_with_tax.cost}}' when '0.0000' then 'true' else 'false' end |
priceentity.bomentity.isreplace | isreplace | string | false |
priceentity.bomentity.seq | seq | string | 2 |
priceentity.bomentity.bomauxid1_parent_id | bomauxid1_parent_id | string | 1 |
priceentity.bomentity.bomauxid1_groupid_number | bomauxid1_groupid_number | string | 01 |
priceentity.bomentity.bomauxid1_number | 属性编码 | string | function case when '{{sub_product_sku_items.属性组1}}'='' then '' else 'findCollection find number from f23aef21-bbe9-34bc-93d9-49d70daf120d where name={{sub_product_sku_items.属性组1}} endFind' end |
priceentity.bomentity.bomaux_auxid1_number | 属性值编码 | string | _function case when '{{sub_product_sku_items.属性组1}}'='' then '' else '_findCollection find number from f23aef21-bbe9-34bc-93d9-49d70daf120d where name={{sub_product_sku_items.属性组1}} endFind' end |
priceentity.bomentity.bomaux_auxid1_id | 属性值id | string | _function case when '{{sub_product_sku_items.属性组1}}'='' then '' else '_findCollection find id from f23aef21-bbe9-34bc-93d9-49d70daf120d where name={{sub_product_sku_items.属性组1}} endFind' end |
priceentity.bomentity.bomauxid1_id | 属性值id | string | _function case when '{{sub_product_sku_items.属性组1}}'='' then '' else '_findCollection find id from f23aef21-bbe9-34bc-93d9-49d70daf120d where name={{sub_product_sku_items.属性组1}} endFind' end |
priceentity.bomentity.bomauxid1_parent_number | bomauxid1_parent_number | string | 01 |
priceentity.bomentity.bomauxid1_groupid_id | bomauxid1_groupid_id | string | 1 |
priceentity.bomentity.bomauxid2_parent_id | bomauxid2_parent_id | string | 2 |
priceentity.bomentity.bomauxid2_groupid_number | bomauxid2_groupid_number | string | 02 |
priceentity.bomentity.bomauxid2_number | 属性编码 | string | _function case when '{{sub_product_sku_items.属性组2}}'='' then '' else '_findCollection find number from f23aef21-bbe9-34bc-93d9-49d70daf120d where name={{sub_product_sku_items.属性组2}} endFind' end |
priceentity.bomentity.bomaux_auxid2_number | 属性值编码 | string | _function case when '{{sub_product_sku_items.属性组2}}'='' then '' else '_findCollection find number from f23aef21-bbe9-34bc-93d9-49d70daf120d where name={{sub_product_sku_items.属性组2}} endFind' end |
priceentity.bomentity.bomaux_auxid2_id | 属性值id | string | _function case when '{{sub_product_sku_items.属性组2}}'='' then '' else '_findCollection find id from f23aef21-bbe9-34bc-93d9-49d70daf120d where name={{sub_product_sku_items.属性组2}} endFind' end |
priceentity.bomentity.bomauxid2_id | 属性值id | string | _function case when '{{sub_product_sku_items.属性组2}}'='' then '' else '_findCollection find id from f23aef21-bbe9-34bc-93d9-49d70daf120d where name={{sub_product_sku_items.属性组2}} endFind' end |
priceentity.bomentity.bomauxid2_parent_number | bomauxid2_parent_number | string | 02 |
priceentity.bomentity.bomauxid2_groupid_id | bomauxid2_groupid_id | string | 2 |
priceentity.bomentity.bomauxid3_parent_id | bomauxid3_parent_id | string | 3 |
priceentity.bomentity.bomauxid3_groupid_number | bomauxid3_groupid_number | string | 03 |
priceentity.bomentity.bomauxid3_number | 属性编码 | string | _function case when '{{sub_product_sku_items.属性组3}}'='' then '' else '_findCollection find number from f23aef21-bbe9-34bc-93d9-49d70daf120d where name={{sub_product_sku_items.属性组3}} endFind' end |
priceentity.bomentity.bomaux_auxid3_number | 属性值编码 | string | _function case when '{{sub_product_sku_items.属性组3}}'='' then '' else '_findCollection find number from f23aef21-bbe9-34bc-93d9-49d70daf120d where name={{sub_product_sku_items.属性组3}} endFind' end |
priceentity.bomentity.bomaux_auxid3_id | 属性值id | string | _function case when '{{sub_product_sku_items.属性组3}}'='' then '' else '_findCollection find id from f23aef21-bbe9-34bc-93d9-49d70daf120d where name={{sub_product_sku_items.属性组3}} endFind' end |
priceentity.bomentity.bomauxid3_id | 属性值id | string | _function case when '{{sub_product_sku_items.属性组3}}'='' then '' else '_findCollection find id from f23aef21-bbe9-34bc-93d9-49d70daf120d where name={{sub_product_sku_items.属性组3}} endFind' end |
priceentity.bomentity.bomauxid3_parent_number | bomauxid3_parent_number | string | 04 |
priceentity.bomentity.bomauxid3_groupid_id | bomauxid3_groupid_id | string | 4 |
priceentity.bomentity.bomauxid4_parent_id | bomauxid4_parent_id | string | 4 |
priceentity.bomentity.bomauxid4_groupid_number | bomauxid4_groupid_number | string | 04 |
priceentity.bomentity.bomauxid4_number | 属性编码 | string | _function case when '{{sub_product_sku_items.属性组4}}'='' then '' else '_findCollection find number from f23aef21-bbe9-34bc-93d9-49d70daf120d where name={{sub_product_sku_items.属性组4}} endFind' end |
priceentity.bomentity.bomaux_auxid4_number | 属性值编码 | string | _function case when '{{sub_product_sku_items.属性组4}}'='' then '' else '_findCollection find number from f23aef21-bbe9-34bc-93d9-49d70daf120d where name={{sub_product_sku_items.属性组4}} endFind' end |
priceentity.bomentity.bomaux_auxid4_id | 属性值id | string | _function case when '{{sub_product_sku_items.属性组4}}'='' then '' else '_findCollection find id from f23aef21-bbe9-34bc-93d9-49d70daf120d where name={{sub_product_sku_items.属性组4}} endFind' end |
priceentity.bomentity.bomauxid4_id | 属性值id | string | _function case when '{{sub_product_sku_items.属性组4}}'='' then '' else '_findCollection find id from f23aef21-bbe9-34bc-93d9-49d70daf120d where name={{sub_product_sku_items.属性组4}} endFind' end |
priceentity.bomentity.bomauxid4_parent_number | bomauxid4_parent_number | string | 05 |
priceentity.bomentity.bomauxid4_groupid_id | bomauxid4_groupid_id | string | 5 |
priceentity.bomentity.bomauxid5_parent_id | bomauxid5_parent_id | string | 5 |
priceentity.bomentity.bomauxid5_groupid_number | bomauxid5_groupid_number | string | 05 |
priceentity.bomentity.bomauxid5_number | 属性编码 | string | _function case when '{{sub_product_sku_items.属性组5}}'='' then '' else '_findCollection find number from f23aef21-bbe9-34bc-93d9-49d70daf120d where name={{sub_product_sku_items.属性组5}} endFind' end |
priceentity.bomentity.bomaux_auxid5_number | 属性值编码 | string | _function case when '{{sub_product_sku_items.属性组5}}'='' then '' else '_findCollection find number from f23aef21-bbe9-34bc-93d9-49d70daf120d where name={{sub_product_sku_items.属性组5}} endFind' end |
priceentity.bomentity.bomaux_auxid5_id | 属性值id | string | _function case when '{{sub_product_sku_items.属性组5}}'='' then '' else '_findCollection find id from f23aef21-bbe9-34bc-93d9-49d70daf120d where name={{sub_product_sku_items.属性组5}} endFind' end |
priceentity.bomentity.bomauxid5_id | 属性值id | string | _function case when '{{sub_product_sku_items.属性组5}}'='' then '' else '_findCollection find id from f23aef21-bbe9-34bc-93d9-49d70daf120d where name={{sub_product_sku_items.属性组5}} _endFind' end |
priceentity.bomentity.bomauxid5_parent_number | bomauxid5_parent_number | string | 05 |
priceentity.bomentity.bomauxid5_groupid_id | bomauxid5_groupid_id | string | 5 |
priceentity.bomentity.materialid_id | materialid_id | string | 1514377262059799552 |
priceentity.bomentity.weight_unit_id | 重量单位 | string | 1540583584643964928 |
priceentity.bomentity.volume_unit_id | 体积单位 | string | 1540583333623259136 |