XLA_MAPPING_SET_VALUES_INT
XLA_MAPPING_SET_VALUES_INT is an interface table to import mapping set values.
Details
-
Schema: FUSION
-
Object owner: XLA
-
Object type: TABLE
-
Tablespace: INTERFACE
Primary Key
| Name | Columns |
|---|---|
|
XLA_MAPPING_SET_VALUES_IN_PK |
DATA_SET_NAME, LINE_NUM |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| DATA_SET_NAME | VARCHAR2 | 30 | Yes | Used to identify a set of records to be processed by a specific Import Accounting Setup process. | |
| LINE_NUM | NUMBER | 18 | Yes | Line number of the mapping set values row in the CSV. | |
| LOAD_REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the interface load job that created the row. | ||
| APPLICATION_SHORT_NAME | VARCHAR2 | 30 | Yes | Abbreviated name of application for which mapping set values needs to be imported. | |
| MAPPING_SET_CODE | VARCHAR2 | 30 | Yes | Short name of a mapping rule that is defined. | |
| CHART_OF_ACCOUNTS_CODE | VARCHAR2 | 30 | Chart of accounts structure instance short name. | ||
| FROM_CHART_OF_ACCOUNTS_CODE | VARCHAR2 | 30 | Chart of accounts structure instance short name from the transaction input value. | ||
| VALUE_SET_CODE | VARCHAR2 | 60 | Value set short name. | ||
| FLEXFIELD_SEGMENT_CODE | VARCHAR2 | 30 | Flexfield segment short name. | ||
| OUTPUT_ACCOUNT_COMBINATION | VARCHAR2 | 800 | User-entered mapping set output account combination. | ||
| OUTPUT_VALUE_CONSTANT | VARCHAR2 | 240 | The converted value associated with a segment or value set mapping source value entered in spreadsheet template. | ||
| VALUE_CONSTANT | VARCHAR2 | 240 | Output value associated with a mapping when no default output is specified. | ||
| SOURCE_VALUE1 | VARCHAR2 | 1000 | User-entered input value for source 1 | ||
| SOURCE_VALUE2 | VARCHAR2 | 1000 | User-entered input value for source 2 | ||
| SOURCE_VALUE3 | VARCHAR2 | 1000 | User-entered input value for source 3 | ||
| SOURCE_VALUE4 | VARCHAR2 | 1000 | User-entered input value for source 4 | ||
| SOURCE_VALUE5 | VARCHAR2 | 1000 | User-entered input value for source 5 | ||
| SOURCE_VALUE6 | VARCHAR2 | 1000 | User-entered input value for source 6 | ||
| SOURCE_VALUE7 | VARCHAR2 | 1000 | User-entered input value for source 7 | ||
| SOURCE_VALUE8 | VARCHAR2 | 1000 | User-entered input value for source 8 | ||
| SOURCE_VALUE9 | VARCHAR2 | 1000 | User-entered input value for source 9 | ||
| SOURCE_VALUE10 | VARCHAR2 | 1000 | User-entered input value for source 10 | ||
| STATUS_CODE | VARCHAR2 | 30 | Mapping value record import status. | ||
| START_DATE | DATE | Indicates the date at the beginning of the date range within which the row is effective. | |||
| END_DATE | DATE | Indicates the date at the end of the date range within which the row is effective. | |||
| DEFAULT_MAPPING_FLAG | VARCHAR2 | 1 | Indicates if output values provided is for default mappings. | ||
| APPLICATION_ID | NUMBER | 18 | Identifier of a functional area within a software suite of products. For example: Financials, or Payroll. | ||
| FROM_CHART_OF_ACCOUNTS_ID | NUMBER | 18 | Chart of accounts identifier for the input value. | ||
| STRIPE_ID | NUMBER | 18 | Indicates to which chart of accounts or value set the output value is associated. | ||
| 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. | ||
| VALUE_CODE_COMBINATION_ID | NUMBER | 18 | Output code combination identifier. | ||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| JOB_DEFINITION_NAME | VARCHAR2 | 100 | Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. | ||
| JOB_DEFINITION_PACKAGE | VARCHAR2 | 900 | Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. | ||
| CREATION_DATE | TIMESTAMP | Who column: indicates the date and time of the creation of the row. | |||
| CREATED_BY | VARCHAR2 | 64 | Who column: indicates the user who created the row. | ||
| LAST_UPDATE_DATE | TIMESTAMP | Who column: indicates the date and time of the last update of the row. | |||
| LAST_UPDATED_BY | VARCHAR2 | 64 | 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. | ||
| WILDCARD_COUNT | NUMBER | 2 | Number of wildcard characters used in a mapping |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| XLA_MAPPING_SET_VALUES_INT_N1 | Non Unique | FUSION_TS_INTERFACE | DATA_SET_NAME, CHART_OF_ACCOUNTS_CODE |
| XLA_MAPPING_SET_VALUES_INT_N2 | Non Unique | FUSION_TS_INTERFACE | DATA_SET_NAME, FROM_CHART_OF_ACCOUNTS_CODE |
| XLA_MAPPING_SET_VALUES_INT_U1 | Unique | FUSION_TS_INTERFACE | DATA_SET_NAME, LINE_NUM |