ValueSets

Columns


Name	Type	Description
ValueSetId [KEY]	Long	The unique identifier of the value set.
ModuleId	String	The module ID of the value set.
ValueSetCode	String	The value set code identifying the value set.
Description	String	The description of the value set.
ValidationType	String	The validation type of the value set.
ValueDataType	String	The value data type of the value set.
ValueSubtype	String	The value subtype of the value set.
ProtectedFlag	String	Indicates if the value set is protected against updates.
MaximumLength	Int	The maximum permitted length for a value.
Precision	Int	The maximum number of digits in a value.
Scale	Int	The maximum number of digits permitted to the right of the decimal point.
UppercaseOnlyFlag	String	Indicates if the value must be in uppercase.
ZeroFillFlag	String	Indicates if a value must be left-padded with zeros.
SecurityEnabledFlag	String	Indicates if data security is enabled for this value set.
DataSecurityObjectName	String	The name of the data security object, if any, used to secure this value set.
MinimumValue	String	The minimum permitted value.
MinimumValueNumber	Decimal	The minimum permitted number value.
MinimumValueDate	Date	The minimum permitted date value.
MinimumValueTimestamp	Datetime	The minimum permitted time stamp value.
MaximumValue	String	The maximum permitted value.
MaximumValueNumber	Decimal	The maximum permitted number value.
MaximumValueDate	Date	The maximum permitted date value.
MaximumValueTimestamp	Datetime	The maximum permitted time stamp value.
IndependentValueSetId	Long	The value set ID, if any, of the independent value set.
IndependentValueSetCode	String	The value set code, if any, of the independent value set.
CreationDate	Datetime	The date when the record was created.
CreatedBy	String	The user who created the record.
LastUpdateDate	Datetime	The date when the record was last updated.
LastUpdatedBy	String	The user who last updated the record.
Finder	String	finder

SSIS Components for Oracle Fusion Cloud Financials

ValueSets

Columns