Bills table

Column Type

Id

String

Url

URI

Total_Value

Decimal

Status

String

Paid_Value

Decimal

Contact

String

Project

String

Created_At

Timestamp

Updated_At

Timestamp

Dated_On

String

Reference

String

Native_Due_Value

Decimal

Due_On

String

Net_Value

Decimal

Paid_On

String

Long_Status

String

Due_Value

Decimal

Currency

String

Input_Total_Values_Inc_Tax

Boolean

Sales_Tax_Value

Decimal

Is_Paid_By_Hire_Purchase

Boolean

Locked_Reason

String

Contact_Name

String

Comments

String

Second_Sales_Tax_Value

Decimal

Recurring

String

View

String

From_Date

Parameter

To_Date

Parameter

Updated_Since

Parameter

Locked_Attributes

Array

Bill_Items

Array

Examples

SELECT
    *
FROM
    Bills
WHERE
    Status = 'Open'

INSERT INTO
    Bills (Contact, Reference, Dated_On, Due_On, Bill_Items)
VALUES
    (
        'https://api.freeagent.com/v2/contacts/18541472',
        'YEB002',
        '2024-11-28',
        '2024-12-28',
        '[{"category":"https://api.freeagent.com/v2/categories/291","description":"YEB Line 2 standing charge","sales_tax_rate":"20","total_value_ex_tax":49.99}]'
    )

UPDATE Bills
SET
    Comments = 'Standing charge for second line.'
WHERE
    Id = '31467166'

DELETE FROM Bills
WHERE
    Id = '31467166'