mftproductionreportslave.md
14.8 KB
mftproductionreportslave
送货通知单从表
- Rows (estimated): 169
- Data size: 304.0 KB
- Engine: InnoDB
- Collation: utf8mb3_general_ci
- Created: 2026-04-27 18:53:35
- Updated: 2026-04-27 18:53:35
Columns
| # | Name | Type | Null | Key | Default | Extra | Comment |
|---|---|---|---|---|---|---|---|
| 1 | iIncrement |
int |
NO | PRI | auto_increment | 自增列 | |
| 2 | sId |
varchar(100) |
NO | MUL | 唯一ID | ||
| 3 | sBrandsId |
varchar(100) |
NO | 加工商ID | |||
| 4 | sSubsidiaryId |
varchar(100) |
NO | 子公司ID | |||
| 5 | iOrder |
int |
NO | 0 | 排序号 | ||
| 6 | sMakePerson |
varchar(255) |
NO | 制单人 | |||
| 7 | sParentId |
varchar(100) |
NO | 父级ID | |||
| 8 | sCustomerId |
varchar(100) |
NO | 客户Id | |||
| 9 | sManualNo |
varchar(255) |
YES | 手工单号 | |||
| 10 | sCustomerOrderNo |
varchar(255) |
YES | 客户订单号 | |||
| 11 | sProductId |
varchar(100) |
NO | 印件Id | |||
| 12 | sProcessId |
varchar(100) |
NO | MUL | 工序Id | ||
| 13 | dProductQty |
decimal(18,6) |
NO | 0.000000 | 产品数量 | ||
| 14 | sSrcControlId |
varchar(100) |
YES | 源单控制表Id | |||
| 15 | sPartsName |
varchar(255) |
YES | 部件名称 | |||
| 16 | sMachineId |
varchar(255) |
YES | 机台Id | |||
| 17 | tStartDate |
datetime |
YES | 开始日期 | |||
| 18 | tEndDate |
datetime |
YES | 结束日期 | |||
| 19 | sMaterialsId |
varchar(255) |
YES | 材料Id | |||
| 20 | sEmployeeId |
varchar(100) |
NO | 员工Id | |||
| 21 | sTeamId |
varchar(100) |
NO | 班组Id | |||
| 22 | dProcessQty |
decimal(18,6) |
NO | 0.000000 | 上报数量 | ||
| 23 | dConversionQty |
decimal(18,6) |
NO | 0.000000 | 换算数量 | ||
| 24 | dHour |
decimal(18,6) |
NO | 0.000000 | 工时 | ||
| 25 | sWageId |
varchar(100) |
NO | 计件工资Id | |||
| 26 | dQualifiedProductionQty |
decimal(18,6) |
NO | 0.000000 | 合格数 | ||
| 27 | dNoQualifiedProductQty |
decimal(18,6) |
NO | 0.000000 | 不合格数 | ||
| 28 | dWasteProductionQty |
decimal(18,6) |
NO | 0.000000 | 作废数量 | ||
| 29 | dAdjustableQty |
decimal(18,6) |
NO | 0.000000 | 调机次数 | ||
| 30 | dMakeReadyQty |
decimal(18,6) |
NO | 0.000000 | 调机数量 | ||
| 31 | dMakeReadyMoney |
decimal(18,6) |
NO | 0.000000 | 调机费用 | ||
| 32 | dEquivalentQty |
decimal(18,6) |
NO | 0.000000 | 折合产量 | ||
| 33 | dWageMoney |
decimal(18,6) |
NO | 0.000000 | 计件工资 | ||
| 34 | dTimeMoney |
decimal(18,6) |
NO | 0.000000 | 工时工资 | ||
| 35 | dLossMoney |
decimal(18,6) |
NO | 0.000000 | 损失金额 | ||
| 36 | dOtherMoney |
decimal(18,6) |
NO | 0.000000 | 其他金额 | ||
| 37 | dAllMoney |
decimal(18,6) |
NO | 0.000000 | 总金额 | ||
| 38 | sMaterialsMemo |
text |
YES | 材料备注 | |||
| 39 | sProcessMemo |
text |
YES | 工序备注 | |||
| 40 | sSrcSlaveId |
varchar(100) |
NO | MUL | 源单从表Id | ||
| 41 | sSrcId |
varchar(100) |
NO | 源单ID | |||
| 42 | sSrcNo |
varchar(255) |
NO | 源单号 | |||
| 43 | dSrcQty |
decimal(18,6) |
YES | 源单数量 | |||
| 44 | dProductPQty |
decimal(18,6) |
YES | 产品总P数 | |||
| 45 | sSlaveMemo |
text |
YES | 从表备注 | |||
| 46 | sWebOrderNo |
varchar(255) |
NO | 网上订单号 | |||
| 47 | sWebOrderId |
varchar(100) |
NO | 网上订单Id | |||
| 48 | sBarcode |
varchar(255) |
YES | 条形码 | |||
| 49 | sOrderId |
varchar(100) |
NO | MUL | 订单ID | ||
| 50 | sOrderSlaveId |
varchar(100) |
NO | 订单从表Id | |||
| 51 | sOrderNo |
varchar(255) |
NO | 订单号 | |||
| 52 | sWorkOrderId |
varchar(100) |
NO | 工单ID | |||
| 53 | sWorkOrderSlaveId |
varchar(100) |
NO | 工单从表Id | |||
| 54 | sWorkOrderNo |
varchar(255) |
NO | 工单ID | |||
| 55 | sWorkOrderControlId |
varchar(100) |
NO | MUL | 工单控制表ID | ||
| 56 | sWorkOrderProcessTbId |
varchar(100) |
NO | 工单工序表Id | |||
| 57 | sWorkOrderMaterialsTbId |
varchar(100) |
NO | 工单材料表id | |||
| 58 | sSReserve1 |
varchar(255) |
YES | 预留字符1 | |||
| 59 | sSReserve2 |
varchar(255) |
YES | 预留字符2 | |||
| 60 | sSReserve3 |
varchar(255) |
YES | 预留字符3 | |||
| 61 | sSReserve4 |
varchar(255) |
YES | 预留字符4 | |||
| 62 | sSReserve5 |
varchar(255) |
YES | 预留字符5 | |||
| 63 | sSReserve6 |
varchar(255) |
YES | 预留字符6 | |||
| 64 | dSReserve1 |
decimal(18,6) |
YES | 预留数字1 | |||
| 65 | dSReserve2 |
decimal(18,6) |
YES | 预留数字2 | |||
| 66 | dSReserve3 |
decimal(18,6) |
YES | 预留数字3 | |||
| 67 | iSReserve1 |
int |
YES | 预留整型1 | |||
| 68 | iSReserve2 |
int |
YES | 预留整型2 | |||
| 69 | iSReserve3 |
int |
YES | 预留整型3 | |||
| 70 | tSReserve1 |
datetime |
YES | 预留日期1 | |||
| 71 | tSReserve2 |
datetime |
YES | 预留日期2 | |||
| 72 | sParam1 |
varchar(255) |
YES | 参数1 | |||
| 73 | sParam2 |
varchar(255) |
YES | 参数2 | |||
| 74 | sParam3 |
varchar(255) |
YES | 参数3 | |||
| 75 | sParam4 |
varchar(255) |
YES | 参数4 | |||
| 76 | sParam5 |
varchar(255) |
YES | 参数5 | |||
| 77 | sParam6 |
varchar(255) |
YES | 参数6 | |||
| 78 | sParamValue1 |
varchar(255) |
YES | 参数值1 | |||
| 79 | sParamValue2 |
varchar(255) |
YES | 参数值2 | |||
| 80 | sParamValue3 |
varchar(255) |
YES | 参数值3 | |||
| 81 | sParamValue4 |
varchar(255) |
YES | 参数值4 | |||
| 82 | sParamValue5 |
varchar(255) |
YES | 参数值5 | |||
| 83 | sParamValue6 |
varchar(255) |
YES | 参数值6 | |||
| 84 | sUnTaskFormId |
varchar(100) |
NO | 未清界面Id | |||
| 85 | tSrcDate |
datetime |
YES | 源单时间 | |||
| 86 | sParam7 |
varchar(255) |
NO | 参数7 | |||
| 87 | sParam8 |
varchar(255) |
NO | 参数8 | |||
| 88 | sParam9 |
varchar(255) |
NO | 参数9 | |||
| 89 | sParam10 |
varchar(255) |
NO | 参数10 | |||
| 90 | sParamValue7 |
varchar(255) |
NO | 参数值7 | |||
| 91 | sParamValue8 |
varchar(255) |
NO | 参数值8 | |||
| 92 | sParamValue9 |
varchar(255) |
NO | 参数值9 | |||
| 93 | sParamValue10 |
varchar(255) |
NO | 参数值10 | |||
| 94 | sMachineWorkId |
varchar(255) |
NO | OEE任务Id | |||
| 95 | sMaterialsProductId |
varchar(255) |
NO | 材料工单产品ID | |||
| 96 | dMakeReadyHour |
decimal(18,6) |
NO | 0.000000 | 准备时间 | ||
| 97 | tAdjustableDate |
datetime |
YES | CURRENT_TIMESTAMP | DEFAULT_GENERATED | 调机结束时间 | |
| 98 | tAffirmDate |
datetime |
YES | CURRENT_TIMESTAMP | DEFAULT_GENERATED | 主管确认时间 | |
| 99 | tVestingDate |
datetime |
YES | CURRENT_TIMESTAMP | DEFAULT_GENERATED | 归属日期 | |
| 100 | bAffirm |
bit(1) |
NO | b'0' | 是否确认 | ||
| 101 | dAbnormalHour |
decimal(18,6) |
YES | 0.000000 | 设备异常时间 | ||
| 102 | dAdjustableHour |
decimal(18,0) |
NO | 0 | 实际调机时间 | ||
| 103 | dAdjustEmpHour |
decimal(18,6) |
NO | 0.000000 | 确认后人工总工时 | ||
| 104 | dAjustReportPlanHour |
decimal(18,6) |
NO | 0.000000 | 调整时间 | ||
| 105 | dAjustReportPlanQty |
decimal(18,6) |
NO | 0.000000 | 调整数量 | ||
| 106 | dAllHour |
decimal(18,0) |
NO | 0 | 总工时 | ||
| 107 | dCalculateMoney |
decimal(18,2) |
YES | 0.00 | 计算金额 | ||
| 108 | dCalculatePrice |
decimal(18,2) |
YES | 0.00 | 单价 | ||
| 109 | dColorMoney |
decimal(18,2) |
YES | 0.00 | 色数总价 | ||
| 110 | dColorNum |
decimal(18,2) |
YES | 0.00 | 色数 | ||
| 111 | dColorOrder |
decimal(18,3) |
YES | 0.000 | 色令 | ||
| 112 | dColorOrderMoney |
decimal(18,2) |
YES | 0.00 | 色令金额 | ||
| 113 | dEmpHour |
decimal(18,6) |
YES | 0.000000 | 人工总工时 | ||
| 114 | dEstHour |
decimal(18,2) |
YES | 0.00 | 用餐时间 | ||
| 115 | dFileErrHour |
decimal(18,6) |
YES | 0.000000 | 文件异常时间 | ||
| 116 | dLookColorHour |
decimal(18,6) |
YES | 0.000000 | 用户看色时间 | ||
| 117 | dMachineLength |
decimal(18,6) |
YES | 0.000000 | 上机长度 | ||
| 118 | dMachineWidth |
decimal(18,6) |
YES | 0.000000 | 上机宽度 | ||
| 119 | dMaintainHour |
decimal(18,6) |
YES | 0.000000 | 设备保养时间 | ||
| 120 | dOpenMoney |
decimal(18,2) |
YES | 0.00 | 开机费 | ||
| 121 | dOriginalHour |
decimal(18,6) |
NO | 0.000000 | 原始工时 | ||
| 122 | dOriginalProcessQty |
decimal(18,6) |
NO | 0.000000 | 原始上报数量 | ||
| 123 | dOriginalWageMoney |
decimal(18,6) |
NO | 0.000000 | 原始计件工资 | ||
| 124 | dOtherHour |
decimal(18,0) |
NO | 0 | 异常工时 | ||
| 125 | dOutOpenMoney |
decimal(18,2) |
YES | 0.00 | 超色数开机费 | ||
| 126 | dPagerErrHour |
decimal(18,6) |
YES | 0.000000 | 纸张异常时间 | ||
| 127 | dPaperFeed |
decimal(8,2) |
YES | 0.00 | 进纸方向尺寸 | ||
| 128 | dQualityQty1 |
decimal(18,6) |
NO | 0.000000 | 色差 | ||
| 129 | dQualityQty10 |
decimal(18,6) |
NO | 0.000000 | 粉团 | ||
| 130 | dQualityQty11 |
decimal(18,6) |
NO | 0.000000 | 纸皮 | ||
| 131 | dQualityQty2 |
decimal(18,6) |
NO | 0.000000 | 套印不正 | ||
| 132 | dQualityQty3 |
decimal(18,6) |
NO | 0.000000 | 水干不正 | ||
| 133 | dQualityQty4 |
decimal(18,6) |
NO | 0.000000 | 白点/墨屎 | ||
| 134 | dQualityQty5 |
decimal(18,6) |
NO | 0.000000 | 拖花 | ||
| 135 | dQualityQty6 |
decimal(18,6) |
NO | 0.000000 | 过底/污渍 | ||
| 136 | dQualityQty7 |
decimal(18,6) |
NO | 0.000000 | 其它 | ||
| 137 | dQualityQty8 |
decimal(18,6) |
NO | 0.000000 | 规矩不准 | ||
| 138 | dQualityQty9 |
decimal(18,6) |
NO | 0.000000 | 皱纸 | ||
| 139 | dStdAdjustHour |
decimal(18,6) |
NO | 0.000000 | 标准调机时间 | ||
| 140 | dStdHour |
decimal(18,6) |
NO | 0.000000 | 标准生产时间 | ||
| 141 | dSumEmpNum |
decimal(18,2) |
YES | 0.00 | 生产人数 | ||
| 142 | dTimeHourMoney |
decimal(18,6) |
NO | 0.000000 | 小时工资 | ||
| 143 | dTwoAdjustHour |
decimal(18,6) |
YES | 0.000000 | 二次调机时间 | ||
| 144 | dUnilateral |
decimal(18,2) |
YES | 0.00 | 粘单变尺寸 | ||
| 145 | dWageMoney1 |
decimal(18,6) |
NO | 0.000000 | 奖项1金额 | ||
| 146 | dWageMoney10 |
decimal(18,6) |
NO | 0.000000 | 奖项10金额 | ||
| 147 | dWageMoney11 |
decimal(18,6) |
NO | 0.000000 | 奖项11金额 | ||
| 148 | dWageMoney12 |
decimal(18,6) |
NO | 0.000000 | 奖项12金额 | ||
| 149 | dWageMoney13 |
decimal(18,6) |
NO | 0.000000 | 奖项13金额 | ||
| 150 | dWageMoney14 |
decimal(18,6) |
NO | 0.000000 | 奖项14金额 | ||
| 151 | dWageMoney15 |
decimal(18,6) |
NO | 0.000000 | 奖项15金额 | ||
| 152 | dWageMoney16 |
decimal(18,6) |
NO | 0.000000 | 奖项16金额 | ||
| 153 | dWageMoney17 |
decimal(18,6) |
NO | 0.000000 | 奖项17金额 | ||
| 154 | dWageMoney18 |
decimal(18,6) |
NO | 0.000000 | 奖项18金额 | ||
| 155 | dWageMoney19 |
decimal(18,6) |
NO | 0.000000 | 奖项19金额 | ||
| 156 | dWageMoney2 |
decimal(18,6) |
NO | 0.000000 | 奖项2金额 | ||
| 157 | dWageMoney20 |
decimal(18,6) |
NO | 0.000000 | 奖项20金额 | ||
| 158 | dWageMoney21 |
decimal(18,6) |
NO | 0.000000 | 奖项21金额 | ||
| 159 | dWageMoney22 |
decimal(18,6) |
NO | 0.000000 | 奖项22金额 | ||
| 160 | dWageMoney23 |
decimal(18,6) |
NO | 0.000000 | 奖项23金额 | ||
| 161 | dWageMoney24 |
decimal(18,6) |
NO | 0.000000 | 奖项24金额 | ||
| 162 | dWageMoney25 |
decimal(18,6) |
NO | 0.000000 | 奖项25金额 | ||
| 163 | dWageMoney3 |
decimal(18,6) |
NO | 0.000000 | 奖项3金额 | ||
| 164 | dWageMoney4 |
decimal(18,6) |
NO | 0.000000 | 奖项5金额 | ||
| 165 | dWageMoney6 |
decimal(18,6) |
NO | 0.000000 | 奖项6金额 | ||
| 166 | dWageMoney7 |
decimal(18,6) |
NO | 0.000000 | 奖项7金额 | ||
| 167 | dWageMoney8 |
decimal(18,6) |
NO | 0.000000 | 奖项8金额 | ||
| 168 | dWageMoney9 |
decimal(18,6) |
NO | 0.000000 | 奖项9金额 | ||
| 169 | iChange |
int |
YES | 0 | 时间变更 | ||
| 170 | iFull |
int |
YES | 0 | 专满版 | ||
| 171 | iOutColor |
int |
YES | 0 | 超4色色数 | ||
| 172 | iTwoFull |
int |
YES | 0 | 专满版两座印 | ||
| 173 | sAffirm |
varchar(255) |
NO | 确认人 | |||
| 174 | sConfirmDayInfo |
varchar(50) |
NO | 是否确认(可汇总日统计) | |||
| 175 | sDaySumReportId |
varchar(50) |
NO | 日统计Id | |||
| 176 | sOeeMemo |
text |
YES | 上报备注 | |||
| 177 | sOppositeColor |
varchar(255) |
YES | 反面颜色 | |||
| 178 | sParams |
text |
YES | 动态参数 | |||
| 179 | sPayrollCalculate |
varchar(50) |
NO | 工资计算方式 | |||
| 180 | sPositiveColor |
varchar(255) |
YES | 正面颜色 | |||
| 181 | sPrintMachineId |
varchar(100) |
NO | 印刷机台Id | |||
| 182 | sPrintTeamId |
varchar(100) |
NO | 印刷班组Id | |||
| 183 | sSrcFormId |
varchar(255) |
NO | 源formId | |||
| 184 | sTeamType |
varchar(50) |
YES | （1：白班，2：晚班） | |||
| 185 | sZFParams |
varchar(255) |
YES | 正反面 |
Indexes
| Name | Unique | Type | Columns |
|---|---|---|---|
IndexN_mftproductionreportslave |
BTREE |
sId, sBrandsId, sSubsidiaryId, sParentId
|
|
IndexN_MftProductionReportSlaveOrderIdProductId |
BTREE |
sOrderId, sProductId, sParentId, sBrandsId, sSubsidiaryId
|
|
IndexN_MftProductionReportSlaveProcessIdProductId |
BTREE |
sProcessId, sParentId, sProductId, sBrandsId, sSubsidiaryId
|
|
IndexN_MftProductionReportSlaveSrcSlaveId |
BTREE |
sSrcSlaveId, sParentId, sBrandsId, sSubsidiaryId
|
|
IndexN_MftProductionReportSlaveSrcSlaveId2 |
BTREE |
sSrcSlaveId, sBrandsId, sSubsidiaryId
|
|
IndexN_MftProductionReportSlaveWorkOrderControlId |
BTREE |
sWorkOrderControlId, sParentId, sBrandsId, sSubsidiaryId
|
|
IndexU_mftproductionreportslave |
✓ | BTREE |
sId, sBrandsId, sSubsidiaryId
|
PRIMARY |
✓ | BTREE | iIncrement |
Narrative
No human-written narrative yet — when this table is exercised by a vertical slice, link from there back to this page.