Altbestand unitize_iwm_articles_arhp

Definition prüfen

Raw YAML Metadaten

engine Typ

valid Parse-Status

Managed Status

draft

iwm_articles_arhp 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_arhp
Source_Primary_Key: [AHFIRM, AHARTE, AHAPNR]
Target_Primary_Key: [firma, ordernumber] #always primary key for target datapool. primary key of source pool can be read from the pool itself.
Datapool: iwm_articles_arhp


Datapool_Definition:
    firma: VARCHAR(2) NOT NULL
    ordernumber: VARCHAR(255) NOT NULL
    mainnumber: VARCHAR(255) NOT NULL
    ahstat: VARCHAR(255) NOT NULL
    ahlzsd: VARCHAR(255) NOT NULL


Mapping:
    firma: iwm_articles_arhp.AHFIRM
    ordernumber: IF(iwm_articles_arhp.AHAPNR = 0, iwm_articles_arhp.AHARTE, CONCAT(iwm_articles_arhp.AHARTE,'-',iwm_articles_arhp.AHAPNR)) AS ordernumber
    mainnumber: iwm_articles_arhp.AHARTE
    ahstat:  iwm_articles_arhp.AHSTAT
    ahlzsd:  iwm_articles_arhp.AHLZSD

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_arhp
Source_Primary_Key	[ "AHFIRM", "AHARTE", "AHAPNR" ]
Target_Primary_Key	[ "firma", "ordernumber" ]
Datapool	iwm_articles_arhp
Datapool_Definition	{ "firma": "VARCHAR(2) NOT NULL", "ordernumber": "VARCHAR(255) NOT NULL", "mainnumber": "VARCHAR(255) NOT NULL", "ahstat": "VARCHAR(255) NOT NULL", "ahlzsd": "VARCHAR(255) NOT NULL" }
Mapping	{ "firma": "iwm_articles_arhp.AHFIRM", "ordernumber": "IF(iwm_articles_arhp.AHAPNR = 0, iwm_articles_arhp.AHARTE, CONCAT(iwm_articles_arhp.AHARTE,'-',iwm_articles_arhp.AHAPNR)) AS ordernumber", "mainnumber": "iwm_articles_arhp.AHARTE", "ahstat": "iwm_articles_arhp.AHSTAT", "ahlzsd": "iwm_articles_arhp.AHLZSD" }