mftqualityaccidentmaster.md
10.4 KB
mftqualityaccidentmaster
质量事故报告
- Engine: InnoDB
- Collation: utf8mb3_general_ci
Columns
| # | Name | Type | Null | Key | Default | Extra | Comment |
|---|---|---|---|---|---|---|---|
| 1 | iIncrement |
int |
NO | PRI | auto_increment | 自增列 | |
| 2 | sSrcId |
varchar(100) |
NO | 源单Id | |||
| 3 | sSrcSlaveId |
varchar(100) |
NO | 源单从表Id | |||
| 4 | sId |
varchar(100) |
NO | MUL | 标准Id | ||
| 5 | sBrandsId |
varchar(100) |
NO | MUL | 加工商Id | ||
| 6 | sSubsidiaryId |
varchar(100) |
NO | 子公司ID | |||
| 7 | tCreateDate |
datetime |
NO | CURRENT_TIMESTAMP | DEFAULT_GENERATED | 制单日期 | |
| 8 | sMakePerson |
varchar(255) |
NO | 制单人 | |||
| 9 | iOrder |
int |
NO | 0 | 排序号 | ||
| 10 | sFormId |
varchar(100) |
NO | 窗体ID | |||
| 11 | sBillNo |
varchar(255) |
NO | 单据号 | |||
| 12 | sCustomerId |
varchar(100) |
NO | 客户Id | |||
| 13 | sWorkOrderId |
varchar(100) |
NO | 工单ID | |||
| 14 | sProductId |
varchar(100) |
NO | 产品id | |||
| 15 | dRewardPunishmentMoney |
decimal(18,6) |
YES | 奖惩金额 | |||
| 16 | sReporter |
varchar(255) |
YES | 提案人 | |||
| 17 | tReportDate |
datetime |
YES | 提案日期 | |||
| 18 | sResponsibleSupplyId |
varchar(100) |
YES | 责任部门 | |||
| 19 | dProductQty |
decimal(18,6) |
YES | 需生产数 | |||
| 20 | dProductTestQty |
decimal(18,6) |
YES | 成品检验数 | |||
| 21 | dMajorDefectQty |
decimal(18,6) |
YES | 主要不良品数 | |||
| 22 | dReplenishmentQty |
decimal(18,6) |
YES | 补货数量 | |||
| 23 | sAccidentMemo |
text |
YES | 事件描述 | |||
| 24 | sReasonAnalyse |
text |
YES | 原因分析 | |||
| 25 | sReason |
varchar(255) |
YES | 提案理由 | |||
| 26 | sType |
varchar(255) |
YES | 质量类型/初步判定 | |||
| 27 | bFile |
varchar(255) |
YES | 是否有文件 | |||
| 28 | sMemo |
text |
YES | 备注 | |||
| 29 | dLoseMoney |
decimal(18,6) |
YES | 损失金额 | |||
| 30 | sResponsiblePerson |
varchar(255) |
YES | 责任人 | |||
| 31 | bCheck |
bit(1) |
NO | b'0' | 是否审核 | ||
| 32 | tCheckDate |
datetime |
YES | 审核日期 | |||
| 33 | sCheckPerson |
varchar(255) |
YES | 审核人 | |||
| 34 | bPrint |
bit(1) |
NO | b'0' | 是否打印 | ||
| 35 | bCopyLimit |
bit(1) |
NO | b'0' | 禁止拷贝 | ||
| 36 | sStatus |
varchar(255) |
YES | 状态（未审核 已审核 作废 一到四级审核） | |||
| 37 | sMachineId |
varchar(100) |
NO | 事故机台Id | |||
| 38 | bInvalid |
bit(1) |
NO | b'0' | 是否作废 | ||
| 39 | sMReserve1 |
varchar(255) |
YES | 预留字符1 | |||
| 40 | sMReserve2 |
varchar(255) |
YES | 预留字符2 | |||
| 41 | sMReserve3 |
varchar(255) |
YES | 预留字符3 | |||
| 42 | sMReserve4 |
varchar(255) |
YES | 预留字符4 | |||
| 43 | sMReserve5 |
varchar(255) |
YES | 预留字符5 | |||
| 44 | sMReserve6 |
varchar(255) |
YES | 预留字符6 | |||
| 45 | dMReserve1 |
decimal(18,6) |
YES | 预留数字1 | |||
| 46 | dMReserve2 |
decimal(18,6) |
YES | 预留数字2 | |||
| 47 | dMReserve3 |
decimal(18,6) |
YES | 预留数字3 | |||
| 48 | iMReserve1 |
int |
YES | 预留整型1 | |||
| 49 | iMReserve2 |
int |
YES | 预留整型2 | |||
| 50 | iMReserve3 |
int |
YES | 预留整型3 | |||
| 51 | tMReserve1 |
datetime |
YES | 预留日期1 | |||
| 52 | tMReserve2 |
datetime |
YES | 预留日期2 | |||
| 53 | sSrcNo |
varchar(100) |
YES | 原单号 | |||
| 54 | sUnTaskFormId |
varchar(100) |
NO | 未清界面Id | |||
| 55 | tSrcDate |
datetime |
YES | 源单时间 | |||
| 56 | sMReserve7 |
varchar(255) |
YES | 预留字符7 | |||
| 57 | sMReserve8 |
varchar(255) |
YES | 预留字符8 | |||
| 58 | sProcessId |
varchar(255) |
YES | 对应工序 | |||
| 59 | sSrctype |
varchar(100) |
NO | 来源类型 | |||
| 60 | sWorkOrderNo |
varchar(100) |
NO | 工单号 | |||
| 61 | sOrderNo |
varchar(100) |
NO | 订单号 | |||
| 62 | tCKDate |
datetime |
YES | CURRENT_TIMESTAMP | DEFAULT_GENERATED | 改善验证日期 | |
| 63 | tJZDate |
datetime |
YES | CURRENT_TIMESTAMP | DEFAULT_GENERATED | 改善措施日期 | |
| 64 | tLeaderDate |
datetime |
YES | CURRENT_TIMESTAMP | DEFAULT_GENERATED | 领导复核日期 | |
| 65 | bBad |
bit(1) |
YES | b'0' | 不良品 | ||
| 66 | bBDComplete |
bit(1) |
YES | b'0' | 补单清除 | ||
| 67 | bBF |
bit(1) |
YES | b'0' | 报废 | ||
| 68 | bBY |
bit(1) |
YES | b'0' | 补印 | ||
| 69 | bCustomerLook |
bit(1) |
YES | b'0' | 客户看色 | ||
| 70 | bDeductionCustomer |
bit(1) |
YES | b'0' | 客户索赔 | ||
| 71 | bDeductionMaterials |
bit(1) |
YES | b'0' | 供应商扣款 | ||
| 72 | bDeductionMaterialsComplete |
bit(1) |
YES | b'0' | 供应商扣款清除 | ||
| 73 | bDeductionSupply |
bit(1) |
YES | b'0' | 外协商扣款 | ||
| 74 | bDeductionSupplyComplete |
bit(1) |
YES | b'0' | 外协扣款清除 | ||
| 75 | bFG |
bit(1) |
YES | b'0' | 返工 | ||
| 76 | bFGComplete |
bit(1) |
YES | b'0' | 返工单清除 | ||
| 77 | bNext |
bit(1) |
YES | b'0' | 下次评定 | ||
| 78 | bNoObject |
bit(1) |
YES | b'0' | 无实物 | ||
| 79 | bPendingComplete |
bit(1) |
NO | b'0' | 强制完工处理客诉 | ||
| 80 | bProductRejectComplete |
bit(1) |
YES | b'0' | 质量报告报废强制完工 | ||
| 81 | BTH |
bit(1) |
YES | b'0' | 退供应商 | ||
| 82 | dAuxiliaryQty |
decimal(18,6) |
NO | 0.000000 | 材料数量/退换货数量 | ||
| 83 | dBackDeductionMaterialsMoney |
decimal(18,6) |
YES | 0.000000 | 供应商扣款金额反写 | ||
| 84 | dBackDeductionSupplyMoney |
decimal(18,6) |
YES | 0.000000 | 外协商扣款金额反写 | ||
| 85 | dDeductionCustomerMoney |
decimal(18,6) |
YES | 0.000000 | 客户索赔金额 | ||
| 86 | dDeductionMaterialsMoney |
decimal(18,6) |
YES | 0.000000 | 供应商扣款金额 | ||
| 87 | dDeductionSupplyMoney |
decimal(18,6) |
YES | 0.000000 | 外协商扣款金额 | ||
| 88 | dDefectQty |
decimal(18,6) |
NO | 0.000000 | 返工不良数量 | ||
| 89 | dMaterialsLossMoney |
decimal(18,6) |
NO | 0.000000 | 原材料费 | ||
| 90 | dMaterialsQty |
decimal(18,6) |
NO | 0.000000 | 计价数量 | ||
| 91 | dMeritsMoney |
decimal(18,6) |
YES | 0.000000 | 内部扣款金额 | ||
| 92 | dOldPrintQty |
decimal(18,6) |
YES | 0.000000 | 旧补单数量 | ||
| 93 | dOtherMoney |
decimal(18,6) |
NO | 0.000000 | 其它 | ||
| 94 | dPrintLossMoney |
decimal(18,6) |
NO | 0.000000 | 补印防损 | ||
| 95 | dPrintQty |
decimal(18,6) |
YES | 0.000000 | 补印数量 | ||
| 96 | dQualityreturnQty |
decimal(18,6) |
YES | 0.000000 | 反写数量 | ||
| 97 | dQuantityQty |
decimal(18,6) |
NO | 0.000000 | 良品数量 | ||
| 98 | dRecentPurchasePrice |
decimal(24,13) |
NO | 0.0000000000000 | |||
| 99 | dScarpQty |
decimal(18,6) |
YES | 0.000000 | 报废数量 | ||
| 100 | iCigPack |
int |
YES | 2 | 是否烟包 1：是，2：否 | ||
| 101 | iMaterialsSuorce |
int |
YES | 0 | 来源，0：检验，1：退料申请 | ||
| 102 | iReason |
int |
YES | 0 | 1-工序检验，2-材料检验，3：发外检验，4-成品检验，5-客户投诉，6-销售退货，7-补料申请，8-补版申请来源，9-工单缺数,10-退料申请，11-成品复检 | ||
| 103 | iValidComplaint |
int |
YES | 0 | 是否有效客诉 1：是 2：否 | ||
| 104 | iWork |
int |
YES | 0 | 是否和大货生产 1：否，2：是 | ||
| 105 | sCheckMemo |
varchar(4000) |
YES | 改善验证 | |||
| 106 | sCkPerson |
varchar(100) |
YES | 改善验证人 | |||
| 107 | sCustomerOrderNo |
varchar(100) |
YES | 客户订单号 | |||
| 108 | sDefineNo |
varchar(50) |
YES | 批次号 | |||
| 109 | sFlowDeptId |
varchar(50) |
YES | 审批部门 | |||
| 110 | sFlowDeptName |
varchar(1000) |
YES | 审批部门 | |||
| 111 | sInspector |
varchar(100) |
YES | 检验员 | |||
| 112 | sJzMemo |
varchar(1000) |
YES | 纠正预防/初步解决方案 | |||
| 113 | sJZPerson |
varchar(100) |
YES | 改善措施人 | |||
| 114 | sLeaderMemo |
varchar(4000) |
YES | 领导意见 | |||
| 115 | sLeaderPerson |
varchar(100) |
YES | 领导 | |||
| 116 | sMaterialsId |
varchar(100) |
NO | 材料id | |||
| 117 | sMaterialsStyle |
varchar(100) |
YES | 材料规格 | |||
| 118 | sOrderId |
varchar(100) |
YES | 订单sId | |||
| 119 | sOrderSlaveId |
varchar(100) |
YES | 订单从表sId | |||
| 120 | sProductUnit |
varchar(100) |
YES | 单位 | |||
| 121 | sPurchaseInstoreId |
varchar(100) |
NO | 采购入库从表Id | |||
| 122 | sPurchaseInstoreNo |
varchar(255) |
NO | 采购入库号 | |||
| 123 | sPurchaseInstoreSlaveId |
varchar(100) |
NO | 采购入库从表Id | |||
| 124 | sPurchaseOrderId |
varchar(100) |
NO | 采购订单从表Id | |||
| 125 | sPurchaseOrderNo |
varchar(255) |
NO | 采购订单号 | |||
| 126 | sPurchaseOrderSlaveId |
varchar(100) |
NO | 采购订单从表Id | |||
| 127 | sReprint |
varchar(100) |
YES | 是否补印 | |||
| 128 | sSrcAccidentNo |
varchar(255) |
YES | 源质量事故单号 | |||
| 129 | sSupplyId |
varchar(100) |
YES | 供应商id | |||
| 130 | sWorkOrderSlaveId |
varchar(100) |
YES | 工单从表id | |||
| 131 | sYyMemo |
varchar(1000) |
YES | 原因分析/客户其它诉求 |
Indexes
| Name | Unique | Type | Columns |
|---|---|---|---|
IndexN_mftqualityaccidentmaster |
BTREE |
sId, sBrandsId, sSubsidiaryId, sCustomerId
|
|
IndexU_mftqualityaccidentmaster |
✓ | BTREE |
sId, sBrandsId, sSubsidiaryId
|
IndexU_mftqualityaccidentmasterNo |
✓ | BTREE |
sBrandsId, sSubsidiaryId, sBillNo
|
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.