# `viw_opsoutsidearrive_qlyoutsideproducttestmaster` (view)


- **Updatable:** YES

## Columns

| # | Name | Type | Null |
|---|---|---|---|
| 1 | `sSupplyId` | `varchar(100)` | NO |
| 2 | `sId` | `varchar(100)` | NO |
| 3 | `sWorkOrderNo` | `varchar(255)` | NO |
| 4 | `sCustomerId` | `varchar(100)` | NO |
| 5 | `sProductId` | `varchar(100)` | NO |
| 6 | `sWorkOrderControlId` | `varchar(100)` | NO |
| 7 | `sProcessId` | `varchar(100)` | NO |
| 8 | `dAuxiliaryQty` | `decimal(18,6)` | NO |
| 9 | `sAuxiliaryUnit` | `varchar(255)` | NO |
| 10 | `dMaterialsQty` | `decimal(18,6)` | NO |
| 11 | `sMaterialsId` | `varchar(100)` | NO |
| 12 | `dMaterialsPrice` | `decimal(18,6)` | NO |
| 13 | `dMaterialsMoney` | `decimal(18,6)` | NO |
| 14 | `sTaxId` | `varchar(100)` | YES |
| 15 | `dMaterialsTaxMoney` | `decimal(18,6)` | YES |
| 16 | `sBillNo` | `varchar(255)` | NO |
| 17 | `iTestResult` | `int` | YES |
| 18 | `sMemo` | `text` | YES |
| 19 | `tCreateDate` | `datetime` | NO |

## Definition

```sql
select `a`.`sSupplyId` AS `sSupplyId`,`a`.`sId` AS `sId`,`a`.`sWorkOrderNo` AS `sWorkOrderNo`,`a`.`sCustomerId` AS `sCustomerId`,`a`.`sProductId` AS `sProductId`,`a`.`sWorkOrderControlId` AS `sWorkOrderControlId`,`a`.`sProcessId` AS `sProcessId`,`a`.`dAuxiliaryQty` AS `dAuxiliaryQty`,`a`.`sAuxiliaryUnit` AS `sAuxiliaryUnit`,`a`.`dMaterialsQty` AS `dMaterialsQty`,`a`.`sMaterialsId` AS `sMaterialsId`,`a`.`dMaterialsPrice` AS `dMaterialsPrice`,`a`.`dMaterialsMoney` AS `dMaterialsMoney`,`a`.`sTaxId` AS `sTaxId`,`a`.`dMaterialsTaxMoney` AS `dMaterialsTaxMoney`,`b`.`sBillNo` AS `sBillNo`,`b`.`iTestResult` AS `iTestResult`,`b`.`sMemo` AS `sMemo`,`b`.`tCreateDate` AS `tCreateDate` from (`viw_opsoutsidearrive` `a` join `qlyoutsideproducttestmaster` `b` on((`a`.`sId` = `b`.`sSrcId`))) where ((`b`.`bCheck` = 1) and (`b`.`iTestResult` = 0))
```

## Narrative

_No human-written narrative yet._
