Invoices table

Column Type

Id

String

Url

URI

Exchange_Rate

Decimal

Contact_Id

String

Contact

URI

Total_Value

Decimal

Omit_Header

Boolean

Updated_At

Timestamp

Dated_On

String

Currency

String

Due_On

String

Refunded_Value

String

Contact_Name

String

Is_Interim_Uk_Vat

Boolean

Reference

String

Net_Value

Decimal

Involves_Sales_Tax

Boolean

Payment_Terms_In_Days

Integer

Due_Value

Decimal

Status

String

Long_Status

String

Created_At

Timestamp

Bank_Account_Id

String

Bank_Account

String

Paid_Value

Decimal

Always_Show_Bic_And_Iban

Boolean

Paid_On

String

Payment_Methods_Paypal

Boolean

Payment_Methods_Stripe

Boolean

Send_Reminder_Emails

Boolean

Send_New_Invoice_Emails

Boolean

Send_Thank_You_Emails

Boolean

Sales_Tax_Value

Decimal

Second_Sales_Tax_Value

Decimal

Client_Contact_Name

String

Project

URI

Po_Reference

String

Discount_Percent

Decimal

Discount_Value

Decimal

Comments

String

Show_Project_Name

Boolean

Written_Off_Date

String

Include_Timeslips

String

Include_Expenses

String

Include_Estimates

String

Recurring_Invoice

String

Invoice_Items

Array

Payment_Methods

Object

Examples

INSERT INTO
    Invoices (
        Contact,
        Dated_On,
        Due_On,
        Currency,
        Exchange_Rate,
        Payment_Terms_In_Days,
        Net_Value,
        Invoice_Items
    )
VALUES
    (
        'https://api.freeagent.com/v2/contacts/18494140',
        '2024-11-27',
        '2024-11-27',
        'USD',
        '0.7263561',
        '30',
        '7649.88',
        '[{"item_type":"Days","quantity":"5","price":"1249.99","description":"CON001 : Consultancy"},{"item_type":"Stock","quantity":"7","price":"199.99","description":"WD 1TB 3.5 : Western Digital 1TB 3.5 hard disk drive","stock_item":"https://api.freeagent.com/v2/stock_items/236156"}]'
    )