LG_STOPTRANS
Alanlar ve Açıklamaları
| Field Name | Field Type | Field Size | Field Offset | Türkçe Açıklama | Expression |
|---|---|---|---|---|---|
| LOGICALREF | Longint | 4 | 0 | İş emri durma nedeni log. Ref. | Work Order Stop Transaction Logical Reference |
| PRODORDREF | Longint | 4 | 4 | Üretim Emri Referansı | Production Order Reference |
| DISPLINEREF | Longint | 4 | 8 | İş emri ref. | Work Order Reference |
| OPREF | Longint | 4 | 12 | İşlem ref. | Operation Reference |
| WSREF | Longint | 4 | 16 | İş İstasyonu Ref. | Workstation Reference |
| CAUSEREF | Longint | 4 | 20 | Durma nedeni ref. | Stop Reason Reference |
| STOPDATE | Longint | 4 | 24 | Durma tarihi | Stop Date |
| STOPTIME | Longint | 4 | 28 | Durma zamanı | Stop Time |
| STARTDATE | Longint | 4 | 32 | Başlangıç tarihi | Start Date |
| STARTTIME | Longint | 4 | 36 | Başlangıç zamanı | Start Time |
| STOPDURATION | Double | 8 | 40 | Durma süresi | Stop Duration |
| AFFECTSCOST | Integer | 2 | 48 | Maliyeti Etkiler | Affects Cost |
| AFFECTSPLAN | Integer | 2 | 50 | Planı Etkiler | Affects Plan |
| TRANSEXP | ZString | 51 | 52 | Hareket açıklaması | Stop Transaction Description |
| LINENR | Integer | 2 | 103 | Satır Numarası | Line Number |
| WSPARTREF | Longint | 4 | 105 | İş İstasyonu Parçalı Ref. | Workstation Partial Reference |
| ACTIVEPARTNUM | Integer | 2 | 109 | Aktif Parça Sayısı | Number of Active Item |
İlişkiler – Relations
| Level | Product ID | Resource ID | Special Code | Source Field | Destination Table | Destination Field | Relation Type | Extra Condition |
|---|---|---|---|---|---|---|---|---|
| 1 | 0 | 873 | PRODORDREF | L_PRODORD | LOGICALREF | one-to-one | ||
| 1 | 0 | 873 | DISPLINEREF | L_DISPLINE | LOGICALREF | one-to-one | ||
| 1 | 0 | 873 | OPREF | L_OPERTION | LOGICALREF | one-to-one | ||
| 1 | 0 | 873 | WSREF | L_WORKSTAT | LOGICALREF | one-to-one | ||
| 1 | 0 | 873 | CAUSEREF | L_STOPCAUSE | LOGICALREF | one-to-one |
Indexler
| Level | Product ID | Index Name | Attributes | Segment No | Segment Field | Sense |
|---|---|---|---|---|---|---|
| 1 | 0 | Index1 | Unique + Not Null | 1 | LOGICALREF | Ascending |
| 1 | 0 | Index2 | Duplicate + Not Null | 1 | DISPLINEREF | Ascending |
| 1 | 0 | Index2 | Duplicate + Not Null | 2 | CAUSEREF | Ascending |
>