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 ...
    • 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 ...
    • Bulk Permit Renewal with Auto-Invoice Generation

      Purpose Statement: The bulk permit renewal feature allows administrators to efficiently renew multiple permits simultaneously while automatically generating and emailing invoices to permit contacts. This streamlined process reduces manual workload, ...