| 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 | ||