SegmentValueHierarchyColumnFlattened
A segment value column flattened hierarchy contains the relationship between various nodes in a given tree version in a column flattened manner for the General Ledger related tree structures.
Business Views
** Available for extracting data- segmentValueColumnFlattenedHierarchiesExtract**
A segment value column flattened hierarchy contains the relationship between various nodes in a given tree version in a column flattened manner for the General Ledger related tree structures.
Label
Segment Value Column Flattened Hierarchies
Data Source
Read-optimized data store
Fields
- cfTreeNodeGUID (string)
Identifier of the tree node.
Label
Tree Node ID
Properties
- searchable
- sortable
- not nullable
- createdBy (string)
The user who created the record.
Label
Created By
Properties
- searchable
- sortable
- not nullable
- distance (int64)
Distance, expressed as the number of levels, between the current or reference node and its root node.
Label
Distance
Properties
- searchable
- sortable
- not nullable
- enterpriseId (int64)
Identifier of the enterprise.
Label
Enterprise ID
Properties
- searchable
- sortable
- not nullable
- level0DataSourceGUID (string)
Identifier of the tree node data source.
Label
Tree Node Data Source ID
Properties
- searchable
- sortable
- level0Value (string)
Reference or current node in the account hierarchy.
Label
Level 0 Value
Properties
- searchable
- sortable
- level0ValueSetCode (string)
Value set code associated with the tree.
Label
Value Set Code
Properties
- searchable
- sortable
- level10Value (string)
Tree node value for level 10 of the account hierarchy and version.
Label
Level 10 Value
Properties
- searchable
- sortable
- level11Value (string)
Tree node value for level 11 of the account hierarchy and version.
Label
Level 11 Value
Properties
- searchable
- sortable
- level12Value (string)
Tree node value for level 12 of the account hierarchy and version.
Label
Level 12 Value
Properties
- searchable
- sortable
- level13Value (string)
Tree node value for level 13 of the account hierarchy and version.
Label
Level 13 Value
Properties
- searchable
- sortable
- level14Value (string)
Tree node value for level 14 of the account hierarchy and version.
Label
Level 14 Value
Properties
- searchable
- sortable
- level15Value (string)
Tree node value for level 15 of the account hierarchy and version.
Label
Level 15 Value
Properties
- searchable
- sortable
- level16Value (string)
Tree node value for level 16 of the account hierarchy and version.
Label
Level 16 Value
Properties
- searchable
- sortable
- level17Value (string)
Tree node value for level 17 of the account hierarchy and version.
Label
Level 17 Value
Properties
- searchable
- sortable
- level18Value (string)
Tree node value for level 18 of the account hierarchy and version.
Label
Level 18 Value
Properties
- searchable
- sortable
- level19Value (string)
Tree node value for level 19 of the account hierarchy and version.
Label
Level 19 Value
Properties
- searchable
- sortable
- level1Value (string)
Tree node value for level 1 of the account hierarchy and version.
Label
Level 1 Value
Properties
- searchable
- sortable
- level20Value (string)
Tree node value for level 20 of the account hierarchy and version.
Label
Level 20 Value
Properties
- searchable
- sortable
- level21Value (string)
Tree node value for level 21 of the account hierarchy and version.
Label
Level 21 Value
Properties
- searchable
- sortable
- level22Value (string)
Tree node value for level 22 of the account hierarchy and version.
Label
Level 22 Value
Properties
- searchable
- sortable
- level23Value (string)
Tree node value for level 23 of the account hierarchy and version.
Label
Level 23 Value
Properties
- searchable
- sortable
- level24Value (string)
Tree node value for level 24 of the account hierarchy and version.
Label
Level 24 Value
Properties
- searchable
- sortable
- level25Value (string)
Tree node value for level 25 of the account hierarchy and version.
Label
Level 25 Value
Properties
- searchable
- sortable
- level26Value (string)
Tree node value for level 26 of the account hierarchy and version.
Label
Level 26 Value
Properties
- searchable
- sortable
- level27Value (string)
Tree node value for level 27 of the account hierarchy and version.
Label
Level 27 Value
Properties
- searchable
- sortable
- level28Value (string)
Tree node value for level 28 of the account hierarchy and version.
Label
Level 28 Value
Properties
- searchable
- sortable
- level29Value (string)
Tree node value for level 29 of the account hierarchy and version.
Label
Level 29 Value
Properties
- searchable
- sortable
- level2Value (string)
Tree node value for level 2 of the account hierarchy and version.
Label
Level 2 Value
Properties
- searchable
- sortable
- level30Value (string)
Tree node value for level 30 of the account hierarchy and version.
Label
Level 30 Value
Properties
- searchable
- sortable
- level31Value (string)
Root node for the level 0 value.
Label
Level 31 Value
Properties
- searchable
- sortable
- level3Value (string)
Tree node value for level 3 of the account hierarchy and version.
Label
Level 3 Value
Properties
- searchable
- sortable
- level4Value (string)
Tree node value for level 4 of the account hierarchy and version.
Label
Level 4 Value
Properties
- searchable
- sortable
- level5Value (string)
Tree node value for level 5 of the account hierarchy and version.
Label
Level 5 Value
Properties
- searchable
- sortable
- level6Value (string)
Tree node value for level 6 of the account hierarchy and version.
Label
Level 6 Value
Properties
- searchable
- sortable
- level7Value (string)
Tree node value for level 7 of the account hierarchy and version.
Label
Level 7 Value
Properties
- searchable
- sortable
- level8Value (string)
Tree node value for level 8 of the account hierarchy and version.
Label
Level 8 Value
Properties
- searchable
- sortable
- level9Value (string)
Tree node value for level 9 of the account hierarchy and version.
Label
Level 9 Value
Properties
- searchable
- sortable
- timeCreated (date-time)
The date and time when the record was created.
Label
Creation Date
Properties
- searchable
- sortable
- not nullable
- timeUpdated (date-time)
The date and time when the record was last updated.
Label
Last Updated Date
Properties
- searchable
- sortable
- not nullable
- treeCode (string)
Indicates the tree code of the segment tree version that matches the specified primary key. This is a foreign key of the table FND_TREE.
Label
Tree Code
Properties
- searchable
- sortable
- not nullable
- treeStructureCode (string)
Tree structure code for the account hierarchy.
Label
Tree Structure Code
Properties
- searchable
- sortable
- not nullable
- treeVersionGUID (string)
Identifier of the account hierarchy version.
Label
Hierarchy Version
Properties
- searchable
- sortable
- not nullable
- updatedBy (string)
The user who last updated the record.
Label
Last Updated By
Properties
- searchable
- sortable
- not nullable
- cfTreeNodeGUID (string)