# `viw_zsgd_lld_materialanalysis` (view)

> VIEW


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

## Columns

| # | Name | Type | Null |
|---|---|---|---|
| 1 | `sId` | `varchar(100)` | NO |
| 2 | `sBillNo` | `varchar(255)` | NO |
| 3 | `tCreateDate` | `datetime` | NO |
| 4 | `sCustomerName` | `varchar(255)` | YES |
| 5 | `sProductName` | `varchar(100)` | YES |
| 6 | `sMaterialsId` | `varchar(100)` | NO |
| 7 | `lldsMaterialsId` | `varchar(100)` | YES |
| 8 | `sMaterialsStyle` | `varchar(255)` | NO |
| 9 | `lldsMaterialsName` | `varchar(100)` | YES |
| 10 | `sMaterialsName` | `varchar(100)` | YES |
| 11 | `iOrder` | `int` | YES |
| 12 | `dAuxiliaryQty` | `decimal(18,6)` | NO |
| 13 | `LldQty` | `decimal(40,6)` | YES |
| 14 | `LldsMaterialsStyle` | `varchar(255)` | YES |
| 15 | `dProductQty` | `decimal(18,6)` | NO |
| 16 | `dDifQty` | `decimal(41,6)` | YES |
| 17 | `sProductId` | `varchar(100)` | NO |
| 18 | `sCustomerId` | `varchar(100)` | NO |
| 19 | `sBrandsId` | `varchar(100)` | NO |
| 20 | `sSubsidiaryId` | `varchar(100)` | NO |
| 21 | `sSlaveId` | `varchar(100)` | NO |
| 22 | `dMaterialsMoney` | `decimal(18,6)` | NO |
| 23 | `dMaterialsPrice` | `decimal(18,6)` | NO |
| 24 | `bSlaveBillComplete` | `bit(1)` | YES |
| 25 | `bBillComplete` | `bit(1)` | NO |
| 26 | `tBillCompleteDate` | `datetime` | YES |
| 27 | `sLossMemo` | `text` | YES |
| 28 | `iChangeType` | `int` | NO |
| 29 | `bInvalid` | `bit(1)` | NO |
| 30 | `bCheck` | `bit(1)` | NO |

## Definition

```sql
select `xlyweberp_saas_ai`.`sgd`.`sId` AS `sId`,`xlyweberp_saas_ai`.`sgd`.`sBillNo` AS `sBillNo`,`xlyweberp_saas_ai`.`sgd`.`tCreateDate` AS `tCreateDate`,`e`.`sCustomerName` AS `sCustomerName`,`ep`.`sProductName` AS `sProductName`,`xlyweberp_saas_ai`.`sgd`.`sMaterialsId` AS `sMaterialsId`,`xlyweberp_saas_ai`.`lld`.`lldsMaterialsId` AS `lldsMaterialsId`,`xlyweberp_saas_ai`.`sgd`.`sMaterialsStyle` AS `sMaterialsStyle`,`em1`.`sMaterialsName` AS `lldsMaterialsName`,`em`.`sMaterialsName` AS `sMaterialsName`,`em`.`iOrder` AS `iOrder`,`xlyweberp_saas_ai`.`sgd`.`dAuxiliaryQty` AS `dAuxiliaryQty`,`xlyweberp_saas_ai`.`lld`.`LldQty` AS `LldQty`,`xlyweberp_saas_ai`.`lld`.`LldsMaterialsStyle` AS `LldsMaterialsStyle`,`xlyweberp_saas_ai`.`sgd`.`dProductQty` AS `dProductQty`,(`xlyweberp_saas_ai`.`lld`.`LldQty` - `xlyweberp_saas_ai`.`sgd`.`dAuxiliaryQty`) AS `dDifQty`,`xlyweberp_saas_ai`.`sgd`.`sProductId` AS `sProductId`,`xlyweberp_saas_ai`.`sgd`.`sCustomerId` AS `sCustomerId`,`xlyweberp_saas_ai`.`sgd`.`sBrandsId` AS `sBrandsId`,`xlyweberp_saas_ai`.`sgd`.`sSubsidiaryId` AS `sSubsidiaryId`,`xlyweberp_saas_ai`.`sgd`.`sSlaveId` AS `sSlaveId`,`xlyweberp_saas_ai`.`sgd`.`dMaterialsMoney` AS `dMaterialsMoney`,`xlyweberp_saas_ai`.`sgd`.`dMaterialsPrice` AS `dMaterialsPrice`,`xlyweberp_saas_ai`.`sgd`.`bSlaveBillComplete` AS `bSlaveBillComplete`,`xlyweberp_saas_ai`.`sgd`.`bBillComplete` AS `bBillComplete`,`xlyweberp_saas_ai`.`sgd`.`tBillCompleteDate` AS `tBillCompleteDate`,`xlyweberp_saas_ai`.`sgd`.`sLossMemo` AS `sLossMemo`,`xlyweberp_saas_ai`.`sgd`.`iChangeType` AS `iChangeType`,`xlyweberp_saas_ai`.`sgd`.`bInvalid` AS `bInvalid`,`xlyweberp_saas_ai`.`sgd`.`bCheck` AS `bCheck` from (((((`xlyweberp_saas_ai`.`viw_mftworkordermaterials` `sgd` left join `xlyweberp_saas_ai`.`viw_zlldgroupby_sgdandsmaterialsid` `lld` on((`xlyweberp_saas_ai`.`sgd`.`sSlaveId` = `xlyweberp_saas_ai`.`lld`.`sWorkOrderMaterialsTbId`))) left join `xlyweberp_saas_ai`.`elecustomer` `e` on((`xlyweberp_saas_ai`.`sgd`.`sCustomerId` = `e`.`sId`))) left join `xlyweberp_saas_ai`.`eleproduct` `ep` on((`xlyweberp_saas_ai`.`sgd`.`sProductId` = `ep`.`sId`))) left join `xlyweberp_saas_ai`.`elematerials` `em` on((`xlyweberp_saas_ai`.`sgd`.`sMaterialsId` = `em`.`sId`))) left join `xlyweberp_saas_ai`.`elematerials` `em1` on((`xlyweberp_saas_ai`.`lld`.`lldsMaterialsId` = `em1`.`sId`)))
```

## Narrative

_No human-written narrative yet._