LedgerSegmentValueAssignment

A general ledger segment value assignment contains information about the balancing segment values that are assigned to a ledger such as a balancing segment value, the ledger it's assigned to, and the start and end date of the assignment.

Expand all

Collapse all

Business Views

** Available for extracting data

• generalLedgerSegmentValueAssignmentsExtract**

  A general ledger segment value assignment contains information about the balancing segment values that are assigned to a ledger such as a balancing segment value, the ledger it's assigned to, and the start and end date of the assignment.

  Label

  General Ledger Segment Value Assignments

  Data Source

  Read-optimized data store

  Expand all

  Collapse all

  Fields

  • createdBy (string)

    The user who created the record.

    Label

    Created By

    Properties

    • searchable
    • sortable
    • not nullable
  • endDate (date)

    Date when a balancing segment value such as company becomes inactive for a specific ledger or legal entity.

    Label

    End Date

    Properties

    • searchable
    • sortable
  • ledgerId (int64)

    The unique identifier of the ledger for which the accounting entry is created.

    Label

    Ledger ID

    Properties

    • searchable
    • sortable
    • not nullable
  • segmentTypeCode (enumeration: LedgerSegmentType)

    The segment type of an account segment. For example, balancing or management.

    Label

    Segment Type Code

    Type

    • Module: oraErpCoreStructure

    • Enumeration Type: LedgerSegmentType

    Properties

    • searchable
    • sortable
    • not nullable

    Valid Values

    • B
  • segmentValue (string)

    Segment value assigned to a ledger.

    Label

    Segment Value

    Properties

    • searchable
    • sortable
    • not nullable
  • slaSequencingFlag (boolean)

    Indicates whether subledger sequencing is required. If Y, then subledger sequencing is required. If N, then subledger sequencing isn't required.

    Label

    Subledger Sequencing

    Properties

    • searchable
    • sortable
  • startDate (date)

    Date when a balancing segment value such as company becomes active for a specific ledger or legal entity.

    Label

    Start Date

    Properties

    • searchable
    • sortable
  • statusCode (enumeration: LedgerSegmentAssignmentStatus)

    Current state of a balancing segment value's relationship with a ledger or legal entity. Valid values are Active and Inactive.

    Label

    Status Code

    Type

    • Module: oraErpCoreStructure

    • Enumeration Type: LedgerSegmentAssignmentStatus

    Properties

    • searchable
    • sortable

    Valid Values

    • D
    • I
    • U
  • 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

  Expand all

  Collapse all

  Reference Object

  • legalEntity (LegalEntity)

    A legal entity represents an entity created under a commercial law which can own property, create obligation, recruit people, trade, account for themselves to regulators, taxation authorities, and owners. It identifies the legal owner or custodian for each business transaction for legal compliance and reporting.

    Business Object

    LegalEntity

    Expand all

    Collapse all

    Fields

    • legalEntityId (int64)

      The unique identifier of the legal entity. This is the primary key of the Legal Entities view object.

      Label

      Legal Entity ID

      Properties

      • searchable
      • sortable
      • not nullable

Back to Top