viw_mftproductparam.md
3.49 KB
viw_mftproductparam (view)
VIEW
- Updatable: YES
-
Definer:
xlyprint@%
Columns
| # | Name | Type | Null |
|---|---|---|---|
| 1 | sId |
varchar(100) |
NO |
| 2 | sBrandsId |
varchar(100) |
NO |
| 3 | sSubsidiaryId |
varchar(100) |
NO |
| 4 | tCreateDate |
datetime |
NO |
| 5 | sMakePerson |
varchar(255) |
NO |
| 6 | sFormId |
varchar(100) |
NO |
| 7 | iOrder |
int |
NO |
| 8 | sBillNo |
varchar(255) |
NO |
| 9 | sMemo |
text |
YES |
| 10 | bCheck |
bit(1) |
NO |
| 11 | tCheckDate |
datetime |
YES |
| 12 | sCheckPerson |
varchar(255) |
YES |
| 13 | bPrint |
bit(1) |
NO |
| 14 | bCopyLimit |
bit(1) |
NO |
| 15 | sStatus |
varchar(255) |
YES |
| 16 | bInvalid |
bit(1) |
NO |
| 17 | sType |
varchar(255) |
NO |
| 18 | iParamOrder |
int |
NO |
| 19 | sParamParam1 |
varchar(255) |
YES |
| 20 | sParamParam2 |
varchar(255) |
YES |
| 21 | sParamParam3 |
varchar(255) |
YES |
| 22 | sParamParam4 |
varchar(255) |
YES |
| 23 | sParamParam5 |
varchar(255) |
YES |
| 24 | sParamParam6 |
varchar(255) |
YES |
| 25 | sParamParam7 |
varchar(255) |
YES |
| 26 | sParamParam8 |
varchar(255) |
YES |
| 27 | sParamParam9 |
varchar(255) |
YES |
| 28 | sParamParam10 |
varchar(255) |
YES |
| 29 | sParamParam11 |
varchar(255) |
YES |
| 30 | sParamParam12 |
varchar(255) |
YES |
| 31 | sParamParam13 |
varchar(255) |
YES |
| 32 | sParamParam14 |
varchar(255) |
YES |
| 33 | sParamParam15 |
varchar(255) |
YES |
| 34 | dParamParam1 |
decimal(18,6) |
YES |
| 35 | dParamParam2 |
decimal(18,6) |
YES |
| 36 | dParamParam3 |
decimal(18,6) |
YES |
| 37 | dParamParam4 |
decimal(18,6) |
YES |
| 38 | dParamParam5 |
decimal(18,6) |
YES |
| 39 | dParamParam6 |
decimal(18,6) |
YES |
| 40 | bNotColor |
bit(1) |
NO |
| 41 | tParamDate |
datetime |
YES |
| 42 | sKnifeMouldId |
varchar(100) |
NO |
| 43 | sMaterialsId |
varchar(100) |
NO |
Definition
select `m`.`sId` AS `sId`,`m`.`sBrandsId` AS `sBrandsId`,`m`.`sSubsidiaryId` AS `sSubsidiaryId`,`m`.`tCreateDate` AS `tCreateDate`,`m`.`sMakePerson` AS `sMakePerson`,`m`.`sFormId` AS `sFormId`,`m`.`iOrder` AS `iOrder`,`m`.`sBillNo` AS `sBillNo`,`m`.`sMemo` AS `sMemo`,`m`.`bCheck` AS `bCheck`,`m`.`tCheckDate` AS `tCheckDate`,`m`.`sCheckPerson` AS `sCheckPerson`,`m`.`bPrint` AS `bPrint`,`m`.`bCopyLimit` AS `bCopyLimit`,`m`.`sStatus` AS `sStatus`,`m`.`bInvalid` AS `bInvalid`,`m`.`sType` AS `sType`,`p`.`iOrder` AS `iParamOrder`,`p`.`sParam1` AS `sParamParam1`,`p`.`sParam2` AS `sParamParam2`,`p`.`sParam3` AS `sParamParam3`,`p`.`sParam4` AS `sParamParam4`,`p`.`sParam5` AS `sParamParam5`,`p`.`sParam6` AS `sParamParam6`,`p`.`sParam7` AS `sParamParam7`,`p`.`sParam8` AS `sParamParam8`,`p`.`sParam9` AS `sParamParam9`,`p`.`sParam10` AS `sParamParam10`,`p`.`sParam11` AS `sParamParam11`,`p`.`sParam12` AS `sParamParam12`,`p`.`sParam13` AS `sParamParam13`,`p`.`sParam14` AS `sParamParam14`,`p`.`sParam15` AS `sParamParam15`,`p`.`dParam1` AS `dParamParam1`,`p`.`dParam2` AS `dParamParam2`,`p`.`dParam3` AS `dParamParam3`,`p`.`dParam4` AS `dParamParam4`,`p`.`dParam5` AS `dParamParam5`,`p`.`dParam6` AS `dParamParam6`,`p`.`bNotColor` AS `bNotColor`,`p`.`tParamDate` AS `tParamDate`,`p`.`sKnifeMouldId` AS `sKnifeMouldId`,`p`.`sMaterialsId` AS `sMaterialsId` from (`xlyweberp_saas_ai`.`mftproductmaster` `m` join `xlyweberp_saas_ai`.`mftproductparam` `p` on((`m`.`sId` = `p`.`sParentId`)))
Narrative
No human-written narrative yet.