Table: dbo.Pending_AP_Payment
This table holds pending payments. A pending payment can be paired with an existing payable, so that the payable can be paid. What this means here is that the pending payment would be turned into a real payment, and then applied against a payable.
Columns
NameTypeConstraintsDescription
pending_ap_payment_KEYint (4)NOT NULLPrimary Key for this table.
ap_payment_type_KEYint (4)NOT NULLThe AP payment type.
checkbook_KEYint (4)NOT NULLThis ties us to a client bank account for the payment.
transaction_datedatetime (8, 3)The date of the pending payment.
journal_KEYint (4)NOT NULLThe journal of the pending payment.
gl_period_KEYint (4)NOT NULLThe gl period to adjust key of the pending payment.
is_handwritten_checkbit (1)NOT NULLTrue if this pending payment is for a handwritten check. False otherwise.
reference_numbernvarchar (32)NOT NULLThe reference number of the pending payment.
vendor__contact_address_type_KEYint (4)Determines the appropriate vendor address to use on the check that will be created when the pending payment is printed. The address type comes from the payable being paid. If the pending payment applies to more than one payable with differing address types, then the user is asked to pick a type and that is stored here
is_transaction_date_overridebit (1)NOT NULLThis value lets us know that the user has chosen to set the transaction date of a pending payment themselves through the User Interface. There are two ways to set the transaction date in Manage AP Payments when creating a pending AP payment. The first is to programmatically set the date to a value. The second is for the user to set the transaction date themselves via the user interface. We need to know if the user has overwritten the system transaction date so that we do not continue to try to reset it. For example, in Manage AP Payments, there is an option to use the oldest due date of a group of payable transactions as the payment date. If the user has set the payment date themselves, and then adds additional payables to the group, we need to know that we do not want the system to update the payment date. Once it is set by the user, it should not be set by the system. This field will be false if the user has not overridden the system calculated date.
is_posting_period_overriddenbit (1)NOT NULLIf this is true, the use_transaction_date_to_default_posting_period flag in Client_GL_Setup is ignored when deciding if the posting period needs to be updated to match the transaction date.
Primary key
NameColumnsDescription
PK_Pending_AP_Paymentpending_ap_payment_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Pending_AP_Payment__AP_Payment_Type__ap_payment_type_KEYap_payment_type_KEYAP_Payment_Type (ap_payment_type_KEY)
FK_Pending_AP_Payment__Checkbook__checkbook_KEYcheckbook_KEYCheckbook (checkbook_KEY)
FK_Pending_AP_Payment__Contact_Address_Type__vendor__contact_address_type_KEYvendor__contact_address_type_KEYContact_Address_Type (contact_address_type_KEY)
FK_Pending_AP_Payment__GL_Period__gl_period_KEYgl_period_KEYGL_Period (gl_period_KEY)
FK_Pending_AP_Payment__Journal__journal_KEYjournal_KEYJournal (journal_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Pending_AP_Payment_Application__Pending_AP_Payment__pending_ap_payment_KEYpending_ap_payment_KEYPending_AP_Payment_Application
FK_Print_Check_Selection__Pending_AP_Payment__source__pending_ap_payment_KEYsource__pending_ap_payment_KEYPrint_Check_Selection

Schema diagram