This table 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.
Module:
RELATIONSHIP_ID
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
---|---|---|---|---|---|---|---|
RELATIONSHIP_ID | NUMBER | 38 | 0 | True | Ledger relationship identifier. | ||
SOURCE_RECORD_ID | VARCHAR2 | 64 | Source record identifier. | ||||
SOURCE_LEDGER_ID | NUMBER | 38 | 0 | Ledger identifier where reporting currency conversions are based from transactions, journals, or balances. | |||
TARGET_LEDGER_ID | VARCHAR2 | 16 | Destination ledger identifier for conversion of transactions, journals, or balances. | ||||
SOURCE_CURRENCY_CODE | VARCHAR | 16 | Source ledger currency code | ||||
SOURCE_LEDGER_NAME | VARCHAR | 32 | Source ledger name | ||||
SOURCE_LEDGER_SHORT_NAME | VARCHAR | 32 | Source ledger short name | ||||
SOURCE_LEDGER_CATEGORY_CODE | VARCHAR | 32 | Source ledger category code | ||||
TARGET_CURRENCY_CODE | VARCHAR | 16 | Target ledger functional currency. | ||||
TARGET_LEDGER_NAME | VARCHAR | 32 | User entered target ledger name. | ||||
TARGET_LEDGER_SHORT_NAME | VARCHAR | 32 | User entered target ledger short name. | ||||
TARGET_LEDGER_CATEGORY_CODE | VARCHAR | 32 | Target ledger category code. Valid values are PRIMARY, SECONDARY and ALC. | ||||
RELATIONSHIP_TYPE_CODE | VARCHAR | 32 | Relationship level between source and target ledger. | ||||
RELATIONSHIP_ENABLED_FLAG | VARCHAR | 16 | Whether or not ledger relationship is enabled. | ||||
GL_RELATIONSHIP_STATUS_CODE | VARCHAR | 32 | Ledger relationship status code. | ||||
SOURCE_CHART_OF_ACCOUNTS_ID | NUMBER | 38 | 0 | Source ledger chart of accounts identifier | |||
TARGET_CHART_OF_ACCOUNTS_ID | NUMBER | 38 | 0 | Target ledger chart of accounts identifier | |||
PRIMARY_LEDGER_ID | NUMBER | 38 | 0 | Ledger identifier of the primary ledger as defined in the accounting configuration. | |||
APPLICATION_ID | NUMBER | 38 | 0 | Application defining column (backward compatible only). | |||
ORG_ID | NUMBER | 38 | 0 | Indicates the identifier of the business unit associated to the row. | |||
TRGT_LEDGER_ID | NUMBER | 38 | 0 | Destination ledger identifier for conversion of transactions, journals, or balances.in Number data type |
Copyright © 2019, 2023, Oracle and/or its affiliates.