Altbestand / Detail

unitize / unitize_iwm_ek_prices

Mandant csv-pipeline-smoke
Altbestand
Managed Definition öffnen
engine Typ
valid Parse-Status
Managed Status
draft
iwm_ek_prices 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
Source_Primary_Key: [A9FIRM, A9ARTE, A9APNR]
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


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



Mapping:
    ordernumber: IF(iwm_ek_prices.A9APNR = 0, iwm_ek_prices.A9ARTE, CONCAT(iwm_ek_prices.A9ARTE, '-',iwm_ek_prices.A9APNR)) AS ordernumber
    firma: iwm_ek_prices.A9FIRM
    A9BREK: iwm_ek_prices.A9BREK
    A9K200: iwm_ek_prices.A9K200
    A9K250: iwm_ek_prices.A9K250
    A9K300: iwm_ek_prices.A9K300

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
Source_Primary_Key [ "A9FIRM", "A9ARTE", "A9APNR" ]
Target_Primary_Key [ "ordernumber", "firma" ]
Datapool iwm_ek_prices
Datapool_Definition { "ordernumber": "VARCHAR(255) NOT NULL", "firma": "VARCHAR(255) NOT NULL", "A9BREK": "VARCHAR(255) NOT NULL", "A9K200": "VARCHAR(255) NOT NULL", "A9K250": "VARCHAR(255) NOT NULL", "A9K300": "VARCHAR(255) NOT NULL" }
Mapping { "ordernumber": "IF(iwm_ek_prices.A9APNR = 0, iwm_ek_prices.A9ARTE, CONCAT(iwm_ek_prices.A9ARTE, '-',iwm_ek_prices.A9APNR)) AS ordernumber", "firma": "iwm_ek_prices.A9FIRM", "A9BREK": "iwm_ek_prices.A9BREK", "A9K200": "iwm_ek_prices.A9K200", "A9K250": "iwm_ek_prices.A9K250", "A9K300": "iwm_ek_prices.A9K300" }