Altbestand / Detail

unitize / unitize_iwm_ek_prices_new

Mandant local-safety-smoke
Altbestand
Managed Definition öffnen
engine Typ
valid Parse-Status
Managed Status
draft
iwm_ek_prices_new Kurzinfo

Raw YAML

Dateiinhalt

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_ek_prices_new
Source_Primary_Key: [EKFIRM, EKARTE, EKAPNR]
Target_Primary_Key: [ordernumber, firma] #always primary key for target datapool. primary key of source pool can be read from the pool itself.
Datapool: iwm_ek_prices_new


Datapool_Definition:
    ordernumber: VARCHAR(255) NOT NULL
    firma: VARCHAR(255) NOT NULL
    A9BREK: VARCHAR(255) NOT NULL
    A9K200: VARCHAR(255) NOT NULL
    A9K300: VARCHAR(255) NOT NULL



Mapping:
    ordernumber: IF(iwm_ek_prices_new.EKAPNR = 0, iwm_ek_prices_new.EKARTE, CONCAT(iwm_ek_prices_new.EKARTE, '-',iwm_ek_prices_new.EKAPNR)) AS ordernumber
    firma: iwm_ek_prices_new.EKFIRM
    A9BREK: iwm_ek_prices_new.EKP100
    A9K200: iwm_ek_prices_new.EKP200
    A9K300: iwm_ek_prices_new.EKP300

Metadata

Erkannte Konfiguration

Diese Sicht basiert auf der aktuell lesbaren Legacy-Datei und hilft beim Vergleichen vor dem Import.

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_ek_prices_new
Source_Primary_Key [ "EKFIRM", "EKARTE", "EKAPNR" ]
Target_Primary_Key [ "ordernumber", "firma" ]
Datapool iwm_ek_prices_new
Datapool_Definition { "ordernumber": "VARCHAR(255) NOT NULL", "firma": "VARCHAR(255) NOT NULL", "A9BREK": "VARCHAR(255) NOT NULL", "A9K200": "VARCHAR(255) NOT NULL", "A9K300": "VARCHAR(255) NOT NULL" }
Mapping { "ordernumber": "IF(iwm_ek_prices_new.EKAPNR = 0, iwm_ek_prices_new.EKARTE, CONCAT(iwm_ek_prices_new.EKARTE, '-',iwm_ek_prices_new.EKAPNR)) AS ordernumber", "firma": "iwm_ek_prices_new.EKFIRM", "A9BREK": "iwm_ek_prices_new.EKP100", "A9K200": "iwm_ek_prices_new.EKP200", "A9K300": "iwm_ek_prices_new.EKP300" }