viw_purorder_detail.md
692 Bytes
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
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.