Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Cari Hesap Kartları Veri Aktarımları aşağıdaki şekildedir:

Cari Hesap Kartları

Alan Açıklaması

Tür

Gerekli Alanlar

Uzunluk

Veri Tabanı Tablosu

Veri Tabanı Alanı

<RECORD STATUS>

Kayıt Statüsü

Integer

 


2

LG_CLCARD

ACTIVE

<ACCOUNT_TYPE

Kayıt Tipi

Integer

2

LG_CLCARD

CARDTYPE

<CODE>

Cari Hesap Kodu

ZString

17

LG_CLCARD

CODE

<TITLE>

Cari Hesap Unvanı

ZString

 


51

LG_CLCARD

DEFINITION_

<AUXIL_CODE>

Özel Kod

ZString

 


11

LG_CLCARD

SPECODE

<AUTH_CODE>

Yetki Kodu

ZString

 


11

LG_CLCARD

CYPHCODE

<ADDRESS1>

Adres 1

ZString

 


51

LG_CLCARD

ADDR1

<ADDRESS2>

Adres 2

ZString

 


51

LG_CLCARD

ADDR2

<DISTRICT_CODE>

Semt Kodu

ZString

 


13

LG_CLCARD

DISTRICTCODE

<DISTRICT>

Semt Açıklaması

ZString

 


51

LG_CLCARD

DISTRICT

<TOWN_CODE>

İlçe Kodu

ZString

 


13

LG_CLCARD

TOWNCODE

<TOWN>

İlçe

ZString

 


51

LG_CLCARD

TOWN

<CITY_ CODE >

Şehir Kodu

ZString

 

 



LG_CLCARD

CITYCODE

<CITY>

Şehir

ZString

 


21

LG_CLCARD

CITY

<COUNTRY_CODE>

Ülke Kodu

ZString

 


13

LG_CLCARD

COUNTRYCODE

<COUNTRY>

Ülke

ZString

 


21

LG_CLCARD

COUNTRY

<POSTAL_CODE>

Posta Kodu

ZString

 


11

LG_CLCARD

POSTCODE

<TELEPHONE1>

Telefon 1

ZString

 


16

LG_CLCARD

TELNRS1

<TELEPHONE2>

Telefon 2

ZString

 


16

LG_CLCARD

TELNRS2

<FAX>

Faks

ZString

 


16

LG_CLCARD

FAXNR

<TAX_ID>

Vergi Numarası

ZString

 


16

LG_CLCARD

TAXNR

<TAX_OFFICE>

Vergi Dairesi

ZString

 


16

LG_CLCARD

TAXOFFICE

<TAX_OFFICE_CODE>

Vergi Dairesi Kodu

ZString

 


17

LG_CLCARD

TAXOFFCODE

<CONTACT>

İlgili

ZString

 


21

LG_CLCARD

INCHARGE

<DISCOUNT_RATE>

İndirim Oranı

ZString

 


8

LG_CLCARD

DISCRATE

<PAYMENT_CODE>

Ödeme Plan Kodu

ZString

 


17

LG_PAYPLANS

CODE

<E_MAIL>

e-Mail

ZString

 


31

LG_CLCARD

EMAILADDR

<WEB_URL>

Web

ZString

 


41

LG_CLCARD

WEBADDR

<REMINDER_TYPE>

İhtar Türü

Integer

 


2

LG_CLCARD

WARNMETHOD

<REMINDER_EMAIL>

İhtar Adresi - e_Mail

ZString

 


31

LG_CLCARD

WARNEMAILADDR

<REMINDER_FAX>

İhtar Şekli - Faks

ZString

 


16

LG_CLCARD

WARNFAXNR

<CORRESP_LANG>

Yazışma Dili

Integer

 


2

LG_CLCARD

CLANGUAGE

<VAT_ID>

KDV No

ZString

 


33

LG_CLCARD

VATNR

<BLOCKED>

Durduruldu

ZString

 


2

LG_CLCARD

BLOCKED

<BANK_ID1>

Banka Numarası 1

ZString

 


17

LG_CLCARD

BANKBRANCHS1

<BANK_ID2>

Banka Numarası 2

ZString

 


17

LG_CLCARD

BANKBRANCHS2

<BANK_ID3>

Banka Numarası 3

ZString

 


17

LG_CLCARD

BANKBRANCHS3

<BANK_ID4>

Banka Numarası 4

ZString

 


17

LG_CLCARD

BANKBRANCHS4

<BANK_ID5>

Banka Numarası 5

ZString

 


17

LG_CLCARD

BANKBRANCHS5

<BANK_ID6>

Banka Numarası 6

ZString

 


17

LG_CLCARD

BANKBRANCHS6

<BANK_ID7>

Banka Numarası 7

ZString

 


17

LG_CLCARD

BANKBRANCHS7

<BANK_ACCOUNT1>

Banka Hesap Numarası 1

ZString

 


17

LG_CLCARD

BANKACCOUNTS1

<BANK_ACCOUNT2>

Banka Hesap Numarası 2

ZString

 


17

LG_CLCARD

BANKACCOUNTS2

<BANK_ACCOUNT3>

Banka Hesap Numarası 3

ZString

 


17

LG_CLCARD

BANKACCOUNTS3

<BANK_ACCOUNT4>

Banka Hesap Numarası 4

ZString

 


17

LG_CLCARD

BANKACCOUNTS4

<BANK_ACCOUNT5>

Banka Hesap Numarası 5

ZString

 


17

LG_CLCARD

BANKACCOUNTS5

<BANK_ACCOUNT6>

Banka Hesap Numarası 6

ZString

 


17

LG_CLCARD

BANKACCOUNTS6

<BANK_ACCOUNT7>

Banka Hesap Numarası 7

ZString

 


17

LG_CLCARD

BANKACCOUNTS7

<DELIVERY_METHOD>

Teslim Şekli

ZString

 


13

LG_CLCARD

DELIVERYMETHOD

<SHIPMENT_AGENT>

Taşıyıcı Firma

ZString

 


13

LG_CLCARD

DELIVERYFIRM

<CURRENCY>

Döviz

Integer

 


2

LG_CLCARD

CCURRENCY

<DATA_SITEID>

Bilgi Veri Merkezi

Integer

 


2

LG_CLCARD

SITEID

<DATA_REFERENCE>

Veri Referansı

Longint

 


4

LG_CLCARD

ORGLOGICREF

<E_COMM_ID>

Veri Aktarım ID

ZString

 


25

LG_CLCARD

EDINO

<TRADING_GRP>

Ticari İşlem Grubu

ZString

 


17

LG_CLCARD

TRADINGGRP

<CREATED BY>

Ekleyen

Integer

 


2

LG_CLCARD

CAPIBLOCK_CREATEDBY

<DATE CREATED>

Ekleme Tarihi

Longint

 


4

LG_CLCARD

CAPIBLOCK_CREADEDDATE

<HOUR_CREATED>

Ekleme Saati

Integer

 


2

LG_CLCARD

CAPIBLOCK_CREATEDHOUR

<MIN_CREATED>

Ekleme Dakikası

Integer

 


2

LG_CLCARD

CAPIBLOCK_CREATEDMIN

<SEC_CREATED>

Ekleme Saniyesi

Integer

 


2

LG_CLCARD

CAPIBLOCK_CREATEDSEC

<MODIFIED_BY>

Değiştiren

Integer

 


2

LG_CLCARD

CAPIBLOCK_MODIFIEDBY

<DATE_MODIFIED

Değiştirme Tarihi

Longint

 


4

LG_CLCARD

CAPIBLOCK_MODIFIEDDATE

<HOUR_MODIFIED>

Değiştirme Saati

Integer

 


2

LG_CLCARD

CAPIBLOCK_MODIFIEDHOUR

<MIN_MODIFIED>

Değiştirme Dakikası

Integer

 


2

LG_CLCARD

CAPIBLOCK_MODIFIEDMIN

<SEC_MODIFIED>

Değiştirme Saniyesi

Integer

 


2

LG_CLCARD

CAPIBLOCK_MODIFIEDSEC

<DEBT_TRCK_TYPE>

Ödeme İzleme Türü

Integer

 


2

LG_CLCARD

PAYMENTPROC

<XRTDIF_TYPE>

Kur Farkı Hesabı

Integer

 


2

LG_CLCARD

CRATEDIFFPROC

<NOTES>

Notlar

Memory

 

 

LG_CLINTEL

 

<LINE>

Satır

ZString

 


51

LG_CLINTEL

INTELLINE

<CREDIT_TYPE>

Risk Kontrol Tipi

Byte

 


1

LG_CLRNUMS

RISKTYPE

<CREDIT_LIMIT>

Risk Limiti

Double

 


8

LG_CLRNUMS

RISKLIMIT

<CREDIT_BALANCED>

Kapanan Risk

Double

 


8

LG_CLRNUMS

RISKBALANCED

<RISKFACT_CHQ>

Çek Risk Çarpanı

Double

 


8

LG_CLRNUMS

CEKRISKFACTOR

<RISKFACT_PROMNT>

Senet Risk Çarpanı

Double

 


8

LG_CLRNUMS

SENETRISKFACTOR

<ACTION_CREDHOLD_ORD>

Risk Limiti Aşıldığında - Siparişte

Byte

 


1

LG_CLRNUMS

ORDRISKOVER

<ACTION_CREDHOLD_SHP>

Risk Limiti Aşıldığında - İrsaliyede

Byte

 


1

LG_CLRNUMS

DESPRISKOVER

<ACTION_CREDHOLD_OTH>

Risk Limiti Aşıldığında - Diğer İşlemlerde

Byte

 


1

LG_CLRNUMS

RISKOVER

<GL_CODE >

Muhasebe Hesap Kodu

ZString

 


25

LG_EMUHACC

CODE

<OHP_CODE>

Masraf Merkezi Kodu

ZString

 


17

LG_EMCENTER

CODE

<PP_GROUP_CODE>

Ödeme Planı Grup Kodu

ZString

 


11

LG_CLCARD

PPGROUPCODE

<USE_REP_RISK>

Will be used On Credit Tracking

Byte

 


1

LG_CLRNUMS

USEREPRISK

<RISK_LIMIT>

Raporlama Dövizi Kredi Limiti

Double

 


8

LG_CLRNUMS

REPRISKLIMIT

<RISK_BALANCED>

Reporting Currency Delivered Credit

Double

 


8

LG_CLRNUMS

REPRISKBALANCED

<ORD_SEND_METHOD>

Sipariş Formu Gönderme metodu

Integer

 


2

LG_CLCARD

ORDSENDMETHOD

<ORD_SEND_EMAIL>

Sipariş Formunun e-Mail Adresine Gönderilmesi

ZString

 


31

LG_CLCARD

ORDSENDEMAILADDR

<ORD_SEND_FAX>

Sipariş Formunun Faks Numarasına Gönderilmesi

ZString

 


16

LG_CLCARD

ORDSENDFAXNR

<DSP_SEND_METHOD>

Makbuz / İrsaliye Gönderme Metodu

Integer

 


2

LG_CLCARD

DSPSENDMETHOD

<DSP_SEND_EMAIL>

Makbuz / İrsaliyenin Mail Adresine Gönderilmesi

ZString

 


31

LG_CLCARD

DSPSENDEMAILADDR

<DSP_SEND_FAX>

Makbuz / İrsaliyenin Faks Numarasına Gönderilmesi

ZString

 


16

LG_CLCARD

DSPSENDFAXNR

<INV_SEND_METHOD>

Fatura Formunu Gönderme Metodu

Integer

 


2

LG_CLCARD

INVSENDMETHOD

<INV _SEND_EMAIL>

Faturanın Mail Adresine Gönderilmesi

ZString

 


31

LG_CLCARD

INVSENDEMAILADDR

<INV _SEND_FAX>

Faturanın Faks Numarasına Gönderilmesi

ZString

 


16

LG_CLCARD

INVSENDFAXNR

<ORD_RISK_TOTAL>

Sipariş Kredi Limiti

Double

 


8

LG_CLRNUMS

ORDRISKTOTAL

<ORD_RISK_TOTAL_SUGG>

Sipariş Kredi Limiti (Öneri)

Double

 


8

LG_CLRNUMS

ORDRISKTOTALSUGG

<REP_ORD_RISK_TOTAL>

Sipariş Kredi Limiti (Raporlama Dövizi)

Double

 


8

LG_CLRNUMS

REPORDRISKTOTAL

<ORD_RISK_TOTAL_SUGG>

Sipariş Kredi Limiti (Raporlama Dövizi) (Öneri)

Double

 


8

LG_CLRNUMS

REPORDRISKTOTALSUGG