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 |