Table: dbo.Payable_Transaction_N_Shortfall_Transaction
This dictionary table associates a payable transaction with the shortfall transaction for which it was created.
Columns
Name | Type | Constraints | Description
payable_transaction_KEY | int (4) | NOT NULL | Primary key for the table and foreign key to Payable_Transaction table
shortfall_transaction_KEY | int (4) | NOT NULL | Foreign key to Shortfall_Transaction table

Primary key
Name | Columns | Description
PK_Payable_Transaction_N_Shortfall_Transaction$payable_transaction_KEY | payable_transaction_KEY |
Unique constraints
Name | Columns | Description
UK_Payable_Transaction_N_Shortfall_Transaction$shortfall_transaction_KEY | shortfall_transaction_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Payable_Transaction_N_Shortfall_Transaction__Payable_Transaction__payable_transaction_KEY | payable_transaction_KEY | Payable_Transaction (payable_transaction_KEY) |
FK_Payable_Transaction_N_Shortfall_Transaction__Shortfall_Transaction__shortfall_transaction_KEY | shortfall_transaction_KEY | Shortfall_Transaction (shortfall_transaction_KEY) |