unitize / iwm_articles_lieferzeit

Engine: Unitize
Source_Config: importEngine
Target_Config: unitizeEngine
Mysql_Engine: InnoDB
Default_Charset: latin1
Source_Connection_Type: database
Source_Database_Connection_Service: DatabaseConnectionService
Source_Datapool: iwm_articles_lieferzeit
Source_Primary_Key: [VCLINR, VCFIRM]
Target_Primary_Key: [ordernumber, firma, lieferzeit, VCKVOT] #always primary key for target datapool. primary key of source pool can be read from the pool itself.

Datapool: iwm_articles_lieferzeit

Add_Indices:
  - Add_Index:
      Datapool: iwm_articles_lieferzeit
      Index_Name: idx_VCLINR_VCFIRM
      Fields: VCLINR, VCFIRM
  - Add_Index:
      Datapool: iwm_articles_new
      Index_Name: idx_LIEFERANTENNUMMER_FIRMA
      Fields: LIEFERANTENNUMMER, FIRMA

Joins:
 - Join:
   Datapool: iwm_articles_new
   Join_Condition:  iwm_articles_lieferzeit.VCLINR = iwm_articles_new.LIEFERANTENNUMMER AND iwm_articles_lieferzeit.VCFIRM = iwm_articles_new.FIRMA

Read_Conditions:
  - iwm_articles_lieferzeit.VCSYSN = 0
  - iwm_articles_lieferzeit.VCARTE = 0
  - iwm_articles_lieferzeit.VCHWGR = 0
  - iwm_articles_lieferzeit.VCKVOT = '' OR iwm_articles_lieferzeit.VCKVOT is null OR iwm_articles_lieferzeit.VCKVOT = 'S'


Datapool_Definition:
    ordernumber: VARCHAR(255) NOT NULL
    lieferzeit: VARCHAR(255) NOT NULL
    firma: VARCHAR(255) NOT NULL
    VCKVOT: VARCHAR(255) NOT NULL DEFAULT ''


Mapping:
    ordernumber: iwm_articles_new.ORDERNUMBER
    lieferzeit: iwm_articles_lieferzeit.VCLIW1
    firma: iwm_articles_new.FIRMA
    firma: iwm_articles_lieferzeit.VCKVOT