account_invoice Normal / ID_BATCHYID_BATCHCHANNEL_IDYCHANNEL_IDTRANSNAMEYTRANSNAMESTATUSYSTATUSLINES_READYLINES_READLINES_WRITTENYLINES_WRITTENLINES_UPDATEDYLINES_UPDATEDLINES_INPUTYLINES_INPUTLINES_OUTPUTYLINES_OUTPUTLINES_REJECTEDYLINES_REJECTEDERRORSYERRORSSTARTDATEYSTARTDATEENDDATEYENDDATELOGDATEYLOGDATEDEPDATEYDEPDATEREPLAYDATEYREPLAYDATELOG_FIELDYLOG_FIELD ID_BATCHYID_BATCHSEQ_NRYSEQ_NRLOGDATEYLOGDATETRANSNAMEYTRANSNAMESTEPNAMEYSTEPNAMESTEP_COPYYSTEP_COPYLINES_READYLINES_READLINES_WRITTENYLINES_WRITTENLINES_UPDATEDYLINES_UPDATEDLINES_INPUTYLINES_INPUTLINES_OUTPUTYLINES_OUTPUTLINES_REJECTEDYLINES_REJECTEDERRORSYERRORSINPUT_BUFFER_ROWSYINPUT_BUFFER_ROWSOUTPUT_BUFFER_ROWSYOUTPUT_BUFFER_ROWS ID_BATCHYID_BATCHCHANNEL_IDYCHANNEL_IDLOG_DATEYLOG_DATELOGGING_OBJECT_TYPEYLOGGING_OBJECT_TYPEOBJECT_NAMEYOBJECT_NAMEOBJECT_COPYYOBJECT_COPYREPOSITORY_DIRECTORYYREPOSITORY_DIRECTORYFILENAMEYFILENAMEOBJECT_IDYOBJECT_IDOBJECT_REVISIONYOBJECT_REVISIONPARENT_CHANNEL_IDYPARENT_CHANNEL_IDROOT_CHANNEL_IDYROOT_CHANNEL_ID ID_BATCHYID_BATCHCHANNEL_IDYCHANNEL_IDLOG_DATEYLOG_DATETRANSNAMEYTRANSNAMESTEPNAMEYSTEPNAMESTEP_COPYYSTEP_COPYLINES_READYLINES_READLINES_WRITTENYLINES_WRITTENLINES_UPDATEDYLINES_UPDATEDLINES_INPUTYLINES_INPUTLINES_OUTPUTYLINES_OUTPUTLINES_REJECTEDYLINES_REJECTEDERRORSYERRORSLOG_FIELDNLOG_FIELD 0.0 0.0 10000 50 50 N Y 50000 Y N 1000 100 - 2012/12/28 16:05:45.566 - 2012/12/28 16:05:45.566 source ${source_host} POSTGRESQL Native ${source} 5432 ${source_user} ${source_password} FORCE_IDENTIFIERS_TO_LOWERCASEN FORCE_IDENTIFIERS_TO_UPPERCASEN IS_CLUSTEREDN PORT_NUMBER5432 QUOTE_ALL_FIELDSN SUPPORTS_BOOLEAN_DATA_TYPEN USE_POOLINGN target ${target_host} POSTGRESQL Native ${target} 5432 ${target_user} ${target_password} FORCE_IDENTIFIERS_TO_LOWERCASEN FORCE_IDENTIFIERS_TO_UPPERCASEN IS_CLUSTEREDN PORT_NUMBER5432 QUOTE_ALL_FIELDSN SUPPORTS_BOOLEAN_DATA_TYPEY USE_POOLINGN Table inputsourceN targetTable outputN create_uidwrite_uidY sourcecreate_uidY write_uidpartyY partyparty_addressY party_addressjournalY journalaccountY Select valuestargetY Select valuesTable outputN accountcurrencyY stateSelect valuesY typestateY Join 2Set field valueY Payment termJoin 2Y RemoveunionY Set field valueRemoveY payment term is Null?Join 2Y payment term is Null?unionY currencypayment term is Null?Y uniontypeY Join 2 JoinRows Y 1 none %%java.io.tmpdir%% out 500

Payment term

N default_payment_term = default_payment_term

654 39 Y Payment term TableInput Y 1 none source SELECT id as default_payment_term FROM account_payment_term order by id; 1 N N N

510 36 Y Remove SelectValues Y 1 none N default_payment_term

746 99 Y Select values SelectValues N 1 none N create_uid write_uid target_account_id account Integer -2 -2 false company_id company Integer -2 -2 false create_uid_target create_uid Integer -2 -2 false curreny currency Integer -2 -2 false name description String -2 -2 false address_invoice_target invoice_address Integer -2 -2 false date_invoice invoice_date Date -2 -2 false target_journal_id journal Integer -2 -2 false move_id move Integer -2 -2 false party_target party Integer -2 -2 false write_uid_target write_uid Integer -2 -2 false

963 195 Y Set field value SetValueField Y 1 none payment_term default_payment_term

746 32 Y Table input TableInput Y 1 none source SELECT * FROM account_invoice 0 N N N

104 346 Y Table output TableOutput Y 1 none target account_invoice 1000 N N N N N N Y N Y N

1064 318 Y account DBLookup Y 4 none target Y Y 0 migration account_account_mapping N N account_id source = target target_account_id Integer

576 195 Y create_uid DBLookup Y 4 none target Y Y 0 migration user_mapping N N create_uid source = target create_uid_target Integer

193 195 Y currency DBLookup Y 4 none target Y Y 0 migration currency_currency_mapping N N currency_id source = target curreny Integer

647 195 Y journal DBLookup Y 4 none target N Y 0 migration account_journal_mapping N N journal_id source = target target_journal_id Integer

505 195 Y party DBLookup Y 4 none target Y Y 0 migration party_party_mapping N N partner_id source = target party_target Integer

357 194 Y party_address DBLookup Y 4 none target Y Y 0 migration party_address_mapping N N address_invoice_id source = target address_invoice_target Integer

431 195 Y payment term is Null? FilterRows Y 1 none Join 2 union N payment_term IS NULL

651 116 Y source Dummy Y 1 none

102 196 Y state ValueMapper Y 1 none state draft draft proforma validated proforma2 validated open posted paid paid cancel cancel

882 196 Y target Dummy Y 1 none

1050 191 Y type ValueMapper Y 1 none type out_invoice out_invoice out_refund out_credit_note in_invoice in_invoice in_refund in_credit_note

813 196 Y union Dummy Y 1 none

734 196 Y write_uid DBLookup Y 4 none target Y Y 0 migration user_mapping N N write_uid source = target write_uid_target Integer

285 195 Y N