Table: dbo.Payable_Transaction
Columns
Name | Type | Constraints | Description
payable_transaction_KEY | int (4) | NOT NULL | Primary key for this table
vendor_KEY | int (4) | NOT NULL | Reference to vendor
transaction_date | smalldatetime (4) | NOT NULL | Date transaction is/was processed
amount | decimal (9, 2) | NOT NULL | Amount of liability to be paid
description | nvarchar (240) | NOT NULL | Description of the payable transaction
bank_transaction_KEY | int (4) |  | Key of associated vendor check to indicate payment
due_date | smalldatetime (4) | NOT NULL | Due date of the payable transaction
tax_period_end_date | smalldatetime (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_date | smalldatetime (4) |  | Effective date of the transaction if edited by the user - null otherwise
funding_processed_status_KEY | int (4) | NOT NULL | Funding 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_KEY | int (4) |  | The GL account number pointed to by this foreign key is the payable account that offsets this payables liability details.
description_override | nvarchar (86) | NOT NULL | Field 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_KEY | int (4) | NOT NULL | The csa export status of the payable transaction.
payable_transaction_type_KEY | int (4) | NOT NULL | Foreign key to the payable transaction's type.
transaction_status_KEY | int (4) | NOT NULL |
origin__accounting_application_KEY | int (4) |  | The application that was running when the payable transaction was created.
reference_number | nvarchar (32) | NOT NULL | Either a reference or check number depending on transaction type.
purchase_order_number | nvarchar (32) | NOT NULL | Purchase order number for the transaction.
vendor__contact_address_type_KEY | int (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_KEY | int (4) |  | FK to the payment term table.
discount_expiration_date | smalldatetime (4) |  | Expiration date for the discount.
not_eligible_for_discount_allowed_amount | decimal (9, 2) | NOT NULL | An amount of money that is not eligible to have a discount applied to it.
discount_allowed_amount | decimal (9, 2) | NOT NULL | amount of discount applied.
memo | nvarchar (480) | NOT NULL | A Memo.
ap_discount_method_KEY | int (4) | NOT NULL | FK to the AP Discount Method table.
is_discount_forced | bit (1) | NOT NULL | Allows the discount_allowed_amount to be used after the discount_expiration_date.
reference_number_sortable | nvarchar (160) | NOT NULL | Sortable reference number.
purchase_order_number_sortable | nvarchar (160) | NOT NULL | Sortable purchase order number.
client_tax_item_KEY | int (4) |  | Key to client tax item for manual liabilities and forms adjustment payments
created_date | datetime (8, 3) |  | The date the payable transaction was created.
created__staff_KEY | int (4) |  | The staff that created the payable transaction.
vendor_amortization_schedule_entry_KEY | int (4) |  | Foreign key to Vendor_Amortization_Schedule_Entry - optional when transaction is not associated with an amortization payment.
payable_transaction_guid | uniqueidentifier (16) | NOT NULL | A unique identifer for each payable transaction row.
exported_to_quick_books | bit (1) | NOT NULL | This flag should be true if the transaction has been exported to quickbooks. It should be false otherwise.
generated_by__transaction_template_KEY | int (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_KEY | int (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_KEY | int (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_KEY | tinyint (1) | NOT NULL | Foreign Key into the Tax_Deferral_Reason table

Primary key
Name | Columns | Description
PK_Payable_Transaction | payable_transaction_KEY |
Unique constraints
Name | Columns | Description
UK_Payable_Transaction$payable_transaction_guid | payable_transaction_guid |

Foreign keys
Name | Columns | Referenced table | Description
FK_Payable_Transaction__Tax_Deferral_Reason__tax_deferral_reason_KEY | tax_deferral_reason_KEY | Tax_Deferral_Reason (tax_deferral_reason_KEY) |
FK_Payable_Transaction__Accounting_Application__origin__accounting_application_KEY | origin__accounting_application_KEY | Accounting_Application (accounting_application_KEY) |
FK_Payable_Transaction__AP_Discount_Method__ap_discount_method_KEY | ap_discount_method_KEY | AP_Discount_Method (ap_discount_method_KEY) |
FK_Payable_Transaction__Client_Tax_Item__client_tax_item_KEY | client_tax_item_KEY | Client_Tax_Item (client_tax_item_KEY) |
FK_Payable_Transaction__Contact_Address_Type__vendor__contact_address_type_KEY | vendor__contact_address_type_KEY | Contact_Address_Type (contact_address_type_KEY) |
FK_Payable_Transaction__Export_Journal_Entry_To_Csa_Status__export_journal_entry_to_csa_status_KEY | export_journal_entry_to_csa_status_KEY | Export_Journal_Entry_To_Csa_Status (export_journal_entry_to_csa_status_KEY) |
FK_Payable_Transaction__File_Storage__file_storage_KEY | file_storage_KEY | File_Storage (file_storage_KEY) |
FK_Payable_Transaction__Funding_Processed_Status__funding_processed_status_KEY | funding_processed_status_KEY | Funding_Processed_Status (funding_processed_status_KEY) |
FK_Payable_Transaction__GL_Account__ap_discount__gl_account_KEY | ap_discount__gl_account_KEY | GL_Account (gl_account_KEY) |
FK_Payable_Transaction__GL_Account__payable__gl_account_KEY | payable__gl_account_KEY | GL_Account (gl_account_KEY) |
FK_Payable_Transaction__Payable_Transaction_Template__generated_by__transaction_template_KEY | generated_by__transaction_template_KEY | Payable_Transaction_Template (transaction_template_KEY) |
FK_Payable_Transaction__Payable_Transaction_Type__payable_transaction_type_KEY | payable_transaction_type_KEY | Payable_Transaction_Type (payable_transaction_type_KEY) |
FK_Payable_Transaction__Payment_Term__payment_term_KEY | payment_term_KEY | Payment_Term (payment_term_KEY) |
FK_Payable_Transaction__Staff__created__staff_KEY | created__staff_KEY | Staff (staff_KEY) |
FK_Payable_Transaction__Transaction_Status__transaction_status_KEY | transaction_status_KEY | Transaction_Status (transaction_status_KEY) |
FK_Payable_Transaction__Vendor__vendor_KEY | vendor_KEY | Vendor (vendor_KEY) |
FK_Payable_Transaction__Vendor_Amortization_Schedule_Entry__vendor_amortization_schedule_entry_KEY | vendor_amortization_schedule_entry_KEY | Vendor_Amortization_Schedule_Entry (vendor_amortization_schedule_entry_KEY) |
FK_Payable_Transaction__Vendor_Bank_Transaction__bank_transaction_KEY | bank_transaction_KEY | Vendor_Bank_Transaction (bank_transaction_KEY) |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Payable_Transaction_Distribution__Payable_Transaction__payable_transaction_KEY | payable_transaction_KEY | Payable_Transaction_Distribution |
FK_Print_Payable_Transaction_Selection__Payable_Transaction__payable_transaction_KEY | payable_transaction_KEY | Print_Payable_Transaction_Selection |
FK_Payable_Transaction_N_Receivable_Transaction__Payable_Transaction__payable_transaction_KEY | payable_transaction_KEY | Payable_Transaction_N_Receivable_Transaction |
FK_Funding_Withdrawal_Liability_Detail__Payable_Transaction__detail__payable_transaction_KEY | detail__payable_transaction_KEY | Funding_Withdrawal_Liability_Detail |
FK_GL_Transaction_N_Payable_Transaction__Payable_Transaction__payable_transaction_KEY | payable_transaction_KEY | GL_Transaction_N_Payable_Transaction |
FK_Pending_AP_Payment_Application__Payable_Transaction__payable_transaction_KEY | payable_transaction_KEY | Pending_AP_Payment_Application |
FK_Vendor_AP_Beginning_Balance__Payable_Transaction__payable_transaction_KEY | payable_transaction_KEY | Vendor_AP_Beginning_Balance |
FK_Payable_Transaction_N_Shortfall_Transaction__Payable_Transaction__payable_transaction_KEY | payable_transaction_KEY | Payable_Transaction_N_Shortfall_Transaction |
FK_Payable_Payment_Application__Payable_Transaction__payable_transaction_KEY | payable_transaction_KEY | Payable_Payment_Application |
FK_Payable_Transaction_N_Elf_File__Payable_Transaction__payable_transaction_KEY | payable_transaction_KEY | Payable_Transaction_N_Elf_File |
FK_Payable_Transaction_N_Magnetic_Media_File_Client__Payable_Transaction__payable_transaction_KEY | payable_transaction_KEY | Payable_Transaction_N_Magnetic_Media_File_Client |
FK_Print_Check_Selection__Payable_Transaction__source__payable_transaction_KEY | source__payable_transaction_KEY | Print_Check_Selection |
FK_Payable_Transaction_N_Ach_Entry_Detail_Record__Payable_Transaction__payable_transaction_KEY | payable_transaction_KEY | Payable_Transaction_N_Ach_Entry_Detail_Record |
FK_Payable_Transaction_N_Payroll_Check_Payroll_Item__Payable_Transaction__payable_transaction_KEY | payable_transaction_KEY | Payable_Transaction_N_Payroll_Check_Payroll_Item |
FK_Payable_Transaction_N_Payroll_Check_Tax_Item__Payable_Transaction__payable_transaction_KEY | payable_transaction_KEY | Payable_Transaction_N_Payroll_Check_Tax_Item |
FK_Payable_Transaction_N_Payroll_Bank_Transaction_Worker_Compensation_Item__Payable_Transaction__payable_transaction_KEY | payable_transaction_KEY | Payable_Transaction_N_Payroll_Bank_Transaction_Worker_Compensation_Item |