v_invoice_payment

v_invoice_payment

Purpose

  1. Invoice payment records.

Relationships

  • v_invoice: Many-to-One (N:1)

    • Many payments link to one invoice

    • Referenced through invoice relationship


Table



Column

Type

Description

id

integer

Primary key

client_code

varchar(28)

Organization ID

check_number

varchar(30)

Check number

note

varchar(255)

Payment note

payment_applied_code

varchar(10)

Applied code

applied_at

date

Application date

amount

numeric(20,2)

Payment amount

payment_type_code

integer

Payment type





    • Related Articles

    • v_invoice

      Purpose Invoice records. Relationships v_invoice_line_item: One-to-Many (1:N) One invoice can have many line items Referenced through invoice_id v_invoice_payment: One-to-Many (1:N) One invoice can have many payments Referenced through invoice_id ...

    • E-Payment Refunds

      Purpose Statement The E-Payment Refunds feature enables fire departments and EMS agencies to process refunds for invoice payments made through electronic payment methods. This functionality provides administrators with flexible options to handle ...

    • Voiding an Invoice

      Purpose Statement The Invoice Void feature allows agencies to cancel invoices that have been issued but need to be nullified due to errors, cancellations, or other administrative needs. This feature provides a clear audit trail by marking invoices as ...

    • Using Advanced Search - Invoice Status Fields

      Purpose Statement The Advanced Search feature for Invoice Status Fields enables users to efficiently filter and locate invoices based on their financial status, processing status, delivery methods, etc. This functionality streamlines invoice ...

    • Creating an Invoice

      Purpose Statement To demonstrate how to create invoices on the First Due Platform for billing services, permits, inspections, and other departmental activities. This feature enables Fire/EMS departments to efficiently generate professional invoices ...