Catalog: Chargebee
Schema: Invoices
Primary Keys: id
Label: Invoice Linked Payments
This is a read-only table. The Chargebee API may not support changing the data or the Invantive SQL driver for Chargebee does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Chargebee API.
Select Chargebee API URL: /invoices
Insert Chargebee API URL: /invoices
Update Chargebee API URL: /invoices
Delete Chargebee API URL: /invoices
Field Selection Method: NotRequired
Base Path: list[*].invoice.linked_payments[*]
The columns of the table InvoiceLinkedPayments are shown below. Each column has an SQL data type.
Name |
Data Type |
Label |
Required |
Documentation |
---|---|---|---|---|
applied_amount |
decimal |
Applied Amount |
☐ |
|
applied_at |
datetime |
Applied at |
☐ |
|
invoice_id |
string |
Invoice ID |
☑ |
|
txn_amount |
decimal |
Transaction Amount |
☐ |
|
txn_date |
datetime |
Transaction Date |
☐ |
|
txn_id |
string |
Transaction ID |
☐ |
|
txn_status |
string |
Transaction Status |
☐ |
|
12-12-2020 18:45 Version 20.1.301-BETA+3023