LG_RTNGLINE
Alanlar ve Açıklamaları
| Field Name | Field Type | Field Size | Field Offset | Türkçe Açıklama | Expression |
|---|---|---|---|---|---|
| LOGICALREF | Longint | 4 | 0 | Üretim rota satırı log. Ref. | Production Route Line Logical Reference |
| ROUTINGREF | Longint | 4 | 4 | Üretim rotası ref. | Production Route Reference |
| LINENO_ | Integer | 2 | 8 | Satır Numarası | Line Number |
| OPERATIONREF | Longint | 4 | 10 | İşlem ref. | Operation Reference |
| SPECODE | ZString | 11 | 14 | Özel Kod | Aux. Code |
| COSTRELATED | Byte | 1 | 25 | Bağlı Maliyet | Cost Related |
| PLANRELATED | Byte | 1 | 26 | Planlama (related) | Planning Related |
| OUTITEMREF | Longint | 4 | 27 | Koşul Malzeme (Sınıf) Ref. | Conditioning Material (Class) Reference |
| LINEEXP | ZString | 51 | 31 | Satır Açıklaması | Line Description |
| SITEID | Integer | 2 | 82 | Veri Merkezi | Data Processing Site |
| RECSTATUS | Integer | 2 | 84 | Kayıt Durumu | Record Status |
| ORGLOGICREF | Longint | 4 | 86 | Orijinal Kayıt Log. Ref. | Original Record Logical Reference |
| WFSTATUS | Longint | 4 | 90 | Kullanımda Değil | Not In Use |
İlişkiler – Relations
| Level | Product ID | Resource ID | Special Code | Source Field | Destination Table | Destination Field | Relation Type | Extra Condition |
|---|---|---|---|---|---|---|---|---|
| 1 | 0 | 897 | ROUTINGREF | L_ROUTING | LOGICALREF | one-to-one | ||
| 1 | 0 | 897 | OPERATIONREF | L_OPERTION | LOGICALREF | one-to-one | ||
| 1 | 0 | 897 | OUTITEMREF | L_ITEMS | 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 | ROUTINGREF | Ascending |
| 1 | 0 | Index2 | Duplicate + Not Null | 2 | LINENO_ | Ascending |
>