Expenses table

Column Type

Id

Integer

Url

URI

From_Date

Parameter

To_Date

Parameter

Updated_Since

Parameter

Sales_Tax_Status

String

Attachment_File_Size

Integer

Attachment_Content_Src_Medium

String

Attachment_Url

URI

Attachment_Content_Src

String

Attachment_Content_Type

String

Attachment_Content_Src_Small

String

Attachment_Expires_At

String

Attachment_File_Name

String

User_Id

Integer

User

URI

Currency

String

Category_Id

Integer

Category

URI or String

Locked_Attributes

Array

Sales_Tax_Rate

Decimal

Dated_On

String

Gross_Value

Decimal

Updated_At

Timestamp

Native_Gross_Value

Decimal

Sales_Tax_Value

Decimal

Native_Sales_Tax_Value

Decimal

Description

String

Created_At

Timestamp

Locked_Reason

String

Second_Sales_Tax_Rate

Decimal

Second_Sales_Tax_Value

Decimal

Second_Sales_Tax_Status

String

Examples

SELECT
    *
FROM
    Expenses

INSERT INTO
    Expenses (
        User,
        Category,
        Dated_On,
        Currency,
        Gross_Value,
        Sales_Tax_Rate,
        Sales_Tax_Status,
        [Description]
    )
VALUES
    (
        'https://api.freeagent.com/v2/users/1861284',
        'https://api.freeagent.com/v2/categories/287',
        '2024-12-03',
        'GBP',
        '-200',
        '20',
        'TAXABLE',
        'Overnight stay'
    )

UPDATE Expenses
SET
    Description = 'Hotel Stay'
WHERE
    Id = '53063365'

DELETE FROM Expenses
WHERE
    Id = '53063365'