# `viw_saldelivergoods_product`（视图）


- **是否可更新：** YES
- **定义者：** `xlyprint@%`

## 字段

| # | 名称 | 类型 | 可空 |
|---|---|---|---|
| 1 | `sBrandsId` | `varchar(50)` | NO |
| 2 | `sBillNo` | `varchar(255)` | NO |
| 3 | `sProductName` | `varchar(100)` | NO |
| 4 | `sId` | `varchar(100)` | NO |
| 5 | `sProductId` | `varchar(100)` | NO |
| 6 | `dProductPrice` | `decimal(18,6)` | NO |
| 7 | `dProductQty` | `decimal(18,6)` | NO |
| 8 | `sOrderId` | `varchar(100)` | NO |
| 9 | `sOrderSlaveId` | `varchar(100)` | NO |
| 10 | `dProductNoTaxMoney` | `decimal(18,6)` | YES |
| 11 | `dProductNoTaxPrice` | `decimal(18,6)` | YES |
| 12 | `dProductMoney` | `decimal(18,6)` | NO |
| 13 | `sProductStyle` | `varchar(50)` | NO |
| 14 | `sProductUnit` | `varchar(50)` | YES |

## 定义

```sql
select `e`.`sBrandsId` AS `sBrandsId`,`xlyweberp_saas_ai`.`v`.`sBillNo` AS `sBillNo`,`e`.`sProductName` AS `sProductName`,`xlyweberp_saas_ai`.`v`.`sSlaveId` AS `sId`,`xlyweberp_saas_ai`.`v`.`sProductId` AS `sProductId`,`xlyweberp_saas_ai`.`v`.`dProductPrice` AS `dProductPrice`,`xlyweberp_saas_ai`.`v`.`dProductQty` AS `dProductQty`,`xlyweberp_saas_ai`.`v`.`sOrderId` AS `sOrderId`,`xlyweberp_saas_ai`.`v`.`sOrderSlaveId` AS `sOrderSlaveId`,`xlyweberp_saas_ai`.`v`.`dProductNoTaxMoney` AS `dProductNoTaxMoney`,`xlyweberp_saas_ai`.`v`.`dProductNoTaxPrice` AS `dProductNoTaxPrice`,`xlyweberp_saas_ai`.`v`.`dProductMoney` AS `dProductMoney`,`e`.`sProductStyle` AS `sProductStyle`,`e`.`sProductUnit` AS `sProductUnit` from (`xlyweberp_saas_ai`.`viw_saldelivergoods` `v` join `xlyweberp_saas_ai`.`eleproduct` `e`) where (`xlyweberp_saas_ai`.`v`.`sProductId` = `e`.`sId`)
```

## 说明

_暂无人工说明。_
