Exclusive: all our customers get a free six-month subscription to EDNA, a next-gen data and AI learning platform

Explore the Paypal API data model

See how the various Paypal endpoints relate to each other, using our handy Entity Relationship Diagram

Try our interactive ERD Or, browse below

Pulling data from the Paypal 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 Paypal 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.

Endpoints

Dispute

Documentation: https://developer.paypal.com/docs/api/customer-disputes/v1/

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
DisputeID string - -
ExternalReasonCode string - -
CreatedTime datetime - -
UpdatedTime datetime - -
Reason string - -
Status string - -
DisputeAmountCurrencyCode string - -
DisputeAmountValue decimal - -
DisputeAssetAssetSymbol string - -
DisputeAssetQuantity decimal - -
TransactionFee string - -
DisputeCoutcomeCode string - -
DisputeOutcomeAmountRefundedCurrencyCode string - -
DisputeOutcomeAmountRefundedValue decimal - -
DisputeOutcomeAssetRefundedSymbol string - -
DisputeOutcomeAssetRefundedQuantity string - -
DisputeLifeCycleStage string - -
DisputeChannel string - -
MerchantContacted boolean - -
BuyerContactedChannel string - -
MerchantContactedOutcome string - -
MerchantContactedTime datetime - -
MerchantContactedMode string - -
BuyerContactedTime datetime - -
BuyerResponseDueDate datetime - -
SellerResponseDueDate datetime - -
OfferBuyerRequestedAmountCurrencyCode string - -
OfferBuyerRequestedAmountValue decimal - -
OfferSellerOfferedAmountCurrencyCode string - -
OfferSellerOfferedAmountValue decimal - -
OfferType string - -
RefundCurrencyCode string - -
RefundValue decimal - -
Note string - -
Email string - -
TimePosted datetime - -
AllowedResponseAcknowledgeReturnItemTypes string - -
AllowedResponseOfferTypes string - -

Invoice

Documentation: https://developer.paypal.com/docs/api/invoicing/v2/

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string - -
ParentID string Invoice → ID -
Status string - -
Reference string - -
Note string - -
TermsAndConditions string - -
Memo string - -
CurrencyCode string - -
InvoiceNumber string - -
InvoiceDate datetime - -
PaymentTermType string - -
PaymentTermDueDate datetime - -
CreatedBy string - -
LastUpdatedBy string - -
CreateTime datetime - -
LastUpdateTime datetime - -
CancelledBy string - -
LastSentBy string - -
RecipientViewUrl string - -
InvoicerViewUrl string - -
CancelTime datetime - -
FirstSentTime datetime - -
LastSentTime datetime - -
CreatedByFlow string - -
TaxCalculatedAfterDiscount boolean - -
TaxInclusive boolean - -
AllowTip boolean - -
AllowPartialPayment boolean - -
PartialPaymentMinimumAmountDueCurrencyCode string - -
PartialPaymentMinimumAmountDueValue decimal - -
TemplateID string Template → ID -
AmountCurrencyCode string - -
AmountValue decimal - -
ItemTotalAmountCurrencyCode string - -
ItemTotalAmountValue decimal - -
InvoiceDiscountPercent decimal - -
InvoiceDiscountAmountCurrencyCode string - -
InvoiceDiscountAmountValue decimal - -
ItemDiscountCurrencyCode string - -
ItemDiscountValue decimal - -
TaxTotalCurrencyCode string - -
TaxTotalValue decimal - -
ShippingAmountCurrencyCode string - -
ShippingAmountValue decimal - -
ShippingTaxName string - -
ShippingTaxNote string - -
ShippingTaxPercent decimal - -
ShippingTaxAmountCurrencyCode string - -
ShippingTaxAmountValue decimal - -
CustomAmountLabel string - -
CustomAmountCurrencyCode string - -
CustomAmountValue decimal - -
DueAmountCurrencyCode string - -
DueAmountValue decimal - -
GratuityCurrencyCode string - -
GratuityValue decimal - -

Plan

Documentation: https://developer.paypal.com/docs/api/catalog-products/v1/

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string - -
Name string - -
Description string - -
ProductID string Product → ID -
Status string - -
QuantitySupported boolean - -
AutoBillOutstanding boolean - -
SetupFeeFailureAction string - -
PaymentFailureThreshold int - -
SetupFeeCurrencyCode string - -
SetupFeeValue string - -
TaxInclusive boolean - -
TaxPercentage decimal - -
CreateTime datetime - -
UpdateTime datetime - -

Product

Documentation: https://developer.paypal.com/docs/api/catalog-products/v1/

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string - -
Name string - -
Description string - -
Type string - -
Category string - -
ImageUrl string - -
HomeUrl string - -
CreateTime datetime - -
UpdateTime datetime - -

Template

Documentation: https://developer.paypal.com/docs/api/invoicing/v2/

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string - -
Name string - -
DefaultTemplate boolean - -
StandardTemplate boolean - -
Reference string - -
Note string - -
TermsAndConditions string - -
Memo string - -
CurrencyCode string - -
PaymentTermType string - -
CreatedBy string - -
LastUpdatedBy string - -
CreateTime datetime - -
LastUpdateTime datetime - -
InvoicerBusinessName string - -
InvoicerNamePrefix string - -
InvoicerGivenName string - -
InvoicerSurname string - -
InvoicerMiddleName string - -
InvoicerNameSuffix string - -
InvoicerAlternateFullName string - -
InvoicerFullName string - -
InvoicerAddressLine1 string - -
InvoicerAddressLine2 string - -
InvoicerAddressLine3 string - -
InvoicerAddressAdminArea4 string - -
InvoicerAddressAdminArea3 string - -
InvoicerAddressAdminArea2 string - -
InvoicerAddressAdminArea1 string - -
InvoicerAddressPostalCode string - -
InvoicerAddressCountryCode string - -
InvoicerAddressStreetNumber string - -
InvoicerAddressStreetName string - -
InvoicerAddressStreetType string - -
InvoicerAddressDeliveryService string - -
InvoicerAddressBuildingName string - -
InvoicerAddressSubBuilding string - -
InvoicerWebsite string - -
InvoicerTaxID string - -
InvoicerAdditionalNotes string - -
InvoicerLogoUrl string - -
InvoicerEmailAddress string - -
TaxCalculatedAfterDiscount boolean - -
TaxInclusive boolean - -
AllowTip boolean - -
AllowPartialPayment boolean - -
PartialPaymentMinimumAmountDueCurrencyCode string - -
PartialPaymentMinimumAmountDueValue decimal - -
AmountCurrencyCode string - -
AmountValue string - -
ItemTotalCurrencyCode string - -
ItemTotalValue decimal - -
InvoiceDiscountPercent decimal - -
InvoiceDiscountCurrencyCode string - -
InvoiceDiscountValue decimal - -
ItemDiscountCurrencyCode string - -
ItemDiscountValue decimal - -
TaxTotalCurrencyCode string - -
TaxTotalValue decimal - -
ShippingAmountCurrencyCode string - -
ShippingAmountValue decimal - -
ShippingName string - -
ShippingTaxNote string - -
ShippingTaxPercent decimal - -
ShippingTaxAmountCurrencyCode string - -
ShippingTaxAmountValue decimal - -
CustomLabel string - -
CustomAmountCurrencyCode string - -
CustomAmountValue decimal - -
DueAmountCurrencyCode string - -
DueAmountValue decimal - -
UnitOfMeasure string - -

DisputedTransaction

Column Type Relates to Notes
RemoteID string - -
DisputeRemoteID string Dispute → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
DisputeID string Dispute → DisputeID -
BuyerTransactionID string - -
SellerTransactionID string - -
ReferenceID string - -
TransactionStatus string - -
InvoiceNumber string - -
Custom string - -
CreateTime datetime - -
GrossAmountCurrencyCode string - -
GrossAmountValue decimal - -
GrossAssetAssetSymbol string - -
GrossAssetQuantity decimal - -
BuyerName string - -
SellerMerchantID string - -
SellerName string - -
SellerEmail string - -

DisputeAdjudication

Column Type Relates to Notes
RemoteID string - -
DisputeRemoteID string Dispute → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
DisputeID string Dispute → DisputeID -
Iterator int - -
Type string - -
AdjudicationTime datetime - -
Reason string - -
DisputeLifeCycleStage string - -

DisputeMoneyMovement

Column Type Relates to Notes
RemoteID string - -
DisputeRemoteID string Dispute → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
DisputeID string Dispute → DisputeID -
Iterator int - -
AffectedParty string - -
Type string - -
AmountCurrencyCode string - -
AmountValue decimal - -
AssetAssetSymbol string - -
AssetQuantity decimal - -
InitiatedTime datetime - -
Reason string - -

DisputeMessage

Column Type Relates to Notes
RemoteID string - -
DisputeRemoteID string Dispute → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
DisputeID string Dispute → DisputeID -
Iterator int - -
PostedBy string - -
Content string - -
TimePosted datetime - -

DisputeEvidence

Column Type Relates to Notes
RemoteID string - -
DisputeRemoteID string Dispute → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
DisputeID string Dispute → DisputeID -
Iterator int - -
EvidenceType string - -
Notes string - -
Source string - -
ItemID string - -
Date datetime - -
ItemType string - -
ActionInfoAction string - -
ActionInfoResponseOption string - -
ActionInfoMandatory boolean - -
DisputeLifeCycleStage string - -

DisputeSupportingInfo

Column Type Relates to Notes
RemoteID string - -
DisputeRemoteID string Dispute → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
DisputeID string Dispute → DisputeID -
Iterator int - -
Notes string - -
Source string - -
ProvidedTime datetime - -
DisputeLifeCycleStage string - -

DisputeOfferHistory

Column Type Relates to Notes
RemoteID string - -
DisputeRemoteID string Dispute → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
DisputeID string Dispute → DisputeID -
Iterator int - -
Actor string - -
EventType string - -
Notes string - -
OfferTime datetime - -
OfferType string - -
OfferAmountCurrencyCode string - -
OfferAmountValue decimal - -
DisputeLifeCycleStage string - -

InvoicePrimaryRecipient

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 - -

InvoiceAdditionalRecipient

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 - -
EmailAddress string - -

InvoiceItem

Column Type Relates to Notes
RemoteID string - -
InvoiceRemoteID string Invoice → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string - -
Name string - -
Description string - -
InvoiceID string Invoice → ID -
Quantity decimal - -
UnitAmountCurrencyCode string - -
UnitAmountValue decimal - -
TaxName string - -
TaxNote string - -
TaxPercent decimal - -
TaxAmountCurrencyCode string - -
TaxAmountValue decimal - -
ItemDate datetime - -
DiscountPercent decimal - -
DiscountAmountCurrencyCode string - -
DiscountAmountValue decimal - -
UnitOfMeasure string - -

InvoiceAttachment

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 -
ReferenceUrl string - -
ContentType string - -
Size string - -
CreateTime datetime - -

InvoicePayment

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 - -
PaidAmountCurrencyCode string - -
PaidAmountValue decimal - -

InvoiceRefund

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 - -
RefundAmountCurrencyCode string - -
RefundAmountValue decimal - -

InvoiceInvoicer

Column Type Relates to Notes
RemoteID string - -
InvoiceRemoteID string Invoice → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
InvoiceID string Invoice → RemoteID -
Iterator int - -
BusinessName string - -
Prefix string - -
GivenName string - -
FirstName string - -
Surname string - -
MiddleName string - -
Suffix string - -
AlternateFullName string - -
FullName string - -
AddressLine1 string - -
AddressLine2 string - -
AddressLine3 string - -
AdminArea4 string - -
AdminArea3 string - -
AdminArea2 string - -
AdminArea1 string - -
PostalCode string - -
CountryCode string - -
StreetNumber string - -
StreetName string - -
StreetType string - -
DeliveryService string - -
BuildingName string - -
SubBuilding string - -
Website string - -
TaxID string - -
AdditionalNotes string - -
LogoUrl string - -
EmailAddress string - -

PlanBillingCycle

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 -
Iterator int - -
TenureType string - -
Sequence int - -
TotalCycles int - -
PricingSchemeVersion int - -
PricingModel string - -
FixedPriceCurrencyCode string - -
FixedPriceValue string - -
PricingSchemeCreateTime datetime - -
PricingSchemeUpdateTime datetime - -
FrequencyIntervalUnit string - -
FrequencyIntervalCount int - -

TemplatePrimaryRecipient

Column Type Relates to Notes
RemoteID string - -
TemplateRemoteID string Template → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
TemplateID string Template → ID -
Iterator int - -
BillingBusinessName string - -
BillingNamePrefix string - -
BillingGivenName string - -
BillingSurname string - -
BillingMiddleName string - -
BillingNameSuffix string - -
BillingAlternateFullName string - -
BillingFullName string - -
BillingAddressLine1 string - -
BillingAddressLine2 string - -
BillingAddressLine3 string - -
BillingAddressAdminArea4 string - -
BillingAddressAdminArea3 string - -
BillingAddressAdminArea2 string - -
BillingAddressAdminArea1 string - -
BillingAddressPostalCode string - -
BillingAddressCountryCode string - -
BillingAddressStreetNumber string - -
BillingAddressStreetName string - -
BillingAddressStreetType string - -
BillingAddressDeliveryService string - -
BillingAddressBuildingName string - -
BillingAddressSubBuilding string - -
BillingAdditionalInfo string - -
BillingEmailAddress string - -
BillingLanguage string - -
ShippingBusinessName string - -
ShippingNamePrefix string - -
ShippingGivenName string - -
ShippingSurname string - -
ShippingMiddleName string - -
ShippingNameSuffix string - -
ShippingAlternateFullName string - -
ShippingFullName string - -
ShippingAddressLine1 string - -
ShippingAddressLine2 string - -
ShippingAddressLine3 string - -
ShippingAddressAdminArea4 string - -
ShippingAddressAdminArea3 string - -
ShippingAddressAdminArea2 string - -
ShippingAddressAdminArea1 string - -
ShippingAddressPostalCode string - -
ShippingAddressCountryCode string - -
ShippingAddressStreetNumber string - -
ShippingAddressStreetName string - -
ShippingAddressStreetType string - -
ShippingAddressDeliveryService string - -
ShippingAddressBuildingName string - -
ShippingAddressSubBuilding string - -

TemplateAdditionalRecipient

Column Type Relates to Notes
RemoteID string - -
TemplateRemoteID string Template → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
TemplateID string Template → ID -
Iterator int - -
Email string - -

TemplateItem

Column Type Relates to Notes
RemoteID string - -
TemplateRemoteID string Template → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string - -
Name string - -
Description string - -
TemplateID string Template → ID -
Quantity decimal - -
UnitAmountCurrencyCode string - -
UnitAmountValue decimal - -
TaxName string - -
TaxNote string - -
TaxPercent decimal - -
TaxAmountCurrencyCode string - -
TaxAmountValue decimal - -
ItemDate datetime - -
DiscountPercent decimal - -
DicountCurrencyCode string - -
DiscountValue decimal - -
UnitOfMeasure string - -

TemplateAttachment

Column Type Relates to Notes
RemoteID string - -
TemplateRemoteID string Template → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string - -
TemplateID string Template → ID -
ReferenceUrl string - -
ContentType string - -
Size string - -
CreateTime datetime - -

TemplateInvoicerPhone

Column Type Relates to Notes
RemoteID string - -
TemplateRemoteID string Template → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
TemplateID string Template → ID -
Iterator int - -
CountryCode string - -
NationalNumber string - -
ExtensionNumber string - -
PhoneType string - -

TemplateItemSetting

Column Type Relates to Notes
RemoteID string - -
TemplateRemoteID string Template → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
TemplateID string Template → ID -
Iterator int - -
FieldName string - -
FieldHidden boolean - -

TemplateSubtotalSetting

Column Type Relates to Notes
RemoteID string - -
TemplateRemoteID string Template → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
TemplateID string Template → ID -
Iterator int - -
FieldName string - -
FieldHidden boolean - -

TransactionShippingInfo

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Name string - -
TransactionRemoteID string Transaction → RemoteID -
Iterator int - -
Method string - -
AddressLine1 string - -
AddressLine2 string - -
AddressCity string - -
AddressState string - -
AddressCountryCode string - -
AddressPostalCode string - -
SecondaryShippingAddressLine1 string - -
SecondaryShippingAddressLine2 string - -
SecondaryShippingAddressCity string - -
SecondaryShippingAddressState string - -
SecondaryShippingAddressCountryCode string - -
SecondaryShippingAddressPostalCode string - -

ItemDetails

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
TransactionRemoteID string Transaction → RemoteID -
Iterator int - -
ItemCode string - -
ItemName string - -
ItemDecsription string - -
ItemOptions string - -
ItemQuality string - -
InvoiceNumber string - -
TaxPercentage decimal - -
ItemUnitPriceCurrencyCode string - -
ItemUnitPriceValue decimal - -
ItemAmountCurrencyCode string - -
ItemAmountValue decimal - -
DiscountAmountCurrencyCode string - -
DiscountAmountValue decimal - -
AdjustmentAmountCurrencyCode string - -
AdjustmentAmountValue decimal - -
GiftWrapAmountCurrencyCode string - -
GiftWrapAmountValue decimal - -
BasicShippingAmountCurrencyCode string - -
BasicShippingAmountValue decimal - -
ExtraShippingAmountCurrencyCode string - -
ExtraShippingAmountValue decimal - -
HandlingAmountCurrencyCode string - -
HandlingAmountValue decimal - -
InsuranceAmountCurrencyCode string - -
InsuranceAmountValue decimal - -
TotalItemAmountCurrencyCode string - -
TotalItemAmountValue decimal - -

TransactionIncentiveDetails

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
TransactionID string Transaction → TransactionID -
Iterator int - -
IncentiveCode string - -
IncentiveType string - -
IncentiveProgramCode string - -
IncentiveAmountCurrencyCode string - -
IncentiveAmountValue decimal - -

DisputedTransactionItem

Column Type Relates to Notes
RemoteID string - -
DisputedTransactionRemoteID string DisputedTransaction → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
DisputedTransactionID string DisputedTransaction → RemoteID -
ItemID string - -
ItemName string - -
ItemDescription string - -
ItemQuantity int - -
PartnerTransactionID string - -
Reason string - -
Notes string - -
ItemType string - -
DisputeAmountCurrencyCode string - -
DisputeAmountValue decimal - -

DisputeMessageDocument

Column Type Relates to Notes
RemoteID string - -
DisputeMessageRemoteID string DisputeMessage → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Name string - -
DisputeMessageID string DisputeMessage → RemoteID -
Iterator int - -
Url string - -

DisputeEvidenceDocument

Column Type Relates to Notes
RemoteID string - -
DisputeEvidenceRemoteID string DisputeEvidence → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Name string - -
DisputeEvidenceID string DisputeEvidence → RemoteID -
Iterator int - -
Url string - -

DisputeEvidenceInfo

Column Type Relates to Notes
RemoteID string - -
DisputeEvidenceRemoteID string DisputeEvidence → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
DisputeEvidenceID string DisputeEvidence → RemoteID -
Iterator int - -

DisputeSupportingInfoDocument

Column Type Relates to Notes
RemoteID string - -
DisputeSupportingInfoRemoteID string DisputeSupportingInfo → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Name string - -
DisputeSupportingInfoID string DisputeSupportingInfo → RemoteID -
Iterator int - -
Url string - -

InvoicePrimaryRecipientBillingInfo

Column Type Relates to Notes
RemoteID string - -
InvoicePrimaryRecipientRemoteID string InvoicePrimaryRecipient → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
InvoicePrimaryRecipientID string InvoicePrimaryRecipient → RemoteID -
Iterator int - -
BusinessName string - -
Prefix string - -
GivenName string - -
FirstName string - -
Surname string - -
MiddleName string - -
Suffix string - -
AlternateFullName string - -
FullName string - -
AddressLine1 string - -
AddressLine2 string - -
AddressLine3 string - -
AdminArea4 string - -
AdminArea3 string - -
AdminArea2 string - -
AdminArea1 string - -
PostalCode string - -
CountryCode string - -
StreetNumber string - -
StreetName string - -
StreetType string - -
DeliveryService string - -
BuildingName string - -
SubBuilding string - -
AdditionalInfo string - -
EmailAddress string - -
Language string - -

InvoicePrimaryRecipientShippingInfo

Column Type Relates to Notes
RemoteID string - -
InvoicePrimaryRecipientRemoteID string InvoicePrimaryRecipient → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
InvoicePrimaryRecipientID string InvoicePrimaryRecipient → RemoteID -
Iterator int - -
Prefix string - -
GivenName string - -
FirstName string - -
Surname string - -
MiddleName string - -
Suffix string - -
AlternateFullName string - -
FullName string - -
AddressLine1 string - -
AddressLine2 string - -
AddressLine3 string - -
AdminArea4 string - -
AdminArea3 string - -
AdminArea2 string - -
AdminArea1 string - -
PostalCode string - -
CountryCode string - -
StreetNumber string - -
StreetName string - -
StreetType string - -
DeliveryService string - -
BuildingName string - -
SubBuilding string - -

InvoicePaymentTransaction

Column Type Relates to Notes
RemoteID string - -
InvoicePaymentRemoteID string InvoicePayment → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
InvoicePaymentID string InvoicePayment → RemoteID -
Iterator int - -
PaymentID string - -
Note string - -
Type string - -
PaymentDate datetime - -
Method string - -
AmountCurrencyCode string - -
AmountValue decimal - -

InvoiceRefundTransaction

Column Type Relates to Notes
RemoteID string - -
InvoiceRefundRemoteID string InvoiceRefund → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
InvoiceRefundID string InvoiceRefund → RemoteID -
Iterator int - -
RefundID string - -
Type string - -
RefundDate datetime - -
Method string - -
AmountCurrencyCode string - -
AmountValue decimal - -

InvoiceInvoicerPhone

Column Type Relates to Notes
RemoteID string - -
InvoiceInvoicerRemoteID string InvoiceInvoicer → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
InvoiceInvoicerID string InvoiceInvoicer → RemoteID -
Iterator int - -
CountryCode string - -
NationalNumber string - -
ExtensionNumber string - -
PhoneType string - -

PlanBillingCyclePricingTier

Column Type Relates to Notes
RemoteID string - -
PlanBillingCycleRemoteID string PlanBillingCycle → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
PlanBillingCycleID string PlanBillingCycle → RemoteID -
Iterator int - -
StartingQuantity string - -
EndingQuantity string - -
CurrencyCode string - -
Value string - -

TemplatePrimaryRecipientBillingPhone

Column Type Relates to Notes
RemoteID string - -
TemplatePrimaryRecipientRemoteID string TemplatePrimaryRecipient → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
TemplateInfoPrimaryRecipientID string TemplatePrimaryRecipient → RemoteID -
Iterator int - -
CountryCode string - -
NationalNumber string - -
ExtensionNumber string - -
PhoneType string - -

DisputeEvidenceInfoTrackingInfo

Column Type Relates to Notes
RemoteID string - -
DisputeEvidenceInfoRemoteID string DisputeEvidenceInfo → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
DisputeEvidenceInfoID string DisputeEvidenceInfo → RemoteID -
Iterator int - -
CarrierName string - -
CarrierNameOther string - -
TrackingUrl string - -
TrackingNumber string - -

DisputeEvidenceInfoRefund

Column Type Relates to Notes
RemoteID string - -
DisputeEvidenceInfoRemoteID string DisputeEvidenceInfo → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
DisputeEvidenceInfoID string DisputeEvidenceInfo → RemoteID -
Iterator int - -
RefundID string - -

InvoiceRecipientBillingPhone

Column Type Relates to Notes
RemoteID string - -
InvoicePrimaryRecipientBillingInfoRemoteID string InvoicePrimaryRecipientBillingInfo → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
InvoicePrimaryRecipientBillingInfoID string InvoicePrimaryRecipientBillingInfo → RemoteID -
Iterator int - -
CountryCode string - -
NationalNumber string - -
ExtensionNumber string - -
PhoneType string - -

InvoicePaymentTransactionShippingInfo

Column Type Relates to Notes
RemoteID string - -
InvoicePaymentTransactionRemoteID string InvoicePaymentTransaction → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
InvoicePaymentTransactionID string InvoicePaymentTransaction → RemoteID -
Iterator int - -
Prefix string - -
GivenName string - -
FirstName string - -
Surname string - -
MiddleName string - -
Suffix string - -
AlternateFullName string - -
FullName string - -
AddressLine1 string - -
AddressLine2 string - -
AddressLine3 string - -
AdminArea4 string - -
AdminArea3 string - -
AdminArea2 string - -
AdminArea1 string - -
PostalCode string - -
CountryCode string - -
StreetNumber string - -
StreetName string - -
StreetType string - -
DeliveryService string - -
BuildingName string - -
SubBuilding string - -

Need more?

SyncHub lives and breathes APIs and data. Keep exploring using the links below.

Connect your own Paypal data Querying Paypal using regular SQL