Table: dbo.Payable_Payment_Application_Payment_Distribution
This table holds distributions for Payable_Payment_Application records.
Columns
NameTypeConstraintsDescription
payable_payment_application_payment_distribution_KEYint (4)NOT NULLPrimary Key.
bank_transaction_distribution_KEYint (4)Foreign Key to the Bank_Transaction_Distribution this application is for or NULL when payment is a Credit Memo.
payable_transaction_distribution_KEYint (4)Foreign Key to the Payable_Transaction_Distribution this application is for or NULL when payment is a bank transaction.
distributed__paid_amountdecimal (9, 2)NOT NULLThe amount of payment used by this distribution.
gl_transaction_KEYint (4)NOT NULLForeign Key to the Payable_Payment_Application we belong to.
Primary key
NameColumnsDescription
PK_Payable_Payment_Application_Payment_Distributionpayable_payment_application_payment_distribution_KEY
Unique constraints
NameColumnsDescription
UK_Payable_Payment_Application_Payment_Distribution$gl_transaction_KEY$bank_transaction_distribution_KEY$payable_transaction_disgl_transaction_KEY, bank_transaction_distribution_KEY, payable_transaction_distribution_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Payable_Payment_Application_Payment_Distribution__Bank_Transaction_Distribution__bank_transaction_distribution_KEYbank_transaction_distribution_KEYBank_Transaction_Distribution (bank_transaction_distribution_KEY)
FK_Payable_Payment_Application_Payment_Distribution__Payable_Payment_Application__gl_transaction_KEYgl_transaction_KEYPayable_Payment_Application (gl_transaction_KEY)
FK_Payable_Payment_Application_Payment_Distribution__Payable_Transaction_Distribution__payable_transaction_distribution_KEYpayable_transaction_distribution_KEYPayable_Transaction_Distribution (payable_transaction_distribution_KEY)

Schema diagram