Table: dbo.Payable_Payment_Application_Payable_Distribution
This table holds distributions for Payable_Payment_Application records.
Columns
NameTypeConstraintsDescription
payable_payment_application_payable_distribution_KEYint (4)NOT NULLPrimary Key.
payable_transaction_distribution_KEYint (4)NOT NULLForeign Key to the Payable_Transaction_Distribution this application is for.
distributed__paid_amountdecimal (9, 2)NOT NULLThe amount applied by this distribution.
distributed__discount_taken_amountdecimal (9, 2)NOT NULLThe amount of discount applied 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_Payable_Distributionpayable_payment_application_payable_distribution_KEY
Unique constraints
NameColumnsDescription
UK_Payable_Payment_Application_Payable_Distribution$gl_transaction_KEY$payable_transaction_distribution_KEYgl_transaction_KEY, payable_transaction_distribution_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Payable_Payment_Application_Payable_Distribution__Payable_Payment_Application__gl_transaction_KEYgl_transaction_KEYPayable_Payment_Application (gl_transaction_KEY)
FK_Payable_Payment_Application_Payable_Distribution__Payable_Transaction_Distribution__payable_transaction_distribution_KEYpayable_transaction_distribution_KEYPayable_Transaction_Distribution (payable_transaction_distribution_KEY)

Schema diagram