v_invoice_line_item

v_invoice_line_item

Purpose

  1. Invoice line items details.

Relationships

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

    • Many line items link to one invoice

    • Referenced through invoice_id


Table



Column

Type

Description

invoice_id

integer

Invoice reference

client_code

varchar(28)

Organization ID

address

text

Service address

invoice_number

varchar(30)

Invoice number

reference_id

varchar(30)

Reference ID

invoice_created_at

timestamp

Creation time

invoice_category_name

varchar(255)

Category name

billing_code

varchar(30)

Billing code

gl_code

varchar(40)

GL code

category_type_name

varchar(255)

Type name

line_item

varchar(255)

Item description

fee_schedule_unit_code

varchar(10)

Unit code

price

numeric(11,4)

Unit price

amount

numeric

Total amount

quantity

numeric

Quantity

service_date

date

Service date

note

varchar(255)

Line item note

is_late_fee

boolean

Late fee flag




    • Related Articles

    • Invoicing - Create Line Item

      Purpose Statement This feature allows administrators to create customizable line items for invoicing within the Fire/EMS software platform. Line items serve as the foundation for billing services, equipment usage, training sessions, and other ...

    • Portal Permit Formula Line Item

      Purpose Statement The Portal Permit Formula Line Item feature enables fire departments and EMS agencies to automatically calculate permit fees based on custom data fields entered by applicants through the Community Connect Portal and Business Portal. ...

    • 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 ...

    • 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 ...

    • Create Invoice When Recording an Inspection

      Purpose Statement To enable inspectors to generate invoices directly within inspection records, streamlining the billing process and ensuring accurate linkage between inspection activities and associated fees. This feature eliminates the need for ...