LG_PRVOPASG

Alanlar ve Açıklamaları

Field Name Field Type Field Size Field Offset Türkçe Açıklama Expression
LOGICALREF Longint 4 0 Önceki operasyon ilişkisi log. ref. Previous Operation Relation Logical Reference
ROUTINGREF Longint 4 4 Üretim rotası ref. Production Route Reference
ROUTLINEREF Longint 4 8 Rota satır ref. Route Line Reference
LINEOPREF Longint 4 12 Satır İşlem Ref. Line Operation Reference
PREVOPREF Longint 4 16 Önceki operasyon ref. Previous Operation Reference
OVERLAPPER Double 8 20 Örtüşme oranı Overlapping Rate

İlişkiler – Relations

Level Product ID Resource ID Special Code Source Field Destination Table Destination Field Relation Type Extra Condition
1 1 892   ROUTINGREF L_ROUTING LOGICALREF one-to-one  
1 1 892   ROUTLINEREF L_RTNGLINE LOGICALREF one-to-one  
1 1 892   LINEOPREF L_OPERTION LOGICALREF one-to-one  
1 1 892   PREVOPREF L_OPERTION LOGICALREF one-to-one  

Indexler

Level Product ID Index Name Attributes Segment No Segment Field Sense
1 1 Index1 Unique + Not Null 1 LOGICALREF Ascending
1 1 Index2 Duplicate + Not Null 1 ROUTINGREF Ascending
1 1 Index2 Duplicate + Not Null 2 PREVOPREF Ascending
1 1 Index3 Duplicate + Not Null 1 ROUTLINEREF Ascending
1 1 Index3 Duplicate + Not Null 2 PREVOPREF Ascending
1 1 Index4 Unique + Not Null 1 PREVOPREF Ascending
1 1 Index4 Unique + Not Null 2 ROUTLINEREF Ascending

>