ExternalAccountingTransactionHeader

An external accounting transaction header contains the Oracle Fusion Accounting Hub transaction information used by the accounting program to generate subledger accounting entries.

Expand all

Collapse all

Business Views

** Available for extracting data

• externalAccountingTransactionHeadersExtract**

  An external accounting transaction header contains the Oracle Fusion Accounting Hub transaction information used by the accounting program to generate subledger accounting entries.

  Label

  External Accounting Transaction Headers

  Data Source

  Read-optimized data store

  Expand all

  Collapse all

  Fields

  • applicationId (int64)

    The unique identifier of the source application that represents a functional area.

    Label

    Application

    Properties

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

    The source value of the external transaction for the Character 1 column in alphanumeric format.

    Label

    Transaction Header Character 1

    Properties

    • searchable
    • sortable
  • character10 (string)

    The source value of the external transaction for the Character 10 column in alphanumeric format.

    Label

    Transaction Header Character 10

    Properties

    • searchable
    • sortable
  • character11 (string)

    The source value of the external transaction for the Character 11 column in alphanumeric format.

    Label

    Transaction Header Character 11

    Properties

    • searchable
    • sortable
  • character12 (string)

    The source value of the external transaction for the Character 12 column in alphanumeric format.

    Label

    Transaction Header Character 12

    Properties

    • searchable
    • sortable
  • character13 (string)

    The source value of the external transaction for the Character 13 column in alphanumeric format.

    Label

    Transaction Header Character 13

    Properties

    • searchable
    • sortable
  • character14 (string)

    The source value of the external transaction for the Character 14 column in alphanumeric format.

    Label

    Transaction Header Character 14

    Properties

    • searchable
    • sortable
  • character15 (string)

    The source value of the external transaction for the Character 15 column in alphanumeric format.

    Label

    Transaction Header Character 15

    Properties

    • searchable
    • sortable
  • character16 (string)

    The source value of the external transaction for the Character 16 column in alphanumeric format.

    Label

    Transaction Header Character 16

    Properties

    • searchable
    • sortable
  • character17 (string)

    The source value of the external transaction for the Character 17 column in alphanumeric format.

    Label

    Transaction Header Character 17

    Properties

    • searchable
    • sortable
  • character18 (string)

    The source value of the external transaction for the Character 18 column in alphanumeric format.

    Label

    Transaction Header Character 18

    Properties

    • searchable
    • sortable
  • character19 (string)

    The source value of the external transaction for the Character 19 column in alphanumeric format.

    Label

    Transaction Header Character 19

    Properties

    • searchable
    • sortable
  • character2 (string)

    The source value of the external transaction for the Character 2 column in alphanumeric format.

    Label

    Transaction Header Character 2

    Properties

    • searchable
    • sortable
  • character20 (string)

    The source value of the external transaction for the Character 20 column in alphanumeric format.

    Label

    Transaction Header Character 20

    Properties

    • searchable
    • sortable
  • character21 (string)

    The source value of the external transaction for the Character 21 column in alphanumeric format.

    Label

    Transaction Header Character 21

    Properties

    • searchable
    • sortable
  • character22 (string)

    The source value of the external transaction for the Character 22 column in alphanumeric format.

    Label

    Transaction Header Character 22

    Properties

    • searchable
    • sortable
  • character23 (string)

    The source value of the external transaction for the Character 23 column in alphanumeric format.

    Label

    Transaction Header Character 23

    Properties

    • searchable
    • sortable
  • character24 (string)

    The source value of the external transaction for the Character 24 column in alphanumeric format.

    Label

    Transaction Header Character 24

    Properties

    • searchable
    • sortable
  • character25 (string)

    The source value of the external transaction for the Character 25 column in alphanumeric format.

    Label

    Transaction Header Character 25

    Properties

    • searchable
    • sortable
  • character26 (string)

    The source value of the external transaction for the Character 26 column in alphanumeric format.

    Label

    Transaction Header Character 26

    Properties

    • searchable
    • sortable
  • character27 (string)

    The source value of the external transaction for the Character 27 column in alphanumeric format.

    Label

    Transaction Header Character 27

    Properties

    • searchable
    • sortable
  • character28 (string)

    The source value of the external transaction for the Character 28 column in alphanumeric format.

    Label

    Transaction Header Character 28

    Properties

    • searchable
    • sortable
  • character29 (string)

    The source value of the external transaction for the Character 29 column in alphanumeric format.

    Label

    Transaction Header Character 29

    Properties

    • searchable
    • sortable
  • character3 (string)

    The source value of the external transaction for the Character 3 column in alphanumeric format.

    Label

    Transaction Header Character 3

    Properties

    • searchable
    • sortable
  • character30 (string)

    The source value of the external transaction for the Character 30 column in alphanumeric format.

    Label

    Transaction Header Character 30

    Properties

    • searchable
    • sortable
  • character31 (string)

    The source value of the external transaction for the Character 31 column in alphanumeric format.

    Label

    Transaction Header Character 31

    Properties

    • searchable
    • sortable
  • character32 (string)

    The source value of the external transaction for the Character 32 column in alphanumeric format.

    Label

    Transaction Header Character 32

    Properties

    • searchable
    • sortable
  • character33 (string)

    The source value of the external transaction for the Character 33 column in alphanumeric format.

    Label

    Transaction Header Character 33

    Properties

    • searchable
    • sortable
  • character34 (string)

    The source value of the external transaction for the Character 34 column in alphanumeric format.

    Label

    Transaction Header Character 34

    Properties

    • searchable
    • sortable
  • character35 (string)

    The source value of the external transaction for the Character 35 column in alphanumeric format.

    Label

    Transaction Header Character 35

    Properties

    • searchable
    • sortable
  • character36 (string)

    The source value of the external transaction for the Character 36 column in alphanumeric format.

    Label

    Transaction Header Character 36

    Properties

    • searchable
    • sortable
  • character37 (string)

    The source value of the external transaction for the Character 37 column in alphanumeric format.

    Label

    Transaction Header Character 37

    Properties

    • searchable
    • sortable
  • character38 (string)

    The source value of the external transaction for the Character 38 column in alphanumeric format.

    Label

    Transaction Header Character 38

    Properties

    • searchable
    • sortable
  • character39 (string)

    The source value of the external transaction for the Character 39 column in alphanumeric format.

    Label

    Transaction Header Character 39

    Properties

    • searchable
    • sortable
  • character4 (string)

    The source value of the external transaction for the Character 4 column in alphanumeric format.

    Label

    Transaction Header Character 4

    Properties

    • searchable
    • sortable
  • character40 (string)

    The source value of the external transaction for the Character 40 column in alphanumeric format.

    Label

    Transaction Header Character 40

    Properties

    • searchable
    • sortable
  • character41 (string)

    The source value of the external transaction for the Character 41 column in alphanumeric format.

    Label

    Transaction Header Character 41

    Properties

    • searchable
    • sortable
  • character42 (string)

    The source value of the external transaction for the Character 42 column in alphanumeric format.

    Label

    Transaction Header Character 42

    Properties

    • searchable
    • sortable
  • character43 (string)

    The source value of the external transaction for the Character 43 column in alphanumeric format.

    Label

    Transaction Header Character 43

    Properties

    • searchable
    • sortable
  • character44 (string)

    The source value of the external transaction for the Character 44 column in alphanumeric format.

    Label

    Transaction Header Character 44

    Properties

    • searchable
    • sortable
  • character45 (string)

    The source value of the external transaction for the Character 45 column in alphanumeric format.

    Label

    Transaction Header Character 45

    Properties

    • searchable
    • sortable
  • character46 (string)

    The source value of the external transaction for the Character 46 column in alphanumeric format.

    Label

    Transaction Header Character 46

    Properties

    • searchable
    • sortable
  • character47 (string)

    The source value of the external transaction for the Character 47 column in alphanumeric format.

    Label

    Transaction Header Character 47

    Properties

    • searchable
    • sortable
  • character48 (string)

    The source value of the external transaction for the Character 48 column in alphanumeric format.

    Label

    Transaction Header Character 48

    Properties

    • searchable
    • sortable
  • character49 (string)

    The source value of the external transaction for the Character 49 column in alphanumeric format.

    Label

    Transaction Header Character 49

    Properties

    • searchable
    • sortable
  • character5 (string)

    The source value of the external transaction for the Character 5 column in alphanumeric format.

    Label

    Transaction Header Character 5

    Properties

    • searchable
    • sortable
  • character50 (string)

    The source value of the external transaction for the Character 50 column in alphanumeric format.

    Label

    Transaction Header Character 50

    Properties

    • searchable
    • sortable
  • character6 (string)

    The source value of the external transaction for the Character 6 column in alphanumeric format.

    Label

    Transaction Header Character 6

    Properties

    • searchable
    • sortable
  • character7 (string)

    The source value of the external transaction for the Character 7 column in alphanumeric format.

    Label

    Transaction Header Character 7

    Properties

    • searchable
    • sortable
  • character8 (string)

    The source value of the external transaction for the Character 8 column in alphanumeric format.

    Label

    Transaction Header Character 8

    Properties

    • searchable
    • sortable
  • character9 (string)

    The source value of the external transaction for the Character 9 column in alphanumeric format.

    Label

    Transaction Header Character 9

    Properties

    • searchable
    • sortable
  • createdBy (string)

    The user who created the record.

    Label

    Created By

    Properties

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

    The source value of the external transaction for the Date 1 column in date and time format.

    Label

    Transaction Header Date 1

    Properties

    • searchable
    • sortable
  • date10 (date)

    The source value of the external transaction for the Date 10 column in date and time format.

    Label

    Transaction Header Date 10

    Properties

    • searchable
    • sortable
  • date2 (date)

    The source value of the external transaction for the Date 2 column in date and time format.

    Label

    Transaction Header Date 2

    Properties

    • searchable
    • sortable
  • date3 (date)

    The source value of the external transaction for the Date 3 column in date and time format.

    Label

    Transaction Header Date 3

    Properties

    • searchable
    • sortable
  • date4 (date)

    The source value of the external transaction for the Date 4 column in date and time format.

    Label

    Transaction Header Date 4

    Properties

    • searchable
    • sortable
  • date5 (date)

    The source value of the external transaction for the Date 5 column in date and time format.

    Label

    Transaction Header Date 5

    Properties

    • searchable
    • sortable
  • date6 (date)

    The source value of the external transaction for the Date 6 column in date and time format.

    Label

    Transaction Header Date 6

    Properties

    • searchable
    • sortable
  • date7 (date)

    The source value of the external transaction for the Date 7 column in date and time format.

    Label

    Transaction Header Date 7

    Properties

    • searchable
    • sortable
  • date8 (date)

    The source value of the external transaction for the Date 8 column in date and time format.

    Label

    Transaction Header Date 8

    Properties

    • searchable
    • sortable
  • date9 (date)

    The source value of the external transaction for the Date 9 column in date and time format.

    Label

    Transaction Header Date 9

    Properties

    • searchable
    • sortable
  • eventId (int64)

    The unique identifier of the accounting event within an application and event class.

    Label

    Event Identifier

    Properties

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

    The file name or OCI object storage identifier of the data file using which the transaction was created.

    Label

    File Identifier

    Properties

    • searchable
    • sortable
  • longCharacter1 (string)

    The source value of the external transaction for the Long Character 1 column in alphanumeric format.

    Label

    Transaction Header Long Character 1

    Properties

    • searchable
    • sortable
  • longCharacter2 (string)

    The source value of the external transaction for the Long Character 2 column in alphanumeric format.

    Label

    Transaction Header Long Character 2

    Properties

    • searchable
    • sortable
  • longCharacter3 (string)

    The source value of the external transaction for the Long Character 3 column in alphanumeric format.

    Label

    Transaction Header Long Character 3

    Properties

    • searchable
    • sortable
  • longCharacter4 (string)

    The source value of the external transaction for the Long Character 4 column in alphanumeric format.

    Label

    Transaction Header Long Character 4

    Properties

    • searchable
    • sortable
  • longCharacter5 (string)

    The source value of the external transaction for the Long Character 5 column in alphanumeric format.

    Label

    Transaction Header Long Character 5

    Properties

    • searchable
    • sortable
  • number1 (int64)

    The source value of the external transaction for the Number 1 column in numeric format.

    Label

    Transaction Header Number 1

    Properties

    • searchable
    • sortable
  • number10 (int64)

    The source value of the external transaction for the Number 10 column in numeric format.

    Label

    Transaction Header Number 10

    Properties

    • searchable
    • sortable
  • number2 (int64)

    The source value of the external transaction for the Number 2 column in numeric format.

    Label

    Transaction Header Number 2

    Properties

    • searchable
    • sortable
  • number3 (int64)

    The source value of the external transaction for the Number 3 column in numeric format.

    Label

    Transaction Header Number 3

    Properties

    • searchable
    • sortable
  • number4 (int64)

    The source value of the external transaction for the Number 4 column in numeric format.

    Label

    Transaction Header Number 4

    Properties

    • searchable
    • sortable
  • number5 (int64)

    The source value of the external transaction for the Number 5 column in numeric format.

    Label

    Transaction Header Number 5

    Properties

    • searchable
    • sortable
  • number6 (int64)

    The source value of the external transaction for the Number 6 column in numeric format.

    Label

    Transaction Header Number 6

    Properties

    • searchable
    • sortable
  • number7 (int64)

    The source value of the external transaction for the Number 7 column in numeric format.

    Label

    Transaction Header Number 7

    Properties

    • searchable
    • sortable
  • number8 (int64)

    The source value of the external transaction for the Number 8 column in numeric format.

    Label

    Transaction Header Number 8

    Properties

    • searchable
    • sortable
  • number9 (int64)

    The source value of the external transaction for the Number 9 column in numeric format.

    Label

    Transaction Header Number 9

    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
  • transactionDate (date)

    The date on which the transaction occurred.

    Label

    Transaction Date

    Properties

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

    The Subledger transaction for which the journal entry is created.

    Label

    Transaction Number

    Properties

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

    Indicates whether the record is for transaction reversal.

    Label

    Transaction Reversal Indicator

    Properties

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

    The user who last updated the record.

    Label

    Last Updated By

    Properties

    • searchable
    • sortable
    • not nullable

Back to Top