1. Invoicing
  2. Credit notes
  3. Credit note linked tax withheld refunds

Credit note linked tax withheld refunds

credit_note_linked_tax_withheld_refunds
copy
Click to Copy
Details of refunds recorded against the invoice.linked_taxes_withheld component of the invoice associated with this credit_note.
UPSERT KEY
credit_note_id + record_id

Each row is uniquely identified by this combination. Use these columns together as the upsert key when applying incremental datasets to your warehouse.

Columns

No match found
tax_withheld_id string, not null
Foreign Key tax_withheld.id
An auto-generated unique identifier for the tax withheld. The value starts with the prefix tax_wh_ (for example, tax_wh_16BdDXSlbu4uV1Ee6).
credit_note_id string, not null
Foreign Key credit_notes.id
The unique ID of the credit note for this record.
amount long, null
The amount withheld by the customer as tax from the invoice. The unit depends on the type of currency.
change_type string
The column indicates the type of change [create, update, delete, read] and can be used to load data into the warehouse accordingly.
date timestamp, null
Date or time associated with the tax withheld.
description string, null
The description for this tax withheld.
record_exported_at timestamp
The column represents the timestamp when the data was exported to the configured destination.
record_extracted_at timestamp
The column represents the timestamp when the updated data became available in Chargebee's data lakehouse.
record_id integer
The column represents the unique integer identifier for each child record within a parent subset.
reference_number string, null
A unique external reference number for the tax withheld. Typically, this is the reference number used by the system you are integrating the API with. Depending on your integration, this could be the reference number issued by the taxation authority to identify the customer or the specific tax transaction.