ADO.NET Provider for Sage Intacct

Build 26.0.9655

ContractLine

Represents individual line items on contracts, defining the item, billing method, revenue recognition settings, renewal options, and schedule details for each contracted service or product.

Columns

Name Type ReadOnly Description
auditCreatedBy String True

The user who created the contract line.

auditCreatedDateTime Datetime True

The date and time when the contract line was created.

auditModifiedBy String True

The user who last modified the contract line.

auditModifiedDateTime Datetime True

The date and time when the contract line was last modified.

billToSource String False

The source used to determine the bill-to contact for this contract line.

billingAmountFrequency String False

The frequency at which billing amounts are calculated for this contract line.

billingBaseFlatFixedAmount Decimal True

The base flat fixed billing amount for this contract line.

billingCommittedQuantityEndAction String False

The action taken when the committed quantity is reached at the end of the billing period for this contract line.

billingCommittedQuantityExcess String False

The handling method for quantities that exceed the committed amount on this contract line.

billingDiscount String False

The discount applied to the billing amount on this contract line.

billingDurationInPeriods String False

The billing duration expressed in periods for this contract line.

billingEndDate Date False

The end date of the billing period for this contract line.

billingFlatFixedAmount Decimal False

The flat fixed billing amount for this contract line.

billingFrequency String False

The billing frequency for this contract line.

billingHoldDate Date True

The date on which billing was placed on hold for this contract line.

billingIsUsageQuantityRecurring Bool False

Indicates whether the usage quantity recurs each billing period for this contract line.

billingMemo String False

The billing memo associated with this contract line.

billingMethod String False

The billing method applied to this contract line.

billingMultiplier String False

The billing multiplier applied to quantities on this contract line.

billingProratePartialPeriods Bool False

Indicates whether partial billing periods are prorated for this contract line.

billingQuantity String False

The billing quantity for this contract line.

billingQuantityType String False

The quantity type used for billing on this contract line.

billingRate String False

The billing rate applied to this contract line.

billingResumeDate Date True

The date on which billing is scheduled to resume for this contract line.

billingStartDate Date False

The start date of the billing period for this contract line.

billingTotalBaseFlatFixedAmount Decimal True

The total base flat fixed billing amount for this contract line.

billingTotalFlatFixedAmount Decimal True

The total flat fixed billing amount for this contract line.

billingUsageQuantityReset String False

The reset behavior for usage quantity at the start of each billing period on this contract line.

cancelationDate Date True

The date on which this contract line was cancelled.

changeType String False

The type of change applied to this contract line, such as add, update, or cancel.

contract_EndDate Date True

The end date of the contract associated with this contract line.

contract_Href String True

The URL of the contract associated with this contract line.

contract_Id String False

The Id of the contract associated with this contract line.

contract_Key String False

The system-assigned key of the contract associated with this contract line.

contract_Name String True

The name of the contract associated with this contract line.

contract_State String True

The state of the contract associated with this contract line.

contract_TermType String True

The term type of the contract associated with this contract line.

currencyBaseCurrency String True

The base currency used for this contract line.

currencyExchangeRate Decimal False

The exchange rate applied to this contract line.

currencyExchangeRateDate Date False

The date of the exchange rate applied to this contract line.

currencyTxnCurrency String True

The transaction currency used for this contract line.

deliveryDate Date True

The delivery date for the item on this contract line.

deliveryStatus String False

The delivery status of the item on this contract line.

endDate Date False

The end date of this contract line.

expenseHoldDate Date True

The date on which expense recognition was placed on hold for this contract line.

expenseMemo String False

The expense memo associated with this contract line.

expenseResumeDate Date True

The date on which expense recognition is scheduled to resume for this contract line.

historicalAsOfDate Date False

The as-of date used for historical billing and recognition amounts on this contract line.

historicalBilledAmount Decimal False

The historical billed amount recorded for this contract line as of the as-of date.

historicalIsHistorical Bool False

Indicates whether this contract line contains historical billing or recognition data.

historicalRecognizedAmount Decimal False

The historical recognized revenue amount recorded for this contract line as of the as-of date.

href String True

The URL of the contract line resource.

id String True

The unique identifier of the contract line.

isRecurring Bool False

Indicates whether this contract line has a recurring billing schedule.

itemDescription String False

The description of the item on this contract line.

item_Href String True

The URL of the item associated with this contract line.

item_Id String False

The Id of the item associated with this contract line.

item_Key String False

The system-assigned key of the item associated with this contract line.

item_Name String True

The name of the item associated with this contract line.

key [KEY] String True

The system-assigned key that uniquely identifies the contract line record.

lineNumber String True

The sequential line number of this entry within the contract.

lineRenewalDate Date True

The renewal date calculated for this contract line.

lineType String True

The type of this contract line, such as standard or subscription.

memo String False

The memo or note associated with this contract line.

parent_Href String True

The URL of the parent contract line associated with this contract line.

parent_Id String True

The Id of the parent contract line associated with this contract line.

parent_Key String True

The system-assigned key of the parent contract line associated with this contract line.

parent_LineNumber String True

The line number of the parent contract line associated with this contract line.

postingDate Date False

The posting date for this contract line.

priceCalculationMemo String True

A memo describing how the price was calculated for this contract line.

recurringBillingPeriod Int True

The current recurring billing period number for this contract line.

renewalRenew Bool False

Indicates whether this contract line is included in the renewal.

renewalTriggerDate Date True

The date that triggers the renewal process for this contract line.

revenueDeferralStatus String False

The revenue deferral status of this contract line.

revenueHoldDate Date True

The date on which revenue recognition was placed on hold for this contract line.

revenueMemo String False

The revenue memo associated with this contract line.

revenueResumeDate Date True

The date on which revenue recognition is scheduled to resume for this contract line.

revenueTotalQuantity String False

The total quantity used for revenue recognition on this contract line.

shipToSource String False

The source used to determine the ship-to contact for this contract line.

startDate Date False

The start date of this contract line.

state String False

The current state of this contract line, such as draft, in progress, or complete.

webURL String True

The web URL used to access this contract line in the application.

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9655