This table will store the transaction distributions of transactions imported from QuickBooks. |
quick_books_transaction_distribution_KEY | int (4) | NOT NULL | Primary Key for this table. |
quick_books_transaction_KEY | int (4) | NOT NULL | Foreign key to the quickbooks transaction table, a table which stores the transaction keys of transactions imported from QuickBooks. |
amount | decimal (9, 2) | NOT NULL | The amount of a transaction distribution. |
gl_account_KEY | int (4) | NOT NULL | This is a foreign key to the GL Account table. The gl account of a transaction distribution. |