diff options
| author | Jesse Luehrs <doy@tozt.net> | 2019-08-26 02:03:41 -0400 |
|---|---|---|
| committer | Jesse Luehrs <doy@tozt.net> | 2019-08-26 02:03:41 -0400 |
| commit | 1d4938471e40586717e6a70a081c8d535f957cae (patch) | |
| tree | 94e282c24092f8e957a57369cf8991518f03d3d0 | |
| parent | 19b020f9917bb154a88cc797ebaefe1c822a883a (diff) | |
| download | ynab-export-1d4938471e40586717e6a70a081c8d535f957cae.tar.gz ynab-export-1d4938471e40586717e6a70a081c8d535f957cae.zip | |
fix
| -rw-r--r-- | data/schema.sql | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/data/schema.sql b/data/schema.sql index 6478769..7424254 100644 --- a/data/schema.sql +++ b/data/schema.sql @@ -169,7 +169,7 @@ CREATE VIEW denorm_transactions AS ( payees.name AS payee, category_group_id, category_groups.name AS category_group, - category_id + category_id, categories.name AS category, transfer_account_id, transfer_accounts.name AS transfer_account @@ -223,7 +223,7 @@ CREATE VIEW denorm_scheduled_transactions AS ( category_groups.name AS category_group, category_id, categories.name AS category, - transfer_account_id, + scheduled_transactions_with_subtransactions.transfer_account_id, transfer_accounts.name AS transfer_account FROM scheduled_transactions_with_subtransactions LEFT JOIN accounts ON ( |