LG_SLQCASGN

Alanlar ve Açıklamaları

Field Name Field Type Field Size Field Offset Türkçe Açıklama Expression
LOGICALREF Longint 4 0 Kalite Kontrol Hareketi Log. Ref. Inspection Transaction Logical Reference
ASGNTYPE Integer 2 4 Atama Türü ; 0 Malzeme; 2 Operasyon Assignment Type ;0 Operation;1 Material
ITEMREF Longint 4 6 Malzeme Kartı Referansı Item Card Reference
FICHEREF Longint 4 10 Fiş ref. Voucher Reference
STTRANSREF Longint 4 14 Malzeme Hareketi Ref. Item Transaction Reference
SLTRANSREF Longint 4 18 Lot / Seri / Stok Yeri Hareket Ref. Lot / Serial / Location Transaction Reference
QCSETREF Longint 4 22 Kalite Kontrol Seti Ref. Inspection Set Reference
QCCODEREF Longint 4 26 Kalite Kontrol Kodu Inspection Code
QCVALREF Longint 4 30 Kalite Kontrol Değeri Kodu Inspection Value Code
QCASGNLOGICREF Longint 4 34 Kalite Kontrol Ataması Ref. Inspection Assignment Reference
QCREVNO Longint 4 38 Kalite Kontrol Ataması Revizyon Numarası Inspection Assignment Revision Number
QTYPE Integer 2 42 Kalite Kontrol Tipi Inspection Type
LINENR Integer 2 44 Satır Numarası Line Number
AMOUNT Double 8 46 Miktar Quantity
QVALUE Double 8 54 Kalite Kontrol Değeri Inspection Value
CONFIRMED Byte 1 62 Kalite Kontrol Değeri Uygunluğu Inspection Value Suitable
QDATE Longint 4 63 Kalite Kontrol Değeri Giriş Tarihi Inspection Value Entering Date
CANCELLED Byte 1 67 İptal Edilmiş Cancelled

İlişkiler – Relations

Level Product ID Resource ID Special Code Source Field Destination Table Destination Field Relation Type Extra Condition
2 3 839   ITEMREF L_ITEMS LOGICALREF one-to-one ASGNTYPE=1
2 3 839   ITEMREF L_OPERTION LOGICALREF one-to-one ASGNTYPE=2
2 3 839   FICHEREF L_STFICHE LOGICALREF one-to-one ASGNTYPE=1
2 3 839   FICHEREF L_PRODORD LOGICALREF one-to-one ASGNTYPE=2
2 3 839   STTRANSREF L_STLINE LOGICALREF one-to-one ASGNTYPE=1
2 3 839   STTRANSREF L_DISPLINE LOGICALREF one-to-one ASGNTYPE=2
2 3 839   SLTRANSREF L_SLTRANS LOGICALREF one-to-one  
2 3 839   QCSETREF L_QCSET LOGICALREF one-to-one  
2 3 839   QCVALREF L_QCLVAL LOGICALREF one-to-one  
2 3 839   QCASGNLOGICREF L_QASGN LOGICALREF one-to-one  

Indexler

Level Product ID Index Name Attributes Segment No Segment Field Sense
2 3 Index1 Unique + Not Null 1 LOGICALREF Ascending
2 3 Index2 Duplicate + Not Null 1 ASGNTYPE Ascending
2 3 Index2 Duplicate + Not Null 2 STTRANSREF Ascending
2 3 Index2 Duplicate + Not Null 3 LINENR Ascending
2 3 Index3 Duplicate + Not Null 1 ASGNTYPE Ascending
2 3 Index3 Duplicate + Not Null 2 SLTRANSREF Ascending
2 3 Index3 Duplicate + Not Null 3 LINENR Ascending

>