XLA_ACCT_LINE_TYPES_B
This table stores journal line rules.
Details
-
Schema: FUSION
-
Object owner: XLA
-
Object type: TABLE
-
Tablespace: REFERENCE
Primary Key
| Name | Columns |
|---|---|
|
XLA_ACCT_LINE_TYPES_B_PK |
APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, AMB_CONTEXT_CODE, ACCOUNTING_LINE_TYPE_CODE, ACCOUNTING_LINE_CODE |
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. | |
| AMB_CONTEXT_CODE | VARCHAR2 | 30 | Yes | Accounting methods builder context. | |
| ENTITY_CODE | VARCHAR2 | 30 | Yes | Unique abbreviated name assigned to an entity and used for reporting or in reference to an option. | |
| EVENT_CLASS_CODE | VARCHAR2 | 30 | Yes | Unique abbreviated name assigned to an event class and used for reporting or in reference to an option. | |
| ACCOUNTING_LINE_TYPE_CODE | VARCHAR2 | 1 | Yes | Indicates whether the journal line rule is seeded. | |
| ACCOUNTING_LINE_CODE | VARCHAR2 | 30 | Yes | Abbreviated name of a rule to convert transactional data into a journal entry line. | |
| TRANSACTION_COA_ID | NUMBER | 18 | Not currently used. | ||
| ACCOUNTING_ENTRY_TYPE_CODE | VARCHAR2 | 1 | Yes | Indicates the accounting line type, for example actual, encumbrances or budget. | |
| NATURAL_SIDE_CODE | VARCHAR2 | 1 | Yes | Indicates whether the journal line rule is for debit, credit, or gain or loss. | |
| GL_TRANSFER_MODE_CODE | VARCHAR2 | 1 | Yes | General ledger transfer option. | |
| SWITCH_SIDE_FLAG | VARCHAR2 | 1 | Determines whether negative amounts will result in negative amounts on the same side or positive amounts on the opposite side. | ||
| MERGE_DUPLICATE_CODE | VARCHAR2 | 1 | Yes | Summarizes journal lines by merging lines with the same values for a specified number of attributes within the same subledger journal entry. | |
| ENABLED_FLAG | VARCHAR2 | 1 | Yes | Indicates the status of a journal line rule. | |
| ACCOUNTING_CLASS_CODE | VARCHAR2 | 30 | Yes | Short name of a lookup type that is shared across application used to classify journal entry lines. | |
| 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. | ||
| ROUNDING_CLASS_CODE | VARCHAR2 | 30 | Yes | Lookup value that is used with the transaction rounding reference to group journal lines and calculate transaction rounding. | |
| BUSINESS_METHOD_CODE | VARCHAR2 | 30 | Yes | Name of a method to associate journal lines of the same business flow class. | |
| BUSINESS_CLASS_CODE | VARCHAR2 | 30 | Unique abbreviated name assigned to a business class and used for reporting or in reference to an option. | ||
| MULTIPERIOD_CLASS_CODE | VARCHAR2 | 30 | Unique abbreviated name assigned to a multiperiod accounting class and used to associate accrual journal to multiperiod accounting journal. | ||
| MULTIPERIOD_OPTION_FLAG | VARCHAR2 | 1 | Multiperiod accounting option. Possible values are Y (the journal line rule is used to create multiperiod accounting journal entries) and N (journal line rule is not used to create multiperiod accounting journal entries). | ||
| MPA_OPTION_CODE | VARCHAR2 | 30 | Multiperiod accounting option. | ||
| ENCUMBRANCE_TYPE_ID | NUMBER | 18 | Identfier of an encumbrance category that allows you to track your encumbrances or anticipated expenditures according to your purchase approval process and to more accurately control your planned expenditures. Examples of encumbrance types are commitments (requisition encumbrances) and obligations (purchase order encumbrances). | ||
| GAIN_OR_LOSS_FLAG | VARCHAR2 | 1 | Subledger gain and loss indicator. | ||
| CROSS_LEDGER_BALANCING_FLAG | VARCHAR2 | 1 | Cross ledger balancing indicator. | ||
| 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. | |
| SEED_DATA_SOURCE | VARCHAR2 | 512 | Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file. | ||
| ORA_SEED_SET1 | VARCHAR2 | 1 | Yes | Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET1. Context values are Y or N. | |
| ORA_SEED_SET2 | VARCHAR2 | 1 | Yes | Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET2. Context values are Y or N. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| XLA_ACCT_LINE_TYPES_B | xla_event_classes_b | APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| XLA_ACCT_LINE_TYPES_B_U1 | Unique | FUSION_TS_TX_DATA | APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, AMB_CONTEXT_CODE, ACCOUNTING_LINE_TYPE_CODE, ACCOUNTING_LINE_CODE, ORA_SEED_SET1 |
| XLA_ACCT_LINE_TYPES_B_U11 | Unique | FUSION_TS_TX_DATA | APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, AMB_CONTEXT_CODE, ACCOUNTING_LINE_TYPE_CODE, ACCOUNTING_LINE_CODE, ORA_SEED_SET2 |