Please enable JavaScript.
Coggle requires JavaScript to display documents.
ETL - ER (Keboola (Transform (export_invoices (create table xe_contact…
ETL - ER
Keboola
Transform
Set Organisation ID
Update Invoices currency rate
Update credit note currency rate
export_invoices
Create staging_invoices table
Union
Invoices
Invoices
Invoices_LineItems
Accounts
Credit Notes
CreditNotes_LineItems
Accounts
CreditNotes
Journals
Journals
JournalLines
Accounts
delete rows which exists in staging_invoices table
insert from staging_invoices table
create table export_first_invoice_dates
export_invoices
create table xe_contact_invoices
xe_contact_invoices
Contacts
xero_accounts_mapping
Create table xe_invoice_dates
export_invoices
create table xe_invoice_dates_accounts
xero_accounts_mapping
xe_invoice_dates