Table: dbo.AR_Payment_Application_Distribution
This table contains a payment application's distribution across the receivable's items. Cash basis accounting requires knowing how much of each item on a receivable was paid by a given payment application. To this end, a payment application must be proportionally distributed across the items of the receivable it is applied to. More precisely, since each item can affect multiple GL accounts, the payment amount is distributed across the GL accounts associated with the receivable items.
Columns
NameTypeConstraintsDescription
ar_payment_application_distribution_KEYint (4)NOT NULLThe primary key for this table.
payment_application__gl_transaction_KEYint (4)NOT NULLThis required foreign key identifies the payment application that is being distributed.
ar_transaction_item_gl_account_KEYint (4)NOT NULLThis required foreign key identifies the receivable item and GL account that this distributed portion of the payment is being applied to.
distributed__paid_amountdecimal (9, 2)NOT NULLThe portion of the payment application being applied to this receivable item.
distributed__discount_honored_amountdecimal (9, 2)NOT NULLIf the payment application included any discount honored, this is the portion of the overall discount honored amount being applied to this receivable item.
Primary key
NameColumnsDescription
PK_AR_Payment_Application_Distributionar_payment_application_distribution_KEY
Unique constraints
NameColumnsDescription
UK_AR_Payment_Application_Distribution$payment_application__gl_transaction_KEY$ar_transaction_item_gl_account_KEYpayment_application__gl_transaction_KEY, ar_transaction_item_gl_account_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_AR_Payment_Application_Distribution__AR_Payment_Application__payment_application__gl_transaction_KEYpayment_application__gl_transaction_KEYAR_Payment_Application (gl_transaction_KEY)
FK_AR_Payment_Application_Distribution__AR_Transaction_Item_GL_Account__ar_transaction_item_gl_account_KEYar_transaction_item_gl_account_KEYAR_Transaction_Item_GL_Account (ar_transaction_item_gl_account_KEY)

Schema diagram