SSIS Components for Certinia

Build 25.0.9434

Account

This is a table representing the Account entities in FinancialForce.

Columns

Name Type ReadOnly References Description
Id [KEY] String True

Unique identifier of the Account.

IsDeleted Boolean True

Label Deleted corresponds to this field.

MasterRecordId String True

Account.Id

Label Master Record ID corresponds to this field.

Name String False

Label Account Name corresponds to this field.

Type String False

Label Account Type corresponds to this field.

ParentId String False

Account.Id

Label Parent Account ID 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.

ShippingStreet String False

Label Shipping Street corresponds to this field.

ShippingCity String False

Label Shipping City corresponds to this field.

ShippingState String False

Label Shipping State/Province corresponds to this field.

ShippingPostalCode String False

Label Shipping Zip/Postal Code corresponds to this field.

ShippingCountry String False

Label Shipping Country corresponds to this field.

ShippingLatitude Double False

Label Shipping Latitude corresponds to this field.

ShippingLongitude Double False

Label Shipping Longitude corresponds to this field.

Phone String False

Label Account Phone corresponds to this field.

Fax String False

Label Account Fax corresponds to this field.

AccountNumber String False

Label Account Number corresponds to this field.

Website String False

Label Website corresponds to this field.

Sic String False

Label SIC Code corresponds to this field.

Industry String False

Label Industry corresponds to this field.

AnnualRevenue Double False

Label Annual Revenue corresponds to this field.

NumberOfEmployees Int False

Label Employees corresponds to this field.

Ownership String False

Label Ownership corresponds to this field.

TickerSymbol String False

Label Ticker Symbol corresponds to this field.

Description String False

Label Account Description corresponds to this field.

Rating String False

Label Account Rating corresponds to this field.

Site String False

Label Account Site corresponds to this field.

OwnerId String False

User.Id

Label Owner ID 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.

Jigsaw String False

Label Data.com Key corresponds to this field.

JigsawCompanyId String True

Label Jigsaw Company ID corresponds to this field.

AccountSource String False

Label Account Source corresponds to this field.

SicDesc String False

Label SIC Description corresponds to this field.

NumberofLocations__c Double False

Label Number of Locations corresponds to this field.

SLAExpirationDate__c Datetime False

Label SLA Expiration Date corresponds to this field.

UpsellOpportunity__c String False

Label Upsell Opportunity corresponds to this field.

SLASerialNumber__c String False

Label SLA Serial Number corresponds to this field.

SLA__c String False

Label SLA corresponds to this field.

CustomerPriority__c String False

Label Customer Priority corresponds to this field.

Active__c String False

Label Active corresponds to this field.

MyAutoNumber__c String True

Label MyAutoNumber corresponds to this field.

MyFormula__c String True

Label MyFormula corresponds to this field.

MyRollupSummary__c Double True

Label MyRollupSummary corresponds to this field.

MyCheckBox__c Boolean False

Label MyCheckBox corresponds to this field.

MyEmail__c String False

Label MyEmail corresponds to this field.

MyPercent__c Double False

Label MyPercent corresponds to this field.

Custom_Date_Time__c Datetime False

Label Custom Date Time corresponds to this field.

New_Currency_Field__c Double False

Label New_Currency_Field corresponds to this field.

New_Currency_Field_2__c Double False

Label New_Currency_Field_2 corresponds to this field.

DO_NOT_USE__c Boolean False

Label DO_NOT_USE corresponds to this field.

CustomNumber__c Double False

Label CustomNumber corresponds to this field.

FiveChar_TextField__c String False

Label FiveChar_TextField corresponds to this field.

FiveChar_CurrencyField__c Double False

Label FiveChar_CurrencyField corresponds to this field.

FiveChar_NumberField__c Double False

Label FiveChar_NumberField corresponds to this field.

FiveChar_PercentField__c Double False

Label FiveChar_PercentField corresponds to this field.

FiveChar_TextAreaMasked__c String False

Label FiveChar_TextAreaMasked corresponds to this field.

NewField__c Double False

Label NewField corresponds to this field.

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