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

    • Creating an Invoice

      Purpose To demonstrate how to create an invoice on the First Due Platform. Invoices can also be created from within an Inspection and from a Permit. See related Articles. Related Articles Create Invoice When Recording an Inspection Create Invoice ...
    • Using Advanced Search - Invoice Status Fields

      Purpose The purpose of this Knowledge Base Article is to demonstrate the use of Advanced Search to determine Money Status, Other Status, Emailed, and Mailed for Invoices. Video Instructions 1. Click on Invoicing. 2. Click on Invoice List. 3. Click on ...
    • 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 ...
    • Invoices - Recording Payments and Adjustments to Invoices

      Purpose The purpose of this Knowledge Base Article is to demonstrate how to manage Invoices: Record payments, write off, discount, send to collections, and make refunds. Related Article Online Payments Video Instructions 1. Click on Invoicing. 2. ...
    • Online Payment Setup

      Purpose The purpose of this Knowledge Base Article is to guide an agency admin through the setup process for online payments. Video Instructions 1. The First Due Implementation Team will send a link via email to the agency contact that will direct ...