ODBC Driver for NetSuite

Build 25.0.9434

GiftCertificate

Tracks issued gift certificates and their redemption status in NetSuite.

Columns

Name Type ReadOnly Description
InternalId [KEY] String True

A unique internal identifier assigned by NetSuite to track this gift certificate within the system, used for internal referencing and transaction management.

AmountRemaining Double False

The remaining balance available on this gift certificate, reflecting any partial redemptions, refunds, or adjustments.

CreatedDate Datetime False

The date and time when this gift certificate was issued or created in NetSuite, used for tracking validity and expiration periods.

Email String False

The email address associated with this gift certificate, typically the recipient’s email, used for digital delivery and notifications.

ExpirationDate Datetime False

The date when this gift certificate expires, after which it becomes invalid and can no longer be redeemed.

GiftCertCode String False

A unique alphanumeric code assigned to this gift certificate, which the recipient enters during checkout to apply the balance to a purchase.

LastModifiedDate Datetime False

The most recent date and time when this gift certificate was updated in NetSuite, such as after a redemption, balance adjustment, or extension.

Message String False

A personalized message that accompanies the gift certificate, often included by the sender as a greeting or special note for the recipient.

Name String False

The name associated with this gift certificate, typically the recipient's name, a business identifier, or a label for tracking purposes.

OriginalAmount Double False

The initial value of this gift certificate at the time of purchase or issuance, representing the total amount available before any redemptions.

Sender String False

The name or identifier of the person or business that purchased or issued this gift certificate, used for record-keeping and sender-recipient tracking.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434