# `viw_ai_salsalesinvoice` (view)


- **Updatable:** YES

## Columns

| # | Name | Type | Null |
|---|---|---|---|
| 1 | `sId` | `varchar(100)` | NO |
| 2 | `sSubsidiaryId` | `varchar(100)` | NO |
| 3 | `tCreateDate` | `datetime` | NO |
| 4 | `tUpdateDate` | `datetime` | NO |
| 5 | `sMakePerson` | `varchar(255)` | NO |
| 6 | `iOrder` | `int` | NO |
| 7 | `sSlaveId` | `varchar(100)` | NO |
| 8 | `sProductName` | `varchar(100)` | NO |
| 9 | `sCustomerName` | `varchar(255)` | NO |
| 10 | `sBillNo` | `varchar(255)` | NO |
| 11 | `dProductMoney` | `decimal(18,6)` | NO |
| 12 | `dProductPrice` | `decimal(18,6)` | NO |
| 13 | `dProductQty` | `decimal(18,6)` | NO |
| 14 | `sSrcNo` | `varchar(255)` | NO |
| 15 | `sSlaveMemo` | `text` | YES |
| 16 | `sOrderNo` | `varchar(255)` | NO |
| 17 | `sWorkOrderNo` | `varchar(255)` | NO |
| 18 | `dTotalMoney` | `decimal(18,6)` | NO |
| 19 | `sBrandsId` | `varchar(100)` | NO |

## Definition

```sql
select `salsalesinvoicemaster`.`sId` AS `sId`,`salsalesinvoicemaster`.`sSubsidiaryId` AS `sSubsidiaryId`,`salsalesinvoicemaster`.`tCreateDate` AS `tCreateDate`,`salsalesinvoicemaster`.`tCreateDate` AS `tUpdateDate`,`salsalesinvoicemaster`.`sMakePerson` AS `sMakePerson`,`salsalesinvoicemaster`.`iOrder` AS `iOrder`,`salsalesinvoiceslave`.`sId` AS `sSlaveId`,`eleproduct`.`sProductName` AS `sProductName`,`elecustomer`.`sCustomerName` AS `sCustomerName`,`salsalesinvoicemaster`.`sBillNo` AS `sBillNo`,`salsalesinvoiceslave`.`dProductMoney` AS `dProductMoney`,`salsalesinvoiceslave`.`dProductPrice` AS `dProductPrice`,`salsalesinvoiceslave`.`dProductQty` AS `dProductQty`,`salsalesinvoiceslave`.`sSrcNo` AS `sSrcNo`,`salsalesinvoiceslave`.`sSlaveMemo` AS `sSlaveMemo`,`salsalesinvoiceslave`.`sOrderNo` AS `sOrderNo`,`salsalesinvoiceslave`.`sWorkOrderNo` AS `sWorkOrderNo`,`salsalesinvoiceslave`.`dTotalMoney` AS `dTotalMoney`,`salsalesinvoicemaster`.`sBrandsId` AS `sBrandsId` from (((`salsalesinvoicemaster` join `salsalesinvoiceslave` on((`salsalesinvoiceslave`.`sParentId` = `salsalesinvoicemaster`.`sId`))) join `elecustomer` on((`salsalesinvoicemaster`.`sCustomerId` = `elecustomer`.`sId`))) join `eleproduct` on((`salsalesinvoiceslave`.`sProductId` = `eleproduct`.`sId`)))
```

## Narrative

_No human-written narrative yet._
