# `viw_ai_salsalesinvoice`（视图）


- **是否可更新：** YES
- **定义者：** `xlyprint@%`

## 字段

| # | 名称 | 类型 | 可空 |
|---|---|---|---|
| 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 |

## 定义

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

## 说明

_暂无人工说明。_