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 |