# `viw_purorder_slave_detail` (view)


- **Updatable:** YES

## Columns

| # | Name | Type | Null |
|---|---|---|---|
| 1 | `tDeliverDate` | `datetime` | YES |
| 2 | `sSrcId` | `varchar(100)` | NO |
| 3 | `sMaterialsId` | `varchar(100)` | NO |

## Definition

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

## Narrative

_No human-written narrative yet._
