LG_SUPPASGN
Alanlar ve Açıklamaları
| Field Name | Field Type | Field Size | Field Offset | Türkçe Açıklama | Expression |
|---|---|---|---|---|---|
| LOGICALREF | Longint | 4 | 0 | Malzeme – Tedarikçi Ataması Log. Ref. | Item – Supplier Assignment Logical Reference |
| ITEMREF | Longint | 4 | 4 | Malzeme Kartı Referansı | Item Card Reference |
| SUPPLYTYPE | Integer | 2 | 8 | Müşteri / Tedarikçi Tipi | Customer / Supplier Type |
| PRIORITY | Integer | 2 | 10 | Öncelik | Priority |
| LINENR | Integer | 2 | 12 | Satır Numarası | Line Number |
| CLIENTREF | Longint | 4 | 14 | Cari Hesap Ref. | Account Receivable / Payable Reference |
| TRADINGGRP | ZString | 17 | 18 | Ticari İşlem Grubu | Trading Group |
| CLCARDTYPE | Integer | 2 | 35 | Cari Hesap Türü | Account Receivable / Payable Type |
| KKKCHECK | Integer | 2 | 37 | Kalite Kontrol İşlemi Yapılmadığında | In Case of Inspection not Held |
| LEADTIME | Double | 8 | 39 | Teslim/Temin Zamanı | Delivery / Lead Time |
| MAXQUANTITY | Double | 8 | 47 | Azami Miktar | Maximum Quantity |
| MINQUANTITY | Double | 8 | 55 | Asgari Miktar | Minimum Quantity |
| BEGDATE | Longint | 4 | 63 | Başlangıç tarihi | Start Date |
| SPECIALIZED | Integer | 2 | 67 | Kullanımda Değil | Not In Use |
| ICUSTSUPCODE | ZString | 25 | 69 | Müşteri / Tedarikçi Kodu | Customer / Supplier Code |
| ICUSTSUPNAME | ZString | 51 | 94 | Müşteri / Tedarikçi Açıklaması | Customer / Supplier Description |
| QTYDEPLEADTIME | Double | 8 | 145 | Miktar bağımlı teslim/temin süresi | Quantity Dependent Delivery / Lead Time |
| PACKETREF | Longint | 4 | 153 | Malzemeler Log. Ref. | ITEMS LOGICALREF |
| PACKAGINGAMNT | Double | 8 | 157 | Paketleme tutarı | Packaging Amount |
| PACKAGINGUOMREF | Longint | 4 | 165 | Birim seti log. Ref. | UNITSETL LOGICALREF |
| PACKETUSETYPE | Integer | 2 | 169 | Paket kullanım türü | Packet Usage Type |
| ORDPERC | Double | 8 | 171 | Cari Hesap Sipariş Oranı (%) | AR/AP Order Rate (%) |
| ORDFREQ | Integer | 2 | 179 | Cari Hesap Sipariş Periyodu (Gün) | AR/AP Order Frequency (Day) |
İlişkiler – Relations
| Level | Product ID | Resource ID | Special Code | Source Field | Destination Table | Destination Field | Relation Type | Extra Condition |
|---|---|---|---|---|---|---|---|---|
| 1 | 0 | 817 | ITEMREF | L_ITEMS | LOGICALREF | one-to-one | ||
| 1 | 0 | 817 | CLIENTREF | L_CLCARD | 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 | ITEMREF | Ascending |
| 1 | 0 | Index2 | Duplicate + Not Null | 2 | LINENR | Ascending |
| 1 | 0 | Index3 | Duplicate + Not Null | 1 | ITEMREF | Ascending |
| 1 | 0 | Index3 | Duplicate + Not Null | 2 | CLCARDTYPE | Ascending |
| 1 | 0 | Index3 | Duplicate + Not Null | 3 | CLIENTREF | Ascending |
| 1 | 0 | Index4 | Duplicate + Not Null | 1 | CLIENTREF | Ascending |
| 1 | 0 | Index4 | Duplicate + Not Null | 2 | SUPPLYTYPE | Ascending |
| 1 | 0 | Index4 | Duplicate + Not Null | 3 | ITEMREF | Ascending |
| 1 | 0 | Index5 | Duplicate + Not Null | 1 | ICUSTSUPCODE | Ascending |
| 1 | 0 | Index5 | Duplicate + Not Null | 2 | CLIENTREF | Ascending |
>