LG_INVOICE

Alanlar ve Açıklamaları

Field Name Field Type Field Size Field Offset Türkçe Açıklama Expression
LOGICALREF Longint 4 0 Fatura Log. Ref. Invoice Logical Reference
GRPCODE Integer 2 4 Grup Kodu; 1 Alış Faturası; 2 Satış Faturası Group Code ;1 Purchase Invoice;2 Sales Invoice
TRCODE Integer 2 6 Fatura Türü Invoice Type
FICHENO ZString 17 8 Fatura Numarası Invoice Number
DATE_ Longint 4 25 Tarih Date
TIME_ Longint 4 29 Zaman Time
DOCODE ZString 9 33 Belge Numarası Document Number
SPECODE ZString 11 42 Özel Kod Aux. Code
CYPHCODE ZString 11 53 Yetki Kodu Auth. Code
CLIENTREF Longint 4 64 Cari Hesap Ref. Account Receivable / Payable Reference
RECVREF Longint 4 68 Borçlu Cari Hesabın (Teslimat) Referansı Account Receivable (Delivery) Reference
CENTERREF Longint 4 72 Masraf Merkezi Ref. Overhead Pool Reference
ACCOUNTREF Longint 4 76 Genel Muhasebe Hesabı Ref. General Ledger Account Reference
SOURCEINDEX Integer 2 80 Ambar Numarası Warehouse Number
SOURCECOSTGRP Integer 2 82 Ambar maliyet grubu Warehouse Cost Group
CANCELLED Byte 1 84 İptal Edilmiş Cancelled
ACCOUNTED Byte 1 85 Muhasebeleştirildi Posted to General Ledger
PAIDINCASH Byte 1 86 Ödenmiş Already Paid
FROMKASA Byte 1 87 Kasadan Fatura Invoice From Safe Deposit
ENTEGSET Byte 1 88 Discounts / Surcharges / Promotions have been distributed ;0 Discounts Will Be Distributed to GL;0 Purchases Will Be Distributed to GL;0 Promotions Will Be Distributed to Item Cost;1 Discounts Will Be Distributed to Item Cost;1 Purchases Will Be Distrib Discounts / Surcharges / Promotions have been distributed ;0 Discounts Will Be Distributed to GL;0 Purchases Will Be Distributed to GL;0 Promotions Will Be Distributed to Item Cost;1 Discounts Will Be Distributed to Item Cost;1 Purchases Will Be Distrib
VAT Double 8 89 KDV VAT
ADDDISCOUNTS Double 8 97 Satıra Uygulanan Ek İndirimler Additional Discounts that Are Applied to Line
TOTALDISCOUNTS Double 8 105 Toplam İndirimler Total Discounts
TOTALDISCOUNTED Double 8 113 İndirimler Satır Toplamı Total After Line Discounts
ADDEXPENSES Double 8 121 Satıra Uygulanan Ek Masraflar Additional Surcharge that Are Applied to Line
TOTALEXPENSES Double 8 129 Toplam Masraflar Total Surcharges
DISTEXPENSE Double 8 137 Malzemelere Dağıtılacak Maliyet Cost That Will Be Distributed to Material Cost
TOTALDEPOZITO Double 8 145 Toplam Depozito Total Deposit
TOTALPROMOTIONS Double 8 153 Toplam Promosyonlar Total Promotion
VATINCGROSS Double 8 161 KDV Dahil Tutar Included VAT Amount
TOTALVAT Double 8 169 Toplam KDV Total VAT
GROSSTOTAL Double 8 177 Toplam Total
NETTOTAL Double 8 185 Net Toplam Net Total
GENEXP1 ZString 51 193 Fiş Genel Açıklaması Voucher General Description
GENEXP2 ZString 51 244 Fiş Genel Açıklaması Voucher General Description
GENEXP3 ZString 51 295 Fiş Genel Açıklaması Voucher General Description
GENEXP4 ZString 51 346 Fiş Genel Açıklaması Voucher General Description
INTERESTAPP Double 8 397 Vade Farkı Due Date Difference That Closed
TRCURR Byte 1 405 İD Türü Transaction Currency Type
TRRATE Double 8 406 İşlem dövizi kuru Transaction Currency Exchange Rate
TRNET Double 8 414 İşlem dövizi tutarı Transaction Currency Amount
REPORTRATE Double 8 422 RD Kuru Reporting Currency Exchange Rate
REPORTNET Double 8 430 RD Tutarı Reporting Currency Amount
ONLYONEPAYLINE Byte 1 438 Tek satırlı ödeme planı One Lined Payment Plan
KASTRANSREF Longint 4 439 Kasa hareketi ref. Safe Deposit Transaction Reference
PAYDEFREF Longint 4 443 Ödeme Planı Referansı Payment Plan Reference
PRINTCNT Integer 2 447 Basılmış Toplam Hesap Total Count of Printed
GVATINC Byte 1 449 KDV dahil / hariç VAT included/excluded
BRANCH Integer 2 450 İşyeri Division
DEPARTMENT Integer 2 452 Bölüm Department
ACCFICHEREF Longint 4 454 Genel Muhasebe Fişi Referansı General Ledger Voucher Reference
ADDEXPACCREF Longint 4 458 Ek Masraflar Genel Muhasebe Hesabı Referansı Additional Surcharge General Ledger Account Reference
ADDEXPCENTREF Longint 4 462 Ek Masraflar Masraf Merkezi Referansı Additional Surcharge Overhead Pool Reference
DECPRDIFF Byte 1 466 Fiyat farkı (t: azalan, f: artan) Price Difference (T: Reducer, F: Raiser)
CAPIBLOCK_CREATEDBY Integer 2 467 Oluşturan Created By
CAPIBLOCK_CREADEDDATE Longint 4 469 Oluşturulma Tarihi Created Date
CAPIBLOCK_CREATEDHOUR Integer 2 473 Oluşturulma Saati Created Hour
CAPIBLOCK_CREATEDMIN Integer 2 475 Oluşturulma Dakikası Created Minute
CAPIBLOCK_CREATEDSEC Integer 2 477 Oluşturulma Saniyesi Created Second
CAPIBLOCK_MODIFIEDBY Integer 2 479 Değiştiren Modified By
CAPIBLOCK_MODIFIEDDATE Longint 4 481 Değiştirilme Tarihi Modified Date
CAPIBLOCK_MODIFIEDHOUR Integer 2 485 Değiştirilme Saati Modified Hour
CAPIBLOCK_MODIFIEDMIN Integer 2 487 Değiştirilme Dakikası Modified Minute
CAPIBLOCK_MODIFIEDSEC Integer 2 489 Değiştirilme Saniyesi Modified Second
SALESMANREF Longint 4 491 Satış Temsilcisi Referansı Sales Representative Card Reference
CANCELLEDACC Byte 1 495 Muhasebeleştirme İşlemi İptal Edilmiş Cancelled to Post General Ledger
SHPTYPCOD ZString 13 496 Teslimat Şekli Delivery Type
SHPAGNCOD ZString 13 509 Taşıyıcı Kodu Shipment Agent Code
TRACKNR ZString 17 522 Paket/Koli No Parcel / Item No
GENEXCTYP Integer 2 539 Döviz Türü (Genel) F. Currency Type (General)
LINEEXCTYP Integer 2 541 Döviz Türü (Satır) F. Currency Type (Line)
TRADINGGRP ZString 17 543 Ticari İşlem Grubu Trading Option
TEXTINC Byte 1 560 Ayrıntılı Açıklama İçerir Contains Detail Description
SITEID Integer 2 561 Veri Merkezi Data Processing Site
RECSTATUS Integer 2 563 Kayıt Durumu Record Status
ORGLOGICREF Longint 4 565 Orijinal Kayıt Log. Ref. Original Record Logical Reference
FACTORYNR Integer 2 569 Fabrika Numarası Plant Number
WFSTATUS Longint 4 571 Kullanımda Değil Not In Use
SHIPINFOREF Longint 4 575 Teslimat Bilgisi Ref. Delivery Information Reference
DISTORDERREF Longint 4 579 Dağıtım Emri Referansı Distribution Order Reference
SENDCNT Integer 2 583 Gönderilenlerin Sayısı Count of Sending
DLVCLIENT Byte 1 585 Teslimat Adresi Müşteri Tipi Delivery Address Client Type
COSTOFSALEFCREF Longint 4 586 Satılan malların maliyeti, yevmiye fişi Cost Of Goods Sold Journal Voucher
OPSTAT Integer 2 590 Hareket durumu Transaction Status
DOCTRACKINGNR ZString 21 592 Belge İzleme Numarası Document Tracking Number
TOTALADDTAX Double 8 613 Ek Vergi Toplamı Additional Tax Total
PAYMENTTYPE Integer 2 621 Ödeme türü Payment Type
INFIDX Double 8 623 Enflasyon Endeksi Inflation Index
ACCOUNTEDCNT Integer 2 631 Muhasebeleştirme sayısı Number of posting
ORGLOGOID ZString 25 633 Veri Merkezi Data Processing Site
FROMEXIM Byte 1 658 İthalat/İhracat İlişkisi Import – Export Relation
FRGTYPCOD ZString 13 659 Taşıma türü kodu Transport Typ Code
EXIMFCTYPE Integer 2 672 İthalat / İhracat Fiş Türü Foreign Trade Slip Type
FROMORDWITHPAY Byte 1 674 Ödemeli / Ödemesiz Sipariş? With payment / Without payment From order?
PROJECTREF Longint 4 675 Proje Referansı PROJECT Reference
WFLOWCRDREF Longint 4 679 İş Akış Kartı Referansı WFTASK Reference
STATUS Integer 2 683 Durumu Status

İlişkiler – Relations

Level Product ID Resource ID Special Code Source Field Destination Table Destination Field Relation Type Extra Condition
2 3 714   CLIENTREF L_CLCARD LOGICALREF one-to-one  
2 3 714   RECVREF L_CLCARD LOGICALREF one-to-one  
2 3 714   CENTERREF L_EMCENTER LOGICALREF one-to-one  
2 3 714   ACCOUNTREF L_EMUHACC LOGICALREF one-to-one  
2 3 714   KASTRANSREF L_KSLINES LOGICALREF one-to-one  
2 3 714   PAYDEFREF L_PAYPLANS LOGICALREF one-to-one  
2 3 714   ACCFICHEREF L_EMFICHE LOGICALREF one-to-one  
2 3 714   ADDEXPACCREF L_EMUHACC LOGICALREF one-to-one  
2 3 714   ADDEXPCENTREF L_EMCENTER LOGICALREF one-to-one  
2 3 714   SALESMANREF L_SLSMAN LOGICALREF one-to-one  
2 3 714   SHIPINFOREF L_SHIPINFO LOGICALREF one-to-one  
2 3 714   DISTORDERREF L_DISTORD LOGICALREF one-to-one  
2 3 714   COSTOFSALEFCREF L_EMFICHE LOGICALREF one-to-one  
2 3 714   PROJECTREF L_PROJECT LOGICALREF one-to-one  
2 3 714   WFLOWCRDREF L_WFTASK 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 Unique + Not Null 1 GRPCODE Ascending
2 3 Index2 Unique + Not Null 2 TRCODE Ascending
2 3 Index2 Unique + Not Null 3 FICHENO Ascending
2 3 Index3 Duplicate + Not Null 1 GRPCODE Ascending
2 3 Index3 Duplicate + Not Null 2 DATE_ Ascending
2 3 Index3 Duplicate + Not Null 3 TIME_ Ascending
2 3 Index3 Duplicate + Not Null 4 TRCODE Ascending
2 3 Index4 Unique + Not Null 1 TRCODE Ascending
2 3 Index4 Unique + Not Null 2 FICHENO Ascending
2 3 Index5 Duplicate + Not Null 1 DATE_ Ascending
2 3 Index5 Duplicate + Not Null 2 TIME_ Ascending
2 3 Index5 Duplicate + Not Null 3 TRCODE Ascending
2 3 Index6 Duplicate + Not Null 1 ACCFICHEREF Ascending
2 3 Index7 Duplicate + Not Null 1 CLIENTREF Ascending
2 3 Index7 Duplicate + Not Null 2 DATE_ Ascending
2 3 Index7 Duplicate + Not Null 3 TIME_ Ascending
2 3 Index8 Duplicate + Not Null 1 SALESMANREF Ascending
2 3 Index8 Duplicate + Not Null 2 DATE_ Ascending
2 3 Index8 Duplicate + Not Null 3 TIME_ Ascending
2 3 Index9 Duplicate + Not Null 1 GRPCODE Ascending
2 3 Index9 Duplicate + Not Null 2 CLIENTREF Ascending
2 3 Index9 Duplicate + Not Null 3 DATE_ Ascending
2 3 Index9 Duplicate + Not Null 4 TIME_ Ascending

>