首页 > 其他分享 >一个独立报表显示工单,进出站,扫码上料,工单下达,完工下线所有情况便于综合异常排查

一个独立报表显示工单,进出站,扫码上料,工单下达,完工下线所有情况便于综合异常排查

时间:2023-03-02 09:11:28浏览次数:33  
标签:扫码 20 上料 23 19 28 工单 220600045710 222700094510

                        
  

工单头

                   
                        
  

计划产线

计划物料BO

物料描述

 

11300201

1000017939

BT9C_32W_850_NL_299_IEC_FCL

 
           
                        
 

进出站

                  
                        
 

资源

工序

线边仓

容器

条码类型

进出站

工单

工序段

INVENTORY BO

QTY

CREATED DATE TIME

ERP STEP

ITEM

DATA FROM

SC3700400032

YG027

AY18

WMAZ14055

F

出站

220500088410

1

220500088410-0001

10

2023/3/1 10:09:30

 

1000017939

FinishOfflineServiceImpl

SC3700400032

YG027

AY18

WMAZ14053

F

出站

220500088410

1

220500088410-0002

5

2023/3/1 13:26:52

 

1000017939

FinishOfflineServiceImpl

SC3700400032

YG027

AY18

WMAZ14052

F

出站

220500088410

1

220500088410-0003

2

2023/3/1 13:32:17

 

1000017939

FinishOfflineServiceImpl

SC3700400032

YG027

AY18

WMAZ14051

F

出站

220500088410

1

220500088410-0004

5

2023/3/1 15:27:50

 

1000019879

FinishOfflineServiceImpl

  
                        
  

扫码上料记录

             
                        
  

资源

工序

条码

物料

数量

上料时间

11300201-YG003

YG003

222700094510-1000020003-2

1000020003

98287

2023/2/28 13:28:14

SC1600600009

YG004

100002750110393202110220023

1000017546

266

2023/2/28 19:33:14

SC1100600009

YG014

222700094510-1000019961-2

1000019961

10000

2023/2/28 19:42:10

SC1100600009

YG014

222700094510-1000019961-1

1000019961

99598

2023/2/28 19:42:35

SC1100600009

YG014

222700094510-1000019962-2

1000019962

10000

2023/2/28 19:53:13

SC1100600009

YG014

222700094510-1000019962-1

1000019962

99598

2023/2/28 19:53:28

SC1100600009

YG014

222700094510-1000019980-2

1000019980

10000

2023/2/28 20:01:51

SC1100600009

YG014

222700094510-1000019989-1

1000019989

99598

2023/2/28 20:05:25

SC1100600009

YG014

222700094510-1000017318-1

1000017318

98312

2023/2/28 20:05:56

SC1100600009

YG014

10000275011039320211022001617

1000017335

1300

2023/2/28 20:11:33

SC1100600009

YG014

222700094510-1000017319-2

1000017319

10000

2023/2/28 20:12:42

SC1500400007

YG025

222700094510-1000017415-2

1000017415

8716

2023/2/28 20:17:31

SC1400300036

YG033

220600045710-1000017285-2

1000017285

834

2023/2/28 20:22:24

        
                        
  

当前生产

                
                        
  

产线

工序段

当前生产资源

顺序号

工单号

设定日期

来源

11300201

1

11300201-YG003

1

220500088410

2023/2/28 13:28:13

ResrceServiceImpl

11300201

1

SC1600600009

1

220500088410

2023/2/28 19:37:26

ResrceServiceImpl

11300201

1

SC3700400032

1

220500088410

2023/2/28 19:42:13

ResrceServiceImpl

    
                        
  

工单下达记录

                   
                        
  

流水码

当前生产资源

工单号

工序段

下达时间

产线

来源

28

11300201-YG003

222700094510A

1

2023/2/23 19:12:57

11300201

ResrceServiceImpl

27

11300201-YG003

222700094510

1

2023/2/23 19:12:57

11300201

ResrceServiceImpl

29

SC1600600009

222700094510

1

2023/2/23 19:14:32

11300201

ResrceServiceImpl

30

SC1100600009

222700094510

1

2023/2/23 19:19:38

11300201

ResrceServiceImpl

41

11300201-YG003

220500088410

1

2023/2/28 13:28:13

11300201

ResrceServiceImpl

42

SC1600600009

220500088410

1

2023/2/28 19:37:31

11300201

ResrceServiceImpl

43

SC3700400032

220500088410

1

2023/2/28 19:42:18

11300201

ResrceServiceImpl

     
                        

上料历史

               
                        

上料资源

上料工序

当前生产资源

产线

条码

物料

上机数量

标准消耗量

报废

账面剩余

实物剩余

上料时间

KEY

清线时间

SO LINE NUM

SO NUM

WBS NUM

SCAN TYPE

ID

11300201-YG003

YG003

11300201-YG003

11300201

222700094510-1000020003-2

1000020003

98312

20

 

98292

98292

2023/2/23 19:12:46

1

2023/2/23 19:33:40

   

122

220

11300201-YG003

YG003

11300201-YG003

11300201

222700094510-1000020003-1

1000020003

99960

0

 

99960

99960

2023/2/23 19:13:09

1

2023/2/23 19:33:40

   

122

221

SC1600600009

YG004

SC1600600009

11300201

222700094510-1000047491-1

1000047491

9156

10

 

9146

9146

2023/2/23 19:13:39

2

2023/2/23 20:14:46

   

122

222

SC1100600009

YG014

SC3700400032

11300201

222700094510-1000017318-2

1000017318

10000

20

 

9980

9980

2023/2/23 19:19:32

3

2023/2/23 20:15:24

   

122

223

SC1500400007

YG025

SC3700400032

11300201

222700094510-1000017415-1

1000017415

99596

20

 

99576

99576

2023/2/23 19:21:18

4

2023/2/23 20:15:39

   

122

224

11300201-YG003

YG003

11300201-YG003

11300201

222700094510-1000020003-2

1000020003

98287

22

 

98265

98265

2023/2/28 13:28:14

5

    

122

241

SC1600600009

YG004

SC1600600009

11300201

100002750110393202110220023

1000017546

266

22

 

244

244

2023/2/28 19:33:14

6

    

122

242

SC1100600009

YG014

SC3700400032

11300201

222700094510-1000019961-2

1000019961

10000

22

 

9978

9978

2023/2/28 19:42:10

7

    

122

243

SC1100600009

YG014

SC3700400032

11300201

222700094510-1000019961-1

1000019961

99598

0

 

99598

99598

2023/2/28 19:42:35

7

    

122

244

SC1100600009

YG014

SC3700400032

11300201

222700094510-1000019962-2

1000019962

10000

22

 

9978

9978

2023/2/28 19:53:13

8

    

122

245

SC1100600009

YG014

SC3700400032

11300201

222700094510-1000019962-1

1000019962

99598

0

 

99598

99598

2023/2/28 19:53:28

8

    

122

246

SC1100600009

YG014

SC3700400032

11300201

222700094510-1000019980-2

1000019980

10000

22

 

9978

9978

2023/2/28 20:01:51

9

    

122

247

SC1100600009

YG014

SC3700400032

11300201

222700094510-1000019989-1

1000019989

99598

22

 

99576

99576

2023/2/28 20:05:25

10

    

122

248

SC1100600009

YG014

SC3700400032

11300201

222700094510-1000017318-1

1000017318

98312

22

 

98290

98290

2023/2/28 20:05:56

11

    

122

249

SC1100600009

YG014

SC3700400032

11300201

10000275011039320211022001617

1000017335

1300

22

 

1278

1278

2023/2/28 20:11:33

12

    

122

250

SC1100600009

YG014

SC3700400032

11300201

222700094510-1000017319-2

1000017319

10000

22

 

9978

9978

2023/2/28 20:12:42

13

    

122

251

SC1500400007

YG025

SC3700400032

11300201

222700094510-1000017415-2

1000017415

8716

22

 

8694

8694

2023/2/28 20:17:31

14

    

122

252

SC1400300036

YG033

SC3700400032

11300201

220600045710-1000017285-2

1000017285

834

22

 

812

812

2023/2/28 20:22:24

15

    

122

253

 
                        

上料绑定工单历史

            
                        

BINDKEY

上料资源

上料工序

工单

工序段

设置时间

DATA FROM

1

11300201-YG003

YG003

222700094510

1

2023/2/23 19:12:51

ResrceServiceImpl

1

11300201-YG003

YG003

222700094510A

1

2023/2/23 19:12:51

ResrceServiceImpl

2

SC1600600009

YG004

222700094510

1

2023/2/23 19:14:30

ResrceServiceImpl

3

SC1100600009

YG014

222700094510

1

2023/2/23 19:19:33

ResrceServiceImpl

4

SC1500400007

YG025

222700094510

1

2023/2/23 19:21:18

ScanCodeUploadMaterialServiceImpl

5

11300201-YG003

YG003

220500088410

1

2023/2/28 13:28:13

ResrceServiceImpl

6

SC1600600009

YG004

220500088410

1

2023/2/28 19:37:26

ResrceServiceImpl

7

SC1100600009

YG014

220500088410

1

2023/2/28 19:42:13

ResrceServiceImpl

8

SC1100600009

YG014

220500088410

1

2023/2/28 19:53:13

ScanCodeUploadMaterialServiceImpl

9

SC1100600009

YG014

220500088410

1

2023/2/28 20:01:51

ScanCodeUploadMaterialServiceImpl

10

SC1100600009

YG014

220500088410

1

2023/2/28 20:05:25

ScanCodeUploadMaterialServiceImpl

11

SC1100600009

YG014

220500088410

1

2023/2/28 20:05:56

ScanCodeUploadMaterialServiceImpl

12

SC1100600009

YG014

220500088410

1

2023/2/28 20:11:33

ScanCodeUploadMaterialServiceImpl

13

SC1100600009

YG014

220500088410

1

2023/2/28 20:12:42

ScanCodeUploadMaterialServiceImpl

14

SC1500400007

YG025

220500088410

1

2023/2/28 20:17:31

ScanCodeUploadMaterialServiceImpl

15

SC1400300036

YG033

220500088410

1

2023/2/28 20:22:24

ScanCodeUploadMaterialServiceImpl

      
                        

工艺路线

                     
                        

序号

工序描述

产线

工序

工序段

工序类型

ERP STEP

工序人数

人时秒数

1

涂膜

11300201

YG003

1

SP02

0010

0

0

2

涂粉

11300201

YG004

1

SP02

0020

3

8.36

3

粉检

11300201

YG039

1

SP02

0030

0

0

4

烤粉

11300201

YG008

1

SP02

0040

0

0

5

擦粉

11300201

YG005

1

SP02

0050

0

0

6

精切

11300201

YG009

1

SP02

0060

0

0

7

缩口

11300201

YG010

1

SP02

0070

0

0

8

烤管

11300201

YG011

1

SP02

0080

0

0

9

封口

11300201

YG014

1

SP02

0090

3

8.36

10

排气

11300201

YG025

1

SP02

0100

1

2.7860

11

装头

11300201

YG033

1

SP02

0110

0

0

12

烤头

11300201

YG034

1

SP02

0120

0

0

13

冲针

11300201

YG035

1

SP02

0130

0

0

14

老练

11300201

YG027

1

SP01

0140

9

25.0770

         
                        

BOM

                     
                        

序号

组件

标准用量

已发料量

工序

工序组

ERP STEP

反冲

预留号

预留行

 

销售订单号

销售订单行

WBS

1

1000016994

1

22

YG003

1

0010

X

1397294

25

    

2

1000020003

1

22

YG003

1

0010

X

1397294

22

    

3

1000043190

1

5

YG003

1

0010

X

1397294

30

 

1100009687

10

 

4

1000017546

1

22

YG004

1

0020

X

1397294

17

    

5

1000017773

1

22

YG010

1

0070

X

1397294

32

    

6

1000019961

1

22

YG014

1

0090

X

1397294

18

    

7

1000017319

1

22

YG014

1

0090

X

1397294

29

    

8

1000017335

1

22

YG014

1

0090

X

1397294

28

    

9

1000019989

1

22

YG014

1

0090

X

1397294

21

    

10

1000017318

1

22

YG014

1

0090

X

1397294

24

    

11

1000019980

1

22

YG014

1

0090

X

1397294

20

    

12

1000019962

1

22

YG014

1

0090

X

1397294

19

    

13

1000017415

1

22

YG025

1

0100

X

1397294

27

    

14

1000017285

1

22

YG033

1

0110

X

1397294

23

    

16

1000110597

1

22

YG033

1

0110

X

1397294

31

    
   
                        

可用条码

                     
                        

条码

物料

有效否

线边仓

库存

SO NUM

SO LINE NUM

WBS NUM

SWR NUM

批次

PP2022072000111234566221

1000017285

1

AY01

800

     

PP2022072000111234566331

1000017285

1

AY01

800

     

PP2022072000111234566332

1000017285

1

AY01

1753

     

PP2022072000111234566111

1000017285

1

AY01

800

     

PP2022072000071234567114

1000043190

1

AY01

1

     

PP2022072000071234567116

1000043190

1

AY01

1

     

PP2022072000071234567113

1000043190

1

AY01

1

     

PP2022072000071234567112

1000043190

1

AY01

1

     

PP2022072000071234567115

1000043190

1

AY01

1

     

220600045710-1000017773-5

1000017773

1

AY02

10000

     

220600045710-1000017773-3

1000017773

1

AY02

1200

     

220600045710-1000017773-2

1000017773

1

AY02

1200

     

220600045710-1000017773-1

1000017773

1

AY02

1100

     

220200027310-YG005-1000017773c

1000017773

1

AY02

12

     

220200027310-YG005-1000017773a

1000017773

1

AY02

15

     

220200027310-YG005-1000017773b

1000017773

1

AY02

15

     

220600554610-YG014-1000017773

1000017773

1

AY05

9988

     

220600221620-YG003-1000016994C

1000016994

1

AY18

15180

     

220600045710-1000016994-1

1000016994

1

AY18

978

     

220600045710-1000016994-2

1000016994

1

AY18

10000

     

220600045710-1000016994-3

1000016994

1

AY18

10000

     

220600045710-1000016994-4

1000016994

1

AY18

5600

     

220600221620-YG003-1000016994B

1000016994

1

AY18

150000

     

220200027310-YG004-1000016994c

1000016994

1

AY18

6465

     

220200027310-YG004-1000016994a

1000016994

1

AY18

20000

     

220200027310-YG004-1000016994b

1000016994

1

AY18

20000

     

220600554610-YG004-1000016994

1000016994

1

AY18

10766

     

220600221620-YG003-1000016994A

1000016994

1

AY18

150000

     

220600045710-1000017285-2

1000017285

1

AY18

812

     

222700094510-1000017318-1

1000017318

1

AY18

98290

     

222700094510-1000017318-2

1000017318

1

AY18

9975

     

222700094510-1000017319-1

1000017319

1

AY18

99598

     

222700094510-1000017319-2

1000017319

1

AY18

9978

     

10000275011039320211022001617

1000017335

1

AY18

1278

   

SWR

200011

222700094510-1000017415-1

1000017415

1

AY18

99571

     

222700094510-1000017415-2

1000017415

1

AY18

8694

   

1234

 

100002750110393202110220023

1000017546

1

AY18

244

     

222700094510-1000017773-1

1000017773

1

AY18

17.1960

     

222700094510-1000019961-2

1000019961

1

AY18

9978

     

222700094510-1000019961-1

1000019961

1

AY18

99598

     

222700094510-1000019962-2

1000019962

1

AY18

9978

     

222700094510-1000019962-1

1000019962

1

AY18

99598

     

222700094510-1000019980-2

1000019980

1

AY18

9978

     

222700094510-1000019980-1

1000019980

1

AY18

99598

     

222700094510-1000019989-1

1000019989

1

AY18

99576

     

222700094510-1000019989-2

1000019989

1

AY18

10000

     

222700094510-1000020003-1

1000020003

1

AY18

99960

   

2345556

 

WAX1000109682202206010004

1000020003

1

AY18

10

   

2345556

 

WAX1000109682202206010003

1000020003

1

AY18

10

   

2345556

 

WAX1000109682202206010002

1000020003

1

AY18

10

   

2345556

 

WAX1000109682202206010001

1000020003

1

AY18

10

   

2345556

 

222700094510-1000020003-2

1000020003

1

AY18

98265

     

220600045710-1000043190-1

1000043190

1

AY18

3

1100009687

10

   

220600045710-1000043190-2

1000043190

1

AY18

1

1100010058

190

   

222700094510-1000110597-5

1000110597

1

AY18

293

     

222700094510-1000110597-3

1000110597

1

AY18

500

   

swr888

 

222700094510-1000110597-4

1000110597

1

AY18

0

   

SWR20221230002-04

 

222700094510-1000110597-2

1000110597

1

AY18

99691.66

   

SWR20221230002-02

 

222700094510-1000110597-1

1000110597

1

AY18

0

     

220600045710-1000017285-1

1000017285

1

AY30

1000

     

220600045710-1000017319-1

1000017319

1

AY30

500

     

220600045710-1000017319-2

1000017319

1

AY30

435

     

220600045710-1000017773-4

1000017773

1

AY30

1000

     

220600045710-1000019961-2

1000019961

1

AY30

435

     

220600045710-1000019961-1

1000019961

1

AY30

500

     

220600045710-1000019989-2

1000019989

1

AY30

435

     

220600045710-1000019989-1

1000019989

1

AY30

500

     

220600045710-1000110597-2

1000110597

1

AY30

69

     

220600045710-1000110597-1

1000110597

1

AY30

100

     

DJF220600361020-0008

1000110597

1

AY55

1399

     

DJF1000116527202207060004

1000020003

1

AY56

10

100000999

10

1

  
    
                        

产线资源

                     
                        

资源

工序

当前生产资源

资源描述

可否扫码

有效否

产线

11300201-YG003

YG003

11300201-YG003

TL5-4线涂膜机

1

1

11300201

SC1600600009

YG004

SC1600600009

TL5-4线涂粉机

1

1

11300201

SC1600100006

YG005

11300201-YG008

TL5-4线擦粉机

1

1

11300201

11300201-YG007

YG007

SC3700400032

TL5-4线前端打印

0

1

11300201

11300201-YG008

YG008

11300201-YG008

TL5-4线烤粉

1

1

11300201

11300201-YG009

YG009

SC3700400032

TL5-4线精切机

0

1

11300201

SC1600200002

YG010

SC3700400032

TL5-4线缩口机

0

1

11300201

SC1600300005

YG011

11300201-YG008

TL5-4线烤管机

1

1

11300201

SC1100700008

YG014

SC3700400032

TL5-4线通端绷丝机

1

1

11300201

SC1100600009

YG014

SC3700400032

TL5-4线闭端绷丝机

1

1

11300201

SC1100700010

YG014

SC3700400032

TL5-4线闭端芯柱机

1

1

11300201

SC1100700009

YG014

SC3700400032

TL5-4线通端芯柱机

1

1

11300201

SC2300100008

YG014

SC3700400032

TL5-4线封口机

1

1

11300201

SC1500400007

YG025

SC3700400032

TL5-4线排气机

1

1

11300201

SC3700400032

YG027

SC3700400032

TL5-4线检验台

1

1

11300201

SC1400300036

YG033

SC3700400032

TL5-4线胶泥机

1

1

11300201

SC2000300003

YG034

SC3700400032

TL5-4线烤头机

0

1

11300201

11300201-YG035

YG035

SC3700400032

TL5-4线冲针机

0

1

11300201

11300201-YG039

YG039

SC3700400032

TL5-4线粉检

0

1

11300201

       
                        

产线工序线边仓

                 
                        

产线

工序

线边仓

默认出站仓

11300201

YG003

AY01

0

11300201

YG003

AY18

0

11300201

YG004

AY18

0

11300201

YG005

AY18

0

11300201

YG008

AY02

0

11300201

YG008

AY18

1

11300201

YG009

AY18

0

11300201

YG010

AY18

0

11300201

YG011

AY18

0

11300201

YG014

AY18

0

11300201

YG025

AY18

0

11300201

YG027

AY18

1

11300201

YG033

AY18

0

11300201

YG034

AY18

0

11300201

YG035

AY18

0

11300201

YG039

AY18

0

              
                        
 

SWR

                    
                        
  

SWRLINE

ITEM

SHOP ORDER

ITEMQTY

SWR20221230002-02

1000110597

222700094510

2300

swr888

1000110597

223100001710

11260

2344555

1000020003

223100001710

11260

          

标签:扫码,20,上料,23,19,28,工单,220600045710,222700094510
From: https://www.cnblogs.com/hlm750908/p/17170614.html

相关文章