L_GUARANTOR
Alanlar ve Açıklamaları
| Level | Product ID | Field Name | Field Type | Field Size | Field Offset | Türkçe Açıklama | Expression |
|---|---|---|---|---|---|---|---|
| 0 | 0 | LOGICALREF | Longint | 4 | 0 | Kefil Log. Ref. | Guarantor Logical Reference |
| 0 | 0 | FICHETYPE | Integer | 2 | 4 | Fiş Türü | Fiche Type |
| 0 | 0 | FICHEREF | Longint | 4 | 6 | Kefil Ref. | Guarantor Reference |
| 0 | 0 | GUARANTORNR | Integer | 2 | 10 | Taksit Numarası | Instalment Number |
| 0 | 0 | GNAMESURNAME | ZString | 51 | 12 | Taksit Soyadı | Instalment Surname |
| 0 | 0 | ADDR1 | ZString | 51 | 63 | Taksit Adresi 1 | Instalment Adress1 |
| 0 | 0 | ADDR2 | ZString | 51 | 114 | Taksit Adresi 2 | Instalment Adress2 |
| 0 | 0 | DISTRICT | ZString | 51 | 165 | Semt | District |
| 0 | 0 | TOWN | ZString | 51 | 216 | İlçe | Town |
| 0 | 0 | CITY | ZString | 21 | 267 | Şehir | City |
| 0 | 0 | COUNTRY | ZString | 21 | 288 | Ülke | Country |
| 0 | 0 | POSTCODE | ZString | 11 | 309 | Posta kodu | Postal Code |
| 0 | 0 | TELNRS1 | ZString | 16 | 320 | Telefon numarası 1 | Telephone Number1 |
| 0 | 0 | TELNRS2 | ZString | 16 | 336 | Telefon numarası 2 | Telephone Number2 |
| 0 | 0 | FAXNR | ZString | 16 | 352 | Faks Numarası | Fax Number |
| 0 | 0 | SITEID | Integer | 2 | 368 | Veri Merkezi | Data Processing Site |
| 0 | 0 | RECSTATUS | Integer | 2 | 370 | Kayıt Durumu | Record Status |
| 0 | 0 | ORGLOGICREF | Longint | 4 | 372 | Orijinal Kayıt Log. Ref. | Original Record Logical Reference |
İlişkiler - Relations
Level|Product ID|Resource ID|Special Code|Source Field|Destination Table|Destination Field|Relation Type|Extra Condition —–|—–|—–|—–|—–|—–|—–|—–|—–
Indexler
| Level | Product ID | Index Name | Attributes | Segment No | Segment Field | Sense |
|---|---|---|---|---|---|---|
| 0 | 0 | Index1 | Unique + Not Null | 1 | LOGICALREF | Ascending |
| 0 | 0 | Index2 | Unique + Not Null | 1 | FICHEREF | Ascending |
| 0 | 0 | Index2 | Unique + Not Null | 2 | FICHETYPE | Ascending |
| 0 | 0 | Index2 | Unique + Not Null | 3 | GUARANTORNR | Ascending |