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