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 |