GL_LEDGER_RELATIONSHIPS
GL_LEDGER_RELATIONSHIPS contains the relationships between ledgers. Each relationship between a primary ledger and a secondary ledger or between a ledger and its reporting currency is stored in one or more rows in this table. GL_LEDGER_RELATIONSHIPS also contains the chart of accounts mapping, conversion, and initialization rules necessary to convert data from the source ledger to its secondary ledger or reporting currency. For upgrade cases, it may contain multiple rows for a single relationship; one row per application or per operating unit for which that relationship is maintained. GL_LEDGER_RELATIONSHIPS also always contains one row for each ledger and for each subledger or journal level reporting currency, even if that ledger has no relationships defined for it.
Details
-
Schema: FUSION
-
Object owner: GL
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
GL_LEDGER_RELATIONSHIPS_PK |
RELATIONSHIP_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Flexfield-mapping |
|---|---|---|---|---|---|---|
| RELATIONSHIP_ID | NUMBER | 18 | Yes | Ledger relationship defining column. | ||
| SOURCE_LEDGER_ID | NUMBER | 18 | Yes | Ledger identifier where reporting currency conversions are based from transactions, journals, or balances. | ||
| TARGET_LEDGER_ID | NUMBER | 18 | Yes | Destination ledger identifier for conversion of transactions, journals, or balances. | ||
| SLA_LEDGER_ID | NUMBER | 18 | Yes | Ledger identifier in the subledger transactions used for creating subledger accounting entries. | ||
| PRIMARY_LEDGER_ID | NUMBER | 18 | Yes | Ledger identifier of the primary ledger as defined in the accounting configuration. | ||
| TARGET_CURRENCY_CODE | VARCHAR2 | 15 | Yes | Target ledger functional currency. | ||
| TARGET_LEDGER_NAME | VARCHAR2 | 30 | Yes | User entered target ledger name. | ||
| TARGET_LEDGER_SHORT_NAME | VARCHAR2 | 20 | Yes | User entered target ledger short name. | ||
| TARGET_LEDGER_CATEGORY_CODE | VARCHAR2 | 30 | Yes | Target ledger category. Valid values are PRIMARY, SECONDARY and ALC. | ||
| RELATIONSHIP_TYPE_CODE | VARCHAR2 | 30 | Yes | Relationship level between source and target ledger. | ||
| RELATIONSHIP_ENABLED_FLAG | VARCHAR2 | 1 | Yes | Whether or not ledger relationship is enabled. | ||
| INHERIT_CREATION_USER_FLAG | VARCHAR2 | 1 | Yes | Whether or not to inherit user creation from source transaction. | ||
| 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. | ||
| 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_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | |||
| GL_JE_CONVERSION_SET_ID | NUMBER | 18 | Journal conversion rules identifier. | |||
| SL_COA_MAPPING_ID | NUMBER | 18 | Key flexfield structure identifier. | |||
| AUTOMATIC_POST_FLAG | VARCHAR2 | 1 | Whether or not to post the journal automatically in target ledger. | |||
| ALC_DEFAULT_CONV_RATE_TYPE | VARCHAR2 | 30 | Default conversion rate type for reporting ledger journal. | |||
| ALC_NO_RATE_ACTION_CODE | VARCHAR2 | 30 | Report error or use the last available rate when no rate exists. | |||
| ALC_MAX_DAYS_ROLL_RATE | NUMBER | Maximum roll days allowed for a conversion rate. | ||||
| ALC_INHERIT_CONVERSION_TYPE | VARCHAR2 | 1 | Inherit conversion rate type from transaction. | |||
| ALC_INIT_CONV_OPTION_CODE | VARCHAR2 | 30 | Historical conversion option (Derive and Initialize). | |||
| ALC_INIT_PERIOD | VARCHAR2 | 15 | First accounting period for reporting currency. | |||
| ALC_INIT_DATE | DATE | First accounting date for reporting currency. | ||||
| ALC_INITIALIZING_RATE_DATE | DATE | Rate date used for initializing historical transactions or balances. | ||||
| ALC_INITIALIZING_RATE_TYPE | VARCHAR2 | 30 | Rate type used for initializing historical transactions or balances. | |||
| ALC_PERIOD_AVERAGE_RATE_TYPE | VARCHAR2 | 30 | Reporting currency period average rate type. | |||
| ALC_PERIOD_END_RATE_TYPE | VARCHAR2 | 30 | Reporting currency period end rate type. | |||
| APPLICATION_ID | NUMBER | 18 | Application defining column (backward compatible only). | |||
| ORG_ID | NUMBER | 18 | Yes | Indicates the identifier of the business unit associated to the row. | ||
| DISABLE_CONVERSION_DATE | DATE | Date which conversion is disabled. | ||||
| STATUS_CODE | VARCHAR2 | 30 | Ledger relationship status code. | |||
| 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. | ||
| REV_EXP_XLATION_RULE_CODE | VARCHAR2 | 9 | Revenue or expense translation rule. | |||
| OE_XLATION_RULE_CODE | VARCHAR2 | 9 | Owner equity translation rule. | |||
| BSV_REPLICATION_FLAG | VARCHAR2 | 1 | Identifies whether journal replication by primary balancing segment value is enabled between a source primary ledger and a target secondary ledger. Valid values are N for not enabled, Y for enabled, and blank. | |||
| BSV_REPLICATION_ENABLED_DATE | DATE | Indicates the date when journal replication by primary balancing segment value is enabled. | ||||
| SOURCE_TREE_CODE | VARCHAR2 | 30 | Tree code for the primary balancing segment in the source ledger. | |||
| SOURCE_TREE_VERSION_ID | VARCHAR2 | 32 | Tree version for the tree code associated with the primary balancing segment in the source ledger. | |||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 150 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | Secondary Ledger Conversion Rules (GL_LEDGER_RELATIONSHIPS) | ||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Secondary Ledger Conversion Rules (GL_LEDGER_RELATIONSHIPS) | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Secondary Ledger Conversion Rules (GL_LEDGER_RELATIONSHIPS) | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Secondary Ledger Conversion Rules (GL_LEDGER_RELATIONSHIPS) | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Secondary Ledger Conversion Rules (GL_LEDGER_RELATIONSHIPS) | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Secondary Ledger Conversion Rules (GL_LEDGER_RELATIONSHIPS) | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Secondary Ledger Conversion Rules (GL_LEDGER_RELATIONSHIPS) | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Secondary Ledger Conversion Rules (GL_LEDGER_RELATIONSHIPS) | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Secondary Ledger Conversion Rules (GL_LEDGER_RELATIONSHIPS) | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Secondary Ledger Conversion Rules (GL_LEDGER_RELATIONSHIPS) | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Secondary Ledger Conversion Rules (GL_LEDGER_RELATIONSHIPS) | ||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Secondary Ledger Conversion Rules (GL_LEDGER_RELATIONSHIPS) | ||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Secondary Ledger Conversion Rules (GL_LEDGER_RELATIONSHIPS) | ||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Secondary Ledger Conversion Rules (GL_LEDGER_RELATIONSHIPS) | ||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Secondary Ledger Conversion Rules (GL_LEDGER_RELATIONSHIPS) | ||
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Secondary Ledger Conversion Rules (GL_LEDGER_RELATIONSHIPS) |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| GL_LEDGER_RELATIONSHIPS | gl_ledgers | SOURCE_LEDGER_ID |
| GL_LEDGER_RELATIONSHIPS | gl_ledgers | TARGET_LEDGER_ID |
| GL_LEDGER_RELATIONSHIPS | gl_ledgers | PRIMARY_LEDGER_ID |
| GL_LEDGER_RELATIONSHIPS | gl_ledgers | SLA_LEDGER_ID |
| GL_LEDGER_RELATIONSHIPS | gl_ledgers | TARGET_LEDGER_NAME |
| GL_LEDGER_RELATIONSHIPS | gl_daily_conversion_types | ALC_INITIALIZING_RATE_TYPE |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| GL_LEDGER_RELATIONSHIPS_N1 | Non Unique | Default | PRIMARY_LEDGER_ID, TARGET_LEDGER_CATEGORY_CODE |
| GL_LEDGER_RELATIONSHIPS_N2 | Non Unique | Default | TARGET_LEDGER_ID, SOURCE_LEDGER_ID, TARGET_LEDGER_NAME |
| GL_LEDGER_RELATIONSHIPS_N3 | Non Unique | Default | TARGET_LEDGER_ID, APPLICATION_ID |
| GL_LEDGER_RELATIONSHIPS_U1 | Unique | Default | RELATIONSHIP_ID |
| GL_LEDGER_RELATIONSHIPS_U2 | Unique | Default | SOURCE_LEDGER_ID, TARGET_LEDGER_CATEGORY_CODE, RELATIONSHIP_TYPE_CODE, TARGET_LEDGER_ID, TARGET_CURRENCY_CODE, PRIMARY_LEDGER_ID, APPLICATION_ID, ORG_ID |