JDBC Driver for FinancialForce

Build 22.0.8462

Contract

This is a table representing the Contract entities in FinancialForce.

Columns

Name Type ReadOnly References Description
Id [KEY] String True

Unique identifier of the Contract.

AccountId String False

Account.Id

Label Account ID corresponds to this field.

OwnerExpirationNotice String False

Label Owner Expiration Notice corresponds to this field.

StartDate Datetime False

Label Contract Start Date corresponds to this field.

EndDate Datetime True

Label Contract End Date corresponds to this field.

BillingStreet String False

Label Billing Street corresponds to this field.

BillingCity String False

Label Billing City corresponds to this field.

BillingState String False

Label Billing State/Province corresponds to this field.

BillingPostalCode String False

Label Billing Zip/Postal Code corresponds to this field.

BillingCountry String False

Label Billing Country corresponds to this field.

BillingLatitude Double False

Label Billing Latitude corresponds to this field.

BillingLongitude Double False

Label Billing Longitude corresponds to this field.

ContractTerm Int False

Label Contract Term corresponds to this field.

OwnerId String False

User.Id

Label Owner ID corresponds to this field.

Status String False

Label Status corresponds to this field.

CompanySignedId String False

User.Id

Label Company Signed By ID corresponds to this field.

CompanySignedDate Datetime False

Label Company Signed Date corresponds to this field.

CustomerSignedId String False

Contact.Id

Label Customer Signed By ID corresponds to this field.

CustomerSignedTitle String False

Label Customer Signed Title corresponds to this field.

CustomerSignedDate Datetime False

Label Customer Signed Date corresponds to this field.

SpecialTerms String False

Label Special Terms corresponds to this field.

ActivatedById String True

User.Id

Label Activated By ID corresponds to this field.

ActivatedDate Datetime True

Label Activated Date corresponds to this field.

StatusCode String True

Label Status Category corresponds to this field.

Description String False

Label Description corresponds to this field.

IsDeleted Boolean True

Label Deleted corresponds to this field.

ContractNumber String True

Label Contract Number corresponds to this field.

LastApprovedDate Datetime True

Label Last Approved Date corresponds to this field.

CreatedDate Datetime True

Label Created Date corresponds to this field.

CreatedById String True

User.Id

Label Created By ID corresponds to this field.

LastModifiedDate Datetime True

Label Last Modified Date corresponds to this field.

LastModifiedById String True

User.Id

Label Last Modified By ID corresponds to this field.

SystemModstamp Datetime True

Label System Modstamp corresponds to this field.

LastActivityDate Datetime True

Label Last Activity corresponds to this field.

LastViewedDate Datetime True

Label Last Viewed Date corresponds to this field.

LastReferencedDate Datetime True

Label Last Referenced Date corresponds to this field.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462