# `viw_purorder_detail` (view)

> VIEW


- **Updatable:** YES
- **Definer:** `xlyprint@%`

## Columns

| # | Name | Type | Null |
|---|---|---|---|
| 1 | `sId` | `varchar(100)` | NO |
| 2 | `tDeliverDate` | `datetime` | YES |
| 3 | `sBrandsId` | `varchar(100)` | NO |
| 4 | `sSubsidiaryId` | `varchar(100)` | NO |

## Definition

```sql
select `ppd`.`sWorkOrderId` AS `sId`,`ppm`.`tDeliverDate` AS `tDeliverDate`,`ppd`.`sBrandsId` AS `sBrandsId`,`ppd`.`sSubsidiaryId` AS `sSubsidiaryId` from (`xlyweberp_saas_ai`.`purpurchaseorderdetail` `ppd` join `xlyweberp_saas_ai`.`purpurchaseordermaster` `ppm` on((`ppm`.`sId` = `ppd`.`sParentId`)))
```

## Narrative

_No human-written narrative yet._