Price_List_Items table

Column Type

Id

Integer

Url

URI

Sales_Tax_Rate

String

Item_Type

String

Created_At

Timestamp

Code

String

Quantity

Decimal

Price

Decimal

Description

String

Second_Sales_Tax_Rate

Decimal

Vat_Status

String

Category_Id

String

Category

URI

Updated_At

Timestamp

Stock_Item_Id

String

Stock_Item

URI

Examples

SELECT
    *
FROM
    Price_List_Items
WHERE
    Item_Type = 'Months'

INSERT INTO
    Price_List_Items (
        Code,
        Quantity,
        Item_Type,
        [Description],
        Price,
        Sales_Tax_Rate,
        Category
    )
VALUES
    (
        'CS001',
        '1',
        'Months',
        'Monthly Cloud Storage',
        '9.99',
        '20',
        'https://api.freeagent.com/v2/categories/001'
    )

UPDATE Price_List_Items
SET
    Price = 10.99
WHERE
    Code = 'CS001'

DELETE FROM Price_List_Items
WHERE
    Code = 'CS001'