# `calcproductcontralsphase` - **Rows (estimated):** 79 - **Data size:** 224.0 KB - **Engine:** InnoDB - **Collation:** utf8mb3_general_ci - **Created:** 2026-04-27 18:51:55 - **Updated:** 2026-04-27 18:51:55 ## Columns | # | Name | Type | Null | Key | Default | Extra | Comment | |---|---|---|---|---|---|---|---| | 1 | `sId` | `varchar(100)` | NO | MUL | | | | | 2 | `sSlaveId` | `varchar(100)` | NO | | | | | | 3 | `sWorkOrderId` | `varchar(100)` | NO | | | | | | 4 | `sWorkSlaveId` | `varchar(100)` | NO | | | | | | 5 | `sPartsName` | `varchar(255)` | YES | | | | | | 6 | `tCreateDate` | `datetime` | YES | | | | | | 7 | `sBillNo` | `varchar(255)` | YES | MUL | | | | | 8 | `sOrderNo` | `text` | YES | | | | | | 9 | `tDeliverDate` | `datetime` | YES | | | | | | 10 | `sCustomerId` | `varchar(100)` | NO | | | | | | 11 | `sCustomerName` | `varchar(255)` | YES | | | | | | 12 | `sProductId` | `varchar(100)` | NO | | | | | | 13 | `sProductName` | `varchar(255)` | YES | | | | | | 14 | `sProductStyle` | `varchar(255)` | YES | | | | | | 15 | `dProductQty` | `decimal(18,6)` | YES | | | | | | 16 | `dProductInStoreQty` | `decimal(18,6)` | YES | | | | | | 17 | `sCustomerMaterialNo` | `varchar(255)` | YES | | | | | | 18 | `iOrder` | `int` | YES | | | | | | 19 | `sControlId` | `varchar(100)` | NO | | | | | | 20 | `sPartNameStatus` | `text` | YES | | | | | | 21 | `sMakePerson` | `varchar(255)` | YES | | | | | | 22 | `sProcessId` | `varchar(255)` | YES | | | | | | 23 | `sProcessName` | `varchar(255)` | YES | | | | | | 24 | `dProcessReportQty` | `decimal(18,6)` | YES | | | | | | 25 | `sReportMachineId` | `varchar(255)` | YES | | | | | | 26 | `sReportMachineName` | `varchar(255)` | YES | | | | | | 27 | `sCReserve1` | `varchar(255)` | YES | | | | | | 28 | `sMReserve1` | `varchar(255)` | YES | | | | | | 29 | `sPlannerMemo` | `varchar(255)` | YES | | | | | | 30 | `tPlannerSet` | `datetime` | YES | | | | | | 31 | `iListOrder` | `int` | YES | | 0 | | | | 32 | `sChangeMemo` | `varchar(255)` | YES | | | | | | 33 | `sPublish` | `varchar(255)` | YES | | | | | | 34 | `dProductPQty` | `decimal(18,6)` | YES | | | | | | 35 | `dSumMachineQty` | `decimal(18,6)` | YES | | | | | | 36 | `sProcessNameS` | `varchar(255)` | YES | | | | | | 37 | `tCalcDate` | `datetime` | YES | | | | | | 38 | `tOrderDate` | `datetime` | YES | | | | | | 39 | `sDeliveryMode` | `varchar(255)` | YES | | | | | | 40 | `sProductState` | `varchar(255)` | YES | | 未完成 | | | | 41 | `dGiveQty` | `decimal(18,6)` | YES | | | | | | 42 | `sManualNo` | `varchar(255)` | YES | | | | | | 43 | `sParentName` | `varchar(255)` | YES | | | | | | 44 | `dDeliverQty` | `decimal(18,6)` | YES | | | | | | 45 | `bBillComplete` | `bit(1)` | YES | | | | | | 46 | `bPlanB` | `bit(1)` | YES | | | | | | 47 | `sProductClassifyId` | `varchar(100)` | YES | | | | | | 48 | `sProductClassifyName` | `varchar(100)` | YES | | | | | | 49 | `sMaterialsStatus` | `longtext` | YES | | | | 材料状态 | | 50 | `s_文件制作-锁定_21` | `varchar(100)` | YES | | | | | | 51 | `s_文件制作-计划_22_json` | `varchar(100)` | YES | | [{"dSchedulHours":"","sState":"0"}] | | | | 52 | `s_文件制作-实际_23_json` | `varchar(100)` | YES | | [{"dSchedulHours":"","sState":"0"}] | | | | 53 | `s_蓝纸确认-锁定_24` | `varchar(100)` | YES | | | | | | 54 | `s_蓝纸确认-计划_25_json` | `varchar(100)` | YES | | [{"dSchedulHours":"","sState":"0"}] | | | | 55 | `s_蓝纸确认-实际_26_json` | `varchar(100)` | YES | | [{"dSchedulHours":"","sState":"0"}] | | | | 56 | `s_印刷阶段-锁定_27` | `varchar(100)` | YES | | | | | | 57 | `s_印刷阶段-计划_28_json` | `varchar(100)` | YES | | [{"dSchedulHours":"","sState":"0"}] | | | | 58 | `s_印刷阶段-实际_29_json` | `varchar(100)` | YES | | [{"dSchedulHours":"","sState":"0"}] | | | | 59 | `s_打码-锁定_30` | `varchar(100)` | YES | | | | | | 60 | `s_打码-计划_31_json` | `varchar(100)` | YES | | [{"dSchedulHours":"","sState":"0"}] | | | | 61 | `s_打码-实际_32_json` | `varchar(100)` | YES | | [{"dSchedulHours":"","sState":"0"}] | | | | 62 | `s_过胶-锁定_33` | `varchar(100)` | YES | | | | | | 63 | `s_过胶-计划_34_json` | `varchar(100)` | YES | | [{"dSchedulHours":"","sState":"0"}] | | | | 64 | `s_过胶-实际_35_json` | `varchar(100)` | YES | | [{"dSchedulHours":"","sState":"0"}] | | | | 65 | `s_表面处理-锁定_36` | `varchar(100)` | YES | | | | | | 66 | `s_表面处理-计划_37_json` | `varchar(100)` | YES | | [{"dSchedulHours":"","sState":"0"}] | | | | 67 | `s_表面处理-实际_38_json` | `varchar(100)` | YES | | [{"dSchedulHours":"","sState":"0"}] | | | | 68 | `s_UV-锁定_39` | `varchar(100)` | YES | | | | | | 69 | `s_UV-计划_40_json` | `varchar(100)` | YES | | [{"dSchedulHours":"","sState":"0"}] | | | | 70 | `s_UV-实际_41_json` | `varchar(100)` | YES | | [{"dSchedulHours":"","sState":"0"}] | | | | 71 | `s_模具准备-锁定_42` | `varchar(100)` | YES | | | | | | 72 | `s_模具准备-计划_43_json` | `varchar(100)` | YES | | [{"dSchedulHours":"","sState":"0"}] | | | | 73 | `s_模具准备-实际_44_json` | `varchar(100)` | YES | | [{"dSchedulHours":"","sState":"0"}] | | | | 74 | `s_模烫阶段-锁定_45` | `varchar(100)` | YES | | | | | | 75 | `s_模烫阶段-计划_46_json` | `varchar(100)` | YES | | [{"dSchedulHours":"","sState":"0"}] | | | | 76 | `s_模烫阶段-实际_47_json` | `varchar(100)` | YES | | [{"dSchedulHours":"","sState":"0"}] | | | | 77 | `s_品检阶段-锁定_48` | `varchar(100)` | YES | | | | | | 78 | `s_品检阶段-计划_49_json` | `varchar(100)` | YES | | [{"dSchedulHours":"","sState":"0"}] | | | | 79 | `s_品检阶段-实际_50_json` | `varchar(100)` | YES | | [{"dSchedulHours":"","sState":"0"}] | | | | 80 | `s_糊盒包装-锁定_51` | `varchar(100)` | YES | | | | | | 81 | `s_糊盒包装-计划_52_json` | `varchar(100)` | YES | | [{"dSchedulHours":"","sState":"0"}] | | | | 82 | `s_糊盒包装-实际_53_json` | `varchar(100)` | YES | | [{"dSchedulHours":"","sState":"0"}] | | | | 83 | `s_装订阶段-锁定_54` | `varchar(100)` | YES | | | | | | 84 | `s_装订阶段-计划_55_json` | `varchar(100)` | YES | | [{"dSchedulHours":"","sState":"0"}] | | | | 85 | `s_装订阶段-实际_56_json` | `varchar(100)` | YES | | [{"dSchedulHours":"","sState":"0"}] | | | | 86 | `s_制版-锁定_57` | `varchar(100)` | YES | | | | | | 87 | `s_制版-计划_58_json` | `varchar(100)` | YES | | [{"dSchedulHours":"","sState":"0"}] | | | | 88 | `s_制版-实际_59_json` | `varchar(100)` | YES | | [{"dSchedulHours":"","sState":"0"}] | | | | 89 | `s_蓝纸-锁定_60` | `varchar(100)` | YES | | | | | | 90 | `s_蓝纸-计划_61_json` | `varchar(100)` | YES | | [{"dSchedulHours":"","sState":"0"}] | | | | 91 | `s_蓝纸-实际_62_json` | `varchar(100)` | YES | | [{"dSchedulHours":"","sState":"0"}] | | | | 92 | `s_白样-锁定_63` | `varchar(100)` | YES | | | | | | 93 | `s_白样-计划_64_json` | `varchar(100)` | YES | | [{"dSchedulHours":"","sState":"0"}] | | | | 94 | `s_白样-实际_65_json` | `varchar(100)` | YES | | [{"dSchedulHours":"","sState":"0"}] | | | | 95 | `s_测试-锁定_66` | `varchar(100)` | YES | | | | | | 96 | `s_测试-计划_67_json` | `varchar(100)` | YES | | [{"dSchedulHours":"","sState":"0"}] | | | | 97 | `s_测试-实际_68_json` | `varchar(100)` | YES | | [{"dSchedulHours":"","sState":"0"}] | | | | 98 | `s_数码-锁定_69` | `varchar(100)` | YES | | | | | | 99 | `s_数码-计划_70_json` | `varchar(100)` | YES | | [{"dSchedulHours":"","sState":"0"}] | | | | 100 | `s_数码-实际_71_json` | `varchar(100)` | YES | | [{"dSchedulHours":"","sState":"0"}] | | | | 101 | `s_设计-锁定_72` | `varchar(100)` | YES | | | | | | 102 | `s_设计-计划_73_json` | `varchar(100)` | YES | | [{"dSchedulHours":"","sState":"0"}] | | | | 103 | `s_设计-实际_74_json` | `varchar(100)` | YES | | [{"dSchedulHours":"","sState":"0"}] | | | ## Indexes | Name | Unique | Type | Columns | |---|---|---|---| | `IndexU_CalcProductContralsPhase` | | BTREE | `sId` | | `IndexU_CalcProductContralsPhaseBillNo` | | BTREE | `sBillNo` | ## Narrative _No human-written narrative yet — when this table is exercised by a [vertical slice](../../slices/index.md), link from there back to this page._