Table: dbo.Payable_Transaction_N_Magnetic_Media_File_Client
Maps the payable transaction to the magnetic media file client that paid it.
Columns
Name | Type | Constraints | Description
payable_transaction_KEY | int (4) | NOT NULL | Foreign key to the payable transaction that is being paid by the associated magnetic media file client.
magnetic_media_file_client_KEY | int (4) | NOT NULL | Foreign key to the magnetic media file client that is paying the associated liability.

Primary key
Name | Columns | Description
PK_Payable_Transaction_N_Magnetic_Media_File_Client$payable_transaction_KEY | payable_transaction_KEY |
Unique constraints
Name | Columns | Description
UK_Payable_Transaction_N_Magnetic_Media_File_Client$payable_transaction_KEY$magnetic_media_file_client_KEY | payable_transaction_KEY, magnetic_media_file_client_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Payable_Transaction_N_Magnetic_Media_File_Client__Magnetic_Media_File_Client__magnetic_media_file_client_KEY | magnetic_media_file_client_KEY | Magnetic_Media_File_Client (magnetic_media_file_client_KEY) |
FK_Payable_Transaction_N_Magnetic_Media_File_Client__Payable_Transaction__payable_transaction_KEY | payable_transaction_KEY | Payable_Transaction (payable_transaction_KEY) |