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

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

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

    • Create Invoice When Recording an Inspection

      Purpose To demonstrate how to create an Invoice while a user is recording the results of an Inspection. Video Instructions 1. Click on Inspections. Note: These next few steps will review the setting necessary to allow a user to generate an Invoice ...

    • Invoicing - Create Line Item

      Purpose To demonstrate how to create a Line Item for Invoicing. Related Articles Automated Invoicing - Formula Automated Invoicing - Flat Fee Video Instructions 1. Click on Invoicing. 2. Click on Fee Schedule. 3. Click on Create Line Item. 4. Select ...

    • v_invoice_payment

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