Table: dbo.Payable_Payment_Application_Payable_Distribution
This table holds distributions for Payable_Payment_Application records.
Columns
Name | Type | Constraints | Description
payable_payment_application_payable_distribution_KEY | int (4) | NOT NULL | Primary Key.
payable_transaction_distribution_KEY | int (4) | NOT NULL | Foreign Key to the Payable_Transaction_Distribution this application is for.
distributed__paid_amount | decimal (9, 2) | NOT NULL | The amount applied by this distribution.
distributed__discount_taken_amount | decimal (9, 2) | NOT NULL | The amount of discount applied 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_Payable_Distribution | payable_payment_application_payable_distribution_KEY |
Unique constraints
Name | Columns | Description
UK_Payable_Payment_Application_Payable_Distribution$gl_transaction_KEY$payable_transaction_distribution_KEY | gl_transaction_KEY, payable_transaction_distribution_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Payable_Payment_Application_Payable_Distribution__Payable_Payment_Application__gl_transaction_KEY | gl_transaction_KEY | Payable_Payment_Application (gl_transaction_KEY) |
FK_Payable_Payment_Application_Payable_Distribution__Payable_Transaction_Distribution__payable_transaction_distribution_KEY | payable_transaction_distribution_KEY | Payable_Transaction_Distribution (payable_transaction_distribution_KEY) |