| 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 | ||