SSIS Components for Salesforce

Build 25.0.9434

Contract

Manages customer contracts, including agreement terms, statuses, and renewal details.

Columns

Name Type ReadOnly References Description
Id [KEY] String True

Unique identifier of the contract record.

AccountId String False

Account.Id

ID of the account associated with the contract.

CurrencyIsoCode String False

ISO code for the currency in which the revenue amount is expressed.

Pricebook2Id String False

Pricebook2.Id

ID of the Pricebook2 associated with this record.

OwnerExpirationNotice String False

Notification message sent to the owner before the contract expiration.

StartDate Date False

Start date of the contract term.

EndDate Date True

End date of the contract term.

BillingStreet String False

Street address used for billing purposes.

BillingCity String False

City used for billing purposes.

BillingState String False

State or province used for billing purposes.

BillingPostalCode String False

Zip or postal code used for billing purposes.

BillingCountry String False

Country used for billing purposes.

BillingLatitude Double False

Latitude of the billing address.

BillingLongitude Double False

Longitude of the billing address.

BillingGeocodeAccuracy String False

Accuracy level of the geocode for the Billing address.

ContractTerm Int False

Duration of the contract term in months.

OwnerId String False

User.Id

ID of the user who owns the contract record.

Status String False

Current status of the contract, such as Draft, Activated, or Terminated.

CompanySignedId String False

User.Id

ID of the user who signed the contract on behalf of the company.

CompanySignedDate Date False

Date when the contract was signed by the company representative.

CustomerSignedId String False

Contact.Id

ID of the contact who signed the contract on behalf of the customer.

CustomerSignedTitle String False

Title of the contact who signed the contract on behalf of the customer.

CustomerSignedDate Date False

Date when the contract was signed by the customer.

SpecialTerms String False

Custom terms or clauses defined in the contract.

ActivatedById String False

User.Id

ID of the user who activated the contract.

ActivatedDate Datetime False

Date when the contract was activated.

StatusCode String True

Categorized status of the contract such as Draft, InApproval, or Activated.

Description String False

Additional information or comments about the contract.

IsDeleted Bool True

Indicates whether the contract has been deleted (true) or not (false).

ContractNumber String True

Auto-generated number used to uniquely identify the contract.

LastApprovedDate Datetime True

Date when the contract was most recently approved.

CreatedDate Datetime True

Date and time when the contract record was created.

CreatedById String True

User.Id

ID of the user who created the contract record.

LastModifiedById String True

User.Id

ID of the user who last modified the contract record.

LastActivityDate Date True

Date of the most recent activity related to this contract.

LastViewedDate Datetime True

Date and time when the contract was last viewed by the user.

LastReferencedDate Datetime True

Date and time when the contract was last referenced in another record or process.

SOQL String False

Specifies the SOQL query to execute against the Salesforce servers. If this pseudo column is set from the WHERE clause it will take precedence over the original query.

ExternalIdColumn String False

Specifies the external Id column to use if performing an insert. If this value is specified, upsert will be used when the INSERT command is called.

FilterScope String False

Optional scope to limit the records returned from queries. This property can take one of these values: Delegated, Everything, Mine, MineAndMyGroups, My_Territory, My_Team_Territory, or Team.

SystemModstamp Datetime True

Date and time when the record was last modified for system tracking purposes.

LastModifiedDate Datetime True

Date and time when the contract record was last modified.

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