Altbestand / Detail

unitize / iwm_articles_kojen

Mandant connection-overlay-smoke-20260406
Altbestand
Managed Definition öffnen
engine Typ
valid Parse-Status
Managed Status
draft
iwm_articles_kojen 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_articles_kojen
Source_Primary_Key: [LBFIRM, LBSPAR, LBVKHS, LBARTE, LBAPNR, LBLAPP]
Target_Primary_Key: [firma, sparte, verkaufshaus, ordernumber, koje] #always primary key for target datapool. primary key of source pool can be read from the pool itself.
Datapool: iwm_articles_kojen


Datapool_Definition:
    firma: VARCHAR(2) NOT NULL
    sparte: VARCHAR(2) NOT NULL
    verkaufshaus: VARCHAR(2) NOT NULL
    ordernumber: VARCHAR(255) NOT NULL
    mainnumber: VARCHAR(255) NOT NULL
    koje: VARCHAR(255) NOT NULL
    kojencode: VARCHAR(255) DEFAULT NULL


Mapping:
    firma: iwm_articles_kojen.LBFIRM
    sparte: iwm_articles_kojen.LBSPAR
    verkaufshaus: iwm_articles_kojen.LBVKHS
    ordernumber: CONCAT(iwm_articles_kojen.LBARTE,'-',iwm_articles_kojen.LBAPNR) as ordernumber
    mainnumber: iwm_articles_kojen.LBARTE
    koje: iwm_articles_kojen.LBLAPP
    kojencode: CONCAT(iwm_articles_kojen.LBVKHS, '-', iwm_articles_kojen.LBLAPP) as kojencode

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_articles_kojen
Source_Primary_Key [ "LBFIRM", "LBSPAR", "LBVKHS", "LBARTE", "LBAPNR", "LBLAPP" ]
Target_Primary_Key [ "firma", "sparte", "verkaufshaus", "ordernumber", "koje" ]
Datapool iwm_articles_kojen
Datapool_Definition { "firma": "VARCHAR(2) NOT NULL", "sparte": "VARCHAR(2) NOT NULL", "verkaufshaus": "VARCHAR(2) NOT NULL", "ordernumber": "VARCHAR(255) NOT NULL", "mainnumber": "VARCHAR(255) NOT NULL", "koje": "VARCHAR(255) NOT NULL", "kojencode": "VARCHAR(255) DEFAULT NULL" }
Mapping { "firma": "iwm_articles_kojen.LBFIRM", "sparte": "iwm_articles_kojen.LBSPAR", "verkaufshaus": "iwm_articles_kojen.LBVKHS", "ordernumber": "CONCAT(iwm_articles_kojen.LBARTE,'-',iwm_articles_kojen.LBAPNR) as ordernumber", "mainnumber": "iwm_articles_kojen.LBARTE", "koje": "iwm_articles_kojen.LBLAPP", "kojencode": "CONCAT(iwm_articles_kojen.LBVKHS, '-', iwm_articles_kojen.LBLAPP) as kojencode" }