ODBC Driver for Square

Build 24.0.9062

GiftCardActivities

Creates and lists gift card activities.

Columns

Name Type ReadOnly Description
Id [KEY] String True

The Square-assigned ID of the gift card activity.

Type String False

The type of gift card activity.

LocationId String False

The ID of the business location where the activity occurred.

GiftCardId String False

The gift card ID. When creating a gift card activity, gift_card_id is not required if gift_card_gan is specified.

GiftCardAccountNumber String False

The gift card account number (GAN). When creating a gift card activity, gift_card_gan is not required if gift_card_id is specified.

GiftCardBalanceMoneyAmount Int64 True

The final balance amount on the gift card after the action is completed.

GiftCardBalanceMoneyCurrency String True

The type of balance amount currency, in ISO 4217 format.

CreatedAt Datetime True

The timestamp when the gift card activity was created, in RFC 3339 format.

GiftCardActivityLoadMoneyAmount Int64 False

The amount of money added to the gift card. This value is a positive integer.

GiftCardActivityLoadMoneyCurrency String False

The type of currency, in ISO 4217 format.

GiftCardActivityLoadOrderId String False

The ID of the order that contains the GIFT_CARD line item.

GiftCardActivityLoadLineItemUid String False

The UID of the GIFT_CARD line item in the order that represents the additional funds for the gift card.

GiftCardActivityLoadReferenceId String False

A client-specified ID that associates the gift card activity with an entity in another system.

GiftCardActivityLoadBuyerPaymentInstrumentIds String False

The payment instrument IDs used to process the order for the additional funds, such as a credit card ID or bank account ID.

GiftCardActivityActivateMoneyAmount Int64 False

The amount of money added to the gift card. This value is a positive integer.

GiftCardActivityActivateMoneyCurrency String False

The type of currency, in ISO 4217 format.

GiftCardActivityActivateOrderId String False

The ID of the order that contains the GIFT_CARD line item.

GiftCardActivityActivateLineItemUid String False

The UID of the GIFT_CARD line item in the order that represents the gift card purchase.

GiftCardActivityActivateReferenceId String False

A client-specified ID that associates the gift card activity with an entity in another system.

GiftCardActivityActivateBuyerPaymentInstrumentIds String False

The payment instrument IDs used to process the gift card purchase, such as a credit card ID or bank account ID.

GiftCardActivityRedeemMoneyAmount Int64 False

The amount of money deducted from the gift card for the redemption. This value is a positive integer.

GiftCardActivityRedeemMoneyCurrency String False

The type of currency, in ISO 4217 format.

GiftCardActivityRedeemMoneyPaymentId String False

The ID of the payment that represents the gift card redemption.

GiftCardActivityRedeemMoneyReferenceId String False

A client-specified ID that associates the gift card activity with an entity in another system.

GiftCardActivityRedeemMoneyStatus String False

The status of the gift card redemption.

GiftCardActivityClearBalanceReason String False

The reason the gift card balance was cleared.

GiftCardActivityDeactivateReason String False

The reason the gift card was deactivated.

GiftCardActivityAdjustIncrementMoneyAmount Int64 False

The amount of money added to the gift card balance. This value is a positive integer.

GiftCardActivityAdjustIncrementMoneyCurrency String False

The type of currency, in ISO 4217 format.

GiftCardActivityAdjustIncrementReason String False

The reason the gift card balance was adjusted.

GiftCardActivityAdjustDecrementMoneyAmount Int64 False

The amount of money deducted from the gift card balance. This value is a positive integer.

GiftCardActivityAdjustDecrementMoneyCurrency String False

The type of currency, in ISO 4217 format.

GiftCardActivityAdjustDecrementReason String False

The reason the gift card balance was adjusted.

GiftCardActivityRefundRedeemActivityId String False

The ID of the refunded REDEEM gift card activity.

GiftCardActivityRefundMoneyAmount Int64 False

The amount of money added to the gift card for the refund. This value is a positive integer.

GiftCardActivityRefundMoneyCurrency String False

The type of currency, in ISO 4217 format.

GiftCardActivityRefundReferenceId String False

A client-specified ID that associates the gift card activity with an entity in another system.

GiftCardActivityRefundPaymentId String False

The ID of the refunded payment.

GiftCardActivityUnlinkedActivityRefundMoneyAmount Int64 False

The amount added to the gift card for the refund. This value is a positive integer.

GiftCardActivityUnlinkedActivityRefundMoneyCurrency String False

The type of currency, in ISO 4217 format.

GiftCardActivityUnlinkedActivityRefundReferenceId String False

A client-specified ID that associates the gift card activity with an entity in another system.

GiftCardActivityUnlinkedActivityRefundPaymentId String False

The ID of the refunded payment.

GiftCardActivityImportMoneyAmount Int64 False

The balance amount on the imported gift card.

GiftCardActivityImportMoneyCurrency String False

The type of currency, in ISO 4217 format.

GiftCardActivityBlockReason String False

The reason the gift card was blocked.

GiftCardActivityUnblockReason String False

The reason the gift card was unblocked.

GiftCardActivityImportReversalMoneyAmount Int64 False

The amount of money cleared from the third-party gift card when the import was reversed.

GiftCardActivityImportReversalMoneyCurrency String False

The type of currency, in ISO 4217 format.

GiftCardActivityTransferBalanceToTransferFromGiftCardId String False

The ID of the gift card from which the specified amount was transferred.

GiftCardActivityTransferBalanceToMoneyAmount Int64 False

The amount of money added to the gift card balance for the transfer. This value is a positive integer.

GiftCardActivityTransferBalanceToMoneyCurrency String False

The type of currency, in ISO 4217 format.

GiftCardActivityTransferBalanceFromTransferToGiftCardId String False

The ID of the gift card to which the specified amount was transferred.

GiftCardActivityTransferBalanceFromMoneyAmount Int64 False

The amount of money deducted from the gift card for the transfer. This value is a positive integer.

GiftCardActivityTransferBalanceFromMoneyCurrency String False

The type of currency, in ISO 4217 format.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062