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 |