viw_mftproductionplan.md
16 KB
viw_mftproductionplan (view)
VIEW
- Updatable: YES
-
Definer:
xlyprint@%
Columns
| # | Name | Type | Null |
|---|---|---|---|
| 1 | iIncrement |
bigint |
NO |
| 2 | sId |
varchar(100) |
NO |
| 3 | sBrandsId |
varchar(100) |
NO |
| 4 | sSubsidiaryId |
varchar(100) |
NO |
| 5 | tCreateDate |
datetime |
NO |
| 6 | sMakePerson |
varchar(255) |
NO |
| 7 | iOrder |
int |
NO |
| 8 | sParentId |
varchar(100) |
NO |
| 9 | sCustomerId |
varchar(100) |
NO |
| 10 | sManualNo |
varchar(11) |
YES |
| 11 | sCustomerOrderNo |
varchar(11) |
YES |
| 12 | sProductId |
varchar(100) |
NO |
| 13 | sProcessId |
varchar(100) |
NO |
| 14 | dProductQty |
decimal(18,6) |
NO |
| 15 | sPartsName |
varchar(255) |
YES |
| 16 | sMachineId |
varchar(100) |
YES |
| 17 | dProductionReportQty |
decimal(18,6) |
NO |
| 18 | dHour |
decimal(18,6) |
NO |
| 19 | tStartDate |
datetime |
YES |
| 20 | tEndDate |
datetime |
YES |
| 21 | sMaterialsId |
varchar(100) |
YES |
| 22 | bProductionReportComplete |
bit(1) |
NO |
| 23 | sEmployeeId |
varchar(100) |
NO |
| 24 | sTeamId |
varchar(100) |
NO |
| 25 | sWorkCenterId |
varchar(100) |
NO |
| 26 | dProcessQty |
decimal(18,6) |
NO |
| 27 | iComplete |
int |
YES |
| 28 | sMaterialsMemo |
text |
YES |
| 29 | sProcessMemo |
text |
YES |
| 30 | sSrcSlaveId |
varchar(100) |
NO |
| 31 | sSrcId |
varchar(100) |
NO |
| 32 | sSrcMainId |
varchar(100) |
NO |
| 33 | sSrcNo |
varchar(255) |
NO |
| 34 | dSrcQty |
decimal(18,6) |
YES |
| 35 | dProductPQty |
decimal(18,6) |
YES |
| 36 | sSlaveMemo |
text |
YES |
| 37 | sWebOrderNo |
varchar(255) |
NO |
| 38 | sWebOrderId |
varchar(100) |
NO |
| 39 | sBarcode |
varchar(255) |
YES |
| 40 | sOrderId |
varchar(100) |
NO |
| 41 | sOrderNo |
varchar(255) |
NO |
| 42 | sOrderSlaveId |
varchar(100) |
NO |
| 43 | sWorkOrderId |
varchar(100) |
NO |
| 44 | sWorkOrderSlaveId |
varchar(100) |
NO |
| 45 | sWorkOrderNo |
varchar(255) |
NO |
| 46 | sWorkOrderControlId |
varchar(100) |
NO |
| 47 | sWorkOrderProcessTbId |
varchar(100) |
NO |
| 48 | sWorkOrderMaterialsTbId |
varchar(100) |
NO |
| 49 | sState |
varchar(11) |
NO |
| 50 | bFrozen |
bit(1) |
NO |
| 51 | sDecompose |
varchar(255) |
YES |
| 52 | sSReserve1 |
varchar(255) |
YES |
| 53 | sSReserve2 |
varchar(255) |
YES |
| 54 | sSReserve3 |
varchar(255) |
YES |
| 55 | sSReserve4 |
varchar(255) |
YES |
| 56 | sSReserve5 |
varchar(255) |
YES |
| 57 | sSReserve6 |
varchar(255) |
YES |
| 58 | dSReserve1 |
decimal(18,6) |
YES |
| 59 | dSReserve2 |
decimal(18,6) |
YES |
| 60 | dSReserve3 |
decimal(18,6) |
YES |
| 61 | iSReserve1 |
int |
YES |
| 62 | iSReserve2 |
int |
YES |
| 63 | iSReserve3 |
int |
YES |
| 64 | tSReserve1 |
datetime |
YES |
| 65 | tSReserve2 |
datetime |
YES |
| 66 | sType |
varchar(255) |
YES |
| 67 | dPlateQty |
decimal(18,6) |
YES |
| 68 | dPrintQty |
decimal(18,6) |
YES |
| 69 | iLevel |
int |
YES |
| 70 | sMemo |
text |
YES |
| 71 | dAdjustHour |
decimal(18,6) |
YES |
| 72 | tCutDate |
datetime |
YES |
| 73 | sCutPerson |
varchar(255) |
YES |
| 74 | bCut |
bit(1) |
NO |
| 75 | bMat |
bit(1) |
NO |
| 76 | tPublishDate |
datetime |
YES |
| 77 | sPublishPerson |
varchar(255) |
YES |
| 78 | bPublish |
bit(1) |
NO |
| 79 | sMakeup |
varchar(255) |
YES |
| 80 | tMakeup |
datetime |
YES |
| 81 | bMakeup |
bit(1) |
NO |
| 82 | sAfterProcess |
text |
YES |
| 83 | sPackage |
varchar(100) |
YES |
| 84 | sDeliveryMode |
varchar(100) |
YES |
| 85 | bProduction |
bit(1) |
NO |
| 86 | sLastReportTeamId |
varchar(100) |
YES |
| 87 | tLastReportDate |
datetime |
YES |
| 88 | dCutMoney |
decimal(18,6) |
NO |
| 89 | dPublishMoney |
decimal(18,6) |
NO |
| 90 | dMakeupMoney |
decimal(18,6) |
NO |
| 91 | iSrcControlOrder |
int |
YES |
| 92 | sSrcFormId |
varchar(100) |
NO |
| 93 | sCurrentProgress |
varchar(1000) |
NO |
| 94 | dCutBuQty |
decimal(18,6) |
NO |
| 95 | dMakeupBuQty |
decimal(18,6) |
NO |
| 96 | dPublishBuQty |
decimal(18,6) |
NO |
| 97 | sReportCompletePerson |
varchar(255) |
NO |
| 98 | tReportCompleteDate |
datetime |
YES |
| 99 | sPriorState |
varchar(100) |
NO |
| 100 | tAdjustMachineDate |
datetime |
YES |
| 101 | bAdjustMachineComplete |
bit(1) |
NO |
| 102 | bStartComplete |
bit(1) |
NO |
| 103 | sColorSerialMemo |
varchar(255) |
NO |
| 104 | sMReserve1 |
varchar(255) |
YES |
| 105 | sMReserve2 |
varchar(255) |
YES |
| 106 | sMReserve3 |
varchar(255) |
YES |
| 107 | tDeliverDate |
datetime |
YES |
| 108 | iStick |
int |
YES |
| 109 | iPrintMode |
int |
YES |
| 110 | dMachineQty |
decimal(18,6) |
YES |
| 111 | sColorSerial |
varchar(255) |
YES |
| 112 | sMachineStyle |
varchar(255) |
YES |
| 113 | sCReserve1 |
varchar(255) |
YES |
| 114 | sCMemo |
varchar(255) |
YES |
| 115 | sProcessRequire |
varchar(255) |
YES |
| 116 | dAuxiliaryQty |
decimal(18,6) |
YES |
| 117 | sMaterMemo |
varchar(255) |
YES |
| 118 | sProductName |
varchar(100) |
YES |
| 119 | sProductNo |
varchar(50) |
YES |
| 120 | sProductStyle |
varchar(50) |
YES |
| 121 | sCustomerName |
varchar(100) |
YES |
| 122 | sCustomerNo |
varchar(50) |
YES |
| 123 | sProcessName |
varchar(100) |
YES |
| 124 | sProcessNo |
varchar(50) |
YES |
| 125 | sMachineName |
varchar(100) |
YES |
| 126 | sMachineNo |
varchar(50) |
YES |
| 127 | sWorkCenterName |
varchar(100) |
YES |
| 128 | sWorkCenterNo |
varchar(50) |
YES |
| 129 | sTeamName |
varchar(100) |
YES |
| 130 | sProductClassifyName |
varchar(100) |
YES |
| 131 | sMaterialsName |
varchar(100) |
YES |
| 132 | sMaterialsNo |
varchar(50) |
YES |
| 133 | sMaterialsStyle |
varchar(50) |
YES |
| 134 | iFace |
int |
YES |
| 135 | iPlate |
int |
YES |
| 136 | dGiveQty |
decimal(18,6) |
NO |
| 137 | dStartDate |
decimal(18,6) |
NO |
| 138 | sPartNameStatus |
longtext |
YES |
| 139 | sMaterialsStatus |
longtext |
YES |
| 140 | tReportDate |
datetime |
YES |
| 141 | sMaterialsProductId |
varchar(255) |
NO |
| 142 | iChangeTotal |
int |
NO |
| 143 | sWorkOrderChangeMemo |
text |
YES |
| 144 | bBillOutside |
bit(1) |
NO |
| 145 | sDecomposeCustomize |
varchar(255) |
NO |
| 146 | bProductionPlanComplete |
bit(1) |
NO |
| 147 | sCaclMachineId |
varchar(100) |
YES |
| 148 | dCaclProductionReportQty |
decimal(18,6) |
NO |
| 149 | sPReserve2 |
varchar(100) |
NO |
| 150 | dSumPlate |
decimal(18,6) |
NO |
| 151 | tChangeMachineDate |
datetime |
YES |
| 152 | bUrgent |
bit(1) |
NO |
| 153 | bPatrolInspection |
bit(1) |
NO |
| 154 | bFirst1Inspection |
bit(1) |
NO |
| 155 | bFirst2Inspection |
bit(1) |
NO |
| 156 | bFirst3Inspection |
bit(1) |
NO |
| 157 | tPatrolInspection |
datetime |
YES |
| 158 | sPatrolInspection |
varchar(100) |
YES |
| 159 | tFirst1Inspection |
datetime |
YES |
| 160 | tFirst2Inspection |
datetime |
YES |
| 161 | tFirst3Inspection |
datetime |
YES |
| 162 | sFirst1Inspection |
varchar(100) |
YES |
| 163 | sFirst2Inspection |
varchar(100) |
YES |
| 164 | sFirst3Inspection |
varchar(100) |
YES |
| 165 | sReportParams |
longtext |
YES |
| 166 | tLimitReportDate |
datetime |
YES |
| 167 | bInking |
bit(1) |
NO |
| 168 | tInkingDate |
datetime |
YES |
| 169 | sInkingPerson |
varchar(50) |
NO |
| 170 | dInkingQty |
decimal(18,6) |
NO |
| 171 | dInkingMoney |
decimal(18,6) |
NO |
| 172 | bMould |
bit(1) |
NO |
| 173 | sMouldPerson |
varchar(50) |
NO |
| 174 | tMouldDate |
datetime |
YES |
| 175 | sMouldNo |
varchar(50) |
YES |
| 176 | dCalcQty1 |
decimal(18,6) |
NO |
| 177 | dCalcQty2 |
decimal(18,6) |
NO |
| 178 | dCalcQty3 |
decimal(18,6) |
NO |
| 179 | dCalcQty4 |
decimal(18,6) |
NO |
| 180 | dCalcHour1 |
decimal(18,6) |
NO |
| 181 | iBlockCount |
int |
NO |
| 182 | bLock |
bit(1) |
NO |
| 183 | sLock |
varchar(50) |
NO |
| 184 | tLock |
datetime |
YES |
| 185 | sPriorProcess |
varchar(255) |
NO |
| 186 | sPriorPlate |
varchar(255) |
NO |
| 187 | iAutoOrder |
int |
NO |
| 188 | sDivRow |
varchar(255) |
YES |
| 189 | sDivRowGroupBy |
varchar(255) |
YES |
| 190 | bEmploy |
bit(1) |
YES |
| 191 | sEmployPerson |
varchar(255) |
YES |
| 192 | tEmploytime |
datetime |
YES |
| 193 | tFileDate |
datetime |
YES |
| 194 | sFilePerson |
varchar(50) |
NO |
| 195 | bFile |
bit(1) |
NO |
| 196 | bInvalid |
int |
NO |
| 197 | sFormId |
char(0) |
NO |
| 198 | bcheck |
int |
NO |
| 199 | bConfirm |
bit(1) |
NO |
| 200 | tConfirmDate |
datetime |
YES |
| 201 | sConfirmPerson |
varchar(50) |
NO |
Definition
select `a`.`iIncrement` AS `iIncrement`,`a`.`sId` AS `sId`,`a`.`sBrandsId` AS `sBrandsId`,`a`.`sSubsidiaryId` AS `sSubsidiaryId`,`a`.`tCreateDate` AS `tCreateDate`,`a`.`sMakePerson` AS `sMakePerson`,`a`.`iOrder` AS `iOrder`,`a`.`sParentId` AS `sParentId`,`a`.`sCustomerId` AS `sCustomerId`,`a`.`sManualNo` AS `sManualNo`,`a`.`sCustomerOrderNo` AS `sCustomerOrderNo`,`a`.`sProductId` AS `sProductId`,`a`.`sProcessId` AS `sProcessId`,`a`.`dProductQty` AS `dProductQty`,`a`.`sPartsName` AS `sPartsName`,`a`.`sMachineId` AS `sMachineId`,`a`.`dProductionReportQty` AS `dProductionReportQty`,`a`.`dHour` AS `dHour`,`a`.`tStartDate` AS `tStartDate`,`a`.`tEndDate` AS `tEndDate`,`a`.`sMaterialsId` AS `sMaterialsId`,`a`.`bProductionReportComplete` AS `bProductionReportComplete`,`a`.`sEmployeeId` AS `sEmployeeId`,`a`.`sTeamId` AS `sTeamId`,`a`.`sWorkCenterId` AS `sWorkCenterId`,`a`.`dProcessQty` AS `dProcessQty`,`a`.`iComplete` AS `iComplete`,`a`.`sMaterialsMemo` AS `sMaterialsMemo`,`a`.`sProcessMemo` AS `sProcessMemo`,`a`.`sSrcSlaveId` AS `sSrcSlaveId`,`a`.`sSrcId` AS `sSrcId`,`a`.`sSrcMainId` AS `sSrcMainId`,`a`.`sSrcNo` AS `sSrcNo`,`a`.`dSrcQty` AS `dSrcQty`,`a`.`dProductPQty` AS `dProductPQty`,`a`.`sSlaveMemo` AS `sSlaveMemo`,`a`.`sWebOrderNo` AS `sWebOrderNo`,`a`.`sWebOrderId` AS `sWebOrderId`,`a`.`sBarcode` AS `sBarcode`,`a`.`sOrderId` AS `sOrderId`,`a`.`sOrderNo` AS `sOrderNo`,`a`.`sOrderSlaveId` AS `sOrderSlaveId`,`a`.`sWorkOrderId` AS `sWorkOrderId`,`a`.`sWorkOrderSlaveId` AS `sWorkOrderSlaveId`,`a`.`sWorkOrderNo` AS `sWorkOrderNo`,`a`.`sWorkOrderControlId` AS `sWorkOrderControlId`,`a`.`sWorkOrderProcessTbId` AS `sWorkOrderProcessTbId`,`a`.`sWorkOrderMaterialsTbId` AS `sWorkOrderMaterialsTbId`,`a`.`sState` AS `sState`,`a`.`bFrozen` AS `bFrozen`,`a`.`sDecompose` AS `sDecompose`,`a`.`sSReserve1` AS `sSReserve1`,`a`.`sSReserve2` AS `sSReserve2`,`a`.`sSReserve3` AS `sSReserve3`,`a`.`sSReserve4` AS `sSReserve4`,`a`.`sSReserve5` AS `sSReserve5`,`a`.`sSReserve6` AS `sSReserve6`,`a`.`dSReserve1` AS `dSReserve1`,`a`.`dSReserve2` AS `dSReserve2`,`a`.`dSReserve3` AS `dSReserve3`,`a`.`iSReserve1` AS `iSReserve1`,`a`.`iSReserve2` AS `iSReserve2`,`a`.`iSReserve3` AS `iSReserve3`,`a`.`tSReserve1` AS `tSReserve1`,`a`.`tSReserve2` AS `tSReserve2`,`a`.`sType` AS `sType`,`a`.`dPlateQty` AS `dPlateQty`,`a`.`dPrintQty` AS `dPrintQty`,`a`.`iLevel` AS `iLevel`,`a`.`sMemo` AS `sMemo`,`a`.`dAdjustHour` AS `dAdjustHour`,`a`.`tCutDate` AS `tCutDate`,`a`.`sCutPerson` AS `sCutPerson`,`a`.`bCut` AS `bCut`,`a`.`bMat` AS `bMat`,`a`.`tPublishDate` AS `tPublishDate`,`a`.`sPublishPerson` AS `sPublishPerson`,`a`.`bPublish` AS `bPublish`,`a`.`sMakeup` AS `sMakeup`,`a`.`tMakeup` AS `tMakeup`,`a`.`bMakeup` AS `bMakeup`,`a`.`sAfterProcess` AS `sAfterProcess`,`a`.`sPackage` AS `sPackage`,`a`.`sDeliveryMode` AS `sDeliveryMode`,`a`.`bProduction` AS `bProduction`,`a`.`sLastReportTeamId` AS `sLastReportTeamId`,`a`.`tLastReportDate` AS `tLastReportDate`,`a`.`dCutMoney` AS `dCutMoney`,`a`.`dPublishMoney` AS `dPublishMoney`,`a`.`dMakeupMoney` AS `dMakeupMoney`,`a`.`iSrcControlOrder` AS `iSrcControlOrder`,`a`.`sSrcFormId` AS `sSrcFormId`,`a`.`sCurrentProgress` AS `sCurrentProgress`,`a`.`dCutBuQty` AS `dCutBuQty`,`a`.`dMakeupBuQty` AS `dMakeupBuQty`,`a`.`dPublishBuQty` AS `dPublishBuQty`,`a`.`sReportCompletePerson` AS `sReportCompletePerson`,`a`.`tReportCompleteDate` AS `tReportCompleteDate`,`a`.`sPriorState` AS `sPriorState`,`a`.`tAdjustMachineDate` AS `tAdjustMachineDate`,`a`.`bAdjustMachineComplete` AS `bAdjustMachineComplete`,`a`.`bStartComplete` AS `bStartComplete`,`a`.`sColorSerialMemo` AS `sColorSerialMemo`,`a`.`sMReserve1` AS `sMReserve1`,`a`.`sMReserve2` AS `sMReserve2`,`a`.`sMReserve3` AS `sMReserve3`,`a`.`tDeliverDate` AS `tDeliverDate`,`a`.`iStick` AS `iStick`,`a`.`iPrintMode` AS `iPrintMode`,`a`.`dMachineQty` AS `dMachineQty`,`a`.`sColorSerial` AS `sColorSerial`,`a`.`sMachineStyle` AS `sMachineStyle`,`a`.`sCReserve1` AS `sCReserve1`,`a`.`sCMemo` AS `sCMemo`,`a`.`sProcessRequire` AS `sProcessRequire`,`a`.`dAuxiliaryQty` AS `dAuxiliaryQty`,`a`.`sMaterMemo` AS `sMaterMemo`,`a`.`sProductName` AS `sProductName`,`a`.`sProductNo` AS `sProductNo`,`a`.`sProductStyle` AS `sProductStyle`,`a`.`sCustomerName` AS `sCustomerName`,`a`.`sCustomerNo` AS `sCustomerNo`,`a`.`sProcessName` AS `sProcessName`,`a`.`sProcessNo` AS `sProcessNo`,`a`.`sMachineName` AS `sMachineName`,`a`.`sMachineNo` AS `sMachineNo`,`a`.`sWorkCenterName` AS `sWorkCenterName`,`a`.`sWorkCenterNo` AS `sWorkCenterNo`,`a`.`sTeamName` AS `sTeamName`,`a`.`sProductClassifyName` AS `sProductClassifyName`,`a`.`sMaterialsName` AS `sMaterialsName`,`a`.`sMaterialsNo` AS `sMaterialsNo`,`a`.`sMaterialsStyle` AS `sMaterialsStyle`,`a`.`iFace` AS `iFace`,`a`.`iPlate` AS `iPlate`,`a`.`dGiveQty` AS `dGiveQty`,`a`.`dStartDate` AS `dStartDate`,`a`.`sPartNameStatus` AS `sPartNameStatus`,`a`.`sMaterialsStatus` AS `sMaterialsStatus`,`a`.`tReportDate` AS `tReportDate`,`a`.`sMaterialsProductId` AS `sMaterialsProductId`,`a`.`iChangeTotal` AS `iChangeTotal`,`a`.`sWorkOrderChangeMemo` AS `sWorkOrderChangeMemo`,`a`.`bBillOutside` AS `bBillOutside`,`a`.`sDecomposeCustomize` AS `sDecomposeCustomize`,`a`.`bProductionPlanComplete` AS `bProductionPlanComplete`,`a`.`sCaclMachineId` AS `sCaclMachineId`,`a`.`dCaclProductionReportQty` AS `dCaclProductionReportQty`,`a`.`sPReserve2` AS `sPReserve2`,`a`.`dSumPlate` AS `dSumPlate`,`a`.`tChangeMachineDate` AS `tChangeMachineDate`,`a`.`bUrgent` AS `bUrgent`,`a`.`bPatrolInspection` AS `bPatrolInspection`,`a`.`bFirst1Inspection` AS `bFirst1Inspection`,`a`.`bFirst2Inspection` AS `bFirst2Inspection`,`a`.`bFirst3Inspection` AS `bFirst3Inspection`,`a`.`tPatrolInspection` AS `tPatrolInspection`,`a`.`sPatrolInspection` AS `sPatrolInspection`,`a`.`tFirst1Inspection` AS `tFirst1Inspection`,`a`.`tFirst2Inspection` AS `tFirst2Inspection`,`a`.`tFirst3Inspection` AS `tFirst3Inspection`,`a`.`sFirst1Inspection` AS `sFirst1Inspection`,`a`.`sFirst2Inspection` AS `sFirst2Inspection`,`a`.`sFirst3Inspection` AS `sFirst3Inspection`,`a`.`sReportParams` AS `sReportParams`,(`a`.`tStartDate` + interval 3 day) AS `tLimitReportDate`,`a`.`bInking` AS `bInking`,`a`.`tInkingDate` AS `tInkingDate`,`a`.`sInkingPerson` AS `sInkingPerson`,`a`.`dInkingQty` AS `dInkingQty`,`a`.`dInkingMoney` AS `dInkingMoney`,`a`.`bMould` AS `bMould`,`a`.`sMouldPerson` AS `sMouldPerson`,`a`.`tMouldDate` AS `tMouldDate`,`a`.`sMouldNo` AS `sMouldNo`,`a`.`dCalcQty1` AS `dCalcQty1`,`a`.`dCalcQty2` AS `dCalcQty2`,`a`.`dCalcQty3` AS `dCalcQty3`,`a`.`dCalcQty4` AS `dCalcQty4`,`a`.`dCalcHour1` AS `dCalcHour1`,`a`.`iBlockCount` AS `iBlockCount`,`a`.`bLock` AS `bLock`,`a`.`sLock` AS `sLock`,`a`.`tLock` AS `tLock`,`a`.`sPriorProcess` AS `sPriorProcess`,`a`.`sPriorPlate` AS `sPriorPlate`,`a`.`iAutoOrder` AS `iAutoOrder`,`a`.`sDivRow` AS `sDivRow`,`a`.`sDivRowGroupBy` AS `sDivRowGroupBy`,`a`.`bEmploy` AS `bEmploy`,`a`.`sEmployPerson` AS `sEmployPerson`,`a`.`tEmploytime` AS `tEmploytime`,`a`.`tFileDate` AS `tFileDate`,`a`.`sFilePerson` AS `sFilePerson`,`a`.`bFile` AS `bFile`,0 AS `bInvalid`,'' AS `sFormId`,1 AS `bcheck`,`a`.`bConfirm` AS `bConfirm`,`a`.`tConfirmDate` AS `tConfirmDate`,`a`.`sConfirmPerson` AS `sConfirmPerson` from `xlyweberp_saas_ai`.`mftproductionplanslave` `a`
Narrative
No human-written narrative yet.