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 |