XLA_FSN_ACCOUNTS_GT
This is a temporary table which is used internally by Oracle.
Details
-
Schema: FUSION
-
Object owner: XLA
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| ROW_NUM | NUMBER | 18 | Yes | Numeric value to indicate the order of a line. | |
| PASS_NUM | NUMBER | 18 | Pass number. Allows those rows from each pass to be identified | ||
| BASE_CCID | NUMBER | 18 | Unique identifier of a base account. | ||
| BALANCE_TYPE | VARCHAR2 | 1 | Yes | Type of balance, such as actual or budget. | |
| EFFECTIVE_DATE | DATE | Date on which this account should be valid. | |||
| PROCESS_CODE | VARCHAR2 | 5 | Indicates the transformations that need to be performed on this row. If the PROCESS_CODE contains a P, then the input values contain a CCID from which a segment value will need to be pulled. If the PROCESS_CODE contains a M, then a mapping set needs to be applied. If the PROCESS_CODE contains an A, then the input values contain a CCIDfrom which a segment value will need to be pulled before the mapping set is applied. If the PROCESS_CODE contains a C, then chart of accounts mapping of CCIDs is necessary. If the PROCESS_CODE contains a S, then chart of accounts mapping of segments is necessary. The PROCESS_CODE can also contain combinations of these, in which case the P will always be first (if it is present), the M will always be next (if it is present), the A will always be next (if it is present), the S will always be next (if it is present), and the C will always be last (if it is present). | ||
| ALL_SEG_INPUT_VALUE | VARCHAR2 | 1000 | Input value for the flexfield rule. | ||
| INPUT_VALUE1 | VARCHAR2 | 1000 | First input value for the segment. | ||
| INPUT_VALUE2 | VARCHAR2 | 1000 | Second input value for the segment. | ||
| INPUT_VALUE3 | VARCHAR2 | 1000 | Third input value for the segment. | ||
| INPUT_VALUE4 | VARCHAR2 | 1000 | Fourth input value for the segment. | ||
| INPUT_VALUE5 | VARCHAR2 | 1000 | Fifth input value for the segment. | ||
| INPUT_VALUE6 | VARCHAR2 | 1000 | Sixth input value for the segment. | ||
| INPUT_VALUE7 | VARCHAR2 | 1000 | Seventh input value or the segment. | ||
| INPUT_VALUE8 | VARCHAR2 | 1000 | Eighth input value for the segment. | ||
| INPUT_VALUE9 | VARCHAR2 | 1000 | Ninth input value for the segment. | ||
| INPUT_VALUE10 | VARCHAR2 | 1000 | Tenth input value for the segment. | ||
| INPUT_VALUE11 | VARCHAR2 | 1000 | Eleventh input value for the segment. | ||
| INPUT_VALUE12 | VARCHAR2 | 1000 | Twelfth input value for the segment. | ||
| INPUT_VALUE13 | VARCHAR2 | 1000 | Thirteenth input value for the segment. | ||
| INPUT_VALUE14 | VARCHAR2 | 1000 | Fourteenth input value for the segment. | ||
| INPUT_VALUE15 | VARCHAR2 | 1000 | Fifteenth input value for the segment. | ||
| INPUT_VALUE16 | VARCHAR2 | 1000 | Sixteenth input value for the segment. | ||
| INPUT_VALUE17 | VARCHAR2 | 1000 | Seventeenth input value for the segment. | ||
| INPUT_VALUE18 | VARCHAR2 | 1000 | Eighteenth input value for the segment. | ||
| INPUT_VALUE19 | VARCHAR2 | 1000 | Nineteenth input value for the segment. | ||
| INPUT_VALUE20 | VARCHAR2 | 1000 | Twentieth input value for the segment. | ||
| INPUT_VALUE21 | VARCHAR2 | 1000 | Twenty-first input value for the segment. | ||
| INPUT_VALUE22 | VARCHAR2 | 1000 | Twenty-second input value for the segment. | ||
| INPUT_VALUE23 | VARCHAR2 | 1000 | Twenty-third input value for the segment. | ||
| INPUT_VALUE24 | VARCHAR2 | 1000 | Twenty-fourth input value for the segment. | ||
| INPUT_VALUE25 | VARCHAR2 | 1000 | Twenty-fifth input value for the segment. | ||
| INPUT_VALUE26 | VARCHAR2 | 1000 | Twenty-sixth input value for the segment. | ||
| INPUT_VALUE27 | VARCHAR2 | 1000 | Twenty-seventh input value for the segment. | ||
| INPUT_VALUE28 | VARCHAR2 | 1000 | Twenty-eighth input value for the segment. | ||
| INPUT_VALUE29 | VARCHAR2 | 1000 | Twenty-ninth input value for the segment. | ||
| INPUT_VALUE30 | VARCHAR2 | 1000 | Thirtieth input value f the segment. | ||
| ALL_SEG_COLUMN_NAME | VARCHAR2 | 19 | Only populated when a single segment value needs to be retrieved for a code combination identifier. Contains the column name in GL_CODE_COMBINATIONS that contains the segment value to be retrieved for use in the account rule that populates the second segment. | ||
| COLUMN_NAME1 | VARCHAR2 | 19 | Only populated when a single segment value needs to be retrieved for a code combination identifier. Contains the column name in GL_CODE_COMBINATIONS that contains the segment value to be retrieved for use in the account rule that populates the second segment. | ||
| COLUMN_NAME2 | VARCHAR2 | 19 | Only populated when a single segment value needs to be retrieved for a code combination identifier. Contains the column name in GL_CODE_COMBINATIONS that contains the segment value to be retrieved for use in the account rule that populates the second segment. | ||
| COLUMN_NAME3 | VARCHAR2 | 19 | Only populated when a single segment value needs to be retrieved for a code combination identifier. Contains the column name in GL_CODE_COMBINATIONS that contains the segment value to be retrieved for use in the account rule that populates the third segment. | ||
| COLUMN_NAME4 | VARCHAR2 | 19 | Only populated when a single segment value needs to be retrieved for a code combination identifier. Contains the column name in GL_CODE_COMBINATIONS that contains the segment value to be retrieved for use in the account rule that populates the forth segment. | ||
| COLUMN_NAME5 | VARCHAR2 | 19 | Only populated when a single segment value needs to be retrieved for a code combination identifier. Contains the column name in GL_CODE_COMBINATIONS that contains the segment value to be retrieved for use in the account rule that populates the fifth segment. | ||
| COLUMN_NAME6 | VARCHAR2 | 19 | Only populated when a single segment value needs to be retrieved for a code combination identifier. Contains the column name in GL_CODE_COMBINATIONS that contains the segment value to be retrieved for use in the account rule that populates the sixth segment. | ||
| COLUMN_NAME7 | VARCHAR2 | 19 | Only populated when a single segment value needs to be retrieved for a code combination identifier. Contains the column name in GL_CODE_COMBINATIONS that contains the segment value to be retrieved for use in the account rule that populates the seventh segment. | ||
| COLUMN_NAME8 | VARCHAR2 | 19 | Only populated when a single segment value needs to be retrieved for a code combination identifier. Contains the column name in GL_CODE_COMBINATIONS that contains the segment value to be retrieved for use in the account rule that populates the eighth segment. | ||
| COLUMN_NAME9 | VARCHAR2 | 19 | Only populated when a single segment value needs to be retrieved for a code combination identifier. Contains the column name in GL_CODE_COMBINATIONS that contains the segment value to be retrieved for use in the account rule that populates the ninth segment. | ||
| COLUMN_NAME10 | VARCHAR2 | 19 | Only populated when a single segment value needs to be retrieved for a code combination identifier. Contains the column name in GL_CODE_COMBINATIONS that contains the segment value to be retrieved for use in the account rule that populates the tenth segment. | ||
| COLUMN_NAME11 | VARCHAR2 | 19 | Only populated when a single segment value needs to be retrieved for a code combination identifier. Contains the column name in GL_CODE_COMBINATIONS that contains the segment value to be retrieved for use in the account rule that populates the eleventh segment. | ||
| COLUMN_NAME12 | VARCHAR2 | 19 | Only populated when a single segment value needs to be retrieved for a code combination identifier. Contains the column name in GL_CODE_COMBINATIONS that contains the segment value to be retrieved for use in the account rule that populates the twelfth segment. | ||
| COLUMN_NAME13 | VARCHAR2 | 19 | Only populated when a single segment value needs to be retrieved for a code combination identifier. Contains the column name in GL_CODE_COMBINATIONS that contains the segment value to be retrieved for use in the account rule that populates the thirteenth segment. | ||
| COLUMN_NAME14 | VARCHAR2 | 19 | Only populated when a single segment value needs to be retrieved for a code combinatin identifier. Contains the column name in GL_CODE_COMBINATINS that contains the segment value to be retrieved for use in the account rule that populates the fourteenth segment. | ||
| COLUMN_NAME15 | VARCHAR2 | 19 | Only populated when a single segment value needs to be retrieved for a code combination identifier. Contains the column name in GL_CODE_COMBINATIONS that contains the segment value to be retrieved for use in the account rule that populates the segment. | ||
| COLUMN_NAME16 | VARCHAR2 | 19 | Only populated when a single segment value needs to be retrieved for a code combination identifier. Contains the column name in GL_CODE_COMBINATIONS that contains the segment value to be retrieved for use in the account rule that populates the sixteenth segment. | ||
| COLUMN_NAME17 | VARCHAR2 | 19 | Only populated when a single segment value needs to be retrieved for a code combination identifier. Contains the column name in GL_CODE_COMBINATIONS that contains the segment value to be retrieved for use in the account rule that populates the seventeenth segment. | ||
| COLUMN_NAME18 | VARCHAR2 | 19 | Only populated when a single segment value needs to be retrieved for a code combination identifier. Contains the column name in GL_CODE_COMBINATIONS that contains the segment value to be retrieved for use in the account rule that populates the eighteenth segment. | ||
| COLUMN_NAME19 | VARCHAR2 | 19 | Only populated when a single segment value needs to be retrieved for a code combination identifier. Contains the column name in GL_CODE_COMBINATIONS that contains the segment value to be retrieved for use in the account rule that populates the nineteenth segment. | ||
| COLUMN_NAME20 | VARCHAR2 | 19 | Only populated when a single segment value needs to be retrieved for a code combination identifier. Contains the column name in GL_CODE_COMBINATIONS that contains the segment value to be retrieved for use in the account rule that populates the twentieth segment. | ||
| COLUMN_NAME21 | VARCHAR2 | 19 | Only populated when a single segment value needs to be retrieved for a code combination identifier. Contains the column name in GL_CODE_COMBINATIONS that contains the segment value to be retrieved for use in the account rule that populates the twenty-first segment. | ||
| COLUMN_NAME22 | VARCHAR2 | 19 | Only populated when a single segment value needs to be retrieved for a code combination identifier. Contains the column name in GL_CODE_COMBINATIONS that contains the segment value to be retrieved for use in the account rule that populates the twenty-second segment. | ||
| COLUMN_NAME23 | VARCHAR2 | 19 | Only populated when a single segment value needs to be retrieved for a code combination identifier. Contains the column name in GL_CODE_COMBINATIONS that contains the segment value to be retrieved for use in the account rule that populates the twenty-third segment. | ||
| COLUMN_NAME24 | VARCHAR2 | 19 | Only populated when a single segment value needs to be retrieved for a code combination identifier. Contains the column name in GL_CODE_COMBINATIONS that contains the segment value to be retrieved for use in the account rule that populates the twenty-forth segment. | ||
| COLUMN_NAME25 | VARCHAR2 | 19 | Only populated when a single segment value needs to be retrieved for a code combination identifier. Contains the column name in GL_CODE_COMBINATIONS that contains the segment value to be retrieved for use in the account rule that populates the twenty-fifth segment. | ||
| COLUMN_NAME26 | VARCHAR2 | 19 | Only populated when a single segment value needs to be retrieved for a code combination identifier. Contains the column name in GL_CODE_COMBINATIONS that contains the segment value to be retrieved for use in the account rule that populates the twenty-sixth segment. | ||
| COLUMN_NAME27 | VARCHAR2 | 19 | Only populated when a single segment value needs to be retrieved for a code combination identifier. Contains the column name in GL_CODE_COMBINATIONS that contains the segment value to be retrieved for use in the account rule that populates the twenty-seventh segment. | ||
| COLUMN_NAME28 | VARCHAR2 | 19 | Only populated when a single segment value needs to be retrieved for a code combination identifier. Contains the column name in GL_CODE_COMBINATIONS that contains the segment value to be retrieved for use in the account rule that populates the twenty-eighth segment. | ||
| COLUMN_NAME29 | VARCHAR2 | 19 | Only populated when a single segment value needs to be retrieved for a code combination identifier. Contains the column name in GL_CODE_COMBINATIONS that contains the segment value to be retrieved for use in the account rule that populates the twenty-ninth segment. | ||
| COLUMN_NAME30 | VARCHAR2 | 19 | Only populated when a single segment value needs to be retrieved for a code combination identifier. Contains the column name in GL_CODE_COMBINATIONS that contains the segment value to be retrieved for use in the account derivation rule that populates the thirtieth segment. | ||
| ALL_SEG_MAPPING_SET_CODE | VARCHAR2 | 30 | Mapping code of the mapping set that needs to be applied to the flexfield. | ||
| MAPPING_SET_CODE1 | VARCHAR2 | 30 | Mapping code of the mapping set that needs to be applied to the first segment. | ||
| MAPPING_SET_CODE2 | VARCHAR2 | 30 | Mapping code of the mapping set that needs to be applied to the second segment. | ||
| MAPPING_SET_CODE3 | VARCHAR2 | 30 | Mapping code of the mapping set that needs to be applied to the third segment. | ||
| MAPPING_SET_CODE4 | VARCHAR2 | 30 | Mapping code of the mapping set that needs to be applied to the fourth segment. | ||
| MAPPING_SET_CODE5 | VARCHAR2 | 30 | Mapping code of the mapping set that needs to be applied to the fifth segment. | ||
| MAPPING_SET_CODE6 | VARCHAR2 | 30 | Mapping code of the mapping set that needs to be applied to the sixth segment. | ||
| MAPPING_SET_CODE7 | VARCHAR2 | 30 | Mapping code of the mapping set that needs to be applied to the seventh segment. | ||
| MAPPING_SET_CODE8 | VARCHAR2 | 30 | Mapping code of the mapping set that needs to be applied to the eighth segment. | ||
| MAPPING_SET_CODE9 | VARCHAR2 | 30 | Mapping code of the mapping set that needs to be applied to the ninth segment. | ||
| MAPPING_SET_CODE10 | VARCHAR2 | 30 | Mapping code of the mapping set that needs to be applied to the tenth segment. | ||
| MAPPING_SET_CODE11 | VARCHAR2 | 30 | Mapping code of the mapping set that needs to be applied to the eleventh segment. | ||
| MAPPING_SET_CODE12 | VARCHAR2 | 30 | Mapping code of the mapping set that needs to be applied to the twelfth segment. | ||
| MAPPING_SET_CODE13 | VARCHAR2 | 30 | Mapping code of the mapping set that needs to be applied to the thirteenth segment. | ||
| MAPPING_SET_CODE14 | VARCHAR2 | 30 | Mapping code of the mapping set that needs to be applied to the fourteenth segment. | ||
| MAPPING_SET_CODE15 | VARCHAR2 | 30 | Mapping code of the mapping set that needs to be applied to the fifteenth segment. | ||
| MAPPING_SET_CODE16 | VARCHAR2 | 30 | Mapping code of the mapping set that needs to be applied to the sixteenth segment. | ||
| MAPPING_SET_CODE17 | VARCHAR2 | 30 | Mapping code of the mapping set that needs to be applied to the seventeenth segment. | ||
| MAPPING_SET_CODE18 | VARCHAR2 | 30 | Mapping code of the mapping set that needs to be applied to the eighteenth segment. | ||
| MAPPING_SET_CODE19 | VARCHAR2 | 30 | Mapping code of the mapping set that needs to be applied to the nineteenth segment. | ||
| MAPPING_SET_CODE20 | VARCHAR2 | 30 | Mapping code of the mapping set that needs to be applied to the twentieth segment, if any. | ||
| MAPPING_SET_CODE21 | VARCHAR2 | 30 | Mapping code of the mapping set that needs to be applied to the twenty-first segment, if any. | ||
| MAPPING_SET_CODE22 | VARCHAR2 | 30 | Mapping code of the mapping set that needs to be applied to the twenty-second segment, if any. | ||
| MAPPING_SET_CODE23 | VARCHAR2 | 30 | Mapping code of the mapping set that needs to be applied to the twenty-third segment. | ||
| MAPPING_SET_CODE24 | VARCHAR2 | 30 | Mapping code of the mapping set that needs to be applied to the twenty-forth segment. | ||
| MAPPING_SET_CODE25 | VARCHAR2 | 30 | Mapping code of the mapping set that needs to be applied to the twenty-fifth segment. | ||
| MAPPING_SET_CODE26 | VARCHAR2 | 30 | Mapping code of the mapping set that needs to be applied to the twenty-sixth segment. | ||
| MAPPING_SET_CODE27 | VARCHAR2 | 30 | Mapping code of the mapping set that needs to be applied to the twenty-seventh segment | ||
| MAPPING_SET_CODE28 | VARCHAR2 | 30 | Mapping code of the mapping set that needs to be applied to the twenty-eighth segment. | ||
| MAPPING_SET_CODE29 | VARCHAR2 | 30 | Mapping code of the mapping set that needs to be applied to the twenty-ninth segment. | ||
| MAPPING_SET_CODE30 | VARCHAR2 | 30 | Mapping code of the mapping set that needs to be applied to the thirtieth segment. | ||
| ALL_SEG_COA_MAP | NUMBER | 2 | Level of chart of accounts mapping to be done for the flexfield, if any. Zero indicates code combination identifier level chart of accounts mapping should be done. A number greater than zero indicates a segment level chart of accounts mapping should be done. The specific number indicates which segment label should apply. | ||
| COA_MAP1 | NUMBER | 2 | Level of chart of accounts mapping to be done for the flexfield, if any. Zero indicates code combination identifier level chart of accounts mapping should be done. A number greater than zero indicates a segment level chart of accounts mapping should be done. The specific number indicates which segment label should apply. | ||
| COA_MAP2 | NUMBER | 2 | Level of chart of accounts mapping to be done for the flexfield, if any. Zero indicates code combination identifier level chart of accounts mapping should be done. A number greater than zero indicates a segment level chart of accounts mapping should be done. The specific number indicates which segment label should apply. | ||
| COA_MAP3 | NUMBER | 2 | Level of chart of accounts mapping to be done for the flexfield, if any. Zero indicates code combination identifier level chart of accounts mapping should be done. A number greater than zero indicates a segment level chart of accounts mapping should be done. The specific number indicates which segment label should apply. | ||
| COA_MAP4 | NUMBER | 2 | Level of chart of accounts mapping to be done for the flexfield, if any. Zero indicates code combination identifier level chart of accounts mapping should be done. A number greater than zero indicates a segment level chart of accounts mapping should be done. The specific number indicates which segment label should apply. | ||
| COA_MAP5 | NUMBER | 2 | Level of chart of accounts mapping to be done for the flexfield, if any. Zero indicates code combination identifier level chart of accounts mapping should be done. A number greater than zero indicates a segment level chart of accounts mapping should be done. The specific number indicates which segment label should apply. | ||
| COA_MAP6 | NUMBER | 2 | Level of chart of accounts mapping to be done for the flexfield, if any. Zero indicates code combination identifier level chart of accounts mapping should be done. A number greater than zero indicates a segment level chart of accounts mapping should be done. The specific number indicates which segment label should apply. | ||
| COA_MAP7 | NUMBER | 2 | Level of chart of accounts mapping to be done for the flexfield, if any. Zero indicates code combination identifier level chart of accounts mapping should be done. A number greater than zero indicates a segment level chart of accounts mapping should be done. The specific number indicates which segment label should apply. | ||
| COA_MAP8 | NUMBER | 2 | Level of chart of accounts mapping to be done for the flexfield, if any. Zero indicates code combination identifier level chart of accounts mapping should be done. A number greater than zero indicates a segment level chart of accounts mapping should be done. The specific number indicates which segment label should apply. | ||
| COA_MAP9 | NUMBER | 2 | Level of chart of accounts mapping to be done for the flexfield, if any. Zero indicates code combination identifier level chart of accounts mapping should be done. A number greater than zero indicates a segment level chart of accounts mapping should be done. The specific number indicates which segment label should apply. | ||
| COA_MAP10 | NUMBER | 2 | Level of chart of accounts mapping to be done for the flexfield, if any. Zero indicates code combination identifier level chart of accounts mapping should be done. A number greater than zero indicates a segment level chart of accounts mapping should be done. The specific number indicates which segment label should apply. | ||
| COA_MAP11 | NUMBER | 2 | Level of chart of accounts mapping to be done for the flexfield, if any. Zero indicates code combination identifier level chart of accounts mapping should be done. A number greater than zero indicates a segment level chart of accounts mapping should be done. The specific number indicates which segment label should apply. | ||
| COA_MAP12 | NUMBER | 2 | Level of chart of accounts mapping to be done for the flexfield, if any. Zero indicates code combination identifier level chart of accounts mapping should be done. A number greater than zero indicates a segment level chart of accounts mapping should be done. The specific number indicates which segment label should apply. | ||
| COA_MAP13 | NUMBER | 2 | Level of chart of accounts mapping to be done for the flexfield, if any. Zero indicates code combination identifier level chart of accounts mapping should be done. A number greater than zero indicates a segment level chart of accounts mapping should be done. The specific number indicates which segment label should apply. | ||
| COA_MAP14 | NUMBER | 2 | Level of chart of accounts mapping to be done for the flexfield, if any. Zero indicates code combination identifier level chart of accounts mapping should be done. A number greater than zero indicates a segment level chart of accounts mapping should be done. The specific number indicates which segment label should apply. | ||
| COA_MAP15 | NUMBER | 2 | Level of chart of accounts mapping to be done for the flexfield, if any. Zero indicates code combination identifier level chart of accounts mapping should be done. A number greater than zero indicates a segment level chart of accounts mapping should be done. The specific number indicates which segment label should apply. | ||
| COA_MAP16 | NUMBER | 2 | Level of chart of accounts mapping to be done for the flexfield, if any. Zero indicates code combination identifier level chart of accounts mapping should be done. A number greater than zero indicates a segment level chart of accounts mapping should be done. The specific number indicates which segment label should apply. | ||
| COA_MAP17 | NUMBER | 2 | Level of chart of accounts mapping to be done for the flexfield, if any. Zero indicates code combination identifier level chart of accounts mapping should be done. A number greater than zero indicates a segment level chart of accounts mapping should be done. The specific number indicates which segment label should apply. | ||
| COA_MAP18 | NUMBER | 2 | Level of chart of accounts mapping to be done for the flexfield, if any. Zero indicates code combination identifier level chart of accounts mapping should be done. A number greater than zero indicates a segment level chart of accounts mapping should be done. The specific number indicates which segment label should apply. | ||
| COA_MAP19 | NUMBER | 2 | Level of chart of accounts mapping to be done for the flexfield, if any. Zero indicates code combination identifier level chart of accounts mapping should be done. A number greater than zero indicates a segment level chart of accounts mapping should be done. The specific number indicates which segment label should apply. | ||
| COA_MAP20 | NUMBER | 2 | Level of chart of accounts mapping to be done for the flexfield, if any. Zero indicates code combination identifier level chart of accounts mapping should be done. A number greater than zero indicates a segment level chart of accounts mapping should be done. The specific number indicates which segment label should apply. | ||
| COA_MAP21 | NUMBER | 2 | Level of chart of accounts mapping to be done for the flexfield, if any. Zero indicates code combination identifier level chart of accounts mapping should be done. A number greater than zero indicates a segment level chart of accounts mapping should be done. The specific number indicates which segment label should apply. | ||
| COA_MAP22 | NUMBER | 2 | Level of chart of accounts mapping to be done for the flexfield, if any. Zero indicates code combination identifier level chart of accounts mapping should be done. A number greater than zero indicates a segment level chart of accounts mapping should be done. The specific number indicates which segment label should apply. | ||
| COA_MAP23 | NUMBER | 2 | Level of chart of accounts mapping to be done for the flexfield, if any. Zero indicates code combination identifier level chart of accounts mapping should be done. A number greater than zero indicates a segment level chart of accounts mapping should be done. The specific number indicates which segment label should apply. | ||
| COA_MAP24 | NUMBER | 2 | Level of chart of accounts mapping to be done for the flexfield, if any. Zero indicates code combination identifier level chart of accounts mapping should be done. A number greater than zero indicates a segment level chart of accounts mapping should be done. The specific number indicates which segment label should apply. | ||
| COA_MAP25 | NUMBER | 2 | Level of chart of accounts mapping to be done for the flexfield, if any. Zero indicates code combination identifier level chart of accounts mapping should be done. A number greater than zero indicates a segment level chart of accounts mapping should be done. The specific number indicates which segment label should apply. | ||
| COA_MAP26 | NUMBER | 2 | Level of chart of accounts mapping to be done for the flexfield, if any. Zero indicates code combination identifier level chart of accounts mapping should be done. A number greater than zero indicates a segment level chart of accounts mapping should be done. The specific number indicates which segment label should apply. | ||
| COA_MAP27 | NUMBER | 2 | Level of chart of accounts mapping to be done for the flexfield, if any. Zero indicates code combination identifier level chart of accounts mapping should be done. A number greater than zero indicates a segment level chart of accounts mapping should be done. The specific number indicates which segment label should apply. | ||
| COA_MAP28 | NUMBER | 2 | Level of chart of accounts mapping to be done for the flexfield, if any. Zero indicates code combination identifier level chart of accounts mapping should be done. A number greater than zero indicates a segment level chart of accounts mapping should be done. The specific number indicates which segment label should apply. | ||
| COA_MAP29 | NUMBER | 2 | Level of chart of accounts mapping to be done for the flexfield, if any. Zero indicates code combination identifier level chart of accounts mapping should be done. A number greater than zero indicates a segment level chart of accounts mapping should be done. The specific number indicates which segment label should apply. | ||
| COA_MAP30 | NUMBER | 2 | Level of chart of accounts mapping to be done for the flexfield, if any. Zero indicates code combination identifier level chart of accounts mapping should be done. A number greater than zero indicates a segment level chart of accounts mapping should be done. The specific number indicates which segment label should apply. | ||
| ALL_SEG_STATUS_NUM | NUMBER | 18 | Indicates the status of the code combination identifier of an account rule. | ||
| STATUS_NUM1 | NUMBER | 18 | Indicates the status of the code combination identifier in the first segment of an account rule. | ||
| STATUS_NUM2 | NUMBER | 18 | Indicates the status of the code combination identifier in the second segment of an account rule. | ||
| STATUS_NUM3 | NUMBER | 18 | Indicates the status of the code combination identifier in the third segment of an account rule. | ||
| STATUS_NUM4 | NUMBER | 18 | Indicates the status of the code combination identifier in the forth segment of an account rule. | ||
| STATUS_NUM5 | NUMBER | 18 | Indicates the status of the code combination identifier in the fifth segment of an account rule. | ||
| STATUS_NUM6 | NUMBER | 18 | Indicates the status of the code combination identifier in the sixth segment of an account rule. | ||
| STATUS_NUM7 | NUMBER | 18 | Indicates the status of the code combination identifier in the seventh segment of an account rule. | ||
| STATUS_NUM8 | NUMBER | 18 | Indicates the status of the code combination identifier in the eighth segment of an account rule. | ||
| STATUS_NUM9 | NUMBER | 18 | Indicates the status of the code combination identifier in the nineth segment of an account rule. | ||
| STATUS_NUM10 | NUMBER | 18 | Indicates the status of the code combination identifier in the tenth segment of an account rule. | ||
| STATUS_NUM11 | NUMBER | 18 | Indicates the status of the code combination identifier in the eleventh segment of an account rule. | ||
| STATUS_NUM12 | NUMBER | 18 | Indicates the status of the code combination identifier in the twelftth segment of an account rule. | ||
| STATUS_NUM13 | NUMBER | 18 | Indicates the status of the code combination identifier in the thirteenth segment of an account rule. | ||
| STATUS_NUM14 | NUMBER | 18 | Indicates the status of the code combination identifier in the fourteenth segment of an account rule. | ||
| STATUS_NUM15 | NUMBER | 18 | Indicates the status of the code combination identifier in the fifteenth segment of an account rule. | ||
| STATUS_NUM16 | NUMBER | 18 | Indicates the status of the code combination identifier in the sixteenth segment of an account rule. | ||
| STATUS_NUM17 | NUMBER | 18 | Indicates the status of the code combination identifier in the seventeenth segment of an account rule. | ||
| STATUS_NUM18 | NUMBER | 18 | Indicates the status of the code combination identifier in the eightteenth segment of an account rule. | ||
| STATUS_NUM19 | NUMBER | 18 | Indicates the status of the code combination identifier in the nineteenth segment of an account rule. | ||
| STATUS_NUM20 | NUMBER | 18 | Indicates the status of the code combination identifier in the twentieth segment of an account rule. | ||
| STATUS_NUM21 | NUMBER | 18 | Indicates the status of the code combination identifier in the twenty-first segment of an account rule. | ||
| STATUS_NUM22 | NUMBER | 18 | Indicates the status of the code combination identifier in the twenty-second segment of an account rule. | ||
| STATUS_NUM23 | NUMBER | 18 | Indicates the status of the code combination identifier in the twenty-third segment of an account rule. | ||
| STATUS_NUM24 | NUMBER | 18 | Indicates the status of the code combination identifier in the twenty-forth segment of an account rule. | ||
| STATUS_NUM25 | NUMBER | 18 | Indicates the status of the code combination identifier in the twenty-fifth segment of an account rule. | ||
| STATUS_NUM26 | NUMBER | 18 | Indicates the status of the code combination identifier in the twenty-sixth segment of an account rule. | ||
| STATUS_NUM27 | NUMBER | 18 | Indicates the status of the code combination identifier in the twenty-seventh segment of an account rule. | ||
| STATUS_NUM28 | NUMBER | 18 | Indicates the status of the code combination identifier in the twenty-eighth segment of an account rule. | ||
| STATUS_NUM29 | NUMBER | 18 | Indicates the status of the code combination identifier in the twenty-ninth segment of an account rule. | ||
| STATUS_NUM30 | NUMBER | 18 | Indicates the status of the code combination identifier in the thirtieth segment of an account rule. | ||
| SEGMENT1 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT2 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT3 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT4 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT5 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT6 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT7 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT8 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT9 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT10 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT11 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT12 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT13 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT14 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT15 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT16 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT17 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT18 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT19 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT20 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT21 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT22 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT23 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT24 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT25 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT26 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT27 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT28 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT29 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. | ||
| SEGMENT30 | VARCHAR2 | 25 | Key Flexfield: segment of the key flexfield. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| XLA_FSN_ACCOUNTS_GT_N1 | Non Unique | PASS_NUM, PROCESS_CODE |
| XLA_FSN_ACCOUNTS_GT_U1 | Unique | ROW_NUM, PASS_NUM |