XLA_LEDGER_OPTIONS
This table contains the subledger accounting options.
Details
-
Schema: FUSION
-
Object owner: XLA
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
XLA_LEDGER_OPTIONS_PK |
APPLICATION_ID, LEDGER_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| APPLICATION_ID | NUMBER | 18 | Yes | Functional area within a software suite of products. For example, Financials or Payroll. | |
| ACCOUNT_DEFINITION_CODE | VARCHAR2 | 30 | Transaction account definition short name. | ||
| ACCOUNT_DEFINITION_TYPE_CODE | VARCHAR2 | 1 | Indicates whether it is a seeded transaction account definition. | ||
| LEDGER_ID | NUMBER | 18 | Yes | Self-contained accounting information set for single or multiple legal or management entities. | |
| TRANSFER_TO_GL_MODE_CODE | VARCHAR2 | 1 | Yes | Stores the general ledger journal entry summarization option | |
| ACCT_REVERSAL_OPTION_CODE | VARCHAR2 | 30 | Yes | Indicates whether accounting reversal should reverse the sides or reverse the amount signs. The possible values are SIDE: reverse the sides for the reversal entries, SIGN: reverse the amount signs for the reversal lines. | |
| CAPTURE_EVENT_FLAG | VARCHAR2 | 1 | Yes | Indicate whether this is a valuation method ledger for the application | |
| 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_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. | |
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| ENABLED_FLAG | VARCHAR2 | 1 | Yes | Indicates whether subledger accounting (or general ledger consolidation) should populate the ledger. | |
| ENABLE_SUBMIT_POSTING_FLAG | VARCHAR2 | 1 | Yes | Indicates whether GL Posting is allowed when accounting is created for subledger transactions. | |
| ROUNDING_RULE_CODE | VARCHAR2 | 30 | Yes | Indicates how amount will be rounded when rounding is performed. Possible Values are: Up: The amount will be rounded up, Down: The amount will be rounded down to nearest: The amount will be rounded to the nearest number. | |
| MERGE_ACCT_OPTION_CODE | VARCHAR2 | 30 | Third party merge accounting option. | ||
| 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. | |
| LAST_ENTITY_ID | NUMBER | 18 | Unique identifier of the last entity. | ||
| EFFECTIVE_PERIOD_NUM | NUMBER | Period when a transaction, such as an asset retirement, is effective. | |||
| PARTITION_GROUP_CODE | VARCHAR2 | 15 | Partition grouping information for this application and ledger, which, when combined with the journal or balance period, determines the database partition in which journals or balances for this application and ledger are stored. | ||
| CALC_SR_BALANCE_FLAG | VARCHAR2 | 1 | Indicates whether to maintain supporting reference balance for the subledger and ledger. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| XLA_LEDGER_OPTIONS_N1 | Non Unique | Default | LEDGER_ID, CAPTURE_EVENT_FLAG |
| XLA_LEDGER_OPTIONS_U1 | Unique | Default | APPLICATION_ID, LEDGER_ID |