bank
Normal
0
/
ID_BATCH Y ID_BATCH CHANNEL_ID Y CHANNEL_ID TRANSNAME Y TRANSNAME STATUS Y STATUS LINES_READ Y LINES_READ LINES_WRITTEN Y LINES_WRITTEN LINES_UPDATED Y LINES_UPDATED LINES_INPUT Y LINES_INPUT LINES_OUTPUT Y LINES_OUTPUT LINES_REJECTED Y LINES_REJECTED ERRORS Y ERRORS STARTDATE Y STARTDATE ENDDATE Y ENDDATE LOGDATE Y LOGDATE DEPDATE Y DEPDATE REPLAYDATE Y REPLAYDATE LOG_FIELD Y LOG_FIELD ID_BATCH Y ID_BATCH SEQ_NR Y SEQ_NR LOGDATE Y LOGDATE TRANSNAME Y TRANSNAME STEPNAME Y STEPNAME STEP_COPY Y STEP_COPY LINES_READ Y LINES_READ LINES_WRITTEN Y LINES_WRITTEN LINES_UPDATED Y LINES_UPDATED LINES_INPUT Y LINES_INPUT LINES_OUTPUT Y LINES_OUTPUT LINES_REJECTED Y LINES_REJECTED ERRORS Y ERRORS INPUT_BUFFER_ROWS Y INPUT_BUFFER_ROWS OUTPUT_BUFFER_ROWS Y OUTPUT_BUFFER_ROWS ID_BATCH Y ID_BATCH CHANNEL_ID Y CHANNEL_ID LOG_DATE Y LOG_DATE LOGGING_OBJECT_TYPE Y LOGGING_OBJECT_TYPE OBJECT_NAME Y OBJECT_NAME OBJECT_COPY Y OBJECT_COPY REPOSITORY_DIRECTORY Y REPOSITORY_DIRECTORY FILENAME Y FILENAME OBJECT_ID Y OBJECT_ID OBJECT_REVISION Y OBJECT_REVISION PARENT_CHANNEL_ID Y PARENT_CHANNEL_ID ROOT_CHANNEL_ID Y ROOT_CHANNEL_ID ID_BATCH Y ID_BATCH CHANNEL_ID Y CHANNEL_ID LOG_DATE Y LOG_DATE TRANSNAME Y TRANSNAME STEPNAME Y STEPNAME STEP_COPY Y STEP_COPY LINES_READ Y LINES_READ LINES_WRITTEN Y LINES_WRITTEN LINES_UPDATED Y LINES_UPDATED LINES_INPUT Y LINES_INPUT LINES_OUTPUT Y LINES_OUTPUT LINES_REJECTED Y LINES_REJECTED ERRORS Y ERRORS LOG_FIELD N LOG_FIELD
0.0
0.0
10000
50
50
N
Y
50000
Y
N
1000
100
-
2013/10/02 10:03:39.448
-
2013/10/02 10:03:39.448
source
${source_host}
POSTGRESQL
Native
${source}
${source_port}
${source_user}
${source_password}
FORCE_IDENTIFIERS_TO_LOWERCASEN FORCE_IDENTIFIERS_TO_UPPERCASEN IS_CLUSTEREDN PORT_NUMBER${source_port} QUOTE_ALL_FIELDSN SUPPORTS_BOOLEAN_DATA_TYPEN USE_POOLINGN
target
${target_host}
POSTGRESQL
Native
${target}
${target_port}
${target_user}
${target_password}
FORCE_IDENTIFIERS_TO_LOWERCASEN FORCE_IDENTIFIERS_TO_UPPERCASEN IS_CLUSTEREDN PORT_NUMBER${target_port} QUOTE_ALL_FIELDSN SUPPORTS_BOOLEAN_DATA_TYPEY USE_POOLINGN
try28_zikzakmedia
localhost
POSTGRESQL
Native
try28_zikzakmedia
5432
jmartin
Encrypted 2be98afc86aa7b48bb91aaf52df80acdb
FORCE_IDENTIFIERS_TO_LOWERCASEN FORCE_IDENTIFIERS_TO_UPPERCASEN IS_CLUSTEREDN PORT_NUMBER5432 QUOTE_ALL_FIELDSN SUPPORTS_BOOLEAN_DATA_TYPEN USE_POOLINGN
Bank exist? Create bank_id Y OpenERP res_bank source N Select bank values target Y Bank exist? Select values Y lookup bank 2 Bank exist? Y create_uid write_uid Y write_uid Select bank values Y Select values migration.bank_mapping Y Select bank_mapping values migration.bank_mapping Y target select-bank N select-bank Tryton Bank N source Database join Y Database join lookup bank 2 Y Create bank_id create_uid Y write_uid Select bank_mapping values Y
Bank exist?
FilterRows
Y
1
none
Select values
Create bank_id
N
bank_id
IS NOT NULL
475
278
Y
Create bank_id
Sequence
Y
1
none
new_bank_id
Y
target
public
bank_id_seq
N
1000
1
999999999
474
384
Y
OpenERP res_bank
TableInput
Y
1
none
source
SELECT * FROM res_bank
0
N
N
N
85
279
Y
Select bank values
SelectValues
Y
1
none
N
id
create_uid
write_uid
active
new_bank_id
id
Integer
-2
-2
false
create_uid_target
create_uid
Integer
-2
-2
false
write_uid_target
write_uid
Integer
-2
-2
false
987
385
Y
Select bank_mapping values
SelectValues
Y
1
none
id
source
-2
-2
new_bank_id
target
-2
-2
N
883
278
Y
Select values
SelectValues
Y
1
none
id
source
-2
-2
bank_id
target
-2
-2
N
596
279
Y
Tryton Bank
TableOutput
Y
1
none
target
1000
N
N
N
N
N
N
Y
N
Y
N
1294
385
Y
migration.bank_mapping
TableOutput
Y
1
none
target
migration
1000
N
N
N
N
N
N
Y
N
Y
N
719
278
Y
create_uid
DBLookup
Y
4
none
target
Y
Y
0
migration
N
N
create_uid
source
=
target
create_uid_target
Integer
593
383
Y
lookup bank 2
DBLookup
Y
4
none
target
N
N
0
N
N
party
party
=
id
bank_id
Integer
379
279
Y
select-bank
SelectValues
Y
1
none
id
0
0
create_uid
0
0
create_date
0
0
bic
0
0
write_uid
0
0
write_date
0
0
party
0
0
N
1195
385
Y
source
Dummy
Y
1
none
191
279
Y
target
Dummy
N
1
none
1101
385
Y
write_uid
DBLookup
N
4
none
target
Y
Y
0
migration
N
N
write_uid
source
=
target
write_uid_target
Integer
884
384
Y
Database join
DBJoin
Y
1
none
target
0
SELECT
id AS party
FROM
party_party
WHERE
substring(code, 1, 3) = 'BNC'
AND
substring(code, 4, 7) = ?
N
N
code
String
278
280
Y
N