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
NameTypeConstraintsDescription
payable_transaction_n_receivable_transaction_KEYint (4)NOT NULLThe primary key.
payable_transaction_KEYint (4)NOT NULLForeign key to the payable.
receivable_transaction_KEYint (4)NOT NULLForeign key to the receivable.
Primary key
NameColumnsDescription
PK_Payable_Transaction_N_Receivable_Transactionpayable_transaction_n_receivable_transaction_KEY
Unique constraints
NameColumnsDescription
UK_Payable_Transaction_N_Receivable_Transaction$payable_transaction_KEYpayable_transaction_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Payable_Transaction_N_Receivable_Transaction__Payable_Transaction__payable_transaction_KEYpayable_transaction_KEYPayable_Transaction (payable_transaction_KEY)
FK_Payable_Transaction_N_Receivable_Transaction__Receivable_Transaction__receivable_transaction_KEYreceivable_transaction_KEYReceivable_Transaction (receivable_transaction_KEY)

Schema diagram