Forming underwear machine glove machine Data Acquisition networking technology solution - Digital transformation of intelligent factory workshop

As a professional provider of IoT data acquisition solutions and an expert in industrial IoT data acquisition, the editor of Shanghai Data Acquisition IOT Technology Co., Ltd， (daq-iot) hereby presents the following introduction, and sincerely welcomes discussions and exchanges. Supported Communication Interfaces: CAN, RS485, Mbus, 4–20mA, Profibus, CC-Link, HART, digital I/O, etc. Industrial Protocols: Modbus RTU/TCP, HJ212, IEC104, DLT645, DLMS, IEC61850, MQTT, etc. Mail:export@daq-iot.com

asIoTData Acquisitionsolution Professional provider,Industrial Data AcquisitionExpert (professional), data acquisition IoT editor daq iot would like to introduce the following content here, and sincerely welcome everyone to discuss and exchange ideas.

As a professional internet of things data acquisition solutions provider, industrial data acquisition experts (professional households), digital internet of things editor daq - iot here to do the following introduction, and sincerely welcome everyone to discuss and exchange.

Field Data Type Description

SERIAL_CODE nvarchar(16) Data Collection IoT DAQ-IoTserial number

IP_SDREESS nvarchar (16) Data Acquisition IoTDAQ-IoTIP Address

MACH_TYPE bit data acquisition IoTDAQ-IoTtype (1: Horizontal machine 2: Underwear machine 3: Stocking machine)

TYPE-CODE nvarchar (8) models such as GDN-8

DIAMETER bit data acquisition IoT DAQ-IoT tube diameter

NEEDLES small needle count

SERVO_TYPE bit Servo boardtype

STEP_TYPE bit Step boardtype

SHUTTLE_TYPE bit Shuttle boardtype

NEEDLE_TYPE bit Needle selection boardtype

SWITCH_TYPE bit Adapter boardtype

TRIANGLE_TYPE bit Triangle type

DENSITY_TYPE bit Density type

CTRL169-PODE bit 169 control mode

NEEDLE_EXE_MODE bit Needle selection execution method

HEADLES_TTYPE bit headless machine type

DIAMETER-ZERO-POS small syringe zero position

FAULTRA-NEEDLE small fault-tolerant needle

HEAD-ZERO-POS smallint machine head zero position

HEAD-INDUCT_SHILDE bit head induction shielding

Fast_SHIELD bit fast forward function blocked

FASTBACK_SHIELD bit fast return function is blocked

INTERRUPT_ERROR bit interrupt error detection

BTSR_Filter bit BTSR filtering

BTSR_COMM-PODE bit BTSR communication mode

PLAY nvarchar (16) location

Responsor nvarchar (16) responsible person

SETUP_daTE smalltimestamp factory entry date

MANU_SACTOR nvarchar (32) supplier

Smallint communication method

PRO_VERSION nvarchar (50) application version

MAINPRO_VERSION nvarchar (50) main program version

INTPRO_VERSION nvarchar (50) Interrupt Program Version

VIEWPRO_VERSION nvarchar (50) interface program version

Nvarchar (50) group number

2、 State Table of Data Acquisition IoT DAQ-IoT

The operational status and production information ofReal-timein the data collection IoT system.

Field Data Type Description

Serial Number: DAQ-IoT

MACH_CODE nvarchar (16) machine number

RECORD_TIME DATE records data collection IoT time

RUN Status Small Running Status

Work State Small Work Status

WORK_SRDERCODE nvarcha (32) Dispatch Order Number

CODEFHIR nvarchar (32) program name

PLAN AMOUNT int Planned Production

DONEPAMOUNT int completed production

Waste quantity of WASTEPAMOUNT smallint

Waste loss of WASTE_LOSS int (%)

FRONT_SCOND smallint front piece count IoT time (seconds)

SPEED smallint data acquisition IoT DAQ-IoT speed

ALL-COURSE smallint total horizontal column

NOW-COURSE smallint current horizontal column

RUN_COINTE int Run data acquisition IoT time

TOTAL-MINTE int Power on data acquisition IoT time

OTHER_MINUTE int

Smallint job type (0, normal 1, sampling)

The smallint team completed the output

Quantity of scrap products in the smallint team

Waste loss of int team (%)

The operation data and IoT time of the GROUP _ RUN_ MENT small team are collected

GROUP, STOP, MENT, small team downtime data collection, IoT time

Shift No Small Current Shift Number

SHIFT-NAME nvarchar (16) Current shift name

TOTAL-AMOUNT_KNUM int completed production * opening quantity

Waste Quantity * Open Quantity

KNUM int opening number

3、 Alarm Information Table (NET_LARN-IN)

List of alarm information for data collection IoT DAQ-IoT.

Field Data Type Description

Warning CODE int Error Number

MACH_TYPE tinyint data acquisition IoTDAQ-IoTtype

Warning DESCRIBE nvarchar (50) Error Description

4、 Data Collection IoT DAQ-IoT Alarm Table (NETVNet Warning)

Historical record table of data collection IoT DAQ-IoT alarm information.

Field Data Type Description

ID int automatic numbering

MACH_CODE nvarchar (16) machine number

Warning CODE int Error Number

BEGIN_TIME start data collection IoT time

END_TIME DATE End data collection IoT time

5、 Data Collection IoT DAQ-IoT Status Record Table (NET_STATE_LOG)

Historical record table of data collection IoT DAQ-IoT status information.

Field Data Type Description

ID Int automatic numbering

MACH_CODE nvarchar (16) machine number

CODEFHIR nvarchar (32) program name

PLAN AMOUNT int Planned Production

DONEPAMOUNT int completed production

Waste quantity of WASTEPAMOUNT smallint

Waste loss of WASTE_LOSS int (%)

RUN_COINTE int Run data acquisition IoT time

TOTAL-MINTE int Power on data acquisition IoT time

START_TIME start data collection IoT time

END_TIME DATE End data collection IoT time

6、 Shift Information Table (NET-DUTY-INFO)

The schedule information table for factory employees.

Field Data Type Description

ID int automatic numbering

MACH_CODE nvarchar (16) data acquisition IoT DAQ-IoT number

FACTORYNAME nvarchar (16) Factory Name

WORKERCODE nvarchar (8) Worker ID

Worker Name nvarchar (16)

Shift No Tinint

Shift Name (16)

BEGIN_TIME start data collection IoT time

END_TIME DATE End data collection IoT time

7、 Shift Production Table (NET-DUTY-LOG)

According to the employee's scheduling information, the data acquisition IoT DAQ-IoT automatically records the production information table.

Field Data Type Description

ID int automatic numbering

MACH_CODE nvarchar (16) data acquisition IoT DAQ-IoT number

Work Order Number (16)

TOTAL_ AMOUNT int Total production

Waste quantity of WASTEPAMOUNT smallint

WASTE_LOSS int Waste Loss

The number of defective products (manually entered)

INFERIOR_CDE smallint defect code (manually entered)

RUN-MINTE smallint operation data collection IoT time

STOP_MENT smallint shutdown data collection IoT time

BEGIN_TIME_StartDate starts counting IoT time

END_TIME_ End Date Data Collection IoT Time

CODEFHIR nvarchar (64) program name

TOTAL-AMOUNT_KNUM int completed production * opening quantity

Waste Quantity * Open Quantity

KNUM int opening number

8、 Factory Table (NET-DEPARTMENT INFO)

Factory information sheet.

Field Data Type Description

FACTORY-CODE nvarchar (8) Factory Number

Factory_NAME nvarchar (16) Factory Name

9、 Factory Department Table (NET-DEPARTMENT INFO)

Factory Department Information Table.

Field Data Type Description

DEPARTMENT CODE nvarchar (8) Department Number

DEPARTMENT NAME nvarchar (16) Department Name

10、 Worker List (NETWORKERS-IN)

List of factory department workers.

Field Data Type Description

WORKERCODE nvarchar (8) Worker ID

FACTORY-CODE nvarchar (8) Factory Number

DEPARTMENT CODE nvarchar (8) Department Number

Worker Name nvarchar (16)

11、 Defective Product Code Table

Defective product code editing table.

Field Data Type Description

CODE smallint defective product code

DESCRIBE nvarchar (50) Defective Product Description

12、 Data Collection IoT Order Table

Data Collection IoT Order Dispatch Form.

Field Data Type Description

ORDERCODE nvarchar (16) Data Acquisition IoT Order Number

WORK_SRDERCODE nvarcha (32) Dispatch Order Number

TARGET_ AMOUNT small number of targets

SAMPLE-CODE nvarchar (16) model number

SIZE nvarchar (8) size

COLOR nvarchar (8) colors

MATERIAL-CODE nvarchar (16) raw material batch

CODEFHIR nvarchar (32) program name

DESCRIBE nvarchar (32) Description

Nvarchar (32) Product Name

UNIT-NAME nvarchar (16 unit names)

TIZISE nvarchar (16 tone color)

nvarchar(16

START_TIME start data collection IoT time

13、 Shift Model Table (NET_Shift_MODEL)

Shift information setting table.

Field Data Type Description

MODEL_NAME nvarchar (16) shift model name

SHIFT-NAME1 nvarchar (16) shift name 1

BEGIN_TIME1 nvarchar (8) shift starts data collection IoT time 1

END_TIME1 nvarchar (8) end of shift data acquisition IoT time 1

The team to which GROUP P1 nvarchar (8) belongs

SHIFT-NAME2 nvarchar (16) shift name 2

BEGIN_TIME2 nvarchar (8) shift starts data collection IoT time 2

END_TIME2 nvarchar (8) End of shift data acquisition IoT time 2

The team to which GROUP 2 nvarchar (8) belongs

SHIFT-NAME3 nvarchar (16) shift name 3

BEGIN_TIME3 nvarchar (8) shift starts data collection IoT time 3

END_TIME3 nvarcha (8) End of shift data acquisition IoT time 3

The team to which GROUP P3 nvarchar (8) belongs

SHIFT-NAME4 nvarchar (16) shift name 4

BEGIN_TIME4 nvarchar (8) shift starts data collection IoT time 4

END_TIME4 nvarchar (8) End of shift data acquisition IoT time 4

The team to which GROUP 4 nvarchar (8) belongs

SHIFT-NAME5 nvarchar (16) shift name 5

BEGIN_TIME5 nvarchar (8) shift starts data collection IoT time 5

END_TIME5 nvarchar (8) End of shift data acquisition IoT time 5

The team to which GROUP 5 nvarchar (8) belongs

SHIFT-NAME6 nvarchar (16) shift name 6

BEGIN_TIME6 nvarchar (8) shift starts data collection IoT time 6

END_TIME6 nvarchar (8) End of shift data acquisition IoT time 6

The team to which GROUP P6 nvarchar (8) belongs

14、 Number of shifts: IoT order production record (NET-AMUNT_LOG)

A production record table containing complete fields of data acquisition IoT order information and employee information.

Field Data Type Description

ORDERCODE nvarchar (16) Data Acquisition IoT Order Number

MACH_CODE nvarchar (16) data acquisition IoTDAQ-IoTencoding

TOTAL_ AMOUNT int Total production

Waste quantity of WASTEPAMOUNT smallint

WASTE_LOSS int Waste Loss

The number of defective products (manually entered)

INFERIOR_CDE smallint defect code (manually entered)

RUN-MINTE smallint operation data collection IoT time

STOP_MENT smallint shutdown data collection IoT time

BEGIN_TIME_StartDate starts counting IoT time

END_TIME_ End Date Data Collection IoT Time

Factory_NAME nvarchar (16) Factory Name

WORKERCODE nvarchar (8) Worker ID

Worker Name nvarchar (16)

Shift No Tinyint

Shift Name (16)

ORDERCODE nvarcha (16) Data Collection IoT Order Number

WORK_SRDERCODE nvarcha (32) Dispatch Order Number

CODEFHIR nvarchar (32) program name

Target production of TARGET_ AMOUNT smallint

SAMPLE-CODE nvarchar (16) model number

SIZE nvarchar (8) size

COLOR nvarchar (8) colors

MATERIAL-CODE nvarchar (16) raw material batch

DESCRIBE nvarchar (32) Description

SAMPLE-NAME nvarchar (32) Product Name

UNIT-NAME nvarchar (16 unit names)

TIZISE nvarchar (16 tone color)

CODETYPE nvarchar (16 flower patterns)

START_TIME start data collection IoT time

15、 Shutdown Information Table (NET_STOP LIST)

Shutdown information setting table.

Field Data Type Description

STOP_CODE small shutdown code

STOP_MENT nvarchar (50) Shutdown Content

16、 Shutdown Record Table (NET-STOP_LOG)

Shutdown Information History Table.

Field Data Type Description

ID int automatic numbering

MACH_CODE nvarchar (16) machine number

STOP_CODE small shutdown code

BEGIN_TIME start data collection IoT time

END_TIME DATE End data collection IoT time

17、 Data Collection IoT Order Sending Table (NET_SENDORDERRECORD)

Data Collection IoT Order Sending Record Form

Field Data Type Description

ID int automatic numbering

MACH_CODE nvarchar (16) machine number

WORK_SRDERCODE nvarcha (32) Dispatch Order Number

SEND_FANG smallint successfully sends data collection IoT order information flag

SEND_TIME DATE Send data collection IoT time

SEND_COD_FLAG smallint sends pattern file success flag

RESET-COUNTER smallint resets counter

Removed F1 from F1 1 smallint

SET_SHIFT_F1 smallint SHIFT+F1

SEND_COD smallint sends pattern files

ACTIVE-COD smallint activation pattern file

DELETE-COD smallint removes pattern files

RENAME-COD smallint renaming pattern file