Explore the Chargebee API data model

Pulling data from the Chargebee API is only the first part of your reporting. You also need to understand the relationships between different endpoints - something that APIs typically fail to convey.

At SyncHub, we not only sync your Chargebee API endpoints down into a reportable format, we also describe their relationships (e.g. in terms of foreign keys) so that you can quickly get a grasp of your data and how it fits together. This page is intended as technical documentation of these relationships.

Addon

Documentation: https://apidocs.chargebee.com/docs/api/addons?prod_cat_ver=1

Column	Type	Relates to	Notes
RemoteID	string	-	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	string	-	-
Name	string	-	-
Description	string	-	-
InvoiceName	string	-	-
PricingModel	string	-	-
ChargeType	string	-	-
Price	long	-	-
PriceInDecimal	decimal	-	-
CurrencyCode	string	-	-
Period	int	-	-
PeriodUnit	string	-	-
Unit	string	-	-
Status	string	-	-
ArchivedAt	long	-	-
WhenArchivedAt	datetime	-	-
EnabledInPortal	boolean	-	-
TaxCode	string	-	-
Sku	string	-	-
AccountingCode	string	-	-
AccountingCategory1	string	-	-
AccountingCategory2	string	-	-
AccountingCategory3	string	-	-
AccountingCategory4	string	-	-
IsShippable	boolean	-	-
ShippingFrequencyPeriod	long	-	-
ShippingFrequencyPeriodUnit	string	-	-
ResourceVersion	long	-	-
UpdatedAt	long	-	-
WhenUpdatedAt	datetime	-	-
Type	string	-	-
Channel	string	-	-
ShowDescriptionInInvoices	boolean	-	-
ShowDescriptionInQuotes	boolean	-	-

BusinessEntity

Documentation: https://apidocs.chargebee.com/docs/api/business_entities

Column	Type	Relates to	Notes
RemoteID	string	-	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	string	-	-
Name	string	-	-
Status	string	-	-
Deleted	boolean	-	-
CreatedAt	long	-	-
WhenCreatedAt	datetime	-	-
ResourceVersion	long	-	-
UpdatedAt	long	-	-
WhenUpdatedAt	datetime	-	-

Coupon

Documentation: https://apidocs.chargebee.com/docs/api/coupons

Column	Type	Relates to	Notes
RemoteID	string	-	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	string	-	-
Name	string	-	-
InvoiceName	string	-	-
DiscountType	string	-	-
DiscountPercentage	decimal	-	-
DiscountAmount	long	-	-
CurrencyCode	string	-	-
DurationType	string	-	-
ValidForm	long	-	-
WhenValidFrom	datetime	-	-
ValidTill	long	-	-
WhenValidTill	datetime	-	-
MaxRedemptions	int	-	-
Status	string	-	-
ApplyOn	string	-	-
CreatedAt	long	-	-
WhenCreatedAt	datetime	-	-
ArchivedAt	long	-	-
WhenArchivedAt	datetime	-	-
ResourceVersion	long	-	-
UpdatedAt	long	-	-
WhenUpdatedAt	datetime	-	-
Period	int	-	-
PeriodUnit	string	-	-
Redemptions	int	-	-
InvoiceNotes	string	-	-

CreditNote

Documentation: https://apidocs.chargebee.com/docs/api/credit_notes

Column	Type	Relates to	Notes
RemoteID	string	-	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	string	-	-
CustomerID	string	Customer → ID	-
SubscriptionID	string	Subscription → ID	-
ReferenceInvoiceID	string	Invoice → ID	-
Type	string	-	-
ReasonCode	string	-	-
Status	string	-	-
VatNumber	string	-	-
Date	long	-	-
WhenDate	datetime	-	-
PriceType	string	-	-
CountryCode	string	-	-
Total	long	-	-
AmountAllocated	long	-	-
AmountRefunded	long	-	-
AmountAvailable	long	-	-
RefundedAt	long	-	-
WhenRefundedAt	datetime	-	-
VoidedAt	long	-	-
WhenVoidedAt	datetime	-	-
GeneratedAt	long	-	-
WhenGeneratedAt	datetime	-	-
ResourceVersion	long	-	-
UpdatedAt	long	-	-
WhenUpdatedAt	datetime	-	-
Channel	string	-	-
SubTotal	long	-	-
SubTotalInLocalCurrency	long	-	-
TotalInLocalCurrency	long	-	-
LocalCurrencyCode	string	-	-
RoundOffAmount	long	-	-
FractionalCorrection	long	-	-
Deleted	boolean	-	-
TaxCategory	string	-	-
LocalCurrencyExchangeRate	decimal	-	-
CreateReasonCode	string	-	-
VatNumberPrefix	string	-	-
BusinessEntityID	string	BusinessEntity → ID	-
TaxOriginCountry	string	-	-
TaxOriginRegistrationNumber	string	-	-

Currency

Documentation: https://apidocs.chargebee.com/docs/api/currencies

Column	Type	Relates to	Notes
RemoteID	string	-	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	string	-	-
IsBaseCurrency	boolean	-	-
CurrencyCode	string	-	-
Enabled	boolean	-	-
ForexType	string	-	-
ManualExchangeRate	string	-	-

Customer

Documentation: https://apidocs.chargebee.com/docs/api/customers

Column	Type	Relates to	Notes
RemoteID	string	-	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	string	-	-
FirstName	string	-	-
LastName	string	-	-
Email	string	-	-
Phone	string	-	-
Company	string	-	-
VatNumber	string	-	-
AutoCollection	string	-	-
AutoCollectionEnabled	boolean	-	-
OfflinePaymentMethod	string	-	-
NetTermDays	int	-	-
VatNumberValidatedTime	long	-	-
WhenVatNumberValidatedTime	datetime	-	-
VatNumberStatus	string	-	-
AllowDirectDebit	boolean	-	-
IsLocationValid	boolean	-	-
CreatedAt	long	-	-
WhenCreatedAt	datetime	-	-
CreatedFromIp	string	-	-
Taxibility	string	-	-
EntityCode	string	-	-
ExemptNumber	string	-	-
ResourceVersion	long	-	-
UpdatedAt	long	-	-
WhenUpdatedAt	datetime	-	-
Locale	string	-	-
BillingDate	int	-	-
BillingMonth	int	-	-
BillingDateMode	string	-	-
BillingDayOfWeek	string	-	-
BillingDayOfWeekMode	string	-	-
PiiCleared	string	-	-
AutoCloseInvoices	boolean	-	-
Channel	string	-	-
ActiveID	string	Customer → ID	-
FraudFlag	string	-	-
PrimaryPaymentSourceID	string	PaymentSource → ID	-
BackupPaymentSourceID	string	PaymentSource → ID	-
InvoiceNotes	string	-	-
BusinessEntityID	string	BusinessEntity → ID	-
PreferredCurrencyCode	string	-	-
PromotionalCredits	long	-	-
UnbilledCharges	long	-	-
RefundableCredits	long	-	-
ExcessPayments	long	-	-
IsEinvoiceEnabled	boolean	-	-
EinvoicingMethod	string	-	-
Deleted	boolean	-	-
RegisteredForGst	boolean	-	-
ConsolidatedInvoicing	boolean	-	-
CustomerType	string	-	-
BusinessCustomerWithoutVatNumber	boolean	-	-
ClientProfileID	string	-	-
UseDefaultHierarchySettings	boolean	-	-
VatNumberPrefix	string	-	-
EntityIdentifierScheme	string	-	-
EntityIdentifierStandard	string	-	-
PaymentType	string	-	-
PaymentGateway	string	-	-
PaymentGatewayAccountID	string	-	-
PaymentStatus	string	-	-
PaymentReferenceID	string	-	-
ParentID	string	Customer → ID	-
PaymentOwnerID	string	Customer → ID	-
InvoiceOwnerID	string	Customer → ID	-
ParentAccountPortalEditChildSubscriptions	string	-	-
ParentAccountPortalDownloadChildInvoices	string	-	-
ParentAccountSendSubscriptionEmails	boolean	-	-
ParentAccountSendInvoiceEmails	boolean	-	-
ParentAccountSendPaymentEmails	boolean	-	-
ChildAccountPortalEditSubscriptions	string	-	-
ChildAccountPortalDownloadInvoices	string	-	-
ChildAccountSendSubscriptionEmails	boolean	-	-
ChildAccountSendInvoiceEmails	boolean	-	-
ChildAccountSendPaymentEmails	boolean	-	-

Invoice

Documentation: https://apidocs.chargebee.com/docs/api/invoices

Column	Type	Relates to	Notes
RemoteID	string	-	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	string	-	-
PoNumber	string	-	-
CustomerID	string	Customer → ID	-
SubscriptionID	string	Subscription → ID	-
Recurring	boolean	-	-
Status	string	-	-
VatNumber	string	-	-
PriceType	string	-	-
Date	long	-	-
WhenDate	datetime	-	-
DueDate	long	-	-
WhenDueDate	datetime	-	-
NetTermDays	int	-	-
ExchangeRate	decimal	-	-
CurrencyCode	string	-	-
Total	long	-	-
AmountPaid	long	-	-
AmountAdjusted	long	-	-
WriteOffAmount	long	-	-
CreditsApplied	long	-	-
AmountDue	long	-	-
PaidAt	long	-	-
WhenPaidAt	datetime	-	-
DunningStatus	string	-	-
NextRetryAt	long	-	-
WhenNextRetryAt	datetime	-	-
VoidedAt	long	-	-
WhenVoidedAt	datetime	-	-
ResourceVersion	long	-	-
UpdatedAt	long	-	-
WhenUpdatedAt	datetime	-	-
SubTotal	long	-	-
SubTotalInLocalCurrency	long	-	-
TotalInLocalCurrency	long	-	-
LocalCurrencyCode	string	-	-
Tax	long	-	-
LocalCurrencyExchangeRate	decimal	-	-
FirstInvoice	boolean	-	-
NewSalesAmount	long	-	-
HasAdvanceCharges	boolean	-	-
TermFinalized	boolean	-	-
IsGifted	boolean	-	-
GeneratedAt	long	-	-
WhenGeneratedAt	datetime	-	-
ExpectedPaymentDate	long	-	-
WhenExpectedPaymentDate	datetime	-	-
AmountToCollect	long	-	-
RoundOfAmount	long	-	-
PaymentOwner	string	-	-
VoidReasonCode	string	-	-
Deleted	boolean	-	-
TaxCategory	string	-	-
VatPrefixNumber	string	-	-
Channel	string	-	-
BusinessEntityID	string	BusinessEntity → ID	-
TaxOriginCountry	string	-	-
RegistrationNumber	string	-	-

Item

Documentation: https://apidocs.chargebee.com/docs/api/items

Column	Type	Relates to	Notes
RemoteID	string	-	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	string	-	-
Name	string	-	-
Description	string	-	-
ExternalName	string	-	-
Status	string	-	-
ResourceVersion	long	-	-
UpdatedAt	long	-	-
WhenUpdatedAt	datetime	-	-
ItemFamilyID	string	ItemFamily → ID	-
Type	string	-	-
IsShippable	boolean	-	-
IsGiftable	boolean	-	-
RedirectUrl	string	-	-
EnabledForCheckout	boolean	-	-
EnabledInPortal	boolean	-	-
IncludedInMrr	boolean	-	-
ItemApplicability	string	-	-
GiftClaimRedirectUrl	string	-	-
Unit	string	-	-
Metered	boolean	-	-
UsageCalculation	string	-	-
ArchivedAt	long	-	-
WhenArchivedAt	datetime	-	-
Channel	string	-	-
BusinessEntityID	string	BusinessEntity → ID	-
BundleConfigurationType	string	-	-

ItemFamily

Documentation: https://apidocs.chargebee.com/docs/api/item_families

Column	Type	Relates to	Notes
RemoteID	string	-	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	string	-	-
Name	string	-	-
Description	string	-	-
Status	string	-	-
ResourceVersion	long	-	-
UpdatedAt	long	-	-
WhenUpdatedAt	datetime	-	-
Channel	string	-	-
BusinessEntityID	string	BusinessEntity → ID	-

ItemPrice

Documentation: https://apidocs.chargebee.com/docs/api/item_prices

Column	Type	Relates to	Notes
RemoteID	string	-	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	string	-	-
Name	string	-	-
Description	string	-	-
ItemFamilyID	string	ItemFamily → ID	-
ItemID	string	Item → ID	-
Status	string	-	-
ExternalName	string	-	-
PriceVariantID	string	-	-
ProrationType	string	-	-
PricingModel	string	-	-
Price	long	-	-
PriceInDecimal	decimal	-	-
Period	int	-	-
CurrencyCode	string	-	-
PeriodUnit	string	-	-
TrialPeriod	int	-	-
TrialPeriodUnit	string	-	-
TrialEndAction	string	-	-
ShippingPeriod	int	-	-
ShippingPeriodUnit	string	-	-
BillingCycles	int	-	-
FreeQuantity	int	-	-
FreeQuantityInDecimal	decimal	-	-
Channel	string	-	-
ResourceVersion	long	-	-
UpdatedAt	long	-	-
WhenUpdatedAt	datetime	-	-
CreatedAt	long	-	-
WhenCreatedAt	datetime	-	-
UsageAccumulationResetFrequency	string	-	-
ArchivedAt	long	-	-
WhenArchivedAt	datetime	-	-
InvoiceNotes	string	-	-
IsTaxable	boolean	-	-
ItemType	string	-	-
ShowDescriptionInInvoices	boolean	-	-
ShowDescriptionInQuotes	boolean	-	-
BusinessEntityID	string	BusinessEntity → ID	-
TaxProfileID	string	-	-
AvalaraSaleType	string	-	-
AvalaraTransactionType	int	-	-
AvalaraServiceType	int	-	-
AvalaraTaxCode	string	-	-
HsnCode	string	-	-
TaxjarProductCode	string	-	-
Sku	string	-	-
AccountingCode	string	-	-
AccountingCategory1	string	-	-
AccountingCategory2	string	-	-
AccountingCategory3	string	-	-
AccountingCategory4	string	-	-

Order

Documentation: https://apidocs.chargebee.com/docs/api/orders

Column	Type	Relates to	Notes
RemoteID	string	-	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	string	-	-
DocumentNumber	string	-	-
InvoiceID	string	Invoice → ID	-
SubscriptionID	string	Subscription → ID	-
CustomerID	string	Customer → ID	-
Status	string	-	-
CancellationReason	string	-	-
PaymentStatus	string	-	-
OrderType	string	-	-
PriceType	string	-	-
ReferenceID	string	-	-
FulfullmentStatus	string	-	-
OrderDate	long	-	-
WhenOrderDate	datetime	-	-
ShippingDate	long	-	-
WhenShippingDate	datetime	-	-
Note	string	-	-
TrackingID	string	-	-
TrackingUrl	string	-	-
BatchID	string	-	-
CreatedBy	string	-	-
ShipmentCarrier	string	-	-
InvoiceRoundOffAmount	long	-	-
Tax	long	-	-
AmountPaid	long	-	-
AmountAdjusted	long	-	-
RefundableCreditsIssued	long	-	-
RefundableCredits	long	-	-
RoundingAdjustement	long	-	-
PaidOn	long	-	-
WhenPaidOn	datetime	-	-
ShippingCutOffDate	long	-	-
WhenShippingCutOffDate	datetime	-	-
CreatedAt	long	-	-
WhenCreatedAt	datetime	-	-
StatusUpdateAt	long	-	-
WhenStatusUpdateAt	datetime	-	-
DeliveredAt	long	-	-
WhenDeliveredAt	datetime	-	-
ShippedAt	long	-	-
WhenShippedAt	datetime	-	-
ResourceVersion	long	-	-
UpdatedAt	long	-	-
WhenUpdatedAt	datetime	-	-
CancelledAt	long	-	-
WhenCancelledAt	datetime	-	-
ResentStatus	string	-	-
IsResent	boolean	-	-
OriginalOrderID	string	Order → ID	-
Discount	long	-	-
SubTotal	long	-	-
Total	long	-	-
Deleted	boolean	-	-
CurrencyCode	string	-	-
IsGifted	boolean	-	-
GiftNote	string	-	-
GiftID	string	-	-
ResendReason	string	-	-
BusinessEntityID	string	-	-

PaymentSource

Documentation: https://apidocs.chargebee.com/docs/api/payment_sources

Column	Type	Relates to	Notes
RemoteID	string	-	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	string	-	-
ResourceVersion	long	-	-
UpdatedAt	long	-	-
CreatedAt	long	-	-
WhenCreatedAt	datetime	-	-
CustomerID	string	Customer → ID	-
Type	string	-	-
ReferenceID	string	-	-
Status	string	-	-
Gateway	string	-	-
GatewayAccountID	string	-	-
IpAddress	string	-	-
IssuingCountry	string	-	-
Deleted	boolean	-	-
BusinessEntityID	string	BusinessEntity → ID	-
BoletoLast4	string	-	-
BoletoFirstName	string	-	-
BoletoLastName	string	-	-
BoletoEmail	string	-	-
AmazonPaymentEmail	string	-	-
AmazonPaymentAgreementID	string	-	-
UpiVpa	string	-	-
PaypalEmail	string	-	-
PaypalAgreementID	string	-	-
VenmoUserName	string	-	-
KlarnaPayNowEmail	string	-	-

Plan

Documentation: https://apidocs.chargebee.com/docs/api/plans?prod_cat_ver=1

Column	Type	Relates to	Notes
RemoteID	string	-	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	string	-	-
Name	string	-	-
Description	string	-	-
InvoiceName	string	-	-
PeriodUnit	string	-	-
Period	int	-	-
TrialPeriod	long	-	-
WhenTrialPeriod	datetime	-	-
TrialPeriodUnit	string	-	-
TrialEndAction	string	-	-
PricingModel	string	-	-
Price	long	-	-
PriceInDecimal	decimal	-	-
CurrencyCode	string	-	-
FreeQuantity	int	-	-
Status	string	-	-
ArchivedAt	long	-	-
WhenArchivedAt	datetime	-	-
BillingCycles	int	-	-
RedirectUrl	string	-	-
EnabledInHostedPages	boolean	-	-
EnabledInPortal	boolean	-	-
AddonApplicability	string	-	-
TaxCode	string	-	-
HsnCode	string	-	-
Sku	string	-	-
AccountingCode	string	-	-
AccountingCategory1	string	-	-
AccountingCategory2	string	-	-
AccountingCategory3	string	-	-
AccountingCategory4	string	-	-
IsShippable	boolean	-	-
ShippingFrequencyPeriod	long	-	-
ShippingFrequencyPeriodUnit	string	-	-
ResourceVersion	long	-	-
UpdatedAt	long	-	-
WhenUpdatedAt	datetime	-	-
Giftable	boolean	-	-
ClaimUrl	string	-	-
FreeQuantityInDecimal	int	-	-
Channel	string	-	-

Subscription

Documentation: https://apidocs.chargebee.com/docs/api/subscriptions

Column	Type	Relates to	Notes
RemoteID	string	-	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	string	-	-
CurrencyCode	string	-	-
StartDate	long	-	-
WhenStartDate	datetime	-	-
TrialEnd	long	-	-
WhenTrialEnd	datetime	-	-
TrialStart	long	-	-
WhenTrialStart	datetime	-	-
RemainingBillingCycles	long	-	-
PoNumber	string	-	-
PlanQuantityInDecimal	decimal	-	-
PlanUnitPriceInDecimal	decimal	-	-
CustomerID	string	Customer → ID	-
Status	string	-	-
TrialEndAction	string	-	-
CurrentTermStart	long	-	-
WhenCurrentTermStart	datetime	-	-
CurrentTermEnd	long	-	-
WhenCurrentTermEnd	datetime	-	-
NextBillingAt	long	-	-
WhenNextBillingAt	datetime	-	-
CreatedAt	long	-	-
WhenCreatedAt	datetime	-	-
StartedAt	long	-	-
WhenStartedAt	datetime	-	-
ActivatedAt	long	-	-
WhenActivatedAt	datetime	-	-
ContractTermBillingCycleOnRenewal	long	-	-
OverrideRelationship	boolean	-	-
PauseDate	long	-	-
WhenPauseDate	datetime	-	-
ResumeDate	long	-	-
WhenResumeDate	datetime	-	-
CancelledAt	long	-	-
WhenCancelledAt	datetime	-	-
CancelReason	string	-	-
CreatedFromIp	string	-	-
ResourceVersion	long	-	-
UpdatedAt	long	-	-
WhenUpdatedAt	datetime	-	-
HasScheduledAdvanceInvoices	boolean	-	-
HasScheduledChanges	boolean	-	-
PaymentSourceID	string	PaymentSource → ID	-
PlanFreeQuantityInDecimal	decimal	-	-
PlanAmountInDecimal	decimal	-	-
CancelScheduleCreatedAt	long	-	-
Channel	string	-	-
NetTermDays	int	-	-
ActiveID	string	Subscription → ID	-
DueInvoicesCount	int	-	-
DueSince	long	-	-
WhenDueSince	datetime	-	-
TotalDues	long	-	-
Mrr	long	-	-
ExchangeRate	decimal	-	-
BaseCurrencyCode	string	-	-
InvoiceNotes	string	-	-
Deleted	boolean	-	-
ChangesScheduledAt	long	-	-
WhenChangesScheduledAt	datetime	-	-
CancelReasonCode	string	-	-
FreePeriod	long	-	-
FreePeriodUnit	string	-	-
CreatePendingInvoices	boolean	-	-
AutoCloseInvoices	boolean	-	-
BusinessEntityID	string	BusinessEntity → ID	-

Transaction

Documentation: https://apidocs.chargebee.com/docs/api/transactions

Column	Type	Relates to	Notes
RemoteID	string	-	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	string	-	-
CustomerID	string	Customer → ID	-
SubscriptionID	string	Subscription → ID	-
GatewayAccountID	string	-	-
PaymentSourceID	string	PaymentSource → ID	-
PaymentMethod	string	-	-
ReferenceNumber	string	-	-
Gateway	string	-	-
Type	string	-	-
Date	long	-	-
WhenDate	datetime	-	-
SettledAt	long	-	-
WhenSettledAt	datetime	-	-
ExchangeRate	decimal	-	-
CurrencyCode	string	-	-
Amount	long	-	-
IdAtGateway	string	-	-
Status	string	-	-
FraudFlag	string	-	-
InitiatorType	string	-	-
ThreeDSecure	boolean	-	-
AuthorizationReason	string	-	-
ErrorCode	string	-	-
ErrorText	string	-	-
VoidedAt	long	-	-
WhenVoidedAt	datetime	-	-
ResourceVersion	long	-	-
UpdatedAt	long	-	-
WhenUpdatedAt	datetime	-	-
FraudReason	string	-	-
CustomPaymentMethodID	string	-	-
AmountUnused	long	-	-
MaskedCardNumber	string	-	-
ReferenceTransactionID	string	Transaction → ID	-
RefundedTxnID	string	Transaction → ID	-
ReferenceAuthorizationID	string	Transaction → ID	-
AmountCapturable	long	-	-
ReversalTransactionID	string	Transaction → ID	-
Deleted	boolean	-	-
Iin	string	-	-
Last4	string	-	-
MerchantReferenceID	string	-	-
BusinessEntityID	string	BusinessEntity → ID	-
PaymentMethodDetails	string	-	-
CustomPaymentMethodName	string	-	-

UnbilledCharge

Documentation: https://apidocs.chargebee.com/docs/api/unbilled_charges

Column	Type	Relates to	Notes
RemoteID	string	-	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	string	-	-
Description	string	-	-
CustomerID	string	Customer → ID	-
SubscriptionID	string	Subscription → ID	-
DateFrom	long	-	-
WhenDateFrom	datetime	-	-
DateTo	long	-	-
WhenDateTo	datetime	-	-
UnitAmount	long	-	-
PricingModel	string	-	-
Quantity	long	-	-
CurrencyCode	string	-	-
DiscountAmount	long	-	-
EntityType	string	-	-
EntityID	string	-	-
ItemPriceID	string	ItemPrice → ID	-
InvoiceID	string	Invoice → ID	-
LineItemID	string	InvoiceLineItem → ID	-
IsVoided	boolean	-	-
VoidedAt	long	-	-
WhenVoidedAt	datetime	-	-
UnitAmountInDecimal	decimal	-	-
QuantityInDecimal	decimal	-	-
AmountInDecimal	decimal	-	-
IsAdvanceCharge	boolean	-	-
BusinessEntityID	string	BusinessEntity → ID	-
Deleted	boolean	-	-
UpdatedAt	long	-	-
WhenUpdatedAt	datetime	-	-

Usage

Documentation: https://apidocs.chargebee.com/docs/api/usages

Column	Type	Relates to	Notes
RemoteID	string	-	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	string	-	-
UsageDate	long	-	-
WhenUsageDate	datetime	-	-
SubscriptionID	string	Subscription → ID	-
ItemPriceID	string	ItemPrice → ID	-
InvoiceID	string	Invoice → ID	-
LineItemID	string	InvoiceLineItem → ID	-
Quantity	string	-	-
Source	string	-	-
Note	string	-	-
ResourceVersion	long	-	-
UpdatedAt	long	-	-
WhenUpdatedAt	datetime	-	-
CreatedAt	long	-	-
WhenCreatedAt	datetime	-	-

AddonCustomField

Column	Type	Relates to	Notes
RemoteID	string	-	-
AddonRemoteID	string	Addon → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
Name	string	-	-
AddonID	string	Addon → ID	-
Value	string	-	-

AddonTier

Column	Type	Relates to	Notes
RemoteID	string	-	-
AddonRemoteID	string	Addon → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
AddonID	string	Addon → ID	-
StartingUnit	int	-	-
EndingUnit	int	-	-
Price	long	-	-
StartingUnitInDecimal	decimal	-	-
EndingUnitInDecimal	decimal	-	-
PriceInDecimal	decimal	-	-

CouponItemConstraint

Column	Type	Relates to	Notes
RemoteID	string	-	-
CouponRemoteID	string	Coupon → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
CouponID	string	Coupon → ID	-
Iterator	int	-	-
ItemType	string	-	-
Constraint	string	-	-

CouponCustomField

Column	Type	Relates to	Notes
RemoteID	string	-	-
CouponRemoteID	string	Coupon → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
Name	string	-	-
CouponID	string	Coupon → ID	-
Value	string	-	-

CouponItemConstraintCriteria

Column	Type	Relates to	Notes
RemoteID	string	-	-
CouponRemoteID	string	Coupon → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
CouponID	string	Coupon → ID	-
Iterator	int	-	-
ItemType	string	-	-

CouponConstraint

Column	Type	Relates to	Notes
RemoteID	string	-	-
CouponRemoteID	string	Coupon → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
CouponID	string	Coupon → ID	-
Iterator	int	-	-
EntityType	string	-	-
Type	string	-	-
Value	string	-	-

CreditNoteEInvoice

Column	Type	Relates to	Notes
RemoteID	string	-	-
CreditNoteRemoteID	string	CreditNote → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	string	-	-
CreditNoteID	string	CreditNote → ID	-
ReferenceNumber	string	-	-
Status	string	-	-
Message	string	-	-

CreditNoteLineItem

Column	Type	Relates to	Notes
RemoteID	string	-	-
CreditNoteRemoteID	string	CreditNote → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	string	-	-
Description	string	-	-
CreditNoteID	string	CreditNote → ID	-
SubscriptionID	string	Subscription → ID	-
DateFrom	long	-	-
WhenDateFrom	datetime	-	-
DateTo	long	-	-
WhenDateTo	datetime	-	-
UnitAmount	long	-	-
Quantity	int	-	-
Amount	long	-	-
PricingModel	string	-	-
IsTaxed	boolean	-	-
TaxAmount	long	-	-
TaxRate	decimal	-	-
UnitAmountInDecimal	decimal	-	-
QuantityInDecimal	decimal	-	-
AmountInDecimal	decimal	-	-
DiscountAmount	long	-	-
ItemLevelDiscoutAmount	long	-	-
ReferenceLineItemID	string	InvoiceLineItem → ID	-
EntityDescription	string	-	-
EntityType	string	-	-
TaxExemptReason	string	-	-
EntityID	string	ItemPrice → ID	-
CustomerID	string	Customer → ID	-

CreditNoteDiscount

Column	Type	Relates to	Notes
RemoteID	string	-	-
CreditNoteRemoteID	string	CreditNote → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
Description	string	-	-
CreditNoteID	string	CreditNote → ID	-
Iterator	int	-	-
Amount	long	-	-
LineItemID	string	CreditNoteLineItem → ID	-
EntityType	string	-	-
DiscountType	string	-	-
EntityID	string	-	-
CouponID	string	Coupon → ID	-
DiscountID	string	SubscriptionDiscount → ID	-
CouponSetCode	string	-	-

CreditNoteLineItemDiscount

Column	Type	Relates to	Notes
RemoteID	string	-	-
CreditNoteRemoteID	string	CreditNote → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
CreditNoteID	string	CreditNote → ID	-
LineItemID	string	CreditNoteLineItem → ID	-
DiscountType	string	-	-
EntityID	string	-	-
CouponID	string	Coupon → ID	-
DiscountID	string	SubscriptionDiscount → ID	-
DiscountAmount	long	-	-

CreditNoteLineItemTier

Column	Type	Relates to	Notes
RemoteID	string	-	-
CreditNoteRemoteID	string	CreditNote → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
CreditNoteID	string	CreditNote → ID	-
LineItemID	string	CreditNoteLineItem → ID	-
StartingUnit	int	-	-
EndingUnit	int	-	-
QuantityUsed	int	-	-
UnitAmount	long	-	-
StartingUnitInDecimal	decimal	-	-
EndingUnitInDecimal	decimal	-	-
QuantityUsedInDecimal	decimal	-	-
UnitAmountInDecimal	decimal	-	-

CreditNoteTax

Column	Type	Relates to	Notes
RemoteID	string	-	-
CreditNoteRemoteID	string	CreditNote → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
Name	string	-	-
Description	string	-	-
CreditNoteID	string	CreditNote → ID	-
Iterator	int	-	-
Amount	long	-	-

CreditNoteLineItemTax

Column	Type	Relates to	Notes
RemoteID	string	-	-
CreditNoteRemoteID	string	CreditNote → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
CreditNoteID	string	CreditNote → ID	-
LineItemID	string	CreditNoteLineItem → ID	-
TaxName	string	-	-
TaxRate	decimal	-	-
DateTo	long	-	-
WhenDateTo	datetime	-	-
DateFrom	long	-	-
WhenDateFrom	datetime	-	-
ProratedTaxableAmount	decimal	-	-
IsPartialTaxApplied	boolean	-	-
IsNonComplianceTax	boolean	-	-
TaxableAmount	long	-	-
TaxAmount	long	-	-
TaxJurisType	string	-	-
TaxJurisName	string	-	-
TaxJurisCode	string	-	-
TaxAmountInLocalCurrency	long	-	-
LocalCurrencyCode	string	-	-

CreditNoteLinkedRefund

Column	Type	Relates to	Notes
RemoteID	string	-	-
CreditNoteRemoteID	string	CreditNote → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
CreditNoteID	string	CreditNote → ID	-
TxnID	string	Transaction → ID	-
AppliedAmount	long	-	-
AppliedAt	long	-	-
WhenAppliedAt	datetime	-	-
TxnStatus	string	-	-
TxnDate	long	-	-
WhenTxnDate	datetime	-	-
TxnAmount	long	-	-
RefundReasonCode	string	-	-

CreditNoteAllocation

Column	Type	Relates to	Notes
RemoteID	string	-	-
CreditNoteRemoteID	string	CreditNote → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
CreditNoteID	string	CreditNote → ID	-
InvoiceID	string	CreditNote → ID	-
AllocatedAmount	long	-	-
AllocatedAt	long	-	-
WhenAllocatedAt	datetime	-	-
InvoiceDate	long	-	-
WhenInvoiceDate	datetime	-	-
InvoiceStatus	string	-	-

CreditNoteShippingAddress

Column	Type	Relates to	Notes
RemoteID	string	-	-
CreditNoteRemoteID	string	CreditNote → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
CreditNoteID	string	CreditNote → ID	-
Iterator	int	-	-
FirstName	string	-	-
LastName	string	-	-
Email	string	-	-
Company	string	-	-
Phone	string	-	-
Line1	string	-	-
Line2	string	-	-
Line3	string	-	-
City	string	-	-
StateCode	string	-	-
State	string	-	-
Country	string	-	-
Zip	string	-	-
ValidationStatus	string	-	-
Index	int	-	-

CreditNoteBillingAddress

Column	Type	Relates to	Notes
RemoteID	string	-	-
CreditNoteRemoteID	string	CreditNote → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
CreditNoteID	string	CreditNote → ID	-
Iterator	int	-	-
FirstName	string	-	-
LastName	string	-	-
Email	string	-	-
Company	string	-	-
Phone	string	-	-
Line1	string	-	-
Line2	string	-	-
Line3	string	-	-
City	string	-	-
StateCode	string	-	-
State	string	-	-
Country	string	-	-
Zip	string	-	-
ValidationStatus	string	-	-

CustomerCustomField

Column	Type	Relates to	Notes
RemoteID	string	-	-
CustomerRemoteID	string	Customer → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
Name	string	-	-
CustomerID	string	Customer → ID	-
Value	string	-	-

CustomerBillingAddress

Column	Type	Relates to	Notes
RemoteID	string	-	-
CustomerRemoteID	string	Customer → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
CustomerID	string	Customer → ID	-
Iterator	int	-	-
FirstName	string	-	-
LastName	string	-	-
Email	string	-	-
Company	string	-	-
Phone	string	-	-
Line1	string	-	-
Line2	string	-	-
Line3	string	-	-
City	string	-	-
StateCode	string	-	-
State	string	-	-
Country	string	-	-
Zip	string	-	-
ValidationStatus	string	-	-

CustomerReferralURL

Column	Type	Relates to	Notes
RemoteID	string	-	-
CustomerRemoteID	string	Customer → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
CustomerID	string	Customer → ID	-
Iterator	int	-	-
ExternalCustomerID	string	-	-
ReferralSharingUrl	string	-	-
CreatedAt	long	-	-
WhenCreatedAt	datetime	-	-
UpdatedAt	long	-	-
WhenUpdatedAt	datetime	-	-
ReferralCampaignID	string	-	-
ReferralAccountID	string	-	-
ReferralExternalCampaignID	string	-	-
ReferralSystem	string	-	-

CustomerContact

Column	Type	Relates to	Notes
RemoteID	string	-	-
CustomerRemoteID	string	Customer → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	string	-	-
CustomerID	string	Customer → ID	-
FirstName	string	-	-
LastName	string	-	-
Email	string	-	-
Phone	string	-	-
Label	string	-	-
Enabled	boolean	-	-
SendAccountEmail	boolean	-	-
SendBillingEmail	boolean	-	-

CustomerBalance

Column	Type	Relates to	Notes
RemoteID	string	-	-
CustomerRemoteID	string	Customer → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
CustomerID	string	Customer → ID	-
Iterator	int	-	-
PromotionalCredits	long	-	-
ExcessPayments	long	-	-
RefundableCredits	long	-	-
UnbilledCharges	long	-	-
CurrencyCode	string	-	-

CustomerEntityIdentifier

Column	Type	Relates to	Notes
RemoteID	string	-	-
CustomerRemoteID	string	Customer → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	string	-	-
CustomerID	string	Customer → ID	-
Value	string	-	-
Scheme	string	-	-
Standard	string	-	-

CustomerTaxProvidersField

Column	Type	Relates to	Notes
RemoteID	string	-	-
CustomerRemoteID	string	Customer → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
CustomerID	string	Customer → ID	-
Iterator	int	-	-
ProviderName	string	-	-
FieldID	string	-	-
FieldValue	string	-	-

InvoiceLineItem

Column	Type	Relates to	Notes
RemoteID	string	-	-
InvoiceRemoteID	string	Invoice → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	string	-	-
Description	string	-	-
InvoiceID	string	Invoice → ID	-
SubscriptionID	string	Subscription → ID	-
DateFrom	long	-	-
WhenDateFrom	datetime	-	-
DateTo	long	-	-
WhenDateTo	datetime	-	-
UnitAmount	long	-	-
Quantity	int	-	-
Amount	long	-	-
PricingModel	string	-	-
IsTaxed	boolean	-	-
TaxAmount	long	-	-
TaxRate	decimal	-	-
UnitAmountInDecimal	decimal	-	-
QuantityInDecimal	decimal	-	-
AmountInDecimal	decimal	-	-
DiscountAmount	long	-	-
ItemLevelDiscountAmount	long	-	-
ReferenceLineItemID	string	InvoiceLineItem → ID	-
EntityDescription	string	-	-
EntityType	string	-	-
TaxExemptReason	string	-	-
EntityID	string	ItemPrice → ID	-
CustomerID	string	Customer → ID	-

InvoiceDiscount

Column	Type	Relates to	Notes
RemoteID	string	-	-
InvoiceRemoteID	string	Invoice → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
Description	string	-	-
InvoiceID	string	Invoice → ID	-
Iterator	int	-	-
Amount	long	-	-
LineItemID	string	InvoiceLineItem → ID	-
EntityType	string	-	-
DiscountType	string	-	-
EntityID	string	-	-
CouponID	string	Coupon → ID	-
DiscountID	string	SubscriptionDiscount → ID	-
CouponSetCode	string	-	-

InvoiceLineItemDiscount

Column	Type	Relates to	Notes
RemoteID	string	-	-
InvoiceRemoteID	string	Invoice → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
InvoiceID	string	Invoice → ID	-
Iterator	int	-	-
LineItemID	string	InvoiceLineItem → ID	-
DiscountType	string	-	-
EntityID	string	-	-
DiscountID	string	SubscriptionDiscount → ID	-
CouponID	string	Coupon → ID	-
DiscountAmount	long	-	-

InvoiceTax

Column	Type	Relates to	Notes
RemoteID	string	-	-
InvoiceRemoteID	string	Invoice → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
Name	string	-	-
Description	string	-	-
InvoiceID	string	Invoice → ID	-
Iterator	int	-	-
Amount	long	-	-

InvoiceLineItemTax

Column	Type	Relates to	Notes
RemoteID	string	-	-
InvoiceRemoteID	string	Invoice → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
InvoiceID	string	Invoice → ID	-
LineItemID	string	InvoiceLineItem → ID	-
TaxName	string	-	-
TaxRate	decimal	-	-
DateTo	long	-	-
WhenDateTo	datetime	-	-
DateFrom	long	-	-
WhenDateFrom	datetime	-	-
ProratedTaxableAmount	decimal	-	-
IsPartialTaxApplied	boolean	-	-
IsNonComplianceTax	boolean	-	-
TaxableAmount	long	-	-
TaxAmount	long	-	-
TaxJurisType	string	-	-
TaxJurisName	string	-	-
TaxJurisCode	string	-	-
TaxAmountInLocalCurrency	long	-	-
LocalCurrencyCode	string	-	-

InvoiceLineItemTier

Column	Type	Relates to	Notes
RemoteID	string	-	-
InvoiceRemoteID	string	Invoice → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
InvoiceID	string	Invoice → ID	-
LineItemID	string	InvoiceLineItem → ID	-
StartingUnit	int	-	-
EndingUnit	int	-	-
QuantityUsed	int	-	-
UnitAmount	long	-	-
StartingUnitInDecimal	decimal	-	-
EndingUnitInDecimal	decimal	-	-
QuantityUsedInDecimal	decimal	-	-
UnitAmountInDecimal	decimal	-	-

InvoiceLinkedPayment

Column	Type	Relates to	Notes
RemoteID	string	-	-
InvoiceRemoteID	string	Invoice → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
InvoiceID	string	Invoice → ID	-
TxnID	string	Transaction → ID	-
AppliedAmount	long	-	-
AppliedAt	long	-	-
WhenAppliedAt	datetime	-	-
TxnStatus	string	-	-
TxnDate	long	-	-
WhenTxnDate	datetime	-	-
TxnAmount	long	-	-

InvoiceDunningAttempt

Column	Type	Relates to	Notes
RemoteID	string	-	-
InvoiceRemoteID	string	Invoice → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
InvoiceID	string	Invoice → ID	-
Iterator	int	-	-
Attempt	int	-	-
TransactionID	string	Transaction → ID	-
DunningType	string	-	-
CreatedAt	long	-	-
WhenCreatedAt	datetime	-	-
TxnStatus	string	-	-
TxnAmount	long	-	-

InvoiceAppliedCredit

Column	Type	Relates to	Notes
RemoteID	string	-	-
InvoiceRemoteID	string	Invoice → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
InvoiceID	string	Invoice → ID	-
CnID	string	CreditNote → ID	-
AppliedAmount	long	-	-
AppliedAt	long	-	-
WhenAppliedAt	datetime	-	-
CnReasonCode	string	-	-
CnCreateReasonCode	string	-	-
CnDate	long	-	-
WhenCNDate	datetime	-	-
CnStatus	string	-	-

InvoiceAdjustmentCreditNote

Column	Type	Relates to	Notes
RemoteID	string	-	-
InvoiceRemoteID	string	Invoice → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
InvoiceID	string	Invoice → ID	-
CnID	string	CreditNote → ID	-
CnReasonCode	string	-	-
CnCreateReasonCode	string	-	-
CnDate	long	-	-
WhenCNDate	datetime	-	-
CnTotal	long	-	-
CnStatus	string	-	-

InvoiceIssuedCreditNote

Column	Type	Relates to	Notes
RemoteID	string	-	-
InvoiceRemoteID	string	Invoice → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
InvoiceID	string	Invoice → ID	-
CnID	string	CreditNote → ID	-
CnReasonCode	string	-	-
CnCreateReasonCode	string	-	-
CnDate	long	-	-
WhenCNDate	datetime	-	-
CnTotal	long	-	-
CnStatus	string	-	-

InvoiceLinkedOrder

Column	Type	Relates to	Notes
RemoteID	string	-	-
InvoiceRemoteID	string	Invoice → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	string	Order → ID	-
InvoiceID	string	Invoice → ID	-
DocumentNumber	string	-	-
Status	string	-	-
OrderType	string	-	-
ReferenceID	string	-	-
FulfillmentStatus	string	-	-
BatchID	string	-	-
CreatedAt	long	-	-
WhenCreatedAt	datetime	-	-

InvoiceNote

Column	Type	Relates to	Notes
RemoteID	string	-	-
InvoiceRemoteID	string	Invoice → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
InvoiceID	string	Invoice → ID	-
Iterator	int	-	-
EntityType	string	-	-
Note	string	-	-
EntityID	string	-	-
CouponID	string	Coupon → ID	-
SubscriptionID	string	Subscription → ID	-
CustomerID	string	Customer → ID	-
ItemPriceID	string	ItemPrice → ID	-
TaxID	string	-	-

InvoiceShippingAddress

Column	Type	Relates to	Notes
RemoteID	string	-	-
InvoiceRemoteID	string	Invoice → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
InvoiceID	string	Invoice → ID	-
Iterator	int	-	-
FirstName	string	-	-
LastName	string	-	-
Email	string	-	-
Company	string	-	-
Phone	string	-	-
Line1	string	-	-
Line2	string	-	-
Line3	string	-	-
City	string	-	-
StateCode	string	-	-
State	string	-	-
Country	string	-	-
Zip	string	-	-
ValidationStatus	string	-	-
Index	int	-	-

StatementDescriptor

Column	Type	Relates to	Notes
RemoteID	string	-	-
InvoiceRemoteID	string	Invoice → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	string	-	-
InvoiceID	string	Invoice → ID	-
Descriptor	string	-	-

InvoiceBillingAddress

Column	Type	Relates to	Notes
RemoteID	string	-	-
InvoiceRemoteID	string	Invoice → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
InvoiceID	string	Invoice → ID	-
Iterator	int	-	-
FirstName	string	-	-
LastName	string	-	-
Email	string	-	-
Company	string	-	-
Phone	string	-	-
Line1	string	-	-
Line2	string	-	-
Line3	string	-	-
City	string	-	-
StateCode	string	-	-
State	string	-	-
Country	string	-	-
Zip	string	-	-
ValidationStatus	string	-	-

InvoiceEInvoice

Column	Type	Relates to	Notes
RemoteID	string	-	-
InvoiceRemoteID	string	Invoice → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	string	-	-
InvoiceID	string	Invoice → ID	-
ReferenceNumber	string	-	-
Status	string	-	-
Message	string	-	-

ItemCustomField

Column	Type	Relates to	Notes
RemoteID	string	-	-
ItemRemoteID	string	Item → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
Name	string	-	-
ItemID	string	Item → ID	-
Value	string	-	-

ItemApplicableItem

Column	Type	Relates to	Notes
RemoteID	string	-	-
ItemRemoteID	string	Item → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	string	Item → ID	-
ItemID	string	Item → ID	-

ItemBundleItem

Column	Type	Relates to	Notes
RemoteID	string	-	-
ItemRemoteID	string	Item → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ParentItemID	string	Item → ID	-
BundleItemID	string	Item → ID	-
ItemType	string	-	-
Quantity	int	-	-
PriceAllocation	decimal	-	-

AttachedItem

Documentation: https://apidocs.chargebee.com/docs/api/attached_items

Column	Type	Relates to	Notes
RemoteID	string	-	-
ItemRemoteID	string	Item → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	string	-	-
ParentItemID	string	Item → ID	-
ItemID	string	Item → ID	-
Type	string	-	-
Status	string	-	-
Quantity	int	-	-
QuantityInDecimal	decimal	-	-
BillingCycles	int	-	-
ChargeOnEvent	string	-	-
ChargeOnce	boolean	-	-
CreatedAt	long	-	-
WhenCreatedAt	datetime	-	-
ResourceVersion	long	-	-
UpdatedAt	long	-	-
WhenUpdatedAt	datetime	-	-
Channel	string	-	-
BusinessEntityID	string	BusinessEntity → ID	-

ItemFamilyCustomField

Column	Type	Relates to	Notes
RemoteID	string	-	-
ItemFamilyRemoteID	string	ItemFamily → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
Name	string	-	-
ItemFamilyID	string	ItemFamily → ID	-
Value	string	-	-

ItemPriceTier

Column	Type	Relates to	Notes
RemoteID	string	-	-
ItemPriceRemoteID	string	ItemPrice → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ItemPriceID	string	ItemPrice → ID	-
Iterator	int	-	-
StartingUnit	int	-	-
EndingUnit	int	-	-
Price	long	-	-

ItemPriceTaxProvidersField

Column	Type	Relates to	Notes
RemoteID	string	-	-
ItemPriceRemoteID	string	ItemPrice → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ItemPriceID	string	ItemPrice → ID	-
FieldID	string	-	-
ProviderName	string	-	-
FieldValue	string	-	-

OrderLineItem

Column	Type	Relates to	Notes
RemoteID	string	-	-
OrderRemoteID	string	Order → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	string	-	-
Description	string	-	-
OrderID	string	Order → ID	-
InvoiceID	string	Invoice → ID	-
InvoiceLineItemID	string	InvoiceLineItem → ID	-
UnitPrice	long	-	-
Amount	long	-	-
FulfillmentQuantity	int	-	-
FulfillmentAmount	long	-	-
TaxAmount	long	-	-
AmountPaid	long	-	-
AmountAdjusted	long	-	-
RefundableCreditsIssued	long	-	-
RefundableCredits	long	-	-
IsShippable	boolean	-	-
Sku	string	-	-
Status	string	-	-
EntityType	string	-	-
ItemLevelDiscountAmount	long	-	-
DiscountAmount	long	-	-
EntityID	string	ItemPrice → ID	-

OrderShippingAddress

Column	Type	Relates to	Notes
RemoteID	string	-	-
OrderRemoteID	string	Order → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
OrderID	string	Order → ID	-
Iterator	int	-	-
FirstName	string	-	-
LastName	string	-	-
Email	string	-	-
Company	string	-	-
Phone	string	-	-
Line1	string	-	-
Line2	string	-	-
Line3	string	-	-
City	string	-	-
StateCode	string	-	-
State	string	-	-
Country	string	-	-
Zip	string	-	-
ValidationStatus	string	-	-
Index	int	-	-

OrderBillingAddress

Column	Type	Relates to	Notes
RemoteID	string	-	-
OrderRemoteID	string	Order → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
OrderID	string	Order → ID	-
Iterator	int	-	-
FirstName	string	-	-
LastName	string	-	-
Email	string	-	-
Company	string	-	-
Phone	string	-	-
Line1	string	-	-
Line2	string	-	-
Line3	string	-	-
City	string	-	-
StateCode	string	-	-
State	string	-	-
Country	string	-	-
Zip	string	-	-
ValidationStatus	string	-	-

OrderLineItemTax

Column	Type	Relates to	Notes
RemoteID	string	-	-
OrderRemoteID	string	Order → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
OrderID	string	Order → ID	-
LineItemID	string	OrderLineItem → ID	-
TaxName	string	-	-
TaxRate	decimal	-	-
DateTo	long	-	-
WhenDateTo	datetime	-	-
DateFrom	long	-	-
WhenDateFrom	datetime	-	-
ProratedTaxableAmount	decimal	-	-
IsPartialTaxApplied	boolean	-	-
IsNonComplianceTax	boolean	-	-
TaxableAmount	long	-	-
TaxAmount	long	-	-
TaxJurisType	string	-	-
TaxJurisName	string	-	-
TaxJurisCode	string	-	-
TaxAmountInLocalCurrency	long	-	-
LocalCurrencyCode	string	-	-

OrderLineItemDiscount

Column	Type	Relates to	Notes
RemoteID	string	-	-
OrderRemoteID	string	Order → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
OrderID	string	Order → ID	-
LineItemID	string	OrderLineItem → ID	-
DiscountType	string	-	-
EntityID	string	-	-
CouponID	string	Coupon → ID	-
DiscountID	string	SubscriptionDiscount → ID	-
DiscountAmount	long	-	-

OrderLineItemLinkedCreditNote

Column	Type	Relates to	Notes
RemoteID	string	-	-
OrderRemoteID	string	Order → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	string	-	-
OrderID	string	Order → ID	-
Amount	long	-	-
Type	string	-	-
Status	string	-	-
AmountAdjusted	long	-	-
AmountRefunded	long	-	-

OrderResentOrder

Column	Type	Relates to	Notes
RemoteID	string	-	-
OrderRemoteID	string	Order → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ParentOrderID	string	Order → ID	-
ResentOrderID	string	Order → ID	-
Reason	string	-	-
Amount	long	-	-

PaymentSourceCard

Column	Type	Relates to	Notes
RemoteID	string	-	-
PaymentSourceRemoteID	string	PaymentSource → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
PaymentSourceID	string	PaymentSource → ID	-
Last4	string	-	-
FirstName	string	-	-
LastName	string	-	-
Iin	string	-	-
Brand	string	-	-
FundingType	string	-	-
ExpiryMonth	int	-	-
ExpiryYear	int	-	-
BillingAddr1	string	-	-
BillingAddr2	string	-	-
BillingCity	string	-	-
BillingStateCode	string	-	-
BillingState	string	-	-
BillingCountry	string	-	-
BillingZip	string	-	-
MaskedNumber	string	-	-

PaymentSourceBankAccount

Column	Type	Relates to	Notes
RemoteID	string	-	-
PaymentSourceRemoteID	string	PaymentSource → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
PaymentSourceID	string	PaymentSource → ID	-
Last4	string	-	-
NameOnAccount	string	-	-
FirstName	string	-	-
LastName	string	-	-
DirectDebitScheme	string	-	-
BankName	string	-	-
MandateID	string	-	-
AccountType	string	-	-
EcheckType	string	-	-
AccountHolderType	string	-	-
Email	string	-	-

PaymentSourceBillingAddress

Column	Type	Relates to	Notes
RemoteID	string	-	-
PaymentSourceRemoteID	string	PaymentSource → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
PaymentSourceID	string	PaymentSource → ID	-
FirstName	string	-	-
LastName	string	-	-
Email	string	-	-
Company	string	-	-
Phone	string	-	-
Line1	string	-	-
Line2	string	-	-
Line3	string	-	-
City	string	-	-
StateCode	string	-	-
State	string	-	-
Country	string	-	-
Zip	string	-	-
ValidationStatus	string	-	-

PaymentSourceMandate

Column	Type	Relates to	Notes
RemoteID	string	-	-
PaymentSourceRemoteID	string	PaymentSource → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	string	-	-
PaymentSourceID	string	PaymentSource → ID	-
SubscriptionID	string	Subscription → ID	-
CreatedAt	long	-	-
WhenCreatedAt	datetime	-	-

PlanCustomField

Column	Type	Relates to	Notes
RemoteID	string	-	-
PlanRemoteID	string	Plan → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
Name	string	-	-
PlanID	string	Plan → ID	-
Value	string	-	-

PlanTier

Column	Type	Relates to	Notes
RemoteID	string	-	-
PlanRemoteID	string	Plan → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
PlanID	string	Plan → ID	-
StartingUnit	int	-	-
EndingUnit	int	-	-
Price	long	-	-
StartingUnitInDecimal	decimal	-	-
EndingUnitInDecimal	decimal	-	-
PriceInDecimal	decimal	-	-

PlanApplicableAddon

Column	Type	Relates to	Notes
RemoteID	string	-	-
PlanRemoteID	string	Plan → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	string	Addon → ID	-
PlanID	string	Plan → ID	-

PlanAttachedAddon

Column	Type	Relates to	Notes
RemoteID	string	-	-
PlanRemoteID	string	Plan → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	string	Addon → ID	-
PlanID	string	Plan → ID	-
Quantity	int	-	-
QuantityInDecimal	decimal	-	-
BillingCycles	int	-	-
Type	string	-	-

PlanEventBasedAddon

Column	Type	Relates to	Notes
RemoteID	string	-	-
PlanRemoteID	string	Plan → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	string	Addon → ID	-
PlanID	string	Plan → ID	-
Quantity	int	-	-
QuantityInDecimal	decimal	-	-
OnEvent	string	-	-
ChargeOnce	boolean	-	-

SubscriptionCustomField

Column	Type	Relates to	Notes
RemoteID	string	-	-
SubscriptionRemoteID	string	Subscription → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
Name	string	-	-
SubscriptionID	string	Subscription → ID	-
Value	string	-	-

SubscriptionItem

Column	Type	Relates to	Notes
RemoteID	string	-	-
SubscriptionRemoteID	string	Subscription → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
SubscriptionID	string	Subscription → ID	-
ItemPriceID	string	ItemPrice → ID	-
ItemType	string	-	-
Quantity	long	-	-
QuantityInDecimal	decimal	-	-
UnitPrice	long	-	-
UnitPriceInDecimal	decimal	-	-
Amount	long	-	-
AmountInDecimal	decimal	-	-
BillingPeriod	int	-	-
BillingPeriodUnit	string	-	-
FreeQuantity	long	-	-
FreeQuantityInDecimal	decimal	-	-
TrialEnd	long	-	-
WhenTrialEnd	datetime	-	-
BillingCycles	int	-	-
ServicePeriodDays	int	-	-
ChargeOnEvent	string	-	-
ChargeOnce	boolean	-	-
ChargeOnOption	string	-	-
ProrationType	string	-	-
UsageAccumulationResetFrequency	string	-	-

SubscriptionItemTier

Column	Type	Relates to	Notes
RemoteID	string	-	-
SubscriptionRemoteID	string	Subscription → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
SubscriptionID	string	Subscription → ID	-
ItemPriceID	string	ItemPrice → ID	-
StartingUnit	int	-	-
EndingUnit	int	-	-
Price	long	-	-
StartingUnitInDecimal	decimal	-	-
EndingUnitInDecimal	decimal	-	-
PriceInDecimal	decimal	-	-
Index	int	-	-

SubscriptionChargedItem

Column	Type	Relates to	Notes
RemoteID	string	-	-
SubscriptionRemoteID	string	Subscription → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
SubscriptionID	string	Subscription → ID	-
ItemPriceID	string	ItemPrice → ID	-
LastChargedAt	long	-	-
WhenLastChargedAt	datetime	-	-

SubscriptionCoupon

Column	Type	Relates to	Notes
RemoteID	string	-	-
SubscriptionRemoteID	string	Subscription → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
SubscriptionID	string	Subscription → ID	-
CouponID	string	-	-
ApplyUntil	long	-	-
WhenApplyUntil	datetime	-	-
AppliedCount	int	-	-
CouponCode	string	-	-

SubscriptionShippingAddress

Column	Type	Relates to	Notes
RemoteID	string	-	-
SubscriptionRemoteID	string	Subscription → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
SubscriptionID	string	Subscription → ID	-
Iterator	int	-	-
FirstName	string	-	-
LastName	string	-	-
Email	string	-	-
Company	string	-	-
Phone	string	-	-
Line1	string	-	-
Line2	string	-	-
Line3	string	-	-
City	string	-	-
StateCode	string	-	-
State	string	-	-
Country	string	-	-
Zip	string	-	-
ValidationStatus	string	-	-
Index	int	-	-

SubscriptionReferralInfo

Column	Type	Relates to	Notes
RemoteID	string	-	-
SubscriptionRemoteID	string	Subscription → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
SubscriptionID	string	Subscription → ID	-
Iterator	int	-	-
ReferralCode	string	-	-
CouponCode	string	-	-
ReferrerID	string	-	-
ExternalReferenceID	string	-	-
RewardStatus	string	-	-
ReferralSystem	string	-	-
AccountID	string	-	-
CampaignID	string	-	-
ExternalCampaignID	string	-	-
FriendOfferType	string	-	-
ReferrerRewardType	string	-	-
NotifyReferralSystem	string	-	-
DestinationUrl	string	-	-
PostPurchaseWidgetEnabled	boolean	-	-

SubscriptionContractTerm

Column	Type	Relates to	Notes
RemoteID	string	-	-
SubscriptionRemoteID	string	Subscription → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	string	-	-
SubscriptionID	string	Subscription → ID	-
Status	string	-	-
ContractStart	long	-	-
WhenContractStart	datetime	-	-
ContractEnd	long	-	-
WhenContractEnd	datetime	-	-
BillingCycle	int	-	-
ActionAtTermEnd	string	-	-
TotalContractValue	long	-	-
TotalContractValueBeforeTax	long	-	-
CancellationCutoffPeriod	int	-	-
CreatedAt	long	-	-
WhenCreatedAt	datetime	-	-
RemainingBillingCycles	int	-	-

SubscriptionDiscount

Column	Type	Relates to	Notes
RemoteID	string	-	-
SubscriptionRemoteID	string	Subscription → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	string	-	-
SubscriptionID	string	Subscription → ID	-
InvoiceName	string	-	-
Type	string	-	-
Percentage	decimal	-	-
Amount	long	-	-
CurrencyCode	string	-	-
DurationType	string	-	-
Period	int	-	-
PeriodUnit	string	-	-
IncludedInMrr	boolean	-	-
ApplyOn	string	-	-
ItemPriceID	string	ItemPrice → ID	-
CreatedAt	long	-	-
WhenCreatedAt	datetime	-	-
ApplyTill	long	-	-
AppliedCount	int	-	-
CouponID	string	Coupon → ID	-
Index	int	-	-

TransactionLinkedInvoice

Column	Type	Relates to	Notes
RemoteID	string	-	-
TransactionRemoteID	string	Transaction → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
TransactionID	string	Transaction → ID	-
InvoiceID	string	Invoice → ID	-
AppliedAmount	long	-	-
AppliedAt	long	-	-
WhenAppliedAt	datetime	-	-
InvoiceDate	long	-	-
WhenInvoiceDate	datetime	-	-
InvoiceTotal	long	-	-
InvoiceStatus	string	-	-

TransactionLinkedCreditNote

Column	Type	Relates to	Notes
RemoteID	string	-	-
TransactionRemoteID	string	Transaction → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
TransactionID	string	Transaction → ID	-
CnID	string	CreditNote → ID	-
AppliedAmount	long	-	-
AppliedAt	long	-	-
WhenAppliedAt	datetime	-	-
CnReasonCode	string	-	-
CnCreateReasonCode	string	-	-
CnDate	long	-	-
WhenCreditNoteDate	datetime	-	-
CnTotal	long	-	-
CnStatus	string	-	-
RnReferenceInvoiceID	string	Invoice → ID	-

TransactionLinkedRefund

Column	Type	Relates to	Notes
RemoteID	string	-	-
TransactionRemoteID	string	Transaction → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
TransactionID	string	Transaction → ID	-
TxnID	string	Transaction → ID	-
TxnStatus	string	-	-
TxnAmount	long	-	-
TxnDate	long	-	-
WhenTransactionDate	datetime	-	-

TransactionLinkedPayment

Column	Type	Relates to	Notes
RemoteID	string	-	-
TransactionRemoteID	string	Transaction → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
ID	string	-	-
TransactionID	string	Transaction → ID	-
Status	string	-	-
Amount	long	-	-
Date	long	-	-
WhenDate	datetime	-	-

TransactionErrorDetails

Column	Type	Relates to	Notes
RemoteID	string	-	-
TransactionRemoteID	string	Transaction → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
TransactionID	string	Transaction → ID	-
Iterator	int	-	-
RequestID	string	-	-
ErrorCategory	string	-	-
ErrorCode	string	-	-
ErrorMessage	string	-	-
DeclineCode	string	-	-
DeclineMessage	string	-	-
NetworkErrorCode	string	-	-
NetworkErrorMessage	string	-	-
ErrorField	string	-	-
RecommendationCode	string	-	-
RecommendationMessage	string	-	-
ProcessorErrorCode	string	-	-
ProcessorErrorMessage	string	-	-
ErrorCauseID	string	-	-
ErrorCauseCustomerMessage	string	-	-
ErrorCauseMerchantMessage	string	-	-

UnbilledChargeTier

Column	Type	Relates to	Notes
RemoteID	string	-	-
UnbilledChargeRemoteID	string	UnbilledCharge → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
UnbilledChargeID	string	UnbilledCharge → ID	-
Iterator	int	-	-
StartingUnit	int	-	-
EndingUnit	int	-	-
QuantityUsed	int	-	-
UnitAmount	long	-	-
StartingUnitInDecimal	decimal	-	-
EndingUnitInDecimal	decimal	-	-
QuantityUsedInDecimal	decimal	-	-
UnitAmountInDecimal	decimal	-	-

CouponItemConstraintItemPrice

Column	Type	Relates to	Notes
RemoteID	string	-	-
CouponItemConstraintRemoteID	string	CouponItemConstraint → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
CouponItemConstraintID	string	CouponItemConstraint → RemoteID	-
ItemPriceID	string	ItemPrice → ID	-

CouponItemConstraintCriteriaCurrency

Column	Type	Relates to	Notes
RemoteID	string	-	-
CouponItemConstraintCriteriaRemoteID	string	CouponItemConstraintCriteria → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
CouponItemConstraintCriteriaID	string	CouponItemConstraintCriteria → RemoteID	-
Currency	string	-	-

CouponItemConstraintCriteriaItemFamily

Column	Type	Relates to	Notes
RemoteID	string	-	-
CouponItemConstraintCriteriaRemoteID	string	CouponItemConstraintCriteria → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
CouponItemConstraintCriteriaID	string	CouponItemConstraintCriteria → RemoteID	-
ItemFamilyID	string	ItemFamily → ID	-

CouponItemConstraintCriteriaItemPricePeriod

Column	Type	Relates to	Notes
RemoteID	string	-	-
CouponItemConstraintCriteriaRemoteID	string	CouponItemConstraintCriteria → RemoteID	-
WhenUpsertedIntoDataStore	datetime	-	-
MirrorRemoteID	int	-	-
IsDeleted	boolean	-	-
WhenCreated	datetime	-	-
WhenModified	datetime	-	-
CouponItemConstraintCriteriaID	string	CouponItemConstraintCriteria → RemoteID	-
Iterator	int	-	-
ItemPricePeriod	string	-	-