励晶产品生产数据集

将“7个核心字段”抽象为最小生产数据后，可在多个高频业务场景中应用，以下是5个典型示例： 1）现场报工/产量统计：工人或机台完成工序后需快速报产量，否则影响工资计算和排产。通过扫描工单条码，系统自动带出品号、工艺、生产仓库等信息，输入完工数量后生成批号并记录入库日。一条记录即可锁定产量与时间。 2）质量追溯/召回：客诉或抽检发现不良时，需快速定位问题批次、工单和工艺。利用“批号”反查，可瞬间锁定同批产品去向。 3）库存账实核对：月底盘点时，若系统库存与实物不符，需定位差异批次。按“仓库+品号+批号”比对系统账与实物数量，精准定位差异。 4）委外对账：供应商送货数量与验收数有差异时，需核对应付款项。以“工单+批号”为键，比对供应商回传数量与企业验收数，差异即为报废数。7个字段是委外结算的最小凭证。 5）计划排产/APS滚动：计划员需实时掌握工单完成情况以滚动排产。通过“工单编号”汇总已完工数量，计算剩余量。7个字段构成APS的输入底座，支撑排产引擎滚动。 抓住“品号-工单-工艺-数量-入库日-仓库-批号”7个字段，可在生产运营中快速定位、统计、追溯、结算、排产，实现“小数据、大作用”。

After abstracting the "7 core fields" into minimal production data, it can be applied in multiple high-frequency business scenarios. Here are 5 typical examples:
1) On-site Job Reporting/Output Statistics: After workers or machines complete a process, they need to quickly report output, otherwise it will affect salary calculation and production scheduling. By scanning the work order barcode, the system automatically pulls in information such as product number, process, and production warehouse. After entering the completed quantity, a batch number is generated and the inbound date is recorded. One single record can lock both the output volume and the corresponding time.
2) Quality Traceability/Recall: When defects are found through customer complaints or spot checks, it is necessary to quickly locate the problematic batch, work order and process. Using the "batch number" for reverse query can instantly lock the whereabouts of products in the same batch.
3) Inventory Book-Physical Reconciliation: During month-end inventory counting, if the system inventory does not match the physical inventory, the difference batch needs to be located. Compare the system account and physical quantity by "warehouse + product number + batch number" to accurately pinpoint the discrepancy.
4) Outsourcing Settlement Reconciliation: When there is a difference between the supplier's delivery quantity and the accepted quantity, accounts payable needs to be verified. Taking "work order + batch number" as the key, compare the quantity returned by the supplier with the enterprise's accepted quantity, and the difference is the scrap quantity. The 7 core fields serve as the minimal voucher for outsourcing settlement.
5) Production Scheduling/APS Rolling Scheduling: Planners need to grasp the completion status of work orders in real time to conduct rolling scheduling. Summarize the completed quantity by "work order number" and calculate the remaining quantity. The 7 core fields form the input foundation for APS, supporting the rolling operation of the scheduling engine.
By focusing on the 7 fields of "product number - work order - process - quantity - inbound date - warehouse - batch number", enterprises can quickly locate, count, trace, settle and schedule in production operations, realizing the effect of "small data, great impact".

搜集汇总

背景与挑战

背景概述

该数据集由广东励晶智能照明有限公司申请，包含产品生产核心字段如品号、工单、工艺、数量等，用于生产优化、效率提升和质量追溯；数据格式为Xlsx，来源于企业自行产生，并已获得深圳市数据知识产权登记系统认证，有效期为2025年至2030年。