OmniDataTransformItem

Name	Label	Type	Description
Id	Omni Data Transformation Item ID	ID
IsDeleted	Deleted	CHECKBOX
Name	Omni Data Transformation API Name	TEXT(80)
CreatedDate	Created Date	DATETIME
CreatedById	Created By ID	LOOKUP
LastModifiedDate	Last Modified Date	DATETIME
LastModifiedById	Last Modified By ID	LOOKUP
SystemModstamp	System Modstamp	DATETIME
LastViewedDate	Last Viewed Date	DATETIME
LastReferencedDate	Last Referenced Date	DATETIME
OmniDataTransformationId	Omni Data Transformations ID	MASTER-DETAIL
DefaultValue	Default Value	TEXT AREA (LONG)(32768)
FilterDataType	Filter Data Type	PICKLIST
FilterGroup	Filter Group	NUMBER(18,0)
FilterOperator	Filter Operator	PICKLIST
FilterValue	Filter Value	TEXT(255)
FormulaConverted	Formula Converted	TEXT AREA (LONG)(32768)
FormulaExpression	Formula Expression	TEXT AREA (LONG)(32768)
FormulaResultPath	Formula Result Path	TEXT(255)
FormulaSequence	Formula Sequence	NUMBER(18,0)
GlobalKey	Global Key	TEXT(80)
InputObjectName	Input Object Name	TEXT(255)
InputObjectQuerySequence	Input Object Query Sequence	NUMBER(18,0)
IsDisabled	Disabled	CHECKBOX
IsRequiredForUpsert	Required For Upsert	CHECKBOX
IsUpsertKey	Upsert Key	CHECKBOX
LinkedFieldName	Linked Field Name	TEXT(255)
LinkedObjectSequence	Linked Object Sequence	NUMBER(18,0)
LookupByFieldName	Lookup By Field Name	TEXT(255)
LookupObjectName	Lookup Object Name	TEXT(255)
LookupReturnedFieldName	Lookup Returned Field Name	TEXT(255)
MigrationAttribute	Migration Attribute	TEXT(255)
MigrationCategory	Migration Category	TEXT(255)
MigrationGroup	Migration Group	TEXT(255)
MigrationKey	Migration Key	TEXT(255)
MigrationPattern	Migration Pattern	TEXT(255)
MigrationProcess	Migration Process	TEXT(255)
MigrationType	Migration Type	TEXT(255)
MigrationValue	Migration Value	TEXT(255)
OutputCreationSequence	Output Creation Sequence	NUMBER(18,0)
OutputFieldFormat	Output Field Format	TEXT(255)
OutputObjectName	Output Object Name	TEXT(255)
TransformValueMappings	Transform Value Mappings	TEXT AREA (LONG)(32768)
OutputFieldName	Output Field Name	TEXT AREA (LONG)(1000)
InputFieldName	Input Field Name	TEXT AREA (LONG)(1000)

Name	Id
Label	Omni Data Transformation Item ID
Type	ID
Required	Yes

Name	IsDeleted
Label	Deleted
Type	CHECKBOX
Required	Yes
Default value	false

Name	Name
Label	Omni Data Transformation API Name
Type	TEXT(80)
Required	Yes

Name	CreatedDate
Label	Created Date
Type	DATETIME
Required	Yes

Name	CreatedById
Label	Created By ID
Type	LOOKUP
Foreign key	Yes
Required	Yes

Name	LastModifiedDate
Label	Last Modified Date
Type	DATETIME
Required	Yes

Name	LastModifiedById
Label	Last Modified By ID
Type	LOOKUP
Foreign key	Yes
Required	Yes

Name	SystemModstamp
Label	System Modstamp
Type	DATETIME
Required	Yes

Name	LastViewedDate
Label	Last Viewed Date
Type	DATETIME

Name	LastReferencedDate
Label	Last Referenced Date
Type	DATETIME

Name	OmniDataTransformationId
Label	Omni Data Transformations ID
Type	MASTER-DETAIL
Foreign key	Yes
Required	Yes

Name	DefaultValue
Label	Default Value
Type	TEXT AREA (LONG)(32768)

Name	FilterDataType
Label	Filter Data Type
Type	PICKLIST
Picklist values	ADDRESS ANYTYPE BASE64 BOOLEAN COMBOBOX CURRENCY DATACATEGORY GROUPREFERENCE DATE DATETIME DOUBLE EMAIL ENCRYPTEDSTRING ID INTEGER LONG MULTIPICKLIST PERCENT PHONE PICKLIST REFERENCE STRING TEXTAREA TIME URL

Name	FilterGroup
Label	Filter Group
Type	NUMBER(18,0)

Name	FilterOperator
Label	Filter Operator
Type	PICKLIST
Picklist values	= <> < > <= >= ~= LIKE NOT LIKE INCLUDES EXCLUDES AND OR LIMIT OFFSET ORDER BY IN

Name	FilterValue
Label	Filter Value
Type	TEXT(255)

Name	FormulaConverted
Label	Formula Converted
Type	TEXT AREA (LONG)(32768)

Name	FormulaExpression
Label	Formula Expression
Type	TEXT AREA (LONG)(32768)

Name	FormulaResultPath
Label	Formula Result Path
Type	TEXT(255)

Name	FormulaSequence
Label	Formula Sequence
Type	NUMBER(18,0)

Name	GlobalKey
Label	Global Key
Type	TEXT(80)

Name	InputObjectName
Label	Input Object Name
Type	TEXT(255)

Name	InputObjectQuerySequence
Label	Input Object Query Sequence
Type	NUMBER(18,0)

Name	IsDisabled
Label	Disabled
Type	CHECKBOX
Required	Yes
Default value	false

Name	IsRequiredForUpsert
Label	Required For Upsert
Type	CHECKBOX
Required	Yes
Default value	false

Name	IsUpsertKey
Label	Upsert Key
Type	CHECKBOX
Required	Yes
Default value	false

Name	LinkedFieldName
Label	Linked Field Name
Type	TEXT(255)

Name	LinkedObjectSequence
Label	Linked Object Sequence
Type	NUMBER(18,0)

Name	LookupByFieldName
Label	Lookup By Field Name
Type	TEXT(255)

Name	LookupObjectName
Label	Lookup Object Name
Type	TEXT(255)

Name	LookupReturnedFieldName
Label	Lookup Returned Field Name
Type	TEXT(255)

Name	MigrationAttribute
Label	Migration Attribute
Type	TEXT(255)

Name	MigrationCategory
Label	Migration Category
Type	TEXT(255)

Name	MigrationGroup
Label	Migration Group
Type	TEXT(255)

Name	MigrationKey
Label	Migration Key
Type	TEXT(255)

Name	MigrationPattern
Label	Migration Pattern
Type	TEXT(255)

Name	MigrationProcess
Label	Migration Process
Type	TEXT(255)

Name	MigrationType
Label	Migration Type
Type	TEXT(255)

Name	MigrationValue
Label	Migration Value
Type	TEXT(255)

Name	OutputCreationSequence
Label	Output Creation Sequence
Type	NUMBER(18,0)

Name	OutputFieldFormat
Label	Output Field Format
Type	TEXT(255)

Name	OutputObjectName
Label	Output Object Name
Type	TEXT(255)

Name	TransformValueMappings
Label	Transform Value Mappings
Type	TEXT AREA (LONG)(32768)

Name	OutputFieldName
Label	Output Field Name
Type	TEXT AREA (LONG)(1000)

Name	InputFieldName
Label	Input Field Name
Type	TEXT AREA (LONG)(1000)

Name	Parent object	Child object	Parent object field	Child object field
CreatedBy	User	OmniDataTransformItem	Id	CreatedById
LastModifiedBy	User	OmniDataTransformItem	Id	LastModifiedById
OmniDataTransformation	OmniDataTransform	OmniDataTransformItem	Id	OmniDataTransformationId

Label	Value