LedgerBudgetBalance

A ledger budget balance provides general ledger budget balances data used for variance reporting. The budget balances data is loaded into the balances cube for reporting. The budget balances data consists of the budget name, ledger, accounting period, and currency information.

Expand all

Collapse all

Business Views

** Available for extracting data

• ledgerBudgetBalancesExtract**

  A ledger budget balance provides general ledger budget balances data used for variance reporting. The budget balances data is loaded into the balances cube for reporting. The budget balances data consists of the budget name, ledger, accounting period, and currency information.

  Label

  Ledger Budget Balances

  Data Source

  Read-optimized data store

  Expand all

  Collapse all

  Fields

  • budgetName (string)

    Name of the budget used to identify budget balances.

    Label

    Budget Name

    Properties

    • searchable
    • sortable
    • not nullable
  • createdBy (string)

    The user who created the record.

    Label

    Created By

    Properties

    • searchable
    • sortable
    • not readable
    • not nullable
  • currencyCode (string)

    Currency used in the ledger or as the entered currency.

    Label

    Currency

    Properties

    • searchable
    • sortable
    • not nullable
  • currencyTypeCode (string)

    Indicates type of currency in the budget balance. A list of accepted values is defined in the lookup type GL_CURRENCY_TYPE.

    Label

    Currency Type

    Properties

    • searchable
    • sortable
    • not nullable
  • ledgerId (int64)

    Unique identifier of the ledger.

    Label

    Ledger ID

    Properties

    • searchable
    • sortable
    • not nullable
  • periodName (string)

    Fiscal period used to report budget results, such as a calendar month.

    Label

    Period Name

    Properties

    • searchable
    • sortable
    • not nullable
  • periodNetCredit (big-decimal)

    Period net credit balance in the ledger or entered currency.

    Label

    Period Net Activity Credit

    Properties

    • searchable
    • sortable
  • periodNetDebit (big-decimal)

    Period net debit balance in the ledger or entered currency.

    Label

    Period Net Activity Debit

    Properties

    • searchable
    • sortable
  • segment1 (string)

    Segment 1 value of the accounting flexfield structure.

    Label

    Chart of Accounts Segment 1

    Properties

    • searchable
    • sortable
  • segment10 (string)

    Segment 10 value of the accounting flexfield structure.

    Label

    Chart of Accounts Segment 10

    Properties

    • searchable
    • sortable
  • segment11 (string)

    Segment 11 value of the accounting flexfield structure.

    Label

    Chart of Accounts Segment 11

    Properties

    • searchable
    • sortable
  • segment12 (string)

    Segment 12 value of the accounting flexfield structure.

    Label

    Chart of Accounts Segment 12

    Properties

    • searchable
    • sortable
  • segment13 (string)

    Segment 13 value of the accounting flexfield structure.

    Label

    Chart of Accounts Segment 13

    Properties

    • searchable
    • sortable
  • segment14 (string)

    Segment 14 value of the accounting flexfield structure.

    Label

    Chart of Accounts Segment 14

    Properties

    • searchable
    • sortable
  • segment15 (string)

    Segment 15 value of the accounting flexfield structure.

    Label

    Chart of Accounts Segment 15

    Properties

    • searchable
    • sortable
  • segment16 (string)

    Segment 16 value of the accounting flexfield structure.

    Label

    Chart of Accounts Segment 16

    Properties

    • searchable
    • sortable
  • segment17 (string)

    Segment 17 value of the accounting flexfield structure.

    Label

    Chart of Accounts Segment 17

    Properties

    • searchable
    • sortable
  • segment18 (string)

    Segment 18 value of the accounting flexfield structure.

    Label

    Chart of Accounts Segment 18

    Properties

    • searchable
    • sortable
  • segment19 (string)

    Segment 19 value of the accounting flexfield structure.

    Label

    Chart of Accounts Segment 19

    Properties

    • searchable
    • sortable
  • segment2 (string)

    Segment 2 value of the accounting flexfield structure.

    Label

    Chart of Accounts Segment 2

    Properties

    • searchable
    • sortable
  • segment20 (string)

    Segment 20 value of the accounting flexfield structure.

    Label

    Chart of Accounts Segment 20

    Properties

    • searchable
    • sortable
  • segment21 (string)

    Segment 21 value of the accounting flexfield structure.

    Label

    Chart of Accounts Segment 21

    Properties

    • searchable
    • sortable
  • segment22 (string)

    Segment 22 value of the accounting flexfield structure.

    Label

    Chart of Accounts Segment 22

    Properties

    • searchable
    • sortable
  • segment23 (string)

    Segment 23 value of the accounting flexfield structure.

    Label

    Chart of Accounts Segment 23

    Properties

    • searchable
    • sortable
  • segment24 (string)

    Segment 24 value of the accounting flexfield structure.

    Label

    Chart of Accounts Segment 24

    Properties

    • searchable
    • sortable
  • segment25 (string)

    Segment 25 value of the accounting flexfield structure.

    Label

    Chart of Accounts Segment 25

    Properties

    • searchable
    • sortable
  • segment26 (string)

    Segment 26 value of the accounting flexfield structure.

    Label

    Chart of Accounts Segment 26

    Properties

    • searchable
    • sortable
  • segment27 (string)

    Segment 27 value of the accounting flexfield structure.

    Label

    Chart of Accounts Segment 27

    Properties

    • searchable
    • sortable
  • segment28 (string)

    Segment 28 value of the accounting flexfield structure.

    Label

    Chart of Accounts Segment 28

    Properties

    • searchable
    • sortable
  • segment29 (string)

    Segment 29 value of the accounting flexfield structure.

    Label

    Chart of Accounts Segment 29

    Properties

    • searchable
    • sortable
  • segment3 (string)

    Segment 3 value of the accounting flexfield structure.

    Label

    Chart of Accounts Segment 3

    Properties

    • searchable
    • sortable
  • segment30 (string)

    Segment 30 value of the accounting flexfield structure.

    Label

    Chart of Accounts Segment 30

    Properties

    • searchable
    • sortable
  • segment4 (string)

    Segment 4 value of the accounting flexfield structure.

    Label

    Chart of Accounts Segment 4

    Properties

    • searchable
    • sortable
  • segment5 (string)

    Segment 5 value of the accounting flexfield structure.

    Label

    Chart of Accounts Segment 5

    Properties

    • searchable
    • sortable
  • segment6 (string)

    Segment 6 value of the accounting flexfield structure.

    Label

    Chart of Accounts Segment 6

    Properties

    • searchable
    • sortable
  • segment7 (string)

    Segment 7 value of the accounting flexfield structure.

    Label

    Chart of Accounts Segment 7

    Properties

    • searchable
    • sortable
  • segment8 (string)

    Segment 8 value of the accounting flexfield structure.

    Label

    Chart of Accounts Segment 8

    Properties

    • searchable
    • sortable
  • segment9 (string)

    Segment 9 value of the accounting flexfield structure.

    Label

    Chart of Accounts Segment 9

    Properties

    • searchable
    • sortable
  • timeCreated (date-time)

    The date and time when the record was created.

    Label

    Creation Date

    Properties

    • searchable
    • sortable
    • not readable
    • not nullable
  • timeUpdated (date-time)

    The date and time when the record was last updated.

    Label

    Last Updated Date

    Properties

    • searchable
    • sortable
    • not readable
    • not nullable
  • updatedBy (string)

    The user who last updated the record.

    Label

    Last Updated By

    Properties

    • searchable
    • sortable
    • not readable
    • not nullable

Back to Top