Sales_Tax_Periods table

Column Type

Id

Integer

Url

URI

Locked_Reason

String

Is_Locked

Boolean

Effective_Date

String

Sales_Tax_Name

String

Sales_Tax_Rate_1

Decimal

Sales_Tax_Rate_2

Decimal

Sales_Tax_Rate_3

Decimal

Sales_Tax_Registration_Number

String

Sales_Tax_Is_Value_Added

Boolean

Sales_Tax_Registration_Status

String

Second_Sales_Tax_Name

String

Second_Sales_Tax_Is_Compound

Boolean

Second_Sales_Tax_Rate_1

Decimal

Second_Sales_Tax_Rate_2

Decimal

Second_Sales_Tax_Rate_3

Decimal

Examples

SELECT
    *
FROM
    Sales_Tax_Periods
WHERE
    Is_Locked = FALSE

INSERT INTO
    Sales_Tax_Periods (
        Sales_Tax_Name,
        Sales_Tax_Rate_1,
        Sales_Tax_Is_Value_Added,
        Sales_Tax_Registration_Status,
        Effective_Date
    )
VALUES
    (
        'VAT Reduced',
        '15',
        'true',
        '1234567890',
        '2026-01-01'
    )

UPDATE Sales_Tax_Periods
SET
    Sales_Tax_Rate_1 = '16'
WHERE
    Id = '75824'

DELETE FROM Sales_Tax_Periods
WHERE
    Id = '75822'