LG_INVOICE

Alanlar ve Açıklamaları

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