GL_COA_MAP_SEGMENT_RULES

GL_COA_MAP_SEGMENT_RULES contains the rules you define in the Segment Rules region of the Chart of Accounts Mappings page. SEGMENT_MAP_TYPE is 'C' for copy value rule, 'S' for single value rule, and 'R' for rollup rule. SINGLE_VALUE is the target detail segment value you specify when you use the single value rule.

Details

• Schema: FUSION

• Object owner: GL

• Object type: TABLE

• Tablespace: APPS_TS_TX_DATA

Primary Key

Name	Columns
GL_COA_MAP_SEGMENT_RULES_PK	SEGMENT_RULE_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
SEGMENT_RULE_ID	NUMBER			Yes	Chart of accounts mapping segment rule identifier.
COA_MAPPING_ID	NUMBER		18	Yes	Chart of accounts mapping identifier.
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.
TO_VALUE_SET_ID	NUMBER			Yes	Target segment value set identifier.
TO_SEG_COLUMN_NAME	VARCHAR2	30		Yes	Target Segment name identifier.
SEGMENT_MAP_TYPE	VARCHAR2	1		Yes	Mapping action for a segment rule, whether Assign Single Value, Copy Value from Source, or Use Rollup Rules.
FROM_VALUE_SET_ID	NUMBER				Source segment value set identifier.
FROM_SEG_COLUMN_NAME	VARCHAR2	30			Name of the source chart of accounts segment.
SINGLE_VALUE	VARCHAR2	25			Target segment value for single value.
OBJECT_VERSION_NUMBER	NUMBER		9	Yes	Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.

Foreign Keys

Table	Foreign Table	Foreign Key Column
GL_COA_MAP_SEGMENT_RULES	gl_coa_mappings	COA_MAPPING_ID
gl_coa_map_rollup_rules	gl_coa_map_segment_rules	SEGMENT_RULE_ID

Indexes

Index	Uniqueness	Tablespace	Columns
GL_COA_MAP_SEGMENT_RULES_U1	Unique	Default	SEGMENT_RULE_ID
GL_COA_MAP_SEGMENT_RULES_U2	Unique	Default	COA_MAPPING_ID, TO_SEG_COLUMN_NAME