Journal Line Rules
The journal line rules view object contains information about journal line rules. The combination of JournalLineRuleBaseApplicationId,JournalLineRuleBaseAccountingLineCode, JournalLineRuleBaseAccountingLineTypeCode, JournalLineRuleBaseAmbContextCode,JournalLineRuleBaseEntityCode, and JournalLineRuleBaseEventClassCode forms the unique identifier of the Journal Line Rules view object.
Data Store Key : FscmTopModelAM.FinExtractAM.XlaBiccExtractAM.JournalLineRuleExtractPVO
Primary Keys : JournalLineRuleBaseEventClassCode, JournalLineRuleBaseAccountingLineTypeCode, JournalLineRuleBaseApplicationId, JournalLineRuleBaseAccountingLineCode, JournalLineRuleBaseEntityCode
Initial Extract Date : JournalLineRuleBaseCreationDate
Incremental Extract Date : JournalLineRuleBaseLastUpdateDate
Attributes
This table provides the list of exposed attributes and their descriptions.
| Name | Description |
|---|---|
| JournalLineRuleBaseAccountingClassCode | The accounting class assigned to journal line rule. A list of accepted values is defined in the lookup type XLA_ACCOUNTING_CLASS. |
| JournalLineRuleBaseAccountingEntryTypeCode | Identifies the source of accounting entry. A list of accepted values is defined in the lookup type XLA_ACCOUNTING_ENTRY_SEQ_TYPE. |
| JournalLineRuleBaseAccountingLineCode | This short name of the journal line rule. This attribute is a part of the composite key of the Journal Line Rules view object. |
| JournalLineRuleBaseAccountingLineTypeCode | Indicates whether the journal line rule is seeded. This attribute is a part of the composite key of the Journal Line Rules view object. A list of accepted values is defined in the lookup type XLA_OWNER_TYPE. |
| JournalLineRuleBaseApplicationId | The identifier of the application. This attribute is a part of the composite key of the Journal Line Rules view object. |
| JournalLineRuleBaseBusinessClassCode | The business flow class for the journal line rule. This is used to reference another line within the same business flow. |
| JournalLineRuleBaseBusinessMethodCode | The business flow method for the journal line rule. A list of accepted values is defined in the lookup type XLA_BUSINESS_FLOW_METHOD. |
| JournalLineRuleBaseCreatedBy | The user who created the journal line rule. |
| JournalLineRuleBaseCreationDate | The date and time when the journal line rule was created. |
| JournalLineRuleBaseEnabledFlag | Indicates the status of a journal line rule. A list of accepted values is defined in the lookup type YES_NO. |
| JournalLineRuleBaseEntityCode | The entity associated with the event class assigned to the journal line rule. This attribute is a part of the composite key of the Journal Line Rules view object. |
| JournalLineRuleBaseEventClassCode | The short name of the event class associated with the journal line rule. This attribute is a part of the composite key of the Journal Line Rules view object. |
| JournalLineRuleBaseGainOrLossFlag | Indicates whether this is an exchange gain or loss journal line rule. A list of accepted values is defined in the lookup type YES_NO. |
| JournalLineRuleBaseLastUpdateDate | The date and time when the journal line rule row was last updated. |
| JournalLineRuleBaseLastUpdateLogin | The session login associated with the user who last updated the journal line rule row. |
| JournalLineRuleBaseLastUpdatedBy | The user who last updated the journal line rule. |
| JournalLineRuleBaseMergeDuplicateCode | Indicates how the journal lines with the same attributes are merged within the same subledger journal entry. A list of accepted values is defined in the lookup type XLA_MERGE_MATCHING_TYPE. |
| JournalLineRuleBaseMultiperiodClassCode | The unique abbreviated name assigned to a multiperiod accounting class and used to associate an accrual journal to a multiperiod accounting journal. A list of accepted values is defined in the lookup type ORA_XLA_MULTIPERIOD_CLASS. |
| JournalLineRuleBaseMultiperiodOptionFlag | Indicates whether the journal line rule is used to create a multiperiod journal entry. |
| JournalLineRuleBaseNaturalSideCode | The column determines if the journal line rule is one among credit, debit, gain, or loss |
| JournalLineRuleBaseObjectVersionNumber | The number of times the journal line rule row has been updated. |
| JournalLineRuleBaseRoundingClassCode | The rounding class assigned to the journal line rule. It's used to group journal lines to calculate rounding difference. |
| JournalLineRuleBaseSeedDataSource | The source of seed data record. The value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file. |
| JournalLineRuleBaseSwitchSideFlag | Indicates whether negative amounts will result in negative amounts on the same side or positive amounts on the opposite side. A list of accepted values is defined in the lookup type YES_NO. |
| JournalLineRuleTranslationAccountingLineCode | The short name for the journal line rule. This attribute is a part of the composite key of the Translated Journal Line Rules view object. |
| JournalLineRuleTranslationAccountingLineTypeCode | Indicates whether the journal line rule is seeded. This attribute is a part of the composite key of the Translated Journal Line Rules view object. A list of accepted values is defined in the lookup type XLA_OWNER_TYPE. |
| JournalLineRuleTranslationAmbContextCode | The accounting method builder context for the journal line rule translation. This attribute is a part of the composite key of the Translated Journal Line Rules view object. |
| JournalLineRuleTranslationApplicationId | The identifier of the application. This attribute is a part of the composite key of the Translated Journal Line Rules view object. |
| JournalLineRuleTranslationCreatedBy | The user who created the translated journal line rule translation. |
| JournalLineRuleTranslationCreationDate | The date and time when the translated journal line rule translation was created. |
| JournalLineRuleTranslationDescription | The description of the journal line rule. |
| JournalLineRuleTranslationEntityCode | The short name of the entity associated with the event class assigned to the journal line rule. This attribute is a part of the composite key of the Translated Journal Line Rules view object. |
| JournalLineRuleTranslationEventClassCode | The short name of the event class associated with the journal line rule.This attribute is a part of the composite key of the Translated Journal Line Rules view object. |
| JournalLineRuleTranslationLanguage | Indicates the code of the language into which the contents of the translatable columns are translated. This attribute is a part of the composite key of the Translated Journal Line Rules view object. |
| JournalLineRuleTranslationLastUpdateDate | The date and time when the translated journal line rule row was last updated. |
| JournalLineRuleTranslationLastUpdateLogin | The session login associated with the user who last updated the translated journal line rule row. |
| JournalLineRuleTranslationLastUpdatedBy | The user who last updated the translated journal line rule. |
| JournalLineRuleTranslationName | The translated name of the journal line rule. |
| JournalLineRuleTranslationObjectVersionNumber | The number of times the journal line rule translation row has been updated. |
| JournalLineRuleTranslationSourceLang | Indicates the code of the language in which the contents of the translatable columns were originally created. This attribute is a part of the composite key of the Translated Journal Line Rules view object. |