Table: dbo.Payable_Transaction
Columns
NameTypeConstraintsDescription
payable_transaction_KEYint (4)NOT NULLPrimary key for this table
vendor_KEYint (4)NOT NULLReference to vendor
transaction_datesmalldatetime (4)NOT NULLDate transaction is/was processed
amountdecimal (9, 2)NOT NULLAmount of liability to be paid
descriptionnvarchar (240)NOT NULLDescription of the payable transaction
bank_transaction_KEYint (4)Key of associated vendor check to indicate payment
due_datesmalldatetime (4)NOT NULLDue date of the payable transaction
tax_period_end_datesmalldatetime (4)Tax period end date for this liability if liability is for a vendor tax agent or null if liability is not for a vendor tax agent
edited_ach_effective_datesmalldatetime (4)Effective date of the transaction if edited by the user - null otherwise
funding_processed_status_KEYint (4)NOT NULLFunding electronic processing status values: 0 - tx has not been processed, 1 - tx has been funded but not processed, 2 - tx has been processed, 3 - do not ever process this tx.
payable__gl_account_KEYint (4)The GL account number pointed to by this foreign key is the payable account that offsets this payables liability details.
description_overridenvarchar (86)NOT NULLField used for defining descriptions of tax items, payroll items as well as fee and billing items that will be used by the report engine. Employee and employer types will have the same description.
export_journal_entry_to_csa_status_KEYint (4)NOT NULLThe csa export status of the payable transaction.
payable_transaction_type_KEYint (4)NOT NULLForeign key to the payable transaction's type.
transaction_status_KEYint (4)NOT NULL
origin__accounting_application_KEYint (4)The application that was running when the payable transaction was created.
reference_numbernvarchar (32)NOT NULLEither a reference or check number depending on transaction type.
purchase_order_numbernvarchar (32)NOT NULLPurchase order number for the transaction.
vendor__contact_address_type_KEYint (4)The contact address type for the vendor. A vendor can have multiple contact addresses and this specifies which type of address to use. It is acceptable if the vendor specified by the vendor_KEY in this table does not have a contact address for the specified type. If no associated contact address is found for the specified type, then this value can be treated as if it were null. A null value for this key indicates that there is no contact address that will be associated with this payable transaction.
payment_term_KEYint (4)FK to the payment term table.
discount_expiration_datesmalldatetime (4)Expiration date for the discount.
not_eligible_for_discount_allowed_amountdecimal (9, 2)NOT NULLAn amount of money that is not eligible to have a discount applied to it.
discount_allowed_amountdecimal (9, 2)NOT NULLamount of discount applied.
memonvarchar (480)NOT NULLA Memo.
ap_discount_method_KEYint (4)NOT NULLFK to the AP Discount Method table.
is_discount_forcedbit (1)NOT NULLAllows the discount_allowed_amount to be used after the discount_expiration_date.
reference_number_sortablenvarchar (160)NOT NULLSortable reference number.
purchase_order_number_sortablenvarchar (160)NOT NULLSortable purchase order number.
client_tax_item_KEYint (4)Key to client tax item for manual liabilities and forms adjustment payments
created_datedatetime (8, 3)The date the payable transaction was created.
created__staff_KEYint (4)The staff that created the payable transaction.
vendor_amortization_schedule_entry_KEYint (4)Foreign key to Vendor_Amortization_Schedule_Entry - optional when transaction is not associated with an amortization payment.
payable_transaction_guiduniqueidentifier (16)NOT NULLA unique identifer for each payable transaction row.
exported_to_quick_booksbit (1)NOT NULLThis flag should be true if the transaction has been exported to quickbooks. It should be false otherwise.
generated_by__transaction_template_KEYint (4)A key linking the payable transaction back to its originating template. This link is necessary because the template generation schedule can be based on amount or number of transactions generated. This link will allow the scheduler to keep track of any changes that might require reconfiguring the schedule, such as a generated transaction being deleted.
file_storage_KEYint (4)A key for attaching a payable file to the transaction. A null key means that no file is attached to the transaction.
ap_discount__gl_account_KEYint (4)Foreign key to the gl account table that tells us which gl account to use for the discount amount. This will be null if there is no discount allowed for the payable.
tax_deferral_reason_KEYtinyint (1)NOT NULLForeign Key into the Tax_Deferral_Reason table
Primary key
NameColumnsDescription
PK_Payable_Transactionpayable_transaction_KEY
Unique constraints
NameColumnsDescription
UK_Payable_Transaction$payable_transaction_guidpayable_transaction_guid
Foreign keys
NameColumnsReferenced tableDescription
FK_Payable_Transaction__Tax_Deferral_Reason__tax_deferral_reason_KEYtax_deferral_reason_KEYTax_Deferral_Reason (tax_deferral_reason_KEY)
FK_Payable_Transaction__Accounting_Application__origin__accounting_application_KEYorigin__accounting_application_KEYAccounting_Application (accounting_application_KEY)
FK_Payable_Transaction__AP_Discount_Method__ap_discount_method_KEYap_discount_method_KEYAP_Discount_Method (ap_discount_method_KEY)
FK_Payable_Transaction__Client_Tax_Item__client_tax_item_KEYclient_tax_item_KEYClient_Tax_Item (client_tax_item_KEY)
FK_Payable_Transaction__Contact_Address_Type__vendor__contact_address_type_KEYvendor__contact_address_type_KEYContact_Address_Type (contact_address_type_KEY)
FK_Payable_Transaction__Export_Journal_Entry_To_Csa_Status__export_journal_entry_to_csa_status_KEYexport_journal_entry_to_csa_status_KEYExport_Journal_Entry_To_Csa_Status (export_journal_entry_to_csa_status_KEY)
FK_Payable_Transaction__File_Storage__file_storage_KEYfile_storage_KEYFile_Storage (file_storage_KEY)
FK_Payable_Transaction__Funding_Processed_Status__funding_processed_status_KEYfunding_processed_status_KEYFunding_Processed_Status (funding_processed_status_KEY)
FK_Payable_Transaction__GL_Account__ap_discount__gl_account_KEYap_discount__gl_account_KEYGL_Account (gl_account_KEY)
FK_Payable_Transaction__GL_Account__payable__gl_account_KEYpayable__gl_account_KEYGL_Account (gl_account_KEY)
FK_Payable_Transaction__Payable_Transaction_Template__generated_by__transaction_template_KEYgenerated_by__transaction_template_KEYPayable_Transaction_Template (transaction_template_KEY)
FK_Payable_Transaction__Payable_Transaction_Type__payable_transaction_type_KEYpayable_transaction_type_KEYPayable_Transaction_Type (payable_transaction_type_KEY)
FK_Payable_Transaction__Payment_Term__payment_term_KEYpayment_term_KEYPayment_Term (payment_term_KEY)
FK_Payable_Transaction__Staff__created__staff_KEYcreated__staff_KEYStaff (staff_KEY)
FK_Payable_Transaction__Transaction_Status__transaction_status_KEYtransaction_status_KEYTransaction_Status (transaction_status_KEY)
FK_Payable_Transaction__Vendor__vendor_KEYvendor_KEYVendor (vendor_KEY)
FK_Payable_Transaction__Vendor_Amortization_Schedule_Entry__vendor_amortization_schedule_entry_KEYvendor_amortization_schedule_entry_KEYVendor_Amortization_Schedule_Entry (vendor_amortization_schedule_entry_KEY)
FK_Payable_Transaction__Vendor_Bank_Transaction__bank_transaction_KEYbank_transaction_KEYVendor_Bank_Transaction (bank_transaction_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Payable_Transaction_Distribution__Payable_Transaction__payable_transaction_KEYpayable_transaction_KEYPayable_Transaction_Distribution
FK_Payable_Transaction_N_Receivable_Transaction__Payable_Transaction__payable_transaction_KEYpayable_transaction_KEYPayable_Transaction_N_Receivable_Transaction
FK_Print_Payable_Transaction_Selection__Payable_Transaction__payable_transaction_KEYpayable_transaction_KEYPrint_Payable_Transaction_Selection
FK_Funding_Withdrawal_Liability_Detail__Payable_Transaction__detail__payable_transaction_KEYdetail__payable_transaction_KEYFunding_Withdrawal_Liability_Detail
FK_GL_Transaction_N_Payable_Transaction__Payable_Transaction__payable_transaction_KEYpayable_transaction_KEYGL_Transaction_N_Payable_Transaction
FK_Pending_AP_Payment_Application__Payable_Transaction__payable_transaction_KEYpayable_transaction_KEYPending_AP_Payment_Application
FK_Vendor_AP_Beginning_Balance__Payable_Transaction__payable_transaction_KEYpayable_transaction_KEYVendor_AP_Beginning_Balance
FK_Payable_Transaction_N_Shortfall_Transaction__Payable_Transaction__payable_transaction_KEYpayable_transaction_KEYPayable_Transaction_N_Shortfall_Transaction
FK_Payable_Payment_Application__Payable_Transaction__payable_transaction_KEYpayable_transaction_KEYPayable_Payment_Application
FK_Payable_Transaction_N_Elf_File__Payable_Transaction__payable_transaction_KEYpayable_transaction_KEYPayable_Transaction_N_Elf_File
FK_Payable_Transaction_N_Magnetic_Media_File_Client__Payable_Transaction__payable_transaction_KEYpayable_transaction_KEYPayable_Transaction_N_Magnetic_Media_File_Client
FK_Print_Check_Selection__Payable_Transaction__source__payable_transaction_KEYsource__payable_transaction_KEYPrint_Check_Selection
FK_Payable_Transaction_N_Ach_Entry_Detail_Record__Payable_Transaction__payable_transaction_KEYpayable_transaction_KEYPayable_Transaction_N_Ach_Entry_Detail_Record
FK_Payable_Transaction_N_Payroll_Check_Payroll_Item__Payable_Transaction__payable_transaction_KEYpayable_transaction_KEYPayable_Transaction_N_Payroll_Check_Payroll_Item
FK_Payable_Transaction_N_Payroll_Check_Tax_Item__Payable_Transaction__payable_transaction_KEYpayable_transaction_KEYPayable_Transaction_N_Payroll_Check_Tax_Item
FK_Payable_Transaction_N_Payroll_Bank_Transaction_Worker_Compensation_Item__Payable_Transaction__payable_transaction_KEYpayable_transaction_KEYPayable_Transaction_N_Payroll_Bank_Transaction_Worker_Compensation_Item

Schema diagram