Versions Compared

Old Version 1

changes.mady.by.user Ozan Uslu

Saved on

compared with

New Version Current

changes.mady.by.user Yuksel Ozbuga

Saved on

Key

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

Alış Kampanya Kartları Veri Aktarımları aşağıdaki şekildedir:

Alış Kampanya Kartları

Alan Açıklaması

Tür

Gerekli Alanlar

Uzunluk

Veri Tabanı Tablosu

Veri Tabanı Alanı

<RECORD_STATUS>Kullanım Durumu (0- Kullanımda, 1- Kullanım Dışı)Integer
 

2LG_CAMPAIGNACTIVE
<CODE>Alış Kampanya Kart KoduZString•25LG_CAMPAIGNCODE
<NAME>Alış Kampanya Kart AçıklamasıZString
 

51LG_CAMPAIGNNAME
<AUXIL_CODE>Özel KodZString
 

11LG_CAMPAIGNSPECODE
<AUTH_CODE>Yetki KoduZString
 

11LG_CAMPAIGNCYPHCODE
<BEG_DATE>Başlangıç TarihiLongint
 

4LG_CAMPAIGNBEGDATE
<END_DATE>Bitiş TarihiLongint
 

4LG_CAMPAIGNENDDATE
<PRIORITY_GRP>Öncelik GrubuZString
 

11LG_CAMPAIGNPRIORITYGRP
<PRIORITY>ÖncelikInteger
 

2LG_CAMPAIGNPRIORITY
<DONT_FIX_LINES>Material Lines That Realize Campaign Conditions Can Be Distributed (1- Yes, 0- No)Byte
 

1LG_CAMPAIGNDONTFIXLINES
<CLIENT_CODE>Cari Hesap Kodu

ZString

 

17LG_CAMPAIGNCLIENTCODE
<CL_AUXIL_CODE>Cari Hesap Özel KoduZString
 

11LG_CAMPAIGNCLSPECODE
<TRADING_GRP>Ticari İşlem GrubuZString
 

17LG_CAMPAIGNTRADINGGRP
<PAY_PLAN_CODE>Ödeme Plan KoduZString
 

17LG_CAMPAIGNPAYPLANCODE
<PP_GROUP_CODE>Ödeme Plan Grup KoduZString
 

11LG_CAMPAIGNPPGROUPCODE
<TOWN_CODE>İlçe KoduZString
 

13LG_CAMPAIGNTOWNCODE
<DISTRICT_CODE>Semt KoduZString
 

13LG_CAMPAIGNDISTRICTCODE
<CITY_CODE>Şehir KoduZString
 

13LG_CAMPAIGNCITYCODE
<COUNTRY_CODE>Ülke KoduZString
 

13LG_CAMPAIGNCOUNTRYCODE
<VARIABLE_DEFS1>Variable Definition 1ZString
 

251LG_CAMPAIGNVARIABLEDEFS11
<VARIABLE_DEFS2>Variable Definition 2ZString
 

251LG_CAMPAIGNVARIABLEDEFS2
<VARIABLE_DEFS3>Variable Definition 3ZString
 

251LG_CAMPAIGNVARIABLEDEFS3
<VARIABLE_DEFS4>Variable Definition 4ZString
 

251LG_CAMPAIGNVARIABLEDEFS4
<VARIABLE_DEFS5>Variable Definition 5ZString
 

251LG_CAMPAIGNVARIABLEDEFS5
<CREATED_BY>EkleyenInteger
 

2LG_CAMPAIGNCAPIBLOCK_CREATEDBY
<DATE_CREATED>Kayıt TarihiLongint
 

4LG_CAMPAIGNCAPIBLOCK_CREADEDDATE
<HOUR_CREATED>Kayıt SaatiInteger
 

2LG_CAMPAIGNCAPIBLOCK_CREATEDHOUR
<MIN_CREATED>Kayıt DakikasıInteger
 

2LG_CAMPAIGNCAPIBLOCK_CREATEDMIN
<SEC_CREATED>Kayıt SaniyesiInteger
 

2LG_CAMPAIGNCAPIBLOCK_CREATEDSEC
<MODIFIED_BY>Son DeğiştirenInteger
 

2LG_CAMPAIGNCAPIBLOCK_MODIFIEDBY
<DATE_MODIFIED>Değiştirme TarihiLongint
 

4LG_CAMPAIGNCAPIBLOCK_MODIFIEDDATE
<HOUR_MODIFIED>Değiştirme SaatiInteger
 

2LG_CAMPAIGNCAPIBLOCK_MODIFIEDHOUR
<MIN_MODIFIED>Değiştirme DakikasıInteger
 

2LG_CAMPAIGNCAPIBLOCK_MODIFIEDMIN
<SEC_MODIFIED>Değiştirme SaniyesiInteger
 

2LG_CAMPAIGNCAPIBLOCK_MODIFIEDSEC
<DATE_SITEID>Veri MerkeziInteger
 

2LG_CAMPAIGNSITEID
<DATA_REFERENCE>Veri ReferansıLongint
 

4LG_CAMPAIGNORGLOGICREF
<CAMPAIGN_LINES>
 

Memory
  


LG_CMPGNLINE
 

<LINE_NR>Satır NumarasıInteger
 

2LG_CMPGNLINELINENR
<LINE_TYPE>

Satır Türü

(1:İndirim; 2:Masraf; 3:Promosyon; 4:Puan)

Integer
 

2LG_CMPGNLINE

LINETYPE

<APPLY_TYPE>Uygulama Türü ; (0: Satıra; 1: Genele)Integer
 

2LG_CMPGNLINEAPPLYTYPE
<COND_ITEM_CODE>Koşul Malzeme KoduZstring
 

25LG_CMPGNLINECONDITEMCODE
<CONDITION>KoşulZstring
 

251LG_CMPGNLINECONDITION
<FORMULA>FormülZstring
 

251LG_CMPGNLINEFORMULA
<PROMIS_CLASS>Is Material Class (1- Yes, 0- No)Byte
 

1LG_CMPGNLINEPROMISCLASS
<ITEM_CODE>Malzeme Kartı KoduZString
 

25LG_ITEMSCODE
<UOM_CODE>Birim KoduZString
 

11LG_UNITSETLCODE