viw_mftproductionplancontrolprocess.md
8.22 KB
viw_mftproductionplancontrolprocess (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 | sWorkOrderId |
varchar(100) |
NO |
| 9 | sWorkOrderNo |
varchar(255) |
NO |
| 10 | sCustomerId |
varchar(100) |
NO |
| 11 | sContacts |
varchar(255) |
YES |
| 12 | sPhone |
varchar(255) |
YES |
| 13 | tDeliverDate |
datetime |
YES |
| 14 | sSalesManId |
varchar(255) |
YES |
| 15 | sProductTechnologyVer |
varchar(255) |
YES |
| 16 | sGetPayId |
varchar(255) |
YES |
| 17 | tGetPayDate |
datetime |
YES |
| 18 | sConsignee |
varchar(255) |
YES |
| 19 | sConsigneeMobile |
varchar(255) |
YES |
| 20 | sDeliverId |
varchar(100) |
YES |
| 21 | sProvince |
varchar(255) |
YES |
| 22 | sCity |
varchar(255) |
YES |
| 23 | sArea |
varchar(255) |
YES |
| 24 | sDeliverTo |
varchar(255) |
YES |
| 25 | sManualNo |
varchar(255) |
YES |
| 26 | sCustomerOrderNo |
varchar(255) |
YES |
| 27 | sCurrency |
varchar(255) |
YES |
| 28 | dCurrencyRate |
decimal(18,6) |
YES |
| 29 | sProductId |
varchar(100) |
NO |
| 30 | dProductQty |
decimal(18,6) |
NO |
| 31 | dProductPrice |
decimal(18,6) |
NO |
| 32 | dProductMoney |
decimal(18,6) |
NO |
| 33 | sProductInfo |
text |
YES |
| 34 | sMaterialsMemo |
text |
YES |
| 35 | sProcessMemo |
text |
YES |
| 36 | sSrcSlaveId |
varchar(100) |
NO |
| 37 | sSrcId |
varchar(100) |
NO |
| 38 | sSrcNo |
varchar(255) |
NO |
| 39 | dSrcQty |
decimal(18,6) |
YES |
| 40 | dProductPQty |
decimal(18,6) |
YES |
| 41 | iProductStick |
int |
YES |
| 42 | bProductInStoreComplete |
bit(1) |
NO |
| 43 | bDeliverComplete |
bit(1) |
NO |
| 44 | bDeliverNotifyComplete |
bit(1) |
NO |
| 45 | bOutsideProcessComplete |
bit(1) |
NO |
| 46 | bCheckingComplete |
bit(1) |
NO |
| 47 | sQualityRequireMemo |
text |
YES |
| 48 | sPackRequireMemo |
text |
YES |
| 49 | sSlaveMemo |
text |
YES |
| 50 | sTaxId |
varchar(100) |
YES |
| 51 | dProductNoTaxPrice |
decimal(18,6) |
YES |
| 52 | dProductNoTaxMoney |
decimal(18,6) |
YES |
| 53 | dProductTaxMoney |
decimal(18,6) |
YES |
| 54 | dProductTaxForeignMoney |
decimal(18,6) |
YES |
| 55 | dProductForeignMoney |
decimal(18,6) |
YES |
| 56 | dProductInStoreQty |
decimal(18,6) |
NO |
| 57 | dDeliverNotifyQty |
decimal(18,6) |
NO |
| 58 | dDeliverQty |
decimal(18,6) |
NO |
| 59 | dCheckingQty |
decimal(18,6) |
NO |
| 60 | dReceiptMoney |
decimal(18,6) |
NO |
| 61 | dOutsideProcessQty |
decimal(18,6) |
NO |
| 62 | sWebOrderNo |
varchar(255) |
NO |
| 63 | sWebOrderId |
varchar(100) |
NO |
| 64 | sBarcode |
varchar(255) |
YES |
| 65 | dGiveQty |
decimal(18,6) |
NO |
| 66 | dPresentQty |
decimal(18,6) |
NO |
| 67 | sProductTechnologyId |
varchar(100) |
YES |
| 68 | sOrderId |
varchar(100) |
NO |
| 69 | sOrderSlaveId |
varchar(100) |
NO |
| 70 | sOrderNo |
varchar(255) |
NO |
| 71 | sSReserve1 |
varchar(255) |
YES |
| 72 | sSReserve2 |
varchar(255) |
YES |
| 73 | sSReserve3 |
varchar(255) |
YES |
| 74 | sSReserve4 |
varchar(255) |
YES |
| 75 | sSReserve5 |
varchar(255) |
YES |
| 76 | sSReserve6 |
varchar(255) |
YES |
| 77 | dSReserve1 |
decimal(18,6) |
YES |
| 78 | dSReserve2 |
decimal(18,6) |
YES |
| 79 | dSReserve3 |
decimal(18,6) |
YES |
| 80 | iSReserve1 |
int |
YES |
| 81 | iSReserve2 |
int |
YES |
| 82 | iSReserve3 |
int |
YES |
| 83 | tSReserve1 |
datetime |
YES |
| 84 | tSReserve2 |
datetime |
YES |
| 85 | sState |
varchar(255) |
NO |
| 86 | bFrozen |
bit(1) |
NO |
| 87 | sControlId |
varchar(100) |
NO |
| 88 | sPartsName |
varchar(255) |
NO |
| 89 | dPartsQty |
decimal(18,6) |
NO |
| 90 | dMachineQty |
decimal(18,6) |
NO |
| 91 | orderProcessId |
varchar(100) |
NO |
| 92 | sProcessId |
varchar(100) |
NO |
| 93 | sMaterialsId |
varchar(100) |
YES |
| 94 | sMachineId |
varchar(100) |
YES |
| 95 | dHour |
decimal(18,6) |
YES |
| 96 | dProductionReportQty |
decimal(18,6) |
NO |
| 97 | dProductionQty |
decimal(18,6) |
NO |
| 98 | iIncrement |
int |
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`.`sWorkOrderId` AS `sWorkOrderId`,`m`.`sWorkOrderNo` AS `sWorkOrderNo`,`m`.`sCustomerId` AS `sCustomerId`,`m`.`sContacts` AS `sContacts`,`m`.`sPhone` AS `sPhone`,`m`.`tDeliverDate` AS `tDeliverDate`,`m`.`sSalesManId` AS `sSalesManId`,`m`.`sProductTechnologyVer` AS `sProductTechnologyVer`,`m`.`sGetPayId` AS `sGetPayId`,`m`.`tGetPayDate` AS `tGetPayDate`,`m`.`sConsignee` AS `sConsignee`,`m`.`sConsigneeMobile` AS `sConsigneeMobile`,`m`.`sDeliverId` AS `sDeliverId`,`m`.`sProvince` AS `sProvince`,`m`.`sCity` AS `sCity`,`m`.`sArea` AS `sArea`,`m`.`sDeliverTo` AS `sDeliverTo`,`m`.`sManualNo` AS `sManualNo`,`m`.`sCustomerOrderNo` AS `sCustomerOrderNo`,`m`.`sCurrency` AS `sCurrency`,`m`.`dCurrencyRate` AS `dCurrencyRate`,`m`.`sProductId` AS `sProductId`,`m`.`dProductQty` AS `dProductQty`,`m`.`dProductPrice` AS `dProductPrice`,`m`.`dProductMoney` AS `dProductMoney`,`m`.`sProductInfo` AS `sProductInfo`,`m`.`sMaterialsMemo` AS `sMaterialsMemo`,`m`.`sProcessMemo` AS `sProcessMemo`,`m`.`sSrcSlaveId` AS `sSrcSlaveId`,`m`.`sSrcId` AS `sSrcId`,`m`.`sSrcNo` AS `sSrcNo`,`m`.`dSrcQty` AS `dSrcQty`,`m`.`dProductPQty` AS `dProductPQty`,`m`.`iProductStick` AS `iProductStick`,`m`.`bProductInStoreComplete` AS `bProductInStoreComplete`,`m`.`bDeliverComplete` AS `bDeliverComplete`,`m`.`bDeliverNotifyComplete` AS `bDeliverNotifyComplete`,`m`.`bOutsideProcessComplete` AS `bOutsideProcessComplete`,`m`.`bCheckingComplete` AS `bCheckingComplete`,`m`.`sQualityRequireMemo` AS `sQualityRequireMemo`,`m`.`sPackRequireMemo` AS `sPackRequireMemo`,`m`.`sSlaveMemo` AS `sSlaveMemo`,`m`.`sTaxId` AS `sTaxId`,`m`.`dProductNoTaxPrice` AS `dProductNoTaxPrice`,`m`.`dProductNoTaxMoney` AS `dProductNoTaxMoney`,`m`.`dProductTaxMoney` AS `dProductTaxMoney`,`m`.`dProductTaxForeignMoney` AS `dProductTaxForeignMoney`,`m`.`dProductForeignMoney` AS `dProductForeignMoney`,`m`.`dProductInStoreQty` AS `dProductInStoreQty`,`m`.`dDeliverNotifyQty` AS `dDeliverNotifyQty`,`m`.`dDeliverQty` AS `dDeliverQty`,`m`.`dCheckingQty` AS `dCheckingQty`,`m`.`dReceiptMoney` AS `dReceiptMoney`,`m`.`dOutsideProcessQty` AS `dOutsideProcessQty`,`m`.`sWebOrderNo` AS `sWebOrderNo`,`m`.`sWebOrderId` AS `sWebOrderId`,`m`.`sBarcode` AS `sBarcode`,`m`.`dGiveQty` AS `dGiveQty`,`m`.`dPresentQty` AS `dPresentQty`,`m`.`sProductTechnologyId` AS `sProductTechnologyId`,`m`.`sOrderId` AS `sOrderId`,`m`.`sOrderSlaveId` AS `sOrderSlaveId`,`m`.`sOrderNo` AS `sOrderNo`,`m`.`sSReserve1` AS `sSReserve1`,`m`.`sSReserve2` AS `sSReserve2`,`m`.`sSReserve3` AS `sSReserve3`,`m`.`sSReserve4` AS `sSReserve4`,`m`.`sSReserve5` AS `sSReserve5`,`m`.`sSReserve6` AS `sSReserve6`,`m`.`dSReserve1` AS `dSReserve1`,`m`.`dSReserve2` AS `dSReserve2`,`m`.`dSReserve3` AS `dSReserve3`,`m`.`iSReserve1` AS `iSReserve1`,`m`.`iSReserve2` AS `iSReserve2`,`m`.`iSReserve3` AS `iSReserve3`,`m`.`tSReserve1` AS `tSReserve1`,`m`.`tSReserve2` AS `tSReserve2`,`m`.`sState` AS `sState`,`m`.`bFrozen` AS `bFrozen`,`c`.`sId` AS `sControlId`,`c`.`sPartsName` AS `sPartsName`,`c`.`dPartsQty` AS `dPartsQty`,`c`.`dMachineQty` AS `dMachineQty`,`p`.`sId` AS `orderProcessId`,`p`.`sProcessId` AS `sProcessId`,`p`.`sMaterialsId` AS `sMaterialsId`,`p`.`sMachineId` AS `sMachineId`,`p`.`dHour` AS `dHour`,`p`.`dProductionReportQty` AS `dProductionReportQty`,`p`.`dProductionQty` AS `dProductionQty`,`p`.`iIncrement` AS `iIncrement` from ((`xlyweberp_saas_ai`.`mftproductionplan` `m` join `xlyweberp_saas_ai`.`mftworkordercontrol` `c` on((`c`.`sParentId` = `m`.`sSrcId`))) join `xlyweberp_saas_ai`.`mftworkorderprocess` `p` on((`p`.`sControlId` = `c`.`sId`)))
Narrative
No human-written narrative yet.