ValueSets

Columns


Name	Type	SupportedFinders	Description
ValueSetId [KEY]	Long	PrimaryKey	The unique identifier of the value set.
ModuleId	String		The module ID of the value set.
ValueSetCode	String	ValueSetCodeFinder	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

CData Python Connector for Oracle Fusion Cloud Financials

ValueSets

Columns