1. Invoicing
  2. Invoices
  3. Invoice notes

Invoice notes

invoice_notes
copy
Click to Copy
The list of notes that appear on the invoice PDF sent to the customer. Notes that come from a specific table related to the invoice have entity_type and entity_id defined. There can be up to two notes in this array for which entity_type and entity_id are not defined:
  • Invoice-specific note: The note stored in the invoice_note field, typically associated with invoice records created through various operations such as subscription creation or invoice finalization.
  • General note: This note is added to all invoices of the Chargebee site. You can add/edit this note in the Chargebee admin console.
UPSERT KEY
invoice_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
invoice_id string, not null
Foreign Key invoices.id
The unique ID of the invoice this table belongs to.
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.
entity_id string, null
The unique identifier of the entity.
entity_type string, null
The type of entity to which the note belongs.
note string, not null
The actual note.
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.