Page History
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> | 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 |