viw_elematerials_m.md
1.58 KB
viw_elematerials_m (view)
- Updatable: NO
Columns
| # | Name | Type | Null |
|---|---|---|---|
| 1 | sProductName |
varchar(100) |
NO |
| 2 | sProductNo |
varchar(50) |
NO |
| 3 | sProductStyle |
char(0) |
NO |
| 4 | sProductUnit |
varchar(50) |
YES |
| 5 | sCustomerProductNo |
char(0) |
NO |
| 6 | sId |
varchar(50) |
NO |
| 7 | sAllPartsName |
char(0) |
NO |
| 8 | sProductId |
varchar(50) |
NO |
| 9 | sProductClassifyId |
varchar(50) |
YES |
| 10 | sType |
char(0) |
NO |
| 11 | tCreateDate |
datetime |
NO |
| 12 | sCustomerId |
char(0) |
NO |
| 13 | sParentId |
varchar(50) |
YES |
| 14 | sProductClassifyName |
varchar(100) |
YES |
| 15 | sParentProductId |
varchar(1) |
NO |
| 16 | sBrandsId |
varchar(50) |
NO |
| 17 | sSubsidiaryId |
varchar(50) |
NO |
Definition
select distinct `a`.`sMaterialsName` AS `sProductName`,`a`.`sMaterialsNo` AS `sProductNo`,'' AS `sProductStyle`,`a`.`sMaterialsUnit` AS `sProductUnit`,'' AS `sCustomerProductNo`,`a`.`sId` AS `sId`,'' AS `sAllPartsName`,`a`.`sId` AS `sProductId`,`b`.`sId` AS `sProductClassifyId`,'' AS `sType`,`a`.`tCreateDate` AS `tCreateDate`,'' AS `sCustomerId`,`a`.`sParentId` AS `sParentId`,`b`.`sName` AS `sProductClassifyName`,'0' AS `sParentProductId`,`a`.`sBrandsId` AS `sBrandsId`,`a`.`sSubsidiaryId` AS `sSubsidiaryId` from (`elematerials` `a` left join `sismaterialsclassify` `b` on(((`a`.`sParentId` = `b`.`sId`) and (`a`.`sBrandsId` = `b`.`sBrandsId`) and (`a`.`sSubsidiaryId` = `b`.`sSubsidiaryId`))))
Narrative
No human-written narrative yet.