SubledgerJournalLineRule
A subledger journal line rule outlines the details of an accounting entry line within a subledger accounting entry. Each journal line rule is linked to a specific event class and contains details such as application identifier, entity, event class, natural side, accounting class and other relevant information associated with the journal line rule.
Business Views
** Available for extracting data- subledgerJournalLineRulesExtract**
A subledger journal line rule outlines the details of an accounting entry line within a subledger accounting entry. Each journal line rule is linked to a specific event class and contains details such as application identifier, entity, event class, natural side, accounting class and other relevant information associated with the journal line rule.
Label
Subledger Journal Line Rules
Data Source
Read-optimized data store
Fields
- accountingClassCode (string)
The accounting class assigned to journal line rule.
Label
Accounting Class
Properties
- searchable
- sortable
- not nullable
- accountingLineCode (string)
The short name of the journal line rule.
Label
Journal Line Rule Short Name
Properties
- searchable
- sortable
- not nullable
- accountingLineTypeCode (string)
Indicates whether the journal line rule is predefined.
Label
Journal Line Rule Type
Properties
- searchable
- sortable
- not nullable
- ambContextCode (string)
The accounting method builder context for the journal line rule.
Label
Accounting Method Builder Context
Properties
- searchable
- sortable
- not nullable
- applicationId (int64)
The identifier of the application.
Label
Application
Properties
- searchable
- sortable
- not nullable
- createdBy (string)
The user who created the record.
Label
Created By
Properties
- searchable
- sortable
- not nullable
- description (string)
The description of the journal line rule.
Label
Description
Properties
- translatable
- enabledFlag (boolean)
Indicates whether the journal line rule is active.
Label
Active
Properties
- searchable
- sortable
- not nullable
- entityCode (string)
The short name of the entity associated with the event class assigned to the journal line rule.
Label
Entity Code
Properties
- searchable
- sortable
- not nullable
- eventClassCode (string)
The short name of the event class associated with the journal line rule.
Label
Event Class
Properties
- searchable
- sortable
- not nullable
- gainOrLossFlag (boolean)
Indicates whether this is an exchange gain or loss journal line rule.
Label
Gain or Loss Indicator
Properties
- searchable
- sortable
- mergeDuplicateCode (string)
Indicates how the journal lines with the same attributes are merged within the same subledger accounting entry.
Label
Merge Matching Lines
Properties
- searchable
- sortable
- not nullable
- multiperiodOptionFlag (boolean)
Indicates whether the journal line rule is used to create a multiperiod journal entry.
Label
Multiperiod
Properties
- searchable
- sortable
- name (string)
The name of the journal line rule.
Label
Journal Line Rule Name
Properties
- translatable
- not nullable
- naturalSideCode (string)
Indicates whether the journal line rule is used for generating a Debit, Credit or, Gain or Loss accounting line.
Label
Side
Properties
- searchable
- sortable
- not nullable
- switchSideFlag (boolean)
Indicates whether negative amounts will result in negative amounts on the same side or positive amounts on the opposite side.
Label
Switch Debit and Credit
Properties
- searchable
- sortable
- timeCreated (date-time)
The date and time when the record was created.
Label
Creation Date
Properties
- searchable
- sortable
- not nullable
- timeUpdated (date-time)
The date and time when the record was last updated.
Label
Last Updated Date
Properties
- searchable
- sortable
- not nullable
- updatedBy (string)
The user who last updated the record.
Label
Last Updated By
Properties
- searchable
- sortable
- not nullable
- $language (string)
The language of the record.
Label
Language
Properties
- creatable
- translatable
- not nullable
- $sourceLang (string)
The language in which the values of the translatable columns were created, updated, or copied from.
Label
Source Language
Properties
- translatable
- not nullable
Reference Object
- accountingEntryTypeLookup (ERPLookupCode)
The accounting entry type short name indicating whether the journal line rule generates actual, encumbrance, or budget journals.
Business Object
ERPLookupCodeFields
- lookupCode (string)
The unique identifier of the Lookup Code.
Label
Lookup Code ID
Properties
- inherited
- searchable
- sortable
- not nullable
- lookupCode (string)
- businessClassLookup (ERPLookupCode)
The short name of a method that's used to associate journal lines of the same business flow class.
Business Object
ERPLookupCodeFields
- lookupCode (string)
The unique identifier of the Lookup Code.
Label
Lookup Code ID
Properties
- inherited
- searchable
- sortable
- not nullable
- lookupCode (string)
- businessMethodLookup (ERPLookupCode)
The short name of a method that's used to associate journal lines of the same business flow class.
Business Object
ERPLookupCodeFields
- lookupCode (string)
The unique identifier of the Lookup Code.
Label
Lookup Code ID
Properties
- inherited
- searchable
- sortable
- not nullable
- lookupCode (string)
- multiperiodClassLookup (ERPLookupCode)
The unique short name assigned to a multiperiod accounting class, used to associate accrual journals with multiperiod accounting journals.
Business Object
ERPLookupCodeFields
- lookupCode (string)
The unique identifier of the Lookup Code.
Label
Lookup Code ID
Properties
- inherited
- searchable
- sortable
- not nullable
- lookupCode (string)
- roundingClassLookup (ERPLookupCode)
The lookup value used with the transaction rounding reference to group journal lines and calculate transaction rounding.
Business Object
ERPLookupCodeFields
- lookupCode (string)
The unique identifier of the Lookup Code.
Label
Lookup Code ID
Properties
- inherited
- searchable
- sortable
- not nullable
- lookupCode (string)
- accountingClassCode (string)