Credit_Note_Reconciliations table

Column Type

Id

Integer

Url

URI

From_Date

Parameter

To_Date

Parameter

Updated_Since

Parameter

Credit_Note_Id

String

Credit_Note

URI

Invoice_Id

String

Invoice

URI

Gross_Value

Decimal

Dated_On

String

Exchange_Rate

Decimal

Currency

String

Created_At

Timestamp

Updated_At

Timestamp

Examples

SELECT
    *
FROM
    Credit_Note_Reconciliations

INSERT INTO
    Credit_Note_Reconciliations (
        Dated_On,
        Currency,
        Exchange_Rate,
        Gross_Value,
        Invoice,
        Credit_Note
    )
VALUES
    (
        '2024-12-06',
        'USD',
        '1',
        '100',
        'https://api.freeagent.com/v2/invoices/73622204',
        'https://api.freeagent.com/v2/credit_notes/73959649'
    )

UPDATE Credit_Note_Reconciliations
SET
    Gross_Value = 200
WHERE
    Id = '357053'

DELETE FROM Credit_Note_Reconciliations
WHERE
    Id = '357053'