# `viw_purorder_slave_detail`（视图）


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

## 字段

| # | 名称 | 类型 | 可空 |
|---|---|---|---|
| 1 | `tDeliverDate` | `datetime` | YES |
| 2 | `sSrcId` | `varchar(100)` | NO |
| 3 | `sMaterialsId` | `varchar(100)` | NO |

## 定义

```sql
select `ppm`.`tDeliverDate` AS `tDeliverDate`,`pps`.`sSrcId` AS `sSrcId`,`pps`.`sMaterialsId` AS `sMaterialsId` from ((`xlyweberp_saas_ai`.`purpurchaseorderdetail` `ppd` join `xlyweberp_saas_ai`.`purpurchaseordermaster` `ppm` on((`ppm`.`sId` = `ppd`.`sParentId`))) join `xlyweberp_saas_ai`.`purpurchaseorderslave` `pps` on((`ppm`.`sId` = `pps`.`sParentId`)))
```

## 说明

_暂无人工说明。_
