VRM_LEDGER_OPTIONS
This table contains ledger options information.
Details
-
Schema: FUSION
-
Object owner: VRM
-
Object type: TABLE
-
Tablespace: TRANSACTION_TABLES
Primary Key
| Name | Columns |
|---|---|
|
VRM_LEDGER_OPTIONS_PK |
LEDGER_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Status |
|---|---|---|---|---|---|---|
| LEDGER_ID | NUMBER | 18 | Yes | Unique identifier of a ledger. | ||
| CREATE_ROUNDING_ENTRIES_FLAG | VARCHAR2 | 1 | Yes | No longer used. | Obsolete | |
| DISCOUNT_CLG_DEF_ACCOUNT_CCID | NUMBER | 18 | Yes | Discount clearing default account used for accounting. | ||
| ROUND_CLG_DEFAULT_ACCOUNT | NUMBER | 18 | No longer used. | Obsolete | ||
| LIABILITY_DEF_ACCOUNT_CCID | NUMBER | 18 | Yes | Contract liability default account used for accounting. | ||
| ASSET_DEF_ACCOUNT_CCID | NUMBER | 18 | Yes | Contract asset default account used for accounting. | ||
| PRICE_VAR_DEF_ACCOUNT_CCID | NUMBER | 18 | Yes | Price variance default account used for accounting. | ||
| REVIEW_THRESHOLD_AMT | NUMBER | Review threshold contract amount. Contracts above threshold will need approval. | ||||
| TRX_PRICE_EXEMP_THRESHOLD_AMT | NUMBER | Transaction price exemption threshold amount. Contracts below this threshold will not be considered for allocation. | ||||
| DISCOUNT_EXEMP_THRESHOLD_AMT | NUMBER | Discount exemption threshold amount. | ||||
| CREATED_FROM | VARCHAR2 | 30 | Yes | The process or user interface from which this row is created.. | ||
| 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. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | ||
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | |||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | ||
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | |||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | |||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | |||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE16 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE17 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE18 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE19 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE20 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE1 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_DATE2 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_DATE3 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_DATE4 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_DATE5 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_NUMBER1 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_NUMBER2 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_NUMBER3 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_NUMBER4 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_NUMBER5 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| IFRS_LEDGER_ID | NUMBER | 18 | Ledger unique identification number. The View Contract Activities page displays the accounting for the ledger that is selected in this column. A value for this column is specified only if the primary ledger is not used for IFRS 15 accounting. If no value is selected for this column, the View Contract Activities page displays the data for the primary ledger. | |||
| ADOPTION_PERIOD | VARCHAR2 | 15 | The fiscal period from which the company recognizes and accounts revenue according to the IFRS 15 and ASC 606 accounting standards. | |||
| WRITEOFF_DEF_ACCOUNT_CCID | NUMBER | 18 | Default account used for recording residual balance adjustments. | |||
| ALLOCATION_METHOD_CODE | VARCHAR2 | 30 | The allocation currency basis used to allocate and recognize revenue for a contract. Valid values are from the lookup type ORA_VRM_ALLOCATION_METHOD. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| VRM_LEDGER_OPTIONS | gl_ledgers | LEDGER_ID |
| VRM_LEDGER_OPTIONS | gl_code_combinations | DISCOUNT_CLG_DEF_ACCOUNT_CCID |
| VRM_LEDGER_OPTIONS | gl_code_combinations | ROUND_CLG_DEFAULT_ACCOUNT |
| VRM_LEDGER_OPTIONS | gl_code_combinations | LIABILITY_DEF_ACCOUNT_CCID |
| VRM_LEDGER_OPTIONS | gl_code_combinations | ASSET_DEF_ACCOUNT_CCID |
| VRM_LEDGER_OPTIONS | gl_code_combinations | PRICE_VAR_DEF_ACCOUNT_CCID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| VRM_LEDGER_OPTIONS_U1 | Unique | Default | LEDGER_ID |