LG_OFFER
Alanlar ve Açıklamaları
| Field Name | Field Type | Field Size | Field Offset | Türkçe Açıklama | Expression |
|---|---|---|---|---|---|
| LOGICALREF | Longint | 4 | 0 | Kayıt Durumu | Record Status |
| TYP | Integer | 2 | 4 | Kart Türü; 1 Satış İçin; 2 Satınalma İçin | Card Type ;1 For Sales;2 For Purchase;1 For Sales;2 For Purchase |
| TRCODE | Integer | 2 | 6 | Kart Türü; 1 Satış İçin; 2 Satınalma İçin | Card Type ;1 For Sales;2 For Purchase;1 For Sales;2 For Purchase |
| VALIDITY | Longint | 4 | 8 | Geçerlilik | Validity |
| REVISNR | ZString | 11 | 12 | Teklif revizyon num. | Offer Revision Number |
| REVISREF | Longint | 4 | 23 | Revizyon ref. | Revision Reference |
| CUSTVNDREF | Longint | 4 | 27 | Müşteri / Tedarikçi Ref. | Customer / Vendor Reference |
| CUSTREFNO | ZString | 11 | 31 | Müşteri Ref. Numarası | Customer Reference (Visual Objective) |
| ACTIVITYREF | Longint | 4 | 42 | Aktivite Referansı | Activity Reference |
| SALESMANREF | Longint | 4 | 46 | Satış Temsilcisi Referansı | Sales Representative Reference |
| SHPTYPCOD | ZString | 13 | 50 | Teslimat Şekli Kodu | Delivery Type Code |
| SHPAGNCOD | ZString | 13 | 63 | Taşıyıcı Kodu | Shipment Agent Code |
| TRADINGGRP | ZString | 17 | 76 | Ticari İşlem Grubu | Trading Option |
| APPROVAL | Integer | 2 | 93 | Teklif durumu | Offer Status |
| SITEID | Longint | 4 | 95 | Veri Merkezi | Data Processing Site |
| ORGLOGICREF | Longint | 4 | 99 | Orijinal Kayıt Log. Ref. | Original Record Logical Reference |
| VALIDALTNR | Integer | 2 | 103 | Geçerli alternatif numarası | Valid Alternative Number |
| OPPORREF | Longint | 4 | 105 | Satış fırsatları ref. | Sales Opportunity Reference |
| RECSTATUS | Integer | 2 | 109 | Kayıt Durumu | Record Status |
İlişkiler – Relations
| Level | Product ID | Resource ID | Special Code | Source Field | Destination Table | Destination Field | Relation Type | Extra Condition |
|---|---|---|---|---|---|---|---|---|
| 1 | 0 | 783 | CUSTVNDREF | L_CSTVND | LOGICALREF | one-to-one | ||
| 1 | 0 | 783 | ACTIVITYREF | L_SLSACTIV | LOGICALREF | one-to-one | ||
| 1 | 0 | 783 | SALESMANREF | L_SLSMAN | LOGICALREF | one-to-one | ||
| 1 | 0 | 783 | OPPORREF | L_SLSOPPOR | 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 | SALESMANREF | Ascending |
| 1 | 0 | Index2 | Duplicate + Not Null | 2 | OPPORREF | Ascending |
| 1 | 0 | Index2 | Duplicate + Not Null | 3 | TYP | Ascending |
| 1 | 0 | Index2 | Duplicate + Not Null | 4 | REVISNR | Ascending |
| 1 | 0 | Index3 | Duplicate + Not Null | 1 | CUSTVNDREF | Ascending |
| 1 | 0 | Index3 | Duplicate + Not Null | 2 | OPPORREF | Ascending |
| 1 | 0 | Index3 | Duplicate + Not Null | 3 | TYP | Ascending |
| 1 | 0 | Index3 | Duplicate + Not Null | 4 | REVISNR | Ascending |
| 1 | 0 | Index4 | Duplicate + Not Null | 1 | OPPORREF | Ascending |
| 1 | 0 | Index4 | Duplicate + Not Null | 2 | ACTIVITYREF | Ascending |
| 1 | 0 | Index4 | Duplicate + Not Null | 3 | REVISNR | Ascending |
>