XLA_MAPPING_SET

Details

Schema: FUSION
Object owner: XLA
Object type: TABLE
Tablespace: FUSION_TS_TX_DATA

Primary Key

Name	Columns
XLA_MAPPING_SET_VALUES_PK	MAPPING_SET_VALUE_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
MAPPING_SET_VALUE_ID	NUMBER		18	Yes	Identifier of mapping set value.
MAP_PREC	NUMBER		2	Yes	Number of wildcard characters used in a mapping
MAPPING_SET_FLAVOR_ID	NUMBER		18	Yes	Foreign key to the parent flavors surrogate key. It helps the accounting engine to improve performance.
APPLICATION_ID	NUMBER		18	Yes	Identifier of a functional area within a software suite of products. For example: Financials, or Payroll.
MAPPING_SET_CODE	VARCHAR2	30		Yes	Short name of a mapping rule that is defined based on input source values to target segment or account.
AMB_CONTEXT_CODE	VARCHAR2	30		Yes	Accounting methods builder context.
VALUE_CONSTANT	VARCHAR2	240			Output value associated with a mapping when no default output is specified.
VALUE_CODE_COMBINATION_ID	NUMBER		18		Output code combination identifier.
ENABLED_FLAG	VARCHAR2	1		Yes	Indicates if mappings are enabled.
TRANSACTION_COA_ID	NUMBER		18		Chart of accounts identifier for the input value.
INPUT_VALUE_CONSTANT1	VARCHAR2	240			Input value constant 1 of a mapping.
INPUT_VALUE_CONSTANT2	VARCHAR2	240			Input value constant 2 of a mapping.
INPUT_VALUE_CONSTANT3	VARCHAR2	240			Input value constant 3 of a mapping.
INPUT_VALUE_CONSTANT4	VARCHAR2	30			Input value constant 4 of a mapping.
INPUT_VALUE_CONSTANT5	VARCHAR2	30			Input value constant 5 of a mapping.
INPUT_VALUE_CONSTANT6	VARCHAR2	30			Input value constant 6 of a mapping.
INPUT_VALUE_CONSTANT7	VARCHAR2	30			Input value constant 7 of a mapping.
INPUT_VALUE_CONSTANT8	VARCHAR2	30			Input value constant 8 of a mapping.
INPUT_VALUE_CONSTANT9	VARCHAR2	30			Input value constant 9 of a mapping.
INPUT_VALUE_CONSTANT10	VARCHAR2	30			Input value constant 10 of a mapping.
STRIPE_ID	NUMBER		18		Indicates to which chart of accounts of value set the output value is associated.
INPUT_HASH	VARCHAR2	32			Data set mapping algorithm for INPUT_VALUE_CONSTANT1 through 10.
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.
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.
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.
CONCAT_INPUT	VARCHAR2	4000			Concatenated input values of a mapping.
EFFECTIVE_START_DATE	DATE			Yes	Date Effective Entity: indicates the date at the beginning of the date range within which the row is effective.
EFFECTIVE_END_DATE	DATE			Yes	Date Effective Entity: indicates the date at the end of the date range within which the row is effective.

Indexes

Index	Uniqueness	Tablespace	Columns
XLA_MAPPING_SET_VALUES_N1	Non Unique	FUSION_TS_TX_DATA	AMB_CONTEXT_CODE, APPLICATION_ID, MAPPING_SET_CODE, STRIPE_ID, ENABLED_FLAG, INPUT_VALUE_CONSTANT1, INPUT_VALUE_CONSTANT2, INPUT_VALUE_CONSTANT3, INPUT_VALUE_CONSTANT4, INPUT_VALUE_CONSTANT5, INPUT_VALUE_CONSTANT6, INPUT_VALUE_CONSTANT7, INPUT_VALUE_CONSTANT8, INPUT_VALUE_CONSTANT9, INPUT_VALUE_CONSTANT10
XLA_MAPPING_SET_VALUES_N2	Non Unique	FUSION_TS_TX_DATA	SUBSTR("CONCAT_INPUT",1,1000), MAPPING_SET_CODE, STRIPE_ID
XLA_MAPPING_SET_VALUES_U1	Unique	FUSION_TS_TX_DATA	MAPPING_SET_VALUE_ID