LG_QCSLINE
Alanlar ve Açıklamaları
| Field Name | Field Type | Field Size | Field Offset | Türkçe Açıklama | Expression |
|---|---|---|---|---|---|
| LOGICALREF | Longint | 4 | 0 | Kalite Kontrol Satırı Log. Ref. | Inspection Line Logical Reference |
| CODE | ZString | 25 | 4 | Kalite Kontrol Satır Kodu | Inspection Line Code |
| NAME | ZString | 51 | 29 | Kalite Kontrol Satır Description | Inspection Line Description |
| SETREF | Longint | 4 | 80 | Kalite Kontrol Seti Ref. | Inspection Set Reference |
| QTYPE | Integer | 2 | 84 | Kalite Kontrol Tipi | Inspection Type |
| QUNIT | ZString | 11 | 86 | Kalite Kontrol Unit | Inspection Unit |
| TOOLCODE | ZString | 25 | 97 | Kalite Kontrol Aracı | Inspection Tool |
| CONTROLLER | Integer | 2 | 122 | Kontrol Sorumlusu | Inspector |
| INSPPOINT | Integer | 2 | 124 | Kontrol Noktası | Inspection Point |
| INSPFICHES1 | Integer | 2 | 126 | Malzeme Yönetimi Fişleri | Material Management Vouchers |
| INSPFICHES2 | Integer | 2 | 128 | Satınalma İrsaliyeleri | Purchase Receipts |
| INSPFICHES3 | Integer | 2 | 130 | Satış dağıtım irsaliyeleri | Sales & Distribution Dispatches |
| IMPORTANCE | ZString | 11 | 132 | Öncelik derecesi | Priority Degree |
| FREQUENCY | Double | 8 | 143 | Kalite Kontrol Periyodu | Inspection Frequency |
| COUNTER | Double | 8 | 151 | Kontrol Sayısı | Inspection Count |
| SAMPLESIZE | Double | 8 | 159 | Numune miktarı | Sample Quantity |
| NOMVAL | Double | 8 | 167 | Nominal değer | Nominal Value |
| MINVAL | Double | 8 | 175 | Asgari Değer | Minimum Value |
| MAXVAL | Double | 8 | 183 | Azami Değer | Maximum Value |
| MINTOL | Double | 8 | 191 | (-) Tolerans | (-)Tolerance |
| MAXTOL | Double | 8 | 199 | (+) Tolerans | (+)Tolerance |
| EXPLINE | ZString | 81 | 207 | Açıklama Satırı | Description Line |
| CONFORMRATE | Integer | 2 | 288 | Kabul Oranı (%) | Nonconf.Accept.(%) |
| LINENO_ | Integer | 2 | 290 | Satır Numarası | Line Number |
| TOOLREF | Longint | 4 | 292 | Araç ref. | Tool Reference |
İlişkiler – Relations
| Level | Product ID | Resource ID | Special Code | Source Field | Destination Table | Destination Field | Relation Type | Extra Condition |
|---|---|---|---|---|---|---|---|---|
| 1 | 3 | 836 | SETREF | L_QCSET | LOGICALREF | one-to-one | ||
| 1 | 3 | 836 | TOOLREF | L_ITEMS | LOGICALREF | one-to-many |
Indexler
| Level | Product ID | Index Name | Attributes | Segment No | Segment Field | Sense |
|---|---|---|---|---|---|---|
| 1 | 3 | Index1 | Unique + Not Null | 1 | LOGICALREF | Ascending |
| 1 | 3 | Index2 | Duplicate + Not Null | 1 | CODE | Ascending |
| 1 | 3 | Index3 | Duplicate + Not Null | 1 | NAME | Ascending |
| 1 | 3 | Index4 | Duplicate + Not Null | 1 | SETREF | Ascending |
| 1 | 3 | Index4 | Duplicate + Not Null | 2 | LINENO_ | Ascending |
| 1 | 3 | Index5 | Unique + Not Null | 1 | SETREF | Ascending |
| 1 | 3 | Index5 | Unique + Not Null | 2 | CODE | Ascending |
>