Table: dbo.Payable_Transaction_N_Receivable_Transaction
This dictionary table links related payables and receivables. The payables and receivables don not necessaryily have to belong to the same client. For example, in SBPR, the fees and billing cycle will generate receivables for the firm and related payables for the client which are linked together via an entry in this table.
Columns
Name | Type | Constraints | Description
payable_transaction_n_receivable_transaction_KEY | int (4) | NOT NULL | The primary key.
payable_transaction_KEY | int (4) | NOT NULL | Foreign key to the payable.
receivable_transaction_KEY | int (4) | NOT NULL | Foreign key to the receivable.

Primary key
Name | Columns | Description
PK_Payable_Transaction_N_Receivable_Transaction | payable_transaction_n_receivable_transaction_KEY |
Unique constraints
Name | Columns | Description
UK_Payable_Transaction_N_Receivable_Transaction$payable_transaction_KEY | payable_transaction_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Payable_Transaction_N_Receivable_Transaction__Payable_Transaction__payable_transaction_KEY | payable_transaction_KEY | Payable_Transaction (payable_transaction_KEY) |
FK_Payable_Transaction_N_Receivable_Transaction__Receivable_Transaction__receivable_transaction_KEY | receivable_transaction_KEY | Receivable_Transaction (receivable_transaction_KEY) |