Invoice_Comment table

Column Type

Invoice_Id

String

Comment_Id

String

Description

String

String

String

Commented_By_Id

String

String_Description

String

Commented_By

String

Comment_Type

String

Time

String

Operation_Type

String

Transaction_Id

String

Transaction_Type

String

Show_Comment_To_Clients

Boolean

Payment_Expected_String

String

Examples

SELECT
    *
FROM
    Invoice_Comment
WHERE
    Invoice_Id = '579676000000050234'
UPDATE Invoice_Comment
SET
    Description = 'Invoice updated. 2'
WHERE
    Invoice_Id = '579676000000050234'
    AND Comment_Id = '579676000000061089'
INSERT INTO
    Invoice_Comment (
        Invoice_Id,
        Description,
        show_comment_to_clients,
        payment_expected_date
    )
VALUES
    (
        '579676000000050234',
        'Comment visible to customer',
        1,
        '2024-08-29'
    )
DELETE FROM Invoice_Comment
WHERE
    Invoice_Id = '579676000000050234'
    AND Comment_Id = '579676000000165022'