Excel Add-In for NetSuite

Build 25.0.9434

Term

Stores payment terms applied to customer invoices and vendor bills, such as Net 30 or Due on Receipt in NetSuite.

Columns

Name Type ReadOnly Description
InternalId [KEY] String True

A unique identifier for the term, used to track and reference specific payment terms in the system.

DateDriven Boolean False

Indicates whether the term's due date is driven by a specific date (true) or another factor, such as an invoice date (false).

DayDiscountExpires Long False

The day of the month on which the discount for the term expires, used to calculate the discount eligibility period for payments.

DayOfMonthNetDue Long False

The day of the month on which the full payment is due for the term, typically the date when the net balance is expected to be paid.

DaysUntilExpiry Long False

The number of days remaining until the discount or term expires, helping to track the validity period of any discount associated with the term.

DaysUntilNetDue Long False

The number of days until the net amount of the term is due, helping businesses manage the timing of payments and cash flow.

DiscountPercent Double False

The percentage of discount offered on the term, typically applied if the payment is made within a specific early payment window.

DiscountPercentDateDriven Double False

The percentage of discount that applies when the term is date-driven, offering flexibility based on the payment date.

DueNextMonthIfWithinDays Long False

The number of days after which a payment that is due within a certain time frame will be pushed to the next month, ensuring correct payment scheduling.

ExternalId String False

An external identifier for the term, used for integration with other systems or external entities, such as customers or vendors.

IsInactive Boolean False

Indicates whether the term is inactive (true) or active (false), allowing businesses to disable certain terms when necessary.

Name String False

The name of the term, such as 'Net 30' or 'COD,' used to identify the specific payment term or condition.

Preferred Boolean False

Indicates whether this term is marked as preferred (true) for use in transactions, helping prioritize the term in business operations.

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