# DW_FA_CONVENTION_TYPES_D

This is the FA dimension table for Fixed asset Convention types details

## Details

Module: Assets

## Key Columns

CONVENTION_TYPE_ID

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
CONVENTION_TYPE_ID | NUMBER | 38 | 0 | True | Identifier of the prorate convention. |  |
SOURCE_RECORD_ID | VARCHAR2 | 64 |  |  | This column is for Oracle Internal use only. Source record identifier. Value is derived from a combination of prorate convention identifier. |  |
PRORATE_CONVENTION_CODE | VARCHAR2 | 16 |  |  | Unique name of the prorate convention. | DW_GL_CODE_COMBINATION_D | CODE_COMBINATION_ID
DESCRIPTION | VARCHAR2 | 64 |  |  | Description of the prorate convention. |  |
FISCAL_YEAR_NAME | VARCHAR2 | 32 |  |  | Name of the fiscal year for which the convention is defined. |  |

Copyright © 2019, 2025, Oracle and/or its affiliates.