Table: dbo.Payable_Payment_Application
This table holds records that are Applications of Payments to Payables.
Columns
NameTypeConstraintsDescription
payable_transaction_KEYint (4)NOT NULLForeign key of related payable.
payment__gl_transaction_KEYint (4)NOT NULLForeign key of gl transaction belonging to related payment.
application_datesmalldatetime (4)NOT NULLThe date (date only) the payment was applied.
gl_transaction_KEYint (4)NOT NULLPrimary Key.
discount_taken_amountdecimal (9, 2)NOT NULLThe amount of discount taken for the Payable Payment Application.
payment__reference_numbernvarchar (32)NOT NULLThe reference number of the payment.
descriptionnvarchar (240)NOT NULLThe description of the bank or payable transaction.
origin__accounting_application_KEYint (4)The application that was running when the bank or payable transaction was created.
data_origin_KEYint (4)The origin of each bank transaction. For example, Data Entry or CSA Conversion.
Primary key
NameColumnsDescription
PK_Payable_Payment_Application$gl_transaction_KEYgl_transaction_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Payable_Payment_Application$origin__accounting_application_KEYorigin__accounting_application_KEYAccounting_Application (accounting_application_KEY)
FK_Payable_Payment_Application$data_origin_KEYdata_origin_KEYData_Origin (data_origin_KEY)
FK_Payable_Payment_Application__GL_Transaction__gl_transaction_KEYgl_transaction_KEYGL_Transaction (gl_transaction_KEY)
FK_Payable_Payment_Application__GL_Transaction__payment__gl_transaction_KEYpayment__gl_transaction_KEYGL_Transaction (gl_transaction_KEY)
FK_Payable_Payment_Application__Payable_Transaction__payable_transaction_KEYpayable_transaction_KEYPayable_Transaction (payable_transaction_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Payable_Payment_Application_Payable_Distribution__Payable_Payment_Application__gl_transaction_KEYgl_transaction_KEYPayable_Payment_Application_Payable_Distribution
FK_Payable_Payment_Application_Payment_Distribution__Payable_Payment_Application__gl_transaction_KEYgl_transaction_KEYPayable_Payment_Application_Payment_Distribution

Schema diagram