Table: dbo.Payable_Payment_Application_Payment_Distribution
This table holds distributions for Payable_Payment_Application records.
Columns
Name | Type | Constraints | Description
payable_payment_application_payment_distribution_KEY | int (4) | NOT NULL | Primary Key.
bank_transaction_distribution_KEY | int (4) |  | Foreign Key to the Bank_Transaction_Distribution this application is for or NULL when payment is a Credit Memo.
payable_transaction_distribution_KEY | int (4) |  | Foreign Key to the Payable_Transaction_Distribution this application is for or NULL when payment is a bank transaction.
distributed__paid_amount | decimal (9, 2) | NOT NULL | The amount of payment used by this distribution.
gl_transaction_KEY | int (4) | NOT NULL | Foreign Key to the Payable_Payment_Application we belong to.

Primary key
Name | Columns | Description
PK_Payable_Payment_Application_Payment_Distribution | payable_payment_application_payment_distribution_KEY |
Unique constraints
Name | Columns | Description
UK_Payable_Payment_Application_Payment_Distribution$gl_transaction_KEY$bank_transaction_distribution_KEY$payable_transaction_dis | gl_transaction_KEY, bank_transaction_distribution_KEY, payable_transaction_distribution_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Payable_Payment_Application_Payment_Distribution__Bank_Transaction_Distribution__bank_transaction_distribution_KEY | bank_transaction_distribution_KEY | Bank_Transaction_Distribution (bank_transaction_distribution_KEY) |
FK_Payable_Payment_Application_Payment_Distribution__Payable_Payment_Application__gl_transaction_KEY | gl_transaction_KEY | Payable_Payment_Application (gl_transaction_KEY) |
FK_Payable_Payment_Application_Payment_Distribution__Payable_Transaction_Distribution__payable_transaction_distribution_KEY | payable_transaction_distribution_KEY | Payable_Transaction_Distribution (payable_transaction_distribution_KEY) |