ExternalAccountingTransactionLine
An external accounting transaction line contains the Oracle Fusion Accounting Hub transaction line information. There is a one-to-many relationship between the accounting transaction header and the accounting transaction line, which is used by the accounting program to generate subledger accounting entries.
Business Views
** Available for extracting data- externalAccountingTransactionLinesExtract**
An external accounting transaction line contains the Oracle Fusion Accounting Hub transaction line information. There is a one-to-many relationship between the accounting transaction header and the accounting transaction line, which is used by the accounting program to generate subledger accounting entries.
Label
External Accounting Transaction Lines
Data Source
Read-optimized data store
Fields
- applicationId (int64)
The unique identifier of the source application which represents a functional area.
Label
Application
Properties
- searchable
- sortable
- not nullable
- character1 (string)
The source value of the external transaction line for the Character 1 column in alphanumeric format.
Label
Transaction Line Character 1
Properties
- searchable
- sortable
- character10 (string)
The source value of the external transaction line for the Character 10 column in alphanumeric format.
Label
Transaction Line Character 10
Properties
- searchable
- sortable
- character100 (string)
The source value of the external transaction line for the Character 100 column in alphanumeric format.
Label
Transaction Line Character 100
Properties
- searchable
- sortable
- character11 (string)
The source value of the external transaction line for the Character 11 column in alphanumeric format.
Label
Transaction Line Character 11
Properties
- searchable
- sortable
- character12 (string)
The source value of the external transaction line for the Character 12 column in alphanumeric format.
Label
Transaction Line Character 12
Properties
- searchable
- sortable
- character13 (string)
The source value of the external transaction line for the Character 13 column in alphanumeric format.
Label
Transaction Line Character 13
Properties
- searchable
- sortable
- character14 (string)
The source value of the external transaction line for the Character 14 column in alphanumeric format.
Label
Transaction Line Character 14
Properties
- searchable
- sortable
- character15 (string)
The source value of the external transaction line for the Character 15 column in alphanumeric format.
Label
Transaction Line Character 15
Properties
- searchable
- sortable
- character16 (string)
The source value of the external transaction line for the Character 16 column in alphanumeric format.
Label
Transaction Line Character 16
Properties
- searchable
- sortable
- character17 (string)
The source value of the external transaction line for the Character 17 column in alphanumeric format.
Label
Transaction Line Character 17
Properties
- searchable
- sortable
- character18 (string)
The source value of the external transaction line for the Character 18 column in alphanumeric format.
Label
Transaction Line Character 18
Properties
- searchable
- sortable
- character19 (string)
The source value of the external transaction line for the Character 19 column in alphanumeric format.
Label
Transaction Line Character 19
Properties
- searchable
- sortable
- character2 (string)
The source value of the external transaction line for the Character 2 column in alphanumeric format.
Label
Transaction Line Character 2
Properties
- searchable
- sortable
- character20 (string)
The source value of the external transaction line for the Character 20 column in alphanumeric format.
Label
Transaction Line Character 20
Properties
- searchable
- sortable
- character21 (string)
The source value of the external transaction line for the Character 21 column in alphanumeric format.
Label
Transaction Line Character 21
Properties
- searchable
- sortable
- character22 (string)
The source value of the external transaction line for the Character 22 column in alphanumeric format.
Label
Transaction Line Character 22
Properties
- searchable
- sortable
- character23 (string)
The source value of the external transaction line for the Character 23 column in alphanumeric format.
Label
Transaction Line Character 23
Properties
- searchable
- sortable
- character24 (string)
The source value of the external transaction line for the Character 24 column in alphanumeric format.
Label
Transaction Line Character 24
Properties
- searchable
- sortable
- character25 (string)
The source value of the external transaction line for the Character 25 column in alphanumeric format.
Label
Transaction Line Character 25
Properties
- searchable
- sortable
- character26 (string)
The source value of the external transaction line for the Character 26 column in alphanumeric format.
Label
Transaction Line Character 26
Properties
- searchable
- sortable
- character27 (string)
The source value of the external transaction line for the Character 27 column in alphanumeric format.
Label
Transaction Line Character 27
Properties
- searchable
- sortable
- character28 (string)
The source value of the external transaction line for the Character 28 column in alphanumeric format.
Label
Transaction Line Character 28
Properties
- searchable
- sortable
- character29 (string)
The source value of the external transaction line for the Character 29 column in alphanumeric format.
Label
Transaction Line Character 29
Properties
- searchable
- sortable
- character3 (string)
The source value of the external transaction line for the Character 3 column in alphanumeric format.
Label
Transaction Line Character 3
Properties
- searchable
- sortable
- character30 (string)
The source value of the external transaction line for the Character 30 column in alphanumeric format.
Label
Transaction Line Character 30
Properties
- searchable
- sortable
- character31 (string)
The source value of the external transaction line for the Character 31 column in alphanumeric format.
Label
Transaction Line Character 31
Properties
- searchable
- sortable
- character32 (string)
The source value of the external transaction line for the Character 32 column in alphanumeric format.
Label
Transaction Line Character 32
Properties
- searchable
- sortable
- character33 (string)
The source value of the external transaction line for the Character 33 column in alphanumeric format.
Label
Transaction Line Character 33
Properties
- searchable
- sortable
- character34 (string)
The source value of the external transaction line for the Character 34 column in alphanumeric format.
Label
Transaction Line Character 34
Properties
- searchable
- sortable
- character35 (string)
The source value of the external transaction line for the Character 35 column in alphanumeric format.
Label
Transaction Line Character 35
Properties
- searchable
- sortable
- character36 (string)
The source value of the external transaction line for the Character 36 column in alphanumeric format.
Label
Transaction Line Character 36
Properties
- searchable
- sortable
- character37 (string)
The source value of the external transaction line for the Character 37 column in alphanumeric format.
Label
Transaction Line Character 37
Properties
- searchable
- sortable
- character38 (string)
The source value of the external transaction line for the Character 38 column in alphanumeric format.
Label
Transaction Line Character 38
Properties
- searchable
- sortable
- character39 (string)
The source value of the external transaction line for the Character 39 column in alphanumeric format.
Label
Transaction Line Character 39
Properties
- searchable
- sortable
- character4 (string)
The source value of the external transaction line for the Character 4 column in alphanumeric format.
Label
Transaction Line Character 4
Properties
- searchable
- sortable
- character40 (string)
The source value of the external transaction line for the Character 40 column in alphanumeric format.
Label
Transaction Line Character 40
Properties
- searchable
- sortable
- character41 (string)
The source value of the external transaction line for the Character 41 column in alphanumeric format.
Label
Transaction Line Character 41
Properties
- searchable
- sortable
- character42 (string)
The source value of the external transaction line for the Character 42 column in alphanumeric format.
Label
Transaction Line Character 42
Properties
- searchable
- sortable
- character43 (string)
The source value of the external transaction line for the Character 43 column in alphanumeric format.
Label
Transaction Line Character 43
Properties
- searchable
- sortable
- character44 (string)
The source value of the external transaction line for the Character 44 column in alphanumeric format.
Label
Transaction Line Character 44
Properties
- searchable
- sortable
- character45 (string)
The source value of the external transaction line for the Character 45 column in alphanumeric format.
Label
Transaction Line Character 45
Properties
- searchable
- sortable
- character46 (string)
The source value of the external transaction line for the Character 46 column in alphanumeric format.
Label
Transaction Line Character 46
Properties
- searchable
- sortable
- character47 (string)
The source value of the external transaction line for the Character 47 column in alphanumeric format.
Label
Transaction Line Character 47
Properties
- searchable
- sortable
- character48 (string)
The source value of the external transaction line for the Character 48 column in alphanumeric format.
Label
Transaction Line Character 48
Properties
- searchable
- sortable
- character49 (string)
The source value of the external transaction line for the Character 49 column in alphanumeric format.
Label
Transaction Line Character 49
Properties
- searchable
- sortable
- character5 (string)
The source value of the external transaction line for the Character 5 column in alphanumeric format.
Label
Transaction Line Character 5
Properties
- searchable
- sortable
- character50 (string)
The source value of the external transaction line for the Character 50 column in alphanumeric format.
Label
Transaction Line Character 50
Properties
- searchable
- sortable
- character51 (string)
The source value of the external transaction line for the Character 51 column in alphanumeric format.
Label
Transaction Line Character 51
Properties
- searchable
- sortable
- character52 (string)
The source value of the external transaction line for the Character 52 column in alphanumeric format.
Label
Transaction Line Character 52
Properties
- searchable
- sortable
- character53 (string)
The source value of the external transaction line for the Character 53 column in alphanumeric format.
Label
Transaction Line Character 53
Properties
- searchable
- sortable
- character54 (string)
The source value of the external transaction line for the Character 54 column in alphanumeric format.
Label
Transaction Line Character 54
Properties
- searchable
- sortable
- character55 (string)
The source value of the external transaction line for the Character 55 column in alphanumeric format.
Label
Transaction Line Character 55
Properties
- searchable
- sortable
- character56 (string)
The source value of the external transaction line for the Character 56 column in alphanumeric format.
Label
Transaction Line Character 56
Properties
- searchable
- sortable
- character57 (string)
The source value of the external transaction line for the Character 57 column in alphanumeric format.
Label
Transaction Line Character 57
Properties
- searchable
- sortable
- character58 (string)
The source value of the external transaction line for the Character 58 column in alphanumeric format.
Label
Transaction Line Character 58
Properties
- searchable
- sortable
- character59 (string)
The source value of the external transaction line for the Character 59 column in alphanumeric format.
Label
Transaction Line Character 59
Properties
- searchable
- sortable
- character6 (string)
The source value of the external transaction line for the Character 6 column in alphanumeric format.
Label
Transaction Line Character 6
Properties
- searchable
- sortable
- character60 (string)
The source value of the external transaction line for the Character 60 column in alphanumeric format.
Label
Transaction Line Character 60
Properties
- searchable
- sortable
- character61 (string)
The source value of the external transaction line for the Character 61 column in alphanumeric format.
Label
Transaction Line Character 61
Properties
- searchable
- sortable
- character62 (string)
The source value of the external transaction line for the Character 62 column in alphanumeric format.
Label
Transaction Line Character 62
Properties
- searchable
- sortable
- character63 (string)
The source value of the external transaction line for the Character 63 column in alphanumeric format.
Label
Transaction Line Character 63
Properties
- searchable
- sortable
- character64 (string)
The source value of the external transaction line for the Character 64 column in alphanumeric format.
Label
Transaction Line Character 64
Properties
- searchable
- sortable
- character65 (string)
The source value of the external transaction line for the Character 65 column in alphanumeric format.
Label
Transaction Line Character 65
Properties
- searchable
- sortable
- character66 (string)
The source value of the external transaction line for the Character 66 column in alphanumeric format.
Label
Transaction Line Character 66
Properties
- searchable
- sortable
- character67 (string)
The source value of the external transaction line for the Character 67 column in alphanumeric format.
Label
Transaction Line Character 67
Properties
- searchable
- sortable
- character68 (string)
The source value of the external transaction line for the Character 68 column in alphanumeric format.
Label
Transaction Line Character 68
Properties
- searchable
- sortable
- character69 (string)
The source value of the external transaction line for the Character 69 column in alphanumeric format.
Label
Transaction Line Character 69
Properties
- searchable
- sortable
- character7 (string)
The source value of the external transaction line for the Character 7 column in alphanumeric format.
Label
Transaction Line Character 7
Properties
- searchable
- sortable
- character70 (string)
The source value of the external transaction line for the Character 70 column in alphanumeric format.
Label
Transaction Line Character 70
Properties
- searchable
- sortable
- character71 (string)
The source value of the external transaction line for the Character 71 column in alphanumeric format.
Label
Transaction Line Character 71
Properties
- searchable
- sortable
- character72 (string)
The source value of the external transaction line for the Character 72 column in alphanumeric format.
Label
Transaction Line Character 72
Properties
- searchable
- sortable
- character73 (string)
The source value of the external transaction line for the Character 73 column in alphanumeric format.
Label
Transaction Line Character 73
Properties
- searchable
- sortable
- character74 (string)
The source value of the external transaction line for the Character 74 column in alphanumeric format.
Label
Transaction Line Character 74
Properties
- searchable
- sortable
- character75 (string)
The source value of the external transaction line for the Character 75 column in alphanumeric format.
Label
Transaction Line Character 75
Properties
- searchable
- sortable
- character76 (string)
The source value of the external transaction line for the Character 76 column in alphanumeric format.
Label
Transaction Line Character 76
Properties
- searchable
- sortable
- character77 (string)
The source value of the external transaction line for the Character 77 column in alphanumeric format.
Label
Transaction Line Character 77
Properties
- searchable
- sortable
- character78 (string)
The source value of the external transaction line for the Character 78 column in alphanumeric format.
Label
Transaction Line Character 78
Properties
- searchable
- sortable
- character79 (string)
The source value of the external transaction line for the Character 79 column in alphanumeric format.
Label
Transaction Line Character 79
Properties
- searchable
- sortable
- character8 (string)
The source value of the external transaction line for the Character 8 column in alphanumeric format.
Label
Transaction Line Character 8
Properties
- searchable
- sortable
- character80 (string)
The source value of the external transaction line for the Character 80 column in alphanumeric format.
Label
Transaction Line Character 80
Properties
- searchable
- sortable
- character81 (string)
The source value of the external transaction line for the Character 81 column in alphanumeric format.
Label
Transaction Line Character 81
Properties
- searchable
- sortable
- character82 (string)
The source value of the external transaction line for the Character 82 column in alphanumeric format.
Label
Transaction Line Character 82
Properties
- searchable
- sortable
- character83 (string)
The source value of the external transaction line for the Character 83 column in alphanumeric format.
Label
Transaction Line Character 83
Properties
- searchable
- sortable
- character84 (string)
The source value of the external transaction line for the Character 84 column in alphanumeric format.
Label
Transaction Line Character 84
Properties
- searchable
- sortable
- character85 (string)
The source value of the external transaction line for the Character 85 column in alphanumeric format.
Label
Transaction Line Character 85
Properties
- searchable
- sortable
- character86 (string)
The source value of the external transaction line for the Character 86 column in alphanumeric format.
Label
Transaction Line Character 86
Properties
- searchable
- sortable
- character87 (string)
The source value of the external transaction line for the Character 87 column in alphanumeric format.
Label
Transaction Line Character 87
Properties
- searchable
- sortable
- character88 (string)
The source value of the external transaction line for the Character 88 column in alphanumeric format.
Label
Transaction Line Character 88
Properties
- searchable
- sortable
- character89 (string)
The source value of the external transaction line for the Character 89 column in alphanumeric format.
Label
Transaction Line Character 89
Properties
- searchable
- sortable
- character9 (string)
The source value of the external transaction line for the Character 9 column in alphanumeric format.
Label
Transaction Line Character 9
Properties
- searchable
- sortable
- character90 (string)
The source value of the external transaction line for the Character 90 column in alphanumeric format.
Label
Transaction Line Character 90
Properties
- searchable
- sortable
- character91 (string)
The source value of the external transaction line for the Character 91 column in alphanumeric format.
Label
Transaction Line Character 91
Properties
- searchable
- sortable
- character92 (string)
The source value of the external transaction line for the Character 92 column in alphanumeric format.
Label
Transaction Line Character 92
Properties
- searchable
- sortable
- character93 (string)
The source value of the external transaction line for the Character 93 column in alphanumeric format.
Label
Transaction Line Character 93
Properties
- searchable
- sortable
- character94 (string)
The source value of the external transaction line for the Character 94 column in alphanumeric format.
Label
Transaction Line Character 94
Properties
- searchable
- sortable
- character95 (string)
The source value of the external transaction line for the Character 95 column in alphanumeric format.
Label
Transaction Line Character 95
Properties
- searchable
- sortable
- character96 (string)
The source value of the external transaction line for the Character 96 column in alphanumeric format.
Label
Transaction Line Character 96
Properties
- searchable
- sortable
- character97 (string)
The source value of the external transaction line for the Character 97 column in alphanumeric format.
Label
Transaction Line Character 97
Properties
- searchable
- sortable
- character98 (string)
The source value of the external transaction line for the Character 98 column in alphanumeric format.
Label
Transaction Line Character 98
Properties
- searchable
- sortable
- character99 (string)
The source value of the external transaction line for the Character 99 column in alphanumeric format.
Label
Transaction Line Character 99
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 line for the Date 1 column in date and time format.
Label
Transaction Line Date 1
Properties
- searchable
- sortable
- date10 (date)
The source value of the external transaction line for the Date 10 column in date and time format.
Label
Transaction Line Date 10
Properties
- searchable
- sortable
- date2 (date)
The source value of the external transaction line for the Date 2 column in date and time format.
Label
Transaction Line Date 2
Properties
- searchable
- sortable
- date3 (date)
The source value of the external transaction line for the Date 3 column in date and time format.
Label
Transaction Line Date 3
Properties
- searchable
- sortable
- date4 (date)
The source value of the external transaction line for the Date 4 column in date and time format.
Label
Transaction Line Date 4
Properties
- searchable
- sortable
- date5 (date)
The source value of the external transaction line for the Date 5 column in date and time format.
Label
Transaction Line Date 5
Properties
- searchable
- sortable
- date6 (date)
The source value of the external transaction line for the Date 6 column in date and time format.
Label
Transaction Line Date 6
Properties
- searchable
- sortable
- date7 (date)
The source value of the external transaction line for the Date 7 column in date and time format.
Label
Transaction Line Date 7
Properties
- searchable
- sortable
- date8 (date)
The source value of the external transaction line for the Date 8 column in date and time format.
Label
Transaction Line Date 8
Properties
- searchable
- sortable
- date9 (date)
The source value of the external transaction line for the Date 9 column in date and time format.
Label
Transaction Line 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
- lineNumber (int64)
The unique identifier of a line in a transaction.
Label
Line Number
Properties
- searchable
- sortable
- not nullable
- longCharacter1 (string)
The source value of the external transaction line for the Long Character 1 column in alphanumeric format.
Label
Transaction Line Long Character 1
Properties
- searchable
- sortable
- longCharacter2 (string)
The source value of the external transaction line for the Long Character 2 column in alphanumeric format.
Label
Transaction Line Long Character 2
Properties
- searchable
- sortable
- longCharacter3 (string)
The source value of the external transaction line for the Long Character 3 column in alphanumeric format.
Label
Transaction Line Long Character 3
Properties
- searchable
- sortable
- longCharacter4 (string)
The source value of the external transaction line for the Long Character 4 column in alphanumeric format.
Label
Transaction Line Long Character 4
Properties
- searchable
- sortable
- longCharacter5 (string)
The source value of the external transaction line for the Long Character 5 column in alphanumeric format.
Label
Transaction Line Long Character 5
Properties
- searchable
- sortable
- number1 (int64)
The source value of the external transaction line for the Number 1 column in numeric format.
Label
Transaction Line Number 1
Properties
- searchable
- sortable
- number10 (int64)
The source value of the external transaction line for the Number 10 column in numeric format.
Label
Transaction Line Number 10
Properties
- searchable
- sortable
- number11 (int64)
The source value of the external transaction line for the Number 11 column in numeric format.
Label
Transaction Line Number 11
Properties
- searchable
- sortable
- number12 (int64)
The source value of the external transaction line for the Number 12 column in numeric format.
Label
Transaction Line Number 12
Properties
- searchable
- sortable
- number13 (int64)
The source value of the external transaction line for the Number 13 column in numeric format.
Label
Transaction Line Number 13
Properties
- searchable
- sortable
- number14 (int64)
The source value of the external transaction line for the Number 14 column in numeric format.
Label
Transaction Line Number 14
Properties
- searchable
- sortable
- number15 (int64)
The source value of the external transaction line for the Number 15 column in numeric format.
Label
Transaction Line Number 15
Properties
- searchable
- sortable
- number16 (int64)
The source value of the external transaction line for the Number 16 column in numeric format.
Label
Transaction Line Number 16
Properties
- searchable
- sortable
- number17 (int64)
The source value of the external transaction line for the Number 17 column in numeric format.
Label
Transaction Line Number 17
Properties
- searchable
- sortable
- number18 (int64)
The source value of the external transaction line for the Number 18 column in numeric format.
Label
Transaction Line Number 18
Properties
- searchable
- sortable
- number19 (int64)
The source value of the external transaction line for the Number 19 column in numeric format.
Label
Transaction Line Number 19
Properties
- searchable
- sortable
- number2 (int64)
The source value of the external transaction line for the Number 2 column in numeric format.
Label
Transaction Line Number 2
Properties
- searchable
- sortable
- number20 (int64)
The source value of the external transaction line for the Number 20 column in numeric format.
Label
Transaction Line Number 20
Properties
- searchable
- sortable
- number21 (int64)
The source value of the external transaction line for the Number 21 column in numeric format.
Label
Transaction Line Number 21
Properties
- searchable
- sortable
- number22 (int64)
The source value of the external transaction line for the Number 22 column in numeric format.
Label
Transaction Line Number 22
Properties
- searchable
- sortable
- number23 (int64)
The source value of the external transaction line for the Number 23 column in numeric format.
Label
Transaction Line Number 23
Properties
- searchable
- sortable
- number24 (int64)
The source value of the external transaction line for the Number 24 column in numeric format.
Label
Transaction Line Number 24
Properties
- searchable
- sortable
- number25 (int64)
The source value of the external transaction line for the Number 25 column in numeric format.
Label
Transaction Line Number 25
Properties
- searchable
- sortable
- number26 (int64)
The source value of the external transaction line for the Number 26 column in numeric format.
Label
Transaction Line Number 26
Properties
- searchable
- sortable
- number27 (int64)
The source value of the external transaction line for the Number 27 column in numeric format.
Label
Transaction Line Number 27
Properties
- searchable
- sortable
- number28 (int64)
The source value of the external transaction line for the Number 28 column in numeric format.
Label
Transaction Line Number 28
Properties
- searchable
- sortable
- number29 (int64)
The source value of the external transaction line for the Number 29 column in numeric format.
Label
Transaction Line Number 29
Properties
- searchable
- sortable
- number3 (int64)
The source value of the external transaction line for the Number 3 column in numeric format.
Label
Transaction Line Number 3
Properties
- searchable
- sortable
- number30 (int64)
The source value of the external transaction line for the Number 30 column in numeric format.
Label
Transaction Line Number 30
Properties
- searchable
- sortable
- number4 (int64)
The source value of the external transaction line for the Number 4 column in numeric format.
Label
Transaction Line Number 4
Properties
- searchable
- sortable
- number5 (int64)
The source value of the external transaction line for the Number 5 column in numeric format.
Label
Transaction Line Number 5
Properties
- searchable
- sortable
- number6 (int64)
The source value of the external transaction line for the Number 6 column in numeric format.
Label
Transaction Line Number 6
Properties
- searchable
- sortable
- number7 (int64)
The source value of the external transaction line for the Number 7 column in numeric format.
Label
Transaction Line Number 7
Properties
- searchable
- sortable
- number8 (int64)
The source value of the external transaction line for the Number 8 column in numeric format.
Label
Transaction Line Number 8
Properties
- searchable
- sortable
- number9 (int64)
The source value of the external transaction line for the Number 9 column in numeric format.
Label
Transaction Line 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
- updatedBy (string)
The user who last updated the record.
Label
Last Updated By
Properties
- searchable
- sortable
- not nullable
- applicationId (int64)